PREVIEW / etf_1hour / 2008-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-30.parquet
  size:    110 KB
  rows:    3,559

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-30 04:00:00	SPY	ETF	126.27	126.27	126.27	126.27	200.0
2008-07-30 05:00:00	SPY	ETF	126.11	126.13	126.1	126.1	7200.0
2008-07-30 06:00:00	SPY	ETF	126.43	126.5	126.4	126.5	5400.0
2008-07-30 07:00:00	SPY	ETF	126.47	126.53	126.21	126.34	780037.0
2008-07-30 08:00:00	SPY	ETF	126.31	126.99	126.13	126.98	6489973.0
2008-07-30 09:00:00	SPY	ETF	126.99	127.69	126.95	127.3	61154743.0
2008-07-30 10:00:00	SPY	ETF	127.31	128.13	126.3502	127.51	72208278.0
2008-07-30 11:00:00	SPY	ETF	127.52	127.86	127.3	127.47	36393921.0
2008-07-30 12:00:00	SPY	ETF	127.48	127.53	126.54	126.85	36080390.0
2008-07-30 13:00:00	SPY	ETF	126.84	127.16	126.3502	126.76	40066131.0
2008-07-30 14:00:00	SPY	ETF	126.77	127.65	126.62	127.45	35507034.0
2008-07-30 15:00:00	SPY	ETF	127.46	128.47	127.05	128.45	52622130.0
2008-07-30 16:00:00	SPY	ETF	128.46	128.68	126.3502	128.59	7702308.0
2008-07-30 17:00:00	SPY	ETF	128.6	128.6	126.35	128.5	1301777.0
2008-07-30 18:00:00	SPY	ETF	128.5	128.62	128.5	128.56	77850.0
2008-07-30 19:00:00	SPY	ETF	128.58	128.58	128.48	128.48	51881.0
2008-07-30 04:00:00	QQQ	ETF	45.22	45.22	45.22	45.22	300.0
2008-07-30 06:00:00	QQQ	ETF	45.41	45.42	45.38	45.4	8300.0
2008-07-30 07:00:00	QQQ	ETF	45.42	45.47	45.37	45.41	464705.0
2008-07-30 08:00:00	QQQ	ETF	45.41	45.59	45.34	45.58	7483609.0
2008-07-30 09:00:00	QQQ	ETF	45.59	45.66	45.37	45.38	17654659.0
2008-07-30 10:00:00	QQQ	ETF	45.39	45.82	45.38	45.53	30464807.0
2008-07-30 11:00:00	QQQ	ETF	45.53	45.66	45.49	45.59	8688810.0
2008-07-30 12:00:00	QQQ	ETF	45.59	45.62	45.11	45.1899	16548222.0
2008-07-30 13:00:00	QQQ	ETF	45.18	45.21	44.88	45.01	26702988.0
2008-07-30 14:00:00	QQQ	ETF	45.0199	45.23	44.9	45.21	16895973.0
2008-07-30 15:00:00	QQQ	ETF	45.21	45.57	44.95	45.56	25781541.0
2008-07-30 16:00:00	QQQ	ETF	45.56	45.62	45.3084	45.6	2001627.0
2008-07-30 17:00:00	QQQ	ETF	45.6	45.64	45.58	45.63	181942.0
2008-07-30 18:00:00	QQQ	ETF	45.6	45.63	45.6	45.63	35321.0
2008-07-30 19:00:00	QQQ	ETF	45.62	45.62	45.57	45.58	50956.0
2008-07-30 06:00:00	IWM	ETF	71.3	71.3	71.3	71.3	100.0
2008-07-30 07:00:00	IWM	ETF	71.32	71.36	71.25	71.27	12900.0
2008-07-30 08:00:00	IWM	ETF	71.31	71.57	71.18	71.56	1370352.0
2008-07-30 09:00:00	IWM	ETF	71.56	72.06	71.46	71.83	19526524.0
2008-07-30 10:00:00	IWM	ETF	71.83	72.07	71.18	71.73	25062678.0
2008-07-30 11:00:00	IWM	ETF	71.73	71.9	71.67	71.82	19259796.0
2008-07-30 12:00:00	IWM	ETF	71.83	71.86	70.92	71.03	14151519.0
2008-07-30 13:00:00	IWM	ETF	71.03	71.07	70.64	70.82	11686391.0
2008-07-30 14:00:00	IWM	ETF	70.82	71.34	70.71	71.3	13425830.0
2008-07-30 15:00:00	IWM	ETF	71.3	71.76	71.02	71.62	20033272.0
2008-07-30 16:00:00	IWM	ETF	71.6	71.9	71.26	71.68	21970014.0
2008-07-30 17:00:00	IWM	ETF	71.67	71.68	71.62	71.68	11559.0
2008-07-30 18:00:00	IWM	ETF	71.62	71.62	71.62	71.62	300.0
2008-07-30 19:00:00	IWM	ETF	71.62	71.65	71.62	71.65	445.0
2008-07-30 06:00:00	DIA	ETF	113.93	113.93	113.93	113.93	200.0
2008-07-30 07:00:00	DIA	ETF	114.03	114.15	114.0	114.0	6050.0
2008-07-30 08:00:00	DIA	ETF	114.02	114.56	113.91	114.54	166403.0
2008-07-30 09:00:00	DIA	ETF	114.57	115.25	114.51	114.91	3481251.0
2008-07-30 10:00:00	DIA	ETF	114.92	115.54	114.76	114.9	5672966.0

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

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