PREVIEW / etf_1hour / 2004-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-15.parquet
  size:    25 KB
  rows:    714

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-15 08:00:00	SPY	ETF	110.68	110.95	110.67	110.88	203000.0
2004-10-15 09:00:00	SPY	ETF	110.88	111.11	110.58	110.72	8199100.0
2004-10-15 10:00:00	SPY	ETF	110.71	111.15	110.65	111.06	12053300.0
2004-10-15 11:00:00	SPY	ETF	111.05	111.07	110.83	110.91	4788600.0
2004-10-15 12:00:00	SPY	ETF	110.91	111.54	110.74	111.43	17242000.0
2004-10-15 13:00:00	SPY	ETF	111.43	111.74	111.36	111.6	3634600.0
2004-10-15 14:00:00	SPY	ETF	111.6	111.65	111.23	111.31	5713200.0
2004-10-15 15:00:00	SPY	ETF	111.31	111.44	111.05	111.17	7235500.0
2004-10-15 16:00:00	SPY	ETF	111.19	111.34	111.13	111.3	1737300.0
2004-10-15 17:00:00	SPY	ETF	111.33	111.35	111.23	111.23	1200.0
2004-10-15 19:00:00	SPY	ETF	111.24	111.35	111.24	111.35	600.0
2004-10-15 08:00:00	QQQ	ETF	35.42	35.51	35.38	35.49	674400.0
2004-10-15 09:00:00	QQQ	ETF	35.49	35.62	35.34	35.43	15580700.0
2004-10-15 10:00:00	QQQ	ETF	35.431	35.6	35.36	35.54	23924100.0
2004-10-15 11:00:00	QQQ	ETF	35.55	35.55	35.4	35.425	9169800.0
2004-10-15 12:00:00	QQQ	ETF	35.425	35.72	35.28	35.65	19431500.0
2004-10-15 13:00:00	QQQ	ETF	35.65	35.856	35.62	35.72	16442400.0
2004-10-15 14:00:00	QQQ	ETF	35.73	35.772	35.566	35.62	10767200.0
2004-10-15 15:00:00	QQQ	ETF	35.62	35.65	35.46	35.58	16195400.0
2004-10-15 16:00:00	QQQ	ETF	35.585	35.68	35.57	35.68	2623000.0
2004-10-15 17:00:00	QQQ	ETF	35.674	35.7	35.65	35.69	28900.0
2004-10-15 18:00:00	QQQ	ETF	35.68	35.699	35.66	35.68	5500.0
2004-10-15 19:00:00	QQQ	ETF	35.68	35.71	35.67	35.71	5000.0
2004-10-15 08:00:00	IWM	ETF	56.27	56.46	56.27	56.46	4800.0
2004-10-15 09:00:00	IWM	ETF	56.44	56.58	56.145	56.185	2516800.0
2004-10-15 10:00:00	IWM	ETF	56.175	56.56	56.15	56.55	2272200.0
2004-10-15 11:00:00	IWM	ETF	56.55	56.57	56.44	56.475	1260800.0
2004-10-15 12:00:00	IWM	ETF	56.485	56.975	56.335	56.94	2618400.0
2004-10-15 13:00:00	IWM	ETF	56.945	57.115	56.88	57.03	1584600.0
2004-10-15 14:00:00	IWM	ETF	57.03	57.125	56.745	56.84	1931600.0
2004-10-15 15:00:00	IWM	ETF	56.85	56.915	56.595	56.84	2487600.0
2004-10-15 16:00:00	IWM	ETF	56.8	56.885	56.47	56.81	505200.0
2004-10-15 08:00:00	DIA	ETF	99.09	99.3	99.0	99.3	22400.0
2004-10-15 09:00:00	DIA	ETF	99.3	99.42	99.07	99.2	959300.0
2004-10-15 10:00:00	DIA	ETF	99.2	99.57	99.15	99.48	1585300.0
2004-10-15 11:00:00	DIA	ETF	99.49	99.49	99.27	99.31	970000.0
2004-10-15 12:00:00	DIA	ETF	99.31	99.81	99.16	99.75	1186600.0
2004-10-15 13:00:00	DIA	ETF	99.76	99.95	99.68	99.8	626200.0
2004-10-15 14:00:00	DIA	ETF	99.81	99.88	99.48	99.58	771900.0
2004-10-15 15:00:00	DIA	ETF	99.58	99.69	99.37	99.43	969100.0
2004-10-15 16:00:00	DIA	ETF	99.43	99.51	99.42	99.49	117700.0
2004-10-15 17:00:00	DIA	ETF	99.49	99.49	99.49	99.49	400.0
2004-10-15 08:00:00	TLT	ETF	89.05	89.18	88.73	88.88	92800.0
2004-10-15 09:00:00	TLT	ETF	88.88	89.02	88.76	88.89	143200.0
2004-10-15 10:00:00	TLT	ETF	88.81	88.96	88.65	88.67	28600.0
2004-10-15 11:00:00	TLT	ETF	88.66	88.72	88.61	88.7	30700.0
2004-10-15 12:00:00	TLT	ETF	88.71	88.86	88.18	88.27	114800.0
2004-10-15 13:00:00	TLT	ETF	88.24	88.54	88.24	88.42	126500.0
2004-10-15 14:00:00	TLT	ETF	88.42	88.68	88.39	88.65	67200.0
2004-10-15 15:00:00	TLT	ETF	88.68	88.75	88.62	88.67	125600.0

> showing 50 of 714 rows — these rows as CSV

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