PREVIEW / etf_30min / 2016-11-30

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-11-30.parquet
  size:    446 KB
  rows:    15,141

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-11-30 04:00:00	SPY	ETF	221.18	221.44	221.18	221.28	8027.0
2016-11-30 04:30:00	SPY	ETF	221.21	221.24	221.03	221.11	14800.0
2016-11-30 05:00:00	SPY	ETF	221.06	221.14	220.93	221.14	3638.0
2016-11-30 05:30:00	SPY	ETF	221.23	221.25	221.15	221.16	5331.0
2016-11-30 06:00:00	SPY	ETF	221.2	221.32	221.17	221.3	14474.0
2016-11-30 06:30:00	SPY	ETF	221.29	221.39	221.29	221.39	20517.0
2016-11-30 07:00:00	SPY	ETF	221.44	221.54	221.39	221.42	214424.0
2016-11-30 07:30:00	SPY	ETF	221.4	221.5	221.37	221.43	250174.0
2016-11-30 08:00:00	SPY	ETF	221.41	221.51	221.33	221.36	331586.0
2016-11-30 08:30:00	SPY	ETF	221.38	221.55	221.35	221.5	962237.0
2016-11-30 09:00:00	SPY	ETF	221.52	221.84	221.51	221.63	1328068.0
2016-11-30 09:30:00	SPY	ETF	221.63	221.82	221.39	221.45	9219869.0
2016-11-30 10:00:00	SPY	ETF	221.44	221.59	220.94	221.08	8369996.0
2016-11-30 10:30:00	SPY	ETF	221.08	221.31	221.06	221.22	4977066.0
2016-11-30 11:00:00	SPY	ETF	221.22	221.65	221.11	221.13	5289060.0
2016-11-30 11:30:00	SPY	ETF	221.13	221.33	221.01	221.07	3625915.0
2016-11-30 12:00:00	SPY	ETF	221.07	221.15	220.89	220.98	3251001.0
2016-11-30 12:30:00	SPY	ETF	220.99	221.179	220.94	221.13	2949133.0
2016-11-30 13:00:00	SPY	ETF	221.13	221.3	221.08	221.19	5115417.0
2016-11-30 13:30:00	SPY	ETF	221.1863	221.3	221.1	221.1985	2935597.0
2016-11-30 14:00:00	SPY	ETF	221.195	221.2	220.67	220.79	6867050.0
2016-11-30 14:30:00	SPY	ETF	220.78	220.78	220.5	220.58	5096885.0
2016-11-30 15:00:00	SPY	ETF	220.583	221.06	220.44	220.985	11087666.0
2016-11-30 15:30:00	SPY	ETF	220.985	220.9975	220.31	220.33	17631329.0
2016-11-30 16:00:00	SPY	ETF	220.34	220.54	220.2922	220.4	18834442.0
2016-11-30 16:30:00	SPY	ETF	220.4	220.42	220.26	220.39	1104556.0
2016-11-30 17:00:00	SPY	ETF	220.38	220.39	220.34	220.38	189832.0
2016-11-30 17:30:00	SPY	ETF	220.39	220.43	220.33	220.42	64043.0
2016-11-30 18:00:00	SPY	ETF	220.42	220.43	220.21	220.36	82143.0
2016-11-30 18:30:00	SPY	ETF	220.39	220.5	220.35	220.48	821498.0
2016-11-30 19:00:00	SPY	ETF	220.42	220.44	220.31	220.31	24326.0
2016-11-30 19:30:00	SPY	ETF	220.35	220.39	220.31	220.35	15003.0
2016-11-30 04:00:00	QQQ	ETF	119.04	119.04	119.04	119.04	1100.0
2016-11-30 04:30:00	QQQ	ETF	119.03	119.03	119.03	119.03	287.0
2016-11-30 05:30:00	QQQ	ETF	119.01	119.05	119.0	119.0	2719.0
2016-11-30 06:00:00	QQQ	ETF	119.07	119.07	119.07	119.07	250.0
2016-11-30 07:00:00	QQQ	ETF	119.08	119.15	119.08	119.1	5007.0
2016-11-30 07:30:00	QQQ	ETF	119.11	119.12	119.06	119.06	86099.0
2016-11-30 08:00:00	QQQ	ETF	119.08	119.09	118.95	118.98	39095.0
2016-11-30 08:30:00	QQQ	ETF	118.95	118.99	118.94	118.99	48157.0
2016-11-30 09:00:00	QQQ	ETF	119.0	119.17	119.0	119.05	214463.0
2016-11-30 09:30:00	QQQ	ETF	119.04	119.1335	118.68	118.75	3320784.0
2016-11-30 10:00:00	QQQ	ETF	118.75	118.78	118.12	118.26	2535781.0
2016-11-30 10:30:00	QQQ	ETF	118.26	118.42	118.21	118.295	1446907.0
2016-11-30 11:00:00	QQQ	ETF	118.29	118.52	118.18	118.18	1749104.0
2016-11-30 11:30:00	QQQ	ETF	118.18	118.29	117.87	117.9	1901481.0
2016-11-30 12:00:00	QQQ	ETF	117.89	117.95	117.71	117.82	1365387.0
2016-11-30 12:30:00	QQQ	ETF	117.82	118.01	117.7845	118.01	1080158.0
2016-11-30 13:00:00	QQQ	ETF	118.0	118.05	117.94	118.02	806782.0
2016-11-30 13:30:00	QQQ	ETF	118.0225	118.03	117.9	117.94	1064151.0

> showing 50 of 15,141 rows — these rows as CSV

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