PREVIEW / etf_1hour / 2008-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-03.parquet
  size:    94 KB
  rows:    3,139

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
2008-01-03 05:00:00	SPY	ETF	144.73	144.73	144.71	144.71	3000.0
2008-01-03 06:00:00	SPY	ETF	144.65	144.65	144.58	144.59	45000.0
2008-01-03 07:00:00	SPY	ETF	144.6	145.13	144.6	144.73	343700.0
2008-01-03 08:00:00	SPY	ETF	144.75	145.41	144.6	145.18	3788100.0
2008-01-03 09:00:00	SPY	ETF	145.17	145.23	144.51	144.8	17665664.0
2008-01-03 10:00:00	SPY	ETF	144.8	145.41	144.6	144.79	25627171.0
2008-01-03 11:00:00	SPY	ETF	144.79	145.32	144.77	145.13	12298006.0
2008-01-03 12:00:00	SPY	ETF	145.14	145.49	145.03	145.19	12114667.0
2008-01-03 13:00:00	SPY	ETF	145.19	145.19	144.75	144.8	9114099.0
2008-01-03 14:00:00	SPY	ETF	144.8	145.49	144.61	144.78	12720489.0
2008-01-03 15:00:00	SPY	ETF	144.78	144.82	144.12	144.46	22582862.0
2008-01-03 16:00:00	SPY	ETF	144.49	145.18	144.49	144.87	7008000.0
2008-01-03 17:00:00	SPY	ETF	144.86	144.87	144.79	144.86	111600.0
2008-01-03 18:00:00	SPY	ETF	144.87	144.92	144.83	144.92	61800.0
2008-01-03 19:00:00	SPY	ETF	144.91	144.91	144.61	144.61	25300.0
2008-01-03 06:00:00	QQQ	ETF	50.28	50.31	50.27	50.31	27100.0
2008-01-03 07:00:00	QQQ	ETF	50.31	50.47	50.29	50.31	363567.0
2008-01-03 08:00:00	QQQ	ETF	50.33	50.59	50.27	50.5	1669121.0
2008-01-03 09:00:00	QQQ	ETF	50.49	50.52	50.2	50.28	20186096.0
2008-01-03 10:00:00	QQQ	ETF	50.28	50.64	50.25	50.37	28176491.0
2008-01-03 11:00:00	QQQ	ETF	50.37	50.57	50.37	50.51	10603638.0
2008-01-03 12:00:00	QQQ	ETF	50.51	50.76	50.472	50.6	10774793.0
2008-01-03 13:00:00	QQQ	ETF	50.6	50.6199	50.43	50.4605	7936458.0
2008-01-03 14:00:00	QQQ	ETF	50.46	50.5	50.31	50.43	8468961.0
2008-01-03 15:00:00	QQQ	ETF	50.43	50.44	50.15	50.43	19722360.0
2008-01-03 16:00:00	QQQ	ETF	50.43	50.63	50.43	50.56	7227299.0
2008-01-03 17:00:00	QQQ	ETF	50.55	50.56	50.53	50.55	210692.0
2008-01-03 18:00:00	QQQ	ETF	50.56	50.62	50.56	50.62	16167.0
2008-01-03 19:00:00	QQQ	ETF	50.62	50.62	50.54	50.56	58167.0
2008-01-03 07:00:00	IWM	ETF	75.18	75.26	75.0	75.02	30000.0
2008-01-03 08:00:00	IWM	ETF	75.04	75.37	74.92	75.27	337800.0
2008-01-03 09:00:00	IWM	ETF	75.29	75.51	74.97	75.2	7528844.0
2008-01-03 10:00:00	IWM	ETF	75.2	75.62	74.85	75.03	18325638.0
2008-01-03 11:00:00	IWM	ETF	75.02	75.3	74.95	75.15	6470570.0
2008-01-03 12:00:00	IWM	ETF	75.15	75.42	74.92	75.09	6332707.0
2008-01-03 13:00:00	IWM	ETF	75.09	75.1	74.53	74.64	8368550.0
2008-01-03 14:00:00	IWM	ETF	74.64	74.8	74.44	74.69	6912353.0
2008-01-03 15:00:00	IWM	ETF	74.68	74.73	74.03	74.07	19090713.0
2008-01-03 16:00:00	IWM	ETF	74.08	74.82	74.06	74.33	4487300.0
2008-01-03 17:00:00	IWM	ETF	74.33	74.4	74.16	74.16	201400.0
2008-01-03 18:00:00	IWM	ETF	74.32	74.38	74.32	74.38	1100.0
2008-01-03 19:00:00	IWM	ETF	74.42	74.42	74.25	74.25	1000.0
2008-01-03 07:00:00	DIA	ETF	130.82	130.82	130.54	130.54	6800.0
2008-01-03 08:00:00	DIA	ETF	130.61	131.02	130.46	130.81	84000.0
2008-01-03 09:00:00	DIA	ETF	130.8	130.86	130.44	130.65	1329405.0
2008-01-03 10:00:00	DIA	ETF	130.66	131.09	130.46	130.64	1586847.0
2008-01-03 11:00:00	DIA	ETF	130.62	131.15	130.62	130.99	924305.0
2008-01-03 12:00:00	DIA	ETF	130.98	131.27	130.92	131.09	773319.0
2008-01-03 13:00:00	DIA	ETF	131.09	131.09	130.68	130.7	594800.0
2008-01-03 14:00:00	DIA	ETF	130.72	130.88	130.56	130.67	819749.0

> showing 50 of 3,139 rows — these rows as CSV

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