PREVIEW / etf_5min / 2018-07-02

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-07-02.parquet
  size:    1.4 MB
  rows:    60,259

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-02 04:00:00	SPY	ETF	269.8	269.8	269.5	269.58	9725.0
2018-07-02 04:05:00	SPY	ETF	269.61	269.63	269.6	269.6	1465.0
2018-07-02 04:10:00	SPY	ETF	269.68	269.78	269.68	269.75	1700.0
2018-07-02 04:15:00	SPY	ETF	269.8	269.84	269.8	269.81	1125.0
2018-07-02 04:20:00	SPY	ETF	269.68	269.68	269.68	269.68	100.0
2018-07-02 04:25:00	SPY	ETF	269.7	269.75	269.7	269.72	6400.0
2018-07-02 04:30:00	SPY	ETF	269.8	269.8	269.63	269.68	6350.0
2018-07-02 04:35:00	SPY	ETF	269.68	269.68	269.66	269.66	5700.0
2018-07-02 04:40:00	SPY	ETF	269.75	270.04	269.75	269.98	10205.0
2018-07-02 04:45:00	SPY	ETF	269.98	270.05	269.98	270.05	5500.0
2018-07-02 04:50:00	SPY	ETF	270.0	270.03	269.96	270.03	1210.0
2018-07-02 04:55:00	SPY	ETF	270.13	270.13	270.08	270.11	3870.0
2018-07-02 05:00:00	SPY	ETF	270.06	270.07	270.05	270.05	2500.0
2018-07-02 05:05:00	SPY	ETF	270.03	270.08	270.03	270.08	700.0
2018-07-02 05:10:00	SPY	ETF	270.0	270.04	270.0	270.04	1000.0
2018-07-02 05:15:00	SPY	ETF	270.05	270.07	269.98	270.02	3425.0
2018-07-02 05:20:00	SPY	ETF	269.98	270.01	269.95	269.95	1415.0
2018-07-02 05:25:00	SPY	ETF	269.95	269.95	269.87	269.87	1870.0
2018-07-02 05:30:00	SPY	ETF	269.88	269.88	269.73	269.73	2095.0
2018-07-02 05:35:00	SPY	ETF	269.7	269.75	269.7	269.75	2200.0
2018-07-02 05:40:00	SPY	ETF	269.73	269.88	269.73	269.85	12000.0
2018-07-02 05:45:00	SPY	ETF	269.95	269.95	269.95	269.95	1000.0
2018-07-02 05:50:00	SPY	ETF	269.87	269.99	269.87	269.99	3533.0
2018-07-02 05:55:00	SPY	ETF	269.87	269.9	269.87	269.9	3946.0
2018-07-02 06:00:00	SPY	ETF	269.9	269.9	269.85	269.88	2120.0
2018-07-02 06:05:00	SPY	ETF	269.9	269.93	269.85	269.85	2935.0
2018-07-02 06:10:00	SPY	ETF	269.92	269.92	269.92	269.92	100.0
2018-07-02 06:15:00	SPY	ETF	269.9	269.9	269.75	269.75	3875.0
2018-07-02 06:20:00	SPY	ETF	269.7	269.7	269.42	269.46	35620.0
2018-07-02 06:25:00	SPY	ETF	269.51	269.56	269.48	269.56	2150.0
2018-07-02 06:30:00	SPY	ETF	269.54	269.63	269.53	269.6	5080.0
2018-07-02 06:35:00	SPY	ETF	269.64	269.64	269.58	269.61	2800.0
2018-07-02 06:40:00	SPY	ETF	269.53	269.72	269.53	269.72	13959.0
2018-07-02 06:45:00	SPY	ETF	269.76	269.81	269.73	269.8	4400.0
2018-07-02 06:50:00	SPY	ETF	269.88	270.03	269.88	269.99	37950.0
2018-07-02 06:55:00	SPY	ETF	269.97	269.99	269.9	269.97	23625.0
2018-07-02 07:00:00	SPY	ETF	269.97	269.97	269.85	269.85	14233.0
2018-07-02 07:05:00	SPY	ETF	269.88	269.88	269.81	269.82	17975.0
2018-07-02 07:10:00	SPY	ETF	269.87	269.96	269.87	269.95	4791.0
2018-07-02 07:15:00	SPY	ETF	269.95	269.99	269.88	269.95	19260.0
2018-07-02 07:20:00	SPY	ETF	269.94	270.06	269.92	270.03	13664.0
2018-07-02 07:25:00	SPY	ETF	270.01	270.06	269.94	269.94	27020.0
2018-07-02 07:30:00	SPY	ETF	269.93	269.93	269.8	269.89	12739.0
2018-07-02 07:35:00	SPY	ETF	269.89	269.94	269.86	269.94	2254.0
2018-07-02 07:40:00	SPY	ETF	269.97	269.97	269.92	269.96	3455.0
2018-07-02 07:45:00	SPY	ETF	269.96	270.09	269.96	270.09	21237.0
2018-07-02 07:50:00	SPY	ETF	270.01	270.05	269.99	270.03	18199.0
2018-07-02 07:55:00	SPY	ETF	270.06	270.1	270.01	270.08	12594.0
2018-07-02 08:00:00	SPY	ETF	270.0	271.28	269.21	271.28	42270.0
2018-07-02 08:05:00	SPY	ETF	269.97	269.99	269.86	269.88	22504.0

> showing 50 of 60,259 rows — these rows as CSV

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