PREVIEW / etf_1hour / 2007-09-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-05.parquet
  size:    83 KB
  rows:    2,808

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-09-05 04:00:00	SPY	ETF	148.42	148.5	148.42	148.5	7000.0
2007-09-05 06:00:00	SPY	ETF	148.21	148.48	147.97	148.07	80900.0
2007-09-05 07:00:00	SPY	ETF	148.09	148.14	147.85	148.07	1031500.0
2007-09-05 08:00:00	SPY	ETF	148.07	149.08	147.82	148.07	3044600.0
2007-09-05 09:00:00	SPY	ETF	148.02	149.08	147.87	147.98	15563608.0
2007-09-05 10:00:00	SPY	ETF	147.98	147.98	147.26	147.69	31744500.0
2007-09-05 11:00:00	SPY	ETF	147.69	147.7	147.14	147.51	20043400.0
2007-09-05 12:00:00	SPY	ETF	147.52	147.88	147.43	147.82	9565800.0
2007-09-05 13:00:00	SPY	ETF	147.82	148.01	147.42	147.5899	15789700.0
2007-09-05 14:00:00	SPY	ETF	147.58	147.967	147.0	147.45	26827900.0
2007-09-05 15:00:00	SPY	ETF	147.45	147.95	147.27	147.56	25063900.0
2007-09-05 16:00:00	SPY	ETF	147.58	148.45	147.43	147.67	13434300.0
2007-09-05 17:00:00	SPY	ETF	147.65	147.66	147.59	147.65	36100.0
2007-09-05 18:00:00	SPY	ETF	147.64	147.66	147.61	147.61	19300.0
2007-09-05 19:00:00	SPY	ETF	147.62	147.68	147.6	147.68	4400.0
2007-09-05 04:00:00	QQQ	ETF	49.57	49.57	49.57	49.57	100.0
2007-09-05 05:00:00	QQQ	ETF	49.58	49.58	49.58	49.58	100.0
2007-09-05 06:00:00	QQQ	ETF	49.55	49.55	49.48	49.5	5300.0
2007-09-05 07:00:00	QQQ	ETF	49.51	49.58	49.46	49.5	688780.0
2007-09-05 08:00:00	QQQ	ETF	49.51	49.55	49.39	49.49	824317.0
2007-09-05 09:00:00	QQQ	ETF	49.48	49.65	49.46	49.46	8599210.0
2007-09-05 10:00:00	QQQ	ETF	49.46	49.52	49.31	49.45	15322060.0
2007-09-05 11:00:00	QQQ	ETF	49.45	49.45	49.26	49.39	13457090.0
2007-09-05 12:00:00	QQQ	ETF	49.38	49.49	49.34	49.45	8083897.0
2007-09-05 13:00:00	QQQ	ETF	49.45	49.51	49.23	49.26	11128773.0
2007-09-05 14:00:00	QQQ	ETF	49.2526	49.32	48.87	49.0599	19982209.0
2007-09-05 15:00:00	QQQ	ETF	49.05	49.22	49.0	49.09	18335123.0
2007-09-05 16:00:00	QQQ	ETF	49.09	49.2	49.04	49.11	2115759.0
2007-09-05 17:00:00	QQQ	ETF	49.11	49.11	49.08	49.1	58536.0
2007-09-05 18:00:00	QQQ	ETF	49.09	49.18	49.07	49.08	190423.0
2007-09-05 19:00:00	QQQ	ETF	49.09	49.13	49.09	49.13	13327.0
2007-09-05 07:00:00	IWM	ETF	79.22	79.27	79.11	79.24	496800.0
2007-09-05 08:00:00	IWM	ETF	79.25	79.75	79.12	79.25	1499100.0
2007-09-05 09:00:00	IWM	ETF	79.24	79.37	79.0	79.02	6443700.0
2007-09-05 10:00:00	IWM	ETF	79.02	79.15	78.69	79.02	9999400.0
2007-09-05 11:00:00	IWM	ETF	78.99	79.02	78.56	78.8	7100400.0
2007-09-05 12:00:00	IWM	ETF	78.79	79.08	78.75	79.02	4287400.0
2007-09-05 13:00:00	IWM	ETF	79.01	79.8	78.78	78.86	4356100.0
2007-09-05 14:00:00	IWM	ETF	78.86	79.01	78.46	78.79	7777800.0
2007-09-05 15:00:00	IWM	ETF	78.79	79.05	78.6	78.78	8346000.0
2007-09-05 16:00:00	IWM	ETF	78.77	79.18	78.75	79.07	3803865.0
2007-09-05 18:00:00	IWM	ETF	79.02	79.02	79.02	79.02	200.0
2007-09-05 19:00:00	IWM	ETF	79.0	79.0	79.0	79.0	300.0
2007-09-05 06:00:00	DIA	ETF	134.03	134.03	134.03	134.03	100.0
2007-09-05 07:00:00	DIA	ETF	133.7	133.7	133.56	133.56	6400.0
2007-09-05 08:00:00	DIA	ETF	133.75	133.83	133.53	133.72	56500.0
2007-09-05 09:00:00	DIA	ETF	133.7	133.82	133.45	133.48	889011.0
2007-09-05 10:00:00	DIA	ETF	133.46	133.48	132.84	133.04	2271700.0
2007-09-05 11:00:00	DIA	ETF	133.03	133.03	132.55	132.8	1094200.0
2007-09-05 12:00:00	DIA	ETF	132.81	133.17	132.75	133.14	1003000.0

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

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