PREVIEW / etf_5min / 2024-08-12
file: by_date/etf_5min/2024/2024-08-12.parquet size: 2.2 MB rows: 111,450
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-08-12 04:00:00 | SPY | ETF | 533.5 | 534.43 | 533.5 | 534.29 | 14147.0 |
| 2024-08-12 04:05:00 | SPY | ETF | 534.32 | 534.45 | 534.32 | 534.45 | 754.0 |
| 2024-08-12 04:10:00 | SPY | ETF | 534.25 | 534.25 | 534.09 | 534.14 | 631.0 |
| 2024-08-12 04:15:00 | SPY | ETF | 534.22 | 534.23 | 534.04 | 534.23 | 1525.0 |
| 2024-08-12 04:20:00 | SPY | ETF | 534.2 | 534.28 | 534.18 | 534.28 | 722.0 |
| 2024-08-12 04:25:00 | SPY | ETF | 534.2 | 534.23 | 534.17 | 534.17 | 3151.0 |
| 2024-08-12 04:35:00 | SPY | ETF | 534.0 | 534.0 | 533.82 | 533.83 | 10236.0 |
| 2024-08-12 04:40:00 | SPY | ETF | 533.86 | 533.89 | 533.71 | 533.71 | 1300.0 |
| 2024-08-12 04:50:00 | SPY | ETF | 533.56 | 533.58 | 533.56 | 533.58 | 200.0 |
| 2024-08-12 04:55:00 | SPY | ETF | 533.5 | 533.5 | 533.49 | 533.49 | 400.0 |
| 2024-08-12 05:00:00 | SPY | ETF | 533.41 | 533.49 | 533.41 | 533.46 | 1672.0 |
| 2024-08-12 05:05:00 | SPY | ETF | 533.35 | 533.44 | 533.35 | 533.44 | 1117.0 |
| 2024-08-12 05:10:00 | SPY | ETF | 533.4 | 533.64 | 533.38 | 533.64 | 3200.0 |
| 2024-08-12 05:25:00 | SPY | ETF | 533.61 | 533.61 | 533.61 | 533.61 | 100.0 |
| 2024-08-12 05:30:00 | SPY | ETF | 533.64 | 533.7 | 533.58 | 533.7 | 907.0 |
| 2024-08-12 05:35:00 | SPY | ETF | 533.75 | 533.9 | 533.65 | 533.9 | 1259.0 |
| 2024-08-12 05:45:00 | SPY | ETF | 533.78 | 533.78 | 533.78 | 533.78 | 112.0 |
| 2024-08-12 05:50:00 | SPY | ETF | 533.52 | 533.63 | 533.52 | 533.63 | 246.0 |
| 2024-08-12 05:55:00 | SPY | ETF | 533.78 | 533.8 | 533.57 | 533.57 | 1311.0 |
| 2024-08-12 06:00:00 | SPY | ETF | 533.66 | 533.66 | 533.36 | 533.43 | 2160.0 |
| 2024-08-12 06:05:00 | SPY | ETF | 533.44 | 533.44 | 533.42 | 533.44 | 373.0 |
| 2024-08-12 06:10:00 | SPY | ETF | 533.47 | 533.84 | 533.44 | 533.84 | 4245.0 |
| 2024-08-12 06:15:00 | SPY | ETF | 533.81 | 533.83 | 533.76 | 533.81 | 5497.0 |
| 2024-08-12 06:20:00 | SPY | ETF | 534.0 | 534.22 | 534.0 | 534.1 | 3196.0 |
| 2024-08-12 06:25:00 | SPY | ETF | 534.08 | 534.14 | 534.08 | 534.14 | 200.0 |
| 2024-08-12 06:30:00 | SPY | ETF | 534.03 | 534.03 | 534.03 | 534.03 | 640.0 |
| 2024-08-12 06:35:00 | SPY | ETF | 534.05 | 534.05 | 534.05 | 534.05 | 100.0 |
| 2024-08-12 06:40:00 | SPY | ETF | 534.22 | 534.22 | 534.22 | 534.22 | 264.0 |
| 2024-08-12 06:45:00 | SPY | ETF | 534.0 | 534.05 | 534.0 | 534.05 | 725.0 |
| 2024-08-12 06:55:00 | SPY | ETF | 534.1 | 534.1 | 534.04 | 534.05 | 11881.0 |
| 2024-08-12 07:00:00 | SPY | ETF | 534.14 | 534.24 | 533.54 | 533.95 | 138898.0 |
| 2024-08-12 07:05:00 | SPY | ETF | 533.98 | 534.23 | 533.97 | 534.23 | 12678.0 |
| 2024-08-12 07:10:00 | SPY | ETF | 534.24 | 534.42 | 534.2 | 534.42 | 3948.0 |
| 2024-08-12 07:15:00 | SPY | ETF | 534.369 | 534.62 | 534.33 | 534.5 | 17346.0 |
| 2024-08-12 07:20:00 | SPY | ETF | 534.54 | 534.72 | 534.54 | 534.58 | 13399.0 |
| 2024-08-12 07:25:00 | SPY | ETF | 534.68 | 534.74 | 534.57 | 534.57 | 4225.0 |
| 2024-08-12 07:30:00 | SPY | ETF | 534.51 | 534.53 | 534.21 | 534.28 | 8733.0 |
| 2024-08-12 07:35:00 | SPY | ETF | 534.33 | 534.33 | 534.19 | 534.31 | 4921.0 |
| 2024-08-12 07:40:00 | SPY | ETF | 534.24 | 534.3 | 534.1 | 534.1 | 7156.0 |
| 2024-08-12 07:45:00 | SPY | ETF | 533.92 | 534.26 | 533.9 | 534.26 | 4199.0 |
| 2024-08-12 07:50:00 | SPY | ETF | 534.32 | 534.53 | 534.3 | 534.43 | 14608.0 |
| 2024-08-12 07:55:00 | SPY | ETF | 534.43 | 534.62 | 534.4 | 534.5 | 7603.0 |
| 2024-08-12 08:00:00 | SPY | ETF | 533.95 | 534.7 | 532.94 | 534.37 | 55580.0 |
| 2024-08-12 08:05:00 | SPY | ETF | 534.43 | 534.65 | 534.42 | 534.57 | 14299.0 |
| 2024-08-12 08:10:00 | SPY | ETF | 534.56 | 534.61 | 534.36 | 534.36 | 6667.0 |
| 2024-08-12 08:15:00 | SPY | ETF | 534.36 | 534.5 | 534.36 | 534.44 | 6044.0 |
| 2024-08-12 08:20:00 | SPY | ETF | 534.44 | 534.8 | 534.44 | 534.8 | 63237.0 |
| 2024-08-12 08:25:00 | SPY | ETF | 534.78 | 534.98 | 534.73 | 534.97 | 68241.0 |
| 2024-08-12 08:30:00 | SPY | ETF | 534.9602 | 535.0 | 534.55 | 534.55 | 21096.0 |
| 2024-08-12 08:35:00 | SPY | ETF | 534.59 | 534.59 | 534.41 | 534.42 | 11911.0 |
> showing 50 of 111,450 rows — these rows as CSV