PREVIEW / etf_1hour / 2007-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-21.parquet
  size:    94 KB
  rows:    3,189

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-21 04:00:00	SPY	ETF	147.11	147.11	146.91	146.91	5900.0
2007-12-21 05:00:00	SPY	ETF	147.06	147.18	146.98	147.18	5300.0
2007-12-21 06:00:00	SPY	ETF	147.12	147.24	147.09	147.15	48400.0
2007-12-21 07:00:00	SPY	ETF	147.19	147.25	147.04	147.12	744200.0
2007-12-21 08:00:00	SPY	ETF	147.13	147.41	146.406	147.29	3026100.0
2007-12-21 09:00:00	SPY	ETF	147.29	147.68	147.09	147.29	23482944.0
2007-12-21 10:00:00	SPY	ETF	147.29	147.84	147.29	147.42	25192512.0
2007-12-21 11:00:00	SPY	ETF	147.43	147.72	147.27	147.45	14066231.0
2007-12-21 12:00:00	SPY	ETF	147.46	147.61	147.37	147.42	7978336.0
2007-12-21 13:00:00	SPY	ETF	147.42	147.56	147.34	147.55	7465651.0
2007-12-21 14:00:00	SPY	ETF	147.55	148.08	147.54	148.02	15654002.0
2007-12-21 15:00:00	SPY	ETF	148.01	148.27	147.58	148.19	25498116.0
2007-12-21 16:00:00	SPY	ETF	148.15	148.43	147.7019	148.33	10461400.0
2007-12-21 17:00:00	SPY	ETF	148.28	148.35	147.74	148.34	1714500.0
2007-12-21 18:00:00	SPY	ETF	148.33	148.43	148.29	148.3	4500.0
2007-12-21 19:00:00	SPY	ETF	148.4	148.42	148.4	148.42	1400.0
2007-12-21 05:00:00	QQQ	ETF	51.48	51.48	51.45	51.45	7900.0
2007-12-21 06:00:00	QQQ	ETF	51.47	51.5	51.45	51.49	6600.0
2007-12-21 07:00:00	QQQ	ETF	51.46	51.49	51.39	51.42	226004.0
2007-12-21 08:00:00	QQQ	ETF	51.41	51.58	51.39	51.57	1727907.0
2007-12-21 09:00:00	QQQ	ETF	51.56	51.75	51.5	51.552	19475820.0
2007-12-21 10:00:00	QQQ	ETF	51.57	51.72	51.52	51.57	14724561.0
2007-12-21 11:00:00	QQQ	ETF	51.56	51.66	51.49	51.54	12148796.0
2007-12-21 12:00:00	QQQ	ETF	51.55	51.63	51.48	51.56	9881403.0
2007-12-21 13:00:00	QQQ	ETF	51.56	51.66	51.54	51.65	7351549.0
2007-12-21 14:00:00	QQQ	ETF	51.64	51.81	51.64	51.78	11194807.0
2007-12-21 15:00:00	QQQ	ETF	51.78	51.9	51.66	51.88	27430025.0
2007-12-21 16:00:00	QQQ	ETF	51.88	51.95	51.615	51.91	3261493.0
2007-12-21 17:00:00	QQQ	ETF	51.91	51.92	51.87	51.9	142627.0
2007-12-21 18:00:00	QQQ	ETF	51.91	51.95	51.9	51.91	14405.0
2007-12-21 19:00:00	QQQ	ETF	51.92	51.93	51.85	51.91	24656.0
2007-12-21 05:00:00	IWM	ETF	77.46	77.46	77.46	77.46	700.0
2007-12-21 06:00:00	IWM	ETF	77.48	77.54	77.48	77.54	5300.0
2007-12-21 07:00:00	IWM	ETF	77.5	77.6	77.45	77.56	81200.0
2007-12-21 08:00:00	IWM	ETF	77.56	77.66	77.39	77.65	559800.0
2007-12-21 09:00:00	IWM	ETF	77.66	78.15	77.64	77.75	13147081.0
2007-12-21 10:00:00	IWM	ETF	77.75	78.16	77.71	77.89	18978837.0
2007-12-21 11:00:00	IWM	ETF	77.89	78.06	77.74	77.77	10210847.0
2007-12-21 12:00:00	IWM	ETF	77.77	77.93	77.72	77.75	7076333.0
2007-12-21 13:00:00	IWM	ETF	77.75	77.94	77.7	77.93	4792805.0
2007-12-21 14:00:00	IWM	ETF	77.93	78.2	77.8	78.15	7937008.0
2007-12-21 15:00:00	IWM	ETF	78.15	78.35	77.98	78.23	13795375.0
2007-12-21 16:00:00	IWM	ETF	78.22	78.6	78.01	78.42	7136400.0
2007-12-21 17:00:00	IWM	ETF	78.55	78.6	78.46	78.53	5200.0
2007-12-21 07:00:00	DIA	ETF	133.23	133.36	133.17	133.26	16500.0
2007-12-21 08:00:00	DIA	ETF	133.3	133.37	133.2	133.35	158000.0
2007-12-21 09:00:00	DIA	ETF	133.32	133.85	133.3	133.59	1672427.0
2007-12-21 10:00:00	DIA	ETF	133.61	134.13	133.61	133.86	1508375.0
2007-12-21 11:00:00	DIA	ETF	133.87	134.18	133.84	133.98	1035200.0
2007-12-21 12:00:00	DIA	ETF	133.98	134.05	133.87	133.88	741835.0

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

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