PREVIEW / etf_1hour / 2004-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-29.parquet
  size:    27 KB
  rows:    791

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
2004-12-29 08:00:00	SPY	ETF	121.14	121.2	121.12	121.16	272700.0
2004-12-29 09:00:00	SPY	ETF	121.16	121.18	120.99	121.06	2113000.0
2004-12-29 10:00:00	SPY	ETF	121.06	121.23	121.03	121.14	3386400.0
2004-12-29 11:00:00	SPY	ETF	121.14	121.33	121.07	121.1	2180600.0
2004-12-29 12:00:00	SPY	ETF	121.1	121.15	121.01	121.04	2864000.0
2004-12-29 13:00:00	SPY	ETF	121.04	121.1	120.95	121.07	2970700.0
2004-12-29 14:00:00	SPY	ETF	121.07	121.16	121.03	121.1	1713600.0
2004-12-29 15:00:00	SPY	ETF	121.1	121.3	121.07	121.29	3417300.0
2004-12-29 16:00:00	SPY	ETF	121.27	121.4	121.22	121.37	3299000.0
2004-12-29 17:00:00	SPY	ETF	121.38	121.39	121.24	121.38	1144300.0
2004-12-29 18:00:00	SPY	ETF	121.37	121.37	121.33	121.33	1200.0
2004-12-29 19:00:00	SPY	ETF	121.36	121.36	121.35	121.35	2300.0
2004-12-29 08:00:00	QQQ	ETF	39.95	39.98	39.95	39.97	154296.0
2004-12-29 09:00:00	QQQ	ETF	39.97	40.01	39.9	39.98	6439738.0
2004-12-29 10:00:00	QQQ	ETF	39.99	40.14	39.97	40.076	10140327.0
2004-12-29 11:00:00	QQQ	ETF	40.075	40.16	39.99	40.01	7297332.0
2004-12-29 12:00:00	QQQ	ETF	40.01	40.03	39.94	39.962	4326825.0
2004-12-29 13:00:00	QQQ	ETF	39.96	40.02	39.9	39.974	4919430.0
2004-12-29 14:00:00	QQQ	ETF	39.973	40.01	39.93	39.969	3495569.0
2004-12-29 15:00:00	QQQ	ETF	39.97	40.04	39.9399	40.01	7598557.0
2004-12-29 16:00:00	QQQ	ETF	40.01	40.061	39.99	40.04	1959387.0
2004-12-29 17:00:00	QQQ	ETF	40.05	40.05	40.03	40.05	6916.0
2004-12-29 18:00:00	QQQ	ETF	40.05	40.07	40.05	40.07	10933.0
2004-12-29 08:00:00	IWM	ETF	65.025	65.025	65.025	65.025	1800.0
2004-12-29 09:00:00	IWM	ETF	65.0	65.015	64.86	64.945	1221000.0
2004-12-29 10:00:00	IWM	ETF	64.95	65.09	64.89	65.025	1510200.0
2004-12-29 11:00:00	IWM	ETF	65.025	65.1549	64.925	64.975	880400.0
2004-12-29 12:00:00	IWM	ETF	64.98	65.025	64.9	64.905	414200.0
2004-12-29 13:00:00	IWM	ETF	64.895	65.015	64.805	64.965	822600.0
2004-12-29 14:00:00	IWM	ETF	64.9601	65.075	64.895	64.94	1080400.0
2004-12-29 15:00:00	IWM	ETF	64.933	65.2	64.93	65.045	1449000.0
2004-12-29 16:00:00	IWM	ETF	65.04	65.085	64.935	65.06	1506800.0
2004-12-29 17:00:00	IWM	ETF	65.035	65.035	65.035	65.035	400.0
2004-12-29 08:00:00	DIA	ETF	108.37	108.38	108.35	108.35	1200.0
2004-12-29 09:00:00	DIA	ETF	108.34	108.37	108.09	108.1464	415800.0
2004-12-29 10:00:00	DIA	ETF	108.15	108.23	107.97	108.07	764700.0
2004-12-29 11:00:00	DIA	ETF	108.07	108.19	107.96	107.99	426100.0
2004-12-29 12:00:00	DIA	ETF	107.98	108.07	107.96	107.98	209300.0
2004-12-29 13:00:00	DIA	ETF	107.98	108.0	107.83	107.92	460600.0
2004-12-29 14:00:00	DIA	ETF	107.92	108.08	107.91	108.04	368700.0
2004-12-29 15:00:00	DIA	ETF	108.06	108.16	108.01	108.14	961800.0
2004-12-29 16:00:00	DIA	ETF	108.13	108.27	108.0	108.22	429500.0
2004-12-29 17:00:00	DIA	ETF	108.24	108.24	108.24	108.24	200.0
2004-12-29 19:00:00	DIA	ETF	108.24	108.24	108.24	108.24	900.0
2004-12-29 09:00:00	GLD	ETF	43.92	43.95	43.82	43.87	635500.0
2004-12-29 10:00:00	GLD	ETF	43.87	44.02	43.82	43.85	395800.0
2004-12-29 11:00:00	GLD	ETF	43.85	43.85	43.38	43.49	542400.0
2004-12-29 12:00:00	GLD	ETF	43.5	43.61	43.49	43.58	2154700.0
2004-12-29 13:00:00	GLD	ETF	43.59	43.67	43.52	43.62	842500.0
2004-12-29 14:00:00	GLD	ETF	43.63	43.72	43.63	43.67	490700.0

> showing 50 of 791 rows — these rows as CSV

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