PREVIEW / etf_30min / 2016-09-20

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-20.parquet
  size:    390 KB
  rows:    13,462

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-20 04:00:00	SPY	ETF	214.04	214.2	213.93	213.93	12298.0
2016-09-20 04:30:00	SPY	ETF	213.87	214.0	213.87	213.99	10698.0
2016-09-20 05:00:00	SPY	ETF	214.04	214.15	214.02	214.13	13262.0
2016-09-20 05:30:00	SPY	ETF	214.11	214.3	214.11	214.3	1815.0
2016-09-20 06:00:00	SPY	ETF	214.3	214.4	214.15	214.28	142193.0
2016-09-20 06:30:00	SPY	ETF	214.33	214.37	214.26	214.27	22207.0
2016-09-20 07:00:00	SPY	ETF	214.27	214.41	214.21	214.41	308191.0
2016-09-20 07:30:00	SPY	ETF	214.41	214.41	214.17	214.21	169592.0
2016-09-20 08:00:00	SPY	ETF	214.19	214.36	214.19	214.34	226150.0
2016-09-20 08:30:00	SPY	ETF	214.31	214.44	214.19	214.29	311404.0
2016-09-20 09:00:00	SPY	ETF	214.27	214.44	214.25	214.41	460517.0
2016-09-20 09:30:00	SPY	ETF	214.41	214.55	214.03	214.36	7275673.0
2016-09-20 10:00:00	SPY	ETF	214.365	214.59	214.12	214.23	4515310.0
2016-09-20 10:30:00	SPY	ETF	214.23	214.3	213.75	213.94	6247111.0
2016-09-20 11:00:00	SPY	ETF	213.93	214.25	213.92	214.0066	3730830.0
2016-09-20 11:30:00	SPY	ETF	214.005	214.1	213.77	213.8	4285797.0
2016-09-20 12:00:00	SPY	ETF	213.805	214.035	213.68	213.99	3105851.0
2016-09-20 12:30:00	SPY	ETF	213.99	213.99	213.43	213.48	4390804.0
2016-09-20 13:00:00	SPY	ETF	213.47	214.3405	213.38	213.655	6313116.0
2016-09-20 13:30:00	SPY	ETF	213.66	213.96	213.56	213.88	3381854.0
2016-09-20 14:00:00	SPY	ETF	213.88	214.0	213.72	213.83	2148584.0
2016-09-20 14:30:00	SPY	ETF	213.83	214.1	213.79	214.008	2175917.0
2016-09-20 15:00:00	SPY	ETF	214.0	214.14	213.88	213.99	2840090.0
2016-09-20 15:30:00	SPY	ETF	213.99	214.02	213.4	213.43	12092069.0
2016-09-20 16:00:00	SPY	ETF	213.43	213.9093	213.27	213.36	3482221.0
2016-09-20 16:30:00	SPY	ETF	213.37	213.42	213.18	213.26	1122078.0
2016-09-20 17:00:00	SPY	ETF	213.27	213.3	213.25	213.3	61273.0
2016-09-20 17:30:00	SPY	ETF	213.29	213.32	213.19	213.31	109659.0
2016-09-20 18:00:00	SPY	ETF	213.28	213.5	213.28	213.45	107510.0
2016-09-20 18:30:00	SPY	ETF	213.45	213.53	213.38	213.45	192887.0
2016-09-20 19:00:00	SPY	ETF	213.45	213.51	213.44	213.48	22427.0
2016-09-20 19:30:00	SPY	ETF	213.49	213.52	213.42	213.44	15240.0
2016-09-20 04:00:00	QQQ	ETF	117.03	117.03	117.03	117.03	6000.0
2016-09-20 04:30:00	QQQ	ETF	117.03	117.03	117.03	117.03	100.0
2016-09-20 05:30:00	QQQ	ETF	117.13	117.19	117.13	117.19	300.0
2016-09-20 06:00:00	QQQ	ETF	117.18	117.27	117.18	117.26	900.0
2016-09-20 06:30:00	QQQ	ETF	117.2	117.24	117.2	117.21	23098.0
2016-09-20 07:00:00	QQQ	ETF	117.22	117.27	117.2	117.27	30549.0
2016-09-20 07:30:00	QQQ	ETF	117.25	117.26	117.16	117.17	71899.0
2016-09-20 08:00:00	QQQ	ETF	117.23	117.25	117.19	117.24	12800.0
2016-09-20 08:30:00	QQQ	ETF	117.3	117.32	117.13	117.15	87193.0
2016-09-20 09:00:00	QQQ	ETF	117.14	117.22	117.14	117.18	109669.0
2016-09-20 09:30:00	QQQ	ETF	117.19	117.45	117.061	117.36	1739314.0
2016-09-20 10:00:00	QQQ	ETF	117.37	117.48	117.1	117.2	982820.0
2016-09-20 10:30:00	QQQ	ETF	117.2	117.26	116.9	117.1	727587.0
2016-09-20 11:00:00	QQQ	ETF	117.1	117.2993	117.025	117.07	701712.0
2016-09-20 11:30:00	QQQ	ETF	117.079	117.14	116.96	116.97	391537.0
2016-09-20 12:00:00	QQQ	ETF	116.98	117.15	116.9307	117.1199	431075.0
2016-09-20 12:30:00	QQQ	ETF	117.12	117.13	116.84	116.855	520122.0
2016-09-20 13:00:00	QQQ	ETF	116.85	116.95	116.8	116.91	586195.0

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

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