PREVIEW / etf_1hour / 2008-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-09.parquet
  size:    102 KB
  rows:    3,297

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-05-09 04:00:00	SPY	ETF	138.7	138.7	138.61	138.62	8000.0
2008-05-09 05:00:00	SPY	ETF	138.5	138.5	138.32	138.32	400.0
2008-05-09 06:00:00	SPY	ETF	138.35	138.53	138.33	138.5	111000.0
2008-05-09 07:00:00	SPY	ETF	138.49	138.59	138.35	138.36	1300083.0
2008-05-09 08:00:00	SPY	ETF	138.58	139.8	138.36	138.57	2372025.0
2008-05-09 09:00:00	SPY	ETF	138.57	138.92	138.45	138.6	18885309.0
2008-05-09 10:00:00	SPY	ETF	138.6	139.39	138.59	139.14	28050320.0
2008-05-09 11:00:00	SPY	ETF	139.14	139.18	138.69	138.83	21059094.0
2008-05-09 12:00:00	SPY	ETF	138.82	138.95	138.65	138.93	12404940.0
2008-05-09 13:00:00	SPY	ETF	138.93	138.95	138.5	138.88	16173895.0
2008-05-09 14:00:00	SPY	ETF	138.88	139.02	138.63	138.79	15061480.0
2008-05-09 15:00:00	SPY	ETF	138.78	139.39	138.75	138.93	25508668.0
2008-05-09 16:00:00	SPY	ETF	138.92	139.8657	138.81	138.9	6127764.0
2008-05-09 17:00:00	SPY	ETF	138.87	139.12	138.87	139.11	108698.0
2008-05-09 18:00:00	SPY	ETF	139.11	139.12	138.93	138.95	43241.0
2008-05-09 19:00:00	SPY	ETF	138.99	139.0	138.91	138.95	13393.0
2008-05-09 05:00:00	QQQ	ETF	48.04	48.04	48.0	48.0	200.0
2008-05-09 06:00:00	QQQ	ETF	48.01	48.03	47.96	47.96	3900.0
2008-05-09 07:00:00	QQQ	ETF	48.01	48.05	47.95	47.96	193364.0
2008-05-09 08:00:00	QQQ	ETF	47.96	48.08	47.95	48.0	1219342.0
2008-05-09 09:00:00	QQQ	ETF	48.0	48.09	47.9	47.98	13924505.0
2008-05-09 10:00:00	QQQ	ETF	47.99	48.46	47.99	48.33	19387381.0
2008-05-09 11:00:00	QQQ	ETF	48.33	48.36	48.1	48.199	10327557.0
2008-05-09 12:00:00	QQQ	ETF	48.19	48.2	48.04	48.19	6563981.0
2008-05-09 13:00:00	QQQ	ETF	48.2	48.23	48.01	48.2	8239833.0
2008-05-09 14:00:00	QQQ	ETF	48.2	48.31	48.05	48.15	10449561.0
2008-05-09 15:00:00	QQQ	ETF	48.15	48.34	48.12	48.19	19437488.0
2008-05-09 16:00:00	QQQ	ETF	48.2	48.3	48.1433	48.2	6751385.0
2008-05-09 17:00:00	QQQ	ETF	48.2	48.27	48.2	48.2	63694.0
2008-05-09 18:00:00	QQQ	ETF	48.23	48.24	48.22	48.22	2400.0
2008-05-09 19:00:00	QQQ	ETF	48.25	48.27	48.21	48.27	7700.0
2008-05-09 06:00:00	IWM	ETF	71.09	71.09	71.09	71.09	200.0
2008-05-09 07:00:00	IWM	ETF	71.16	71.16	71.08	71.09	28900.0
2008-05-09 08:00:00	IWM	ETF	71.06	71.28	71.03	71.23	222017.0
2008-05-09 09:00:00	IWM	ETF	71.21	71.37	71.04	71.21	9611756.0
2008-05-09 10:00:00	IWM	ETF	71.22	72.12	71.2	71.88	10992317.0
2008-05-09 11:00:00	IWM	ETF	71.89	71.95	71.46	71.56	5624656.0
2008-05-09 12:00:00	IWM	ETF	71.56	71.62	71.34	71.6	3255702.0
2008-05-09 13:00:00	IWM	ETF	71.59	71.81	71.5	71.79	4164122.0
2008-05-09 14:00:00	IWM	ETF	71.78	71.84	71.53	71.65	4003658.0
2008-05-09 15:00:00	IWM	ETF	71.64	71.97	71.59	71.97	7854445.0
2008-05-09 16:00:00	IWM	ETF	71.97	72.07	71.5	71.62	4518870.0
2008-05-09 17:00:00	IWM	ETF	71.62	72.19	71.62	71.67	60059.0
2008-05-09 18:00:00	IWM	ETF	71.7	71.7	71.7	71.7	300.0
2008-05-09 19:00:00	IWM	ETF	71.7	71.7	71.7	71.7	300.0
2008-05-09 06:00:00	DIA	ETF	127.48	127.48	127.48	127.48	200.0
2008-05-09 07:00:00	DIA	ETF	127.45	127.45	127.42	127.45	600.0
2008-05-09 08:00:00	DIA	ETF	127.45	127.68	127.45	127.6	39231.0
2008-05-09 09:00:00	DIA	ETF	127.66	127.79	127.33	127.54	1263646.0
2008-05-09 10:00:00	DIA	ETF	127.54	128.03	127.54	127.85	1883806.0

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

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