PREVIEW / etf_5min / 2018-07-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-07-26.parquet
  size:    1.3 MB
  rows:    57,699

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-07-26 04:00:00	SPY	ETF	283.02	283.02	283.02	283.02	290.0
2018-07-26 04:10:00	SPY	ETF	283.07	283.07	283.07	283.07	500.0
2018-07-26 04:15:00	SPY	ETF	283.07	283.07	283.07	283.07	100.0
2018-07-26 04:25:00	SPY	ETF	283.0	283.0	282.94	282.94	3226.0
2018-07-26 04:30:00	SPY	ETF	283.05	283.05	282.94	282.94	6133.0
2018-07-26 04:40:00	SPY	ETF	283.07	283.07	283.07	283.07	250.0
2018-07-26 04:45:00	SPY	ETF	283.03	283.06	282.96	282.98	3800.0
2018-07-26 04:50:00	SPY	ETF	282.93	282.93	282.89	282.92	1800.0
2018-07-26 04:55:00	SPY	ETF	282.94	282.96	282.94	282.96	800.0
2018-07-26 05:00:00	SPY	ETF	282.96	282.98	282.96	282.98	1000.0
2018-07-26 05:05:00	SPY	ETF	282.96	283.03	282.96	283.03	1300.0
2018-07-26 05:10:00	SPY	ETF	283.06	283.06	283.06	283.06	700.0
2018-07-26 05:15:00	SPY	ETF	283.08	283.08	283.05	283.05	1800.0
2018-07-26 05:20:00	SPY	ETF	283.08	283.08	283.0	283.08	2856.0
2018-07-26 05:25:00	SPY	ETF	283.1	283.1	283.04	283.06	2120.0
2018-07-26 05:30:00	SPY	ETF	283.16	283.16	283.1	283.15	1700.0
2018-07-26 05:35:00	SPY	ETF	283.18	283.18	283.15	283.15	1954.0
2018-07-26 05:40:00	SPY	ETF	283.2	283.23	283.13	283.18	6301.0
2018-07-26 05:45:00	SPY	ETF	283.08	283.08	283.05	283.05	777.0
2018-07-26 05:50:00	SPY	ETF	283.1	283.13	283.06	283.1	3500.0
2018-07-26 05:55:00	SPY	ETF	283.18	283.18	283.18	283.18	300.0
2018-07-26 06:00:00	SPY	ETF	283.15	283.15	283.14	283.15	1209.0
2018-07-26 06:05:00	SPY	ETF	283.15	283.18	283.14	283.18	2400.0
2018-07-26 06:10:00	SPY	ETF	283.16	283.16	283.13	283.13	1150.0
2018-07-26 06:15:00	SPY	ETF	283.11	283.11	283.06	283.11	4000.0
2018-07-26 06:20:00	SPY	ETF	283.08	283.09	282.97	283.0	3100.0
2018-07-26 06:25:00	SPY	ETF	283.01	283.01	283.01	283.01	650.0
2018-07-26 06:30:00	SPY	ETF	282.99	283.03	282.93	282.95	64346.0
2018-07-26 06:35:00	SPY	ETF	282.98	283.04	282.97	283.02	4300.0
2018-07-26 06:40:00	SPY	ETF	282.97	283.02	282.97	283.02	7700.0
2018-07-26 06:45:00	SPY	ETF	283.0	283.02	282.99	282.99	24131.0
2018-07-26 06:50:00	SPY	ETF	283.0	283.01	282.95	282.95	10600.0
2018-07-26 06:55:00	SPY	ETF	283.01	283.01	282.99	282.99	1200.0
2018-07-26 07:00:00	SPY	ETF	283.0	283.03	282.98	283.03	11352.0
2018-07-26 07:05:00	SPY	ETF	283.03	283.08	283.01	283.08	9045.0
2018-07-26 07:10:00	SPY	ETF	283.08	283.15	283.06	283.13	33920.0
2018-07-26 07:15:00	SPY	ETF	283.13	283.16	283.13	283.15	28796.0
2018-07-26 07:20:00	SPY	ETF	283.15	283.16	283.15	283.16	10105.0
2018-07-26 07:25:00	SPY	ETF	283.15	283.15	283.11	283.12	28970.0
2018-07-26 07:30:00	SPY	ETF	283.1	283.12	283.1	283.12	15527.0
2018-07-26 07:35:00	SPY	ETF	283.12	283.19	283.12	283.15	1272.0
2018-07-26 07:40:00	SPY	ETF	283.17	283.17	283.13	283.15	5468.0
2018-07-26 07:45:00	SPY	ETF	283.18	283.18	283.12	283.12	88168.0
2018-07-26 07:50:00	SPY	ETF	283.1	283.12	283.07	283.07	22341.0
2018-07-26 07:55:00	SPY	ETF	283.06	283.1	283.06	283.1	43473.0
2018-07-26 08:00:00	SPY	ETF	283.1001	283.17	283.03	283.08	33272.0
2018-07-26 08:05:00	SPY	ETF	283.1	283.19	283.1	283.14	22470.0
2018-07-26 08:10:00	SPY	ETF	283.13	283.31	282.85	283.25	181362.0
2018-07-26 08:15:00	SPY	ETF	283.27	283.34	283.25	283.31	79660.0
2018-07-26 08:20:00	SPY	ETF	283.28	283.28	283.21	283.2654	193177.0

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

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