PREVIEW / etf_1hour / 2007-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-02.parquet
  size:    80 KB
  rows:    2,733

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-02 05:00:00	SPY	ETF	150.41	150.41	150.41	150.41	100.0
2007-07-02 06:00:00	SPY	ETF	150.54	150.69	150.47	150.69	121100.0
2007-07-02 07:00:00	SPY	ETF	150.67	151.05	150.67	150.69	573600.0
2007-07-02 08:00:00	SPY	ETF	150.915	151.04	150.43	150.72	2687500.0
2007-07-02 09:00:00	SPY	ETF	150.71	151.16	150.43	151.08	22243923.0
2007-07-02 10:00:00	SPY	ETF	151.09	151.54	151.09	151.44	20164302.0
2007-07-02 11:00:00	SPY	ETF	151.44	151.55	151.17	151.19	8379802.0
2007-07-02 12:00:00	SPY	ETF	151.19	151.47	151.0	151.18	8105819.0
2007-07-02 13:00:00	SPY	ETF	151.18	151.7	151.14	151.53	8851295.0
2007-07-02 14:00:00	SPY	ETF	151.53	151.62	151.34	151.57	8409079.0
2007-07-02 15:00:00	SPY	ETF	151.57	151.8	151.24	151.8	15051211.0
2007-07-02 16:00:00	SPY	ETF	151.81	151.91	151.73	151.86	5505800.0
2007-07-02 17:00:00	SPY	ETF	151.87	151.88	151.76	151.82	312400.0
2007-07-02 18:00:00	SPY	ETF	151.8	151.82	151.78	151.78	23700.0
2007-07-02 19:00:00	SPY	ETF	151.85	151.89	151.84	151.89	5300.0
2007-07-02 07:00:00	QQQ	ETF	47.7	47.76	47.7	47.73	729322.0
2007-07-02 08:00:00	QQQ	ETF	47.71	47.74	47.57	47.71	1344073.0
2007-07-02 09:00:00	QQQ	ETF	47.7	47.9	47.68	47.87	14515891.0
2007-07-02 10:00:00	QQQ	ETF	47.87	48.01	47.86	47.99	22037325.0
2007-07-02 11:00:00	QQQ	ETF	47.99	48.03	47.92	47.93	6710561.0
2007-07-02 12:00:00	QQQ	ETF	47.93	48.0	47.9	47.95	5038134.0
2007-07-02 13:00:00	QQQ	ETF	47.95	48.03	47.93	47.99	6524615.0
2007-07-02 14:00:00	QQQ	ETF	47.99	48.02	47.9405	48.0	3677237.0
2007-07-02 15:00:00	QQQ	ETF	47.99	48.048	47.94	48.03	12027099.0
2007-07-02 16:00:00	QQQ	ETF	48.03	48.05	47.96	48.02	4448188.0
2007-07-02 17:00:00	QQQ	ETF	48.04	48.04	48.0	48.01	284141.0
2007-07-02 18:00:00	QQQ	ETF	48.02	48.02	48.01	48.02	3882.0
2007-07-02 19:00:00	QQQ	ETF	48.02	48.03	48.02	48.03	19648.0
2007-07-02 07:00:00	IWM	ETF	83.29	83.44	83.29	83.34	356100.0
2007-07-02 08:00:00	IWM	ETF	83.42	83.42	82.96	83.34	995000.0
2007-07-02 09:00:00	IWM	ETF	83.34	83.54	82.96	83.53	7155361.0
2007-07-02 10:00:00	IWM	ETF	83.53	83.82	83.47	83.76	8987317.0
2007-07-02 11:00:00	IWM	ETF	83.76	83.86	83.65	83.65	7144502.0
2007-07-02 12:00:00	IWM	ETF	83.66	83.89	83.59	83.67	3491400.0
2007-07-02 13:00:00	IWM	ETF	83.67	84.09	83.66	84.0	4600173.0
2007-07-02 14:00:00	IWM	ETF	84.0	84.06	83.78	83.96	5245572.0
2007-07-02 15:00:00	IWM	ETF	83.95	84.03	83.85	84.01	6168032.0
2007-07-02 16:00:00	IWM	ETF	84.01	84.07	83.88	83.98	1493300.0
2007-07-02 17:00:00	IWM	ETF	84.02	84.02	83.99	83.99	21700.0
2007-07-02 18:00:00	IWM	ETF	84.01	84.01	84.01	84.01	500.0
2007-07-02 07:00:00	DIA	ETF	134.46	134.46	134.46	134.46	100.0
2007-07-02 08:00:00	DIA	ETF	134.38	134.44	134.35	134.41	17400.0
2007-07-02 09:00:00	DIA	ETF	134.35	134.75	134.3	134.69	892987.0
2007-07-02 10:00:00	DIA	ETF	134.71	135.02	134.71	134.94	1779986.0
2007-07-02 11:00:00	DIA	ETF	134.94	135.08	134.82	134.84	840000.0
2007-07-02 12:00:00	DIA	ETF	134.84	135.08	134.69	134.83	716400.0
2007-07-02 13:00:00	DIA	ETF	134.83	135.22	134.8	135.09	850540.0
2007-07-02 14:00:00	DIA	ETF	135.09	135.2	134.92	135.15	1093715.0
2007-07-02 15:00:00	DIA	ETF	135.14	135.3	135.0	135.3	1221709.0
2007-07-02 16:00:00	DIA	ETF	135.3	135.37	135.18	135.29	131800.0

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

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