PREVIEW / etf_1hour / 2006-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-09.parquet
  size:    39 KB
  rows:    1,217

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-01-09 06:00:00	SPY	ETF	128.34	128.34	128.34	128.34	100.0
2006-01-09 07:00:00	SPY	ETF	128.36	128.38	128.31	128.37	76100.0
2006-01-09 08:00:00	SPY	ETF	128.37	128.42	128.32	128.37	290300.0
2006-01-09 09:00:00	SPY	ETF	128.37	128.6	128.37	128.54	4135300.0
2006-01-09 10:00:00	SPY	ETF	128.53	128.71	128.38	128.52	8062800.0
2006-01-09 11:00:00	SPY	ETF	128.52	128.71	128.45	128.68	3264200.0
2006-01-09 12:00:00	SPY	ETF	128.68	128.8	128.57	128.79	4942900.0
2006-01-09 13:00:00	SPY	ETF	128.8	129.06	128.69	128.95	5756600.0
2006-01-09 14:00:00	SPY	ETF	128.98	128.99	128.5	128.66	6235700.0
2006-01-09 15:00:00	SPY	ETF	128.67	128.97	128.59	128.92	9206800.0
2006-01-09 16:00:00	SPY	ETF	128.92	128.94	128.64	128.67	654900.0
2006-01-09 17:00:00	SPY	ETF	128.67	128.71	128.67	128.67	102300.0
2006-01-09 18:00:00	SPY	ETF	128.74	128.77	128.7	128.7	7200.0
2006-01-09 19:00:00	SPY	ETF	128.71	128.71	128.68	128.68	2200.0
2006-01-09 09:00:00	QQQ	ETF	42.66	42.72	42.61	42.63	8654000.0
2006-01-09 10:00:00	QQQ	ETF	42.63	42.83	42.52	42.73	16610800.0
2006-01-09 11:00:00	QQQ	ETF	42.73	42.85	42.65	42.83	6371600.0
2006-01-09 12:00:00	QQQ	ETF	42.83	42.85	42.75	42.82	4432800.0
2006-01-09 13:00:00	QQQ	ETF	42.82	42.92	42.77	42.87	8573000.0
2006-01-09 14:00:00	QQQ	ETF	42.87	42.88	42.65	42.73	12019900.0
2006-01-09 15:00:00	QQQ	ETF	42.74	42.86	42.69	42.84	9776100.0
2006-01-09 07:00:00	IWM	ETF	69.6	69.6	69.6	69.6	800.0
2006-01-09 08:00:00	IWM	ETF	69.6	69.6	69.56	69.56	1200.0
2006-01-09 09:00:00	IWM	ETF	69.55	69.88	69.54	69.83	2783000.0
2006-01-09 10:00:00	IWM	ETF	69.83	69.98	69.77	69.83	4390700.0
2006-01-09 11:00:00	IWM	ETF	69.84	70.11	69.79	70.09	1898700.0
2006-01-09 12:00:00	IWM	ETF	70.09	70.2	70.05	70.2	2393000.0
2006-01-09 13:00:00	IWM	ETF	70.2	70.38	70.1	70.32	2225100.0
2006-01-09 14:00:00	IWM	ETF	70.31	70.36	70.04	70.09	2210500.0
2006-01-09 15:00:00	IWM	ETF	70.09	70.21	69.94	70.13	3160800.0
2006-01-09 16:00:00	IWM	ETF	70.13	70.14	69.98	69.98	302400.0
2006-01-09 17:00:00	IWM	ETF	69.99	69.99	69.97	69.97	300.0
2006-01-09 18:00:00	IWM	ETF	70.01	70.01	70.01	70.01	900.0
2006-01-09 19:00:00	IWM	ETF	69.99	69.99	69.99	69.99	2000.0
2006-01-09 08:00:00	DIA	ETF	109.5	109.5	109.5	109.5	1400.0
2006-01-09 09:00:00	DIA	ETF	109.5	109.72	109.47	109.65	1257700.0
2006-01-09 10:00:00	DIA	ETF	109.65	109.8	109.55	109.66	1113200.0
2006-01-09 11:00:00	DIA	ETF	109.64	109.86	109.6	109.85	233800.0
2006-01-09 12:00:00	DIA	ETF	109.84	110.0	109.8	109.99	1046500.0
2006-01-09 13:00:00	DIA	ETF	109.99	110.21	109.9	110.13	1755100.0
2006-01-09 14:00:00	DIA	ETF	110.13	110.17	109.68	109.7901	1685700.0
2006-01-09 15:00:00	DIA	ETF	109.8	110.14	109.75	110.08	713000.0
2006-01-09 16:00:00	DIA	ETF	110.07	110.07	109.87	109.88	2345600.0
2006-01-09 17:00:00	DIA	ETF	109.93	109.95	109.87	109.87	1500.0
2006-01-09 19:00:00	DIA	ETF	109.98	109.99	109.98	109.99	1000.0
2006-01-09 08:00:00	GLD	ETF	53.94	53.94	53.47	53.54	28300.0
2006-01-09 09:00:00	GLD	ETF	53.6	53.64	53.31	53.58	720200.0
2006-01-09 10:00:00	GLD	ETF	53.57	54.1	53.55	53.97	797800.0
2006-01-09 11:00:00	GLD	ETF	53.96	54.49	53.9493	54.44	652200.0
2006-01-09 12:00:00	GLD	ETF	54.42	54.6	54.35	54.57	618400.0

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

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