PREVIEW / etf_1hour / 2006-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-31.parquet
  size:    44 KB
  rows:    1,350

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
2006-05-31 05:00:00	SPY	ETF	126.47	126.54	126.47	126.54	2300.0
2006-05-31 06:00:00	SPY	ETF	126.65	126.65	126.47	126.47	26100.0
2006-05-31 07:00:00	SPY	ETF	126.46	126.65	126.46	126.65	132600.0
2006-05-31 08:00:00	SPY	ETF	126.63	126.88	126.05	126.67	1424100.0
2006-05-31 09:00:00	SPY	ETF	126.67	126.97	126.56	126.87	9488600.0
2006-05-31 10:00:00	SPY	ETF	126.87	127.33	126.61	127.2	15449300.0
2006-05-31 11:00:00	SPY	ETF	127.21	127.37	127.01	127.16	4795800.0
2006-05-31 12:00:00	SPY	ETF	127.16	127.2	127.04	127.05	4537000.0
2006-05-31 13:00:00	SPY	ETF	127.05	127.14	126.812	126.9	4616100.0
2006-05-31 14:00:00	SPY	ETF	126.91	127.18	126.2	126.82	21892000.0
2006-05-31 15:00:00	SPY	ETF	126.83	127.38	126.3274	127.3	14858500.0
2006-05-31 16:00:00	SPY	ETF	127.3	127.98	127.26	127.45	3885800.0
2006-05-31 17:00:00	SPY	ETF	127.47	127.49	127.38	127.42	15600.0
2006-05-31 18:00:00	SPY	ETF	127.44	127.54	127.44	127.5	8000.0
2006-05-31 19:00:00	SPY	ETF	127.51	127.51	127.51	127.51	100.0
2006-05-31 09:00:00	QQQ	ETF	38.72	38.86	38.71	38.8	12989100.0
2006-05-31 10:00:00	QQQ	ETF	38.8	39.05	38.68	38.97	23904700.0
2006-05-31 11:00:00	QQQ	ETF	38.97	39.99	38.88	38.95	10485200.0
2006-05-31 12:00:00	QQQ	ETF	38.95	38.99	38.9	38.95	12278900.0
2006-05-31 13:00:00	QQQ	ETF	38.95	38.97	38.83	38.85	10084700.0
2006-05-31 14:00:00	QQQ	ETF	38.85	38.95	38.54	38.72	36833800.0
2006-05-31 15:00:00	QQQ	ETF	38.71	38.9	38.62	38.83	20005100.0
2006-05-31 07:00:00	IWM	ETF	70.9	70.9	70.9	70.9	800.0
2006-05-31 08:00:00	IWM	ETF	70.9	70.97	70.64	70.88	1197500.0
2006-05-31 09:00:00	IWM	ETF	70.89	71.21	70.81	71.06	4379900.0
2006-05-31 10:00:00	IWM	ETF	71.05	71.48	70.67	71.4	11718200.0
2006-05-31 11:00:00	IWM	ETF	71.39	71.7	70.6955	71.39	8121200.0
2006-05-31 12:00:00	IWM	ETF	71.38	71.67	71.34	71.5	5088500.0
2006-05-31 13:00:00	IWM	ETF	71.5	71.58	71.19	71.24	4660300.0
2006-05-31 14:00:00	IWM	ETF	71.25	71.5	70.6955	71.31	13153700.0
2006-05-31 15:00:00	IWM	ETF	71.29	71.75	70.74	71.59	7186700.0
2006-05-31 16:00:00	IWM	ETF	71.6	71.87	71.59	71.73	926900.0
2006-05-31 17:00:00	IWM	ETF	71.79	71.8	71.77	71.8	3200.0
2006-05-31 07:00:00	DIA	ETF	111.24	111.24	111.24	111.24	1000.0
2006-05-31 08:00:00	DIA	ETF	111.24	111.34	111.21	111.23	107400.0
2006-05-31 09:00:00	DIA	ETF	111.25	111.41	111.1701	111.23	578800.0
2006-05-31 10:00:00	DIA	ETF	111.23	111.77	111.06	111.7	1697100.0
2006-05-31 11:00:00	DIA	ETF	111.67	111.81	111.53	111.68	484500.0
2006-05-31 12:00:00	DIA	ETF	111.69	111.71	111.56	111.58	288900.0
2006-05-31 13:00:00	DIA	ETF	111.5776	111.6	111.32	111.4	411200.0
2006-05-31 14:00:00	DIA	ETF	111.4	111.55	110.8	111.22	2492800.0
2006-05-31 15:00:00	DIA	ETF	111.24	111.66	111.0499	111.62	942400.0
2006-05-31 16:00:00	DIA	ETF	111.62	111.71	111.58	111.71	55800.0
2006-05-31 17:00:00	DIA	ETF	111.67	111.67	111.66	111.66	4300.0
2006-05-31 18:00:00	DIA	ETF	111.66	111.71	111.66	111.71	1400.0
2006-05-31 19:00:00	DIA	ETF	111.72	111.74	111.67	111.74	600.0
2006-05-31 06:00:00	GLD	ETF	65.05	65.05	65.05	65.05	400.0
2006-05-31 08:00:00	GLD	ETF	65.18	65.42	65.0	65.23	68300.0
2006-05-31 09:00:00	GLD	ETF	65.23	65.66	65.22	65.37	752700.0
2006-05-31 10:00:00	GLD	ETF	65.36	65.36	64.04	64.39	1706100.0

> showing 50 of 1,350 rows — these rows as CSV

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