PREVIEW / etf_30min / 2016-06-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-29.parquet
  size:    419 KB
  rows:    14,128

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-06-29 04:00:00	SPY	ETF	203.82	204.24	203.82	204.08	28006.0
2016-06-29 04:30:00	SPY	ETF	204.12	204.34	203.94	204.2	37649.0
2016-06-29 05:00:00	SPY	ETF	204.3	204.3	204.16	204.22	4662.0
2016-06-29 05:30:00	SPY	ETF	204.24	204.38	204.16	204.3	28644.0
2016-06-29 06:00:00	SPY	ETF	204.4	204.8	204.4	204.7	56966.0
2016-06-29 06:30:00	SPY	ETF	204.7	204.73	204.47	204.52	61387.0
2016-06-29 07:00:00	SPY	ETF	204.53	204.67	204.29	204.35	163573.0
2016-06-29 07:30:00	SPY	ETF	204.36	204.65	204.24	204.65	321613.0
2016-06-29 08:00:00	SPY	ETF	204.64	204.75	203.22	204.61	591367.0
2016-06-29 08:30:00	SPY	ETF	204.62	204.99	204.5	204.88	919982.0
2016-06-29 09:00:00	SPY	ETF	204.86	204.91	204.6	204.82	1336415.0
2016-06-29 09:30:00	SPY	ETF	204.84	205.24	204.72	205.0	16315772.0
2016-06-29 10:00:00	SPY	ETF	205.0	205.6	204.91	205.53	12203197.0
2016-06-29 10:30:00	SPY	ETF	205.525	205.74	205.36	205.575	8455544.0
2016-06-29 11:00:00	SPY	ETF	205.58	205.98	205.575	205.96	7145194.0
2016-06-29 11:30:00	SPY	ETF	205.95	206.245	205.85	206.12	7375884.0
2016-06-29 12:00:00	SPY	ETF	206.11	206.43	206.07	206.39	5704728.0
2016-06-29 12:30:00	SPY	ETF	206.39	206.39	206.02	206.07	5990004.0
2016-06-29 13:00:00	SPY	ETF	206.08	206.18	205.8845	206.05	4451482.0
2016-06-29 13:30:00	SPY	ETF	206.055	206.26	206.04	206.2468	3293252.0
2016-06-29 14:00:00	SPY	ETF	206.25	206.61	206.2	206.52	6996941.0
2016-06-29 14:30:00	SPY	ETF	206.515	206.73	206.36	206.63	7755372.0
2016-06-29 15:00:00	SPY	ETF	206.63	206.93	206.62	206.86	10442470.0
2016-06-29 15:30:00	SPY	ETF	206.865	206.87	206.43	206.67	21792568.0
2016-06-29 16:00:00	SPY	ETF	206.68	207.18	206.64	207.14	9726503.0
2016-06-29 16:30:00	SPY	ETF	207.14	207.93	206.66	207.84	1625477.0
2016-06-29 17:00:00	SPY	ETF	207.82	208.4866	206.4866	207.45	935022.0
2016-06-29 17:30:00	SPY	ETF	207.44	207.63	207.44	207.57	114190.0
2016-06-29 18:00:00	SPY	ETF	207.56	207.7	207.48	207.48	186421.0
2016-06-29 18:30:00	SPY	ETF	207.46	207.54	207.39	207.39	76975.0
2016-06-29 19:00:00	SPY	ETF	207.4	207.42	207.29	207.29	111881.0
2016-06-29 19:30:00	SPY	ETF	207.3	207.34	207.16	207.26	126664.0
2016-06-29 04:00:00	QQQ	ETF	104.96	104.97	104.95	104.95	2042.0
2016-06-29 04:30:00	QQQ	ETF	104.98	105.08	104.98	105.08	400.0
2016-06-29 05:00:00	QQQ	ETF	105.01	105.01	104.95	104.95	1500.0
2016-06-29 05:30:00	QQQ	ETF	104.99	104.99	104.99	104.99	400.0
2016-06-29 06:00:00	QQQ	ETF	105.17	105.33	105.17	105.33	4913.0
2016-06-29 06:30:00	QQQ	ETF	105.31	105.31	105.22	105.22	2200.0
2016-06-29 07:00:00	QQQ	ETF	105.17	105.26	105.1	105.1	14882.0
2016-06-29 07:30:00	QQQ	ETF	105.14	105.25	105.05	105.25	27511.0
2016-06-29 08:00:00	QQQ	ETF	105.25	105.25	105.05	105.15	119594.0
2016-06-29 08:30:00	QQQ	ETF	105.13	105.34	105.1	105.31	144268.0
2016-06-29 09:00:00	QQQ	ETF	105.27	105.32	105.18	105.26	343943.0
2016-06-29 09:30:00	QQQ	ETF	105.26	105.735	105.231	105.63	3588721.0
2016-06-29 10:00:00	QQQ	ETF	105.63	105.82	105.51	105.77	4410932.0
2016-06-29 10:30:00	QQQ	ETF	105.76	105.8599	105.54	105.66	2587683.0
2016-06-29 11:00:00	QQQ	ETF	105.66	106.03	105.66	106.01	1987959.0
2016-06-29 11:30:00	QQQ	ETF	106.01	106.17	105.94	106.14	1474329.0
2016-06-29 12:00:00	QQQ	ETF	106.1268	106.32	106.09	106.3	1487053.0
2016-06-29 12:30:00	QQQ	ETF	106.3	106.3	106.08	106.12	1319928.0

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

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