PREVIEW / etf_1hour / 2006-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-06.parquet
  size:    45 KB
  rows:    1,363

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-06-06 05:00:00	SPY	ETF	127.41	127.41	127.41	127.41	100.0
2006-06-06 07:00:00	SPY	ETF	127.4	127.4	127.21	127.26	96300.0
2006-06-06 08:00:00	SPY	ETF	127.27	127.4	127.18	127.24	1806200.0
2006-06-06 09:00:00	SPY	ETF	127.24	127.38	126.51	126.59	13626300.0
2006-06-06 10:00:00	SPY	ETF	126.6	127.07	126.35	126.45	23971000.0
2006-06-06 11:00:00	SPY	ETF	126.45	126.56	125.76	125.98	20598900.0
2006-06-06 12:00:00	SPY	ETF	125.96	126.95	125.91	126.88	20552600.0
2006-06-06 13:00:00	SPY	ETF	126.87	126.89	126.26	126.52	11354300.0
2006-06-06 14:00:00	SPY	ETF	126.51	126.65	126.09	126.12	10439400.0
2006-06-06 15:00:00	SPY	ETF	126.12	126.96	126.0	126.71	19428000.0
2006-06-06 16:00:00	SPY	ETF	126.72	126.94	126.45	126.88	4585700.0
2006-06-06 17:00:00	SPY	ETF	126.91	126.97	126.91	126.91	76600.0
2006-06-06 18:00:00	SPY	ETF	126.96	126.97	126.91	126.91	369300.0
2006-06-06 19:00:00	SPY	ETF	126.95	126.95	126.95	126.95	4000.0
2006-06-06 09:00:00	QQQ	ETF	38.85	38.95	38.57	38.63	18661500.0
2006-06-06 10:00:00	QQQ	ETF	38.62	38.87	38.57	38.62	23205800.0
2006-06-06 11:00:00	QQQ	ETF	38.61	38.66	38.35	38.46	23605900.0
2006-06-06 12:00:00	QQQ	ETF	38.46	38.79	38.43	38.76	16228800.0
2006-06-06 13:00:00	QQQ	ETF	38.77	38.77	38.54	38.65	9540000.0
2006-06-06 14:00:00	QQQ	ETF	38.65	38.68	38.47	38.49	10034000.0
2006-06-06 15:00:00	QQQ	ETF	38.5	38.8	38.45	38.73	20233300.0
2006-06-06 08:00:00	IWM	ETF	71.21	71.22	71.09	71.09	45800.0
2006-06-06 09:00:00	IWM	ETF	71.12	71.16	70.24	70.35	14780400.0
2006-06-06 10:00:00	IWM	ETF	70.36	70.95	70.24	70.33	14061100.0
2006-06-06 11:00:00	IWM	ETF	70.33	70.45	69.81	69.87	16238700.0
2006-06-06 12:00:00	IWM	ETF	69.87	70.87	69.83	70.81	14634400.0
2006-06-06 13:00:00	IWM	ETF	70.8	70.86	70.28	70.67	12616900.0
2006-06-06 14:00:00	IWM	ETF	70.6575	70.66	70.14	70.21	6377500.0
2006-06-06 15:00:00	IWM	ETF	70.22	70.77	70.11	70.76	13373700.0
2006-06-06 16:00:00	IWM	ETF	70.77	70.95	70.73	70.9	933100.0
2006-06-06 17:00:00	IWM	ETF	70.91	70.98	70.91	70.98	6000.0
2006-06-06 07:00:00	DIA	ETF	110.92	110.92	110.88	110.88	600.0
2006-06-06 08:00:00	DIA	ETF	110.91	110.91	110.8	110.86	3700.0
2006-06-06 09:00:00	DIA	ETF	110.82	110.94	110.22	110.27	1719100.0
2006-06-06 10:00:00	DIA	ETF	110.28	110.62	109.94	110.0	2790900.0
2006-06-06 11:00:00	DIA	ETF	109.99	110.11	109.21	109.39	4224600.0
2006-06-06 12:00:00	DIA	ETF	109.39	110.05	109.35	109.98	2064600.0
2006-06-06 13:00:00	DIA	ETF	109.96	109.97	109.49	109.7	1146900.0
2006-06-06 14:00:00	DIA	ETF	109.71	109.82	109.39	109.44	989800.0
2006-06-06 15:00:00	DIA	ETF	109.43	110.088	109.32	109.98	2055300.0
2006-06-06 16:00:00	DIA	ETF	109.95	110.1	109.94	110.08	99400.0
2006-06-06 17:00:00	DIA	ETF	110.14	110.15	110.14	110.15	600.0
2006-06-06 18:00:00	DIA	ETF	110.15	110.15	110.15	110.15	100.0
2006-06-06 07:00:00	GLD	ETF	63.08	63.08	63.06	63.06	2700.0
2006-06-06 08:00:00	GLD	ETF	63.05	63.22	62.46	62.5	482300.0
2006-06-06 09:00:00	GLD	ETF	62.49	62.78	62.29	62.42	1937600.0
2006-06-06 10:00:00	GLD	ETF	62.43	62.64	62.2016	62.3	1538700.0
2006-06-06 11:00:00	GLD	ETF	62.29	62.52	62.16	62.19	1034700.0
2006-06-06 12:00:00	GLD	ETF	62.18	62.6	62.18	62.52	583300.0
2006-06-06 13:00:00	GLD	ETF	62.52	62.67	62.48	62.51	448900.0

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

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