PREVIEW / etf_1hour / 2004-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-31.parquet
  size:    26 KB
  rows:    779

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-31 08:00:00	SPY	ETF	121.32	121.38	121.28	121.29	45100.0
2004-12-31 09:00:00	SPY	ETF	121.29	121.44	121.2	121.3	2363900.0
2004-12-31 10:00:00	SPY	ETF	121.3	121.4	121.25	121.36	2288000.0
2004-12-31 11:00:00	SPY	ETF	121.36	121.38	121.27	121.33	1795200.0
2004-12-31 12:00:00	SPY	ETF	121.34	121.36	121.16	121.18	1868000.0
2004-12-31 13:00:00	SPY	ETF	121.18	121.32	121.17	121.29	1603900.0
2004-12-31 14:00:00	SPY	ETF	121.3	121.66	121.29	121.48	4134900.0
2004-12-31 15:00:00	SPY	ETF	121.48	121.54	121.03	121.04	5905900.0
2004-12-31 16:00:00	SPY	ETF	121.04	121.11	120.77	120.85	3259400.0
2004-12-31 17:00:00	SPY	ETF	120.84	120.88	120.82	120.86	7700.0
2004-12-31 08:00:00	QQQ	ETF	40.037	40.05	40.02	40.03	84113.0
2004-12-31 09:00:00	QQQ	ETF	40.03	40.11	40.0	40.0701	5844882.0
2004-12-31 10:00:00	QQQ	ETF	40.07	40.121	40.04	40.08	5390385.0
2004-12-31 11:00:00	QQQ	ETF	40.07	40.09	40.01	40.033	3549274.0
2004-12-31 12:00:00	QQQ	ETF	40.04	40.07	39.94	39.963	4241154.0
2004-12-31 13:00:00	QQQ	ETF	39.963	40.06	39.963	40.041	4160496.0
2004-12-31 14:00:00	QQQ	ETF	40.05	40.121	40.03	40.05	5404048.0
2004-12-31 15:00:00	QQQ	ETF	40.05	40.075	39.9	39.92	12017434.0
2004-12-31 16:00:00	QQQ	ETF	39.919	39.93	39.76	39.91	1687541.0
2004-12-31 17:00:00	QQQ	ETF	39.91	39.91	39.84	39.85	62760.0
2004-12-31 18:00:00	QQQ	ETF	39.87	39.89	39.86	39.89	7400.0
2004-12-31 08:00:00	IWM	ETF	64.965	64.965	64.965	64.965	1000.0
2004-12-31 09:00:00	IWM	ETF	64.99	65.0	64.745	64.815	2118800.0
2004-12-31 10:00:00	IWM	ETF	64.81	64.915	64.8	64.89	1353800.0
2004-12-31 11:00:00	IWM	ETF	64.895	64.995	64.885	64.975	618600.0
2004-12-31 12:00:00	IWM	ETF	64.975	65.02	64.94	64.955	1409600.0
2004-12-31 13:00:00	IWM	ETF	64.955	65.125	64.95	65.095	894600.0
2004-12-31 14:00:00	IWM	ETF	65.09	65.33	65.09	65.165	2456600.0
2004-12-31 15:00:00	IWM	ETF	65.165	65.18	64.68	64.69	4198800.0
2004-12-31 16:00:00	IWM	ETF	64.71	64.88	64.67	64.73	1203400.0
2004-12-31 17:00:00	IWM	ETF	64.715	64.715	64.715	64.715	600.0
2004-12-31 08:00:00	DIA	ETF	108.02	108.02	108.02	108.02	100.0
2004-12-31 09:00:00	DIA	ETF	107.98	108.01	107.85	107.92	513300.0
2004-12-31 10:00:00	DIA	ETF	107.92	107.99	107.86	107.96	184000.0
2004-12-31 11:00:00	DIA	ETF	107.97	107.98	107.88	107.95	255900.0
2004-12-31 12:00:00	DIA	ETF	107.95	107.98	107.78	107.79	329300.0
2004-12-31 13:00:00	DIA	ETF	107.78	107.93	107.78	107.91	205500.0
2004-12-31 14:00:00	DIA	ETF	107.91	108.19	107.9	108.05	527500.0
2004-12-31 15:00:00	DIA	ETF	108.07	108.17	107.7	107.73	1745200.0
2004-12-31 16:00:00	DIA	ETF	107.73	107.75	107.47	107.48	482000.0
2004-12-31 17:00:00	DIA	ETF	107.47	107.55	107.47	107.55	2000.0
2004-12-31 09:00:00	GLD	ETF	43.85	43.94	43.85	43.92	36100.0
2004-12-31 10:00:00	GLD	ETF	43.9	43.94	43.83	43.92	96000.0
2004-12-31 11:00:00	GLD	ETF	43.92	43.92	43.75	43.77	97400.0
2004-12-31 12:00:00	GLD	ETF	43.76	43.8	43.73	43.77	31400.0
2004-12-31 13:00:00	GLD	ETF	43.77	43.86	43.77	43.86	85700.0
2004-12-31 14:00:00	GLD	ETF	43.86	43.88	43.81	43.86	71000.0
2004-12-31 15:00:00	GLD	ETF	43.85	43.87	43.799	43.84	108300.0
2004-12-31 16:00:00	GLD	ETF	43.83	43.83	43.8	43.8	700.0
2004-12-31 08:00:00	TLT	ETF	88.24	88.24	88.21	88.21	10300.0

> showing 50 of 779 rows — these rows as CSV

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