PREVIEW / etf_1hour / 2006-05-11

all etf 1-hour files

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

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-11 06:00:00	SPY	ETF	132.72	132.72	132.65	132.65	900.0
2006-05-11 07:00:00	SPY	ETF	132.66	132.66	132.55	132.55	144500.0
2006-05-11 08:00:00	SPY	ETF	132.56	132.79	132.53	132.64	1187700.0
2006-05-11 09:00:00	SPY	ETF	132.59	132.62	131.9	132.06	6541600.0
2006-05-11 10:00:00	SPY	ETF	132.05	132.51	131.5	131.55	12901300.0
2006-05-11 11:00:00	SPY	ETF	131.55	131.73	131.2	131.26	13775900.0
2006-05-11 12:00:00	SPY	ETF	131.26	131.31	130.98	131.2376	8280000.0
2006-05-11 13:00:00	SPY	ETF	131.24	131.24	130.76	130.96	11298400.0
2006-05-11 14:00:00	SPY	ETF	130.98	131.14	130.6	130.7	7821100.0
2006-05-11 15:00:00	SPY	ETF	130.7	130.92	130.52	130.78	12277300.0
2006-05-11 16:00:00	SPY	ETF	130.78	131.0	130.74	130.95	2087300.0
2006-05-11 17:00:00	SPY	ETF	130.97	131.0	130.93	131.0	125800.0
2006-05-11 18:00:00	SPY	ETF	131.0	131.01	130.99	131.01	28100.0
2006-05-11 19:00:00	SPY	ETF	130.98	130.98	130.98	130.98	3700.0
2006-05-11 09:00:00	QQQ	ETF	41.63	41.65	41.33	41.37	12637600.0
2006-05-11 10:00:00	QQQ	ETF	41.37	41.46	41.02	41.04	33128100.0
2006-05-11 11:00:00	QQQ	ETF	41.04	41.1	40.7	40.84	21377700.0
2006-05-11 12:00:00	QQQ	ETF	40.84	40.95	40.79	40.94	14842400.0
2006-05-11 13:00:00	QQQ	ETF	40.94	40.95	40.76	40.84	9877300.0
2006-05-11 14:00:00	QQQ	ETF	40.83	40.94	40.68	40.71	15078900.0
2006-05-11 15:00:00	QQQ	ETF	40.72	40.82	40.63	40.73	23997100.0
2006-05-11 08:00:00	IWM	ETF	77.19	77.35	77.18	77.18	16700.0
2006-05-11 09:00:00	IWM	ETF	77.15	77.16	76.66	76.72	1929600.0
2006-05-11 10:00:00	IWM	ETF	76.7	76.86	76.35	76.39	5695600.0
2006-05-11 11:00:00	IWM	ETF	76.39	76.5	75.88	75.89	6427300.0
2006-05-11 12:00:00	IWM	ETF	75.91	76.01	75.68	75.85	8477200.0
2006-05-11 13:00:00	IWM	ETF	75.84	75.93	75.51	75.66	4352900.0
2006-05-11 14:00:00	IWM	ETF	75.65	75.82	75.47	75.48	4804400.0
2006-05-11 15:00:00	IWM	ETF	75.48	75.66	75.23	75.26	8836600.0
2006-05-11 16:00:00	IWM	ETF	75.27	75.41	75.2	75.31	1574500.0
2006-05-11 17:00:00	IWM	ETF	75.32	75.35	75.31	75.35	2800.0
2006-05-11 19:00:00	IWM	ETF	75.32	75.4	75.32	75.4	800.0
2006-05-11 07:00:00	DIA	ETF	116.56	116.56	116.55	116.55	3600.0
2006-05-11 08:00:00	DIA	ETF	116.55	116.64	116.49	116.6	500200.0
2006-05-11 09:00:00	DIA	ETF	116.57	116.57	115.95	116.0	676800.0
2006-05-11 10:00:00	DIA	ETF	116.0	116.2	115.5	115.53	3172600.0
2006-05-11 11:00:00	DIA	ETF	115.52	115.65	115.34	115.41	1329300.0
2006-05-11 12:00:00	DIA	ETF	115.42	115.47	115.21	115.42	571500.0
2006-05-11 13:00:00	DIA	ETF	115.41	115.42	115.07	115.25	768200.0
2006-05-11 14:00:00	DIA	ETF	115.23	115.38	114.99	115.07	684600.0
2006-05-11 15:00:00	DIA	ETF	115.05	115.18	114.85	115.08	1633200.0
2006-05-11 16:00:00	DIA	ETF	115.09	115.23	115.08	115.22	164500.0
2006-05-11 17:00:00	DIA	ETF	115.24	115.36	115.24	115.34	1700.0
2006-05-11 07:00:00	GLD	ETF	70.7	70.7	70.57	70.64	6100.0
2006-05-11 08:00:00	GLD	ETF	70.65	71.65	70.44	71.57	425500.0
2006-05-11 09:00:00	GLD	ETF	71.59	72.23	71.4	71.61	4084100.0
2006-05-11 10:00:00	GLD	ETF	71.62	71.67	71.05	71.42	3155600.0
2006-05-11 11:00:00	GLD	ETF	71.44	72.04	71.4	72.01	3070700.0
2006-05-11 12:00:00	GLD	ETF	72.0	72.15	71.75	71.92	1668100.0
2006-05-11 13:00:00	GLD	ETF	71.9001	72.0	71.63	71.86	924600.0

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

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