PREVIEW / etf_5min / 2023-05-09

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-09.parquet
  size:    1.8 MB
  rows:    90,407

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-05-09 04:00:00	SPY	ETF	412.01	412.05	412.0	412.05	951.0
2023-05-09 04:05:00	SPY	ETF	412.11	412.11	412.0	412.0	1905.0
2023-05-09 04:10:00	SPY	ETF	411.93	411.93	411.93	411.93	1900.0
2023-05-09 04:15:00	SPY	ETF	411.8	411.84	411.79	411.84	500.0
2023-05-09 04:20:00	SPY	ETF	411.77	411.83	411.76	411.77	2700.0
2023-05-09 04:25:00	SPY	ETF	411.72	411.72	411.49	411.54	1500.0
2023-05-09 04:30:00	SPY	ETF	411.45	411.47	411.21	411.33	3300.0
2023-05-09 04:35:00	SPY	ETF	411.35	411.38	411.32	411.33	3258.0
2023-05-09 04:40:00	SPY	ETF	411.25	411.25	411.23	411.23	800.0
2023-05-09 04:45:00	SPY	ETF	411.18	411.3	411.15	411.3	1500.0
2023-05-09 04:50:00	SPY	ETF	411.28	411.5	411.28	411.5	3550.0
2023-05-09 04:55:00	SPY	ETF	411.45	411.45	411.23	411.34	5350.0
2023-05-09 05:05:00	SPY	ETF	411.44	411.47	411.44	411.47	4000.0
2023-05-09 05:10:00	SPY	ETF	411.47	411.47	411.35	411.4	1404.0
2023-05-09 05:15:00	SPY	ETF	411.34	411.42	411.3	411.39	500.0
2023-05-09 05:20:00	SPY	ETF	411.33	411.33	411.2	411.2	2800.0
2023-05-09 05:25:00	SPY	ETF	411.25	411.27	411.24	411.27	850.0
2023-05-09 05:30:00	SPY	ETF	411.32	411.32	411.27	411.27	400.0
2023-05-09 05:35:00	SPY	ETF	411.35	411.44	411.35	411.43	900.0
2023-05-09 05:45:00	SPY	ETF	411.38	411.38	411.35	411.35	250.0
2023-05-09 05:50:00	SPY	ETF	411.31	411.34	411.14	411.25	66079.0
2023-05-09 05:55:00	SPY	ETF	411.33	411.48	411.33	411.48	59991.0
2023-05-09 06:00:00	SPY	ETF	411.46	411.5	411.46	411.5	538.0
2023-05-09 06:05:00	SPY	ETF	411.48	411.48	411.41	411.41	598.0
2023-05-09 06:15:00	SPY	ETF	411.3	411.33	411.3	411.33	640.0
2023-05-09 06:20:00	SPY	ETF	411.35	411.35	411.32	411.33	3398.0
2023-05-09 06:25:00	SPY	ETF	411.29	411.29	411.29	411.29	400.0
2023-05-09 06:30:00	SPY	ETF	411.2	411.38	411.15	411.38	2700.0
2023-05-09 06:35:00	SPY	ETF	411.42	411.43	411.42	411.42	5000.0
2023-05-09 06:40:00	SPY	ETF	411.39	411.4	411.39	411.4	200.0
2023-05-09 06:45:00	SPY	ETF	411.45	411.46	411.41	411.41	1622.0
2023-05-09 06:50:00	SPY	ETF	411.39	411.39	411.37	411.37	1200.0
2023-05-09 06:55:00	SPY	ETF	411.37	411.38	411.34	411.34	1600.0
2023-05-09 07:00:00	SPY	ETF	411.39	411.41	411.28	411.28	18482.0
2023-05-09 07:05:00	SPY	ETF	411.25	411.28	411.14	411.25	40747.0
2023-05-09 07:10:00	SPY	ETF	411.23	411.35	411.211	411.34	2223.0
2023-05-09 07:15:00	SPY	ETF	411.33	411.33	411.26	411.28	2590.0
2023-05-09 07:20:00	SPY	ETF	411.26	411.26	411.11	411.18	4359.0
2023-05-09 07:25:00	SPY	ETF	411.2	411.2	411.06	411.14	17390.0
2023-05-09 07:30:00	SPY	ETF	411.2	411.2	411.03	411.03	8676.0
2023-05-09 07:35:00	SPY	ETF	411.02	411.1	411.0	411.0	12820.0
2023-05-09 07:40:00	SPY	ETF	411.1	411.16	411.09	411.09	7584.0
2023-05-09 07:45:00	SPY	ETF	411.07	411.35	411.06	411.26	26785.0
2023-05-09 07:50:00	SPY	ETF	411.27	411.3	411.2	411.29	4760.0
2023-05-09 07:55:00	SPY	ETF	411.31	411.31	411.24	411.26	7679.0
2023-05-09 08:00:00	SPY	ETF	411.2994	412.44	411.0	411.25	32017.0
2023-05-09 08:05:00	SPY	ETF	411.25	411.39	411.17	411.39	7353.0
2023-05-09 08:10:00	SPY	ETF	411.39	411.52	411.39	411.45	23672.0
2023-05-09 08:15:00	SPY	ETF	411.4999	411.52	411.45	411.49	14571.0
2023-05-09 08:20:00	SPY	ETF	411.51	411.51	411.39	411.41	9417.0

> showing 50 of 90,407 rows — these rows as CSV

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