PREVIEW / etf_1hour / 2004-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-05-14.parquet
  size:    24 KB
  rows:    664

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-05-14 08:00:00	SPY	ETF	109.51	109.71	109.18	109.65	1040900.0
2004-05-14 09:00:00	SPY	ETF	109.68	110.44	109.65	109.74	8356000.0
2004-05-14 10:00:00	SPY	ETF	109.75	110.28	109.27	110.16	10270300.0
2004-05-14 11:00:00	SPY	ETF	110.19	110.265	109.67	109.79	4746500.0
2004-05-14 12:00:00	SPY	ETF	109.79	110.43	109.75	110.3	3683200.0
2004-05-14 13:00:00	SPY	ETF	110.31	110.7	110.23	110.36	6240700.0
2004-05-14 14:00:00	SPY	ETF	110.36	110.74	110.27	110.35	5377400.0
2004-05-14 15:00:00	SPY	ETF	110.36	110.36	109.93	110.04	5801300.0
2004-05-14 16:00:00	SPY	ETF	110.02	110.15	109.94	110.06	1581300.0
2004-05-14 17:00:00	SPY	ETF	110.08	110.12	110.08	110.12	600.0
2004-05-14 18:00:00	SPY	ETF	110.05	110.05	109.95	109.95	1300.0
2004-05-14 19:00:00	SPY	ETF	110.03	110.05	110.03	110.05	1500.0
2004-05-14 08:00:00	QQQ	ETF	34.95	35.11	34.84	35.08	872500.0
2004-05-14 09:00:00	QQQ	ETF	35.07	35.314	34.76	34.838	23678000.0
2004-05-14 10:00:00	QQQ	ETF	34.838	35.05	34.649	34.958	30846000.0
2004-05-14 11:00:00	QQQ	ETF	34.96	35.01	34.7	34.78	13746900.0
2004-05-14 12:00:00	QQQ	ETF	34.779	35.04	34.75	34.98	11294100.0
2004-05-14 13:00:00	QQQ	ETF	34.975	35.15	34.95	35.03	13702000.0
2004-05-14 14:00:00	QQQ	ETF	35.031	35.26	34.97	35.0	13417600.0
2004-05-14 15:00:00	QQQ	ETF	35.0	35.003	34.78	34.8	17960000.0
2004-05-14 16:00:00	QQQ	ETF	34.8	34.91	34.73	34.8	2959800.0
2004-05-14 17:00:00	QQQ	ETF	34.8	34.82	34.765	34.8	92600.0
2004-05-14 18:00:00	QQQ	ETF	34.81	34.83	34.8	34.82	27200.0
2004-05-14 19:00:00	QQQ	ETF	34.82	34.84	34.81	34.81	13600.0
2004-05-14 08:00:00	IWM	ETF	53.935	54.05	53.9	54.05	9600.0
2004-05-14 09:00:00	IWM	ETF	54.21	54.75	54.11	54.19	1792800.0
2004-05-14 10:00:00	IWM	ETF	54.11	54.575	53.835	54.575	3735400.0
2004-05-14 11:00:00	IWM	ETF	54.495	54.53	54.02	54.12	1428800.0
2004-05-14 12:00:00	IWM	ETF	54.13	54.71	54.095	54.71	2563600.0
2004-05-14 13:00:00	IWM	ETF	54.655	54.9	54.535	54.645	2169000.0
2004-05-14 14:00:00	IWM	ETF	54.6	54.885	54.515	54.55	2543600.0
2004-05-14 15:00:00	IWM	ETF	54.525	54.55	54.055	54.1	3964800.0
2004-05-14 16:00:00	IWM	ETF	54.025	54.23	54.005	54.05	332600.0
2004-05-14 08:00:00	DIA	ETF	99.8	100.05	99.6	100.05	87200.0
2004-05-14 09:00:00	DIA	ETF	100.07	100.69	100.0	100.03	1164500.0
2004-05-14 10:00:00	DIA	ETF	100.04	100.65	99.73	100.51	2065400.0
2004-05-14 11:00:00	DIA	ETF	100.51	100.58	100.1	100.19	641300.0
2004-05-14 12:00:00	DIA	ETF	100.19	100.73	100.18	100.62	591500.0
2004-05-14 13:00:00	DIA	ETF	100.641	100.9	100.55	100.69	725700.0
2004-05-14 14:00:00	DIA	ETF	100.66	101.0	100.55	100.62	755500.0
2004-05-14 15:00:00	DIA	ETF	100.63	100.63	100.3	100.49	1230300.0
2004-05-14 16:00:00	DIA	ETF	100.45	100.54	100.35	100.42	82200.0
2004-05-14 17:00:00	DIA	ETF	100.42	100.42	100.42	100.42	300.0
2004-05-14 18:00:00	DIA	ETF	100.5	100.5	100.5	100.5	500.0
2004-05-14 08:00:00	TLT	ETF	80.33	80.71	80.28	80.46	33000.0
2004-05-14 09:00:00	TLT	ETF	80.7	81.23	80.65	81.12	545200.0
2004-05-14 10:00:00	TLT	ETF	81.12	81.12	80.73	80.85	634500.0
2004-05-14 11:00:00	TLT	ETF	80.89	81.12	80.79	81.12	286900.0
2004-05-14 12:00:00	TLT	ETF	81.12	81.36	81.1	81.27	738700.0
2004-05-14 13:00:00	TLT	ETF	81.3	81.33	81.16	81.33	484600.0

> showing 50 of 664 rows — these rows as CSV

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