PREVIEW / etf_30min / 2016-12-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-29.parquet
  size:    424 KB
  rows:    14,563

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-12-29 04:00:00	SPY	ETF	224.3	224.49	224.3	224.49	800.0
2016-12-29 04:30:00	SPY	ETF	224.44	224.44	224.41	224.41	4952.0
2016-12-29 05:00:00	SPY	ETF	224.42	224.44	224.4	224.44	1075.0
2016-12-29 05:30:00	SPY	ETF	224.51	224.6	224.51	224.54	5907.0
2016-12-29 06:30:00	SPY	ETF	224.52	224.52	224.47	224.5	1106.0
2016-12-29 07:00:00	SPY	ETF	224.48	224.57	224.48	224.55	17635.0
2016-12-29 07:30:00	SPY	ETF	224.56	224.63	224.56	224.63	95124.0
2016-12-29 08:00:00	SPY	ETF	224.55	224.69	224.51	224.59	95502.0
2016-12-29 08:30:00	SPY	ETF	224.63	224.63	224.46	224.52	107647.0
2016-12-29 09:00:00	SPY	ETF	224.53	224.6	224.4	224.45	159966.0
2016-12-29 09:30:00	SPY	ETF	224.48	224.89	224.39	224.57	4565978.0
2016-12-29 10:00:00	SPY	ETF	224.565	224.75	224.45	224.675	3702878.0
2016-12-29 10:30:00	SPY	ETF	224.69	224.695	224.24	224.295	3575445.0
2016-12-29 11:00:00	SPY	ETF	224.3	224.36	224.16	224.305	3737901.0
2016-12-29 11:30:00	SPY	ETF	224.31	224.385	224.04	224.13	2292125.0
2016-12-29 12:00:00	SPY	ETF	224.13	224.225	223.84	224.17	4125943.0
2016-12-29 12:30:00	SPY	ETF	224.18	224.31	224.1	224.15	3065012.0
2016-12-29 13:00:00	SPY	ETF	224.16	224.2	224.08	224.16	1733550.0
2016-12-29 13:30:00	SPY	ETF	224.15	224.17	223.96	224.17	1599451.0
2016-12-29 14:00:00	SPY	ETF	224.17	224.48	224.15	224.32	5049307.0
2016-12-29 14:30:00	SPY	ETF	224.32	224.389	224.17	224.29	1943563.0
2016-12-29 15:00:00	SPY	ETF	224.3	224.37	224.19	224.29	2810582.0
2016-12-29 15:30:00	SPY	ETF	224.28	224.37	224.18	224.37	5528771.0
2016-12-29 16:00:00	SPY	ETF	224.37	224.5	224.2533	224.4	3098140.0
2016-12-29 16:30:00	SPY	ETF	224.42	224.52	224.39	224.5	152055.0
2016-12-29 17:00:00	SPY	ETF	224.5	224.5	224.44	224.46	16714.0
2016-12-29 17:30:00	SPY	ETF	224.46	224.49	224.44	224.49	10534.0
2016-12-29 18:00:00	SPY	ETF	224.5	224.51	224.46	224.47	16107.0
2016-12-29 18:30:00	SPY	ETF	224.51	224.57	224.5	224.51	9822.0
2016-12-29 19:00:00	SPY	ETF	224.48	224.5	224.45	224.49	10996.0
2016-12-29 19:30:00	SPY	ETF	224.45	224.45	224.4	224.45	37809.0
2016-12-29 04:00:00	QQQ	ETF	119.81	119.81	119.81	119.81	300.0
2016-12-29 04:30:00	QQQ	ETF	119.84	119.84	119.84	119.84	300.0
2016-12-29 06:30:00	QQQ	ETF	119.84	119.84	119.84	119.84	688.0
2016-12-29 07:00:00	QQQ	ETF	119.86	119.91	119.86	119.91	639.0
2016-12-29 07:30:00	QQQ	ETF	119.94	119.96	119.94	119.94	4100.0
2016-12-29 08:00:00	QQQ	ETF	119.94	119.97	119.94	119.97	18365.0
2016-12-29 08:30:00	QQQ	ETF	119.91	119.96	119.87	119.96	62781.0
2016-12-29 09:00:00	QQQ	ETF	119.91	119.92	119.83	119.85	34307.0
2016-12-29 09:30:00	QQQ	ETF	119.85	120.13	119.68	119.771	1469252.0
2016-12-29 10:00:00	QQQ	ETF	119.78	119.975	119.7	119.89	572303.0
2016-12-29 10:30:00	QQQ	ETF	119.9	119.9	119.59	119.67	635830.0
2016-12-29 11:00:00	QQQ	ETF	119.66	119.6669	119.49	119.57	751315.0
2016-12-29 11:30:00	QQQ	ETF	119.58	119.6	119.37	119.425	1044850.0
2016-12-29 12:00:00	QQQ	ETF	119.43	119.62	119.33	119.59	774385.0
2016-12-29 12:30:00	QQQ	ETF	119.59	119.7188	119.57	119.621	761067.0
2016-12-29 13:00:00	QQQ	ETF	119.62	119.66	119.54	119.545	230714.0
2016-12-29 13:30:00	QQQ	ETF	119.545	119.56	119.39	119.485	505370.0
2016-12-29 14:00:00	QQQ	ETF	119.49	119.66	119.48	119.595	565269.0
2016-12-29 14:30:00	QQQ	ETF	119.6	119.65	119.52	119.605	847620.0

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

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