PREVIEW / etf_30min / 2017-02-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-15.parquet
  size:    446 KB
  rows:    15,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
2017-02-15 04:00:00	SPY	ETF	233.9	233.9	233.78	233.78	1300.0
2017-02-15 05:00:00	SPY	ETF	233.83	233.83	233.82	233.82	2000.0
2017-02-15 05:30:00	SPY	ETF	233.75	233.79	233.64	233.64	7451.0
2017-02-15 06:00:00	SPY	ETF	233.69	233.75	233.67	233.7	3620.0
2017-02-15 06:30:00	SPY	ETF	233.7	233.77	233.7	233.7	1800.0
2017-02-15 07:00:00	SPY	ETF	233.74	233.85	233.71	233.77	32181.0
2017-02-15 07:30:00	SPY	ETF	233.78	233.78	233.7	233.75	17271.0
2017-02-15 08:00:00	SPY	ETF	233.71	233.79	233.56	233.64	129045.0
2017-02-15 08:30:00	SPY	ETF	233.62	233.66	233.35	233.4	675934.0
2017-02-15 09:00:00	SPY	ETF	233.4	233.48	233.32	233.44	679799.0
2017-02-15 09:30:00	SPY	ETF	233.45	233.79	233.39	233.765	6201679.0
2017-02-15 10:00:00	SPY	ETF	233.76	233.83	233.53	233.79	6214278.0
2017-02-15 10:30:00	SPY	ETF	233.79	234.14	233.76	234.13	6281766.0
2017-02-15 11:00:00	SPY	ETF	234.12	234.46	234.08	234.39	5394873.0
2017-02-15 11:30:00	SPY	ETF	234.4	234.45	233.9034	234.11	4426768.0
2017-02-15 12:00:00	SPY	ETF	234.11	234.24	233.99	234.1999	3222834.0
2017-02-15 12:30:00	SPY	ETF	234.2	234.39	234.165	234.29	3516649.0
2017-02-15 13:00:00	SPY	ETF	234.29	234.45	234.14	234.38	3529483.0
2017-02-15 13:30:00	SPY	ETF	234.38	234.74	234.29	234.5665	4393541.0
2017-02-15 14:00:00	SPY	ETF	234.5608	234.75	234.5	234.71	4170968.0
2017-02-15 14:30:00	SPY	ETF	234.71	234.82	234.64	234.805	3803554.0
2017-02-15 15:00:00	SPY	ETF	234.8098	235.14	234.72	234.995	8136442.0
2017-02-15 15:30:00	SPY	ETF	234.99	235.04	234.79	234.87	12632459.0
2017-02-15 16:00:00	SPY	ETF	234.87	235.26	234.86	235.12	8965763.0
2017-02-15 16:30:00	SPY	ETF	235.13	235.3	234.91	235.21	2053672.0
2017-02-15 17:00:00	SPY	ETF	235.19	235.26	234.92	235.23	267586.0
2017-02-15 17:30:00	SPY	ETF	235.24	235.26	234.92	235.23	246113.0
2017-02-15 18:00:00	SPY	ETF	235.22	235.24	235.14	235.19	79340.0
2017-02-15 18:30:00	SPY	ETF	235.19	235.19	235.11	235.15	95098.0
2017-02-15 19:00:00	SPY	ETF	235.16	235.16	235.08	235.08	30700.0
2017-02-15 19:30:00	SPY	ETF	235.1	235.1	235.0	235.01	125305.0
2017-02-15 04:00:00	QQQ	ETF	128.69	128.69	128.69	128.69	200.0
2017-02-15 04:30:00	QQQ	ETF	128.62	128.62	128.62	128.62	100.0
2017-02-15 05:00:00	QQQ	ETF	128.62	128.62	128.62	128.62	100.0
2017-02-15 05:30:00	QQQ	ETF	128.59	128.59	128.54	128.54	4100.0
2017-02-15 06:00:00	QQQ	ETF	128.55	128.58	128.55	128.58	900.0
2017-02-15 06:30:00	QQQ	ETF	128.57	128.64	128.57	128.57	16103.0
2017-02-15 07:00:00	QQQ	ETF	128.6	128.65	128.6	128.64	19500.0
2017-02-15 07:30:00	QQQ	ETF	128.61	128.61	128.57	128.57	1279.0
2017-02-15 08:00:00	QQQ	ETF	128.66	128.66	128.51	128.52	48405.0
2017-02-15 08:30:00	QQQ	ETF	128.5	128.54	128.36	128.41	254263.0
2017-02-15 09:00:00	QQQ	ETF	128.4	128.45	128.37	128.44	293693.0
2017-02-15 09:30:00	QQQ	ETF	128.44	128.67	128.37	128.659	1295750.0
2017-02-15 10:00:00	QQQ	ETF	128.65	128.67	128.505	128.61	1462804.0
2017-02-15 10:30:00	QQQ	ETF	128.62	128.77	128.6084	128.7465	747758.0
2017-02-15 11:00:00	QQQ	ETF	128.73	128.96	128.705	128.95	1155555.0
2017-02-15 11:30:00	QQQ	ETF	128.95	128.98	128.68	128.81	1184048.0
2017-02-15 12:00:00	QQQ	ETF	128.815	128.87	128.74	128.8432	510390.0
2017-02-15 12:30:00	QQQ	ETF	128.84	128.95	128.81	128.9	489023.0
2017-02-15 13:00:00	QQQ	ETF	128.9	128.99	128.8	128.96	555875.0

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

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