PREVIEW / etf_5min / 2019-07-02

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-07-02.parquet
  size:    1.4 MB
  rows:    62,951

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
2019-07-02 04:10:00	SPY	ETF	295.2	295.2	295.05	295.05	300.0
2019-07-02 04:25:00	SPY	ETF	295.05	295.14	295.05	295.14	1200.0
2019-07-02 04:35:00	SPY	ETF	295.16	295.16	295.16	295.16	1100.0
2019-07-02 04:40:00	SPY	ETF	295.0	295.0	295.0	295.0	1500.0
2019-07-02 04:45:00	SPY	ETF	295.0	295.0	294.95	294.95	806.0
2019-07-02 04:50:00	SPY	ETF	295.12	295.14	295.12	295.14	800.0
2019-07-02 05:00:00	SPY	ETF	295.19	295.19	295.19	295.19	300.0
2019-07-02 05:15:00	SPY	ETF	295.18	295.18	295.18	295.18	100.0
2019-07-02 05:20:00	SPY	ETF	295.14	295.14	295.14	295.14	400.0
2019-07-02 05:25:00	SPY	ETF	295.2	295.26	295.2	295.23	1200.0
2019-07-02 05:30:00	SPY	ETF	295.26	295.31	295.26	295.31	1000.0
2019-07-02 05:35:00	SPY	ETF	295.29	295.29	295.27	295.27	300.0
2019-07-02 05:40:00	SPY	ETF	295.29	295.29	295.19	295.23	2474.0
2019-07-02 05:45:00	SPY	ETF	295.18	295.29	295.06	295.28	9600.0
2019-07-02 05:50:00	SPY	ETF	295.23	295.23	295.13	295.13	4500.0
2019-07-02 05:55:00	SPY	ETF	295.15	295.19	295.15	295.16	1600.0
2019-07-02 06:00:00	SPY	ETF	295.16	295.16	295.16	295.16	400.0
2019-07-02 06:10:00	SPY	ETF	295.31	295.31	295.31	295.31	100.0
2019-07-02 06:15:00	SPY	ETF	295.29	295.34	295.29	295.34	200.0
2019-07-02 06:20:00	SPY	ETF	295.39	295.39	295.39	295.39	215.0
2019-07-02 06:25:00	SPY	ETF	295.43	295.43	295.43	295.43	200.0
2019-07-02 06:30:00	SPY	ETF	295.42	295.42	295.38	295.38	2250.0
2019-07-02 06:35:00	SPY	ETF	295.42	295.43	295.41	295.41	3420.0
2019-07-02 06:40:00	SPY	ETF	295.41	295.41	295.4	295.41	2000.0
2019-07-02 06:45:00	SPY	ETF	295.42	295.42	295.38	295.4	2775.0
2019-07-02 06:50:00	SPY	ETF	295.4	295.4	295.4	295.4	100.0
2019-07-02 07:00:00	SPY	ETF	295.34	295.5	295.34	295.45	3891.0
2019-07-02 07:05:00	SPY	ETF	295.43	295.43	295.36	295.37	3650.0
2019-07-02 07:10:00	SPY	ETF	295.37	295.4	295.35	295.35	5000.0
2019-07-02 07:15:00	SPY	ETF	295.35	295.35	295.26	295.26	9023.0
2019-07-02 07:20:00	SPY	ETF	295.27	295.27	295.23	295.23	3369.0
2019-07-02 07:25:00	SPY	ETF	295.21	295.22	295.2	295.2	5612.0
2019-07-02 07:30:00	SPY	ETF	295.21	295.25	295.17	295.17	3671.0
2019-07-02 07:35:00	SPY	ETF	295.2	295.25	295.2	295.21	1165.0
2019-07-02 07:40:00	SPY	ETF	295.24	295.27	295.23	295.27	6567.0
2019-07-02 07:45:00	SPY	ETF	295.27	295.29	295.26	295.29	5196.0
2019-07-02 07:50:00	SPY	ETF	295.29	295.36	295.29	295.35	18776.0
2019-07-02 07:55:00	SPY	ETF	295.37	295.39	295.37	295.37	9185.0
2019-07-02 08:00:00	SPY	ETF	295.41	295.96	295.24	295.34	5876.0
2019-07-02 08:05:00	SPY	ETF	295.34	295.4	295.34	295.4	13950.0
2019-07-02 08:10:00	SPY	ETF	295.37	295.69	295.37	295.38	341526.0
2019-07-02 08:15:00	SPY	ETF	295.38	295.39	295.35	295.38	15341.0
2019-07-02 08:20:00	SPY	ETF	295.38	295.43	295.38	295.43	30600.0
2019-07-02 08:25:00	SPY	ETF	295.35	295.39	295.35	295.38	2520.0
2019-07-02 08:35:00	SPY	ETF	295.45	295.55	295.45	295.55	14733.0
2019-07-02 08:40:00	SPY	ETF	295.49	295.51	295.45	295.5	9503.0
2019-07-02 08:45:00	SPY	ETF	295.47	295.47	295.38	295.41	5480.0
2019-07-02 08:50:00	SPY	ETF	295.38	295.66	295.26	295.42	16549.0
2019-07-02 08:55:00	SPY	ETF	295.42	295.5	295.4	295.4	17927.0
2019-07-02 09:00:00	SPY	ETF	295.34	295.52	295.34	295.51	7311.0

> showing 50 of 62,951 rows — these rows as CSV

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