PREVIEW / etf_5min / 2023-09-15

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-15.parquet
  size:    1.9 MB
  rows:    94,306

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-09-15 04:00:00	SPY	ETF	445.0	449.68	445.0	449.24	11858.0
2023-09-15 04:05:00	SPY	ETF	449.34	449.47	449.32	449.41	3613.0
2023-09-15 04:10:00	SPY	ETF	449.41	449.41	449.27	449.29	1568.0
2023-09-15 04:15:00	SPY	ETF	449.31	449.31	449.1	449.1	1500.0
2023-09-15 04:20:00	SPY	ETF	449.12	449.27	449.12	449.21	1943.0
2023-09-15 04:25:00	SPY	ETF	449.28	449.28	449.18	449.18	1987.0
2023-09-15 04:30:00	SPY	ETF	449.16	449.16	449.1	449.1	4892.0
2023-09-15 04:35:00	SPY	ETF	449.2	449.2	449.1	449.1	6199.0
2023-09-15 04:40:00	SPY	ETF	449.14	449.17	449.14	449.17	200.0
2023-09-15 04:45:00	SPY	ETF	449.1	449.21	449.1	449.21	1200.0
2023-09-15 04:50:00	SPY	ETF	449.26	449.26	449.1	449.1	4754.0
2023-09-15 04:55:00	SPY	ETF	449.15	449.15	449.1	449.1	1887.0
2023-09-15 05:00:00	SPY	ETF	449.11	449.12	449.06	449.08	5450.0
2023-09-15 05:05:00	SPY	ETF	449.22	449.39	449.22	449.36	2612.0
2023-09-15 05:10:00	SPY	ETF	449.34	449.34	449.11	449.13	4972.0
2023-09-15 05:15:00	SPY	ETF	449.1	449.16	449.06	449.09	7156.0
2023-09-15 05:20:00	SPY	ETF	449.18	449.23	449.1	449.1	3174.0
2023-09-15 05:25:00	SPY	ETF	449.18	449.21	449.14	449.21	1319.0
2023-09-15 05:30:00	SPY	ETF	449.2	449.32	449.2	449.27	973.0
2023-09-15 05:35:00	SPY	ETF	449.28	449.43	449.28	449.43	1527.0
2023-09-15 05:40:00	SPY	ETF	449.42	449.43	449.4	449.4	1460.0
2023-09-15 05:45:00	SPY	ETF	449.36	449.36	449.3	449.3	800.0
2023-09-15 05:50:00	SPY	ETF	449.3	449.3	449.3	449.3	125.0
2023-09-15 05:55:00	SPY	ETF	449.44	449.44	449.44	449.44	100.0
2023-09-15 06:00:00	SPY	ETF	449.34	449.37	449.27	449.28	10551.0
2023-09-15 06:05:00	SPY	ETF	449.22	449.41	449.22	449.41	300.0
2023-09-15 06:10:00	SPY	ETF	449.41	449.47	449.35	449.47	757.0
2023-09-15 06:15:00	SPY	ETF	449.41	449.43	449.38	449.38	1625.0
2023-09-15 06:20:00	SPY	ETF	449.42	449.47	449.42	449.47	3834.0
2023-09-15 06:25:00	SPY	ETF	449.5	449.59	449.42	449.45	1891.0
2023-09-15 06:30:00	SPY	ETF	449.44	449.5	449.38	449.46	3635.0
2023-09-15 06:35:00	SPY	ETF	449.44	449.44	449.37	449.4	963.0
2023-09-15 06:40:00	SPY	ETF	449.36	449.4	449.36	449.4	232.0
2023-09-15 06:45:00	SPY	ETF	449.45	449.45	449.45	449.45	111.0
2023-09-15 06:50:00	SPY	ETF	449.52	449.54	449.48	449.48	3759.0
2023-09-15 06:55:00	SPY	ETF	449.46	449.6	449.46	449.6	3187.0
2023-09-15 07:00:00	SPY	ETF	449.59	449.6	449.5	449.54	12289.0
2023-09-15 07:05:00	SPY	ETF	449.55	449.56	449.4	449.44	3299.0
2023-09-15 07:10:00	SPY	ETF	449.44	449.52	449.37	449.37	3572.0
2023-09-15 07:15:00	SPY	ETF	449.35	449.38	449.25	449.38	13337.0
2023-09-15 07:20:00	SPY	ETF	449.39	449.41	449.25	449.26	6329.0
2023-09-15 07:25:00	SPY	ETF	449.25	449.36	449.2	449.36	10403.0
2023-09-15 07:30:00	SPY	ETF	449.34	449.4	449.29	449.4	8455.0
2023-09-15 07:35:00	SPY	ETF	449.35	449.4	449.32	449.34	6835.0
2023-09-15 07:40:00	SPY	ETF	449.34	449.4	449.29	449.29	7079.0
2023-09-15 07:45:00	SPY	ETF	449.28	449.29	449.2	449.26	66395.0
2023-09-15 07:50:00	SPY	ETF	449.19	449.19	449.08	449.1	15325.0
2023-09-15 07:55:00	SPY	ETF	449.1	449.15	449.06	449.09	22431.0
2023-09-15 08:00:00	SPY	ETF	449.4182	449.93	449.09	449.18	99818.0
2023-09-15 08:05:00	SPY	ETF	449.21	449.42	449.2	449.38	19681.0

> showing 50 of 94,306 rows — these rows as CSV

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