PREVIEW / etf_1hour / 2007-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-17.parquet
  size:    96 KB
  rows:    3,217

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-12-17 04:00:00	SPY	ETF	146.08	146.15	146.03	146.12	7100.0
2007-12-17 05:00:00	SPY	ETF	146.28	146.36	146.28	146.36	8300.0
2007-12-17 06:00:00	SPY	ETF	146.31	146.53	146.26	146.28	79300.0
2007-12-17 07:00:00	SPY	ETF	146.27	146.7	146.15	146.61	751400.0
2007-12-17 08:00:00	SPY	ETF	146.62	147.05	146.21	146.71	4143100.0
2007-12-17 09:00:00	SPY	ETF	146.7	146.72	146.14	146.21	21849190.0
2007-12-17 10:00:00	SPY	ETF	146.2	146.79	146.03	146.67	25114289.0
2007-12-17 11:00:00	SPY	ETF	146.66	146.87	146.03	146.27	18473898.0
2007-12-17 12:00:00	SPY	ETF	146.26	146.63	146.18	146.56	7917829.0
2007-12-17 13:00:00	SPY	ETF	146.56	146.57	145.47	145.48	26178671.0
2007-12-17 14:00:00	SPY	ETF	145.48	145.99	145.29	145.37	18721139.0
2007-12-17 15:00:00	SPY	ETF	145.37	145.78	144.94	145.07	34420557.0
2007-12-17 16:00:00	SPY	ETF	145.07	145.5272	144.86	145.07	10441800.0
2007-12-17 17:00:00	SPY	ETF	145.01	147.22	144.99	147.22	2220700.0
2007-12-17 18:00:00	SPY	ETF	145.08	145.35	145.08	145.35	163400.0
2007-12-17 19:00:00	SPY	ETF	145.35	145.4	145.16	145.27	91000.0
2007-12-17 04:00:00	QQQ	ETF	50.58	50.59	50.58	50.59	2100.0
2007-12-17 05:00:00	QQQ	ETF	50.65	50.7	50.65	50.7	400.0
2007-12-17 06:00:00	QQQ	ETF	50.77	50.77	50.67	50.67	20300.0
2007-12-17 07:00:00	QQQ	ETF	50.64	50.8	50.63	50.78	145180.0
2007-12-17 08:00:00	QQQ	ETF	50.78	50.83	50.7	50.78	655975.0
2007-12-17 09:00:00	QQQ	ETF	50.79	50.94	50.65	50.65	14001029.0
2007-12-17 10:00:00	QQQ	ETF	50.66	50.73	50.49	50.6299	19802462.0
2007-12-17 11:00:00	QQQ	ETF	50.63	50.6894	50.23	50.33	17708199.0
2007-12-17 12:00:00	QQQ	ETF	50.32	50.49	50.27	50.4801	13499802.0
2007-12-17 13:00:00	QQQ	ETF	50.49	50.49	49.93	49.96	18652950.0
2007-12-17 14:00:00	QQQ	ETF	49.95	50.14	49.83	49.87	13669429.0
2007-12-17 15:00:00	QQQ	ETF	49.87	50.07	49.71	49.75	30937182.0
2007-12-17 16:00:00	QQQ	ETF	49.75	50.2819	49.7	49.84	4909988.0
2007-12-17 17:00:00	QQQ	ETF	49.77	49.85	49.77	49.8	606192.0
2007-12-17 18:00:00	QQQ	ETF	49.82	49.93	49.82	49.91	203637.0
2007-12-17 19:00:00	QQQ	ETF	49.92	49.98	49.87	49.91	63286.0
2007-12-17 04:00:00	IWM	ETF	74.52	74.52	74.5	74.5	700.0
2007-12-17 06:00:00	IWM	ETF	74.69	74.69	74.69	74.69	2500.0
2007-12-17 07:00:00	IWM	ETF	74.5	74.91	74.5	74.9	80700.0
2007-12-17 08:00:00	IWM	ETF	74.9	74.91	73.5	74.83	360500.0
2007-12-17 09:00:00	IWM	ETF	74.83	74.92	74.42	74.54	9821100.0
2007-12-17 10:00:00	IWM	ETF	74.54	74.86	74.45	74.67	10847011.0
2007-12-17 11:00:00	IWM	ETF	74.67	74.8	74.39	74.63	5679013.0
2007-12-17 12:00:00	IWM	ETF	74.62	75.04	74.58	75.02	3764200.0
2007-12-17 13:00:00	IWM	ETF	75.02	75.02	74.25	74.27	10024300.0
2007-12-17 14:00:00	IWM	ETF	74.27	74.66	74.13	74.24	7947446.0
2007-12-17 15:00:00	IWM	ETF	74.23	74.46	73.75	73.77	20523679.0
2007-12-17 16:00:00	IWM	ETF	73.79	74.4	73.75	73.81	2720719.0
2007-12-17 17:00:00	IWM	ETF	73.86	73.89	73.86	73.86	33700.0
2007-12-17 18:00:00	IWM	ETF	73.98	74.04	73.98	74.04	300.0
2007-12-17 19:00:00	IWM	ETF	74.04	74.04	73.86	73.86	2400.0
2007-12-17 07:00:00	DIA	ETF	132.95	133.11	132.95	133.11	12800.0
2007-12-17 08:00:00	DIA	ETF	133.02	133.19	133.02	133.1	19000.0
2007-12-17 09:00:00	DIA	ETF	133.12	133.12	132.57	132.58	1235742.0

> showing 50 of 3,217 rows — these rows as CSV

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