PREVIEW / etf_30min / 2017-02-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-09.parquet
  size:    429 KB
  rows:    14,703

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-09 04:00:00	SPY	ETF	229.2	229.27	229.2	229.27	1300.0
2017-02-09 04:30:00	SPY	ETF	229.26	229.26	229.26	229.26	500.0
2017-02-09 05:00:00	SPY	ETF	229.24	229.28	229.24	229.28	430.0
2017-02-09 05:30:00	SPY	ETF	229.35	229.35	229.23	229.23	3700.0
2017-02-09 06:00:00	SPY	ETF	229.39	229.8	229.39	229.77	28295.0
2017-02-09 06:30:00	SPY	ETF	229.77	229.8	229.7	229.73	89425.0
2017-02-09 07:00:00	SPY	ETF	229.7	229.73	229.64	229.64	43326.0
2017-02-09 07:30:00	SPY	ETF	229.64	229.67	229.5	229.62	81227.0
2017-02-09 08:00:00	SPY	ETF	229.68	229.68	229.43	229.5	86998.0
2017-02-09 08:30:00	SPY	ETF	229.5	229.51	229.37	229.45	231876.0
2017-02-09 09:00:00	SPY	ETF	229.45	229.55	229.43	229.55	264824.0
2017-02-09 09:30:00	SPY	ETF	229.56	229.81	229.52	229.7601	5515580.0
2017-02-09 10:00:00	SPY	ETF	229.77	230.2	229.73	230.18	5584047.0
2017-02-09 10:30:00	SPY	ETF	230.17	230.53	230.11	230.49	6237444.0
2017-02-09 11:00:00	SPY	ETF	230.49	230.79	230.4	230.735	3501516.0
2017-02-09 11:30:00	SPY	ETF	230.74	230.79	230.57	230.645	3770711.0
2017-02-09 12:00:00	SPY	ETF	230.65	230.78	230.51	230.54	3178080.0
2017-02-09 12:30:00	SPY	ETF	230.55	230.61	230.4399	230.555	2733185.0
2017-02-09 13:00:00	SPY	ETF	230.56	230.69	230.51	230.68	2604659.0
2017-02-09 13:30:00	SPY	ETF	230.68	230.74	230.55	230.74	1888091.0
2017-02-09 14:00:00	SPY	ETF	230.74	230.81	230.7	230.75	5932796.0
2017-02-09 14:30:00	SPY	ETF	230.75	230.95	230.73	230.87	2870575.0
2017-02-09 15:00:00	SPY	ETF	230.88	230.94	230.73	230.745	3625454.0
2017-02-09 15:30:00	SPY	ETF	230.74	230.75	230.54	230.57	8616116.0
2017-02-09 16:00:00	SPY	ETF	230.57	230.65	230.5	230.58	5888278.0
2017-02-09 16:30:00	SPY	ETF	230.58	230.62	230.51	230.59	159192.0
2017-02-09 17:00:00	SPY	ETF	230.6	230.64	230.38	230.57	494442.0
2017-02-09 17:30:00	SPY	ETF	230.57	230.6	230.56	230.59	13563.0
2017-02-09 18:00:00	SPY	ETF	230.6	230.6	230.51	230.58	83807.0
2017-02-09 18:30:00	SPY	ETF	230.6	230.63	230.58	230.6	18364.0
2017-02-09 19:00:00	SPY	ETF	230.58	230.58	230.53	230.55	16586.0
2017-02-09 19:30:00	SPY	ETF	230.57	230.6	230.57	230.6	10295.0
2017-02-09 05:30:00	QQQ	ETF	126.63	126.65	126.63	126.65	15000.0
2017-02-09 06:00:00	QQQ	ETF	126.65	126.78	126.65	126.78	12750.0
2017-02-09 07:00:00	QQQ	ETF	126.75	126.75	126.71	126.71	3800.0
2017-02-09 07:30:00	QQQ	ETF	126.69	126.69	126.63	126.66	2199.0
2017-02-09 08:00:00	QQQ	ETF	126.66	126.66	126.6	126.65	11635.0
2017-02-09 08:30:00	QQQ	ETF	126.62	126.63	126.5	126.58	27201.0
2017-02-09 09:00:00	QQQ	ETF	126.64	126.66	126.61	126.66	136135.0
2017-02-09 09:30:00	QQQ	ETF	126.63	126.83	126.56	126.719	1704795.0
2017-02-09 10:00:00	QQQ	ETF	126.71	126.91	126.66	126.87	1231847.0
2017-02-09 10:30:00	QQQ	ETF	126.86	126.94	126.77	126.9	1273432.0
2017-02-09 11:00:00	QQQ	ETF	126.91	127.15	126.87	127.12	1244756.0
2017-02-09 11:30:00	QQQ	ETF	127.12	127.219	127.12	127.14	686812.0
2017-02-09 12:00:00	QQQ	ETF	127.14	127.165	127.03	127.04	736271.0
2017-02-09 12:30:00	QQQ	ETF	127.0407	127.075	126.93	127.021	608324.0
2017-02-09 13:00:00	QQQ	ETF	127.02	127.11	126.995	127.085	694127.0
2017-02-09 13:30:00	QQQ	ETF	127.09	127.14	127.02	127.14	797422.0
2017-02-09 14:00:00	QQQ	ETF	127.135	127.19	127.11	127.135	527632.0
2017-02-09 14:30:00	QQQ	ETF	127.139	127.24	127.13	127.18	596827.0

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

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