PREVIEW / etf_1hour / 2004-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-01.parquet
  size:    26 KB
  rows:    708

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-01 08:00:00	SPY	ETF	112.23	112.37	112.2	112.27	140900.0
2004-10-01 09:00:00	SPY	ETF	112.28	112.65	112.2	112.64	11526600.0
2004-10-01 10:00:00	SPY	ETF	112.64	113.25	112.55	113.25	14331900.0
2004-10-01 11:00:00	SPY	ETF	113.25	113.45	113.17	113.26	8082300.0
2004-10-01 12:00:00	SPY	ETF	113.28	113.45	113.23	113.37	2659800.0
2004-10-01 13:00:00	SPY	ETF	113.37	113.4	113.15	113.18	3498300.0
2004-10-01 14:00:00	SPY	ETF	113.18	113.5	113.1	113.44	4637200.0
2004-10-01 15:00:00	SPY	ETF	113.42	113.52	113.21	113.48	6688800.0
2004-10-01 16:00:00	SPY	ETF	113.49	113.73	113.44	113.73	2564400.0
2004-10-01 17:00:00	SPY	ETF	113.73	113.89	113.57	113.59	25200.0
2004-10-01 18:00:00	SPY	ETF	113.59	113.59	113.57	113.58	300.0
2004-10-01 08:00:00	QQQ	ETF	35.35	35.54	35.35	35.48	968200.0
2004-10-01 09:00:00	QQQ	ETF	35.49	35.56	35.36	35.54	15461100.0
2004-10-01 10:00:00	QQQ	ETF	35.53	35.91	35.53	35.89	28512800.0
2004-10-01 11:00:00	QQQ	ETF	35.89	36.1	35.89	36.028	20373200.0
2004-10-01 12:00:00	QQQ	ETF	36.028	36.09	35.99	36.04	8395400.0
2004-10-01 13:00:00	QQQ	ETF	36.03	36.056	35.95	35.97	7184000.0
2004-10-01 14:00:00	QQQ	ETF	35.97	36.14	35.93	36.1	13396600.0
2004-10-01 15:00:00	QQQ	ETF	36.1	36.15	36.0	36.11	17195100.0
2004-10-01 16:00:00	QQQ	ETF	36.11	36.15	36.07	36.14	3344100.0
2004-10-01 17:00:00	QQQ	ETF	36.13	36.17	36.11	36.15	92300.0
2004-10-01 18:00:00	QQQ	ETF	36.14	36.17	36.13	36.17	12900.0
2004-10-01 19:00:00	QQQ	ETF	36.16	36.17	36.16	36.17	8500.0
2004-10-01 08:00:00	IWM	ETF	57.32	57.32	57.32	57.32	7000.0
2004-10-01 09:00:00	IWM	ETF	57.35	57.45	57.215	57.45	1821000.0
2004-10-01 10:00:00	IWM	ETF	57.44	57.97	57.44	57.97	3858800.0
2004-10-01 11:00:00	IWM	ETF	57.945	58.1	57.92	58.02	1960200.0
2004-10-01 12:00:00	IWM	ETF	58.0	58.09	57.96	58.07	986000.0
2004-10-01 13:00:00	IWM	ETF	58.065	58.085	57.95	57.95	905400.0
2004-10-01 14:00:00	IWM	ETF	57.955	58.165	57.86	58.115	1895000.0
2004-10-01 15:00:00	IWM	ETF	58.095	58.375	58.035	58.36	2780800.0
2004-10-01 16:00:00	IWM	ETF	58.36	58.36	58.0289	58.36	1239200.0
2004-10-01 17:00:00	IWM	ETF	58.36	58.36	58.36	58.36	57400.0
2004-10-01 18:00:00	IWM	ETF	58.36	58.36	58.36	58.36	200.0
2004-10-01 08:00:00	DIA	ETF	101.28	101.43	101.24	101.31	35000.0
2004-10-01 09:00:00	DIA	ETF	101.32	101.51	101.22	101.45	1572200.0
2004-10-01 10:00:00	DIA	ETF	101.46	101.98	101.42	101.95	1530400.0
2004-10-01 11:00:00	DIA	ETF	101.96	102.08	101.89	101.98	808700.0
2004-10-01 12:00:00	DIA	ETF	101.98	102.01	101.89	101.97	252200.0
2004-10-01 13:00:00	DIA	ETF	101.96	102.0	101.77	101.8	403900.0
2004-10-01 14:00:00	DIA	ETF	101.81	102.1	101.71	102.05	813300.0
2004-10-01 15:00:00	DIA	ETF	102.04	102.18	101.87	102.02	1130700.0
2004-10-01 16:00:00	DIA	ETF	102.09	102.23	102.06	102.23	208300.0
2004-10-01 17:00:00	DIA	ETF	102.25	102.25	102.25	102.25	100.0
2004-10-01 08:00:00	TLT	ETF	87.68	87.68	87.45	87.5	74000.0
2004-10-01 09:00:00	TLT	ETF	87.45	87.6	87.44	87.5	261800.0
2004-10-01 10:00:00	TLT	ETF	87.54	87.58	87.29	87.46	735900.0
2004-10-01 11:00:00	TLT	ETF	87.43	87.53	87.42	87.45	111100.0
2004-10-01 12:00:00	TLT	ETF	87.5	87.63	87.41	87.41	241800.0
2004-10-01 13:00:00	TLT	ETF	87.41	87.46	87.33	87.44	87100.0

> showing 50 of 708 rows — these rows as CSV

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