PREVIEW / etf_30min / 2015-06-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-02.parquet
  size:    377 KB
  rows:    12,718

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
2015-06-02 04:00:00	SPY	ETF	211.61	211.61	210.7	210.7	9172.0
2015-06-02 04:30:00	SPY	ETF	210.85	210.92	210.01	210.2	36341.0
2015-06-02 05:00:00	SPY	ETF	210.26	210.49	210.16	210.49	14550.0
2015-06-02 05:30:00	SPY	ETF	210.48	210.65	210.39	210.51	37807.0
2015-06-02 06:00:00	SPY	ETF	210.57	211.56	210.57	211.48	84405.0
2015-06-02 06:30:00	SPY	ETF	211.43	211.48	210.98	211.06	105314.0
2015-06-02 07:00:00	SPY	ETF	211.12	211.27	210.81	210.98	160042.0
2015-06-02 07:30:00	SPY	ETF	210.99	211.22	210.84	211.01	259154.0
2015-06-02 08:00:00	SPY	ETF	211.01	211.56	210.46	210.91	1272601.0
2015-06-02 08:30:00	SPY	ETF	210.9	211.27	210.9	211.1	503223.0
2015-06-02 09:00:00	SPY	ETF	211.11	211.11	210.64	211.04	2105106.0
2015-06-02 09:30:00	SPY	ETF	211.02	211.14	210.27	210.769	16637414.0
2015-06-02 10:00:00	SPY	ETF	210.77	211.26	210.56	210.99	9524410.0
2015-06-02 10:30:00	SPY	ETF	210.985	211.47	210.95	211.15	5902743.0
2015-06-02 11:00:00	SPY	ETF	211.16	211.44	211.04	211.08	3906750.0
2015-06-02 11:30:00	SPY	ETF	211.08	211.3966	211.05	211.37	2306595.0
2015-06-02 12:00:00	SPY	ETF	211.38	211.99	211.35	211.81	5682956.0
2015-06-02 12:30:00	SPY	ETF	211.81	212.13	211.8	212.0	4966764.0
2015-06-02 13:00:00	SPY	ETF	212.0	212.19	211.93	211.976	2706701.0
2015-06-02 13:30:00	SPY	ETF	211.98	212.18	211.87	212.11	2669699.0
2015-06-02 14:00:00	SPY	ETF	212.12	212.15	211.75	211.84	3850324.0
2015-06-02 14:30:00	SPY	ETF	211.84	211.89	211.38	211.66	4909114.0
2015-06-02 15:00:00	SPY	ETF	211.66	211.665	211.32	211.43	5026909.0
2015-06-02 15:30:00	SPY	ETF	211.43	211.58	211.24	211.37	10853312.0
2015-06-02 16:00:00	SPY	ETF	211.36	211.39	211.18	211.26	3689017.0
2015-06-02 16:30:00	SPY	ETF	211.26	211.3	211.23	211.3	1946189.0
2015-06-02 17:00:00	SPY	ETF	211.3	211.3	211.26	211.26	18637.0
2015-06-02 17:30:00	SPY	ETF	211.28	211.3	211.25	211.29	33370.0
2015-06-02 18:00:00	SPY	ETF	211.3	211.37	211.3	211.3	41933.0
2015-06-02 18:30:00	SPY	ETF	211.35	211.39	211.34	211.38	3200.0
2015-06-02 19:00:00	SPY	ETF	211.36	211.36	211.34	211.34	4182.0
2015-06-02 19:30:00	SPY	ETF	211.35	211.42	211.35	211.4	12540.0
2015-06-02 04:00:00	QQQ	ETF	110.24	110.24	109.91	109.91	7450.0
2015-06-02 04:30:00	QQQ	ETF	109.87	109.87	109.54	109.54	22921.0
2015-06-02 05:00:00	QQQ	ETF	109.6	109.6	109.6	109.6	100.0
2015-06-02 06:00:00	QQQ	ETF	109.85	110.43	109.85	110.43	1100.0
2015-06-02 06:30:00	QQQ	ETF	110.42	110.42	110.2	110.26	9600.0
2015-06-02 07:00:00	QQQ	ETF	110.28	110.36	110.12	110.18	28134.0
2015-06-02 07:30:00	QQQ	ETF	110.22	110.27	110.17	110.18	8026.0
2015-06-02 08:00:00	QQQ	ETF	110.2	110.2	109.81	110.02	69948.0
2015-06-02 08:30:00	QQQ	ETF	110.06	110.26	110.04	110.18	35649.0
2015-06-02 09:00:00	QQQ	ETF	110.15	110.15	109.85	110.02	233105.0
2015-06-02 09:30:00	QQQ	ETF	110.01	110.11	109.47	109.79	4261658.0
2015-06-02 10:00:00	QQQ	ETF	109.79	110.1	109.66	109.94	2113681.0
2015-06-02 10:30:00	QQQ	ETF	109.93	110.26	109.9157	110.01	1340237.0
2015-06-02 11:00:00	QQQ	ETF	110.01	110.17	109.9361	109.94	749658.0
2015-06-02 11:30:00	QQQ	ETF	109.95	110.1	109.91	110.0957	496168.0
2015-06-02 12:00:00	QQQ	ETF	110.08	110.45	110.07	110.301	1419504.0
2015-06-02 12:30:00	QQQ	ETF	110.31	110.52	110.27	110.47	710538.0
2015-06-02 13:00:00	QQQ	ETF	110.465	110.61	110.43	110.47	898898.0

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

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