PREVIEW / etf_1hour / 2007-07-30

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-30.parquet
  size:    87 KB
  rows:    2,895

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-30 04:00:00	SPY	ETF	146.04	146.09	146.04	146.09	4700.0
2007-07-30 05:00:00	SPY	ETF	145.67	145.83	145.65	145.83	17100.0
2007-07-30 06:00:00	SPY	ETF	145.64	145.72	144.9	145.2	991700.0
2007-07-30 07:00:00	SPY	ETF	145.36	145.6	145.1	145.27	2653800.0
2007-07-30 08:00:00	SPY	ETF	145.3	146.0	144.98	145.9	9941900.0
2007-07-30 09:00:00	SPY	ETF	145.89	146.33	145.33	146.06	42705074.0
2007-07-30 10:00:00	SPY	ETF	146.0499	146.72	145.86	146.05	40080184.0
2007-07-30 11:00:00	SPY	ETF	146.05	146.42	145.38	145.9	36346817.0
2007-07-30 12:00:00	SPY	ETF	145.91	147.09	145.6	146.51	22613511.0
2007-07-30 13:00:00	SPY	ETF	146.51	147.25	145.29	147.05	31365132.0
2007-07-30 14:00:00	SPY	ETF	147.05	147.31	146.36	147.2	26321690.0
2007-07-30 15:00:00	SPY	ETF	147.21	147.81	147.05	147.27	45258514.0
2007-07-30 16:00:00	SPY	ETF	147.26	147.67	147.2	147.55	8427400.0
2007-07-30 17:00:00	SPY	ETF	147.59	147.61	147.45	147.51	9052600.0
2007-07-30 18:00:00	SPY	ETF	147.5	147.56	147.31	147.32	674900.0
2007-07-30 19:00:00	SPY	ETF	147.33	147.38	147.26	147.27	796800.0
2007-07-30 04:00:00	QQQ	ETF	48.19	48.19	48.14	48.14	3000.0
2007-07-30 05:00:00	QQQ	ETF	48.16	48.16	48.08	48.08	11000.0
2007-07-30 06:00:00	QQQ	ETF	48.13	48.13	47.85	47.85	11500.0
2007-07-30 07:00:00	QQQ	ETF	48.07	48.1	47.92	48.0	318167.0
2007-07-30 08:00:00	QQQ	ETF	48.01	48.22	47.92	48.22	2034446.0
2007-07-30 09:00:00	QQQ	ETF	48.21	48.39	48.03	48.3	26992319.0
2007-07-30 10:00:00	QQQ	ETF	48.31	48.44	48.04	48.16	29965088.0
2007-07-30 11:00:00	QQQ	ETF	48.16	48.27	47.95	48.14	22695700.0
2007-07-30 12:00:00	QQQ	ETF	48.14	48.39	48.01	48.35	17952519.0
2007-07-30 13:00:00	QQQ	ETF	48.36	48.6	48.28	48.52	25259372.0
2007-07-30 14:00:00	QQQ	ETF	48.52	48.59	48.41	48.53	11361857.0
2007-07-30 15:00:00	QQQ	ETF	48.53	48.73	48.4	48.54	18943893.0
2007-07-30 16:00:00	QQQ	ETF	48.55	48.69	48.49	48.65	3312832.0
2007-07-30 17:00:00	QQQ	ETF	48.65	48.66	48.61	48.63	1973104.0
2007-07-30 18:00:00	QQQ	ETF	48.64	48.65	48.6	48.62	134590.0
2007-07-30 19:00:00	QQQ	ETF	48.62	48.63	48.55	48.55	458998.0
2007-07-30 06:00:00	IWM	ETF	76.52	76.67	76.52	76.58	5000.0
2007-07-30 07:00:00	IWM	ETF	76.9	76.92	76.65	76.81	193100.0
2007-07-30 08:00:00	IWM	ETF	76.69	77.2	76.63	77.13	1248000.0
2007-07-30 09:00:00	IWM	ETF	77.12	77.53	76.55	77.32	34243098.0
2007-07-30 10:00:00	IWM	ETF	77.32	77.79	77.04	77.22	28013526.0
2007-07-30 11:00:00	IWM	ETF	77.21	77.44	76.72	77.04	15482666.0
2007-07-30 12:00:00	IWM	ETF	77.04	77.54	76.73	77.5	15170192.0
2007-07-30 13:00:00	IWM	ETF	77.5	78.01	76.95	77.9	9757104.0
2007-07-30 14:00:00	IWM	ETF	77.9	78.2	77.79	78.05	12774019.0
2007-07-30 15:00:00	IWM	ETF	78.04	78.42	77.92	77.97	17105427.0
2007-07-30 16:00:00	IWM	ETF	77.97	78.25	77.02	78.04	3324700.0
2007-07-30 17:00:00	IWM	ETF	78.0	78.0	77.95	77.95	51800.0
2007-07-30 18:00:00	IWM	ETF	77.92	77.92	77.88	77.88	14900.0
2007-07-30 07:00:00	DIA	ETF	132.44	132.44	132.19	132.29	10300.0
2007-07-30 08:00:00	DIA	ETF	132.24	132.9	132.12	132.81	141800.0
2007-07-30 09:00:00	DIA	ETF	132.83	133.12	132.13	132.59	3112100.0
2007-07-30 10:00:00	DIA	ETF	132.59	133.06	132.39	132.62	4370500.0
2007-07-30 11:00:00	DIA	ETF	132.63	132.88	132.17	132.55	3387500.0

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

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