PREVIEW / etf_5min / 2018-06-05

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-05.parquet
  size:    1.3 MB
  rows:    57,584

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
2018-06-05 04:00:00	SPY	ETF	275.0	275.11	274.96	274.96	4305.0
2018-06-05 04:05:00	SPY	ETF	274.98	275.01	274.98	274.98	3100.0
2018-06-05 04:10:00	SPY	ETF	275.06	275.06	275.06	275.06	1100.0
2018-06-05 04:15:00	SPY	ETF	275.06	275.11	275.06	275.11	1580.0
2018-06-05 04:20:00	SPY	ETF	275.11	275.12	275.11	275.11	2100.0
2018-06-05 04:30:00	SPY	ETF	275.1	275.17	275.1	275.14	3550.0
2018-06-05 04:35:00	SPY	ETF	275.11	275.16	275.11	275.16	4500.0
2018-06-05 04:40:00	SPY	ETF	275.14	275.14	275.05	275.05	1550.0
2018-06-05 04:45:00	SPY	ETF	275.11	275.11	275.06	275.06	1300.0
2018-06-05 04:50:00	SPY	ETF	275.11	275.14	275.06	275.06	1400.0
2018-06-05 04:55:00	SPY	ETF	275.11	275.16	275.11	275.16	700.0
2018-06-05 05:00:00	SPY	ETF	275.14	275.14	275.04	275.04	4400.0
2018-06-05 05:10:00	SPY	ETF	275.24	275.24	275.24	275.24	100.0
2018-06-05 05:15:00	SPY	ETF	275.27	275.27	275.18	275.18	9500.0
2018-06-05 05:20:00	SPY	ETF	275.21	275.21	275.21	275.21	4400.0
2018-06-05 05:25:00	SPY	ETF	275.26	275.32	275.26	275.31	2509.0
2018-06-05 05:30:00	SPY	ETF	275.27	275.27	275.16	275.21	7900.0
2018-06-05 05:35:00	SPY	ETF	275.31	275.38	275.28	275.38	1602.0
2018-06-05 05:40:00	SPY	ETF	275.33	275.35	275.28	275.28	8100.0
2018-06-05 05:45:00	SPY	ETF	275.24	275.27	275.24	275.27	300.0
2018-06-05 05:50:00	SPY	ETF	275.36	275.39	275.36	275.39	1405.0
2018-06-05 05:55:00	SPY	ETF	275.36	275.44	275.36	275.42	2800.0
2018-06-05 06:00:00	SPY	ETF	275.44	275.44	275.41	275.42	2100.0
2018-06-05 06:05:00	SPY	ETF	275.29	275.29	275.24	275.24	1200.0
2018-06-05 06:10:00	SPY	ETF	275.27	275.27	275.2	275.2	3650.0
2018-06-05 06:15:00	SPY	ETF	275.19	275.2	275.17	275.17	1102.0
2018-06-05 06:20:00	SPY	ETF	275.25	275.27	275.25	275.27	800.0
2018-06-05 06:25:00	SPY	ETF	275.2	275.22	275.15	275.15	17000.0
2018-06-05 06:30:00	SPY	ETF	275.15	275.15	275.07	275.09	24930.0
2018-06-05 06:35:00	SPY	ETF	275.1	275.18	275.1	275.18	2550.0
2018-06-05 06:40:00	SPY	ETF	275.15	275.18	275.1	275.12	12300.0
2018-06-05 06:45:00	SPY	ETF	275.11	275.11	275.11	275.11	100.0
2018-06-05 06:50:00	SPY	ETF	275.17	275.27	275.16	275.26	25120.0
2018-06-05 06:55:00	SPY	ETF	275.19	275.19	275.13	275.13	3700.0
2018-06-05 07:00:00	SPY	ETF	275.13	275.31	275.13	275.31	3851.0
2018-06-05 07:05:00	SPY	ETF	275.26	275.26	275.21	275.21	8178.0
2018-06-05 07:10:00	SPY	ETF	275.2	275.28	275.2	275.26	1445.0
2018-06-05 07:15:00	SPY	ETF	275.26	275.29	275.25	275.29	18910.0
2018-06-05 07:20:00	SPY	ETF	275.27	275.27	275.25	275.25	606.0
2018-06-05 07:25:00	SPY	ETF	275.24	275.24	275.24	275.24	3910.0
2018-06-05 07:30:00	SPY	ETF	275.22	275.22	275.15	275.17	21317.0
2018-06-05 07:35:00	SPY	ETF	275.19	275.27	275.19	275.27	2031.0
2018-06-05 07:40:00	SPY	ETF	275.19	275.26	275.19	275.26	1428.0
2018-06-05 07:50:00	SPY	ETF	275.2	275.2	275.11	275.16	7031.0
2018-06-05 07:55:00	SPY	ETF	275.16	275.16	275.14	275.14	1100.0
2018-06-05 08:00:00	SPY	ETF	275.19	275.28	274.69	275.09	65881.0
2018-06-05 08:05:00	SPY	ETF	275.12	275.25	275.0	275.0	31455.0
2018-06-05 08:10:00	SPY	ETF	275.01	275.04	274.9	275.04	34570.0
2018-06-05 08:15:00	SPY	ETF	275.01	275.01	274.88	274.88	30016.0
2018-06-05 08:20:00	SPY	ETF	274.88	274.92	274.85	274.89	31358.0

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

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