PREVIEW / etf_5min / 2024-06-28

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-06-28.parquet
  size:    2.2 MB
  rows:    109,909

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-28 04:00:00	SPY	ETF	547.78	547.79	547.74	547.75	1727.0
2024-06-28 04:05:00	SPY	ETF	547.66	547.66	547.64	547.65	2300.0
2024-06-28 04:10:00	SPY	ETF	547.6	547.72	547.6	547.65	1832.0
2024-06-28 04:15:00	SPY	ETF	547.65	547.69	547.65	547.69	1243.0
2024-06-28 04:20:00	SPY	ETF	547.73	547.82	547.73	547.82	242.0
2024-06-28 04:25:00	SPY	ETF	547.99	547.99	547.98	547.98	1648.0
2024-06-28 04:30:00	SPY	ETF	548.06	548.06	547.95	547.98	400.0
2024-06-28 04:35:00	SPY	ETF	547.98	547.98	547.98	547.98	400.0
2024-06-28 04:45:00	SPY	ETF	548.05	548.1	547.99	547.99	1148.0
2024-06-28 04:50:00	SPY	ETF	548.02	548.02	548.02	548.02	100.0
2024-06-28 04:55:00	SPY	ETF	548.14	548.19	548.09	548.19	332.0
2024-06-28 05:00:00	SPY	ETF	548.12	548.26	548.11	548.26	2000.0
2024-06-28 05:05:00	SPY	ETF	548.3	548.3	548.23	548.23	300.0
2024-06-28 05:10:00	SPY	ETF	548.24	548.24	548.22	548.22	336.0
2024-06-28 05:15:00	SPY	ETF	548.28	548.28	548.25	548.25	1000.0
2024-06-28 05:20:00	SPY	ETF	548.4	548.4	548.34	548.34	2500.0
2024-06-28 05:25:00	SPY	ETF	548.38	548.38	548.38	548.38	6000.0
2024-06-28 05:30:00	SPY	ETF	548.44	548.44	548.34	548.34	820.0
2024-06-28 05:35:00	SPY	ETF	548.3	548.47	548.3	548.46	525.0
2024-06-28 05:40:00	SPY	ETF	548.51	548.57	548.48	548.56	2432.0
2024-06-28 05:45:00	SPY	ETF	548.56	548.57	548.5	548.53	4302.0
2024-06-28 05:55:00	SPY	ETF	548.48	548.49	548.48	548.49	5000.0
2024-06-28 06:00:00	SPY	ETF	548.39	548.47	548.38	548.47	2314.0
2024-06-28 06:05:00	SPY	ETF	548.43	548.46	548.39	548.39	28050.0
2024-06-28 06:10:00	SPY	ETF	548.32	548.32	548.31	548.31	1456.0
2024-06-28 06:15:00	SPY	ETF	548.36	548.36	548.27	548.27	200.0
2024-06-28 06:20:00	SPY	ETF	548.24	548.36	548.24	548.36	1122.0
2024-06-28 06:25:00	SPY	ETF	548.37	548.43	548.34	548.38	1236.0
2024-06-28 06:30:00	SPY	ETF	548.43	548.43	548.42	548.43	9400.0
2024-06-28 06:35:00	SPY	ETF	548.43	548.43	548.43	548.43	200.0
2024-06-28 06:40:00	SPY	ETF	548.43	548.48	548.43	548.43	3783.0
2024-06-28 06:45:00	SPY	ETF	548.43	548.44	548.43	548.44	587.0
2024-06-28 06:50:00	SPY	ETF	548.45	548.45	548.45	548.45	500.0
2024-06-28 07:00:00	SPY	ETF	548.45	548.47	548.02	548.46	138320.0
2024-06-28 07:05:00	SPY	ETF	548.48	548.48	548.32	548.35	3988.0
2024-06-28 07:10:00	SPY	ETF	548.37	548.41	548.37	548.41	5376.0
2024-06-28 07:15:00	SPY	ETF	548.4	548.44	548.38	548.38	5340.0
2024-06-28 07:20:00	SPY	ETF	548.41	548.41	548.29	548.34	5374.0
2024-06-28 07:25:00	SPY	ETF	548.34	548.34	548.27	548.27	11389.0
2024-06-28 07:30:00	SPY	ETF	548.3	548.41	548.26	548.38	11740.0
2024-06-28 07:35:00	SPY	ETF	548.38	548.45	548.34	548.37	6569.0
2024-06-28 07:40:00	SPY	ETF	548.4	548.43	548.35	548.35	7000.0
2024-06-28 07:45:00	SPY	ETF	548.36	548.37	548.36	548.37	3395.0
2024-06-28 07:50:00	SPY	ETF	548.36	548.36	548.31	548.31	5894.0
2024-06-28 07:55:00	SPY	ETF	548.3	548.34	548.28	548.31	3800.0
2024-06-28 08:00:00	SPY	ETF	548.35	548.47	547.51	548.25	25025.0
2024-06-28 08:05:00	SPY	ETF	548.4	548.4	548.21	548.22	35350.0
2024-06-28 08:10:00	SPY	ETF	548.26	548.4	548.21	548.4	8728.0
2024-06-28 08:15:00	SPY	ETF	548.41	548.63	548.41	548.63	19488.0
2024-06-28 08:20:00	SPY	ETF	548.63	548.65	548.45	548.49	37423.0

> showing 50 of 109,909 rows — these rows as CSV

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