PREVIEW / etf_5min / 2023-01-26

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-01-26.parquet
  size:    2.0 MB
  rows:    98,022

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-26 04:00:00	SPY	ETF	401.37	401.64	401.14	401.62	7476.0
2023-01-26 04:05:00	SPY	ETF	401.6	401.84	401.6	401.84	3686.0
2023-01-26 04:10:00	SPY	ETF	401.84	401.87	401.74	401.74	2681.0
2023-01-26 04:15:00	SPY	ETF	401.71	401.73	401.61	401.72	1516.0
2023-01-26 04:20:00	SPY	ETF	401.74	401.74	401.31	401.31	10902.0
2023-01-26 04:25:00	SPY	ETF	401.38	401.4	401.3	401.3	1489.0
2023-01-26 04:30:00	SPY	ETF	401.2	401.2	401.03	401.03	1532.0
2023-01-26 04:35:00	SPY	ETF	401.03	401.03	400.83	400.83	11361.0
2023-01-26 04:40:00	SPY	ETF	400.78	400.95	400.73	400.92	5049.0
2023-01-26 04:45:00	SPY	ETF	400.92	401.01	400.92	401.01	697.0
2023-01-26 04:50:00	SPY	ETF	401.07	401.08	401.0	401.0	10584.0
2023-01-26 04:55:00	SPY	ETF	400.94	400.94	400.81	400.84	848.0
2023-01-26 05:00:00	SPY	ETF	400.96	400.96	400.94	400.94	261.0
2023-01-26 05:05:00	SPY	ETF	400.97	401.04	400.93	401.04	1300.0
2023-01-26 05:10:00	SPY	ETF	401.14	401.15	401.06	401.06	1798.0
2023-01-26 05:15:00	SPY	ETF	401.14	401.14	401.05	401.07	1225.0
2023-01-26 05:20:00	SPY	ETF	401.06	401.2	401.06	401.11	1179.0
2023-01-26 05:25:00	SPY	ETF	401.03	401.03	401.0	401.0	269.0
2023-01-26 05:30:00	SPY	ETF	401.21	401.21	401.21	401.21	100.0
2023-01-26 05:35:00	SPY	ETF	401.39	401.39	401.25	401.38	3650.0
2023-01-26 05:40:00	SPY	ETF	401.43	401.43	401.28	401.28	807.0
2023-01-26 05:45:00	SPY	ETF	401.33	401.36	401.28	401.31	4367.0
2023-01-26 05:50:00	SPY	ETF	401.5	401.5	401.5	401.5	250.0
2023-01-26 05:55:00	SPY	ETF	401.52	401.52	401.34	401.34	11400.0
2023-01-26 06:00:00	SPY	ETF	401.28	401.28	401.28	401.28	400.0
2023-01-26 06:05:00	SPY	ETF	401.53	401.53	401.41	401.49	2220.0
2023-01-26 06:10:00	SPY	ETF	401.44	401.5	401.44	401.5	350.0
2023-01-26 06:15:00	SPY	ETF	401.4	401.53	401.4	401.44	600.0
2023-01-26 06:20:00	SPY	ETF	401.54	401.54	401.4	401.4	5965.0
2023-01-26 06:25:00	SPY	ETF	401.4	401.48	401.4	401.48	204.0
2023-01-26 06:30:00	SPY	ETF	401.34	401.34	401.22	401.22	8266.0
2023-01-26 06:35:00	SPY	ETF	401.2	401.27	401.1	401.1	9013.0
2023-01-26 06:40:00	SPY	ETF	401.12	401.18	401.08	401.18	1106.0
2023-01-26 06:45:00	SPY	ETF	401.24	401.25	401.05	401.1	3003.0
2023-01-26 06:50:00	SPY	ETF	401.16	401.19	401.1	401.1	4757.0
2023-01-26 06:55:00	SPY	ETF	401.18	401.24	401.14	401.24	9708.0
2023-01-26 07:00:00	SPY	ETF	401.25	401.38	401.17	401.34	8161.0
2023-01-26 07:05:00	SPY	ETF	401.35	401.45	401.34	401.36	9041.0
2023-01-26 07:10:00	SPY	ETF	401.45	401.45	401.43	401.43	816.0
2023-01-26 07:15:00	SPY	ETF	401.31	401.34	401.31	401.33	875.0
2023-01-26 07:20:00	SPY	ETF	401.31	401.42	401.27	401.32	6477.0
2023-01-26 07:25:00	SPY	ETF	401.29	401.48	401.23	401.48	7490.0
2023-01-26 07:30:00	SPY	ETF	401.34	401.85	401.34	401.79	11424.0
2023-01-26 07:35:00	SPY	ETF	401.77	401.82	401.7	401.7	4743.0
2023-01-26 07:40:00	SPY	ETF	401.71	401.93	401.71	401.85	14288.0
2023-01-26 07:45:00	SPY	ETF	401.86	402.26	401.84	402.24	44613.0
2023-01-26 07:50:00	SPY	ETF	402.25	402.96	402.25	402.58	75979.0
2023-01-26 07:55:00	SPY	ETF	402.58	402.58	402.4	402.55	24545.0
2023-01-26 08:00:00	SPY	ETF	401.32	402.8	400.95	402.58	91984.0
2023-01-26 08:05:00	SPY	ETF	402.5	402.5	402.18	402.18	189441.0

> showing 50 of 98,022 rows — these rows as CSV

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