PREVIEW / etf_1hour / 2006-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-28.parquet
  size:    49 KB
  rows:    1,551

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-07-28 04:00:00	SPY	ETF	126.95	126.95	126.95	126.95	100.0
2006-07-28 05:00:00	SPY	ETF	126.96	126.96	126.96	126.96	100.0
2006-07-28 06:00:00	SPY	ETF	126.83	126.83	126.83	126.83	100.0
2006-07-28 07:00:00	SPY	ETF	126.82	126.84	126.73	126.8	7300.0
2006-07-28 08:00:00	SPY	ETF	126.79	127.15	126.68	126.94	3368700.0
2006-07-28 09:00:00	SPY	ETF	126.95	127.42	126.9	127.21	10429800.0
2006-07-28 10:00:00	SPY	ETF	127.22	127.38	126.86	127.37	12574400.0
2006-07-28 11:00:00	SPY	ETF	127.37	127.93	127.34	127.86	16713200.0
2006-07-28 12:00:00	SPY	ETF	127.84	127.99	127.66	127.92	4965200.0
2006-07-28 13:00:00	SPY	ETF	127.91	128.06	127.57	127.71	11083600.0
2006-07-28 14:00:00	SPY	ETF	127.72	127.96	127.64	127.9	6291900.0
2006-07-28 15:00:00	SPY	ETF	127.87	128.14	127.76	127.84	12585500.0
2006-07-28 16:00:00	SPY	ETF	127.83	128.0	127.8	127.95	1157100.0
2006-07-28 17:00:00	SPY	ETF	127.96	127.96	127.93	127.96	25300.0
2006-07-28 18:00:00	SPY	ETF	127.97	128.0	127.96	127.96	400.0
2006-07-28 19:00:00	SPY	ETF	127.97	127.97	127.97	127.97	1500.0
2006-07-28 09:00:00	QQQ	ETF	36.56	36.8	36.51	36.7	12287000.0
2006-07-28 10:00:00	QQQ	ETF	36.7	36.75	36.5	36.7	14730300.0
2006-07-28 11:00:00	QQQ	ETF	36.7	36.97	36.7	36.9	16635700.0
2006-07-28 12:00:00	QQQ	ETF	36.89	37.04	36.83	37.01	8960900.0
2006-07-28 13:00:00	QQQ	ETF	37.02	37.1	36.87	36.95	10220400.0
2006-07-28 14:00:00	QQQ	ETF	36.95	37.06	36.92	37.03	6785400.0
2006-07-28 15:00:00	QQQ	ETF	37.02	37.14	36.98	37.1	16519300.0
2006-07-28 08:00:00	IWM	ETF	68.23	68.68	68.14	68.63	1804200.0
2006-07-28 09:00:00	IWM	ETF	68.63	69.36	68.5	69.01	12324400.0
2006-07-28 10:00:00	IWM	ETF	69.01	69.11	68.49	69.0	12760100.0
2006-07-28 11:00:00	IWM	ETF	69.0	69.46	68.96	69.32	10426200.0
2006-07-28 12:00:00	IWM	ETF	69.32	69.6	69.18	69.53	6206700.0
2006-07-28 13:00:00	IWM	ETF	69.55	69.67	68.48	69.45	5454300.0
2006-07-28 14:00:00	IWM	ETF	69.44	69.6	69.38	69.51	4590400.0
2006-07-28 15:00:00	IWM	ETF	69.51	69.7	69.36	69.55	6110400.0
2006-07-28 16:00:00	IWM	ETF	69.59	70.15	69.54	69.67	1029000.0
2006-07-28 17:00:00	IWM	ETF	69.67	69.67	69.67	69.67	1300.0
2006-07-28 08:00:00	DIA	ETF	111.26	111.55	111.2	111.37	676300.0
2006-07-28 09:00:00	DIA	ETF	111.37	111.82	111.15	111.59	1778800.0
2006-07-28 10:00:00	DIA	ETF	111.61	111.9	111.42	111.88	1532800.0
2006-07-28 11:00:00	DIA	ETF	111.88	112.28	111.88	112.2	2049400.0
2006-07-28 12:00:00	DIA	ETF	112.2	112.28	111.98	112.23	386100.0
2006-07-28 13:00:00	DIA	ETF	112.24	112.32	111.95	112.08	519000.0
2006-07-28 14:00:00	DIA	ETF	112.08	112.33	112.08	112.24	457300.0
2006-07-28 15:00:00	DIA	ETF	112.24	112.33	111.98	112.0	3869400.0
2006-07-28 16:00:00	DIA	ETF	111.99	112.19	111.97	112.19	14900.0
2006-07-28 19:00:00	DIA	ETF	112.12	112.12	112.11	112.11	500.0
2006-07-28 07:00:00	GLD	ETF	62.56	62.56	62.56	62.56	2000.0
2006-07-28 08:00:00	GLD	ETF	62.47	63.0	62.2	62.86	155400.0
2006-07-28 09:00:00	GLD	ETF	62.85	63.34	62.71	63.34	722700.0
2006-07-28 10:00:00	GLD	ETF	63.34	63.34	62.99	63.2	578400.0
2006-07-28 11:00:00	GLD	ETF	63.21	63.32	62.75	63.09	434500.0
2006-07-28 12:00:00	GLD	ETF	63.09	63.22	62.98	63.09	366500.0
2006-07-28 13:00:00	GLD	ETF	63.1	63.24	62.87	63.18	354400.0

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

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