PREVIEW / etf_30min / 2016-07-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-27.parquet
  size:    402 KB
  rows:    13,492

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-07-27 04:00:00	SPY	ETF	217.15	217.2	217.12	217.19	6150.0
2016-07-27 04:30:00	SPY	ETF	217.19	217.22	217.12	217.17	9592.0
2016-07-27 05:00:00	SPY	ETF	217.17	217.17	217.13	217.13	2001.0
2016-07-27 05:30:00	SPY	ETF	217.12	217.12	217.0	217.0	7533.0
2016-07-27 06:00:00	SPY	ETF	217.0	217.1	217.0	217.1	5652.0
2016-07-27 06:30:00	SPY	ETF	217.1	217.1	217.02	217.07	6901.0
2016-07-27 07:00:00	SPY	ETF	217.06	217.1	216.97	216.99	70654.0
2016-07-27 07:30:00	SPY	ETF	217.02	217.16	217.0	217.15	37051.0
2016-07-27 08:00:00	SPY	ETF	217.14	217.18	217.04	217.16	188494.0
2016-07-27 08:30:00	SPY	ETF	217.15	217.22	216.96	217.16	258678.0
2016-07-27 09:00:00	SPY	ETF	217.2	217.26	217.16	217.19	266872.0
2016-07-27 09:30:00	SPY	ETF	217.19	217.27	216.8	217.07	5493004.0
2016-07-27 10:00:00	SPY	ETF	217.07	217.11	216.59	216.69	6937907.0
2016-07-27 10:30:00	SPY	ETF	216.68	216.68	216.21	216.39	6853551.0
2016-07-27 11:00:00	SPY	ETF	216.385	216.5	216.17	216.48	3689194.0
2016-07-27 11:30:00	SPY	ETF	216.48	216.49	216.07	216.105	3296367.0
2016-07-27 12:00:00	SPY	ETF	216.1	216.19	216.0	216.085	2601071.0
2016-07-27 12:30:00	SPY	ETF	216.08	216.24	216.03	216.11	3559192.0
2016-07-27 13:00:00	SPY	ETF	216.109	216.16	215.92	216.01	2239857.0
2016-07-27 13:30:00	SPY	ETF	216.005	216.36	215.96	216.2328	3586039.0
2016-07-27 14:00:00	SPY	ETF	216.24	216.81	215.62	216.44	13560979.0
2016-07-27 14:30:00	SPY	ETF	216.4399	216.71	216.39	216.61	4085783.0
2016-07-27 15:00:00	SPY	ETF	216.615	217.02	216.615	216.8189	5599285.0
2016-07-27 15:30:00	SPY	ETF	216.81	216.98	216.32	216.53	11288869.0
2016-07-27 16:00:00	SPY	ETF	216.54	216.56	216.21	216.33	8891928.0
2016-07-27 16:30:00	SPY	ETF	216.33	216.66	216.31	216.66	548490.0
2016-07-27 17:00:00	SPY	ETF	216.64	216.64	216.57	216.58	57316.0
2016-07-27 17:30:00	SPY	ETF	216.59	216.64	216.54	216.6	47179.0
2016-07-27 18:00:00	SPY	ETF	216.6	216.65	216.52	216.56	53349.0
2016-07-27 18:30:00	SPY	ETF	216.57	216.6	216.56	216.59	33603.0
2016-07-27 19:00:00	SPY	ETF	216.56	216.56	216.52	216.56	11703.0
2016-07-27 19:30:00	SPY	ETF	216.56	216.58	216.48	216.54	26935.0
2016-07-27 04:00:00	QQQ	ETF	114.5	114.51	114.5	114.51	1600.0
2016-07-27 04:30:00	QQQ	ETF	114.53	114.53	114.53	114.53	1000.0
2016-07-27 05:30:00	QQQ	ETF	114.48	114.5	114.48	114.5	1095.0
2016-07-27 06:00:00	QQQ	ETF	114.51	114.51	114.51	114.51	100.0
2016-07-27 06:30:00	QQQ	ETF	114.5	114.5	114.5	114.5	500.0
2016-07-27 07:00:00	QQQ	ETF	114.53	114.56	114.51	114.54	6105.0
2016-07-27 07:30:00	QQQ	ETF	114.57	114.71	114.57	114.7	7514.0
2016-07-27 08:00:00	QQQ	ETF	114.68	114.7	114.53	114.68	29073.0
2016-07-27 08:30:00	QQQ	ETF	114.67	114.73	114.63	114.68	48994.0
2016-07-27 09:00:00	QQQ	ETF	114.72	114.85	114.71	114.76	265380.0
2016-07-27 09:30:00	QQQ	ETF	114.76	114.77	114.44	114.7205	3826070.0
2016-07-27 10:00:00	QQQ	ETF	114.73	114.76	114.47	114.52	1068406.0
2016-07-27 10:30:00	QQQ	ETF	114.51	114.55	114.34	114.4	1829615.0
2016-07-27 11:00:00	QQQ	ETF	114.4	114.56	114.35	114.55	917290.0
2016-07-27 11:30:00	QQQ	ETF	114.55	114.55	114.34	114.35	448215.0
2016-07-27 12:00:00	QQQ	ETF	114.35	114.37	114.2343	114.3	603470.0
2016-07-27 12:30:00	QQQ	ETF	114.3	114.35	114.26	114.3	419566.0
2016-07-27 13:00:00	QQQ	ETF	114.3	114.35	114.26	114.31	317325.0

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

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