PREVIEW / etf_30min / 2016-06-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-13.parquet
  size:    396 KB
  rows:    13,527

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-13 04:00:00	SPY	ETF	209.6	209.94	209.6	209.77	112392.0
2016-06-13 04:30:00	SPY	ETF	209.72	209.72	209.46	209.46	6850.0
2016-06-13 05:00:00	SPY	ETF	209.43	209.49	209.27	209.3	15343.0
2016-06-13 05:30:00	SPY	ETF	209.39	209.47	209.32	209.33	9276.0
2016-06-13 06:00:00	SPY	ETF	209.34	209.44	209.32	209.34	13265.0
2016-06-13 06:30:00	SPY	ETF	209.31	209.39	209.27	209.34	29383.0
2016-06-13 07:00:00	SPY	ETF	209.41	209.58	209.35	209.52	153257.0
2016-06-13 07:30:00	SPY	ETF	209.53	209.76	209.48	209.59	87574.0
2016-06-13 08:00:00	SPY	ETF	209.58	209.68	209.37	209.5	326813.0
2016-06-13 08:30:00	SPY	ETF	209.51	209.68	209.45	209.47	507108.0
2016-06-13 09:00:00	SPY	ETF	209.48	209.53	209.18	209.38	735666.0
2016-06-13 09:30:00	SPY	ETF	209.36	210.11	209.34	209.9659	11658092.0
2016-06-13 10:00:00	SPY	ETF	209.97	210.23	209.72	210.14	9793604.0
2016-06-13 10:30:00	SPY	ETF	210.14	210.37	209.91	209.9789	7242277.0
2016-06-13 11:00:00	SPY	ETF	209.98	210.04	209.7	209.895	5472521.0
2016-06-13 11:30:00	SPY	ETF	209.9	209.9305	209.07	209.135	6875975.0
2016-06-13 12:00:00	SPY	ETF	209.14	209.68	209.05	209.42	7209181.0
2016-06-13 12:30:00	SPY	ETF	209.42	209.73	209.32	209.6	3741665.0
2016-06-13 13:00:00	SPY	ETF	209.61	209.695	209.33	209.58	4209756.0
2016-06-13 13:30:00	SPY	ETF	209.58	209.59	208.97	209.08	6914037.0
2016-06-13 14:00:00	SPY	ETF	209.09	209.59	208.98	209.124	4038668.0
2016-06-13 14:30:00	SPY	ETF	209.13	209.48	209.04	209.09	4637987.0
2016-06-13 15:00:00	SPY	ETF	209.095	209.17	208.66	208.82	10005261.0
2016-06-13 15:30:00	SPY	ETF	208.83	208.96	208.35	208.44	15419866.0
2016-06-13 16:00:00	SPY	ETF	208.46	208.63	208.35	208.35	4644925.0
2016-06-13 16:30:00	SPY	ETF	208.35	209.34	208.12	208.19	10955810.0
2016-06-13 17:00:00	SPY	ETF	208.2	208.23	208.07	208.1	171303.0
2016-06-13 17:30:00	SPY	ETF	208.1	208.15	208.05	208.15	145280.0
2016-06-13 18:00:00	SPY	ETF	208.15	208.21	207.91	207.96	116611.0
2016-06-13 18:30:00	SPY	ETF	207.93	208.05	207.9	207.95	68763.0
2016-06-13 19:00:00	SPY	ETF	207.97	208.08	207.95	208.07	21873.0
2016-06-13 19:30:00	SPY	ETF	208.02	208.2	208.02	208.16	52089.0
2016-06-13 04:00:00	QQQ	ETF	108.5	108.83	108.5	108.83	9042.0
2016-06-13 05:00:00	QQQ	ETF	108.54	108.6	108.54	108.6	1000.0
2016-06-13 05:30:00	QQQ	ETF	108.53	108.53	108.52	108.52	200.0
2016-06-13 06:00:00	QQQ	ETF	108.51	108.55	108.51	108.54	338.0
2016-06-13 06:30:00	QQQ	ETF	108.53	108.53	108.52	108.52	4000.0
2016-06-13 07:00:00	QQQ	ETF	108.53	108.56	108.49	108.51	14055.0
2016-06-13 07:30:00	QQQ	ETF	108.57	108.64	108.54	108.57	7827.0
2016-06-13 08:00:00	QQQ	ETF	108.55	108.59	108.51	108.51	282773.0
2016-06-13 08:30:00	QQQ	ETF	108.51	108.61	108.35	108.43	239307.0
2016-06-13 09:00:00	QQQ	ETF	108.43	108.47	108.28	108.36	384496.0
2016-06-13 09:30:00	QQQ	ETF	108.34	108.83	108.28	108.73	3246286.0
2016-06-13 10:00:00	QQQ	ETF	108.72	108.88	108.52	108.76	1840510.0
2016-06-13 10:30:00	QQQ	ETF	108.76	108.93	108.61	108.6451	1419689.0
2016-06-13 11:00:00	QQQ	ETF	108.65	108.75	108.559	108.6818	880600.0
2016-06-13 11:30:00	QQQ	ETF	108.69	108.7066	108.1	108.125	1744357.0
2016-06-13 12:00:00	QQQ	ETF	108.12	108.42	108.07	108.2792	1666308.0
2016-06-13 12:30:00	QQQ	ETF	108.27	108.54	108.26	108.45	830593.0
2016-06-13 13:00:00	QQQ	ETF	108.45	108.49	108.2808	108.44	480615.0

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

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