PREVIEW / etf_5min / 2023-05-25

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-05-25.parquet
  size:    2.0 MB
  rows:    97,366

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-25 04:00:00	SPY	ETF	412.59	412.9	412.5	412.86	13298.0
2023-05-25 04:05:00	SPY	ETF	413.04	413.2	413.04	413.12	1752.0
2023-05-25 04:10:00	SPY	ETF	413.07	413.2	413.05	413.12	5226.0
2023-05-25 04:15:00	SPY	ETF	413.18	413.4	413.18	413.4	1434.0
2023-05-25 04:20:00	SPY	ETF	413.38	413.4	413.27	413.3	3635.0
2023-05-25 04:25:00	SPY	ETF	413.29	413.38	413.23	413.35	1706.0
2023-05-25 04:30:00	SPY	ETF	413.37	413.37	413.22	413.22	1942.0
2023-05-25 04:35:00	SPY	ETF	413.26	413.37	413.21	413.21	1098.0
2023-05-25 04:40:00	SPY	ETF	413.33	413.38	413.33	413.38	227.0
2023-05-25 04:45:00	SPY	ETF	413.55	413.58	413.42	413.46	1300.0
2023-05-25 04:50:00	SPY	ETF	413.6	413.65	413.6	413.65	700.0
2023-05-25 04:55:00	SPY	ETF	413.63	413.63	413.63	413.63	800.0
2023-05-25 05:00:00	SPY	ETF	413.8	413.9	413.77	413.82	3416.0
2023-05-25 05:05:00	SPY	ETF	413.75	413.95	413.72	413.92	4984.0
2023-05-25 05:10:00	SPY	ETF	413.75	413.75	413.69	413.69	600.0
2023-05-25 05:15:00	SPY	ETF	413.74	413.9	413.74	413.9	710.0
2023-05-25 05:20:00	SPY	ETF	413.89	413.91	413.89	413.9	1435.0
2023-05-25 05:25:00	SPY	ETF	413.85	413.85	413.83	413.83	500.0
2023-05-25 05:30:00	SPY	ETF	413.98	414.06	413.98	413.98	6089.0
2023-05-25 05:35:00	SPY	ETF	414.07	414.07	413.93	413.93	3935.0
2023-05-25 05:40:00	SPY	ETF	413.86	414.01	413.84	414.01	2479.0
2023-05-25 05:45:00	SPY	ETF	414.0	414.1	413.99	414.07	4200.0
2023-05-25 05:50:00	SPY	ETF	414.13	414.25	414.13	414.25	63470.0
2023-05-25 05:55:00	SPY	ETF	414.24	414.27	414.1	414.17	45049.0
2023-05-25 06:00:00	SPY	ETF	414.17	414.17	414.0	414.03	3482.0
2023-05-25 06:05:00	SPY	ETF	414.0	414.11	414.0	414.11	3434.0
2023-05-25 06:10:00	SPY	ETF	414.08	414.17	414.08	414.17	2330.0
2023-05-25 06:15:00	SPY	ETF	414.16	414.21	414.13	414.18	1325.0
2023-05-25 06:20:00	SPY	ETF	414.15	414.15	414.15	414.15	413.0
2023-05-25 06:25:00	SPY	ETF	414.21	414.27	414.11	414.15	13374.0
2023-05-25 06:30:00	SPY	ETF	414.12	414.23	414.11	414.13	11263.0
2023-05-25 06:35:00	SPY	ETF	414.14	414.15	414.05	414.06	13013.0
2023-05-25 06:40:00	SPY	ETF	414.05	414.09	413.88	414.03	36074.0
2023-05-25 06:45:00	SPY	ETF	414.05	414.06	413.76	413.76	8400.0
2023-05-25 06:50:00	SPY	ETF	413.79	413.82	413.73	413.75	7272.0
2023-05-25 06:55:00	SPY	ETF	413.76	413.76	413.6	413.6	1575.0
2023-05-25 07:00:00	SPY	ETF	413.56	413.68	413.54	413.54	67031.0
2023-05-25 07:05:00	SPY	ETF	413.5	413.69	413.45	413.69	24141.0
2023-05-25 07:10:00	SPY	ETF	413.69	413.7	413.47	413.53	17199.0
2023-05-25 07:15:00	SPY	ETF	413.55	413.7	413.55	413.7	19256.0
2023-05-25 07:20:00	SPY	ETF	413.68	413.741	413.59	413.72	21435.0
2023-05-25 07:25:00	SPY	ETF	413.7	413.76	413.59	413.59	12112.0
2023-05-25 07:30:00	SPY	ETF	413.59	413.72	413.43	413.43	16503.0
2023-05-25 07:35:00	SPY	ETF	413.42	413.56	413.24	413.42	46761.0
2023-05-25 07:40:00	SPY	ETF	413.53	413.63	413.42	413.63	7636.0
2023-05-25 07:45:00	SPY	ETF	413.63	413.7	413.58	413.7	21490.0
2023-05-25 07:50:00	SPY	ETF	413.7	413.77	413.54	413.6	14660.0
2023-05-25 07:55:00	SPY	ETF	413.67	413.96	413.67	413.95	18358.0
2023-05-25 08:00:00	SPY	ETF	413.55	414.2696	412.28	414.09	56574.0
2023-05-25 08:05:00	SPY	ETF	414.12	414.18	413.98	414.05	32965.0

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

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