PREVIEW / etf_30min / 2016-10-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-21.parquet
  size:    382 KB
  rows:    13,094

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
2016-10-21 04:00:00	SPY	ETF	213.51	213.66	213.51	213.63	4452.0
2016-10-21 04:30:00	SPY	ETF	213.57	213.58	213.33	213.33	8999.0
2016-10-21 05:00:00	SPY	ETF	213.32	213.49	213.3	213.43	6860.0
2016-10-21 05:30:00	SPY	ETF	213.4	213.68	213.4	213.66	8622.0
2016-10-21 06:00:00	SPY	ETF	213.66	213.67	213.47	213.48	12960.0
2016-10-21 06:30:00	SPY	ETF	213.44	213.52	213.34	213.34	17476.0
2016-10-21 07:00:00	SPY	ETF	213.35	213.47	213.28	213.45	63663.0
2016-10-21 07:30:00	SPY	ETF	213.45	213.49	213.38	213.49	54429.0
2016-10-21 08:00:00	SPY	ETF	213.42	213.88	213.32	213.4	1652819.0
2016-10-21 08:30:00	SPY	ETF	213.41	213.95	213.15	213.17	1122095.0
2016-10-21 09:00:00	SPY	ETF	213.17	213.18	212.79	212.96	1950141.0
2016-10-21 09:30:00	SPY	ETF	212.96	213.27	212.76	213.17	11651911.0
2016-10-21 10:00:00	SPY	ETF	213.17	213.315	212.98	213.26	17878651.0
2016-10-21 10:30:00	SPY	ETF	213.26	213.57	213.26	213.38	8032644.0
2016-10-21 11:00:00	SPY	ETF	213.38	213.54	213.29	213.4599	5029590.0
2016-10-21 11:30:00	SPY	ETF	213.45	213.77	213.35	213.665	3262580.0
2016-10-21 12:00:00	SPY	ETF	213.66	213.76	213.58	213.58	3360736.0
2016-10-21 12:30:00	SPY	ETF	213.58	213.62	213.49	213.61	2537844.0
2016-10-21 13:00:00	SPY	ETF	213.61	213.65	213.5	213.51	1730948.0
2016-10-21 13:30:00	SPY	ETF	213.51	213.84	213.36	213.81	3020982.0
2016-10-21 14:00:00	SPY	ETF	213.805	213.89	213.68	213.865	2010649.0
2016-10-21 14:30:00	SPY	ETF	213.8638	214.01	213.8	214.0	3188868.0
2016-10-21 15:00:00	SPY	ETF	213.99	214.08	213.83	213.91	4567156.0
2016-10-21 15:30:00	SPY	ETF	213.905	214.03	213.8	213.935	11017648.0
2016-10-21 16:00:00	SPY	ETF	213.97	214.01	213.81	213.88	3485637.0
2016-10-21 16:30:00	SPY	ETF	213.88	213.99	213.87	213.98	750666.0
2016-10-21 17:00:00	SPY	ETF	213.96	214.06	213.94	214.06	1324664.0
2016-10-21 17:30:00	SPY	ETF	214.06	214.14	214.01	214.02	71386.0
2016-10-21 18:00:00	SPY	ETF	214.02	214.06	213.92	214.02	61484.0
2016-10-21 18:30:00	SPY	ETF	214.02	214.02	213.96	213.96	4851.0
2016-10-21 19:00:00	SPY	ETF	213.99	213.99	213.96	213.99	2668.0
2016-10-21 19:30:00	SPY	ETF	213.98	214.03	213.97	214.03	28085.0
2016-10-21 04:30:00	QQQ	ETF	118.04	118.04	117.86	117.86	800.0
2016-10-21 05:00:00	QQQ	ETF	117.91	117.91	117.91	117.91	5000.0
2016-10-21 06:00:00	QQQ	ETF	118.02	118.02	117.97	117.97	400.0
2016-10-21 06:30:00	QQQ	ETF	117.98	117.98	117.95	117.95	1590.0
2016-10-21 07:00:00	QQQ	ETF	117.91	117.99	117.91	117.99	16723.0
2016-10-21 07:30:00	QQQ	ETF	118.03	118.04	117.97	118.03	2576.0
2016-10-21 08:00:00	QQQ	ETF	118.02	118.06	117.71	117.96	125716.0
2016-10-21 08:30:00	QQQ	ETF	117.97	118.01	117.89	117.9	17324.0
2016-10-21 09:00:00	QQQ	ETF	117.91	117.92	117.7	117.8	291886.0
2016-10-21 09:30:00	QQQ	ETF	117.8	117.891	117.41	117.83	2483878.0
2016-10-21 10:00:00	QQQ	ETF	117.82	117.86	117.67	117.8	737724.0
2016-10-21 10:30:00	QQQ	ETF	117.8	117.95	117.8	117.865	937810.0
2016-10-21 11:00:00	QQQ	ETF	117.86	118.04	117.81	118.02	756419.0
2016-10-21 11:30:00	QQQ	ETF	118.02	118.16	117.95	118.11	945823.0
2016-10-21 12:00:00	QQQ	ETF	118.105	118.15	117.9568	117.97	605667.0
2016-10-21 12:30:00	QQQ	ETF	117.97	118.02	117.93	118.0192	307654.0
2016-10-21 13:00:00	QQQ	ETF	118.021	118.07	117.98	117.98	370853.0
2016-10-21 13:30:00	QQQ	ETF	117.98	118.17	117.89	118.13	442417.0

> showing 50 of 13,094 rows — these rows as CSV

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