PREVIEW / etf_5min / 2023-01-19

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-19.parquet
  size:    2.0 MB
  rows:    97,358

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-01-19 04:00:00	SPY	ETF	390.22	390.5	390.11	390.4	17576.0
2023-01-19 04:05:00	SPY	ETF	390.32	390.45	390.27	390.3	7879.0
2023-01-19 04:10:00	SPY	ETF	390.44	390.62	390.44	390.6	15044.0
2023-01-19 04:15:00	SPY	ETF	390.61	390.61	390.23	390.23	2809.0
2023-01-19 04:20:00	SPY	ETF	390.22	390.3	390.17	390.2	7266.0
2023-01-19 04:25:00	SPY	ETF	390.11	390.18	390.04	390.04	3006.0
2023-01-19 04:30:00	SPY	ETF	390.05	390.19	390.05	390.1	1975.0
2023-01-19 04:35:00	SPY	ETF	390.04	390.04	389.92	390.0	3377.0
2023-01-19 04:40:00	SPY	ETF	389.91	390.0	389.85	390.0	14767.0
2023-01-19 04:45:00	SPY	ETF	389.93	389.97	389.83	389.97	6432.0
2023-01-19 04:50:00	SPY	ETF	390.0	390.0	389.82	389.83	700.0
2023-01-19 04:55:00	SPY	ETF	389.96	389.97	389.93	389.95	1841.0
2023-01-19 05:00:00	SPY	ETF	389.96	390.1	389.96	390.03	101800.0
2023-01-19 05:05:00	SPY	ETF	390.08	390.08	389.84	389.97	3217.0
2023-01-19 05:10:00	SPY	ETF	390.1	390.26	390.1	390.17	3422.0
2023-01-19 05:15:00	SPY	ETF	389.9	389.91	389.9	389.91	200.0
2023-01-19 05:20:00	SPY	ETF	389.9	389.9	389.77	389.77	2119.0
2023-01-19 05:25:00	SPY	ETF	389.78	389.8	389.56	389.56	1428.0
2023-01-19 05:30:00	SPY	ETF	389.56	389.62	389.52	389.61	9088.0
2023-01-19 05:35:00	SPY	ETF	389.55	389.55	389.41	389.41	3810.0
2023-01-19 05:40:00	SPY	ETF	389.43	389.49	389.43	389.48	2403.0
2023-01-19 05:45:00	SPY	ETF	389.48	389.52	389.37	389.5	17723.0
2023-01-19 05:50:00	SPY	ETF	389.55	389.62	389.51	389.51	3452.0
2023-01-19 05:55:00	SPY	ETF	389.61	389.64	389.56	389.64	6750.0
2023-01-19 06:00:00	SPY	ETF	389.66	389.66	389.25	389.26	4571.0
2023-01-19 06:05:00	SPY	ETF	389.24	389.6	389.24	389.59	202154.0
2023-01-19 06:10:00	SPY	ETF	389.57	389.61	389.36	389.39	1878.0
2023-01-19 06:15:00	SPY	ETF	389.31	389.31	389.13	389.14	7228.0
2023-01-19 06:20:00	SPY	ETF	389.15	389.15	388.96	388.98	7998.0
2023-01-19 06:25:00	SPY	ETF	388.92	388.98	388.84	388.86	11639.0
2023-01-19 06:30:00	SPY	ETF	388.85	388.85	388.75	388.81	23320.0
2023-01-19 06:35:00	SPY	ETF	388.75	388.9	388.75	388.89	3074.0
2023-01-19 06:40:00	SPY	ETF	388.9	388.9	388.75	388.75	8245.0
2023-01-19 06:45:00	SPY	ETF	388.78	388.83	388.75	388.82	15334.0
2023-01-19 06:50:00	SPY	ETF	388.86	388.86	388.71	388.83	4539.0
2023-01-19 06:55:00	SPY	ETF	388.88	389.15	388.88	388.95	25247.0
2023-01-19 07:00:00	SPY	ETF	389.0	389.02	388.5	388.55	56231.0
2023-01-19 07:05:00	SPY	ETF	388.6	388.83	388.56	388.83	23365.0
2023-01-19 07:10:00	SPY	ETF	388.79	388.95	388.69	388.9	38927.0
2023-01-19 07:15:00	SPY	ETF	388.93	388.95	388.65	388.68	13763.0
2023-01-19 07:20:00	SPY	ETF	388.65	388.83	388.5	388.52	16000.0
2023-01-19 07:25:00	SPY	ETF	388.5	388.75	388.47	388.75	11469.0
2023-01-19 07:30:00	SPY	ETF	388.73	388.73	388.45	388.59	24094.0
2023-01-19 07:35:00	SPY	ETF	388.5	388.77	388.5	388.6	23093.0
2023-01-19 07:40:00	SPY	ETF	388.61	388.61	388.36	388.36	16397.0
2023-01-19 07:45:00	SPY	ETF	388.4	388.42	388.22	388.26	30085.0
2023-01-19 07:50:00	SPY	ETF	388.27	388.36	388.23	388.23	58909.0
2023-01-19 07:55:00	SPY	ETF	388.23	388.37	388.17	388.34	48564.0
2023-01-19 08:00:00	SPY	ETF	388.85	391.19	388.11	388.22	121323.0
2023-01-19 08:05:00	SPY	ETF	388.32	388.3995	388.21	388.38	33975.0

> showing 50 of 97,358 rows — these rows as CSV

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