PREVIEW / etf_5min / 2020-08-24

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-08-24.parquet
  size:    1.6 MB
  rows:    73,748

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-24 04:00:00	SPY	ETF	341.2	341.5	341.2	341.32	15872.0
2020-08-24 04:05:00	SPY	ETF	341.28	341.28	341.23	341.28	1644.0
2020-08-24 04:10:00	SPY	ETF	341.29	341.29	341.21	341.21	562.0
2020-08-24 04:15:00	SPY	ETF	341.21	341.32	341.2	341.32	2238.0
2020-08-24 04:20:00	SPY	ETF	341.33	341.45	341.32	341.45	8228.0
2020-08-24 04:25:00	SPY	ETF	341.41	341.42	341.38	341.38	1320.0
2020-08-24 04:30:00	SPY	ETF	341.37	341.53	341.37	341.48	3189.0
2020-08-24 04:35:00	SPY	ETF	341.46	341.46	341.44	341.45	1701.0
2020-08-24 04:40:00	SPY	ETF	341.39	341.63	341.39	341.62	3340.0
2020-08-24 04:45:00	SPY	ETF	341.66	341.79	341.61	341.77	3529.0
2020-08-24 04:50:00	SPY	ETF	341.78	341.82	341.67	341.82	3687.0
2020-08-24 04:55:00	SPY	ETF	341.7	341.79	341.7	341.72	1818.0
2020-08-24 05:00:00	SPY	ETF	341.7	341.7	341.61	341.69	2043.0
2020-08-24 05:05:00	SPY	ETF	341.73	341.74	341.71	341.71	902.0
2020-08-24 05:10:00	SPY	ETF	341.62	341.62	341.6	341.6	1602.0
2020-08-24 05:15:00	SPY	ETF	341.55	341.55	341.54	341.55	1301.0
2020-08-24 05:20:00	SPY	ETF	341.65	341.65	341.63	341.63	323.0
2020-08-24 05:25:00	SPY	ETF	341.57	341.7	341.57	341.7	603.0
2020-08-24 05:30:00	SPY	ETF	341.67	341.67	341.65	341.65	416.0
2020-08-24 05:35:00	SPY	ETF	341.77	341.77	341.72	341.72	601.0
2020-08-24 05:40:00	SPY	ETF	341.85	341.85	341.8	341.82	1704.0
2020-08-24 05:45:00	SPY	ETF	341.83	341.86	341.83	341.86	1146.0
2020-08-24 05:50:00	SPY	ETF	341.8	341.8	341.8	341.8	701.0
2020-08-24 05:55:00	SPY	ETF	341.74	341.82	341.69	341.82	2010.0
2020-08-24 06:00:00	SPY	ETF	341.75	341.75	341.72	341.74	466.0
2020-08-24 06:05:00	SPY	ETF	341.65	341.74	341.65	341.74	2905.0
2020-08-24 06:10:00	SPY	ETF	341.84	341.84	341.84	341.84	366.0
2020-08-24 06:15:00	SPY	ETF	341.84	341.84	341.83	341.84	1000.0
2020-08-24 06:20:00	SPY	ETF	341.84	341.84	341.8	341.8	1084.0
2020-08-24 06:25:00	SPY	ETF	341.77	341.82	341.77	341.82	902.0
2020-08-24 06:30:00	SPY	ETF	341.83	342.02	341.83	342.0	5728.0
2020-08-24 06:35:00	SPY	ETF	342.04	342.12	342.04	342.1	2368.0
2020-08-24 06:40:00	SPY	ETF	342.04	342.2	342.04	342.11	5950.0
2020-08-24 06:45:00	SPY	ETF	342.05	342.13	342.04	342.05	4661.0
2020-08-24 06:50:00	SPY	ETF	342.08	342.19	342.08	342.18	8551.0
2020-08-24 06:55:00	SPY	ETF	342.19	342.19	342.07	342.12	9632.0
2020-08-24 07:00:00	SPY	ETF	342.16	342.19	342.04	342.1	18430.0
2020-08-24 07:05:00	SPY	ETF	342.1	342.12	342.06	342.09	38798.0
2020-08-24 07:10:00	SPY	ETF	342.09	342.25	342.09	342.18	44782.0
2020-08-24 07:15:00	SPY	ETF	342.18	342.29	342.18	342.28	18493.0
2020-08-24 07:20:00	SPY	ETF	342.25	342.27	342.2	342.23	40656.0
2020-08-24 07:25:00	SPY	ETF	342.26	342.28	342.19	342.28	9050.0
2020-08-24 07:30:00	SPY	ETF	342.22	342.28	342.21	342.23	26201.0
2020-08-24 07:35:00	SPY	ETF	342.22	342.29	342.22	342.29	15289.0
2020-08-24 07:40:00	SPY	ETF	342.25	342.29	342.2	342.25	18620.0
2020-08-24 07:45:00	SPY	ETF	342.27	342.27	342.21	342.26	28615.0
2020-08-24 07:50:00	SPY	ETF	342.26	342.27	342.2	342.26	23528.0
2020-08-24 07:55:00	SPY	ETF	342.23	342.4	342.23	342.35	46331.0
2020-08-24 08:00:00	SPY	ETF	342.39	342.46	340.59	342.46	64467.0
2020-08-24 08:05:00	SPY	ETF	342.46	342.48	342.3	342.3	33930.0

> showing 50 of 73,748 rows — these rows as CSV

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