PREVIEW / etf_1min / 2024-07-17

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-17.parquet
  size:    5.5 MB
  rows:    319,176

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-07-17 04:00:00	SPY	ETF	562.5	562.5	561.09	561.12	4670.0
2024-07-17 04:01:00	SPY	ETF	561.1	561.11	561.01	561.01	7188.0
2024-07-17 04:02:00	SPY	ETF	561.02	561.02	561.02	561.02	100.0
2024-07-17 04:03:00	SPY	ETF	561.18	561.18	561.14	561.14	5400.0
2024-07-17 04:04:00	SPY	ETF	561.25	561.33	561.2	561.32	3950.0
2024-07-17 04:06:00	SPY	ETF	561.14	561.14	561.0	561.0	755.0
2024-07-17 04:07:00	SPY	ETF	561.0	561.0	560.98	560.98	573.0
2024-07-17 04:08:00	SPY	ETF	560.93	560.93	560.86	560.86	200.0
2024-07-17 04:09:00	SPY	ETF	560.91	560.91	560.85	560.88	430.0
2024-07-17 04:10:00	SPY	ETF	560.98	560.98	560.98	560.98	100.0
2024-07-17 04:11:00	SPY	ETF	560.84	560.84	560.84	560.84	100.0
2024-07-17 04:12:00	SPY	ETF	560.9	560.9	560.9	560.9	400.0
2024-07-17 04:13:00	SPY	ETF	560.79	560.8	560.57	560.57	1495.0
2024-07-17 04:14:00	SPY	ETF	560.37	560.37	560.37	560.37	100.0
2024-07-17 04:15:00	SPY	ETF	560.53	560.53	560.32	560.32	1352.0
2024-07-17 04:16:00	SPY	ETF	560.32	560.38	560.32	560.38	931.0
2024-07-17 04:17:00	SPY	ETF	560.35	560.35	560.29	560.33	682.0
2024-07-17 04:18:00	SPY	ETF	560.3	560.3	560.3	560.3	100.0
2024-07-17 04:19:00	SPY	ETF	560.41	560.41	560.36	560.36	230.0
2024-07-17 04:21:00	SPY	ETF	560.25	560.33	560.25	560.33	300.0
2024-07-17 04:22:00	SPY	ETF	560.36	560.36	560.32	560.32	350.0
2024-07-17 04:23:00	SPY	ETF	560.32	560.32	560.24	560.24	284.0
2024-07-17 04:24:00	SPY	ETF	560.16	560.16	560.13	560.13	572.0
2024-07-17 04:25:00	SPY	ETF	560.17	560.23	560.17	560.23	245.0
2024-07-17 04:27:00	SPY	ETF	560.15	560.22	560.15	560.22	3728.0
2024-07-17 04:28:00	SPY	ETF	560.24	560.36	560.23	560.36	5100.0
2024-07-17 04:29:00	SPY	ETF	560.3	560.3	560.27	560.27	295.0
2024-07-17 04:30:00	SPY	ETF	560.4	560.49	560.4	560.49	415.0
2024-07-17 04:31:00	SPY	ETF	560.44	560.44	560.44	560.44	200.0
2024-07-17 04:32:00	SPY	ETF	560.41	560.41	560.41	560.41	150.0
2024-07-17 04:33:00	SPY	ETF	560.42	560.47	560.42	560.47	276.0
2024-07-17 04:34:00	SPY	ETF	560.44	560.52	560.44	560.5	4654.0
2024-07-17 04:35:00	SPY	ETF	560.47	560.6	560.45	560.45	623.0
2024-07-17 04:36:00	SPY	ETF	560.41	560.41	560.41	560.41	1200.0
2024-07-17 04:37:00	SPY	ETF	560.47	560.47	560.47	560.47	200.0
2024-07-17 04:38:00	SPY	ETF	560.45	560.49	560.45	560.49	4998.0
2024-07-17 04:39:00	SPY	ETF	560.44	560.44	560.37	560.37	1395.0
2024-07-17 04:40:00	SPY	ETF	560.36	560.36	560.36	560.36	103.0
2024-07-17 04:41:00	SPY	ETF	560.36	560.38	560.36	560.38	400.0
2024-07-17 04:42:00	SPY	ETF	560.37	560.37	560.3	560.3	248.0
2024-07-17 04:45:00	SPY	ETF	560.33	560.33	560.33	560.33	200.0
2024-07-17 04:47:00	SPY	ETF	560.54	560.54	560.54	560.54	100.0
2024-07-17 04:48:00	SPY	ETF	560.5	560.5	560.5	560.5	163.0
2024-07-17 04:49:00	SPY	ETF	560.62	560.62	560.62	560.62	300.0
2024-07-17 04:50:00	SPY	ETF	560.77	560.77	560.77	560.77	100.0
2024-07-17 04:51:00	SPY	ETF	560.84	560.84	560.77	560.77	300.0
2024-07-17 04:52:00	SPY	ETF	560.87	560.9	560.87	560.9	300.0
2024-07-17 04:53:00	SPY	ETF	560.86	560.86	560.86	560.86	500.0
2024-07-17 04:54:00	SPY	ETF	560.88	560.88	560.88	560.88	100.0
2024-07-17 04:56:00	SPY	ETF	560.78	560.78	560.75	560.75	200.0

> showing 50 of 319,176 rows — these rows as CSV

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