PREVIEW / etf_30min / 2017-10-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-09.parquet
  size:    420 KB
  rows:    14,545

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-10-09 04:00:00	SPY	ETF	254.51	254.51	254.45	254.47	1683.0
2017-10-09 04:30:00	SPY	ETF	254.48	254.51	254.48	254.51	802.0
2017-10-09 05:00:00	SPY	ETF	254.47	254.47	254.47	254.47	105.0
2017-10-09 06:00:00	SPY	ETF	254.57	254.57	254.57	254.57	353.0
2017-10-09 06:30:00	SPY	ETF	254.64	254.65	254.62	254.62	2600.0
2017-10-09 07:00:00	SPY	ETF	254.64	254.71	254.62	254.71	13205.0
2017-10-09 07:30:00	SPY	ETF	254.7	254.78	254.7	254.74	99199.0
2017-10-09 08:00:00	SPY	ETF	254.37	254.78	254.37	254.69	53827.0
2017-10-09 08:30:00	SPY	ETF	254.7	254.7	254.59	254.61	140166.0
2017-10-09 09:00:00	SPY	ETF	254.62	254.73	254.62	254.64	250457.0
2017-10-09 09:30:00	SPY	ETF	254.63	254.7	254.15	254.26	4137167.0
2017-10-09 10:00:00	SPY	ETF	254.26	254.34	254.18	254.23	1982722.0
2017-10-09 10:30:00	SPY	ETF	254.22	254.37	254.07	254.22	1511375.0
2017-10-09 11:00:00	SPY	ETF	254.22	254.38	254.19	254.36	1062994.0
2017-10-09 11:30:00	SPY	ETF	254.35	254.42	254.31	254.37	778333.0
2017-10-09 12:00:00	SPY	ETF	254.38	254.4	254.26	254.27	584280.0
2017-10-09 12:30:00	SPY	ETF	254.28	254.32	254.19	254.22	735234.0
2017-10-09 13:00:00	SPY	ETF	254.2164	254.3	254.21	254.3	503487.0
2017-10-09 13:30:00	SPY	ETF	254.295	254.3	254.24	254.28	1576123.0
2017-10-09 14:00:00	SPY	ETF	254.29	254.3	254.14	254.145	1350274.0
2017-10-09 14:30:00	SPY	ETF	254.14	254.15	253.98	253.99	1462157.0
2017-10-09 15:00:00	SPY	ETF	253.985	253.99	253.66	253.905	3241275.0
2017-10-09 15:30:00	SPY	ETF	253.9	253.99	253.65	253.96	8295334.0
2017-10-09 16:00:00	SPY	ETF	253.95	254.13	253.95	254.13	6204565.0
2017-10-09 16:30:00	SPY	ETF	254.1	254.11	254.04	254.08	97078.0
2017-10-09 17:00:00	SPY	ETF	254.1	254.12	254.06	254.09	936687.0
2017-10-09 17:30:00	SPY	ETF	254.06	254.06	254.05	254.06	7461.0
2017-10-09 18:00:00	SPY	ETF	254.06	254.09	254.03	254.06	39879.0
2017-10-09 18:30:00	SPY	ETF	254.08	254.11	254.07	254.07	21707.0
2017-10-09 19:00:00	SPY	ETF	254.07	254.09	254.06	254.09	14775.0
2017-10-09 19:30:00	SPY	ETF	254.08	254.11	254.07	254.1	23542.0
2017-10-09 04:00:00	QQQ	ETF	147.76	147.76	147.7	147.76	11493.0
2017-10-09 04:30:00	QQQ	ETF	147.79	147.8	147.79	147.8	1007.0
2017-10-09 05:00:00	QQQ	ETF	147.74	147.81	147.74	147.81	992.0
2017-10-09 05:30:00	QQQ	ETF	147.82	147.82	147.82	147.82	500.0
2017-10-09 06:30:00	QQQ	ETF	147.87	147.87	147.86	147.86	1998.0
2017-10-09 07:00:00	QQQ	ETF	147.81	147.86	147.81	147.86	7247.0
2017-10-09 07:30:00	QQQ	ETF	147.88	147.91	147.86	147.9	15950.0
2017-10-09 08:00:00	QQQ	ETF	147.66	147.98	147.66	147.95	27286.0
2017-10-09 08:30:00	QQQ	ETF	147.95	147.95	147.88	147.91	62747.0
2017-10-09 09:00:00	QQQ	ETF	147.92	147.95	147.88	147.88	50201.0
2017-10-09 09:30:00	QQQ	ETF	147.86	147.9066	147.6412	147.86	2122186.0
2017-10-09 10:00:00	QQQ	ETF	147.85	148.0093	147.76	147.83	1387817.0
2017-10-09 10:30:00	QQQ	ETF	147.84	147.8536	147.58	147.7	864805.0
2017-10-09 11:00:00	QQQ	ETF	147.7	147.84	147.69	147.78	446866.0
2017-10-09 11:30:00	QQQ	ETF	147.78	147.87	147.735	147.84	374152.0
2017-10-09 12:00:00	QQQ	ETF	147.84	147.86	147.71	147.72	303375.0
2017-10-09 12:30:00	QQQ	ETF	147.72	147.78	147.69	147.73	307773.0
2017-10-09 13:00:00	QQQ	ETF	147.73	147.76	147.68	147.75	213534.0
2017-10-09 13:30:00	QQQ	ETF	147.74	147.79	147.63	147.69	798957.0

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

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