PREVIEW / etf_30min / 2015-11-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-02.parquet
  size:    391 KB
  rows:    13,157

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-11-02 04:00:00	SPY	ETF	207.51	207.78	207.43	207.78	21594.0
2015-11-02 04:30:00	SPY	ETF	207.79	208.21	207.79	208.15	10322.0
2015-11-02 05:00:00	SPY	ETF	208.11	208.13	207.91	207.98	5387.0
2015-11-02 05:30:00	SPY	ETF	208.13	208.16	208.06	208.06	10691.0
2015-11-02 06:00:00	SPY	ETF	208.13	208.21	208.13	208.21	9600.0
2015-11-02 06:30:00	SPY	ETF	208.19	208.29	208.1	208.11	30980.0
2015-11-02 07:00:00	SPY	ETF	208.08	208.11	208.02	208.02	77971.0
2015-11-02 07:30:00	SPY	ETF	208.03	208.11	207.92	208.0	114856.0
2015-11-02 08:00:00	SPY	ETF	208.03	208.19	207.35	208.15	131157.0
2015-11-02 08:30:00	SPY	ETF	208.14	208.36	208.06	208.34	247657.0
2015-11-02 09:00:00	SPY	ETF	208.33	208.49	207.93	208.32	624436.0
2015-11-02 09:30:00	SPY	ETF	208.32	209.03	208.17	208.96	9592506.0
2015-11-02 10:00:00	SPY	ETF	208.96	209.3	208.83	209.155	6786212.0
2015-11-02 10:30:00	SPY	ETF	209.16	209.22	209.0	209.14	6733364.0
2015-11-02 11:00:00	SPY	ETF	209.14	209.47	209.07	209.26	5339314.0
2015-11-02 11:30:00	SPY	ETF	209.27	209.32	209.14	209.285	4255238.0
2015-11-02 12:00:00	SPY	ETF	209.29	209.4	209.2001	209.4	2352588.0
2015-11-02 12:30:00	SPY	ETF	209.4	209.63	209.27	209.59	3731231.0
2015-11-02 13:00:00	SPY	ETF	209.58	209.69	209.43	209.58	2873341.0
2015-11-02 13:30:00	SPY	ETF	209.58	209.73	209.53	209.73	3488782.0
2015-11-02 14:00:00	SPY	ETF	209.725	209.91	209.71	209.8639	3847854.0
2015-11-02 14:30:00	SPY	ETF	209.87	210.38	209.84	210.35	6360871.0
2015-11-02 15:00:00	SPY	ETF	210.35	210.61	210.22	210.541	7623065.0
2015-11-02 15:30:00	SPY	ETF	210.55	210.62	210.21	210.37	12497117.0
2015-11-02 16:00:00	SPY	ETF	210.38	210.4	209.6014	210.1	4401588.0
2015-11-02 16:30:00	SPY	ETF	210.1	210.39	209.91	209.93	1380980.0
2015-11-02 17:00:00	SPY	ETF	209.93	210.03	209.93	210.0	1607975.0
2015-11-02 17:30:00	SPY	ETF	210.01	210.02	209.95	209.95	26548.0
2015-11-02 18:00:00	SPY	ETF	209.96	210.08	209.88	209.9	101218.0
2015-11-02 18:30:00	SPY	ETF	209.97	210.09	209.96	210.07	9291.0
2015-11-02 19:00:00	SPY	ETF	210.01	210.24	210.01	210.24	30283.0
2015-11-02 19:30:00	SPY	ETF	210.18	210.33	210.18	210.28	53769.0
2015-11-02 04:30:00	QQQ	ETF	113.54	113.54	113.54	113.54	500.0
2015-11-02 05:00:00	QQQ	ETF	113.45	113.45	113.4	113.4	400.0
2015-11-02 05:30:00	QQQ	ETF	113.48	113.5	113.48	113.5	2500.0
2015-11-02 06:00:00	QQQ	ETF	113.5	113.54	113.5	113.54	2500.0
2015-11-02 06:30:00	QQQ	ETF	113.53	113.55	113.48	113.51	3895.0
2015-11-02 07:00:00	QQQ	ETF	113.48	113.48	113.48	113.48	800.0
2015-11-02 07:30:00	QQQ	ETF	113.48	113.54	113.43	113.54	4438.0
2015-11-02 08:00:00	QQQ	ETF	113.51	113.6	113.51	113.57	22173.0
2015-11-02 08:30:00	QQQ	ETF	113.58	113.68	113.53	113.68	43684.0
2015-11-02 09:00:00	QQQ	ETF	113.69	113.74	113.6	113.62	102806.0
2015-11-02 09:30:00	QQQ	ETF	113.63	113.86	113.39	113.83	2711479.0
2015-11-02 10:00:00	QQQ	ETF	113.83	114.1	113.76	114.05	2411877.0
2015-11-02 10:30:00	QQQ	ETF	114.05	114.07	113.93	114.06	1782828.0
2015-11-02 11:00:00	QQQ	ETF	114.06	114.28	114.0201	114.15	1414816.0
2015-11-02 11:30:00	QQQ	ETF	114.15	114.2399	114.1	114.22	990167.0
2015-11-02 12:00:00	QQQ	ETF	114.22	114.25	114.13	114.23	571696.0
2015-11-02 12:30:00	QQQ	ETF	114.24	114.3301	114.16	114.3	836583.0
2015-11-02 13:00:00	QQQ	ETF	114.3	114.36	114.23	114.29	748448.0

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

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