PREVIEW / etf_1hour / 2007-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-17.parquet
  size:    90 KB
  rows:    2,947

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-17 04:00:00	SPY	ETF	154.61	154.63	154.61	154.63	3100.0
2007-10-17 06:00:00	SPY	ETF	154.4	154.45	154.32	154.45	104900.0
2007-10-17 07:00:00	SPY	ETF	154.5	154.89	154.49	154.77	1570200.0
2007-10-17 08:00:00	SPY	ETF	154.8	154.98	154.65	154.94	7251800.0
2007-10-17 09:00:00	SPY	ETF	154.96	155.16	154.59	154.68	17581382.0
2007-10-17 10:00:00	SPY	ETF	154.679	154.8	154.27	154.36	19940450.0
2007-10-17 11:00:00	SPY	ETF	154.36	154.62	154.13	154.47	17640200.0
2007-10-17 12:00:00	SPY	ETF	154.46	154.5	153.44	153.4875	20370450.0
2007-10-17 13:00:00	SPY	ETF	153.48	153.61	152.47	152.68	44922500.0
2007-10-17 14:00:00	SPY	ETF	152.68	153.27	152.52	153.18	34055413.0
2007-10-17 15:00:00	SPY	ETF	153.1799	154.06	153.14	154.03	37850643.0
2007-10-17 16:00:00	SPY	ETF	154.05	154.9723	153.22	154.4	11133700.0
2007-10-17 17:00:00	SPY	ETF	154.38	154.41	154.2	154.22	179000.0
2007-10-17 18:00:00	SPY	ETF	154.2	154.29	154.15	154.24	47800.0
2007-10-17 19:00:00	SPY	ETF	154.2	154.23	154.1	154.23	14400.0
2007-10-17 04:00:00	QQQ	ETF	53.5	53.5	53.5	53.5	1000.0
2007-10-17 05:00:00	QQQ	ETF	53.44	53.44	53.44	53.44	2000.0
2007-10-17 06:00:00	QQQ	ETF	53.44	53.44	53.38	53.39	500.0
2007-10-17 07:00:00	QQQ	ETF	53.4	53.56	53.4	53.51	494654.0
2007-10-17 08:00:00	QQQ	ETF	53.53	53.66	53.51	53.63	884186.0
2007-10-17 09:00:00	QQQ	ETF	53.63	53.72	53.41	53.4674	21250074.0
2007-10-17 10:00:00	QQQ	ETF	53.46	53.56	53.35	53.49	16818674.0
2007-10-17 11:00:00	QQQ	ETF	53.49	53.64	53.41	53.573	17395219.0
2007-10-17 12:00:00	QQQ	ETF	53.57	53.59	53.12	53.12	17228715.0
2007-10-17 13:00:00	QQQ	ETF	53.12	53.17	52.68	52.72	38184657.0
2007-10-17 14:00:00	QQQ	ETF	52.729	53.04	52.68	53.0201	28674430.0
2007-10-17 15:00:00	QQQ	ETF	53.02	53.58	53.01	53.55	34951804.0
2007-10-17 16:00:00	QQQ	ETF	53.56	53.85	53.3586	53.68	7523347.0
2007-10-17 17:00:00	QQQ	ETF	53.66	53.71	53.51	53.55	491569.0
2007-10-17 18:00:00	QQQ	ETF	53.55	53.6	53.53	53.57	69627.0
2007-10-17 19:00:00	QQQ	ETF	53.56	53.57	53.52	53.55	15769.0
2007-10-17 07:00:00	IWM	ETF	83.25	83.25	82.6	82.74	44300.0
2007-10-17 08:00:00	IWM	ETF	82.7	82.83	81.94	82.83	4653100.0
2007-10-17 09:00:00	IWM	ETF	82.79	82.92	82.57	82.66	6785300.0
2007-10-17 10:00:00	IWM	ETF	82.65	82.73	82.2	82.3	11870200.0
2007-10-17 11:00:00	IWM	ETF	82.3	82.56	82.16	82.43	11034100.0
2007-10-17 12:00:00	IWM	ETF	82.43	82.45	81.64	81.67	10005600.0
2007-10-17 13:00:00	IWM	ETF	81.67	81.79	81.06	81.21	12717500.0
2007-10-17 14:00:00	IWM	ETF	81.22	81.53	81.12	81.49	15344200.0
2007-10-17 15:00:00	IWM	ETF	81.49	82.23	81.4	82.23	14239200.0
2007-10-17 16:00:00	IWM	ETF	82.22	82.5	81.81	82.44	2877400.0
2007-10-17 17:00:00	IWM	ETF	82.42	82.61	81.73	82.25	665100.0
2007-10-17 18:00:00	IWM	ETF	82.28	82.28	82.28	82.28	2000.0
2007-10-17 19:00:00	IWM	ETF	82.24	82.24	82.24	82.24	12000.0
2007-10-17 08:00:00	DIA	ETF	139.8	140.09	139.77	140.0	155500.0
2007-10-17 09:00:00	DIA	ETF	140.0	140.18	139.55	139.66	2044500.0
2007-10-17 10:00:00	DIA	ETF	139.64	139.68	139.29	139.42	2785800.0
2007-10-17 11:00:00	DIA	ETF	139.41	139.47	139.13	139.38	1507000.0
2007-10-17 12:00:00	DIA	ETF	139.37	139.41	138.5	138.58	2312800.0
2007-10-17 13:00:00	DIA	ETF	138.59	138.65	137.74	137.89	4886600.0

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

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