PREVIEW / etf_5min / 2016-08-18

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-08-18.parquet
  size:    1.1 MB
  rows:    47,238

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-08-18 04:00:00	SPY	ETF	218.45	218.45	218.38	218.44	705.0
2016-08-18 04:10:00	SPY	ETF	218.47	218.47	218.47	218.47	102.0
2016-08-18 04:20:00	SPY	ETF	218.5	218.5	218.5	218.5	236.0
2016-08-18 05:00:00	SPY	ETF	218.46	218.46	218.46	218.46	600.0
2016-08-18 05:30:00	SPY	ETF	218.41	218.41	218.41	218.41	100.0
2016-08-18 05:35:00	SPY	ETF	218.43	218.43	218.43	218.43	100.0
2016-08-18 05:50:00	SPY	ETF	218.36	218.36	218.36	218.36	300.0
2016-08-18 05:55:00	SPY	ETF	218.35	218.4	218.35	218.38	2201.0
2016-08-18 06:20:00	SPY	ETF	218.41	218.41	218.39	218.39	224.0
2016-08-18 06:40:00	SPY	ETF	218.43	218.43	218.43	218.43	3250.0
2016-08-18 06:45:00	SPY	ETF	218.36	218.36	218.36	218.36	10000.0
2016-08-18 06:50:00	SPY	ETF	218.36	218.36	218.36	218.36	2400.0
2016-08-18 06:55:00	SPY	ETF	218.4	218.4	218.4	218.4	101.0
2016-08-18 07:00:00	SPY	ETF	218.34	218.38	218.34	218.36	23226.0
2016-08-18 07:05:00	SPY	ETF	218.38	218.39	218.33	218.39	4728.0
2016-08-18 07:10:00	SPY	ETF	218.39	218.39	218.34	218.34	4801.0
2016-08-18 07:15:00	SPY	ETF	218.38	218.38	218.23	218.23	25275.0
2016-08-18 07:20:00	SPY	ETF	218.22	218.28	218.22	218.28	7022.0
2016-08-18 07:25:00	SPY	ETF	218.3	218.3	218.29	218.29	620.0
2016-08-18 07:30:00	SPY	ETF	218.29	218.29	218.28	218.28	510.0
2016-08-18 07:35:00	SPY	ETF	218.24	218.24	218.2	218.23	21672.0
2016-08-18 07:40:00	SPY	ETF	218.22	218.24	218.21	218.24	873.0
2016-08-18 07:45:00	SPY	ETF	218.24	218.24	218.24	218.24	100.0
2016-08-18 07:50:00	SPY	ETF	218.22	218.23	218.17	218.17	17702.0
2016-08-18 07:55:00	SPY	ETF	218.18	218.18	218.1	218.13	17239.0
2016-08-18 08:00:00	SPY	ETF	218.15	218.679	218.1	218.679	71825.0
2016-08-18 08:05:00	SPY	ETF	218.1	218.14	218.1	218.14	8437.0
2016-08-18 08:10:00	SPY	ETF	218.14	218.14	218.1	218.12	46472.0
2016-08-18 08:15:00	SPY	ETF	218.12	218.14	218.11	218.12	9127.0
2016-08-18 08:20:00	SPY	ETF	218.13	218.16	218.1	218.15	41577.0
2016-08-18 08:25:00	SPY	ETF	218.14	218.2	218.14	218.2	18905.0
2016-08-18 08:30:00	SPY	ETF	218.2	218.26	218.2	218.23	16735.0
2016-08-18 08:35:00	SPY	ETF	218.22	218.24	218.22	218.24	9501.0
2016-08-18 08:40:00	SPY	ETF	218.2	218.22	218.2	218.21	12151.0
2016-08-18 08:45:00	SPY	ETF	218.22	218.22	218.22	218.22	11580.0
2016-08-18 08:50:00	SPY	ETF	218.23	218.26	218.21	218.22	13482.0
2016-08-18 08:55:00	SPY	ETF	218.24	218.25	218.22	218.23	11500.0
2016-08-18 09:00:00	SPY	ETF	218.2	218.2	218.2	218.2	2001.0
2016-08-18 09:05:00	SPY	ETF	218.21	218.24	218.2	218.23	10975.0
2016-08-18 09:10:00	SPY	ETF	218.23	218.24	218.22	218.24	9500.0
2016-08-18 09:15:00	SPY	ETF	218.24	218.28	218.24	218.27	14234.0
2016-08-18 09:20:00	SPY	ETF	218.27	218.31	218.25	218.31	26737.0
2016-08-18 09:25:00	SPY	ETF	218.3	218.36	218.3	218.33	58238.0
2016-08-18 09:30:00	SPY	ETF	218.34	218.6	218.31	218.5399	1518099.0
2016-08-18 09:35:00	SPY	ETF	218.52	218.57	218.41	218.42	1154310.0
2016-08-18 09:40:00	SPY	ETF	218.42	218.43	218.21	218.32	1326754.0
2016-08-18 09:45:00	SPY	ETF	218.33	218.4	218.21	218.3925	1216581.0
2016-08-18 09:50:00	SPY	ETF	218.4	218.4	218.28	218.3699	575967.0
2016-08-18 09:55:00	SPY	ETF	218.365	218.54	218.35	218.46	544375.0
2016-08-18 10:00:00	SPY	ETF	218.46	218.57	218.38	218.55	773378.0

> showing 50 of 47,238 rows — these rows as CSV

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