PREVIEW / etf_1hour / 2004-07-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-07.parquet
  size:    25 KB
  rows:    703

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-07-07 08:00:00	SPY	ETF	112.06	112.06	111.82	111.83	27600.0
2004-07-07 09:00:00	SPY	ETF	111.83	112.22	111.75	112.07	3993900.0
2004-07-07 10:00:00	SPY	ETF	112.08	112.37	111.99	112.06	4671300.0
2004-07-07 11:00:00	SPY	ETF	112.06	112.17	111.86	111.96	3302400.0
2004-07-07 12:00:00	SPY	ETF	111.96	112.08	111.89	111.99	2205100.0
2004-07-07 13:00:00	SPY	ETF	112.0	112.37	111.92	112.32	3532800.0
2004-07-07 14:00:00	SPY	ETF	112.32	112.57	112.2	112.45	3715500.0
2004-07-07 15:00:00	SPY	ETF	112.45	112.51	112.07	112.14	4292900.0
2004-07-07 16:00:00	SPY	ETF	112.15	112.29	111.5	111.58	2787700.0
2004-07-07 17:00:00	SPY	ETF	111.58	111.62	111.53	111.53	170700.0
2004-07-07 18:00:00	SPY	ETF	111.58	111.58	111.41	111.47	100700.0
2004-07-07 19:00:00	SPY	ETF	111.5	111.61	111.5	111.51	6200.0
2004-07-07 08:00:00	QQQ	ETF	36.14	36.14	36.0	36.02	84200.0
2004-07-07 09:00:00	QQQ	ETF	36.01	36.24	35.92	36.17	17364300.0
2004-07-07 10:00:00	QQQ	ETF	36.166	36.25	36.08	36.1	12266800.0
2004-07-07 11:00:00	QQQ	ETF	36.1	36.15	35.96	36.05	9112600.0
2004-07-07 12:00:00	QQQ	ETF	36.05	36.12	35.99	36.05	7068500.0
2004-07-07 13:00:00	QQQ	ETF	36.054	36.228	36.02	36.19	11834800.0
2004-07-07 14:00:00	QQQ	ETF	36.19	36.29	36.13	36.26	10901300.0
2004-07-07 15:00:00	QQQ	ETF	36.252	36.26	36.04	36.08	14069800.0
2004-07-07 16:00:00	QQQ	ETF	36.07	36.15	35.6	35.64	6057000.0
2004-07-07 17:00:00	QQQ	ETF	35.65	35.69	35.59	35.68	1051000.0
2004-07-07 18:00:00	QQQ	ETF	35.68	35.68	35.59	35.64	262800.0
2004-07-07 19:00:00	QQQ	ETF	35.64	35.67	35.63	35.67	34700.0
2004-07-07 08:00:00	IWM	ETF	57.16	57.16	57.16	57.16	1000.0
2004-07-07 09:00:00	IWM	ETF	57.05	57.5	56.97	57.345	1233200.0
2004-07-07 10:00:00	IWM	ETF	57.33	57.46	57.16	57.175	974400.0
2004-07-07 11:00:00	IWM	ETF	57.175	57.25	57.09	57.15	1075400.0
2004-07-07 12:00:00	IWM	ETF	57.175	57.215	56.92	57.06	1455600.0
2004-07-07 13:00:00	IWM	ETF	57.045	57.265	57.015	57.16	995800.0
2004-07-07 14:00:00	IWM	ETF	57.165	57.34	57.11	57.185	843600.0
2004-07-07 15:00:00	IWM	ETF	57.185	57.24	56.85	56.955	1318600.0
2004-07-07 16:00:00	IWM	ETF	56.915	57.085	56.5	56.5	497200.0
2004-07-07 17:00:00	IWM	ETF	56.455	56.605	56.25	56.605	4800.0
2004-07-07 08:00:00	DIA	ETF	102.5	102.5	102.29	102.29	7000.0
2004-07-07 09:00:00	DIA	ETF	102.27	102.61	102.25	102.48	360700.0
2004-07-07 10:00:00	DIA	ETF	102.49	102.71	102.4	102.44	644400.0
2004-07-07 11:00:00	DIA	ETF	102.45	102.55	102.26	102.34	652100.0
2004-07-07 12:00:00	DIA	ETF	102.38	102.49	102.31	102.39	273500.0
2004-07-07 13:00:00	DIA	ETF	102.42	102.8	102.4	102.75	1373100.0
2004-07-07 14:00:00	DIA	ETF	102.78	102.91	102.67	102.86	734500.0
2004-07-07 15:00:00	DIA	ETF	102.85	102.92	102.52	102.6	892000.0
2004-07-07 16:00:00	DIA	ETF	102.64	102.7	102.08	102.15	182300.0
2004-07-07 17:00:00	DIA	ETF	102.12	102.12	102.0	102.05	7500.0
2004-07-07 18:00:00	DIA	ETF	102.1	102.1	101.95	101.95	1200.0
2004-07-07 19:00:00	DIA	ETF	102.05	102.05	102.05	102.05	900.0
2004-07-07 09:00:00	TLT	ETF	84.2	84.34	84.2	84.29	49700.0
2004-07-07 10:00:00	TLT	ETF	84.34	84.36	84.29	84.34	35800.0
2004-07-07 11:00:00	TLT	ETF	84.29	84.42	84.29	84.36	88700.0
2004-07-07 12:00:00	TLT	ETF	84.38	84.4	84.35	84.4	76000.0

> showing 50 of 703 rows — these rows as CSV

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