PREVIEW / etf_5min / 2023-07-27

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-27.parquet
  size:    2.1 MB
  rows:    101,948

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
2023-07-27 04:00:00	SPY	ETF	457.44	457.98	457.27	457.97	20349.0
2023-07-27 04:05:00	SPY	ETF	458.02	458.04	458.0	458.02	6884.0
2023-07-27 04:10:00	SPY	ETF	458.05	458.13	458.02	458.1	4324.0
2023-07-27 04:15:00	SPY	ETF	458.1	458.18	458.1	458.18	4108.0
2023-07-27 04:20:00	SPY	ETF	458.17	458.25	458.13	458.2	2793.0
2023-07-27 04:25:00	SPY	ETF	458.22	458.28	458.19	458.28	1596.0
2023-07-27 04:30:00	SPY	ETF	458.27	458.32	458.25	458.27	7199.0
2023-07-27 04:35:00	SPY	ETF	458.32	458.32	458.01	458.01	5901.0
2023-07-27 04:40:00	SPY	ETF	458.02	458.22	458.02	458.2	1161.0
2023-07-27 04:45:00	SPY	ETF	458.14	458.14	458.14	458.14	200.0
2023-07-27 04:50:00	SPY	ETF	458.13	458.23	458.12	458.23	1121.0
2023-07-27 04:55:00	SPY	ETF	458.22	458.31	458.22	458.31	614.0
2023-07-27 05:00:00	SPY	ETF	458.25	458.27	458.22	458.27	1798.0
2023-07-27 05:05:00	SPY	ETF	458.2	458.2	458.2	458.2	100.0
2023-07-27 05:10:00	SPY	ETF	458.25	458.32	458.25	458.32	451.0
2023-07-27 05:20:00	SPY	ETF	458.26	458.26	458.1	458.11	3995.0
2023-07-27 05:25:00	SPY	ETF	458.19	458.23	458.12	458.13	1972.0
2023-07-27 05:30:00	SPY	ETF	458.2	458.28	458.2	458.28	850.0
2023-07-27 05:35:00	SPY	ETF	458.29	458.29	458.29	458.29	240.0
2023-07-27 05:40:00	SPY	ETF	458.35	458.38	458.32	458.38	400.0
2023-07-27 05:45:00	SPY	ETF	458.26	458.31	458.26	458.31	400.0
2023-07-27 05:50:00	SPY	ETF	458.34	458.34	458.26	458.31	708.0
2023-07-27 05:55:00	SPY	ETF	458.27	458.29	458.21	458.21	600.0
2023-07-27 06:00:00	SPY	ETF	458.17	458.2	458.17	458.2	1105.0
2023-07-27 06:05:00	SPY	ETF	458.2	458.31	458.2	458.3	2439.0
2023-07-27 06:10:00	SPY	ETF	458.28	458.33	458.26	458.33	2070.0
2023-07-27 06:15:00	SPY	ETF	458.32	458.32	458.25	458.25	5437.0
2023-07-27 06:20:00	SPY	ETF	458.25	458.28	458.25	458.28	750.0
2023-07-27 06:25:00	SPY	ETF	458.34	458.34	458.32	458.32	1100.0
2023-07-27 06:30:00	SPY	ETF	458.39	458.47	458.36	458.37	2972.0
2023-07-27 06:35:00	SPY	ETF	458.39	458.39	458.39	458.39	500.0
2023-07-27 06:40:00	SPY	ETF	458.3	458.33	458.3	458.33	4221.0
2023-07-27 06:45:00	SPY	ETF	458.3	458.39	458.3	458.3	550.0
2023-07-27 06:50:00	SPY	ETF	458.31	458.31	458.18	458.18	11390.0
2023-07-27 06:55:00	SPY	ETF	458.2	458.24	458.16	458.2	2570.0
2023-07-27 07:00:00	SPY	ETF	458.2	458.29	458.08	458.2	14377.0
2023-07-27 07:05:00	SPY	ETF	458.25	458.26	458.12	458.12	5361.0
2023-07-27 07:10:00	SPY	ETF	458.13	458.24	458.13	458.15	1841.0
2023-07-27 07:15:00	SPY	ETF	458.18	458.21	458.14	458.21	15339.0
2023-07-27 07:20:00	SPY	ETF	458.21	458.39	458.2	458.36	23841.0
2023-07-27 07:25:00	SPY	ETF	458.35	458.37	458.32	458.35	9700.0
2023-07-27 07:30:00	SPY	ETF	458.35	458.57	458.35	458.53	6679.0
2023-07-27 07:35:00	SPY	ETF	458.57	458.6	458.5	458.54	4767.0
2023-07-27 07:40:00	SPY	ETF	458.54	458.7	458.54	458.69	13812.0
2023-07-27 07:45:00	SPY	ETF	458.7	458.72	458.63	458.63	14046.0
2023-07-27 07:50:00	SPY	ETF	458.68	458.71	458.641	458.69	10224.0
2023-07-27 07:55:00	SPY	ETF	458.69	458.73	458.65	458.65	10094.0
2023-07-27 08:00:00	SPY	ETF	458.09	458.79	456.85	458.67	72330.0
2023-07-27 08:05:00	SPY	ETF	458.69	458.69	458.59	458.64	70883.0
2023-07-27 08:10:00	SPY	ETF	458.72	458.8	458.7	458.8	31906.0

> showing 50 of 101,948 rows — these rows as CSV

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