PREVIEW / etf_30min / 2016-09-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-22.parquet
  size:    406 KB
  rows:    13,996

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-09-22 04:00:00	SPY	ETF	215.82	215.99	215.82	215.85	1100.0
2016-09-22 04:30:00	SPY	ETF	215.9	216.01	215.9	216.0	7741.0
2016-09-22 05:00:00	SPY	ETF	216.13	216.48	216.13	216.4	13312.0
2016-09-22 05:30:00	SPY	ETF	216.41	216.47	216.37	216.46	10187.0
2016-09-22 06:00:00	SPY	ETF	216.48	216.66	216.48	216.62	34631.0
2016-09-22 06:30:00	SPY	ETF	216.62	216.62	216.43	216.43	13047.0
2016-09-22 07:00:00	SPY	ETF	216.45	216.62	216.45	216.61	178006.0
2016-09-22 07:30:00	SPY	ETF	216.61	216.72	216.6	216.71	169367.0
2016-09-22 08:00:00	SPY	ETF	216.72	216.8	216.44	216.76	365042.0
2016-09-22 08:30:00	SPY	ETF	216.76	216.91	216.7	216.81	621041.0
2016-09-22 09:00:00	SPY	ETF	216.81	217.02	216.8	216.99	532423.0
2016-09-22 09:30:00	SPY	ETF	217.0	217.42	216.91	217.3	11629081.0
2016-09-22 10:00:00	SPY	ETF	217.295	217.33	217.02	217.283	5466173.0
2016-09-22 10:30:00	SPY	ETF	217.29	217.53	217.135	217.135	5342264.0
2016-09-22 11:00:00	SPY	ETF	217.135	217.22	216.84	216.93	4588088.0
2016-09-22 11:30:00	SPY	ETF	216.92	217.2691	216.88	216.965	2945997.0
2016-09-22 12:00:00	SPY	ETF	216.965	217.13	216.89	217.1	2328640.0
2016-09-22 12:30:00	SPY	ETF	217.1032	217.21	217.01	217.2	2546803.0
2016-09-22 13:00:00	SPY	ETF	217.2001	217.42	217.165	217.24	2596425.0
2016-09-22 13:30:00	SPY	ETF	217.24	217.4199	217.19	217.27	2436248.0
2016-09-22 14:00:00	SPY	ETF	217.27	217.35	216.71	216.89	5099310.0
2016-09-22 14:30:00	SPY	ETF	216.89	217.3	216.725	217.29	4302101.0
2016-09-22 15:00:00	SPY	ETF	217.2889	217.38	217.15	217.22	5365479.0
2016-09-22 15:30:00	SPY	ETF	217.21	217.49	217.13	217.16	13625768.0
2016-09-22 16:00:00	SPY	ETF	217.16	217.24	216.94	217.06	4232403.0
2016-09-22 16:30:00	SPY	ETF	217.07	217.18	217.06	217.13	280091.0
2016-09-22 17:00:00	SPY	ETF	217.1	217.12	217.07	217.09	139008.0
2016-09-22 17:30:00	SPY	ETF	217.11	217.13	217.07	217.07	26003.0
2016-09-22 18:00:00	SPY	ETF	217.07	217.09	217.02	217.06	50029.0
2016-09-22 18:30:00	SPY	ETF	217.08	217.1	217.03	217.05	8488.0
2016-09-22 19:00:00	SPY	ETF	217.06	217.07	217.0	217.0	29350.0
2016-09-22 19:30:00	SPY	ETF	216.99	217.04	216.94	217.04	37974.0
2016-09-22 04:00:00	QQQ	ETF	118.29	118.29	118.29	118.29	100.0
2016-09-22 05:00:00	QQQ	ETF	118.44	118.56	118.44	118.56	1000.0
2016-09-22 05:30:00	QQQ	ETF	118.58	118.58	118.58	118.58	100.0
2016-09-22 06:00:00	QQQ	ETF	118.61	118.67	118.61	118.63	3898.0
2016-09-22 06:30:00	QQQ	ETF	118.63	118.63	118.55	118.55	3571.0
2016-09-22 07:00:00	QQQ	ETF	118.56	118.59	118.54	118.59	3699.0
2016-09-22 07:30:00	QQQ	ETF	118.59	118.71	118.59	118.71	8547.0
2016-09-22 08:00:00	QQQ	ETF	118.71	118.73	118.56	118.73	96466.0
2016-09-22 08:30:00	QQQ	ETF	118.72	118.8	118.71	118.8	39109.0
2016-09-22 09:00:00	QQQ	ETF	118.8	118.88	118.8	118.87	276368.0
2016-09-22 09:30:00	QQQ	ETF	118.86	118.96	118.7177	118.8601	3095171.0
2016-09-22 10:00:00	QQQ	ETF	118.87	119.02	118.76	118.98	1194236.0
2016-09-22 10:30:00	QQQ	ETF	118.99	119.12	118.83	118.87	890628.0
2016-09-22 11:00:00	QQQ	ETF	118.865	118.965	118.82	118.8863	1086025.0
2016-09-22 11:30:00	QQQ	ETF	118.89	118.99	118.86	118.94	851465.0
2016-09-22 12:00:00	QQQ	ETF	118.95	119.02	118.92	118.9929	478761.0
2016-09-22 12:30:00	QQQ	ETF	118.999	119.0601	118.99	119.0601	560513.0
2016-09-22 13:00:00	QQQ	ETF	119.06	119.22	119.04	119.11	952016.0

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

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