PREVIEW / etf_1hour / 2009-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-08.parquet
  size:    142 KB
  rows:    4,420

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
2009-09-08 04:00:00	SPY	ETF	103.05	103.16	102.89	102.89	5222.0
2009-09-08 05:00:00	SPY	ETF	102.9	103.04	102.9	103.0	41400.0
2009-09-08 06:00:00	SPY	ETF	102.88	102.95	102.8	102.8	20100.0
2009-09-08 07:00:00	SPY	ETF	102.86	103.05	102.85	103.01	504970.0
2009-09-08 08:00:00	SPY	ETF	103.0	103.13	102.2	102.92	1507881.0
2009-09-08 09:00:00	SPY	ETF	102.92	103.05	102.53	102.63	26754501.0
2009-09-08 10:00:00	SPY	ETF	102.63	103.02	102.39	102.98	24426145.0
2009-09-08 11:00:00	SPY	ETF	102.98	103.03	102.54	102.6625	15315565.0
2009-09-08 12:00:00	SPY	ETF	102.67	102.83	102.59	102.72	6300324.0
2009-09-08 13:00:00	SPY	ETF	102.72	102.81	102.51	102.71	8501250.0
2009-09-08 14:00:00	SPY	ETF	102.719	102.99	102.6	102.89	12897925.0
2009-09-08 15:00:00	SPY	ETF	102.88	103.01	102.7012	102.9	25024374.0
2009-09-08 16:00:00	SPY	ETF	102.89	103.0	102.0762	102.74	10121382.0
2009-09-08 17:00:00	SPY	ETF	102.74	102.82	102.7	102.79	134503.0
2009-09-08 18:00:00	SPY	ETF	102.79	102.89	102.74	102.79	53772.0
2009-09-08 19:00:00	SPY	ETF	102.81	102.9	102.8	102.85	67319.0
2009-09-08 04:00:00	QQQ	ETF	40.65	40.73	40.65	40.73	1319.0
2009-09-08 05:00:00	QQQ	ETF	40.73	40.73	40.68	40.68	3000.0
2009-09-08 06:00:00	QQQ	ETF	40.66	40.67	40.66	40.67	900.0
2009-09-08 07:00:00	QQQ	ETF	40.65	40.73	40.65	40.69	226320.0
2009-09-08 08:00:00	QQQ	ETF	40.67	40.78	40.56	40.64	337885.0
2009-09-08 09:00:00	QQQ	ETF	40.65	40.78	40.5	40.55	12798665.0
2009-09-08 10:00:00	QQQ	ETF	40.552	40.71	40.48	40.69	15312149.0
2009-09-08 11:00:00	QQQ	ETF	40.68	40.72	40.5	40.55	7514306.0
2009-09-08 12:00:00	QQQ	ETF	40.54	40.61	40.52	40.57	2715444.0
2009-09-08 13:00:00	QQQ	ETF	40.56	40.6	40.46	40.5599	3993979.0
2009-09-08 14:00:00	QQQ	ETF	40.5595	40.69	40.49	40.63	4748400.0
2009-09-08 15:00:00	QQQ	ETF	40.64	40.75	40.58	40.74	11113685.0
2009-09-08 16:00:00	QQQ	ETF	40.74	40.76	40.66	40.69	6172562.0
2009-09-08 17:00:00	QQQ	ETF	40.69	40.7	40.67	40.7	45757.0
2009-09-08 18:00:00	QQQ	ETF	40.7	40.75	40.68	40.68	23616.0
2009-09-08 19:00:00	QQQ	ETF	40.68	40.71	40.67	40.71	11762.0
2009-09-08 07:00:00	IWM	ETF	57.62	57.7	57.57	57.66	54779.0
2009-09-08 08:00:00	IWM	ETF	57.63	57.66	57.28	57.61	263433.0
2009-09-08 09:00:00	IWM	ETF	57.61	57.73	57.16	57.24	4905264.0
2009-09-08 10:00:00	IWM	ETF	57.23	57.64	57.0	57.6	8258944.0
2009-09-08 11:00:00	IWM	ETF	57.6	57.66	57.33	57.43	2673570.0
2009-09-08 12:00:00	IWM	ETF	57.43	57.52	57.3601	57.39	788310.0
2009-09-08 13:00:00	IWM	ETF	57.38	57.48	57.23	57.4	2902932.0
2009-09-08 14:00:00	IWM	ETF	57.39	57.64	57.27	57.57	3209047.0
2009-09-08 15:00:00	IWM	ETF	57.57	57.68	57.45	57.66	6084790.0
2009-09-08 16:00:00	IWM	ETF	57.65	57.72	57.6265	57.63	8211110.0
2009-09-08 17:00:00	IWM	ETF	57.58	57.62	57.58	57.6	3409.0
2009-09-08 18:00:00	IWM	ETF	57.57	57.6	57.57	57.6	4010.0
2009-09-08 19:00:00	IWM	ETF	57.59	57.62	57.58	57.6	4100.0
2009-09-08 06:00:00	DIA	ETF	95.22	95.22	95.22	95.22	100.0
2009-09-08 07:00:00	DIA	ETF	95.15	95.26	95.15	95.18	6350.0
2009-09-08 08:00:00	DIA	ETF	95.19	95.19	95.06	95.12	33594.0
2009-09-08 09:00:00	DIA	ETF	95.12	95.22	94.76	94.78	1521226.0
2009-09-08 10:00:00	DIA	ETF	94.78	95.15	94.62	95.14	1858343.0

> showing 50 of 4,420 rows — these rows as CSV

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