PREVIEW / etf_1hour / 2008-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-22.parquet
  size:    114 KB
  rows:    3,689

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-09-22 05:00:00	SPY	ETF	123.72	123.72	123.72	123.72	2500.0
2008-09-22 06:00:00	SPY	ETF	123.64	123.64	123.35	123.6	49700.0
2008-09-22 07:00:00	SPY	ETF	123.74	123.8	123.48	123.69	369525.0
2008-09-22 08:00:00	SPY	ETF	123.68	125.0	122.4	124.05	4204715.0
2008-09-22 09:00:00	SPY	ETF	124.05	124.76	123.39	123.66	25562210.0
2008-09-22 10:00:00	SPY	ETF	123.66	123.85	122.96	123.6	32679781.0
2008-09-22 11:00:00	SPY	ETF	123.6	123.64	122.33	122.74	27135622.0
2008-09-22 12:00:00	SPY	ETF	122.74	123.73	122.41	123.1	16550082.0
2008-09-22 13:00:00	SPY	ETF	123.09	123.19	121.94	122.69	31567763.0
2008-09-22 14:00:00	SPY	ETF	122.69	123.05	121.93	122.06	32638766.0
2008-09-22 15:00:00	SPY	ETF	122.06	122.5	120.36	120.6	57856933.0
2008-09-22 16:00:00	SPY	ETF	120.71	125.3426	120.54	121.3	10595787.0
2008-09-22 17:00:00	SPY	ETF	121.28	124.2	121.28	121.37	1135150.0
2008-09-22 18:00:00	SPY	ETF	121.35	125.3426	121.27	121.32	2551815.0
2008-09-22 19:00:00	SPY	ETF	121.33	121.38	121.16	121.29	14723.0
2008-09-22 05:00:00	QQQ	ETF	42.49	42.49	42.48	42.48	10000.0
2008-09-22 07:00:00	QQQ	ETF	42.5	42.51	42.37	42.4	94012.0
2008-09-22 08:00:00	QQQ	ETF	42.41	42.81	42.37	42.81	2593087.0
2008-09-22 09:00:00	QQQ	ETF	42.8	42.95	42.364	42.48	25723314.0
2008-09-22 10:00:00	QQQ	ETF	42.48	42.58	42.27	42.53	21718541.0
2008-09-22 11:00:00	QQQ	ETF	42.52	42.54	41.9	42.01	18317393.0
2008-09-22 12:00:00	QQQ	ETF	42.02	42.15	41.95	42.06	9921031.0
2008-09-22 13:00:00	QQQ	ETF	42.06	42.09	41.66	41.87	20122005.0
2008-09-22 14:00:00	QQQ	ETF	41.87	42.0178	41.58	41.62	18690078.0
2008-09-22 15:00:00	QQQ	ETF	41.62	41.7	40.9099	40.91	38165507.0
2008-09-22 16:00:00	QQQ	ETF	40.91	41.2577	40.8	41.03	5041486.0
2008-09-22 17:00:00	QQQ	ETF	41.04	41.09	40.88	41.05	160813.0
2008-09-22 18:00:00	QQQ	ETF	41.09	41.1	41.03	41.06	22655.0
2008-09-22 19:00:00	QQQ	ETF	41.01	41.07	40.99	41.07	28573.0
2008-09-22 05:00:00	IWM	ETF	74.88	74.88	74.88	74.88	2500.0
2008-09-22 07:00:00	IWM	ETF	74.83	75.0	74.77	74.97	25240.0
2008-09-22 08:00:00	IWM	ETF	74.95	75.15	74.79	74.86	896918.0
2008-09-22 09:00:00	IWM	ETF	74.86	75.65	73.98	74.28	11847998.0
2008-09-22 10:00:00	IWM	ETF	74.29	74.32	73.5	73.99	15100250.0
2008-09-22 11:00:00	IWM	ETF	73.99	74.4	73.13	73.4	10272793.0
2008-09-22 12:00:00	IWM	ETF	73.4	73.69	73.07	73.63	5803890.0
2008-09-22 13:00:00	IWM	ETF	73.63	73.67	72.48	72.96	9961613.0
2008-09-22 14:00:00	IWM	ETF	72.96	73.2	72.69	72.79	8252759.0
2008-09-22 15:00:00	IWM	ETF	72.78	73.1	70.22	71.8	24075239.0
2008-09-22 16:00:00	IWM	ETF	71.81	73.4	71.76	72.03	5775656.0
2008-09-22 17:00:00	IWM	ETF	72.03	72.14	72.03	72.1	13700.0
2008-09-22 18:00:00	IWM	ETF	72.1	72.1	72.02	72.02	5150.0
2008-09-22 19:00:00	IWM	ETF	72.04	72.06	72.02	72.02	2100.0
2008-09-22 07:00:00	DIA	ETF	112.85	112.9	112.67	112.9	11650.0
2008-09-22 08:00:00	DIA	ETF	112.85	113.51	112.72	113.39	139257.0
2008-09-22 09:00:00	DIA	ETF	113.44	114.01	112.55	112.69	2191572.0
2008-09-22 10:00:00	DIA	ETF	112.7	112.88	112.08	112.47	3481338.0
2008-09-22 11:00:00	DIA	ETF	112.45	112.49	111.48	111.91	2829469.0
2008-09-22 12:00:00	DIA	ETF	111.9	112.19	111.6	112.01	2334167.0
2008-09-22 13:00:00	DIA	ETF	112.0	112.07	111.08	111.7	2042293.0

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

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