PREVIEW / etf_5min / 2024-08-01

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-08-01.parquet
  size:    2.4 MB
  rows:    122,557

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
2024-08-01 04:00:00	SPY	ETF	552.26	552.35	551.97	552.14	6435.0
2024-08-01 04:05:00	SPY	ETF	552.0	552.06	551.5	551.61	5394.0
2024-08-01 04:10:00	SPY	ETF	551.4	551.4	550.69	551.08	7525.0
2024-08-01 04:15:00	SPY	ETF	550.99	551.51	550.95	551.2	5086.0
2024-08-01 04:20:00	SPY	ETF	551.0	551.2	550.73	551.2	4177.0
2024-08-01 04:25:00	SPY	ETF	550.99	551.32	550.9	551.32	3127.0
2024-08-01 04:30:00	SPY	ETF	551.26	551.62	551.03	551.62	2465.0
2024-08-01 04:35:00	SPY	ETF	551.26	551.32	550.99	551.07	3777.0
2024-08-01 04:40:00	SPY	ETF	551.01	551.16	550.67	551.16	3144.0
2024-08-01 04:45:00	SPY	ETF	551.08	551.13	551.04	551.04	436.0
2024-08-01 04:50:00	SPY	ETF	551.33	551.33	550.99	550.99	6725.0
2024-08-01 04:55:00	SPY	ETF	550.9	551.09	550.9	551.09	1248.0
2024-08-01 05:00:00	SPY	ETF	551.07	551.28	551.0	551.28	772.0
2024-08-01 05:10:00	SPY	ETF	551.5	551.5	551.5	551.5	477.0
2024-08-01 05:15:00	SPY	ETF	552.04	552.07	551.78	551.93	2834.0
2024-08-01 05:20:00	SPY	ETF	551.83	551.83	551.8	551.8	414.0
2024-08-01 05:25:00	SPY	ETF	551.55	551.74	551.53	551.63	17948.0
2024-08-01 05:30:00	SPY	ETF	551.6	551.9	551.56	551.9	10580.0
2024-08-01 05:35:00	SPY	ETF	552.07	552.31	552.07	552.31	25276.0
2024-08-01 05:40:00	SPY	ETF	552.3	552.34	552.28	552.34	85511.0
2024-08-01 05:45:00	SPY	ETF	552.32	552.37	552.32	552.37	1499.0
2024-08-01 05:50:00	SPY	ETF	552.44	552.53	552.43	552.53	5210.0
2024-08-01 05:55:00	SPY	ETF	552.35	552.46	552.35	552.46	1400.0
2024-08-01 06:00:00	SPY	ETF	552.66	552.66	552.49	552.49	1000.0
2024-08-01 06:05:00	SPY	ETF	552.4	552.51	552.4	552.51	1248.0
2024-08-01 06:10:00	SPY	ETF	552.34	552.53	552.34	552.37	1551.0
2024-08-01 06:15:00	SPY	ETF	552.51	552.54	552.51	552.54	800.0
2024-08-01 06:20:00	SPY	ETF	552.48	552.63	552.47	552.5	2100.0
2024-08-01 06:25:00	SPY	ETF	552.54	552.73	552.54	552.69	1250.0
2024-08-01 06:30:00	SPY	ETF	552.64	552.65	552.54	552.54	7692.0
2024-08-01 06:35:00	SPY	ETF	552.42	552.42	552.25	552.4	5337.0
2024-08-01 06:40:00	SPY	ETF	552.47	552.48	552.29	552.48	2400.0
2024-08-01 06:45:00	SPY	ETF	552.73	552.73	552.73	552.73	977.0
2024-08-01 06:50:00	SPY	ETF	552.74	552.75	552.63	552.67	2950.0
2024-08-01 06:55:00	SPY	ETF	552.81	552.82	552.81	552.82	550.0
2024-08-01 07:00:00	SPY	ETF	552.82	553.04	552.73	552.97	42015.0
2024-08-01 07:05:00	SPY	ETF	552.96	553.16	552.96	553.01	4051.0
2024-08-01 07:10:00	SPY	ETF	553.02	553.02	552.9	552.99	5985.0
2024-08-01 07:15:00	SPY	ETF	553.08	553.18	553.07	553.15	2580.0
2024-08-01 07:20:00	SPY	ETF	553.21	553.25	552.94	553.09	30657.0
2024-08-01 07:25:00	SPY	ETF	553.2	553.33	553.19	553.33	5119.0
2024-08-01 07:30:00	SPY	ETF	553.31	553.33	553.15	553.33	7135.0
2024-08-01 07:35:00	SPY	ETF	553.3	553.3	553.24	553.24	1025.0
2024-08-01 07:40:00	SPY	ETF	553.24	553.48	553.24	553.34	49795.0
2024-08-01 07:45:00	SPY	ETF	553.38	553.39	553.08	553.08	4910.0
2024-08-01 07:50:00	SPY	ETF	553.02	553.03	552.8	553.02	9371.0
2024-08-01 07:55:00	SPY	ETF	552.93	552.93	552.4	552.47	61561.0
2024-08-01 08:00:00	SPY	ETF	552.87	554.01	551.0496	552.83	57619.0
2024-08-01 08:05:00	SPY	ETF	552.8	552.95	552.75	552.92	18543.0
2024-08-01 08:10:00	SPY	ETF	552.9099	552.9099	552.71	552.77	18849.0

> showing 50 of 122,557 rows — these rows as CSV

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