PREVIEW / etf_5min / 2017-09-25

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-25.parquet
  size:    1.3 MB
  rows:    54,337

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-09-25 04:00:00	SPY	ETF	249.36	249.36	249.2	249.2	3375.0
2017-09-25 04:05:00	SPY	ETF	249.18	249.18	249.15	249.15	5800.0
2017-09-25 04:10:00	SPY	ETF	249.18	249.18	249.18	249.18	2000.0
2017-09-25 04:25:00	SPY	ETF	249.11	249.11	249.11	249.11	100.0
2017-09-25 04:35:00	SPY	ETF	249.15	249.18	249.07	249.18	5900.0
2017-09-25 04:40:00	SPY	ETF	249.21	249.29	249.21	249.29	602.0
2017-09-25 04:45:00	SPY	ETF	249.26	249.26	249.26	249.26	302.0
2017-09-25 04:55:00	SPY	ETF	249.34	249.34	249.34	249.34	630.0
2017-09-25 05:00:00	SPY	ETF	249.34	249.34	249.28	249.28	1503.0
2017-09-25 05:05:00	SPY	ETF	249.29	249.29	249.29	249.29	1100.0
2017-09-25 05:15:00	SPY	ETF	249.31	249.31	249.26	249.26	1003.0
2017-09-25 05:30:00	SPY	ETF	249.19	249.19	249.19	249.19	300.0
2017-09-25 05:35:00	SPY	ETF	249.16	249.17	249.11	249.12	3006.0
2017-09-25 05:40:00	SPY	ETF	249.12	249.12	249.12	249.12	100.0
2017-09-25 05:45:00	SPY	ETF	249.12	249.12	249.11	249.11	400.0
2017-09-25 05:50:00	SPY	ETF	249.16	249.16	249.16	249.16	2600.0
2017-09-25 05:55:00	SPY	ETF	249.18	249.25	249.18	249.25	3203.0
2017-09-25 06:05:00	SPY	ETF	249.28	249.28	249.28	249.28	300.0
2017-09-25 06:10:00	SPY	ETF	249.31	249.31	249.31	249.31	300.0
2017-09-25 06:15:00	SPY	ETF	249.31	249.31	249.31	249.31	1000.0
2017-09-25 06:20:00	SPY	ETF	249.33	249.33	249.33	249.33	401.0
2017-09-25 06:35:00	SPY	ETF	249.33	249.33	249.33	249.33	2400.0
2017-09-25 06:40:00	SPY	ETF	249.33	249.33	249.33	249.33	200.0
2017-09-25 06:45:00	SPY	ETF	249.33	249.33	249.33	249.33	5800.0
2017-09-25 06:50:00	SPY	ETF	249.34	249.37	249.34	249.37	8722.0
2017-09-25 07:00:00	SPY	ETF	249.39	249.42	249.39	249.42	1730.0
2017-09-25 07:05:00	SPY	ETF	249.41	249.42	249.41	249.42	4420.0
2017-09-25 07:10:00	SPY	ETF	249.41	249.41	249.41	249.41	300.0
2017-09-25 07:15:00	SPY	ETF	249.41	249.41	249.41	249.41	2000.0
2017-09-25 07:20:00	SPY	ETF	249.4	249.4	249.39	249.39	343.0
2017-09-25 07:25:00	SPY	ETF	249.36	249.39	249.34	249.39	1314.0
2017-09-25 07:30:00	SPY	ETF	249.38	249.41	249.38	249.41	10129.0
2017-09-25 07:35:00	SPY	ETF	249.44	249.45	249.41	249.42	9381.0
2017-09-25 07:40:00	SPY	ETF	249.36	249.39	249.36	249.39	2930.0
2017-09-25 07:45:00	SPY	ETF	249.39	249.39	249.39	249.39	100.0
2017-09-25 07:50:00	SPY	ETF	249.41	249.41	249.4	249.4	3424.0
2017-09-25 07:55:00	SPY	ETF	249.4	249.4	249.4	249.4	4782.0
2017-09-25 08:00:00	SPY	ETF	249.45	249.45	249.34	249.35	24334.0
2017-09-25 08:05:00	SPY	ETF	249.39	249.39	249.39	249.39	10000.0
2017-09-25 08:10:00	SPY	ETF	249.38	249.4	249.38	249.4	3900.0
2017-09-25 08:15:00	SPY	ETF	249.39	249.41	249.38	249.4	5400.0
2017-09-25 08:20:00	SPY	ETF	249.4	249.4	249.38	249.38	1076.0
2017-09-25 08:25:00	SPY	ETF	249.37	249.37	249.37	249.37	700.0
2017-09-25 08:30:00	SPY	ETF	249.37	249.38	249.24	249.24	48009.0
2017-09-25 08:35:00	SPY	ETF	249.25	249.28	249.24	249.26	6327.0
2017-09-25 08:40:00	SPY	ETF	249.26	249.28	249.15	249.16	14936.0
2017-09-25 08:45:00	SPY	ETF	249.15	249.2	249.14	249.19	17244.0
2017-09-25 08:50:00	SPY	ETF	249.21	249.21	249.17	249.18	7837.0
2017-09-25 08:55:00	SPY	ETF	249.18	249.2	249.16	249.17	13241.0
2017-09-25 09:00:00	SPY	ETF	249.17	249.18	249.07	249.07	39213.0

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

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