PREVIEW / etf_1hour / 2004-02-17

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-17.parquet
  size:    25 KB
  rows:    707

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-02-17 08:00:00	SPY	ETF	115.67	115.9	115.66	115.84	86000.0
2004-02-17 09:00:00	SPY	ETF	115.81	116.04	115.77	115.88	3158200.0
2004-02-17 10:00:00	SPY	ETF	115.89	116.07	115.78	115.99	3168200.0
2004-02-17 11:00:00	SPY	ETF	115.99	116.16	115.95	116.02	2294700.0
2004-02-17 12:00:00	SPY	ETF	116.01	116.31	116.0	116.19	2975800.0
2004-02-17 13:00:00	SPY	ETF	116.18	116.27	116.04	116.15	2830100.0
2004-02-17 14:00:00	SPY	ETF	116.19	116.43	116.12	116.38	2678700.0
2004-02-17 15:00:00	SPY	ETF	116.38	116.41	116.07	116.14	4789800.0
2004-02-17 16:00:00	SPY	ETF	116.14	116.33	116.1	116.33	1371500.0
2004-02-17 17:00:00	SPY	ETF	116.29	116.34	116.25	116.33	6400.0
2004-02-17 18:00:00	SPY	ETF	116.26	116.27	116.21	116.26	4600.0
2004-02-17 19:00:00	SPY	ETF	116.26	116.26	116.18	116.18	1300.0
2004-02-17 08:00:00	QQQ	ETF	37.19	37.28	37.17	37.26	110200.0
2004-02-17 09:00:00	QQQ	ETF	37.25	37.41	37.22	37.29	12422700.0
2004-02-17 10:00:00	QQQ	ETF	37.29	37.37	37.23	37.29	8309300.0
2004-02-17 11:00:00	QQQ	ETF	37.3	37.4	37.29	37.33	8202100.0
2004-02-17 12:00:00	QQQ	ETF	37.33	37.48	37.33	37.44	8973800.0
2004-02-17 13:00:00	QQQ	ETF	37.44	37.51	37.42	37.47	6124900.0
2004-02-17 14:00:00	QQQ	ETF	37.474	37.62	37.44	37.6	9397200.0
2004-02-17 15:00:00	QQQ	ETF	37.6	37.61	37.45	37.463	11662600.0
2004-02-17 16:00:00	QQQ	ETF	37.46	37.54	37.4	37.54	2572300.0
2004-02-17 17:00:00	QQQ	ETF	37.54	37.56	37.522	37.55	133300.0
2004-02-17 18:00:00	QQQ	ETF	37.55	37.56	37.51	37.51	81300.0
2004-02-17 19:00:00	QQQ	ETF	37.51	37.53	37.5	37.53	42400.0
2004-02-17 08:00:00	IWM	ETF	58.7	58.7	58.7	58.7	1000.0
2004-02-17 09:00:00	IWM	ETF	58.71	58.92	58.68	58.79	1384800.0
2004-02-17 10:00:00	IWM	ETF	58.79	58.995	58.77	58.915	688800.0
2004-02-17 11:00:00	IWM	ETF	58.92	59.03	58.88	59.01	401600.0
2004-02-17 12:00:00	IWM	ETF	59.025	59.2	59.005	59.015	528400.0
2004-02-17 13:00:00	IWM	ETF	59.05	59.1	59.015	59.095	155400.0
2004-02-17 14:00:00	IWM	ETF	59.095	59.275	59.07	59.235	419200.0
2004-02-17 15:00:00	IWM	ETF	59.235	59.28	59.08	59.16	2393000.0
2004-02-17 16:00:00	IWM	ETF	59.17	59.415	59.17	59.405	300600.0
2004-02-17 08:00:00	DIA	ETF	107.2	107.26	107.13	107.23	26500.0
2004-02-17 09:00:00	DIA	ETF	107.22	107.4	107.11	107.24	467200.0
2004-02-17 10:00:00	DIA	ETF	107.22	107.32	107.1	107.29	520600.0
2004-02-17 11:00:00	DIA	ETF	107.251	107.394	107.21	107.278	258900.0
2004-02-17 12:00:00	DIA	ETF	107.25	107.45	107.25	107.36	162400.0
2004-02-17 13:00:00	DIA	ETF	107.36	107.45	107.27	107.37	165800.0
2004-02-17 14:00:00	DIA	ETF	107.39	107.66	107.36	107.638	394000.0
2004-02-17 15:00:00	DIA	ETF	107.64	107.66	107.37	107.446	703800.0
2004-02-17 16:00:00	DIA	ETF	107.44	107.59	107.44	107.59	181400.0
2004-02-17 17:00:00	DIA	ETF	107.56	107.67	107.56	107.67	2100.0
2004-02-17 09:00:00	TLT	ETF	87.86	87.86	87.64	87.65	69800.0
2004-02-17 10:00:00	TLT	ETF	87.59	87.67	87.54	87.55	34800.0
2004-02-17 11:00:00	TLT	ETF	87.53	87.84	87.53	87.84	87500.0
2004-02-17 12:00:00	TLT	ETF	87.89	87.89	87.75	87.75	14400.0
2004-02-17 13:00:00	TLT	ETF	87.86	87.86	87.7	87.78	16700.0
2004-02-17 14:00:00	TLT	ETF	87.7	87.75	87.62	87.63	74800.0
2004-02-17 15:00:00	TLT	ETF	87.65	87.77	87.61	87.73	335200.0

> showing 50 of 707 rows — these rows as CSV

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