PREVIEW / etf_30min / 2016-04-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-13.parquet
  size:    403 KB
  rows:    13,651

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-04-13 04:00:00	SPY	ETF	206.8	207.01	206.7	206.86	20300.0
2016-04-13 04:30:00	SPY	ETF	206.85	206.95	206.8	206.95	619.0
2016-04-13 05:00:00	SPY	ETF	206.96	207.3	206.96	207.25	14649.0
2016-04-13 05:30:00	SPY	ETF	207.24	207.26	207.07	207.08	24351.0
2016-04-13 06:00:00	SPY	ETF	207.09	207.14	206.94	207.02	21134.0
2016-04-13 06:30:00	SPY	ETF	207.02	207.21	207.0	207.21	103560.0
2016-04-13 07:00:00	SPY	ETF	207.22	207.29	207.04	207.04	198973.0
2016-04-13 07:30:00	SPY	ETF	207.07	207.25	207.07	207.13	241395.0
2016-04-13 08:00:00	SPY	ETF	207.12	207.23	198.86	207.09	424229.0
2016-04-13 08:30:00	SPY	ETF	207.1	207.15	206.77	206.9	551725.0
2016-04-13 09:00:00	SPY	ETF	206.9	207.11	206.9	207.01	351852.0
2016-04-13 09:30:00	SPY	ETF	207.0	207.45	206.92	207.285	11536274.0
2016-04-13 10:00:00	SPY	ETF	207.29	207.4	207.15	207.3	7185887.0
2016-04-13 10:30:00	SPY	ETF	207.31	207.44	206.84	207.07	8778086.0
2016-04-13 11:00:00	SPY	ETF	207.06	207.49	207.0121	207.46	6233478.0
2016-04-13 11:30:00	SPY	ETF	207.46	207.8	207.45	207.57	7286927.0
2016-04-13 12:00:00	SPY	ETF	207.57	207.61	207.21	207.42	4588037.0
2016-04-13 12:30:00	SPY	ETF	207.41	207.55	207.25	207.42	2738288.0
2016-04-13 13:00:00	SPY	ETF	207.415	207.45	207.15	207.36	3449285.0
2016-04-13 13:30:00	SPY	ETF	207.36	207.71	207.32	207.65	4887586.0
2016-04-13 14:00:00	SPY	ETF	207.64	207.88	207.5	207.54	5563320.0
2016-04-13 14:30:00	SPY	ETF	207.5375	207.75	207.52	207.59	4966332.0
2016-04-13 15:00:00	SPY	ETF	207.585	207.9	207.55	207.82	5592737.0
2016-04-13 15:30:00	SPY	ETF	207.825	208.1	207.78	208.02	13180332.0
2016-04-13 16:00:00	SPY	ETF	208.02	208.04	207.92	208.02	4256582.0
2016-04-13 16:30:00	SPY	ETF	208.02	208.05	205.9398	208.0	1660231.0
2016-04-13 17:00:00	SPY	ETF	208.0	208.07	207.98	208.06	168917.0
2016-04-13 17:30:00	SPY	ETF	208.06	208.09	208.0	208.07	269335.0
2016-04-13 18:00:00	SPY	ETF	208.05	208.09	207.95	207.95	224284.0
2016-04-13 18:30:00	SPY	ETF	208.0	208.02	207.94	208.0	28713.0
2016-04-13 19:00:00	SPY	ETF	208.0	208.04	208.0	208.03	16270.0
2016-04-13 19:30:00	SPY	ETF	208.04	208.08	207.95	208.08	128198.0
2016-04-13 04:00:00	QQQ	ETF	110.07	110.23	110.07	110.13	798.0
2016-04-13 04:30:00	QQQ	ETF	110.19	110.19	110.19	110.19	2000.0
2016-04-13 05:00:00	QQQ	ETF	110.25	110.44	110.25	110.43	2699.0
2016-04-13 05:30:00	QQQ	ETF	110.36	110.39	110.36	110.36	2196.0
2016-04-13 06:00:00	QQQ	ETF	110.33	110.39	110.29	110.29	6106.0
2016-04-13 06:30:00	QQQ	ETF	110.35	110.36	110.35	110.35	655.0
2016-04-13 07:00:00	QQQ	ETF	110.33	110.39	110.28	110.29	85466.0
2016-04-13 07:30:00	QQQ	ETF	110.29	110.4	110.29	110.35	61824.0
2016-04-13 08:00:00	QQQ	ETF	110.32	110.34	110.27	110.33	74010.0
2016-04-13 08:30:00	QQQ	ETF	110.32	110.37	110.2	110.28	48905.0
2016-04-13 09:00:00	QQQ	ETF	110.27	110.41	110.27	110.34	143354.0
2016-04-13 09:30:00	QQQ	ETF	110.32	110.82	110.21	110.725	3539902.0
2016-04-13 10:00:00	QQQ	ETF	110.725	110.92	110.62	110.805	2353084.0
2016-04-13 10:30:00	QQQ	ETF	110.81	110.86	110.49	110.52	1802681.0
2016-04-13 11:00:00	QQQ	ETF	110.51	110.76	110.48	110.735	1286620.0
2016-04-13 11:30:00	QQQ	ETF	110.74	110.894	110.43	110.61	1502671.0
2016-04-13 12:00:00	QQQ	ETF	110.61	110.64	110.4	110.615	1169153.0
2016-04-13 12:30:00	QQQ	ETF	110.62	110.69	110.466	110.56	871625.0

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

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