PREVIEW / etf_1hour / 2007-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-23.parquet
  size:    81 KB
  rows:    2,771

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-07-23 06:00:00	SPY	ETF	153.51	153.9	153.51	153.9	72000.0
2007-07-23 07:00:00	SPY	ETF	153.8	154.15	153.8	153.92	1128300.0
2007-07-23 08:00:00	SPY	ETF	153.985	154.14	153.1	153.95	2141300.0
2007-07-23 09:00:00	SPY	ETF	153.95	154.42	153.95	154.09	19447340.0
2007-07-23 10:00:00	SPY	ETF	154.09	154.45	153.84	154.45	20336978.0
2007-07-23 11:00:00	SPY	ETF	154.44	154.72	154.39	154.5	14541963.0
2007-07-23 12:00:00	SPY	ETF	154.5	154.63	154.4	154.4201	6078058.0
2007-07-23 13:00:00	SPY	ETF	154.44	154.48	154.19	154.26	8704976.0
2007-07-23 14:00:00	SPY	ETF	154.26	154.52	153.94	154.37	16638664.0
2007-07-23 15:00:00	SPY	ETF	154.375	154.475	153.95	154.06	21049757.0
2007-07-23 16:00:00	SPY	ETF	154.04	154.15	153.84	153.91	6379600.0
2007-07-23 17:00:00	SPY	ETF	153.92	153.98	153.3566	153.89	1019500.0
2007-07-23 18:00:00	SPY	ETF	153.89	153.97	153.88	153.88	28800.0
2007-07-23 19:00:00	SPY	ETF	153.88	153.88	153.87	153.87	2000.0
2007-07-23 04:00:00	QQQ	ETF	50.09	50.09	50.09	50.09	500.0
2007-07-23 05:00:00	QQQ	ETF	50.12	50.14	50.12	50.14	20000.0
2007-07-23 06:00:00	QQQ	ETF	50.05	50.17	50.05	50.16	109300.0
2007-07-23 07:00:00	QQQ	ETF	50.16	50.21	50.13	50.14	374312.0
2007-07-23 08:00:00	QQQ	ETF	50.14	50.2	50.13	50.16	896052.0
2007-07-23 09:00:00	QQQ	ETF	50.16	50.25	50.05	50.07	13544158.0
2007-07-23 10:00:00	QQQ	ETF	50.07	50.24	49.92	50.24	20999642.0
2007-07-23 11:00:00	QQQ	ETF	50.24	50.31	50.17	50.2	10582624.0
2007-07-23 12:00:00	QQQ	ETF	50.19	50.27	50.17	50.2	5352819.0
2007-07-23 13:00:00	QQQ	ETF	50.21	50.22	50.0	50.05	6787501.0
2007-07-23 14:00:00	QQQ	ETF	50.05	50.17	49.97	50.13	12093405.0
2007-07-23 15:00:00	QQQ	ETF	50.13	50.18	50.01	50.0601	13531252.0
2007-07-23 16:00:00	QQQ	ETF	50.066	50.12	49.85	49.95	11574700.0
2007-07-23 17:00:00	QQQ	ETF	49.95	50.07	49.95	49.98	569347.0
2007-07-23 18:00:00	QQQ	ETF	50.0	50.05	49.98	50.01	226240.0
2007-07-23 19:00:00	QQQ	ETF	50.01	50.03	50.01	50.02	13701.0
2007-07-23 06:00:00	IWM	ETF	83.44	83.45	83.44	83.45	10000.0
2007-07-23 07:00:00	IWM	ETF	83.43	83.54	83.43	83.45	19200.0
2007-07-23 08:00:00	IWM	ETF	83.45	83.47	83.44	83.44	26500.0
2007-07-23 09:00:00	IWM	ETF	83.51	83.68	83.35	83.5	8743415.0
2007-07-23 10:00:00	IWM	ETF	83.5	83.75	83.21	83.75	12693356.0
2007-07-23 11:00:00	IWM	ETF	83.76	83.84	83.51	83.62	7743236.0
2007-07-23 12:00:00	IWM	ETF	83.61	83.85	83.6	83.7	2392670.0
2007-07-23 13:00:00	IWM	ETF	83.7	83.74	83.42	83.48	4274246.0
2007-07-23 14:00:00	IWM	ETF	83.49	83.52	83.24	83.41	11479617.0
2007-07-23 15:00:00	IWM	ETF	83.41	83.45	83.1	83.15	14875226.0
2007-07-23 16:00:00	IWM	ETF	83.16	83.2	82.85	82.89	1962500.0
2007-07-23 17:00:00	IWM	ETF	82.92	82.92	82.75	82.75	18000.0
2007-07-23 18:00:00	IWM	ETF	82.89	82.91	82.89	82.91	6600.0
2007-07-23 19:00:00	IWM	ETF	82.85	82.85	82.83	82.83	10000.0
2007-07-23 07:00:00	DIA	ETF	138.81	139.0	138.81	139.0	1800.0
2007-07-23 08:00:00	DIA	ETF	138.92	138.95	138.85	138.9	6500.0
2007-07-23 09:00:00	DIA	ETF	138.96	139.2	138.88	139.05	1759700.0
2007-07-23 10:00:00	DIA	ETF	139.06	139.39	138.81	139.39	3152000.0
2007-07-23 11:00:00	DIA	ETF	139.4	139.56	139.31	139.47	1213100.0
2007-07-23 12:00:00	DIA	ETF	139.47	139.59	139.38	139.4	743900.0

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

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