PREVIEW / etf_5min / 2022-08-24

all etf 5-min files

  file:    by_date/etf_5min/2022/2022-08-24.parquet
  size:    1.8 MB
  rows:    86,546

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
2022-08-24 04:00:00	SPY	ETF	411.15	411.52	411.13	411.48	2093.0
2022-08-24 04:05:00	SPY	ETF	411.52	411.68	411.52	411.67	500.0
2022-08-24 04:10:00	SPY	ETF	411.88	411.89	411.83	411.83	1237.0
2022-08-24 04:15:00	SPY	ETF	412.0	412.01	411.83	411.96	8700.0
2022-08-24 04:20:00	SPY	ETF	411.95	412.14	411.95	412.08	3126.0
2022-08-24 04:25:00	SPY	ETF	412.11	412.19	412.07	412.14	1770.0
2022-08-24 04:30:00	SPY	ETF	412.32	412.79	412.32	412.79	39357.0
2022-08-24 04:35:00	SPY	ETF	412.7	412.7	412.53	412.53	4004.0
2022-08-24 04:40:00	SPY	ETF	412.52	412.52	412.19	412.19	4579.0
2022-08-24 04:45:00	SPY	ETF	412.33	412.33	412.33	412.33	400.0
2022-08-24 04:50:00	SPY	ETF	412.38	412.38	412.36	412.36	249.0
2022-08-24 04:55:00	SPY	ETF	412.4	412.5	412.4	412.48	900.0
2022-08-24 05:00:00	SPY	ETF	412.67	412.79	412.67	412.7	2429.0
2022-08-24 05:05:00	SPY	ETF	412.5	412.51	412.49	412.49	1399.0
2022-08-24 05:10:00	SPY	ETF	412.68	412.68	412.55	412.55	700.0
2022-08-24 05:15:00	SPY	ETF	412.52	412.52	412.43	412.43	695.0
2022-08-24 05:20:00	SPY	ETF	412.48	412.48	412.48	412.48	100.0
2022-08-24 05:25:00	SPY	ETF	412.35	412.35	412.29	412.29	19571.0
2022-08-24 05:30:00	SPY	ETF	412.13	412.15	411.98	411.98	29006.0
2022-08-24 05:35:00	SPY	ETF	412.07	412.08	412.0	412.0	11960.0
2022-08-24 05:40:00	SPY	ETF	412.17	412.27	412.17	412.2	4399.0
2022-08-24 05:50:00	SPY	ETF	412.04	412.04	411.98	411.99	2026.0
2022-08-24 05:55:00	SPY	ETF	412.0	412.13	412.0	412.05	9280.0
2022-08-24 06:00:00	SPY	ETF	412.02	412.08	411.95	412.07	1397.0
2022-08-24 06:15:00	SPY	ETF	412.2	412.2	412.13	412.13	577.0
2022-08-24 06:20:00	SPY	ETF	412.35	412.38	412.35	412.38	900.0
2022-08-24 06:25:00	SPY	ETF	412.28	412.28	412.06	412.06	3799.0
2022-08-24 06:30:00	SPY	ETF	412.11	412.16	412.11	412.13	1600.0
2022-08-24 06:35:00	SPY	ETF	412.3	412.35	412.28	412.28	1950.0
2022-08-24 06:40:00	SPY	ETF	412.13	412.22	411.91	412.21	26050.0
2022-08-24 06:45:00	SPY	ETF	412.24	412.24	412.03	412.03	7190.0
2022-08-24 06:50:00	SPY	ETF	412.03	412.03	411.91	411.95	32628.0
2022-08-24 06:55:00	SPY	ETF	411.8	411.93	411.79	411.85	17350.0
2022-08-24 07:00:00	SPY	ETF	411.85	412.07	411.85	412.07	9382.0
2022-08-24 07:05:00	SPY	ETF	412.1	412.28	411.99	412.28	12764.0
2022-08-24 07:10:00	SPY	ETF	412.29	412.42	412.29	412.39	10458.0
2022-08-24 07:15:00	SPY	ETF	412.45	412.45	412.3	412.37	3201.0
2022-08-24 07:20:00	SPY	ETF	412.37	412.52	412.36	412.43	1858.0
2022-08-24 07:25:00	SPY	ETF	412.3	412.56	412.26	412.56	10972.0
2022-08-24 07:30:00	SPY	ETF	412.55	412.7	412.48	412.48	23862.0
2022-08-24 07:35:00	SPY	ETF	412.44	412.44	412.42	412.42	600.0
2022-08-24 07:40:00	SPY	ETF	412.62	412.69	412.53	412.69	3700.0
2022-08-24 07:45:00	SPY	ETF	412.74	413.08	412.7	413.08	31528.0
2022-08-24 07:50:00	SPY	ETF	413.07	413.13	412.99	413.12	79201.0
2022-08-24 07:55:00	SPY	ETF	413.19	413.23	412.96	413.0	5495.0
2022-08-24 08:00:00	SPY	ETF	412.01	413.45	410.86	413.34	46968.0
2022-08-24 08:05:00	SPY	ETF	413.38	413.39	413.18	413.18	18470.0
2022-08-24 08:10:00	SPY	ETF	413.21	413.24	413.06	413.24	123479.0
2022-08-24 08:15:00	SPY	ETF	413.26	413.4	413.11	413.12	23507.0
2022-08-24 08:20:00	SPY	ETF	413.1	413.1	412.87	413.0	9000.0

> showing 50 of 86,546 rows — these rows as CSV

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