PREVIEW / etf_5min / 2017-01-05

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-05.parquet
  size:    1.3 MB
  rows:    57,613

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-05 04:00:00	SPY	ETF	226.3	226.3	226.1	226.27	3940.0
2017-01-05 04:05:00	SPY	ETF	226.26	226.26	226.26	226.26	756.0
2017-01-05 04:10:00	SPY	ETF	226.31	226.31	226.31	226.31	4600.0
2017-01-05 04:15:00	SPY	ETF	226.28	226.35	226.28	226.35	1502.0
2017-01-05 04:20:00	SPY	ETF	226.31	226.32	226.31	226.32	801.0
2017-01-05 04:25:00	SPY	ETF	226.36	226.36	226.36	226.36	300.0
2017-01-05 04:30:00	SPY	ETF	226.38	226.38	226.35	226.36	6303.0
2017-01-05 04:35:00	SPY	ETF	226.38	226.38	226.38	226.38	300.0
2017-01-05 04:40:00	SPY	ETF	226.35	226.35	226.35	226.35	800.0
2017-01-05 04:45:00	SPY	ETF	226.35	226.35	226.35	226.35	1000.0
2017-01-05 04:50:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2017-01-05 04:55:00	SPY	ETF	226.43	226.44	226.43	226.44	1700.0
2017-01-05 05:00:00	SPY	ETF	226.42	226.42	226.42	226.42	1900.0
2017-01-05 05:05:00	SPY	ETF	226.46	226.46	226.44	226.45	1600.0
2017-01-05 05:10:00	SPY	ETF	226.42	226.42	226.42	226.42	3000.0
2017-01-05 05:15:00	SPY	ETF	226.42	226.42	226.42	226.42	2800.0
2017-01-05 05:25:00	SPY	ETF	226.23	226.25	226.23	226.25	503.0
2017-01-05 05:30:00	SPY	ETF	226.23	226.23	226.2	226.2	2100.0
2017-01-05 05:35:00	SPY	ETF	226.19	226.21	226.19	226.21	1200.0
2017-01-05 05:40:00	SPY	ETF	226.21	226.21	226.15	226.16	3804.0
2017-01-05 05:50:00	SPY	ETF	226.28	226.37	226.28	226.37	505.0
2017-01-05 05:55:00	SPY	ETF	226.4	226.42	226.4	226.42	1107.0
2017-01-05 06:05:00	SPY	ETF	226.4	226.4	226.4	226.4	841.0
2017-01-05 06:10:00	SPY	ETF	226.38	226.38	226.35	226.36	5003.0
2017-01-05 06:15:00	SPY	ETF	226.38	226.38	226.38	226.38	6000.0
2017-01-05 06:20:00	SPY	ETF	226.35	226.36	226.3	226.3	703.0
2017-01-05 06:35:00	SPY	ETF	226.31	226.35	226.29	226.29	12414.0
2017-01-05 06:40:00	SPY	ETF	226.31	226.31	226.31	226.31	7500.0
2017-01-05 06:45:00	SPY	ETF	226.31	226.39	226.31	226.35	1907.0
2017-01-05 07:00:00	SPY	ETF	226.36	226.36	226.32	226.32	13607.0
2017-01-05 07:05:00	SPY	ETF	226.37	226.37	226.25	226.32	4616.0
2017-01-05 07:10:00	SPY	ETF	226.28	226.29	226.27	226.27	11347.0
2017-01-05 07:15:00	SPY	ETF	226.25	226.25	226.17	226.21	16102.0
2017-01-05 07:20:00	SPY	ETF	226.2	226.2	226.08	226.12	13959.0
2017-01-05 07:25:00	SPY	ETF	226.08	226.1	226.02	226.05	19906.0
2017-01-05 07:30:00	SPY	ETF	226.04	226.08	226.01	226.07	15678.0
2017-01-05 07:35:00	SPY	ETF	226.07	226.07	225.98	226.04	10384.0
2017-01-05 07:40:00	SPY	ETF	226.02	226.03	226.02	226.03	2300.0
2017-01-05 07:45:00	SPY	ETF	226.02	226.05	226.0	226.05	8451.0
2017-01-05 07:50:00	SPY	ETF	226.03	226.03	225.98	226.01	5728.0
2017-01-05 07:55:00	SPY	ETF	225.98	226.05	225.98	226.02	4460.0
2017-01-05 08:00:00	SPY	ETF	226.03	226.37	226.01	226.07	74598.0
2017-01-05 08:05:00	SPY	ETF	226.07	226.3483	226.07	226.12	2272381.0
2017-01-05 08:10:00	SPY	ETF	226.12	226.17	226.09	226.14	34612.0
2017-01-05 08:15:00	SPY	ETF	226.1	226.16	226.08	226.13	17094.0
2017-01-05 08:20:00	SPY	ETF	226.09	226.2	226.09	226.14	47279.0
2017-01-05 08:25:00	SPY	ETF	226.17	226.17	226.13	226.15	39243.0
2017-01-05 08:30:00	SPY	ETF	226.16	226.2	226.14	226.16	16825.0
2017-01-05 08:35:00	SPY	ETF	226.16	226.22	226.15	226.17	14703.0
2017-01-05 08:40:00	SPY	ETF	226.2	226.35	226.19	226.3	43928.0

> showing 50 of 57,613 rows — these rows as CSV

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