PREVIEW / etf_1hour / 2004-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-30.parquet
  size:    25 KB
  rows:    706

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-09-30 08:00:00	SPY	ETF	111.9	111.9	111.62	111.62	138800.0
2004-09-30 09:00:00	SPY	ETF	111.57	111.76	111.43	111.67	5947800.0
2004-09-30 10:00:00	SPY	ETF	111.67	111.82	111.51	111.52	6424100.0
2004-09-30 11:00:00	SPY	ETF	111.53	111.57	111.33	111.36	3889400.0
2004-09-30 12:00:00	SPY	ETF	111.37	111.5	111.26	111.38	3569500.0
2004-09-30 13:00:00	SPY	ETF	111.38	111.69	111.31	111.67	2617400.0
2004-09-30 14:00:00	SPY	ETF	111.67	111.93	111.6	111.9	2956100.0
2004-09-30 15:00:00	SPY	ETF	111.9	111.98	111.48	111.74	9294200.0
2004-09-30 16:00:00	SPY	ETF	111.74	111.8	111.64	111.71	6348800.0
2004-09-30 17:00:00	SPY	ETF	111.71	111.81	111.71	111.8	65600.0
2004-09-30 18:00:00	SPY	ETF	111.81	111.81	111.79	111.81	15500.0
2004-09-30 19:00:00	SPY	ETF	111.8	111.8	111.79	111.79	1300.0
2004-09-30 08:00:00	QQQ	ETF	35.14	35.15	35.05	35.06	224600.0
2004-09-30 09:00:00	QQQ	ETF	35.05	35.24	34.99	35.172	13361200.0
2004-09-30 10:00:00	QQQ	ETF	35.173	35.27	35.07	35.092	14277800.0
2004-09-30 11:00:00	QQQ	ETF	35.098	35.116	34.91	34.93	10033000.0
2004-09-30 12:00:00	QQQ	ETF	34.93	35.02	34.89	34.988	5698100.0
2004-09-30 13:00:00	QQQ	ETF	34.99	35.17	34.95	35.13	6404400.0
2004-09-30 14:00:00	QQQ	ETF	35.13	35.23	35.1	35.22	6445600.0
2004-09-30 15:00:00	QQQ	ETF	35.21	35.25	35.05	35.12	13185200.0
2004-09-30 16:00:00	QQQ	ETF	35.12	35.1696	35.05	35.11	2806300.0
2004-09-30 17:00:00	QQQ	ETF	35.1	35.15	35.09	35.12	192300.0
2004-09-30 18:00:00	QQQ	ETF	35.11	35.14	35.1	35.12	128400.0
2004-09-30 19:00:00	QQQ	ETF	35.13	35.14	35.13	35.14	800.0
2004-09-30 08:00:00	IWM	ETF	56.88	56.9	56.88	56.88	50600.0
2004-09-30 09:00:00	IWM	ETF	56.88	57.125	56.655	57.065	4507400.0
2004-09-30 10:00:00	IWM	ETF	57.065	57.2	57.005	57.03	1253000.0
2004-09-30 11:00:00	IWM	ETF	57.02	57.035	56.85	56.88	2493200.0
2004-09-30 12:00:00	IWM	ETF	56.905	56.92	56.79	56.835	1398000.0
2004-09-30 13:00:00	IWM	ETF	56.84	57.1	56.82	57.08	1141800.0
2004-09-30 14:00:00	IWM	ETF	57.065	57.275	56.99	57.27	1203000.0
2004-09-30 15:00:00	IWM	ETF	57.27	57.3	56.885	56.94	3178400.0
2004-09-30 16:00:00	IWM	ETF	56.94	57.09	56.88	56.975	744200.0
2004-09-30 17:00:00	IWM	ETF	56.975	57.0	56.975	57.0	5600.0
2004-09-30 19:00:00	IWM	ETF	56.98	56.98	56.98	56.98	400.0
2004-09-30 08:00:00	DIA	ETF	101.56	101.56	100.78	100.81	67400.0
2004-09-30 09:00:00	DIA	ETF	100.79	100.97	100.62	100.93	1277900.0
2004-09-30 10:00:00	DIA	ETF	100.91	101.01	100.7	100.71	1075500.0
2004-09-30 11:00:00	DIA	ETF	100.71	100.74	100.6	100.63	647000.0
2004-09-30 12:00:00	DIA	ETF	100.64	100.71	100.55	100.6184	387800.0
2004-09-30 13:00:00	DIA	ETF	100.6	100.88	100.57	100.86	381200.0
2004-09-30 14:00:00	DIA	ETF	100.86	101.03	100.75	101.01	587900.0
2004-09-30 15:00:00	DIA	ETF	101.02	101.07	100.64	100.86	1657300.0
2004-09-30 16:00:00	DIA	ETF	100.86	100.93	100.82	100.85	271800.0
2004-09-30 17:00:00	DIA	ETF	100.84	100.85	100.84	100.85	1000.0
2004-09-30 18:00:00	DIA	ETF	100.8	100.8	100.8	100.8	400.0
2004-09-30 08:00:00	TLT	ETF	88.76	88.95	88.76	88.9	5100.0
2004-09-30 09:00:00	TLT	ETF	88.47	88.47	88.0	88.1	325000.0
2004-09-30 10:00:00	TLT	ETF	88.06	88.17	87.96	88.17	730000.0
2004-09-30 11:00:00	TLT	ETF	88.17	88.22	88.07	88.11	203000.0

> showing 50 of 706 rows — these rows as CSV

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