PREVIEW / etf_5min / 2020-08-17

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-08-17.parquet
  size:    1.6 MB
  rows:    72,472

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
2020-08-17 04:00:00	SPY	ETF	337.44	337.54	337.01	337.01	1116.0
2020-08-17 04:10:00	SPY	ETF	337.26	337.26	337.26	337.26	267.0
2020-08-17 04:15:00	SPY	ETF	337.15	337.15	337.1	337.1	531.0
2020-08-17 04:20:00	SPY	ETF	337.18	337.18	337.18	337.18	100.0
2020-08-17 04:30:00	SPY	ETF	337.05	337.05	337.05	337.05	205.0
2020-08-17 04:35:00	SPY	ETF	337.1	337.1	337.1	337.1	700.0
2020-08-17 04:40:00	SPY	ETF	337.06	337.3	337.0	337.3	3951.0
2020-08-17 04:45:00	SPY	ETF	337.3	337.3	337.3	337.3	851.0
2020-08-17 04:50:00	SPY	ETF	337.3	337.3	337.25	337.26	16750.0
2020-08-17 04:55:00	SPY	ETF	337.32	337.32	337.32	337.32	200.0
2020-08-17 05:00:00	SPY	ETF	337.48	337.48	337.46	337.46	308.0
2020-08-17 05:05:00	SPY	ETF	337.4	337.45	337.4	337.45	431.0
2020-08-17 05:10:00	SPY	ETF	337.5	337.51	337.5	337.51	700.0
2020-08-17 05:15:00	SPY	ETF	337.57	337.63	337.57	337.63	405.0
2020-08-17 05:20:00	SPY	ETF	337.68	337.7	337.6	337.6	800.0
2020-08-17 05:25:00	SPY	ETF	337.56	337.56	337.56	337.56	130.0
2020-08-17 05:30:00	SPY	ETF	337.46	337.47	337.46	337.47	1250.0
2020-08-17 05:35:00	SPY	ETF	337.38	337.38	337.34	337.34	419.0
2020-08-17 05:40:00	SPY	ETF	337.35	337.39	337.35	337.39	307.0
2020-08-17 05:45:00	SPY	ETF	337.39	337.42	337.37	337.42	501.0
2020-08-17 05:50:00	SPY	ETF	337.28	337.28	337.2	337.26	770.0
2020-08-17 05:55:00	SPY	ETF	337.31	337.31	337.31	337.31	675.0
2020-08-17 06:00:00	SPY	ETF	337.31	337.36	337.31	337.36	4810.0
2020-08-17 06:05:00	SPY	ETF	337.28	337.28	337.28	337.28	501.0
2020-08-17 06:10:00	SPY	ETF	337.41	337.41	337.37	337.37	2600.0
2020-08-17 06:15:00	SPY	ETF	337.31	337.31	337.27	337.29	1360.0
2020-08-17 06:20:00	SPY	ETF	337.22	337.22	337.21	337.22	2004.0
2020-08-17 06:25:00	SPY	ETF	337.2	337.26	337.2	337.26	801.0
2020-08-17 06:30:00	SPY	ETF	337.25	337.25	337.25	337.25	1150.0
2020-08-17 06:35:00	SPY	ETF	337.17	337.22	337.17	337.22	1486.0
2020-08-17 06:40:00	SPY	ETF	337.2	337.25	337.2	337.24	2800.0
2020-08-17 06:45:00	SPY	ETF	337.24	337.3	337.22	337.25	1510.0
2020-08-17 06:50:00	SPY	ETF	337.26	337.27	337.18	337.18	1477.0
2020-08-17 06:55:00	SPY	ETF	337.27	337.37	337.27	337.37	2081.0
2020-08-17 07:00:00	SPY	ETF	337.33	337.38	337.23	337.33	25948.0
2020-08-17 07:05:00	SPY	ETF	337.28	337.44	337.28	337.41	1767.0
2020-08-17 07:10:00	SPY	ETF	337.41	337.41	337.24	337.26	5218.0
2020-08-17 07:15:00	SPY	ETF	337.23	337.35	337.23	337.3	2178.0
2020-08-17 07:20:00	SPY	ETF	337.25	337.31	337.25	337.29	2679.0
2020-08-17 07:25:00	SPY	ETF	337.33	337.37	337.33	337.35	584.0
2020-08-17 07:30:00	SPY	ETF	337.32	337.49	337.17	337.26	80183.0
2020-08-17 07:35:00	SPY	ETF	337.3	337.33	337.29	337.33	5279.0
2020-08-17 07:40:00	SPY	ETF	337.32	337.51	337.3	337.48	29656.0
2020-08-17 07:45:00	SPY	ETF	337.45	337.46	337.38	337.42	7717.0
2020-08-17 07:50:00	SPY	ETF	337.44	337.44	337.35	337.35	2436.0
2020-08-17 07:55:00	SPY	ETF	337.35	337.35	337.31	337.31	2243.0
2020-08-17 08:00:00	SPY	ETF	337.34	337.47	336.6436	337.35	159688.0
2020-08-17 08:05:00	SPY	ETF	337.4	337.4	337.35	337.38	4513.0
2020-08-17 08:10:00	SPY	ETF	337.3699	337.37	337.34	337.36	2030.0
2020-08-17 08:15:00	SPY	ETF	337.35	337.51	337.32	337.49	17177.0

> showing 50 of 72,472 rows — these rows as CSV

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