PREVIEW / etf_1hour / 2004-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-19.parquet
  size:    26 KB
  rows:    732

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-19 08:00:00	SPY	ETF	112.2	112.2	112.06	112.07	136000.0
2004-10-19 09:00:00	SPY	ETF	112.08	112.12	111.89	111.92	5073000.0
2004-10-19 10:00:00	SPY	ETF	111.92	112.23	111.68	111.73	10678300.0
2004-10-19 11:00:00	SPY	ETF	111.72	111.79	111.3	111.44	8419600.0
2004-10-19 12:00:00	SPY	ETF	111.45	111.7	111.43	111.54	3640400.0
2004-10-19 13:00:00	SPY	ETF	111.54	111.59	111.15	111.16	5940200.0
2004-10-19 14:00:00	SPY	ETF	111.16	111.22	110.78	110.86	6771100.0
2004-10-19 15:00:00	SPY	ETF	110.87	110.99	110.66	110.72	6522500.0
2004-10-19 16:00:00	SPY	ETF	110.73	110.77	110.59	110.64	2304900.0
2004-10-19 17:00:00	SPY	ETF	110.64	110.66	110.41	110.5	148900.0
2004-10-19 18:00:00	SPY	ETF	110.5	110.54	110.31	110.39	61100.0
2004-10-19 19:00:00	SPY	ETF	110.34	110.42	110.34	110.42	4200.0
2004-10-19 08:00:00	QQQ	ETF	36.5	36.52	36.4	36.42	1071300.0
2004-10-19 09:00:00	QQQ	ETF	36.42	36.45	36.31	36.36	16889600.0
2004-10-19 10:00:00	QQQ	ETF	36.36	36.57	36.336	36.41	24011800.0
2004-10-19 11:00:00	QQQ	ETF	36.41	36.47	36.19	36.314	18320500.0
2004-10-19 12:00:00	QQQ	ETF	36.31	36.4	36.26	36.3	9442400.0
2004-10-19 13:00:00	QQQ	ETF	36.3	36.4	36.16	36.17	12651000.0
2004-10-19 14:00:00	QQQ	ETF	36.17	36.19	35.93	36.0	20142200.0
2004-10-19 15:00:00	QQQ	ETF	36.0	36.09	35.89	35.91	19104000.0
2004-10-19 16:00:00	QQQ	ETF	35.91	35.951	35.79	35.83	5463000.0
2004-10-19 17:00:00	QQQ	ETF	35.83	35.86	35.77	35.77	470000.0
2004-10-19 18:00:00	QQQ	ETF	35.79	35.82	35.758	35.76	82600.0
2004-10-19 19:00:00	QQQ	ETF	35.78	35.79	35.78	35.79	8100.0
2004-10-19 08:00:00	IWM	ETF	57.325	57.375	57.325	57.375	3800.0
2004-10-19 09:00:00	IWM	ETF	57.385	57.5	57.235	57.34	2107400.0
2004-10-19 10:00:00	IWM	ETF	57.345	57.54	57.205	57.24	1994600.0
2004-10-19 11:00:00	IWM	ETF	57.255	57.28	56.95	57.04	1851800.0
2004-10-19 12:00:00	IWM	ETF	57.035	57.13	57.0	57.04	1136600.0
2004-10-19 13:00:00	IWM	ETF	57.015	57.015	56.665	56.69	1478200.0
2004-10-19 14:00:00	IWM	ETF	56.68	56.72	56.51	56.57	1795000.0
2004-10-19 15:00:00	IWM	ETF	56.57	56.655	56.4	56.43	2409200.0
2004-10-19 16:00:00	IWM	ETF	56.425	56.5	56.37	56.5	786600.0
2004-10-19 17:00:00	IWM	ETF	56.44	56.44	56.44	56.44	4000.0
2004-10-19 18:00:00	IWM	ETF	56.375	56.375	56.345	56.345	1400.0
2004-10-19 19:00:00	IWM	ETF	56.285	56.295	56.285	56.295	2000.0
2004-10-19 08:00:00	DIA	ETF	100.15	100.18	100.01	100.09	26300.0
2004-10-19 09:00:00	DIA	ETF	100.08	100.13	99.95	100.01	1163200.0
2004-10-19 10:00:00	DIA	ETF	100.04	100.37	99.83	99.88	1882000.0
2004-10-19 11:00:00	DIA	ETF	99.89	99.94	99.56	99.73	1469900.0
2004-10-19 12:00:00	DIA	ETF	99.73	99.99	99.71	99.88	686300.0
2004-10-19 13:00:00	DIA	ETF	99.87	99.87	99.46	99.48	675700.0
2004-10-19 14:00:00	DIA	ETF	99.49	99.55	99.12	99.17	1643000.0
2004-10-19 15:00:00	DIA	ETF	99.18	99.35	99.06	99.09	1577600.0
2004-10-19 16:00:00	DIA	ETF	99.06	99.14	99.02	99.09	104800.0
2004-10-19 17:00:00	DIA	ETF	99.01	99.08	98.98	98.99	1600.0
2004-10-19 18:00:00	DIA	ETF	99.05	99.09	98.84	98.87	3400.0
2004-10-19 19:00:00	DIA	ETF	98.9	98.9	98.9	98.9	900.0
2004-10-19 08:00:00	TLT	ETF	88.39	88.41	88.27	88.41	10600.0
2004-10-19 09:00:00	TLT	ETF	88.4	88.47	88.27	88.4	73600.0

> showing 50 of 732 rows — these rows as CSV

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