PREVIEW / etf_30min / 2016-06-02

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-02.parquet
  size:    384 KB
  rows:    12,916

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-02 04:00:00	SPY	ETF	209.87	209.94	209.78	209.94	2260.0
2016-06-02 04:30:00	SPY	ETF	209.93	210.1	209.93	210.06	4524.0
2016-06-02 05:00:00	SPY	ETF	210.03	210.16	210.03	210.12	5512.0
2016-06-02 05:30:00	SPY	ETF	210.1	210.23	210.1	210.23	1607.0
2016-06-02 06:00:00	SPY	ETF	210.22	210.22	210.09	210.15	2341.0
2016-06-02 06:30:00	SPY	ETF	210.14	210.25	210.14	210.23	5564.0
2016-06-02 07:00:00	SPY	ETF	210.26	210.27	210.15	210.18	19047.0
2016-06-02 07:30:00	SPY	ETF	210.18	210.24	210.18	210.2	18286.0
2016-06-02 08:00:00	SPY	ETF	210.18	210.22	209.901	210.13	189504.0
2016-06-02 08:30:00	SPY	ETF	210.14	210.14	209.75	209.81	347096.0
2016-06-02 09:00:00	SPY	ETF	209.82	209.85	209.6	209.79	765824.0
2016-06-02 09:30:00	SPY	ETF	209.8	209.91	209.2399	209.41	8070308.0
2016-06-02 10:00:00	SPY	ETF	209.41	209.77	209.35	209.605	4924969.0
2016-06-02 10:30:00	SPY	ETF	209.615	209.92	209.58	209.82	3606667.0
2016-06-02 11:00:00	SPY	ETF	209.82	210.09	209.75	209.92	4295507.0
2016-06-02 11:30:00	SPY	ETF	209.92	210.19	209.81	210.12	3297649.0
2016-06-02 12:00:00	SPY	ETF	210.1111	210.13	209.86	209.91	2561662.0
2016-06-02 12:30:00	SPY	ETF	209.9	210.2	209.78	210.17	3074716.0
2016-06-02 13:00:00	SPY	ETF	210.1601	210.32	210.13	210.17	2231564.0
2016-06-02 13:30:00	SPY	ETF	210.17	210.41	210.12	210.39	2665796.0
2016-06-02 14:00:00	SPY	ETF	210.39	210.67	210.385	210.55	4401261.0
2016-06-02 14:30:00	SPY	ETF	210.54	210.59	210.46	210.5765	2492285.0
2016-06-02 15:00:00	SPY	ETF	210.57	210.71	210.42	210.7	3496206.0
2016-06-02 15:30:00	SPY	ETF	210.7	210.91	210.5	210.91	10568409.0
2016-06-02 16:00:00	SPY	ETF	210.91	210.98	210.6143	210.87	4623242.0
2016-06-02 16:30:00	SPY	ETF	210.88	211.04	210.87	210.97	418625.0
2016-06-02 17:00:00	SPY	ETF	210.97	210.98	210.91	210.93	43222.0
2016-06-02 17:30:00	SPY	ETF	210.94	210.98	210.9	210.97	61681.0
2016-06-02 18:00:00	SPY	ETF	210.95	210.95	210.85	210.91	38454.0
2016-06-02 18:30:00	SPY	ETF	210.91	210.91	210.86	210.87	13502.0
2016-06-02 19:00:00	SPY	ETF	210.87	210.9	210.85	210.87	10975.0
2016-06-02 19:30:00	SPY	ETF	210.85	211.04	210.85	211.02	42571.0
2016-06-02 04:00:00	QQQ	ETF	110.12	110.12	110.12	110.12	200.0
2016-06-02 05:00:00	QQQ	ETF	110.31	110.31	110.31	110.31	1500.0
2016-06-02 06:00:00	QQQ	ETF	110.28	110.28	110.28	110.28	500.0
2016-06-02 06:30:00	QQQ	ETF	110.33	110.34	110.31	110.31	4900.0
2016-06-02 07:00:00	QQQ	ETF	110.31	110.32	110.3	110.32	13998.0
2016-06-02 07:30:00	QQQ	ETF	110.33	110.33	110.32	110.32	700.0
2016-06-02 08:00:00	QQQ	ETF	110.29	110.3	110.19	110.29	13535.0
2016-06-02 08:30:00	QQQ	ETF	110.35	110.35	110.12	110.15	30040.0
2016-06-02 09:00:00	QQQ	ETF	110.12	110.15	110.05	110.12	67376.0
2016-06-02 09:30:00	QQQ	ETF	110.13	110.16	109.53	109.67	2128940.0
2016-06-02 10:00:00	QQQ	ETF	109.67	110.07	109.644	110.0	1213813.0
2016-06-02 10:30:00	QQQ	ETF	110.0	110.16	109.98	110.05	1322774.0
2016-06-02 11:00:00	QQQ	ETF	110.06	110.27	110.01	110.12	1065239.0
2016-06-02 11:30:00	QQQ	ETF	110.12	110.21	110.04	110.1	615962.0
2016-06-02 12:00:00	QQQ	ETF	110.11	110.11	109.91	109.94	404802.0
2016-06-02 12:30:00	QQQ	ETF	109.95	110.16	109.86	110.155	543483.0
2016-06-02 13:00:00	QQQ	ETF	110.16	110.26	110.12	110.15	485151.0
2016-06-02 13:30:00	QQQ	ETF	110.145	110.301	110.09	110.28	639789.0

> showing 50 of 12,916 rows — these rows as CSV

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