PREVIEW / etf_5min / 2018-08-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-01.parquet
  size:    1.3 MB
  rows:    56,983

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-08-01 04:05:00	SPY	ETF	281.37	281.37	281.37	281.37	300.0
2018-08-01 04:10:00	SPY	ETF	281.4	281.5	281.4	281.46	1000.0
2018-08-01 04:15:00	SPY	ETF	281.29	281.29	281.28	281.28	4900.0
2018-08-01 04:20:00	SPY	ETF	281.23	281.23	281.16	281.16	2093.0
2018-08-01 04:25:00	SPY	ETF	281.23	281.29	281.23	281.29	400.0
2018-08-01 04:30:00	SPY	ETF	281.29	281.29	281.24	281.27	2000.0
2018-08-01 04:35:00	SPY	ETF	281.29	281.29	281.29	281.29	700.0
2018-08-01 04:40:00	SPY	ETF	281.21	281.21	281.21	281.21	1915.0
2018-08-01 04:45:00	SPY	ETF	281.13	281.13	281.13	281.13	300.0
2018-08-01 04:50:00	SPY	ETF	281.21	281.21	281.21	281.21	300.0
2018-08-01 05:05:00	SPY	ETF	281.11	281.11	281.11	281.11	300.0
2018-08-01 05:10:00	SPY	ETF	281.06	281.06	280.98	281.01	1802.0
2018-08-01 05:15:00	SPY	ETF	281.0	281.0	281.0	281.0	1000.0
2018-08-01 05:20:00	SPY	ETF	280.96	280.96	280.96	280.96	302.0
2018-08-01 05:30:00	SPY	ETF	280.91	280.96	280.91	280.96	900.0
2018-08-01 05:35:00	SPY	ETF	280.95	280.95	280.88	280.88	2510.0
2018-08-01 05:40:00	SPY	ETF	280.91	280.97	280.91	280.97	1900.0
2018-08-01 05:50:00	SPY	ETF	281.01	281.01	280.96	280.96	700.0
2018-08-01 05:55:00	SPY	ETF	280.93	280.95	280.93	280.93	5260.0
2018-08-01 06:00:00	SPY	ETF	280.95	280.99	280.95	280.99	1100.0
2018-08-01 06:05:00	SPY	ETF	280.96	280.98	280.96	280.96	1800.0
2018-08-01 06:10:00	SPY	ETF	280.98	281.06	280.98	281.05	5100.0
2018-08-01 06:15:00	SPY	ETF	281.11	281.11	281.06	281.06	4242.0
2018-08-01 06:20:00	SPY	ETF	281.09	281.14	281.09	281.14	400.0
2018-08-01 06:25:00	SPY	ETF	281.08	281.31	281.08	281.31	2102.0
2018-08-01 06:30:00	SPY	ETF	281.25	281.26	281.2	281.2	3406.0
2018-08-01 06:35:00	SPY	ETF	281.13	281.15	281.13	281.15	400.0
2018-08-01 06:45:00	SPY	ETF	281.14	281.15	281.14	281.15	2400.0
2018-08-01 06:50:00	SPY	ETF	281.06	281.06	281.05	281.05	300.0
2018-08-01 06:55:00	SPY	ETF	281.01	281.01	280.95	280.95	3402.0
2018-08-01 07:00:00	SPY	ETF	280.96	281.01	280.96	280.98	3523.0
2018-08-01 07:05:00	SPY	ETF	281.01	281.04	280.98	281.01	8413.0
2018-08-01 07:10:00	SPY	ETF	281.01	281.02	280.98	281.01	4305.0
2018-08-01 07:15:00	SPY	ETF	281.06	281.08	281.06	281.06	7168.0
2018-08-01 07:20:00	SPY	ETF	281.06	281.06	281.02	281.02	3840.0
2018-08-01 07:25:00	SPY	ETF	281.04	281.06	281.03	281.06	18418.0
2018-08-01 07:30:00	SPY	ETF	281.05	281.05	281.05	281.05	1000.0
2018-08-01 07:35:00	SPY	ETF	281.18	281.2	281.18	281.2	1183.0
2018-08-01 07:40:00	SPY	ETF	281.17	281.19	281.17	281.19	925.0
2018-08-01 07:45:00	SPY	ETF	281.21	281.26	281.21	281.26	6473.0
2018-08-01 07:50:00	SPY	ETF	281.26	281.29	281.22	281.22	11276.0
2018-08-01 07:55:00	SPY	ETF	281.25	281.27	281.23	281.27	5910.0
2018-08-01 08:00:00	SPY	ETF	281.31	281.71	280.98	281.33	17705.0
2018-08-01 08:05:00	SPY	ETF	281.25	281.3	281.22	281.3	7431.0
2018-08-01 08:10:00	SPY	ETF	281.32	281.34	281.28	281.32	14780.0
2018-08-01 08:15:00	SPY	ETF	281.28	281.39	281.27	281.39	21829.0
2018-08-01 08:20:00	SPY	ETF	281.37	281.37	281.28	281.28	11580.0
2018-08-01 08:25:00	SPY	ETF	281.31	281.32	281.25	281.28	3383.0
2018-08-01 08:30:00	SPY	ETF	281.29	281.29	281.17	281.25	19513.0
2018-08-01 08:35:00	SPY	ETF	281.29	281.29	281.22	281.27	9737.0

> showing 50 of 56,983 rows — these rows as CSV

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