PREVIEW / etf_1min / 2024-04-19

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-04-19.parquet
  size:    5.3 MB
  rows:    305,675

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-04-19 04:00:00	SPY	ETF	497.0	497.49	494.97	497.39	12218.0
2024-04-19 04:01:00	SPY	ETF	497.53	497.54	497.48	497.54	2380.0
2024-04-19 04:02:00	SPY	ETF	497.43	497.45	497.29	497.3	4298.0
2024-04-19 04:03:00	SPY	ETF	497.3	497.3	497.22	497.3	956.0
2024-04-19 04:04:00	SPY	ETF	497.39	497.44	497.39	497.44	660.0
2024-04-19 04:05:00	SPY	ETF	497.42	497.49	497.35	497.49	3377.0
2024-04-19 04:06:00	SPY	ETF	497.43	497.43	497.34	497.38	819.0
2024-04-19 04:07:00	SPY	ETF	497.3	497.3	496.97	497.03	2740.0
2024-04-19 04:08:00	SPY	ETF	497.01	497.05	496.92	497.05	3128.0
2024-04-19 04:09:00	SPY	ETF	497.06	497.3	497.06	497.3	1179.0
2024-04-19 04:11:00	SPY	ETF	497.06	497.06	496.88	496.88	5315.0
2024-04-19 04:12:00	SPY	ETF	497.01	497.01	496.73	496.73	1041.0
2024-04-19 04:13:00	SPY	ETF	496.91	496.91	496.76	496.76	782.0
2024-04-19 04:14:00	SPY	ETF	496.76	496.94	496.68	496.94	499.0
2024-04-19 04:15:00	SPY	ETF	496.97	497.1	496.97	497.1	750.0
2024-04-19 04:16:00	SPY	ETF	497.18	497.23	497.18	497.23	343.0
2024-04-19 04:17:00	SPY	ETF	497.14	497.27	497.14	497.27	1824.0
2024-04-19 04:18:00	SPY	ETF	497.53	497.53	497.49	497.49	203.0
2024-04-19 04:19:00	SPY	ETF	497.63	497.78	497.63	497.73	2631.0
2024-04-19 04:20:00	SPY	ETF	497.74	497.74	497.59	497.6	500.0
2024-04-19 04:21:00	SPY	ETF	497.45	497.54	497.45	497.5	323.0
2024-04-19 04:22:00	SPY	ETF	497.63	497.63	497.63	497.63	100.0
2024-04-19 04:23:00	SPY	ETF	497.46	497.47	497.46	497.47	350.0
2024-04-19 04:24:00	SPY	ETF	497.5	497.5	497.5	497.5	300.0
2024-04-19 04:25:00	SPY	ETF	497.65	497.66	497.65	497.66	300.0
2024-04-19 04:26:00	SPY	ETF	497.74	497.88	497.74	497.88	1891.0
2024-04-19 04:27:00	SPY	ETF	497.84	497.84	497.79	497.79	292.0
2024-04-19 04:28:00	SPY	ETF	497.76	497.76	497.75	497.75	1100.0
2024-04-19 04:29:00	SPY	ETF	497.75	497.75	497.62	497.62	3100.0
2024-04-19 04:31:00	SPY	ETF	497.65	497.65	497.36	497.36	1900.0
2024-04-19 04:33:00	SPY	ETF	497.37	497.37	497.3	497.3	200.0
2024-04-19 04:34:00	SPY	ETF	497.25	497.29	497.25	497.29	667.0
2024-04-19 04:35:00	SPY	ETF	497.07	497.07	497.07	497.07	155.0
2024-04-19 04:36:00	SPY	ETF	497.04	497.04	497.04	497.04	600.0
2024-04-19 04:38:00	SPY	ETF	497.15	497.15	497.15	497.15	201.0
2024-04-19 04:39:00	SPY	ETF	497.18	497.2	497.18	497.2	2400.0
2024-04-19 04:40:00	SPY	ETF	497.12	497.12	497.12	497.12	300.0
2024-04-19 04:41:00	SPY	ETF	497.07	497.07	496.89	496.89	2000.0
2024-04-19 04:43:00	SPY	ETF	496.77	496.77	496.77	496.77	1000.0
2024-04-19 04:45:00	SPY	ETF	497.0	497.0	497.0	497.0	349.0
2024-04-19 04:46:00	SPY	ETF	496.97	496.97	496.97	496.97	100.0
2024-04-19 04:48:00	SPY	ETF	496.9	496.9	496.9	496.9	100.0
2024-04-19 04:49:00	SPY	ETF	497.04	497.08	497.04	497.08	3550.0
2024-04-19 04:50:00	SPY	ETF	497.15	497.25	497.15	497.25	2300.0
2024-04-19 04:51:00	SPY	ETF	497.26	497.3	497.26	497.3	901.0
2024-04-19 04:54:00	SPY	ETF	497.19	497.19	497.19	497.19	142.0
2024-04-19 04:57:00	SPY	ETF	497.19	497.19	497.19	497.19	158.0
2024-04-19 05:00:00	SPY	ETF	497.11	497.11	497.11	497.11	131.0
2024-04-19 05:02:00	SPY	ETF	497.5	497.59	497.5	497.59	425.0
2024-04-19 05:03:00	SPY	ETF	497.62	497.62	497.62	497.62	100.0

> showing 50 of 305,675 rows — these rows as CSV

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