PREVIEW / etf_1hour / 2015-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-05.parquet
  size:    239 KB
  rows:    7,599

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-08-05 04:00:00	SPY	ETF	209.35	209.54	209.27	209.54	4959.0
2015-08-05 05:00:00	SPY	ETF	209.54	209.72	209.51	209.7	4584.0
2015-08-05 06:00:00	SPY	ETF	209.7	209.98	209.7	209.91	175278.0
2015-08-05 07:00:00	SPY	ETF	209.87	210.42	209.86	210.22	636846.0
2015-08-05 08:00:00	SPY	ETF	210.2	210.94	209.87	210.48	2057070.0
2015-08-05 09:00:00	SPY	ETF	210.48	211.09	210.39	210.9098	13006026.0
2015-08-05 10:00:00	SPY	ETF	210.93	211.31	210.66	211.04	13106573.0
2015-08-05 11:00:00	SPY	ETF	211.045	211.17	210.48	210.53	10837682.0
2015-08-05 12:00:00	SPY	ETF	210.52	210.58	209.9	210.33	11343679.0
2015-08-05 13:00:00	SPY	ETF	210.34	210.35	209.73	209.95	8420977.0
2015-08-05 14:00:00	SPY	ETF	209.94	210.4	209.86	210.235	6750989.0
2015-08-05 15:00:00	SPY	ETF	210.24	210.51	209.99	210.09	13579496.0
2015-08-05 16:00:00	SPY	ETF	210.08	211.37	209.98	210.09	5001924.0
2015-08-05 17:00:00	SPY	ETF	210.09	210.13	210.01	210.02	298772.0
2015-08-05 18:00:00	SPY	ETF	210.02	210.06	209.97	209.98	66550.0
2015-08-05 19:00:00	SPY	ETF	209.99	210.01	209.92	209.93	120456.0
2015-08-05 06:00:00	QQQ	ETF	111.53	111.64	111.49	111.52	30800.0
2015-08-05 07:00:00	QQQ	ETF	111.62	111.96	111.6	111.88	40300.0
2015-08-05 08:00:00	QQQ	ETF	111.86	112.36	111.61	112.03	421478.0
2015-08-05 09:00:00	QQQ	ETF	112.03	112.71	111.88	112.65	5366659.0
2015-08-05 10:00:00	QQQ	ETF	112.65	112.8899	112.5	112.84	4290552.0
2015-08-05 11:00:00	QQQ	ETF	112.84	113.0	112.69	112.72	2940299.0
2015-08-05 12:00:00	QQQ	ETF	112.715	112.72	112.25	112.55	3853255.0
2015-08-05 13:00:00	QQQ	ETF	112.55	112.56	112.07	112.16	2602011.0
2015-08-05 14:00:00	QQQ	ETF	112.16	112.53	112.12	112.35	2102086.0
2015-08-05 15:00:00	QQQ	ETF	112.36	112.52	112.18	112.23	3660385.0
2015-08-05 16:00:00	QQQ	ETF	112.23	112.3	112.07	112.17	715033.0
2015-08-05 17:00:00	QQQ	ETF	112.17	112.18	112.17	112.17	910.0
2015-08-05 18:00:00	QQQ	ETF	112.08	112.1	112.08	112.1	8130.0
2015-08-05 19:00:00	QQQ	ETF	112.09	112.12	112.04	112.04	33300.0
2015-08-05 07:00:00	IWM	ETF	122.41	122.49	122.41	122.45	18398.0
2015-08-05 08:00:00	IWM	ETF	122.45	122.98	122.45	122.64	342755.0
2015-08-05 09:00:00	IWM	ETF	122.67	123.4199	122.56	123.13	2578172.0
2015-08-05 10:00:00	IWM	ETF	123.18	123.53	123.06	123.18	4056198.0
2015-08-05 11:00:00	IWM	ETF	123.18	123.37	122.715	122.78	2778118.0
2015-08-05 12:00:00	IWM	ETF	122.78	122.85	122.07	122.47	4526909.0
2015-08-05 13:00:00	IWM	ETF	122.465	122.48	121.91	122.24	2862158.0
2015-08-05 14:00:00	IWM	ETF	122.235	122.54	122.15	122.29	1536006.0
2015-08-05 15:00:00	IWM	ETF	122.28	122.61	122.15	122.33	2889275.0
2015-08-05 16:00:00	IWM	ETF	122.33	122.48	122.27	122.36	941387.0
2015-08-05 17:00:00	IWM	ETF	122.4	122.43	122.31	122.32	8880.0
2015-08-05 06:00:00	DIA	ETF	175.5	175.5	175.5	175.5	100.0
2015-08-05 07:00:00	DIA	ETF	175.52	175.84	175.52	175.75	4100.0
2015-08-05 08:00:00	DIA	ETF	175.7	176.4	175.68	176.08	4926.0
2015-08-05 09:00:00	DIA	ETF	176.0	176.26	175.74	176.04	790871.0
2015-08-05 10:00:00	DIA	ETF	176.09	176.52	175.9	176.26	774360.0
2015-08-05 11:00:00	DIA	ETF	176.26	176.38	175.73	175.804	337766.0
2015-08-05 12:00:00	DIA	ETF	175.8	175.84	175.13	175.51	674914.0
2015-08-05 13:00:00	DIA	ETF	175.5	175.51	175.032	175.28	836218.0
2015-08-05 14:00:00	DIA	ETF	175.28	175.59	175.239	175.45	403328.0

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

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