PREVIEW / etf_1hour / 2008-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-21.parquet
  size:    112 KB
  rows:    3,585

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-07-21 04:00:00	SPY	ETF	125.68	125.84	125.68	125.81	3300.0
2008-07-21 05:00:00	SPY	ETF	125.78	125.93	125.78	125.93	600.0
2008-07-21 06:00:00	SPY	ETF	126.23	126.5	126.23	126.42	86500.0
2008-07-21 07:00:00	SPY	ETF	126.39	126.87	126.35	126.43	3148534.0
2008-07-21 08:00:00	SPY	ETF	126.42	126.76	126.0	126.7	3510333.0
2008-07-21 09:00:00	SPY	ETF	126.71	126.75	126.37	126.61	23256754.0
2008-07-21 10:00:00	SPY	ETF	126.61	126.8	126.1	126.3	36076436.0
2008-07-21 11:00:00	SPY	ETF	126.3	126.47	125.69	125.7025	25325063.0
2008-07-21 12:00:00	SPY	ETF	125.71	126.27	125.62	125.99	23177498.0
2008-07-21 13:00:00	SPY	ETF	125.99	126.38	125.97	126.07	17328379.0
2008-07-21 14:00:00	SPY	ETF	126.09	126.2	125.7	125.78	30549631.0
2008-07-21 15:00:00	SPY	ETF	125.78	126.0679	125.54	126.0	31466779.0
2008-07-21 16:00:00	SPY	ETF	126.03	126.74	124.98	125.0	22394848.0
2008-07-21 17:00:00	SPY	ETF	125.0	125.07	124.39	124.73	823924.0
2008-07-21 18:00:00	SPY	ETF	124.75	124.94	124.74	124.89	321769.0
2008-07-21 19:00:00	SPY	ETF	124.89	125.0	124.85	125.0	44223.0
2008-07-21 04:00:00	QQQ	ETF	44.73	44.8	44.73	44.8	1100.0
2008-07-21 05:00:00	QQQ	ETF	44.86	45.03	44.83	45.03	5100.0
2008-07-21 06:00:00	QQQ	ETF	45.02	45.1	45.02	45.07	3600.0
2008-07-21 07:00:00	QQQ	ETF	45.09	45.23	45.03	45.03	73324.0
2008-07-21 08:00:00	QQQ	ETF	45.04	45.12	44.97	45.12	1274569.0
2008-07-21 09:00:00	QQQ	ETF	45.11	45.16	44.96	45.12	14944899.0
2008-07-21 10:00:00	QQQ	ETF	45.12	45.19	44.84	44.89	18657267.0
2008-07-21 11:00:00	QQQ	ETF	44.898	44.96	44.5	44.53	13616225.0
2008-07-21 12:00:00	QQQ	ETF	44.53	44.71	44.49	44.59	15185143.0
2008-07-21 13:00:00	QQQ	ETF	44.58	44.87	44.55	44.74	9576823.0
2008-07-21 14:00:00	QQQ	ETF	44.75	44.8	44.57	44.66	9082321.0
2008-07-21 15:00:00	QQQ	ETF	44.66	44.81	44.58	44.78	20145970.0
2008-07-21 16:00:00	QQQ	ETF	44.78	44.93	44.16	44.21	11363287.0
2008-07-21 17:00:00	QQQ	ETF	44.21	44.8	43.88	43.94	8632921.0
2008-07-21 18:00:00	QQQ	ETF	43.97	44.04	43.92	44.0	578489.0
2008-07-21 19:00:00	QQQ	ETF	44.0	44.09	43.98	44.09	96636.0
2008-07-21 07:00:00	IWM	ETF	69.31	69.39	69.19	69.22	156316.0
2008-07-21 08:00:00	IWM	ETF	69.36	69.39	69.16	69.35	395937.0
2008-07-21 09:00:00	IWM	ETF	69.36	69.53	69.19	69.48	7135160.0
2008-07-21 10:00:00	IWM	ETF	69.47	69.61	69.05	69.29	10668629.0
2008-07-21 11:00:00	IWM	ETF	69.29	69.51	69.01	69.02	6980887.0
2008-07-21 12:00:00	IWM	ETF	69.02	69.35	68.98	69.22	4861529.0
2008-07-21 13:00:00	IWM	ETF	69.22	69.6	69.2	69.47	3849136.0
2008-07-21 14:00:00	IWM	ETF	69.48	69.52	69.23	69.34	14023742.0
2008-07-21 15:00:00	IWM	ETF	69.35	69.75	69.28	69.58	12566430.0
2008-07-21 16:00:00	IWM	ETF	69.56	69.78	69.01	69.02	6628802.0
2008-07-21 17:00:00	IWM	ETF	69.04	69.08	68.71	68.86	145426.0
2008-07-21 18:00:00	IWM	ETF	68.87	69.05	68.86	69.05	49200.0
2008-07-21 19:00:00	IWM	ETF	69.0	69.07	69.0	69.07	4638.0
2008-07-21 06:00:00	DIA	ETF	115.27	115.27	115.27	115.27	100.0
2008-07-21 07:00:00	DIA	ETF	115.43	115.65	115.25	115.25	14188.0
2008-07-21 08:00:00	DIA	ETF	115.31	115.49	115.25	115.45	133190.0
2008-07-21 09:00:00	DIA	ETF	115.46	115.51	115.15	115.24	2792192.0
2008-07-21 10:00:00	DIA	ETF	115.24	115.38	114.76	114.94	3022721.0

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

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