PREVIEW / etf_30min / 2017-01-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-13.parquet
  size:    422 KB
  rows:    14,355

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-01-13 04:00:00	SPY	ETF	226.53	226.54	226.53	226.54	200.0
2017-01-13 05:00:00	SPY	ETF	226.69	226.69	226.69	226.69	395.0
2017-01-13 05:30:00	SPY	ETF	226.69	226.82	226.69	226.82	1609.0
2017-01-13 06:00:00	SPY	ETF	226.78	226.8	226.73	226.79	18874.0
2017-01-13 06:30:00	SPY	ETF	226.76	226.76	226.63	226.64	2610.0
2017-01-13 07:00:00	SPY	ETF	226.69	226.73	226.62	226.67	9781.0
2017-01-13 07:30:00	SPY	ETF	226.72	226.75	226.59	226.75	166385.0
2017-01-13 08:00:00	SPY	ETF	226.67	226.8	226.48	226.51	248716.0
2017-01-13 08:30:00	SPY	ETF	226.51	226.72	226.4	226.68	178038.0
2017-01-13 09:00:00	SPY	ETF	226.7	226.81	226.65	226.73	288768.0
2017-01-13 09:30:00	SPY	ETF	226.73	227.4	226.73	227.2	7149237.0
2017-01-13 10:00:00	SPY	ETF	227.19	227.31	226.9865	227.11	3901586.0
2017-01-13 10:30:00	SPY	ETF	227.12	227.3	227.1	227.2062	2881500.0
2017-01-13 11:00:00	SPY	ETF	227.2	227.28	227.05	227.26	3936697.0
2017-01-13 11:30:00	SPY	ETF	227.26	227.33	227.0989	227.25	4499335.0
2017-01-13 12:00:00	SPY	ETF	227.26	227.29	226.81	226.9166	2904327.0
2017-01-13 12:30:00	SPY	ETF	226.92	227.105	226.91	227.085	1730648.0
2017-01-13 13:00:00	SPY	ETF	227.09	227.14	227.03	227.09	1407013.0
2017-01-13 13:30:00	SPY	ETF	227.095	227.15	226.96	226.999	1556888.0
2017-01-13 14:00:00	SPY	ETF	227.0	227.0599	226.69	226.69	3286840.0
2017-01-13 14:30:00	SPY	ETF	226.69	227.04	226.69	227.0	2208371.0
2017-01-13 15:00:00	SPY	ETF	226.99	227.0	226.86	226.95	2044009.0
2017-01-13 15:30:00	SPY	ETF	226.94	227.2	226.85	227.03	9898028.0
2017-01-13 16:00:00	SPY	ETF	227.04	227.32	226.96	227.26	13119539.0
2017-01-13 16:30:00	SPY	ETF	227.26	227.27	227.05	227.12	297464.0
2017-01-13 17:00:00	SPY	ETF	227.17	227.18	227.05	227.14	141253.0
2017-01-13 17:30:00	SPY	ETF	227.14	227.3	227.14	227.15	9610.0
2017-01-13 18:00:00	SPY	ETF	227.14	227.22	227.13	227.14	18457.0
2017-01-13 18:30:00	SPY	ETF	227.16	227.16	227.16	227.16	2041.0
2017-01-13 19:00:00	SPY	ETF	227.16	227.19	227.16	227.19	400.0
2017-01-13 19:30:00	SPY	ETF	227.17	227.22	227.16	227.22	6523.0
2017-01-13 05:00:00	QQQ	ETF	122.82	122.82	122.82	122.82	800.0
2017-01-13 06:00:00	QQQ	ETF	122.9	122.9	122.9	122.9	100.0
2017-01-13 06:30:00	QQQ	ETF	122.89	122.89	122.85	122.85	14896.0
2017-01-13 07:00:00	QQQ	ETF	122.86	122.86	122.84	122.84	7300.0
2017-01-13 07:30:00	QQQ	ETF	122.88	122.92	122.83	122.88	83447.0
2017-01-13 08:00:00	QQQ	ETF	122.88	123.02	122.79	122.8	160797.0
2017-01-13 08:30:00	QQQ	ETF	122.78	122.88	122.78	122.84	65719.0
2017-01-13 09:00:00	QQQ	ETF	122.87	122.91	122.8	122.82	224686.0
2017-01-13 09:30:00	QQQ	ETF	122.81	123.28	122.8	123.15	2509784.0
2017-01-13 10:00:00	QQQ	ETF	123.15	123.23	122.99	123.18	840064.0
2017-01-13 10:30:00	QQQ	ETF	123.1861	123.31	123.145	123.23	655641.0
2017-01-13 11:00:00	QQQ	ETF	123.24	123.31	123.11	123.28	844862.0
2017-01-13 11:30:00	QQQ	ETF	123.29	123.37	123.255	123.35	594761.0
2017-01-13 12:00:00	QQQ	ETF	123.35	123.36	123.11	123.12	891197.0
2017-01-13 12:30:00	QQQ	ETF	123.1107	123.2733	123.1107	123.26	317352.0
2017-01-13 13:00:00	QQQ	ETF	123.27	123.31	123.2365	123.27	284015.0
2017-01-13 13:30:00	QQQ	ETF	123.27	123.32	123.23	123.24	291734.0
2017-01-13 14:00:00	QQQ	ETF	123.24	123.28	123.07	123.075	803686.0
2017-01-13 14:30:00	QQQ	ETF	123.08	123.24	123.07	123.2165	469103.0

> showing 50 of 14,355 rows — these rows as CSV

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