PREVIEW / etf_5min / 2021-07-23

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-23.parquet
  size:    1.7 MB
  rows:    78,108

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
2021-07-23 04:00:00	SPY	ETF	437.22	437.22	437.09	437.14	8626.0
2021-07-23 04:05:00	SPY	ETF	437.07	437.19	437.07	437.18	40218.0
2021-07-23 04:10:00	SPY	ETF	437.13	437.15	437.13	437.14	1351.0
2021-07-23 04:15:00	SPY	ETF	437.17	437.18	437.17	437.18	397.0
2021-07-23 04:20:00	SPY	ETF	437.15	437.15	437.08	437.14	5496.0
2021-07-23 04:25:00	SPY	ETF	437.14	437.14	437.09	437.09	1900.0
2021-07-23 04:30:00	SPY	ETF	437.11	437.17	437.1	437.17	900.0
2021-07-23 04:35:00	SPY	ETF	437.27	437.32	437.25	437.3	3869.0
2021-07-23 04:40:00	SPY	ETF	437.27	437.27	437.27	437.27	100.0
2021-07-23 04:45:00	SPY	ETF	437.37	437.37	437.35	437.37	490.0
2021-07-23 04:50:00	SPY	ETF	437.26	437.26	437.26	437.26	300.0
2021-07-23 04:55:00	SPY	ETF	437.3	437.3	437.3	437.3	278.0
2021-07-23 05:00:00	SPY	ETF	437.27	437.3	437.25	437.3	500.0
2021-07-23 05:05:00	SPY	ETF	437.3	437.3	437.25	437.27	6200.0
2021-07-23 05:10:00	SPY	ETF	437.32	437.43	437.32	437.38	1605.0
2021-07-23 05:20:00	SPY	ETF	437.38	437.38	437.38	437.38	100.0
2021-07-23 05:30:00	SPY	ETF	437.37	437.37	437.37	437.37	200.0
2021-07-23 05:35:00	SPY	ETF	437.51	437.51	437.51	437.51	100.0
2021-07-23 05:40:00	SPY	ETF	437.6	437.65	437.6	437.61	2345.0
2021-07-23 05:45:00	SPY	ETF	437.61	437.65	437.61	437.65	200.0
2021-07-23 05:50:00	SPY	ETF	437.61	437.61	437.61	437.61	400.0
2021-07-23 06:10:00	SPY	ETF	437.47	437.54	437.43	437.54	6834.0
2021-07-23 06:15:00	SPY	ETF	437.5	437.5	437.46	437.5	8202.0
2021-07-23 06:20:00	SPY	ETF	437.5	437.5	437.5	437.5	3083.0
2021-07-23 06:25:00	SPY	ETF	437.5	437.56	437.5	437.52	1400.0
2021-07-23 06:30:00	SPY	ETF	437.53	437.57	437.5	437.57	11750.0
2021-07-23 06:35:00	SPY	ETF	437.57	437.6	437.56	437.59	2287.0
2021-07-23 06:40:00	SPY	ETF	437.59	437.62	437.59	437.62	1499.0
2021-07-23 06:45:00	SPY	ETF	437.62	437.63	437.6	437.6	670.0
2021-07-23 06:50:00	SPY	ETF	437.59	437.62	437.59	437.62	488.0
2021-07-23 06:55:00	SPY	ETF	437.55	437.6	437.51	437.57	3316.0
2021-07-23 07:00:00	SPY	ETF	437.57	437.59	437.5	437.5	15292.0
2021-07-23 07:05:00	SPY	ETF	437.49	437.51	437.32	437.42	5662.0
2021-07-23 07:10:00	SPY	ETF	437.44	437.44	437.38	437.38	3100.0
2021-07-23 07:15:00	SPY	ETF	437.38	437.43	437.34	437.43	3221.0
2021-07-23 07:20:00	SPY	ETF	437.43	437.43	437.31	437.31	1795.0
2021-07-23 07:25:00	SPY	ETF	437.31	437.31	437.15	437.2	32001.0
2021-07-23 07:30:00	SPY	ETF	437.23	437.23	437.2	437.2	2900.0
2021-07-23 07:35:00	SPY	ETF	437.33	437.35	437.31	437.33	8170.0
2021-07-23 07:40:00	SPY	ETF	437.33	437.39	437.31	437.31	4277.0
2021-07-23 07:45:00	SPY	ETF	437.29	437.3	437.21	437.21	2847.0
2021-07-23 07:50:00	SPY	ETF	437.27	437.41	437.27	437.41	2577.0
2021-07-23 07:55:00	SPY	ETF	437.38	437.43	437.38	437.4	20178.0
2021-07-23 08:00:00	SPY	ETF	437.5699	437.59	437.0	437.46	67089.0
2021-07-23 08:05:00	SPY	ETF	437.45	437.5	437.44	437.47	20772.0
2021-07-23 08:10:00	SPY	ETF	437.44	437.5	437.44	437.5	3833.0
2021-07-23 08:15:00	SPY	ETF	437.5	437.5	437.43	437.5	2897.0
2021-07-23 08:20:00	SPY	ETF	437.53	437.6	437.52	437.57	6748.0
2021-07-23 08:25:00	SPY	ETF	437.57	438.0	437.57	437.61	39697.0
2021-07-23 08:30:00	SPY	ETF	437.61	437.65	437.5	437.5	8394.0

> showing 50 of 78,108 rows — these rows as CSV

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