PREVIEW / etf_1hour / 2004-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-08.parquet
  size:    27 KB
  rows:    768

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-08 08:00:00	SPY	ETF	118.09	118.24	118.07	118.17	184600.0
2004-12-08 09:00:00	SPY	ETF	118.17	118.37	118.01	118.28	6853800.0
2004-12-08 10:00:00	SPY	ETF	118.28	118.54	118.18	118.25	8859800.0
2004-12-08 11:00:00	SPY	ETF	118.24	118.66	118.13	118.48	5221700.0
2004-12-08 12:00:00	SPY	ETF	118.48	118.66	118.37	118.58	5553300.0
2004-12-08 13:00:00	SPY	ETF	118.59	118.81	118.55	118.73	3888300.0
2004-12-08 14:00:00	SPY	ETF	118.74	118.82	118.47	118.55	4050600.0
2004-12-08 15:00:00	SPY	ETF	118.55	118.72	118.37	118.62	5055600.0
2004-12-08 16:00:00	SPY	ETF	118.62	118.8	118.48	118.48	2161700.0
2004-12-08 17:00:00	SPY	ETF	118.5	118.6	118.45	118.59	65000.0
2004-12-08 18:00:00	SPY	ETF	118.57	118.6	118.56	118.56	1900.0
2004-12-08 19:00:00	SPY	ETF	118.55	118.6	118.54	118.6	3800.0
2004-12-08 08:00:00	QQQ	ETF	39.56	39.67	39.56	39.65	1247331.0
2004-12-08 09:00:00	QQQ	ETF	39.66	39.72	39.5	39.685	12874851.0
2004-12-08 10:00:00	QQQ	ETF	39.69	39.85	39.63	39.72	16678573.0
2004-12-08 11:00:00	QQQ	ETF	39.707	39.91	39.63	39.83	10752292.0
2004-12-08 12:00:00	QQQ	ETF	39.83	39.9	39.75	39.89	10354904.0
2004-12-08 13:00:00	QQQ	ETF	39.89	39.98	39.82	39.89	9711276.0
2004-12-08 14:00:00	QQQ	ETF	39.882	39.92	39.76	39.79	9034182.0
2004-12-08 15:00:00	QQQ	ETF	39.79	39.86	39.71	39.811	12648381.0
2004-12-08 16:00:00	QQQ	ETF	39.818	39.86	39.57	39.61	6910377.0
2004-12-08 17:00:00	QQQ	ETF	39.6	39.68	39.6	39.67	294310.0
2004-12-08 18:00:00	QQQ	ETF	39.67	39.68	39.63	39.68	56968.0
2004-12-08 08:00:00	IWM	ETF	62.52	62.52	62.44	62.44	16600.0
2004-12-08 09:00:00	IWM	ETF	62.49	62.635	62.3	62.435	1655000.0
2004-12-08 10:00:00	IWM	ETF	62.455	62.83	62.445	62.66	2559000.0
2004-12-08 11:00:00	IWM	ETF	62.64	62.83	62.57	62.655	1216600.0
2004-12-08 12:00:00	IWM	ETF	62.655	62.75	62.59	62.735	552000.0
2004-12-08 13:00:00	IWM	ETF	62.74	63.055	62.73	62.97	1478800.0
2004-12-08 14:00:00	IWM	ETF	62.975	63.035	62.84	62.855	972400.0
2004-12-08 15:00:00	IWM	ETF	62.85	63.01	62.69	62.98	1856000.0
2004-12-08 16:00:00	IWM	ETF	62.98	63.1	62.925	62.99	272400.0
2004-12-08 08:00:00	DIA	ETF	104.45	104.59	104.43	104.53	12300.0
2004-12-08 09:00:00	DIA	ETF	104.6	104.71	104.42	104.68	1374900.0
2004-12-08 10:00:00	DIA	ETF	104.65	104.84	104.55	104.6	1163600.0
2004-12-08 11:00:00	DIA	ETF	104.58	104.95	104.5	104.83	993700.0
2004-12-08 12:00:00	DIA	ETF	104.84	104.93	104.74	104.83	709600.0
2004-12-08 13:00:00	DIA	ETF	104.81	105.05	104.8	104.99	683500.0
2004-12-08 14:00:00	DIA	ETF	104.97	105.06	104.76	104.83	917700.0
2004-12-08 15:00:00	DIA	ETF	104.84	104.96	104.7	104.91	984000.0
2004-12-08 16:00:00	DIA	ETF	104.9	105.03	104.88	104.88	115000.0
2004-12-08 17:00:00	DIA	ETF	104.9	104.9	104.9	104.9	100.0
2004-12-08 09:00:00	GLD	ETF	43.8	43.89	43.55	43.69	1152500.0
2004-12-08 10:00:00	GLD	ETF	43.7	43.86	43.64	43.65	1139600.0
2004-12-08 11:00:00	GLD	ETF	43.64	43.65	43.36	43.5	1338200.0
2004-12-08 12:00:00	GLD	ETF	43.49	43.75	43.37	43.74	917900.0
2004-12-08 13:00:00	GLD	ETF	43.75	43.78	43.65	43.72	302100.0
2004-12-08 14:00:00	GLD	ETF	43.73	43.94	43.724	43.9	378500.0
2004-12-08 15:00:00	GLD	ETF	43.88	44.02	43.8	43.97	608000.0
2004-12-08 16:00:00	GLD	ETF	43.98	44.02	43.97	44.01	60400.0

> showing 50 of 768 rows — these rows as CSV

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