PREVIEW / etf_5min / 2023-03-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-03-06.parquet
  size:    1.9 MB
  rows:    94,128

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-03-06 04:00:00	SPY	ETF	404.58	404.71	404.43	404.45	12993.0
2023-03-06 04:05:00	SPY	ETF	404.53	404.54	404.26	404.26	1631.0
2023-03-06 04:10:00	SPY	ETF	404.46	404.55	404.45	404.47	1612.0
2023-03-06 04:15:00	SPY	ETF	404.35	404.35	404.19	404.19	2400.0
2023-03-06 04:20:00	SPY	ETF	404.16	404.36	404.16	404.33	1590.0
2023-03-06 04:25:00	SPY	ETF	404.26	404.3	404.15	404.15	1285.0
2023-03-06 04:30:00	SPY	ETF	404.08	404.14	404.07	404.07	1130.0
2023-03-06 04:35:00	SPY	ETF	404.22	404.25	404.15	404.17	2650.0
2023-03-06 04:40:00	SPY	ETF	404.2	404.26	404.17	404.26	1060.0
2023-03-06 04:45:00	SPY	ETF	404.24	404.24	404.11	404.11	2910.0
2023-03-06 04:50:00	SPY	ETF	404.19	404.19	404.04	404.04	1002.0
2023-03-06 04:55:00	SPY	ETF	404.0	404.1	404.0	404.1	600.0
2023-03-06 05:00:00	SPY	ETF	404.13	404.26	404.13	404.16	1613.0
2023-03-06 05:05:00	SPY	ETF	404.17	404.21	404.0	404.0	1779.0
2023-03-06 05:10:00	SPY	ETF	404.06	404.26	404.06	404.14	741.0
2023-03-06 05:15:00	SPY	ETF	404.2	404.22	404.17	404.17	1700.0
2023-03-06 05:20:00	SPY	ETF	404.19	404.19	404.14	404.14	378.0
2023-03-06 05:25:00	SPY	ETF	404.19	404.19	404.07	404.09	1100.0
2023-03-06 05:30:00	SPY	ETF	404.05	404.05	404.0	404.0	2330.0
2023-03-06 05:35:00	SPY	ETF	403.98	403.98	403.89	403.9	2000.0
2023-03-06 05:40:00	SPY	ETF	403.92	404.1	403.92	404.09	1050.0
2023-03-06 05:45:00	SPY	ETF	404.17	404.24	404.17	404.24	308.0
2023-03-06 05:50:00	SPY	ETF	404.25	404.41	404.25	404.41	2111.0
2023-03-06 05:55:00	SPY	ETF	404.38	404.38	404.38	404.38	300.0
2023-03-06 06:00:00	SPY	ETF	404.37	404.37	404.2	404.2	1800.0
2023-03-06 06:05:00	SPY	ETF	404.24	404.24	404.24	404.24	500.0
2023-03-06 06:10:00	SPY	ETF	404.39	404.57	404.39	404.5	8635.0
2023-03-06 06:15:00	SPY	ETF	404.46	404.5	404.34	404.5	2177.0
2023-03-06 06:20:00	SPY	ETF	404.46	404.47	404.41	404.41	455.0
2023-03-06 06:25:00	SPY	ETF	404.3	404.3	404.27	404.27	700.0
2023-03-06 06:30:00	SPY	ETF	404.19	404.27	404.13	404.18	3621.0
2023-03-06 06:35:00	SPY	ETF	404.18	404.2	404.1	404.19	2510.0
2023-03-06 06:40:00	SPY	ETF	404.19	404.19	404.0	404.0	2604.0
2023-03-06 06:45:00	SPY	ETF	404.0	404.01	403.73	403.8	21135.0
2023-03-06 06:50:00	SPY	ETF	403.83	403.83	403.62	403.64	11848.0
2023-03-06 06:55:00	SPY	ETF	403.68	403.85	403.64	403.78	14950.0
2023-03-06 07:00:00	SPY	ETF	403.73	403.93	403.68	403.9	34529.0
2023-03-06 07:05:00	SPY	ETF	403.89	404.0	403.86	403.9	34321.0
2023-03-06 07:10:00	SPY	ETF	403.94	403.96	403.75	403.76	19899.0
2023-03-06 07:15:00	SPY	ETF	403.78	403.88	403.78	403.88	6850.0
2023-03-06 07:20:00	SPY	ETF	403.85	404.01	403.85	403.94	10149.0
2023-03-06 07:25:00	SPY	ETF	403.96	404.01	403.96	403.98	5584.0
2023-03-06 07:30:00	SPY	ETF	403.97	404.06	403.89	403.89	9324.0
2023-03-06 07:35:00	SPY	ETF	403.89	404.15	403.89	404.15	45835.0
2023-03-06 07:40:00	SPY	ETF	404.15	404.15	404.1	404.15	5634.0
2023-03-06 07:45:00	SPY	ETF	404.15	404.17	404.04	404.15	57861.0
2023-03-06 07:50:00	SPY	ETF	404.18	404.39	404.16	404.39	8530.0
2023-03-06 07:55:00	SPY	ETF	404.39	404.39	404.27	404.39	39754.0
2023-03-06 08:00:00	SPY	ETF	403.72	405.03	403.69	404.36	53063.0
2023-03-06 08:05:00	SPY	ETF	404.35	404.37	404.21	404.35	20562.0

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

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