PREVIEW / etf_5min / 2019-08-20

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-08-20.parquet
  size:    1.4 MB
  rows:    60,501

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-08-20 04:00:00	SPY	ETF	292.55	292.59	292.48	292.48	1724.0
2019-08-20 04:10:00	SPY	ETF	292.5	292.5	292.5	292.5	100.0
2019-08-20 04:15:00	SPY	ETF	292.5	292.5	292.5	292.5	500.0
2019-08-20 04:20:00	SPY	ETF	292.6	292.63	292.6	292.63	800.0
2019-08-20 04:25:00	SPY	ETF	292.6	292.7	292.6	292.7	700.0
2019-08-20 04:35:00	SPY	ETF	292.68	292.73	292.68	292.73	1054.0
2019-08-20 04:40:00	SPY	ETF	292.71	292.71	292.7	292.7	700.0
2019-08-20 04:55:00	SPY	ETF	292.58	292.58	292.58	292.58	100.0
2019-08-20 05:00:00	SPY	ETF	292.53	292.53	292.53	292.53	300.0
2019-08-20 05:10:00	SPY	ETF	292.48	292.48	292.43	292.43	860.0
2019-08-20 05:15:00	SPY	ETF	292.4	292.4	292.31	292.31	1604.0
2019-08-20 05:20:00	SPY	ETF	292.25	292.25	292.25	292.25	1030.0
2019-08-20 05:25:00	SPY	ETF	292.35	292.35	292.35	292.35	988.0
2019-08-20 05:30:00	SPY	ETF	292.36	292.4	292.36	292.4	4000.0
2019-08-20 05:35:00	SPY	ETF	292.43	292.46	292.43	292.46	3000.0
2019-08-20 05:40:00	SPY	ETF	292.53	292.53	292.53	292.53	2500.0
2019-08-20 05:45:00	SPY	ETF	292.48	292.48	292.48	292.48	100.0
2019-08-20 05:50:00	SPY	ETF	292.4	292.43	292.4	292.43	625.0
2019-08-20 05:55:00	SPY	ETF	292.48	292.48	292.48	292.48	102.0
2019-08-20 06:05:00	SPY	ETF	292.6	292.6	292.6	292.6	600.0
2019-08-20 06:10:00	SPY	ETF	292.6	292.6	292.6	292.6	500.0
2019-08-20 06:30:00	SPY	ETF	292.48	292.48	292.48	292.48	300.0
2019-08-20 06:35:00	SPY	ETF	292.46	292.46	292.46	292.46	500.0
2019-08-20 06:40:00	SPY	ETF	292.43	292.43	292.43	292.43	415.0
2019-08-20 06:45:00	SPY	ETF	292.25	292.25	292.25	292.25	5262.0
2019-08-20 06:50:00	SPY	ETF	292.33	292.33	292.33	292.33	150.0
2019-08-20 06:55:00	SPY	ETF	292.36	292.36	292.25	292.25	1251.0
2019-08-20 07:00:00	SPY	ETF	292.25	292.32	292.23	292.25	9142.0
2019-08-20 07:05:00	SPY	ETF	292.2	292.2	291.98	291.99	10484.0
2019-08-20 07:10:00	SPY	ETF	292.05	292.05	291.98	291.98	12360.0
2019-08-20 07:15:00	SPY	ETF	292.1	292.1	292.05	292.05	4999.0
2019-08-20 07:20:00	SPY	ETF	291.98	292.03	291.97	292.03	1410.0
2019-08-20 07:25:00	SPY	ETF	292.03	292.06	292.03	292.06	500.0
2019-08-20 07:30:00	SPY	ETF	292.04	292.07	292.0	292.07	25600.0
2019-08-20 07:35:00	SPY	ETF	292.07	292.25	292.07	292.24	32302.0
2019-08-20 07:40:00	SPY	ETF	292.24	292.39	292.24	292.37	44610.0
2019-08-20 07:45:00	SPY	ETF	292.4	292.45	292.35	292.37	49418.0
2019-08-20 07:50:00	SPY	ETF	292.38	292.38	292.38	292.38	100.0
2019-08-20 07:55:00	SPY	ETF	292.39	292.57	292.35	292.54	56511.0
2019-08-20 08:00:00	SPY	ETF	292.3601	293.0	291.99	292.56	49648.0
2019-08-20 08:05:00	SPY	ETF	292.53	292.55	292.41	292.41	28645.0
2019-08-20 08:10:00	SPY	ETF	292.45	292.5	292.42	292.46	7785.0
2019-08-20 08:15:00	SPY	ETF	292.46	292.55	292.46	292.49	7090.0
2019-08-20 08:20:00	SPY	ETF	292.56	292.6	292.4899	292.54	5139.0
2019-08-20 08:25:00	SPY	ETF	292.5	292.63	292.5	292.63	8875.0
2019-08-20 08:30:00	SPY	ETF	292.62	292.78	292.62	292.73	16054.0
2019-08-20 08:35:00	SPY	ETF	292.71	292.71	292.61	292.61	32602.0
2019-08-20 08:40:00	SPY	ETF	292.61	292.61	292.32	292.35	19357.0
2019-08-20 08:45:00	SPY	ETF	292.4	292.4	292.14	292.25	42384.0
2019-08-20 08:50:00	SPY	ETF	292.25	292.31	292.13	292.17	28735.0

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

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