PREVIEW / etf_1hour / 2005-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-09.parquet
  size:    30 KB
  rows:    935

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2005-08-09 05:00:00	SPY	ETF	122.83	122.83	122.83	122.83	5100.0
2005-08-09 07:00:00	SPY	ETF	122.87	122.87	122.85	122.85	6000.0
2005-08-09 08:00:00	SPY	ETF	122.84	123.08	122.83	123.06	632400.0
2005-08-09 09:00:00	SPY	ETF	123.06	123.18	123.01	123.1505	6491000.0
2005-08-09 10:00:00	SPY	ETF	123.15	123.27	123.02	123.21	6719100.0
2005-08-09 11:00:00	SPY	ETF	123.22	123.33	123.15	123.27	2933500.0
2005-08-09 12:00:00	SPY	ETF	123.27	123.32	123.19	123.22	1686300.0
2005-08-09 13:00:00	SPY	ETF	123.22	123.27	123.09	123.26	3333100.0
2005-08-09 14:00:00	SPY	ETF	123.24	123.59	123.15	123.25	13534100.0
2005-08-09 15:00:00	SPY	ETF	123.27	123.35	122.87	123.34	10051100.0
2005-08-09 16:00:00	SPY	ETF	123.37	123.42	123.35	123.37	430600.0
2005-08-09 17:00:00	SPY	ETF	123.37	123.39	123.17	123.25	82200.0
2005-08-09 18:00:00	SPY	ETF	123.27	123.48	123.27	123.36	233500.0
2005-08-09 19:00:00	SPY	ETF	123.36	123.36	123.34	123.34	1200.0
2005-08-09 09:00:00	QQQ	ETF	39.37	39.42	39.34	39.42	6845100.0
2005-08-09 10:00:00	QQQ	ETF	39.42	39.5	39.38	39.46	10070400.0
2005-08-09 11:00:00	QQQ	ETF	39.47	39.51	39.42	39.46	6110400.0
2005-08-09 12:00:00	QQQ	ETF	39.46	39.49	39.44	39.46	3004000.0
2005-08-09 13:00:00	QQQ	ETF	39.46	39.48	39.4	39.47	3479800.0
2005-08-09 14:00:00	QQQ	ETF	39.46	39.59	39.44	39.48	13158600.0
2005-08-09 15:00:00	QQQ	ETF	39.49	39.51	39.31	39.44	14360300.0
2005-08-09 08:00:00	IWM	ETF	65.9	66.01	65.9	66.0	18500.0
2005-08-09 09:00:00	IWM	ETF	65.97	66.0	65.78	65.89	2196300.0
2005-08-09 10:00:00	IWM	ETF	65.89	66.07	65.8	66.02	3832400.0
2005-08-09 11:00:00	IWM	ETF	66.02	66.06	65.87	65.88	2109200.0
2005-08-09 12:00:00	IWM	ETF	65.88	65.9	65.79	65.8	1424400.0
2005-08-09 13:00:00	IWM	ETF	65.8	65.82	65.66	65.81	1424200.0
2005-08-09 14:00:00	IWM	ETF	65.81	66.07	65.7	65.77	4661100.0
2005-08-09 15:00:00	IWM	ETF	65.78	65.83	65.45	65.79	4873400.0
2005-08-09 16:00:00	IWM	ETF	65.8	66.14	65.74	65.87	232200.0
2005-08-09 17:00:00	IWM	ETF	65.84	65.84	65.74	65.74	20100.0
2005-08-09 18:00:00	IWM	ETF	65.74	65.75	65.74	65.75	50100.0
2005-08-09 08:00:00	DIA	ETF	105.78	105.92	105.78	105.92	4100.0
2005-08-09 09:00:00	DIA	ETF	105.88	106.06	105.82	105.99	909700.0
2005-08-09 10:00:00	DIA	ETF	105.97	106.1	105.91	106.06	756600.0
2005-08-09 11:00:00	DIA	ETF	106.07	106.16	106.03	106.11	394600.0
2005-08-09 12:00:00	DIA	ETF	106.1	106.16	106.08	106.08	227300.0
2005-08-09 13:00:00	DIA	ETF	106.08	106.12	106.0	106.1	729600.0
2005-08-09 14:00:00	DIA	ETF	106.1	106.43	106.01	106.18	1319400.0
2005-08-09 15:00:00	DIA	ETF	106.17	106.4	105.83	106.18	802300.0
2005-08-09 16:00:00	DIA	ETF	106.18	106.33	106.18	106.28	10300.0
2005-08-09 17:00:00	DIA	ETF	106.22	106.22	106.19	106.19	300.0
2005-08-09 18:00:00	DIA	ETF	106.19	106.25	106.19	106.23	2400.0
2005-08-09 09:00:00	GLD	ETF	43.27	43.27	43.166	43.19	256900.0
2005-08-09 10:00:00	GLD	ETF	43.2	43.25	43.18	43.23	76400.0
2005-08-09 11:00:00	GLD	ETF	43.22	43.3	43.21	43.26	82800.0
2005-08-09 12:00:00	GLD	ETF	43.25	43.3	43.22	43.3	540900.0
2005-08-09 13:00:00	GLD	ETF	43.32	43.34	43.28	43.31	54300.0
2005-08-09 14:00:00	GLD	ETF	43.29	43.35	43.28	43.33	245300.0
2005-08-09 15:00:00	GLD	ETF	43.33	43.34	43.31	43.34	41800.0

> showing 50 of 935 rows — these rows as CSV

> unlock the full archive -- $79 one-time