PREVIEW / etf_1hour / 2007-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-16.parquet
  size:    86 KB
  rows:    2,900

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
2007-10-16 04:00:00	SPY	ETF	154.11	154.19	154.11	154.19	200.0
2007-10-16 05:00:00	SPY	ETF	154.26	154.31	154.24	154.31	20600.0
2007-10-16 06:00:00	SPY	ETF	154.29	154.29	154.16	154.29	74300.0
2007-10-16 07:00:00	SPY	ETF	154.34	154.36	154.13	154.25	1005000.0
2007-10-16 08:00:00	SPY	ETF	154.24	154.56	154.18	154.49	1879400.0
2007-10-16 09:00:00	SPY	ETF	154.51	156.48	153.97	154.21	22243672.0
2007-10-16 10:00:00	SPY	ETF	154.21	154.39	153.55	154.04	31608307.0
2007-10-16 11:00:00	SPY	ETF	154.04	154.52	153.89	154.06	22242539.0
2007-10-16 12:00:00	SPY	ETF	154.06	154.31	153.9	154.215	10631477.0
2007-10-16 13:00:00	SPY	ETF	154.21	154.22	153.71	154.01	16519726.0
2007-10-16 14:00:00	SPY	ETF	154.01	154.21	153.58	153.8	18154400.0
2007-10-16 15:00:00	SPY	ETF	153.8	154.12	153.47	153.7608	27044705.0
2007-10-16 16:00:00	SPY	ETF	153.75	154.44	153.62	154.3	8251600.0
2007-10-16 17:00:00	SPY	ETF	154.31	154.43	154.28	154.35	203700.0
2007-10-16 18:00:00	SPY	ETF	154.33	154.5	154.31	154.46	178300.0
2007-10-16 19:00:00	SPY	ETF	154.44	154.44	154.3	154.35	71100.0
2007-10-16 04:00:00	QQQ	ETF	52.81	52.82	52.8	52.8	1000.0
2007-10-16 05:00:00	QQQ	ETF	52.84	52.84	52.83	52.84	500.0
2007-10-16 06:00:00	QQQ	ETF	52.85	52.88	52.8	52.88	53900.0
2007-10-16 07:00:00	QQQ	ETF	52.87	52.88	52.76	52.77	664947.0
2007-10-16 08:00:00	QQQ	ETF	52.8	52.93	52.76	52.91	2638463.0
2007-10-16 09:00:00	QQQ	ETF	52.91	52.95	52.68	52.95	20238525.0
2007-10-16 10:00:00	QQQ	ETF	52.9485	53.08	52.747	52.93	39836003.0
2007-10-16 11:00:00	QQQ	ETF	52.93	53.28	52.91	53.16	28155692.0
2007-10-16 12:00:00	QQQ	ETF	53.15	53.2	53.0	53.09	13611226.0
2007-10-16 13:00:00	QQQ	ETF	53.09	53.09	52.83	53.0	21401876.0
2007-10-16 14:00:00	QQQ	ETF	53.0	53.11	52.83	52.89	18255897.0
2007-10-16 15:00:00	QQQ	ETF	52.9	53.04	52.8	52.88	37708540.0
2007-10-16 16:00:00	QQQ	ETF	52.87	53.43	52.86	53.37	11626342.0
2007-10-16 17:00:00	QQQ	ETF	53.37	53.42	53.34	53.41	908199.0
2007-10-16 18:00:00	QQQ	ETF	53.39	53.46	53.39	53.46	73889.0
2007-10-16 19:00:00	QQQ	ETF	53.45	53.47	53.41	53.45	47505.0
2007-10-16 04:00:00	IWM	ETF	82.46	82.48	82.46	82.48	400.0
2007-10-16 07:00:00	IWM	ETF	82.42	82.46	82.34	82.36	16500.0
2007-10-16 08:00:00	IWM	ETF	82.37	82.46	82.29	82.41	279200.0
2007-10-16 09:00:00	IWM	ETF	82.35	84.18	78.23	82.34	9861418.0
2007-10-16 10:00:00	IWM	ETF	82.34	82.5	81.88	82.24	15508300.0
2007-10-16 11:00:00	IWM	ETF	82.23	82.56	82.14	82.3	7129300.0
2007-10-16 12:00:00	IWM	ETF	82.3	82.49	82.22	82.42	4346188.0
2007-10-16 13:00:00	IWM	ETF	82.41	82.44	82.11	82.33	5038900.0
2007-10-16 14:00:00	IWM	ETF	82.33	82.46	81.99	82.08	5067600.0
2007-10-16 15:00:00	IWM	ETF	82.08	82.24	81.9	81.96	10480700.0
2007-10-16 16:00:00	IWM	ETF	81.96	82.41	81.89	82.32	1605900.0
2007-10-16 17:00:00	IWM	ETF	82.35	82.6	82.34	82.6	92700.0
2007-10-16 18:00:00	IWM	ETF	82.45	82.48	82.4	82.48	25500.0
2007-10-16 19:00:00	IWM	ETF	82.45	82.45	82.37	82.41	2700.0
2007-10-16 07:00:00	DIA	ETF	139.45	139.46	139.45	139.46	600.0
2007-10-16 08:00:00	DIA	ETF	139.41	139.73	139.4	139.68	16300.0
2007-10-16 09:00:00	DIA	ETF	139.66	139.66	139.25	139.45	1212900.0
2007-10-16 10:00:00	DIA	ETF	139.45	139.58	138.72	139.11	2723700.0

> showing 50 of 2,900 rows — these rows as CSV

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