PREVIEW / etf_30min / 2016-07-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-07-19.parquet
  size:    387 KB
  rows:    13,300

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-07-19 04:00:00	SPY	ETF	215.81	215.81	215.6	215.73	11265.0
2016-07-19 04:30:00	SPY	ETF	215.75	215.84	215.6	215.73	9759.0
2016-07-19 05:00:00	SPY	ETF	215.71	215.84	215.7	215.8	7023.0
2016-07-19 05:30:00	SPY	ETF	215.76	215.78	215.7	215.73	11571.0
2016-07-19 06:00:00	SPY	ETF	215.7	215.73	215.63	215.66	29031.0
2016-07-19 06:30:00	SPY	ETF	215.68	215.94	215.68	215.9	16815.0
2016-07-19 07:00:00	SPY	ETF	215.91	215.93	215.82	215.93	21504.0
2016-07-19 07:30:00	SPY	ETF	215.93	216.03	215.9	215.92	145854.0
2016-07-19 08:00:00	SPY	ETF	215.93	215.99	215.85	215.94	143901.0
2016-07-19 08:30:00	SPY	ETF	215.95	216.08	215.89	215.9	225317.0
2016-07-19 09:00:00	SPY	ETF	215.91	215.95	215.81	215.93	209928.0
2016-07-19 09:30:00	SPY	ETF	215.92	216.16	215.71	215.84	7424584.0
2016-07-19 10:00:00	SPY	ETF	215.84	216.1	215.7	216.02	4168862.0
2016-07-19 10:30:00	SPY	ETF	216.02	216.09	215.8	216.04	3027278.0
2016-07-19 11:00:00	SPY	ETF	216.049	216.23	215.94	216.0311	3942661.0
2016-07-19 11:30:00	SPY	ETF	216.035	216.11	215.68	215.77	2992375.0
2016-07-19 12:00:00	SPY	ETF	215.77	215.89	215.68	215.825	2416411.0
2016-07-19 12:30:00	SPY	ETF	215.82	216.01	215.73	215.97	1824101.0
2016-07-19 13:00:00	SPY	ETF	215.96	215.97	215.68	215.71	1855308.0
2016-07-19 13:30:00	SPY	ETF	215.71	215.82	215.63	215.7	1676586.0
2016-07-19 14:00:00	SPY	ETF	215.7	215.955	215.69	215.891	1490357.0
2016-07-19 14:30:00	SPY	ETF	215.89	216.0	215.83	215.8701	1579330.0
2016-07-19 15:00:00	SPY	ETF	215.88	215.985	215.805	215.92	2253852.0
2016-07-19 15:30:00	SPY	ETF	215.92	216.16	215.89	216.15	7285976.0
2016-07-19 16:00:00	SPY	ETF	216.15	216.38	216.0	216.23	6605587.0
2016-07-19 16:30:00	SPY	ETF	216.23	216.32	216.18	216.32	2644842.0
2016-07-19 17:00:00	SPY	ETF	216.29	216.29	216.19	216.29	144210.0
2016-07-19 17:30:00	SPY	ETF	216.28	216.34	216.26	216.27	41611.0
2016-07-19 18:00:00	SPY	ETF	216.29	216.37	216.27	216.36	88100.0
2016-07-19 18:30:00	SPY	ETF	216.36	216.36	216.24	216.24	31321.0
2016-07-19 19:00:00	SPY	ETF	216.24	216.26	216.23	216.25	6158.0
2016-07-19 19:30:00	SPY	ETF	216.28	216.28	216.2	216.22	34089.0
2016-07-19 04:00:00	QQQ	ETF	112.1	112.12	112.1	112.12	200.0
2016-07-19 05:00:00	QQQ	ETF	112.13	112.13	112.13	112.13	800.0
2016-07-19 05:30:00	QQQ	ETF	112.14	112.14	112.11	112.11	2012.0
2016-07-19 06:00:00	QQQ	ETF	112.1	112.1	112.08	112.08	5599.0
2016-07-19 07:00:00	QQQ	ETF	112.13	112.17	112.13	112.17	600.0
2016-07-19 07:30:00	QQQ	ETF	112.16	112.19	112.11	112.13	8571.0
2016-07-19 08:00:00	QQQ	ETF	112.13	112.15	112.11	112.14	15659.0
2016-07-19 08:30:00	QQQ	ETF	112.16	112.24	112.13	112.19	309300.0
2016-07-19 09:00:00	QQQ	ETF	112.18	112.18	112.13	112.16	68588.0
2016-07-19 09:30:00	QQQ	ETF	112.17	112.48	111.97	112.06	5024210.0
2016-07-19 10:00:00	QQQ	ETF	112.07	112.292	112.01	112.215	857534.0
2016-07-19 10:30:00	QQQ	ETF	112.22	112.3	112.05	112.26	729346.0
2016-07-19 11:00:00	QQQ	ETF	112.25	112.36	112.21	112.27	591637.0
2016-07-19 11:30:00	QQQ	ETF	112.26	112.33	112.06	112.1144	991727.0
2016-07-19 12:00:00	QQQ	ETF	112.12	112.17	112.03	112.1	583610.0
2016-07-19 12:30:00	QQQ	ETF	112.1	112.22	112.08	112.18	454054.0
2016-07-19 13:00:00	QQQ	ETF	112.17	112.17	111.99	112.02	450125.0
2016-07-19 13:30:00	QQQ	ETF	112.02	112.08	111.93	111.9699	388355.0

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

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