PREVIEW / etf_5min / 2024-06-20

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-06-20.parquet
  size:    2.3 MB
  rows:    116,520

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-06-20 04:00:00	SPY	ETF	550.12	550.49	549.52	550.36	4661.0
2024-06-20 04:05:00	SPY	ETF	550.53	550.54	550.45	550.45	1513.0
2024-06-20 04:10:00	SPY	ETF	550.53	550.54	550.37	550.38	3171.0
2024-06-20 04:15:00	SPY	ETF	550.48	550.48	550.36	550.36	817.0
2024-06-20 04:20:00	SPY	ETF	550.53	550.53	550.37	550.37	900.0
2024-06-20 04:25:00	SPY	ETF	550.39	550.44	550.35	550.44	521.0
2024-06-20 04:30:00	SPY	ETF	550.33	550.33	550.2	550.24	1139.0
2024-06-20 04:35:00	SPY	ETF	550.24	550.29	550.24	550.27	1742.0
2024-06-20 04:40:00	SPY	ETF	550.29	550.29	550.28	550.28	421.0
2024-06-20 04:50:00	SPY	ETF	550.49	550.49	550.49	550.49	297.0
2024-06-20 04:55:00	SPY	ETF	550.53	550.53	550.51	550.51	406.0
2024-06-20 05:00:00	SPY	ETF	550.51	550.57	550.5	550.57	600.0
2024-06-20 05:05:00	SPY	ETF	550.51	550.51	550.51	550.51	200.0
2024-06-20 05:15:00	SPY	ETF	550.36	550.36	550.35	550.35	200.0
2024-06-20 05:20:00	SPY	ETF	550.35	550.45	550.34	550.45	2101.0
2024-06-20 05:25:00	SPY	ETF	550.51	550.54	550.51	550.54	257.0
2024-06-20 05:30:00	SPY	ETF	550.51	550.51	550.42	550.45	399.0
2024-06-20 05:35:00	SPY	ETF	550.41	550.41	550.41	550.41	400.0
2024-06-20 05:40:00	SPY	ETF	550.32	550.38	550.32	550.38	1491.0
2024-06-20 05:50:00	SPY	ETF	550.5	550.59	550.5	550.59	3083.0
2024-06-20 06:05:00	SPY	ETF	550.41	550.41	550.41	550.41	300.0
2024-06-20 06:10:00	SPY	ETF	550.44	550.53	550.44	550.53	200.0
2024-06-20 06:15:00	SPY	ETF	550.59	550.59	550.56	550.56	363.0
2024-06-20 06:20:00	SPY	ETF	550.61	550.61	550.61	550.61	149.0
2024-06-20 06:25:00	SPY	ETF	550.71	550.71	550.69	550.69	220.0
2024-06-20 06:30:00	SPY	ETF	550.62	550.62	550.62	550.62	400.0
2024-06-20 06:35:00	SPY	ETF	550.68	550.73	550.68	550.73	200.0
2024-06-20 06:40:00	SPY	ETF	550.63	550.72	550.58	550.72	1220.0
2024-06-20 06:45:00	SPY	ETF	550.71	550.71	550.61	550.61	700.0
2024-06-20 06:55:00	SPY	ETF	550.6	550.6	550.6	550.6	300.0
2024-06-20 07:00:00	SPY	ETF	550.43	550.6	550.4	550.6	6031.0
2024-06-20 07:05:00	SPY	ETF	550.65	550.77	550.65	550.68	5249.0
2024-06-20 07:10:00	SPY	ETF	550.6	550.6	550.5	550.5	25230.0
2024-06-20 07:15:00	SPY	ETF	550.531	550.531	550.51	550.52	13132.0
2024-06-20 07:20:00	SPY	ETF	550.49	550.53	550.44	550.44	1794.0
2024-06-20 07:25:00	SPY	ETF	550.48	550.58	550.48	550.55	10064.0
2024-06-20 07:30:00	SPY	ETF	550.54	550.58	550.52	550.58	423.0
2024-06-20 07:35:00	SPY	ETF	550.56	550.56	550.39	550.4	1262.0
2024-06-20 07:40:00	SPY	ETF	550.43	550.43	550.39	550.42	2042.0
2024-06-20 07:45:00	SPY	ETF	550.41	550.41	550.27	550.33	7261.0
2024-06-20 07:50:00	SPY	ETF	550.31	550.31	550.16	550.19	3708.0
2024-06-20 07:55:00	SPY	ETF	550.3	550.35	550.261	550.261	1500.0
2024-06-20 08:00:00	SPY	ETF	550.69	551.12	549.59	550.42	37103.0
2024-06-20 08:05:00	SPY	ETF	550.4	550.4	550.18	550.18	5969.0
2024-06-20 08:10:00	SPY	ETF	550.15	550.15	549.92	550.0	24621.0
2024-06-20 08:15:00	SPY	ETF	549.96	550.17	549.96	550.17	13347.0
2024-06-20 08:20:00	SPY	ETF	550.17	550.2	550.13	550.13	1830.0
2024-06-20 08:25:00	SPY	ETF	550.17	550.32	550.16	550.3	10168.0
2024-06-20 08:30:00	SPY	ETF	550.39	550.5	549.78	549.84	18925.0
2024-06-20 08:35:00	SPY	ETF	549.8318	549.98	549.68	549.73	25653.0

> showing 50 of 116,520 rows — these rows as CSV

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