PREVIEW / etf_1hour / 2015-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-02.parquet
  size:    248 KB
  rows:    7,855

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
2015-12-02 04:00:00	SPY	ETF	210.89	211.0	210.76	210.93	17716.0
2015-12-02 05:00:00	SPY	ETF	210.91	211.11	210.9	211.01	9757.0
2015-12-02 06:00:00	SPY	ETF	211.0	211.09	210.78	210.78	20848.0
2015-12-02 07:00:00	SPY	ETF	210.81	210.84	210.48	210.81	210356.0
2015-12-02 08:00:00	SPY	ETF	210.77	210.91	210.46	210.58	459478.0
2015-12-02 09:00:00	SPY	ETF	210.56	210.95	210.45	210.8611	9329002.0
2015-12-02 10:00:00	SPY	ETF	210.865	211.0	210.49	210.6	10192864.0
2015-12-02 11:00:00	SPY	ETF	210.59	210.61	209.93	210.05	13171124.0
2015-12-02 12:00:00	SPY	ETF	210.06	210.34	209.82	210.085	8983952.0
2015-12-02 13:00:00	SPY	ETF	210.075	210.21	209.65	209.7185	10194693.0
2015-12-02 14:00:00	SPY	ETF	209.7108	209.72	208.27	208.39	20258362.0
2015-12-02 15:00:00	SPY	ETF	208.3899	209.065	208.23	208.5	28705440.0
2015-12-02 16:00:00	SPY	ETF	208.51	209.14	208.45	209.05	4506122.0
2015-12-02 17:00:00	SPY	ETF	209.05	213.54	208.54	209.0	729067.0
2015-12-02 18:00:00	SPY	ETF	209.0	209.04	208.48	208.88	218857.0
2015-12-02 19:00:00	SPY	ETF	208.85	208.97	208.75	208.94	53227.0
2015-12-02 04:00:00	QQQ	ETF	115.15	115.32	115.15	115.25	1200.0
2015-12-02 05:00:00	QQQ	ETF	115.4	115.46	115.37	115.37	300.0
2015-12-02 06:00:00	QQQ	ETF	115.36	115.36	115.33	115.33	300.0
2015-12-02 07:00:00	QQQ	ETF	115.31	115.31	115.19	115.23	20703.0
2015-12-02 08:00:00	QQQ	ETF	115.2	115.33	115.08	115.17	36130.0
2015-12-02 09:00:00	QQQ	ETF	115.2	115.68	115.18	115.66	2991431.0
2015-12-02 10:00:00	QQQ	ETF	115.66	115.75	115.47	115.5861	3149414.0
2015-12-02 11:00:00	QQQ	ETF	115.59	115.5969	115.32	115.44	2200021.0
2015-12-02 12:00:00	QQQ	ETF	115.45	115.62	115.35	115.57	1300147.0
2015-12-02 13:00:00	QQQ	ETF	115.55	115.58	115.14	115.17	1654453.0
2015-12-02 14:00:00	QQQ	ETF	115.17	115.17	114.29	114.35	5148121.0
2015-12-02 15:00:00	QQQ	ETF	114.35	114.755	114.28	114.47	4334309.0
2015-12-02 16:00:00	QQQ	ETF	114.47	114.78	114.45	114.73	854602.0
2015-12-02 17:00:00	QQQ	ETF	114.71	114.71	114.67	114.7	3139.0
2015-12-02 18:00:00	QQQ	ETF	114.73	114.74	114.52	114.68	8320.0
2015-12-02 19:00:00	QQQ	ETF	114.63	114.75	114.63	114.75	6420.0
2015-12-02 06:00:00	IWM	ETF	120.0	120.0	120.0	120.0	100.0
2015-12-02 07:00:00	IWM	ETF	119.96	119.96	119.88	119.9	1400.0
2015-12-02 08:00:00	IWM	ETF	119.95	119.95	119.71	119.71	15556.0
2015-12-02 09:00:00	IWM	ETF	119.71	119.97	119.6	119.88	1846067.0
2015-12-02 10:00:00	IWM	ETF	119.89	120.04	119.71	119.9	2409004.0
2015-12-02 11:00:00	IWM	ETF	119.89	119.91	119.23	119.3	2364912.0
2015-12-02 12:00:00	IWM	ETF	119.29	119.44	119.14	119.18	2147284.0
2015-12-02 13:00:00	IWM	ETF	119.169	119.39	119.05	119.18	1911315.0
2015-12-02 14:00:00	IWM	ETF	119.18	119.185	118.46	118.5	3839045.0
2015-12-02 15:00:00	IWM	ETF	118.49	118.91	118.45	118.62	5354921.0
2015-12-02 16:00:00	IWM	ETF	118.63	119.0	118.6	118.96	929514.0
2015-12-02 17:00:00	IWM	ETF	118.92	118.92	118.8	118.8	570.0
2015-12-02 18:00:00	IWM	ETF	118.85	118.85	118.84	118.85	10474.0
2015-12-02 19:00:00	IWM	ETF	118.8	118.8	118.8	118.8	500.0
2015-12-02 04:00:00	DIA	ETF	178.77	178.77	178.77	178.77	979.0
2015-12-02 08:00:00	DIA	ETF	178.56	178.69	178.56	178.6	2425.0
2015-12-02 09:00:00	DIA	ETF	178.6	179.01	178.55	178.94	433072.0
2015-12-02 10:00:00	DIA	ETF	178.94	179.04	178.67	178.81	560908.0

> showing 50 of 7,855 rows — these rows as CSV

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