PREVIEW / etf_1hour / 2008-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-19.parquet
  size:    117 KB
  rows:    3,815

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-19 04:00:00	SPY	ETF	122.99	123.57	122.58	123.57	4650.0
2008-09-19 05:00:00	SPY	ETF	123.43	123.85	123.21	123.69	84400.0
2008-09-19 06:00:00	SPY	ETF	123.65	124.36	123.56	123.73	291100.0
2008-09-19 07:00:00	SPY	ETF	123.73	125.1	123.54	124.71	5870350.0
2008-09-19 08:00:00	SPY	ETF	124.7	126.88	121.2891	126.51	16104889.0
2008-09-19 09:00:00	SPY	ETF	126.52	128.09	124.6	124.73	59951670.0
2008-09-19 10:00:00	SPY	ETF	124.74	125.23	123.33	123.7	68477888.0
2008-09-19 11:00:00	SPY	ETF	123.7	126.75	123.7	125.4	51452439.0
2008-09-19 12:00:00	SPY	ETF	125.4	127.76	122.5	125.67	66025602.0
2008-09-19 13:00:00	SPY	ETF	125.67	126.25	124.81	124.82	40378437.0
2008-09-19 14:00:00	SPY	ETF	124.82	126.25	124.44	124.83	39833435.0
2008-09-19 15:00:00	SPY	ETF	124.83	125.23	116.52	125.04	83428227.0
2008-09-19 16:00:00	SPY	ETF	125.02	125.34	120.4883	124.39	48040504.0
2008-09-19 17:00:00	SPY	ETF	124.33	124.7	120.4883	124.6	9496841.0
2008-09-19 18:00:00	SPY	ETF	124.59	124.8	124.53	124.71	39356.0
2008-09-19 19:00:00	SPY	ETF	124.55	124.55	124.3	124.53	39115.0
2008-09-19 04:00:00	QQQ	ETF	42.6	42.72	42.56	42.72	5500.0
2008-09-19 05:00:00	QQQ	ETF	42.69	42.81	42.65	42.71	4900.0
2008-09-19 06:00:00	QQQ	ETF	42.75	42.85	42.69	42.69	24200.0
2008-09-19 07:00:00	QQQ	ETF	42.69	43.1	42.57	43.01	1444113.0
2008-09-19 08:00:00	QQQ	ETF	43.0	43.75	42.5719	43.51	8916085.0
2008-09-19 09:00:00	QQQ	ETF	43.51	44.23	42.59	42.6605	47301635.0
2008-09-19 10:00:00	QQQ	ETF	42.66	42.87	42.1	42.41	42511097.0
2008-09-19 11:00:00	QQQ	ETF	42.41	43.13	42.41	43.0805	33595913.0
2008-09-19 12:00:00	QQQ	ETF	43.09	43.28	42.98	43.08	24510335.0
2008-09-19 13:00:00	QQQ	ETF	43.08	43.08	42.7	42.74	15222406.0
2008-09-19 14:00:00	QQQ	ETF	42.74	42.85	42.51	42.73	30045872.0
2008-09-19 15:00:00	QQQ	ETF	42.73	42.93	42.38	42.87	43000436.0
2008-09-19 16:00:00	QQQ	ETF	42.87	43.1726	42.42	42.66	7622060.0
2008-09-19 17:00:00	QQQ	ETF	42.64	42.9	42.62	42.73	152730.0
2008-09-19 18:00:00	QQQ	ETF	42.75	42.79	42.63	42.63	11635.0
2008-09-19 19:00:00	QQQ	ETF	42.7	42.8	42.65	42.65	6890.0
2008-09-19 04:00:00	IWM	ETF	73.99	74.05	73.99	74.05	500.0
2008-09-19 05:00:00	IWM	ETF	74.8	74.8	74.67	74.7	1600.0
2008-09-19 07:00:00	IWM	ETF	74.95	77.0	74.93	75.75	735820.0
2008-09-19 08:00:00	IWM	ETF	75.55	77.75	75.3	77.75	3043561.0
2008-09-19 09:00:00	IWM	ETF	77.7	86.0	74.95	75.47	13998704.0
2008-09-19 10:00:00	IWM	ETF	75.46	76.23	73.95	74.04	17540894.0
2008-09-19 11:00:00	IWM	ETF	74.03	74.96	74.02	74.79	16444409.0
2008-09-19 12:00:00	IWM	ETF	74.79	75.45	74.68	75.05	15165382.0
2008-09-19 13:00:00	IWM	ETF	75.05	75.15	74.72	74.76	10912698.0
2008-09-19 14:00:00	IWM	ETF	74.75	74.85	74.23	74.56	14169462.0
2008-09-19 15:00:00	IWM	ETF	74.57	75.19	73.99	75.19	27745019.0
2008-09-19 16:00:00	IWM	ETF	75.19	75.55	74.75	75.05	4151627.0
2008-09-19 17:00:00	IWM	ETF	75.35	75.35	75.22	75.3	377200.0
2008-09-19 18:00:00	IWM	ETF	75.2	75.43	75.2	75.43	100585.0
2008-09-19 07:00:00	DIA	ETF	112.41	113.31	112.32	113.0	227003.0
2008-09-19 08:00:00	DIA	ETF	113.01	114.2	112.88	114.18	647806.0
2008-09-19 09:00:00	DIA	ETF	114.18	116.14	113.4	113.64	4104603.0
2008-09-19 10:00:00	DIA	ETF	113.65	113.98	112.66	113.03	2359999.0

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

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