PREVIEW / etf_1hour / 2008-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-01.parquet
  size:    107 KB
  rows:    3,438

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-08-01 04:00:00	SPY	ETF	126.9	126.99	126.9	126.95	2900.0
2008-08-01 05:00:00	SPY	ETF	127.05	127.05	127.05	127.05	1000.0
2008-08-01 06:00:00	SPY	ETF	127.3	127.3	127.2	127.2	32000.0
2008-08-01 07:00:00	SPY	ETF	127.11	127.17	126.5	126.7	721864.0
2008-08-01 08:00:00	SPY	ETF	126.66	127.75	126.66	127.3	10511024.0
2008-08-01 09:00:00	SPY	ETF	127.3	127.38	125.83	126.19	35003655.0
2008-08-01 10:00:00	SPY	ETF	126.19	126.83	125.46	126.2	55820640.0
2008-08-01 11:00:00	SPY	ETF	126.21	126.48	125.83	126.31	25131659.0
2008-08-01 12:00:00	SPY	ETF	126.3	126.35	125.54	125.6	25052394.0
2008-08-01 13:00:00	SPY	ETF	125.61	127.0	125.58	126.2	22481350.0
2008-08-01 14:00:00	SPY	ETF	126.2	126.31	125.72	126.23	26862291.0
2008-08-01 15:00:00	SPY	ETF	126.23	126.63	125.84	126.11	32751520.0
2008-08-01 16:00:00	SPY	ETF	126.12	126.79	125.97	126.27	7873220.0
2008-08-01 17:00:00	SPY	ETF	126.27	126.33	126.13	126.19	13581.0
2008-08-01 18:00:00	SPY	ETF	126.19	126.2	126.19	126.2	700.0
2008-08-01 19:00:00	SPY	ETF	126.18	126.23	126.18	126.23	12727.0
2008-08-01 05:00:00	QQQ	ETF	45.55	45.55	45.55	45.55	100.0
2008-08-01 06:00:00	QQQ	ETF	45.58	45.58	45.58	45.58	400.0
2008-08-01 07:00:00	QQQ	ETF	45.55	45.55	45.4	45.42	84647.0
2008-08-01 08:00:00	QQQ	ETF	45.42	45.74	45.32	45.69	5867354.0
2008-08-01 09:00:00	QQQ	ETF	45.68	45.69	44.42	44.67	42596200.0
2008-08-01 10:00:00	QQQ	ETF	44.6699	44.9	44.4	44.83	38248299.0
2008-08-01 11:00:00	QQQ	ETF	44.84	45.01	44.63	44.99	17258092.0
2008-08-01 12:00:00	QQQ	ETF	44.99	45.0	44.62	44.68	13846274.0
2008-08-01 13:00:00	QQQ	ETF	44.68	45.08	44.65	44.94	17441057.0
2008-08-01 14:00:00	QQQ	ETF	44.94	45.05	44.77	44.99	11271091.0
2008-08-01 15:00:00	QQQ	ETF	44.99	45.13	44.87	44.9	19803865.0
2008-08-01 16:00:00	QQQ	ETF	44.9	45.4734	44.83	44.95	4942933.0
2008-08-01 17:00:00	QQQ	ETF	44.95	44.95	44.92	44.94	5200.0
2008-08-01 18:00:00	QQQ	ETF	44.94	44.94	44.92	44.92	3800.0
2008-08-01 19:00:00	QQQ	ETF	44.92	44.94	44.91	44.94	22690.0
2008-08-01 06:00:00	IWM	ETF	71.41	71.41	71.41	71.41	200.0
2008-08-01 07:00:00	IWM	ETF	71.22	71.22	71.0	71.15	76306.0
2008-08-01 08:00:00	IWM	ETF	71.13	71.67	71.13	71.46	3549347.0
2008-08-01 09:00:00	IWM	ETF	71.47	71.61	70.33	70.6	15380853.0
2008-08-01 10:00:00	IWM	ETF	70.6	71.32	70.32	71.25	22199819.0
2008-08-01 11:00:00	IWM	ETF	71.26	71.69	70.89	71.58	15757214.0
2008-08-01 12:00:00	IWM	ETF	71.58	71.59	71.03	71.09	9164626.0
2008-08-01 13:00:00	IWM	ETF	71.09	71.76	71.06	71.61	10210616.0
2008-08-01 14:00:00	IWM	ETF	71.62	71.66	71.29	71.48	9248515.0
2008-08-01 15:00:00	IWM	ETF	71.49	71.69	71.25	71.4	13499096.0
2008-08-01 16:00:00	IWM	ETF	71.4	71.67	71.17	71.6	1771499.0
2008-08-01 18:00:00	IWM	ETF	71.68	71.68	71.68	71.68	100.0
2008-08-01 06:00:00	DIA	ETF	113.96	114.14	113.96	114.14	400.0
2008-08-01 07:00:00	DIA	ETF	114.12	114.12	113.54	113.76	13235.0
2008-08-01 08:00:00	DIA	ETF	113.73	114.49	113.72	114.24	457443.0
2008-08-01 09:00:00	DIA	ETF	114.27	114.34	113.14	113.39	2873635.0
2008-08-01 10:00:00	DIA	ETF	113.39	113.56	112.59	113.21	5712409.0
2008-08-01 11:00:00	DIA	ETF	113.23	113.45	112.88	113.29	2881175.0
2008-08-01 12:00:00	DIA	ETF	113.26	113.3	112.73	112.77	2078268.0

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

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