PREVIEW / etf_5min / 2019-09-24

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-24.parquet
  size:    1.5 MB
  rows:    63,295

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-09-24 04:00:00	SPY	ETF	299.2	299.45	299.2	299.34	3778.0
2019-09-24 04:05:00	SPY	ETF	299.23	299.33	299.22	299.29	4620.0
2019-09-24 04:10:00	SPY	ETF	299.34	299.4	299.34	299.4	1610.0
2019-09-24 04:15:00	SPY	ETF	299.4	299.42	299.39	299.39	5570.0
2019-09-24 04:20:00	SPY	ETF	299.35	299.35	299.34	299.34	400.0
2019-09-24 04:25:00	SPY	ETF	299.36	299.36	299.36	299.36	400.0
2019-09-24 04:30:00	SPY	ETF	299.31	299.31	299.23	299.23	800.0
2019-09-24 04:35:00	SPY	ETF	299.32	299.32	299.32	299.32	300.0
2019-09-24 04:40:00	SPY	ETF	299.29	299.29	299.29	299.29	404.0
2019-09-24 04:45:00	SPY	ETF	299.36	299.39	299.36	299.39	880.0
2019-09-24 04:50:00	SPY	ETF	299.39	299.39	299.39	299.39	1200.0
2019-09-24 04:55:00	SPY	ETF	299.39	299.39	299.39	299.39	100.0
2019-09-24 05:00:00	SPY	ETF	299.39	299.39	299.39	299.39	500.0
2019-09-24 05:05:00	SPY	ETF	299.39	299.39	299.39	299.39	300.0
2019-09-24 05:10:00	SPY	ETF	299.39	299.49	299.39	299.49	1311.0
2019-09-24 05:15:00	SPY	ETF	299.49	299.49	299.49	299.49	800.0
2019-09-24 05:20:00	SPY	ETF	299.54	299.54	299.54	299.54	400.0
2019-09-24 05:30:00	SPY	ETF	299.54	299.55	299.53	299.53	1100.0
2019-09-24 05:35:00	SPY	ETF	299.56	299.57	299.53	299.57	1225.0
2019-09-24 05:40:00	SPY	ETF	299.53	299.54	299.53	299.54	700.0
2019-09-24 05:45:00	SPY	ETF	299.54	299.64	299.54	299.58	3000.0
2019-09-24 05:50:00	SPY	ETF	299.56	299.56	299.55	299.55	1000.0
2019-09-24 05:55:00	SPY	ETF	299.56	299.57	299.56	299.57	2200.0
2019-09-24 06:00:00	SPY	ETF	299.45	299.45	299.44	299.44	600.0
2019-09-24 06:05:00	SPY	ETF	299.46	299.46	299.46	299.46	552.0
2019-09-24 06:10:00	SPY	ETF	299.43	299.46	299.39	299.46	500.0
2019-09-24 06:15:00	SPY	ETF	299.44	299.44	299.39	299.39	200.0
2019-09-24 06:25:00	SPY	ETF	299.38	299.38	299.38	299.38	300.0
2019-09-24 06:30:00	SPY	ETF	299.36	299.36	299.36	299.36	500.0
2019-09-24 06:35:00	SPY	ETF	299.39	299.39	299.39	299.39	400.0
2019-09-24 06:40:00	SPY	ETF	299.34	299.49	299.3	299.48	16300.0
2019-09-24 06:45:00	SPY	ETF	299.48	299.51	299.48	299.48	1300.0
2019-09-24 06:50:00	SPY	ETF	299.48	299.48	299.48	299.48	100.0
2019-09-24 06:55:00	SPY	ETF	299.56	299.56	299.53	299.53	500.0
2019-09-24 07:00:00	SPY	ETF	299.55	299.62	299.55	299.57	8954.0
2019-09-24 07:05:00	SPY	ETF	299.61	299.66	299.61	299.66	2205.0
2019-09-24 07:10:00	SPY	ETF	299.65	299.84	299.65	299.77	17818.0
2019-09-24 07:15:00	SPY	ETF	299.78	299.8	299.73	299.8	5934.0
2019-09-24 07:20:00	SPY	ETF	299.77	299.77	299.65	299.66	6571.0
2019-09-24 07:25:00	SPY	ETF	299.65	299.68	299.64	299.68	4292.0
2019-09-24 07:30:00	SPY	ETF	299.65	299.65	299.62	299.65	6790.0
2019-09-24 07:35:00	SPY	ETF	299.65	299.67	299.62	299.67	4180.0
2019-09-24 07:40:00	SPY	ETF	299.69	299.7	299.65	299.67	4044.0
2019-09-24 07:45:00	SPY	ETF	299.62	299.64	299.62	299.64	1315.0
2019-09-24 07:50:00	SPY	ETF	299.64	299.64	299.56	299.56	7990.0
2019-09-24 07:55:00	SPY	ETF	299.57	299.63	299.57	299.63	1663.0
2019-09-24 08:00:00	SPY	ETF	299.63	299.69	299.11	299.51	43345.0
2019-09-24 08:05:00	SPY	ETF	299.53	299.55	299.47	299.48	13075.0
2019-09-24 08:10:00	SPY	ETF	299.48	299.48	299.34	299.38	282309.0
2019-09-24 08:15:00	SPY	ETF	299.42	299.45	299.37	299.43	14844.0

> showing 50 of 63,295 rows — these rows as CSV

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