PREVIEW / etf_5min / 2023-01-24

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-24.parquet
  size:    2.0 MB
  rows:    96,828

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-24 04:00:00	SPY	ETF	400.18	400.25	400.16	400.17	3446.0
2023-01-24 04:05:00	SPY	ETF	400.34	400.41	400.31	400.34	926.0
2023-01-24 04:10:00	SPY	ETF	400.26	400.5	400.26	400.47	931.0
2023-01-24 04:15:00	SPY	ETF	400.51	400.51	400.46	400.48	845.0
2023-01-24 04:20:00	SPY	ETF	400.4	400.4	400.31	400.31	206.0
2023-01-24 04:25:00	SPY	ETF	400.15	400.38	400.15	400.35	5405.0
2023-01-24 04:30:00	SPY	ETF	400.3	400.34	400.15	400.17	7836.0
2023-01-24 04:35:00	SPY	ETF	400.16	400.26	400.15	400.16	3357.0
2023-01-24 04:40:00	SPY	ETF	400.21	400.21	399.95	399.95	10744.0
2023-01-24 04:45:00	SPY	ETF	400.01	400.05	399.99	400.05	2152.0
2023-01-24 04:50:00	SPY	ETF	400.07	400.16	400.02	400.06	1182.0
2023-01-24 04:55:00	SPY	ETF	400.01	400.1	400.01	400.08	989.0
2023-01-24 05:00:00	SPY	ETF	400.1	400.13	400.1	400.1	1187.0
2023-01-24 05:05:00	SPY	ETF	400.13	400.13	399.96	399.96	2400.0
2023-01-24 05:10:00	SPY	ETF	399.95	399.95	399.87	399.87	1180.0
2023-01-24 05:15:00	SPY	ETF	399.97	399.97	399.74	399.8	2654.0
2023-01-24 05:20:00	SPY	ETF	399.74	399.82	399.71	399.82	1074.0
2023-01-24 05:25:00	SPY	ETF	399.79	399.79	399.75	399.78	915.0
2023-01-24 05:30:00	SPY	ETF	399.71	399.71	399.61	399.61	764.0
2023-01-24 05:35:00	SPY	ETF	399.81	399.94	399.81	399.94	1109.0
2023-01-24 05:40:00	SPY	ETF	399.91	399.98	399.91	399.98	300.0
2023-01-24 05:45:00	SPY	ETF	399.76	399.9	399.69	399.9	15807.0
2023-01-24 05:50:00	SPY	ETF	399.95	400.01	399.95	399.99	1262.0
2023-01-24 05:55:00	SPY	ETF	399.94	400.0	399.94	400.0	640.0
2023-01-24 06:00:00	SPY	ETF	400.04	400.04	399.86	399.86	1600.0
2023-01-24 06:05:00	SPY	ETF	399.69	399.69	399.53	399.61	2407.0
2023-01-24 06:10:00	SPY	ETF	399.67	399.67	399.54	399.54	1100.0
2023-01-24 06:15:00	SPY	ETF	399.61	399.61	399.53	399.53	442.0
2023-01-24 06:20:00	SPY	ETF	399.47	399.59	399.47	399.59	11250.0
2023-01-24 06:25:00	SPY	ETF	399.53	399.62	399.53	399.53	3800.0
2023-01-24 06:30:00	SPY	ETF	399.5	399.58	399.45	399.58	6295.0
2023-01-24 06:35:00	SPY	ETF	399.6	399.78	399.6	399.74	1311.0
2023-01-24 06:40:00	SPY	ETF	399.8	399.81	399.72	399.79	1120.0
2023-01-24 06:45:00	SPY	ETF	399.84	399.9	399.84	399.9	1116.0
2023-01-24 06:50:00	SPY	ETF	399.95	399.95	399.75	399.75	4670.0
2023-01-24 06:55:00	SPY	ETF	399.77	399.84	399.76	399.77	3168.0
2023-01-24 07:00:00	SPY	ETF	399.75	399.76	399.51	399.54	6215.0
2023-01-24 07:05:00	SPY	ETF	399.52	399.7	399.52	399.53	9094.0
2023-01-24 07:10:00	SPY	ETF	399.55	399.59	399.4	399.59	6650.0
2023-01-24 07:15:00	SPY	ETF	399.56	399.69	399.56	399.56	2175.0
2023-01-24 07:20:00	SPY	ETF	399.56	399.7	399.56	399.6	3766.0
2023-01-24 07:25:00	SPY	ETF	399.64	399.71	399.56	399.68	6641.0
2023-01-24 07:30:00	SPY	ETF	399.63	399.67	399.51	399.51	3518.0
2023-01-24 07:35:00	SPY	ETF	399.52	399.58	399.38	399.49	31272.0
2023-01-24 07:40:00	SPY	ETF	399.59	399.81	399.51	399.72	13937.0
2023-01-24 07:45:00	SPY	ETF	399.67	399.75	399.61	399.75	2686.0
2023-01-24 07:50:00	SPY	ETF	399.74	399.83	399.74	399.75	4515.0
2023-01-24 07:55:00	SPY	ETF	399.69	399.69	399.66	399.66	7061.0
2023-01-24 08:00:00	SPY	ETF	399.6	400.85	399.38	399.71	28713.0
2023-01-24 08:05:00	SPY	ETF	399.69	399.76	399.6	399.73	4583.0

> showing 50 of 96,828 rows — these rows as CSV

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