PREVIEW / etf_1hour / 2008-06-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-24.parquet
  size:    107 KB
  rows:    3,444

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-06-24 04:00:00	SPY	ETF	131.58	131.58	131.53	131.53	3000.0
2008-06-24 05:00:00	SPY	ETF	131.1	131.1	130.45	130.86	45000.0
2008-06-24 06:00:00	SPY	ETF	130.81	130.89	130.69	130.82	40700.0
2008-06-24 07:00:00	SPY	ETF	130.8	130.82	130.52	130.74	1515738.0
2008-06-24 08:00:00	SPY	ETF	130.72	131.48	130.61	130.82	4032551.0
2008-06-24 09:00:00	SPY	ETF	130.87	131.34	130.5	130.61	29492692.0
2008-06-24 10:00:00	SPY	ETF	130.62	131.3	130.19	131.27	53296267.0
2008-06-24 11:00:00	SPY	ETF	131.27	132.07	131.22	131.92	48777705.0
2008-06-24 12:00:00	SPY	ETF	131.92	132.38	131.8	131.978	27187074.0
2008-06-24 13:00:00	SPY	ETF	131.97	132.23	131.76	132.09	22038032.0
2008-06-24 14:00:00	SPY	ETF	132.09	132.44	131.47	131.665	24649079.0
2008-06-24 15:00:00	SPY	ETF	131.67	131.79	130.97	131.24	46715295.0
2008-06-24 16:00:00	SPY	ETF	131.1999	131.6398	130.25	131.2	7101863.0
2008-06-24 17:00:00	SPY	ETF	131.25	131.29	131.17	131.21	52852.0
2008-06-24 18:00:00	SPY	ETF	131.22	131.29	131.22	131.22	28060.0
2008-06-24 19:00:00	SPY	ETF	131.27	131.27	131.24	131.24	12000.0
2008-06-24 05:00:00	QQQ	ETF	46.8	46.8	46.5	46.59	139000.0
2008-06-24 06:00:00	QQQ	ETF	46.6	46.69	46.6	46.64	321700.0
2008-06-24 07:00:00	QQQ	ETF	46.64	46.64	46.52	46.6	526159.0
2008-06-24 08:00:00	QQQ	ETF	46.6	46.67	46.56	46.67	2937532.0
2008-06-24 09:00:00	QQQ	ETF	46.68	46.995	46.66	46.7	19735118.0
2008-06-24 10:00:00	QQQ	ETF	46.66	46.89	46.41	46.84	34530657.0
2008-06-24 11:00:00	QQQ	ETF	46.84	47.26	46.74	47.17	34559950.0
2008-06-24 12:00:00	QQQ	ETF	47.17	47.23	47.03	47.09	12250521.0
2008-06-24 13:00:00	QQQ	ETF	47.09	47.29	47.06	47.25	11768972.0
2008-06-24 14:00:00	QQQ	ETF	47.25	47.37	46.86	46.97	20561782.0
2008-06-24 15:00:00	QQQ	ETF	46.97	47.07	46.68	46.81	21913282.0
2008-06-24 16:00:00	QQQ	ETF	46.81	46.9063	46.74	46.85	5216979.0
2008-06-24 17:00:00	QQQ	ETF	46.85	46.85	46.8	46.84	42490.0
2008-06-24 18:00:00	QQQ	ETF	46.85	46.86	46.85	46.85	3020.0
2008-06-24 19:00:00	QQQ	ETF	46.85	46.86	46.84	46.84	13500.0
2008-06-24 05:00:00	IWM	ETF	71.2	71.28	71.2	71.28	8000.0
2008-06-24 07:00:00	IWM	ETF	71.22	71.27	71.1	71.24	356500.0
2008-06-24 08:00:00	IWM	ETF	71.24	71.34	71.12	71.25	1380229.0
2008-06-24 09:00:00	IWM	ETF	71.29	71.68	70.86	70.97	17269142.0
2008-06-24 10:00:00	IWM	ETF	70.94	71.21	70.61	71.18	23268755.0
2008-06-24 11:00:00	IWM	ETF	71.18	71.85	71.13	71.8	18889952.0
2008-06-24 12:00:00	IWM	ETF	71.81	71.89	71.55	71.58	7475295.0
2008-06-24 13:00:00	IWM	ETF	71.59	71.69	71.29	71.55	6296352.0
2008-06-24 14:00:00	IWM	ETF	71.55	71.78	71.15	71.26	8643872.0
2008-06-24 15:00:00	IWM	ETF	71.27	71.38	70.73	70.73	15894684.0
2008-06-24 16:00:00	IWM	ETF	70.73	71.96	70.61	70.66	3347914.0
2008-06-24 17:00:00	IWM	ETF	70.68	71.96	70.6	70.61	436803.0
2008-06-24 18:00:00	IWM	ETF	70.7	70.7	70.7	70.7	100.0
2008-06-24 19:00:00	IWM	ETF	70.75	70.75	70.7	70.7	413.0
2008-06-24 05:00:00	DIA	ETF	118.0	118.0	117.5	117.5	300.0
2008-06-24 07:00:00	DIA	ETF	117.6	117.66	117.47	117.64	5400.0
2008-06-24 08:00:00	DIA	ETF	117.64	117.85	117.55	117.79	49291.0
2008-06-24 09:00:00	DIA	ETF	117.86	118.18	117.45	117.47	1987691.0
2008-06-24 10:00:00	DIA	ETF	117.47	118.07	117.16	118.03	3928565.0

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

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