PREVIEW / etf_1min / 2024-03-19

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-03-19.parquet
  size:    5.1 MB
  rows:    291,578

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-03-19 04:00:00	SPY	ETF	512.45	512.45	512.33	512.33	1400.0
2024-03-19 04:01:00	SPY	ETF	512.39	512.49	512.39	512.49	301.0
2024-03-19 04:02:00	SPY	ETF	512.53	512.53	512.52	512.52	400.0
2024-03-19 04:05:00	SPY	ETF	512.57	512.57	512.47	512.48	651.0
2024-03-19 04:06:00	SPY	ETF	512.42	512.42	512.11	512.11	400.0
2024-03-19 04:07:00	SPY	ETF	512.12	512.14	512.11	512.14	2600.0
2024-03-19 04:08:00	SPY	ETF	512.12	512.19	512.11	512.19	1388.0
2024-03-19 04:09:00	SPY	ETF	512.14	512.14	512.14	512.14	100.0
2024-03-19 04:10:00	SPY	ETF	512.2	512.2	512.2	512.2	100.0
2024-03-19 04:11:00	SPY	ETF	512.31	512.31	512.31	512.31	200.0
2024-03-19 04:13:00	SPY	ETF	512.16	512.16	512.12	512.12	370.0
2024-03-19 04:15:00	SPY	ETF	512.18	512.18	512.18	512.18	100.0
2024-03-19 04:20:00	SPY	ETF	512.11	512.11	512.11	512.11	200.0
2024-03-19 04:24:00	SPY	ETF	512.43	512.43	512.43	512.43	300.0
2024-03-19 04:25:00	SPY	ETF	512.44	512.44	512.44	512.44	600.0
2024-03-19 04:27:00	SPY	ETF	512.4	512.4	512.4	512.4	100.0
2024-03-19 04:29:00	SPY	ETF	512.49	512.5	512.49	512.5	400.0
2024-03-19 04:30:00	SPY	ETF	512.57	512.57	512.57	512.57	125.0
2024-03-19 04:32:00	SPY	ETF	512.46	512.47	512.46	512.47	900.0
2024-03-19 04:34:00	SPY	ETF	512.54	512.54	512.54	512.54	500.0
2024-03-19 04:36:00	SPY	ETF	512.58	512.58	512.58	512.58	100.0
2024-03-19 04:38:00	SPY	ETF	512.59	512.59	512.59	512.59	142.0
2024-03-19 04:40:00	SPY	ETF	512.73	512.84	512.73	512.84	1368.0
2024-03-19 04:41:00	SPY	ETF	512.8	512.8	512.8	512.8	600.0
2024-03-19 04:42:00	SPY	ETF	512.9	512.94	512.87	512.94	931.0
2024-03-19 04:44:00	SPY	ETF	513.04	513.04	513.03	513.03	840.0
2024-03-19 04:45:00	SPY	ETF	513.11	513.12	513.11	513.12	685.0
2024-03-19 04:47:00	SPY	ETF	513.0	513.0	512.98	512.98	341.0
2024-03-19 04:51:00	SPY	ETF	513.21	513.39	513.21	513.39	400.0
2024-03-19 04:54:00	SPY	ETF	513.36	513.45	513.34	513.45	2305.0
2024-03-19 04:55:00	SPY	ETF	513.39	513.39	513.39	513.39	800.0
2024-03-19 04:56:00	SPY	ETF	513.21	513.21	513.17	513.17	1972.0
2024-03-19 04:57:00	SPY	ETF	513.15	513.16	513.15	513.16	1175.0
2024-03-19 04:58:00	SPY	ETF	513.1	513.1	513.1	513.1	375.0
2024-03-19 04:59:00	SPY	ETF	512.85	512.85	512.85	512.85	184.0
2024-03-19 05:00:00	SPY	ETF	512.95	512.95	512.95	512.95	100.0
2024-03-19 05:02:00	SPY	ETF	512.92	512.96	512.92	512.96	1100.0
2024-03-19 05:03:00	SPY	ETF	513.04	513.06	513.04	513.06	962.0
2024-03-19 05:05:00	SPY	ETF	512.75	512.75	512.7	512.7	500.0
2024-03-19 05:06:00	SPY	ETF	512.46	512.47	512.4	512.47	2035.0
2024-03-19 05:07:00	SPY	ETF	512.48	512.48	512.46	512.46	475.0
2024-03-19 05:09:00	SPY	ETF	512.54	512.54	512.54	512.54	1099.0
2024-03-19 05:10:00	SPY	ETF	512.45	512.46	512.45	512.46	800.0
2024-03-19 05:16:00	SPY	ETF	512.58	512.58	512.58	512.58	124.0
2024-03-19 05:17:00	SPY	ETF	512.5	512.5	512.5	512.5	100.0
2024-03-19 05:19:00	SPY	ETF	512.44	512.44	512.44	512.44	500.0
2024-03-19 05:28:00	SPY	ETF	512.42	512.47	512.42	512.47	1800.0
2024-03-19 05:32:00	SPY	ETF	512.49	512.49	512.49	512.49	625.0
2024-03-19 05:36:00	SPY	ETF	512.22	512.22	512.2	512.2	6000.0
2024-03-19 05:37:00	SPY	ETF	512.27	512.27	512.2	512.2	700.0

> showing 50 of 291,578 rows — these rows as CSV

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