PREVIEW / etf_5min / 2019-10-18

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-18.parquet
  size:    1.4 MB
  rows:    57,746

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-10-18 04:00:00	SPY	ETF	299.03	299.03	298.98	298.98	400.0
2019-10-18 04:10:00	SPY	ETF	299.05	299.05	298.95	298.95	300.0
2019-10-18 04:15:00	SPY	ETF	298.95	299.12	298.95	299.12	515.0
2019-10-18 04:20:00	SPY	ETF	299.07	299.07	299.07	299.07	100.0
2019-10-18 04:25:00	SPY	ETF	298.95	298.95	298.95	298.95	100.0
2019-10-18 04:30:00	SPY	ETF	298.92	298.92	298.92	298.92	200.0
2019-10-18 04:35:00	SPY	ETF	298.9	299.02	298.9	299.0	1531.0
2019-10-18 04:40:00	SPY	ETF	298.94	299.05	298.94	299.05	1980.0
2019-10-18 04:45:00	SPY	ETF	299.12	299.12	299.12	299.12	300.0
2019-10-18 04:50:00	SPY	ETF	299.1	299.1	299.07	299.07	200.0
2019-10-18 04:55:00	SPY	ETF	299.12	299.12	299.12	299.12	125.0
2019-10-18 05:20:00	SPY	ETF	298.95	298.95	298.95	298.95	400.0
2019-10-18 05:25:00	SPY	ETF	299.12	299.3	299.12	299.2	1300.0
2019-10-18 05:30:00	SPY	ETF	299.15	299.15	299.07	299.07	325.0
2019-10-18 05:35:00	SPY	ETF	299.17	299.2	299.17	299.2	720.0
2019-10-18 05:45:00	SPY	ETF	299.25	299.25	299.19	299.19	500.0
2019-10-18 05:50:00	SPY	ETF	299.2	299.27	299.2	299.27	1240.0
2019-10-18 05:55:00	SPY	ETF	299.33	299.33	299.3	299.3	600.0
2019-10-18 06:00:00	SPY	ETF	299.28	299.29	299.22	299.22	2625.0
2019-10-18 06:05:00	SPY	ETF	299.27	299.27	299.27	299.27	300.0
2019-10-18 06:10:00	SPY	ETF	299.25	299.32	299.19	299.24	6440.0
2019-10-18 06:15:00	SPY	ETF	299.34	299.34	299.34	299.34	1050.0
2019-10-18 06:20:00	SPY	ETF	299.29	299.29	299.29	299.29	100.0
2019-10-18 06:25:00	SPY	ETF	299.27	299.27	299.19	299.19	450.0
2019-10-18 06:30:00	SPY	ETF	299.14	299.14	299.14	299.14	270.0
2019-10-18 06:40:00	SPY	ETF	299.22	299.27	299.22	299.27	500.0
2019-10-18 06:45:00	SPY	ETF	299.27	299.28	299.26	299.26	1300.0
2019-10-18 06:50:00	SPY	ETF	299.28	299.35	299.28	299.31	15820.0
2019-10-18 06:55:00	SPY	ETF	299.3	299.37	299.3	299.37	7300.0
2019-10-18 07:00:00	SPY	ETF	299.35	299.39	299.31	299.37	17355.0
2019-10-18 07:05:00	SPY	ETF	299.4	299.42	299.35	299.36	4490.0
2019-10-18 07:10:00	SPY	ETF	299.39	299.45	299.39	299.45	13100.0
2019-10-18 07:15:00	SPY	ETF	299.42	299.46	299.42	299.46	1450.0
2019-10-18 07:20:00	SPY	ETF	299.4	299.42	299.36	299.42	14300.0
2019-10-18 07:25:00	SPY	ETF	299.44	299.44	299.34	299.34	9093.0
2019-10-18 07:30:00	SPY	ETF	299.44	299.54	299.41	299.54	14440.0
2019-10-18 07:35:00	SPY	ETF	299.54	299.55	299.54	299.54	49007.0
2019-10-18 07:40:00	SPY	ETF	299.54	299.54	299.41	299.5	9080.0
2019-10-18 07:45:00	SPY	ETF	299.5	299.51	299.46	299.46	7150.0
2019-10-18 07:50:00	SPY	ETF	299.5	299.57	299.5	299.57	15640.0
2019-10-18 07:55:00	SPY	ETF	299.5	299.51	299.44	299.51	13155.0
2019-10-18 08:00:00	SPY	ETF	299.3501	299.5499	298.45	299.48	13170.0
2019-10-18 08:05:00	SPY	ETF	299.51	299.54	299.51	299.54	2102.0
2019-10-18 08:10:00	SPY	ETF	299.53	299.56	299.53	299.53	5206.0
2019-10-18 08:15:00	SPY	ETF	299.5	299.51	299.48	299.49	20622.0
2019-10-18 08:20:00	SPY	ETF	299.49	299.5	299.38	299.4701	29115.0
2019-10-18 08:25:00	SPY	ETF	299.48	299.51	299.46	299.46	54228.0
2019-10-18 08:30:00	SPY	ETF	299.47	299.52	299.42	299.52	11164.0
2019-10-18 08:35:00	SPY	ETF	299.52	299.52	299.47	299.52	5733.0
2019-10-18 08:40:00	SPY	ETF	299.45	299.48	299.45	299.48	370.0

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

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