PREVIEW / etf_1hour / 2007-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-18.parquet
  size:    84 KB
  rows:    2,846

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-18 04:00:00	SPY	ETF	154.15	154.18	154.15	154.18	2200.0
2007-10-18 06:00:00	SPY	ETF	154.4	154.5	154.3	154.4	20200.0
2007-10-18 07:00:00	SPY	ETF	154.32	154.35	153.39	153.56	1992000.0
2007-10-18 08:00:00	SPY	ETF	153.6	153.79	153.16	153.28	6177500.0
2007-10-18 09:00:00	SPY	ETF	153.3	153.68	153.25	153.38	13838912.0
2007-10-18 10:00:00	SPY	ETF	153.38	153.91	153.08	153.59	25810065.0
2007-10-18 11:00:00	SPY	ETF	153.58	153.8	153.22	153.45	16147800.0
2007-10-18 12:00:00	SPY	ETF	153.45	153.63	153.16	153.38	12606650.0
2007-10-18 13:00:00	SPY	ETF	153.38	154.03	153.21	153.97	17116121.0
2007-10-18 14:00:00	SPY	ETF	153.96	154.19	153.53	153.66	23060658.0
2007-10-18 15:00:00	SPY	ETF	153.66	154.15	153.65	153.82	16002300.0
2007-10-18 16:00:00	SPY	ETF	153.84	154.02	153.69	153.78	10982500.0
2007-10-18 17:00:00	SPY	ETF	153.77	154.0	153.73	153.94	1895500.0
2007-10-18 18:00:00	SPY	ETF	153.9	153.94	153.69	153.91	261800.0
2007-10-18 19:00:00	SPY	ETF	153.89	153.9	153.88	153.88	9500.0
2007-10-18 04:00:00	QQQ	ETF	53.55	53.55	53.55	53.55	900.0
2007-10-18 05:00:00	QQQ	ETF	53.6	53.6	53.6	53.6	5000.0
2007-10-18 06:00:00	QQQ	ETF	53.64	53.68	53.64	53.65	7300.0
2007-10-18 07:00:00	QQQ	ETF	53.6	53.6	53.36	53.38	1596789.0
2007-10-18 08:00:00	QQQ	ETF	53.39	53.66	53.22	53.26	5817936.0
2007-10-18 09:00:00	QQQ	ETF	53.25	53.45	53.181	53.27	12557100.0
2007-10-18 10:00:00	QQQ	ETF	53.27	53.49	53.12	53.328	20920149.0
2007-10-18 11:00:00	QQQ	ETF	53.32	53.38	53.15	53.3	10165822.0
2007-10-18 12:00:00	QQQ	ETF	53.3	53.41	53.23	53.35	7583575.0
2007-10-18 13:00:00	QQQ	ETF	53.35	53.76	53.25	53.73	20563755.0
2007-10-18 14:00:00	QQQ	ETF	53.73	53.88	53.64	53.68	19080309.0
2007-10-18 15:00:00	QQQ	ETF	53.68	53.89	53.67	53.78	23908064.0
2007-10-18 16:00:00	QQQ	ETF	53.78	53.86	53.34	53.62	23047122.0
2007-10-18 17:00:00	QQQ	ETF	53.64	53.82	53.62	53.8	1258688.0
2007-10-18 18:00:00	QQQ	ETF	53.8	53.8	53.75	53.75	31689.0
2007-10-18 19:00:00	QQQ	ETF	53.74	53.76	53.72	53.72	10700.0
2007-10-18 06:00:00	IWM	ETF	82.37	82.37	82.22	82.22	10200.0
2007-10-18 07:00:00	IWM	ETF	82.08	83.08	81.79	81.83	464000.0
2007-10-18 08:00:00	IWM	ETF	81.82	82.1	81.5	81.6	912600.0
2007-10-18 09:00:00	IWM	ETF	81.6	81.83	81.47	81.64	9368610.0
2007-10-18 10:00:00	IWM	ETF	81.64	82.18	81.39	81.95	21304000.0
2007-10-18 11:00:00	IWM	ETF	81.96	82.06	81.59	81.81	6536900.0
2007-10-18 12:00:00	IWM	ETF	81.81	81.92	81.6	81.74	6696200.0
2007-10-18 13:00:00	IWM	ETF	81.74	82.3	81.61	82.27	5982400.0
2007-10-18 14:00:00	IWM	ETF	82.27	82.39	81.87	81.99	7749200.0
2007-10-18 15:00:00	IWM	ETF	82.0	82.24	81.95	82.08	7310500.0
2007-10-18 16:00:00	IWM	ETF	82.07	82.17	81.4	82.09	2309500.0
2007-10-18 17:00:00	IWM	ETF	82.09	82.17	81.95	81.95	15000.0
2007-10-18 18:00:00	IWM	ETF	82.19	82.19	82.05	82.05	3300.0
2007-10-18 19:00:00	IWM	ETF	82.01	82.01	82.01	82.01	300.0
2007-10-18 07:00:00	DIA	ETF	138.63	138.66	138.6	138.6	4800.0
2007-10-18 08:00:00	DIA	ETF	138.63	138.64	138.35	138.45	46000.0
2007-10-18 09:00:00	DIA	ETF	138.47	138.81	138.36	138.47	1346800.0
2007-10-18 10:00:00	DIA	ETF	138.48	138.91	138.22	138.67	1855400.0
2007-10-18 11:00:00	DIA	ETF	138.65	138.85	138.4	138.63	1129400.0

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

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