PREVIEW / etf_1min / 2024-07-25
file: by_date/etf_1min/2024/2024-07-25.parquet size: 5.6 MB rows: 321,721
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-25 04:00:00 | SPY | ETF | 541.88 | 542.28 | 540.63 | 540.7 | 8408.0 |
| 2024-07-25 04:01:00 | SPY | ETF | 540.76 | 540.88 | 540.76 | 540.88 | 595.0 |
| 2024-07-25 04:02:00 | SPY | ETF | 540.8 | 540.83 | 540.69 | 540.72 | 6018.0 |
| 2024-07-25 04:03:00 | SPY | ETF | 540.57 | 540.6 | 540.21 | 540.3 | 4624.0 |
| 2024-07-25 04:04:00 | SPY | ETF | 540.06 | 540.12 | 539.91 | 540.02 | 13795.0 |
| 2024-07-25 04:05:00 | SPY | ETF | 540.22 | 540.26 | 540.02 | 540.02 | 2460.0 |
| 2024-07-25 04:06:00 | SPY | ETF | 540.07 | 540.07 | 539.76 | 539.79 | 1059.0 |
| 2024-07-25 04:07:00 | SPY | ETF | 539.77 | 539.77 | 539.52 | 539.58 | 3173.0 |
| 2024-07-25 04:08:00 | SPY | ETF | 539.59 | 539.59 | 539.51 | 539.51 | 600.0 |
| 2024-07-25 04:10:00 | SPY | ETF | 539.53 | 539.83 | 539.53 | 539.83 | 820.0 |
| 2024-07-25 04:11:00 | SPY | ETF | 539.69 | 539.77 | 539.69 | 539.77 | 1017.0 |
| 2024-07-25 04:12:00 | SPY | ETF | 539.78 | 539.78 | 539.78 | 539.78 | 172.0 |
| 2024-07-25 04:13:00 | SPY | ETF | 539.79 | 539.79 | 539.67 | 539.67 | 588.0 |
| 2024-07-25 04:14:00 | SPY | ETF | 539.55 | 539.55 | 539.5 | 539.5 | 729.0 |
| 2024-07-25 04:15:00 | SPY | ETF | 539.41 | 539.41 | 539.38 | 539.38 | 400.0 |
| 2024-07-25 04:16:00 | SPY | ETF | 539.36 | 539.45 | 539.36 | 539.36 | 1294.0 |
| 2024-07-25 04:17:00 | SPY | ETF | 539.36 | 539.36 | 539.28 | 539.3 | 640.0 |
| 2024-07-25 04:18:00 | SPY | ETF | 539.3 | 539.34 | 539.3 | 539.34 | 528.0 |
| 2024-07-25 04:19:00 | SPY | ETF | 539.32 | 539.32 | 539.28 | 539.28 | 454.0 |
| 2024-07-25 04:20:00 | SPY | ETF | 539.5 | 539.5 | 539.5 | 539.5 | 389.0 |
| 2024-07-25 04:21:00 | SPY | ETF | 539.47 | 539.47 | 539.47 | 539.47 | 100.0 |
| 2024-07-25 04:22:00 | SPY | ETF | 539.74 | 539.74 | 539.74 | 539.74 | 210.0 |
| 2024-07-25 04:23:00 | SPY | ETF | 539.64 | 539.64 | 539.53 | 539.53 | 218.0 |
| 2024-07-25 04:27:00 | SPY | ETF | 540.35 | 540.35 | 540.34 | 540.34 | 1100.0 |
| 2024-07-25 04:28:00 | SPY | ETF | 540.5 | 540.59 | 540.36 | 540.36 | 3728.0 |
| 2024-07-25 04:29:00 | SPY | ETF | 540.4 | 540.75 | 540.39 | 540.75 | 1300.0 |
| 2024-07-25 04:30:00 | SPY | ETF | 540.55 | 540.94 | 540.53 | 540.83 | 4078.0 |
| 2024-07-25 04:32:00 | SPY | ETF | 541.1 | 541.1 | 541.1 | 541.1 | 300.0 |
| 2024-07-25 04:33:00 | SPY | ETF | 541.14 | 541.19 | 541.12 | 541.17 | 1704.0 |
| 2024-07-25 04:34:00 | SPY | ETF | 541.17 | 541.17 | 541.16 | 541.16 | 200.0 |
| 2024-07-25 04:35:00 | SPY | ETF | 541.03 | 541.03 | 541.03 | 541.03 | 400.0 |
| 2024-07-25 04:36:00 | SPY | ETF | 540.87 | 540.87 | 540.8 | 540.8 | 858.0 |
| 2024-07-25 04:37:00 | SPY | ETF | 540.71 | 540.72 | 540.71 | 540.72 | 462.0 |
| 2024-07-25 04:38:00 | SPY | ETF | 540.92 | 540.96 | 540.92 | 540.96 | 715.0 |
| 2024-07-25 04:39:00 | SPY | ETF | 540.98 | 541.04 | 540.97 | 541.0 | 1735.0 |
| 2024-07-25 04:40:00 | SPY | ETF | 541.09 | 541.27 | 541.09 | 541.27 | 880.0 |
| 2024-07-25 04:41:00 | SPY | ETF | 541.34 | 541.57 | 541.32 | 541.57 | 500.0 |
| 2024-07-25 04:43:00 | SPY | ETF | 541.5 | 541.5 | 541.31 | 541.31 | 313.0 |
| 2024-07-25 04:44:00 | SPY | ETF | 541.36 | 541.36 | 541.36 | 541.36 | 100.0 |
| 2024-07-25 04:45:00 | SPY | ETF | 541.4 | 541.4 | 541.22 | 541.27 | 300.0 |
| 2024-07-25 04:46:00 | SPY | ETF | 541.2 | 541.25 | 541.2 | 541.25 | 2200.0 |
| 2024-07-25 04:48:00 | SPY | ETF | 541.17 | 541.18 | 541.13 | 541.18 | 3850.0 |
| 2024-07-25 04:49:00 | SPY | ETF | 541.18 | 541.18 | 541.18 | 541.18 | 400.0 |
| 2024-07-25 04:50:00 | SPY | ETF | 541.25 | 541.35 | 541.25 | 541.34 | 550.0 |
| 2024-07-25 04:52:00 | SPY | ETF | 541.4 | 541.51 | 541.4 | 541.51 | 551.0 |
| 2024-07-25 04:54:00 | SPY | ETF | 541.55 | 541.55 | 541.52 | 541.52 | 2291.0 |
| 2024-07-25 04:55:00 | SPY | ETF | 541.58 | 541.58 | 541.54 | 541.58 | 1000.0 |
| 2024-07-25 04:56:00 | SPY | ETF | 541.68 | 541.68 | 541.68 | 541.68 | 102.0 |
| 2024-07-25 04:57:00 | SPY | ETF | 541.71 | 541.71 | 541.62 | 541.62 | 200.0 |
| 2024-07-25 04:59:00 | SPY | ETF | 541.69 | 541.69 | 541.69 | 541.69 | 290.0 |
> showing 50 of 321,721 rows — these rows as CSV