PREVIEW / etf_30min / 2016-09-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-09.parquet
  size:    430 KB
  rows:    14,522

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-09 04:00:00	SPY	ETF	218.14	218.14	217.92	217.97	7762.0
2016-09-09 04:30:00	SPY	ETF	217.98	218.14	217.98	218.12	6761.0
2016-09-09 05:00:00	SPY	ETF	218.1	218.14	218.06	218.06	4005.0
2016-09-09 05:30:00	SPY	ETF	218.07	218.07	217.98	218.02	7148.0
2016-09-09 06:00:00	SPY	ETF	218.02	218.04	217.84	217.84	31375.0
2016-09-09 06:30:00	SPY	ETF	217.83	217.83	217.72	217.74	64410.0
2016-09-09 07:00:00	SPY	ETF	217.75	217.75	217.61	217.62	64218.0
2016-09-09 07:30:00	SPY	ETF	217.67	217.7	217.35	217.53	777332.0
2016-09-09 08:00:00	SPY	ETF	217.52	218.359	217.0	217.24	956906.0
2016-09-09 08:30:00	SPY	ETF	217.24	217.28	217.02	217.07	833977.0
2016-09-09 09:00:00	SPY	ETF	217.07	217.24	216.93	216.96	926079.0
2016-09-09 09:30:00	SPY	ETF	216.97	217.03	216.2899	216.52	20057574.0
2016-09-09 10:00:00	SPY	ETF	216.52	216.64	216.16	216.355	17271232.0
2016-09-09 10:30:00	SPY	ETF	216.36	216.4	215.74	216.15	13157754.0
2016-09-09 11:00:00	SPY	ETF	216.15	216.2	215.86	216.16	8613337.0
2016-09-09 11:30:00	SPY	ETF	216.16	216.2	215.51	215.605	7862845.0
2016-09-09 12:00:00	SPY	ETF	215.605	215.76	215.26	215.44	8866197.0
2016-09-09 12:30:00	SPY	ETF	215.435	215.47	215.2038	215.42	7447390.0
2016-09-09 13:00:00	SPY	ETF	215.42	215.425	214.78	215.03	10939687.0
2016-09-09 13:30:00	SPY	ETF	215.023	215.03	214.38	214.61	13243941.0
2016-09-09 14:00:00	SPY	ETF	214.61	214.615	214.0	214.551	14179228.0
2016-09-09 14:30:00	SPY	ETF	214.555	214.72	214.06	214.435	19707069.0
2016-09-09 15:00:00	SPY	ETF	214.435	214.55	213.99	214.385	20108006.0
2016-09-09 15:30:00	SPY	ETF	214.385	214.45	213.25	213.28	31799320.0
2016-09-09 16:00:00	SPY	ETF	213.28	213.6226	212.79	212.93	15796429.0
2016-09-09 16:30:00	SPY	ETF	212.94	213.32	212.59	212.77	1763601.0
2016-09-09 17:00:00	SPY	ETF	212.72	213.28	212.72	212.76	1333893.0
2016-09-09 17:30:00	SPY	ETF	212.76	213.32	212.71	212.83	1008842.0
2016-09-09 18:00:00	SPY	ETF	212.86	212.87	212.73	212.74	184301.0
2016-09-09 18:30:00	SPY	ETF	212.75	212.75	212.63	212.7	43101.0
2016-09-09 19:00:00	SPY	ETF	212.71	212.75	212.63	212.7	26668.0
2016-09-09 19:30:00	SPY	ETF	212.7	212.7	212.63	212.63	61273.0
2016-09-09 04:00:00	QQQ	ETF	117.03	117.03	116.87	116.9	40700.0
2016-09-09 04:30:00	QQQ	ETF	116.92	116.97	116.92	116.92	59100.0
2016-09-09 05:30:00	QQQ	ETF	116.93	116.93	116.9	116.9	5935.0
2016-09-09 06:00:00	QQQ	ETF	116.85	116.88	116.85	116.88	10099.0
2016-09-09 06:30:00	QQQ	ETF	116.8	116.84	116.8	116.84	11199.0
2016-09-09 07:00:00	QQQ	ETF	116.8	116.8	116.77	116.77	13400.0
2016-09-09 07:30:00	QQQ	ETF	116.78	116.8	116.6	116.67	51818.0
2016-09-09 08:00:00	QQQ	ETF	116.67	116.68	116.34	116.44	131454.0
2016-09-09 08:30:00	QQQ	ETF	116.42	116.46	116.29	116.32	86699.0
2016-09-09 09:00:00	QQQ	ETF	116.34	116.41	116.22	116.22	263068.0
2016-09-09 09:30:00	QQQ	ETF	116.22	116.51	116.2	116.298	3872612.0
2016-09-09 10:00:00	QQQ	ETF	116.3	116.45	116.17	116.3	2273357.0
2016-09-09 10:30:00	QQQ	ETF	116.3	116.3799	115.85	116.02	2774027.0
2016-09-09 11:00:00	QQQ	ETF	116.01	116.05	115.8	115.9285	2019507.0
2016-09-09 11:30:00	QQQ	ETF	115.92	115.94	115.47	115.56	1776259.0
2016-09-09 12:00:00	QQQ	ETF	115.555	115.64	115.26	115.39	2374298.0
2016-09-09 12:30:00	QQQ	ETF	115.38	115.4407	115.2	115.33	1783206.0
2016-09-09 13:00:00	QQQ	ETF	115.34	115.35	114.97	115.12	1771921.0

> showing 50 of 14,522 rows — these rows as CSV

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