PREVIEW / etf_1hour / 2004-10-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-25.parquet
  size:    26 KB
  rows:    752

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-10-25 08:00:00	SPY	ETF	109.58	109.67	109.48	109.66	109800.0
2004-10-25 09:00:00	SPY	ETF	109.71	109.8	109.43	109.47	6855500.0
2004-10-25 10:00:00	SPY	ETF	109.48	109.89	109.35	109.81	7838800.0
2004-10-25 11:00:00	SPY	ETF	109.79	109.82	109.47	109.56	4240000.0
2004-10-25 12:00:00	SPY	ETF	109.55	109.75	109.43	109.74	3927900.0
2004-10-25 13:00:00	SPY	ETF	109.74	110.12	109.7	109.94	5304800.0
2004-10-25 14:00:00	SPY	ETF	109.95	110.07	109.73	109.8	4672500.0
2004-10-25 15:00:00	SPY	ETF	109.8	110.12	109.72	109.87	6746200.0
2004-10-25 16:00:00	SPY	ETF	109.87	110.21	109.81	110.14	2312000.0
2004-10-25 17:00:00	SPY	ETF	110.14	110.18	110.0	110.01	225500.0
2004-10-25 18:00:00	SPY	ETF	110.09	110.19	110.09	110.19	6500.0
2004-10-25 19:00:00	SPY	ETF	110.19	110.19	110.14	110.14	1400.0
2004-10-25 08:00:00	QQQ	ETF	35.75	35.75	35.61	35.72	300500.0
2004-10-25 09:00:00	QQQ	ETF	35.72	35.787	35.57	35.6	16621500.0
2004-10-25 10:00:00	QQQ	ETF	35.61	35.79	35.53	35.683	24971200.0
2004-10-25 11:00:00	QQQ	ETF	35.67	35.7	35.51	35.58	13771600.0
2004-10-25 12:00:00	QQQ	ETF	35.574	35.642	35.49	35.64	8673400.0
2004-10-25 13:00:00	QQQ	ETF	35.64	35.8	35.63	35.71	10341800.0
2004-10-25 14:00:00	QQQ	ETF	35.71	35.74	35.55	35.618	11582400.0
2004-10-25 15:00:00	QQQ	ETF	35.61	35.73	35.57	35.62	12117500.0
2004-10-25 16:00:00	QQQ	ETF	35.62	35.7	35.586	35.65	2357200.0
2004-10-25 17:00:00	QQQ	ETF	35.68	35.68	35.642	35.65	322000.0
2004-10-25 18:00:00	QQQ	ETF	35.65	35.66	35.62	35.66	63600.0
2004-10-25 19:00:00	QQQ	ETF	35.66	35.67	35.65	35.65	28400.0
2004-10-25 08:00:00	IWM	ETF	56.17	56.17	56.14	56.14	2400.0
2004-10-25 09:00:00	IWM	ETF	56.2	56.63	56.2	56.36	2605400.0
2004-10-25 10:00:00	IWM	ETF	56.375	56.785	56.355	56.745	2972200.0
2004-10-25 11:00:00	IWM	ETF	56.75	56.765	56.55	56.57	2115800.0
2004-10-25 12:00:00	IWM	ETF	56.57	56.85	56.49	56.84	1057200.0
2004-10-25 13:00:00	IWM	ETF	56.845	57.225	56.845	57.04	1930000.0
2004-10-25 14:00:00	IWM	ETF	57.06	57.1	56.875	56.945	1111600.0
2004-10-25 15:00:00	IWM	ETF	56.94	57.03	56.835	56.99	1988400.0
2004-10-25 16:00:00	IWM	ETF	56.98	57.37	56.98	57.22	612600.0
2004-10-25 08:00:00	DIA	ETF	97.35	97.59	97.29	97.59	13000.0
2004-10-25 09:00:00	DIA	ETF	97.57	97.66	97.33	97.37	1199000.0
2004-10-25 10:00:00	DIA	ETF	97.36	97.75	97.27	97.69	1501300.0
2004-10-25 11:00:00	DIA	ETF	97.7	97.73	97.41	97.49	784100.0
2004-10-25 12:00:00	DIA	ETF	97.49	97.68	97.4	97.67	788400.0
2004-10-25 13:00:00	DIA	ETF	97.66	97.96	97.64	97.82	1152400.0
2004-10-25 14:00:00	DIA	ETF	97.84	97.97	97.67	97.71	855300.0
2004-10-25 15:00:00	DIA	ETF	97.71	97.89	97.64	97.67	1351200.0
2004-10-25 16:00:00	DIA	ETF	97.66	98.0	97.6	97.93	710000.0
2004-10-25 17:00:00	DIA	ETF	97.9	97.9	97.8	97.8	16400.0
2004-10-25 08:00:00	TLT	ETF	90.0	90.03	90.0	90.03	1600.0
2004-10-25 09:00:00	TLT	ETF	90.07	90.07	89.95	89.99	14200.0
2004-10-25 10:00:00	TLT	ETF	89.96	89.99	89.8	89.9	58600.0
2004-10-25 11:00:00	TLT	ETF	89.92	90.01	89.87	90.0	26500.0
2004-10-25 12:00:00	TLT	ETF	90.02	90.09	90.02	90.05	51700.0
2004-10-25 13:00:00	TLT	ETF	90.03	90.03	89.87	89.88	29800.0
2004-10-25 14:00:00	TLT	ETF	89.87	89.89	89.82	89.85	25500.0

> showing 50 of 752 rows — these rows as CSV

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