PREVIEW / etf_5min / 2017-06-20

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-06-20.parquet
  size:    1.3 MB
  rows:    54,156

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-06-20 04:05:00	SPY	ETF	244.54	244.54	244.54	244.54	200.0
2017-06-20 04:15:00	SPY	ETF	244.47	244.47	244.47	244.47	200.0
2017-06-20 04:20:00	SPY	ETF	244.45	244.45	244.45	244.45	110.0
2017-06-20 05:00:00	SPY	ETF	244.44	244.47	244.44	244.47	4000.0
2017-06-20 05:05:00	SPY	ETF	244.47	244.47	244.47	244.47	500.0
2017-06-20 05:10:00	SPY	ETF	244.44	244.44	244.44	244.44	2500.0
2017-06-20 05:20:00	SPY	ETF	244.43	244.47	244.43	244.45	500.0
2017-06-20 05:30:00	SPY	ETF	244.43	244.43	244.43	244.43	400.0
2017-06-20 05:40:00	SPY	ETF	244.4	244.4	244.4	244.4	500.0
2017-06-20 05:45:00	SPY	ETF	244.42	244.42	244.42	244.42	5000.0
2017-06-20 05:50:00	SPY	ETF	244.4	244.4	244.4	244.4	400.0
2017-06-20 05:55:00	SPY	ETF	244.4	244.4	244.4	244.4	300.0
2017-06-20 06:00:00	SPY	ETF	244.4	244.4	244.4	244.4	300.0
2017-06-20 06:10:00	SPY	ETF	244.36	244.36	244.36	244.36	100.0
2017-06-20 06:15:00	SPY	ETF	244.37	244.42	244.37	244.42	1000.0
2017-06-20 06:20:00	SPY	ETF	244.42	244.44	244.39	244.44	3997.0
2017-06-20 06:25:00	SPY	ETF	244.44	244.44	244.38	244.38	3300.0
2017-06-20 06:30:00	SPY	ETF	244.45	244.46	244.45	244.46	43400.0
2017-06-20 06:35:00	SPY	ETF	244.47	244.47	244.46	244.46	300.0
2017-06-20 06:40:00	SPY	ETF	244.45	244.45	244.45	244.45	300.0
2017-06-20 06:45:00	SPY	ETF	244.45	244.45	244.45	244.45	2900.0
2017-06-20 06:50:00	SPY	ETF	244.45	244.45	244.38	244.38	5800.0
2017-06-20 06:55:00	SPY	ETF	244.4	244.41	244.4	244.41	400.0
2017-06-20 07:00:00	SPY	ETF	244.42	244.42	244.42	244.42	8120.0
2017-06-20 07:05:00	SPY	ETF	244.42	244.42	244.4	244.4	51804.0
2017-06-20 07:10:00	SPY	ETF	244.42	244.42	244.4	244.4	4138.0
2017-06-20 07:15:00	SPY	ETF	244.4	244.41	244.38	244.38	10909.0
2017-06-20 07:20:00	SPY	ETF	244.38	244.4	244.36	244.36	68678.0
2017-06-20 07:25:00	SPY	ETF	244.37	244.37	244.34	244.35	4073.0
2017-06-20 07:30:00	SPY	ETF	244.38	244.42	244.38	244.42	2478.0
2017-06-20 07:35:00	SPY	ETF	244.41	244.42	244.41	244.42	769.0
2017-06-20 07:40:00	SPY	ETF	244.42	244.46	244.41	244.46	9011.0
2017-06-20 07:45:00	SPY	ETF	244.46	244.46	244.46	244.46	2349.0
2017-06-20 07:50:00	SPY	ETF	244.46	244.47	244.43	244.47	15358.0
2017-06-20 07:55:00	SPY	ETF	244.45	244.45	244.4	244.4	21857.0
2017-06-20 08:00:00	SPY	ETF	244.42	244.42	244.25	244.25	34266.0
2017-06-20 08:05:00	SPY	ETF	244.26	244.3	244.26	244.3	6170.0
2017-06-20 08:10:00	SPY	ETF	244.29	244.29	244.24	244.25	10868.0
2017-06-20 08:15:00	SPY	ETF	244.23	244.24	244.17	244.2	44439.0
2017-06-20 08:20:00	SPY	ETF	244.2	244.21	244.14	244.15	34436.0
2017-06-20 08:25:00	SPY	ETF	244.17	244.18	244.14	244.18	14127.0
2017-06-20 08:30:00	SPY	ETF	244.19	244.24	244.17	244.24	10569.0
2017-06-20 08:35:00	SPY	ETF	244.23	244.25	244.2	244.2	18631.0
2017-06-20 08:40:00	SPY	ETF	244.2	244.2	244.16	244.18	9889.0
2017-06-20 08:45:00	SPY	ETF	244.15	244.15	244.1	244.12	54441.0
2017-06-20 08:50:00	SPY	ETF	244.12	244.17	244.11	244.15	57950.0
2017-06-20 08:55:00	SPY	ETF	244.14	244.17	244.14	244.15	26951.0
2017-06-20 09:00:00	SPY	ETF	244.16	244.22	244.16	244.21	11390.0
2017-06-20 09:05:00	SPY	ETF	244.21	244.24	244.21	244.24	4133.0
2017-06-20 09:10:00	SPY	ETF	244.23	244.25	244.22	244.23	17343.0

> showing 50 of 54,156 rows — these rows as CSV

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