PREVIEW / etf_1min / 2024-06-17

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-06-17.parquet
  size:    5.2 MB
  rows:    287,486

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-17 04:00:00	SPY	ETF	542.55	542.95	542.55	542.93	1297.0
2024-06-17 04:01:00	SPY	ETF	543.16	543.16	543.16	543.16	200.0
2024-06-17 04:02:00	SPY	ETF	542.97	542.97	542.97	542.97	100.0
2024-06-17 04:03:00	SPY	ETF	543.07	543.07	543.07	543.07	269.0
2024-06-17 04:04:00	SPY	ETF	543.04	543.04	543.04	543.04	121.0
2024-06-17 04:05:00	SPY	ETF	542.89	542.89	542.89	542.89	140.0
2024-06-17 04:07:00	SPY	ETF	543.07	543.07	543.07	543.07	100.0
2024-06-17 04:09:00	SPY	ETF	543.23	543.27	543.22	543.23	1425.0
2024-06-17 04:11:00	SPY	ETF	543.26	543.28	543.24	543.25	1760.0
2024-06-17 04:12:00	SPY	ETF	543.22	543.26	543.22	543.26	500.0
2024-06-17 04:13:00	SPY	ETF	543.37	543.4	543.35	543.35	1100.0
2024-06-17 04:14:00	SPY	ETF	543.37	543.37	543.35	543.37	701.0
2024-06-17 04:15:00	SPY	ETF	543.33	543.33	543.28	543.3	2046.0
2024-06-17 04:16:00	SPY	ETF	543.36	543.36	543.36	543.36	999.0
2024-06-17 04:21:00	SPY	ETF	543.35	543.35	543.35	543.35	100.0
2024-06-17 04:22:00	SPY	ETF	543.2	543.2	543.2	543.2	139.0
2024-06-17 04:25:00	SPY	ETF	543.15	543.15	543.15	543.15	209.0
2024-06-17 04:26:00	SPY	ETF	543.13	543.13	543.13	543.13	121.0
2024-06-17 04:27:00	SPY	ETF	543.01	543.01	543.01	543.01	353.0
2024-06-17 04:29:00	SPY	ETF	542.94	542.94	542.93	542.93	600.0
2024-06-17 04:30:00	SPY	ETF	542.87	542.87	542.82	542.82	200.0
2024-06-17 04:32:00	SPY	ETF	542.74	542.74	542.65	542.65	340.0
2024-06-17 04:35:00	SPY	ETF	542.5	542.5	542.5	542.5	100.0
2024-06-17 04:39:00	SPY	ETF	542.39	542.39	542.38	542.38	200.0
2024-06-17 04:42:00	SPY	ETF	542.33	542.33	542.33	542.33	100.0
2024-06-17 04:45:00	SPY	ETF	542.34	542.34	542.34	542.34	175.0
2024-06-17 04:54:00	SPY	ETF	542.4	542.4	542.39	542.4	1200.0
2024-06-17 04:57:00	SPY	ETF	542.42	542.42	542.42	542.42	100.0
2024-06-17 05:00:00	SPY	ETF	542.43	542.43	542.43	542.43	6393.0
2024-06-17 05:01:00	SPY	ETF	542.43	542.43	542.43	542.43	2099.0
2024-06-17 05:02:00	SPY	ETF	542.38	542.38	542.38	542.38	1200.0
2024-06-17 05:04:00	SPY	ETF	542.48	542.48	542.48	542.48	139.0
2024-06-17 05:05:00	SPY	ETF	542.63	542.63	542.63	542.63	100.0
2024-06-17 05:07:00	SPY	ETF	542.44	542.44	542.44	542.44	300.0
2024-06-17 05:13:00	SPY	ETF	542.47	542.47	542.47	542.47	200.0
2024-06-17 05:15:00	SPY	ETF	542.47	542.47	542.42	542.43	3089.0
2024-06-17 05:17:00	SPY	ETF	542.42	542.42	542.39	542.39	600.0
2024-06-17 05:20:00	SPY	ETF	542.39	542.39	542.39	542.39	184.0
2024-06-17 05:22:00	SPY	ETF	542.4	542.4	542.4	542.4	615.0
2024-06-17 05:29:00	SPY	ETF	542.54	542.54	542.54	542.54	350.0
2024-06-17 05:50:00	SPY	ETF	542.57	542.57	542.57	542.57	206.0
2024-06-17 05:51:00	SPY	ETF	542.55	542.55	542.55	542.55	499.0
2024-06-17 05:58:00	SPY	ETF	542.57	542.57	542.57	542.57	100.0
2024-06-17 06:04:00	SPY	ETF	542.41	542.41	542.41	542.41	104.0
2024-06-17 06:05:00	SPY	ETF	542.26	542.26	542.2	542.2	771.0
2024-06-17 06:06:00	SPY	ETF	542.19	542.19	542.19	542.19	1600.0
2024-06-17 06:09:00	SPY	ETF	542.2	542.2	542.2	542.2	100.0
2024-06-17 06:10:00	SPY	ETF	542.17	542.17	542.16	542.16	700.0
2024-06-17 06:18:00	SPY	ETF	542.11	542.11	542.11	542.11	300.0
2024-06-17 06:19:00	SPY	ETF	542.0	542.0	542.0	542.0	4500.0

> showing 50 of 287,486 rows — these rows as CSV

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