PREVIEW / etf_1min / 2024-06-18

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-06-18.parquet
  size:    5.0 MB
  rows:    286,084

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-18 04:00:00	SPY	ETF	546.88	546.88	546.88	546.88	300.0
2024-06-18 04:01:00	SPY	ETF	547.0	547.01	546.99	546.99	1400.0
2024-06-18 04:02:00	SPY	ETF	546.94	546.94	546.9	546.9	350.0
2024-06-18 04:03:00	SPY	ETF	546.98	547.03	546.98	547.0	646.0
2024-06-18 04:04:00	SPY	ETF	546.95	546.95	546.95	546.95	1000.0
2024-06-18 04:05:00	SPY	ETF	546.91	546.91	546.91	546.91	100.0
2024-06-18 04:06:00	SPY	ETF	546.93	546.93	546.93	546.93	100.0
2024-06-18 04:08:00	SPY	ETF	546.99	546.99	546.99	546.99	200.0
2024-06-18 04:09:00	SPY	ETF	547.0	547.05	547.0	547.05	525.0
2024-06-18 04:10:00	SPY	ETF	547.05	547.05	547.04	547.04	200.0
2024-06-18 04:11:00	SPY	ETF	547.0	547.0	547.0	547.0	100.0
2024-06-18 04:12:00	SPY	ETF	546.98	546.99	546.98	546.98	1180.0
2024-06-18 04:13:00	SPY	ETF	546.9	546.9	546.9	546.9	500.0
2024-06-18 04:15:00	SPY	ETF	546.92	546.92	546.92	546.92	100.0
2024-06-18 04:16:00	SPY	ETF	546.85	546.85	546.85	546.85	200.0
2024-06-18 04:17:00	SPY	ETF	546.8	546.81	546.8	546.81	300.0
2024-06-18 04:22:00	SPY	ETF	546.7	546.7	546.61	546.61	844.0
2024-06-18 04:25:00	SPY	ETF	546.63	546.63	546.61	546.61	800.0
2024-06-18 04:33:00	SPY	ETF	546.91	546.91	546.91	546.91	479.0
2024-06-18 04:34:00	SPY	ETF	546.84	546.84	546.84	546.84	324.0
2024-06-18 04:40:00	SPY	ETF	546.83	546.83	546.83	546.83	100.0
2024-06-18 04:43:00	SPY	ETF	546.81	546.81	546.81	546.81	500.0
2024-06-18 04:50:00	SPY	ETF	547.0	547.02	547.0	547.02	10000.0
2024-06-18 04:51:00	SPY	ETF	547.13	547.13	547.11	547.11	438.0
2024-06-18 04:52:00	SPY	ETF	547.21	547.21	547.21	547.21	187.0
2024-06-18 04:53:00	SPY	ETF	547.2	547.2	547.2	547.2	200.0
2024-06-18 04:55:00	SPY	ETF	547.22	547.22	547.22	547.22	200.0
2024-06-18 04:56:00	SPY	ETF	547.2	547.2	547.17	547.17	600.0
2024-06-18 05:10:00	SPY	ETF	547.32	547.32	547.32	547.32	500.0
2024-06-18 05:12:00	SPY	ETF	547.39	547.39	547.39	547.39	200.0
2024-06-18 05:14:00	SPY	ETF	547.48	547.49	547.48	547.49	1000.0
2024-06-18 05:15:00	SPY	ETF	547.42	547.42	547.42	547.42	200.0
2024-06-18 05:23:00	SPY	ETF	547.38	547.38	547.38	547.38	102.0
2024-06-18 05:27:00	SPY	ETF	547.12	547.12	547.11	547.11	998.0
2024-06-18 05:28:00	SPY	ETF	547.11	547.11	547.1	547.1	1161.0
2024-06-18 05:29:00	SPY	ETF	547.11	547.11	547.11	547.11	100.0
2024-06-18 05:31:00	SPY	ETF	547.12	547.12	547.12	547.12	100.0
2024-06-18 05:32:00	SPY	ETF	547.1	547.1	547.1	547.1	188.0
2024-06-18 05:34:00	SPY	ETF	547.05	547.05	547.05	547.05	155.0
2024-06-18 05:51:00	SPY	ETF	547.33	547.35	547.33	547.35	200.0
2024-06-18 05:52:00	SPY	ETF	547.39	547.39	547.39	547.39	100.0
2024-06-18 05:56:00	SPY	ETF	547.31	547.31	547.31	547.31	800.0
2024-06-18 05:57:00	SPY	ETF	547.29	547.29	547.2	547.2	600.0
2024-06-18 06:10:00	SPY	ETF	547.13	547.13	547.04	547.04	393.0
2024-06-18 06:11:00	SPY	ETF	547.01	547.01	547.01	547.01	300.0
2024-06-18 06:14:00	SPY	ETF	547.1	547.1	547.1	547.1	100.0
2024-06-18 06:20:00	SPY	ETF	547.17	547.17	547.17	547.17	125.0
2024-06-18 06:22:00	SPY	ETF	547.26	547.26	547.26	547.26	393.0
2024-06-18 06:30:00	SPY	ETF	547.37	547.5	547.37	547.5	3199.0
2024-06-18 06:32:00	SPY	ETF	547.42	547.42	547.42	547.42	300.0

> showing 50 of 286,084 rows — these rows as CSV

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