PREVIEW / etf_1hour / 2007-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-02.parquet
  size:    85 KB
  rows:    2,865

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-02 04:00:00	SPY	ETF	154.35	154.35	154.35	154.35	30000.0
2007-10-02 05:00:00	SPY	ETF	154.3	154.43	154.3	154.43	20000.0
2007-10-02 06:00:00	SPY	ETF	154.48	154.6	154.44	154.6	155500.0
2007-10-02 07:00:00	SPY	ETF	154.63	154.68	154.51	154.64	396600.0
2007-10-02 08:00:00	SPY	ETF	154.62	154.63	154.36	154.57	835500.0
2007-10-02 09:00:00	SPY	ETF	154.58	154.65	154.3	154.33	12127220.0
2007-10-02 10:00:00	SPY	ETF	154.325	154.54	153.95	154.15	29407300.0
2007-10-02 11:00:00	SPY	ETF	154.15	154.3	153.95	154.24	16192900.0
2007-10-02 12:00:00	SPY	ETF	154.24	154.3	153.9	154.05	8209200.0
2007-10-02 13:00:00	SPY	ETF	154.05	154.16	153.81	154.1	8729700.0
2007-10-02 14:00:00	SPY	ETF	154.1	154.46	154.02	154.36	14394249.0
2007-10-02 15:00:00	SPY	ETF	154.37	154.5	154.18	154.43	15908700.0
2007-10-02 16:00:00	SPY	ETF	154.44	154.44	154.01	154.14	4104700.0
2007-10-02 17:00:00	SPY	ETF	154.15	154.18	154.06	154.18	61900.0
2007-10-02 18:00:00	SPY	ETF	154.15	154.21	154.09	154.21	292500.0
2007-10-02 19:00:00	SPY	ETF	154.18	154.21	154.13	154.21	38900.0
2007-10-02 04:00:00	QQQ	ETF	51.91	51.91	51.91	51.91	1000.0
2007-10-02 05:00:00	QQQ	ETF	52.03	52.03	52.0	52.0	11700.0
2007-10-02 06:00:00	QQQ	ETF	52.04	52.04	52.04	52.04	10000.0
2007-10-02 07:00:00	QQQ	ETF	52.06	52.08	52.03	52.04	172870.0
2007-10-02 08:00:00	QQQ	ETF	52.05	52.06	51.95	52.02	1107045.0
2007-10-02 09:00:00	QQQ	ETF	52.02	52.06	51.87	51.88	10353974.0
2007-10-02 10:00:00	QQQ	ETF	51.88	52.03	51.78	51.84	13997152.0
2007-10-02 11:00:00	QQQ	ETF	51.83	51.91	51.72	51.91	7940801.0
2007-10-02 12:00:00	QQQ	ETF	51.9	51.91	51.74	51.84	5646523.0
2007-10-02 13:00:00	QQQ	ETF	51.84	51.9	51.76	51.88	6116465.0
2007-10-02 14:00:00	QQQ	ETF	51.88	52.0	51.85	51.94	6165769.0
2007-10-02 15:00:00	QQQ	ETF	51.941	52.03	51.86	52.02	16353988.0
2007-10-02 16:00:00	QQQ	ETF	52.02	52.04	51.9	51.93	3101835.0
2007-10-02 17:00:00	QQQ	ETF	51.92	51.94	51.87	51.89	45011.0
2007-10-02 18:00:00	QQQ	ETF	51.91	51.95	51.91	51.95	13900.0
2007-10-02 19:00:00	QQQ	ETF	51.91	51.95	51.91	51.95	8050.0
2007-10-02 06:00:00	IWM	ETF	82.16	82.22	82.16	82.22	5400.0
2007-10-02 07:00:00	IWM	ETF	82.32	82.32	82.29	82.29	32300.0
2007-10-02 08:00:00	IWM	ETF	82.29	82.31	82.16	82.23	135000.0
2007-10-02 09:00:00	IWM	ETF	82.23	82.48	82.15	82.32	6359746.0
2007-10-02 10:00:00	IWM	ETF	82.31	82.68	82.24	82.44	13784100.0
2007-10-02 11:00:00	IWM	ETF	82.44	82.55	82.23	82.49	5897600.0
2007-10-02 12:00:00	IWM	ETF	82.49	82.52	82.2	82.32	3082900.0
2007-10-02 13:00:00	IWM	ETF	82.31	82.5	82.18	82.48	5883000.0
2007-10-02 14:00:00	IWM	ETF	82.47	82.86	82.25	82.74	7949500.0
2007-10-02 15:00:00	IWM	ETF	82.73	82.87	82.63	82.73	8481200.0
2007-10-02 16:00:00	IWM	ETF	82.73	82.82	82.34	82.65	2361900.0
2007-10-02 17:00:00	IWM	ETF	82.52	82.52	82.5	82.5	14300.0
2007-10-02 18:00:00	IWM	ETF	82.5	82.55	82.5	82.55	7200.0
2007-10-02 19:00:00	IWM	ETF	82.53	82.53	82.53	82.53	100.0
2007-10-02 07:00:00	DIA	ETF	140.91	140.91	140.91	140.91	600.0
2007-10-02 08:00:00	DIA	ETF	140.89	140.89	140.72	140.82	53200.0
2007-10-02 09:00:00	DIA	ETF	140.83	140.91	140.6	140.61	840000.0
2007-10-02 10:00:00	DIA	ETF	140.61	140.82	140.29	140.4	2306200.0

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

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