PREVIEW / etf_30min / 2016-06-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-21.parquet
  size:    389 KB
  rows:    13,319

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-21 04:00:00	SPY	ETF	208.6	208.73	208.49	208.73	39772.0
2016-06-21 04:30:00	SPY	ETF	208.73	208.79	208.61	208.65	36033.0
2016-06-21 05:00:00	SPY	ETF	208.58	208.6	208.42	208.45	79215.0
2016-06-21 05:30:00	SPY	ETF	208.45	208.54	208.42	208.52	11682.0
2016-06-21 06:00:00	SPY	ETF	208.48	208.92	208.48	208.86	11915.0
2016-06-21 06:30:00	SPY	ETF	208.86	208.89	208.75	208.83	32839.0
2016-06-21 07:00:00	SPY	ETF	208.8	208.84	208.64	208.64	114082.0
2016-06-21 07:30:00	SPY	ETF	208.65	208.72	208.64	208.71	26812.0
2016-06-21 08:00:00	SPY	ETF	208.7	208.8	208.59	208.66	331159.0
2016-06-21 08:30:00	SPY	ETF	208.64	208.7	208.09	208.34	779335.0
2016-06-21 09:00:00	SPY	ETF	208.33	208.46	208.18	208.27	634565.0
2016-06-21 09:30:00	SPY	ETF	208.3	208.42	207.95	208.17	7029535.0
2016-06-21 10:00:00	SPY	ETF	208.16	208.33	207.78	208.11	7083910.0
2016-06-21 10:30:00	SPY	ETF	208.11	208.3724	207.99	208.12	6607313.0
2016-06-21 11:00:00	SPY	ETF	208.12	208.63	208.09	208.31	5921227.0
2016-06-21 11:30:00	SPY	ETF	208.3075	208.32	208.02	208.27	3190064.0
2016-06-21 12:00:00	SPY	ETF	208.28	208.48	208.16	208.475	2386928.0
2016-06-21 12:30:00	SPY	ETF	208.47	208.53	208.25	208.26	2366412.0
2016-06-21 13:00:00	SPY	ETF	208.27	208.41	208.13	208.205	2913363.0
2016-06-21 13:30:00	SPY	ETF	208.2	208.35	208.0	208.295	3200985.0
2016-06-21 14:00:00	SPY	ETF	208.295	208.62	208.2	208.55	3828917.0
2016-06-21 14:30:00	SPY	ETF	208.55	208.92	208.51	208.585	4664585.0
2016-06-21 15:00:00	SPY	ETF	208.5801	208.86	208.38	208.79	6645265.0
2016-06-21 15:30:00	SPY	ETF	208.78	208.82	208.34	208.39	9957476.0
2016-06-21 16:00:00	SPY	ETF	208.4	208.54	208.32	208.4075	3038981.0
2016-06-21 16:30:00	SPY	ETF	208.39	208.45	208.25	208.29	369550.0
2016-06-21 17:00:00	SPY	ETF	208.31	208.44	208.27	208.36	205341.0
2016-06-21 17:30:00	SPY	ETF	208.35	208.43	208.33	208.34	86374.0
2016-06-21 18:00:00	SPY	ETF	208.33	208.33	208.11	208.15	91625.0
2016-06-21 18:30:00	SPY	ETF	208.19	208.23	208.17	208.19	10470.0
2016-06-21 19:00:00	SPY	ETF	208.21	208.24	208.21	208.24	6175.0
2016-06-21 19:30:00	SPY	ETF	208.22	208.3	208.15	208.15	24178.0
2016-06-21 04:00:00	QQQ	ETF	107.56	107.56	107.56	107.56	1600.0
2016-06-21 04:30:00	QQQ	ETF	107.55	107.55	107.54	107.54	7400.0
2016-06-21 05:00:00	QQQ	ETF	107.51	107.51	107.39	107.39	1800.0
2016-06-21 05:30:00	QQQ	ETF	107.42	107.49	107.42	107.48	4599.0
2016-06-21 06:00:00	QQQ	ETF	107.48	107.65	107.48	107.65	1699.0
2016-06-21 06:30:00	QQQ	ETF	107.66	107.66	107.66	107.66	800.0
2016-06-21 07:00:00	QQQ	ETF	107.64	107.67	107.58	107.58	12248.0
2016-06-21 07:30:00	QQQ	ETF	107.57	107.63	107.57	107.63	5167.0
2016-06-21 08:00:00	QQQ	ETF	107.58	107.64	107.58	107.58	24819.0
2016-06-21 08:30:00	QQQ	ETF	107.54	107.54	107.29	107.43	90645.0
2016-06-21 09:00:00	QQQ	ETF	107.4	107.43	107.3	107.32	105866.0
2016-06-21 09:30:00	QQQ	ETF	107.32	107.62	107.25	107.5801	5252200.0
2016-06-21 10:00:00	QQQ	ETF	107.56	107.59	107.24	107.48	1885147.0
2016-06-21 10:30:00	QQQ	ETF	107.49	107.54	107.19	107.23	886373.0
2016-06-21 11:00:00	QQQ	ETF	107.23	107.52	107.19	107.31	1209530.0
2016-06-21 11:30:00	QQQ	ETF	107.29	107.4	107.1899	107.39	647081.0
2016-06-21 12:00:00	QQQ	ETF	107.39	107.57	107.33	107.55	470128.0
2016-06-21 12:30:00	QQQ	ETF	107.56	107.6	107.28	107.2999	451079.0

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

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