PREVIEW / etf_1hour / 2004-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-20.parquet
  size:    25 KB
  rows:    690

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-09-20 08:00:00	SPY	ETF	112.78	112.78	112.7	112.71	16000.0
2004-09-20 09:00:00	SPY	ETF	112.7	112.79	112.4	112.41	4772400.0
2004-09-20 10:00:00	SPY	ETF	112.41	112.99	112.36	112.81	8484500.0
2004-09-20 11:00:00	SPY	ETF	112.82	112.89	112.6	112.71	3586300.0
2004-09-20 12:00:00	SPY	ETF	112.71	112.85	112.48	112.48	1177300.0
2004-09-20 13:00:00	SPY	ETF	112.5	112.72	112.38	112.49	4759200.0
2004-09-20 14:00:00	SPY	ETF	112.49	112.57	112.28	112.39	4777200.0
2004-09-20 15:00:00	SPY	ETF	112.37	112.63	112.31	112.52	4669700.0
2004-09-20 16:00:00	SPY	ETF	112.52	112.52	112.42	112.5	2104400.0
2004-09-20 17:00:00	SPY	ETF	112.47	112.47	112.39	112.4	36800.0
2004-09-20 18:00:00	SPY	ETF	112.4	112.42	112.4	112.42	1900.0
2004-09-20 08:00:00	QQQ	ETF	35.3	35.32	35.26	35.29	133300.0
2004-09-20 09:00:00	QQQ	ETF	35.29	35.35	35.2	35.23	14469000.0
2004-09-20 10:00:00	QQQ	ETF	35.22	35.7	35.22	35.64	24792500.0
2004-09-20 11:00:00	QQQ	ETF	35.64	35.77	35.56	35.64	14064900.0
2004-09-20 12:00:00	QQQ	ETF	35.64	35.67	35.42	35.44	5942000.0
2004-09-20 13:00:00	QQQ	ETF	35.44	35.48	35.3	35.38	9861300.0
2004-09-20 14:00:00	QQQ	ETF	35.372	35.47	35.26	35.362	15231600.0
2004-09-20 15:00:00	QQQ	ETF	35.37	35.49	35.33	35.43	12294000.0
2004-09-20 16:00:00	QQQ	ETF	35.438	35.53	35.4	35.53	4085400.0
2004-09-20 17:00:00	QQQ	ETF	35.526	35.535	35.44	35.46	466100.0
2004-09-20 18:00:00	QQQ	ETF	35.44	35.47	35.44	35.45	225600.0
2004-09-20 19:00:00	QQQ	ETF	35.44	35.46	35.43	35.43	16300.0
2004-09-20 08:00:00	IWM	ETF	56.83	56.955	56.83	56.905	2600.0
2004-09-20 09:00:00	IWM	ETF	56.885	57.16	56.885	56.925	933600.0
2004-09-20 10:00:00	IWM	ETF	56.91	57.325	56.875	57.125	2873800.0
2004-09-20 11:00:00	IWM	ETF	57.13	57.22	57.075	57.135	1104800.0
2004-09-20 12:00:00	IWM	ETF	57.14	57.25	56.99	56.99	1381000.0
2004-09-20 13:00:00	IWM	ETF	57.0	57.1	56.925	57.01	768600.0
2004-09-20 14:00:00	IWM	ETF	57.01	57.035	56.81	56.89	1380800.0
2004-09-20 15:00:00	IWM	ETF	56.905	57.1	56.875	56.99	1344200.0
2004-09-20 16:00:00	IWM	ETF	56.985	56.985	56.9	56.975	492800.0
2004-09-20 17:00:00	IWM	ETF	57.03	57.04	56.905	56.915	2400.0
2004-09-20 08:00:00	DIA	ETF	102.72	102.73	102.64	102.64	1900.0
2004-09-20 09:00:00	DIA	ETF	102.65	102.67	102.23	102.29	1046500.0
2004-09-20 10:00:00	DIA	ETF	102.27	102.7	102.21	102.56	1326900.0
2004-09-20 11:00:00	DIA	ETF	102.58	102.66	102.37	102.43	659600.0
2004-09-20 12:00:00	DIA	ETF	102.44	102.55	102.25	102.27	395200.0
2004-09-20 13:00:00	DIA	ETF	102.28	102.4	102.14	102.22	739100.0
2004-09-20 14:00:00	DIA	ETF	102.21	102.29	102.01	102.08	837100.0
2004-09-20 15:00:00	DIA	ETF	102.08	102.25	102.01	102.2	738500.0
2004-09-20 16:00:00	DIA	ETF	102.18	102.38	102.12	102.17	47200.0
2004-09-20 17:00:00	DIA	ETF	102.17	102.2	102.16	102.17	2300.0
2004-09-20 09:00:00	TLT	ETF	88.26	88.28	88.19	88.22	111800.0
2004-09-20 10:00:00	TLT	ETF	88.22	88.3	88.2	88.3	113800.0
2004-09-20 11:00:00	TLT	ETF	88.29	88.37	88.26	88.34	38700.0
2004-09-20 12:00:00	TLT	ETF	88.34	88.34	88.2615	88.29	60300.0
2004-09-20 13:00:00	TLT	ETF	88.31	88.43	88.31	88.39	81700.0
2004-09-20 14:00:00	TLT	ETF	88.4	88.57	88.39	88.55	119900.0
2004-09-20 15:00:00	TLT	ETF	88.54	88.55	88.48	88.5	193800.0

> showing 50 of 690 rows — these rows as CSV

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