PREVIEW / etf_5min / 2024-05-23
file: by_date/etf_5min/2024/2024-05-23.parquet size: 2.3 MB rows: 112,031
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-05-23 04:00:00 | SPY | ETF | 532.0 | 532.68 | 532.0 | 532.64 | 2727.0 |
| 2024-05-23 04:05:00 | SPY | ETF | 532.67 | 532.73 | 532.67 | 532.7 | 2492.0 |
| 2024-05-23 04:10:00 | SPY | ETF | 532.7 | 532.7 | 532.6 | 532.63 | 1142.0 |
| 2024-05-23 04:15:00 | SPY | ETF | 532.64 | 532.64 | 532.6 | 532.64 | 300.0 |
| 2024-05-23 04:20:00 | SPY | ETF | 532.53 | 532.53 | 532.53 | 532.53 | 200.0 |
| 2024-05-23 04:25:00 | SPY | ETF | 532.58 | 532.69 | 532.57 | 532.69 | 1200.0 |
| 2024-05-23 04:35:00 | SPY | ETF | 532.68 | 532.68 | 532.59 | 532.59 | 200.0 |
| 2024-05-23 04:40:00 | SPY | ETF | 532.43 | 532.43 | 532.43 | 532.43 | 200.0 |
| 2024-05-23 04:45:00 | SPY | ETF | 532.41 | 532.44 | 532.41 | 532.44 | 286.0 |
| 2024-05-23 04:50:00 | SPY | ETF | 532.31 | 532.31 | 532.31 | 532.31 | 400.0 |
| 2024-05-23 05:00:00 | SPY | ETF | 532.4 | 532.4 | 532.32 | 532.32 | 1900.0 |
| 2024-05-23 05:05:00 | SPY | ETF | 532.44 | 532.44 | 532.36 | 532.36 | 1038.0 |
| 2024-05-23 05:10:00 | SPY | ETF | 532.38 | 532.55 | 532.37 | 532.55 | 600.0 |
| 2024-05-23 05:15:00 | SPY | ETF | 532.57 | 532.57 | 532.57 | 532.57 | 100.0 |
| 2024-05-23 05:20:00 | SPY | ETF | 532.63 | 532.63 | 532.63 | 532.63 | 100.0 |
| 2024-05-23 05:25:00 | SPY | ETF | 532.69 | 532.69 | 532.63 | 532.64 | 5000.0 |
| 2024-05-23 05:30:00 | SPY | ETF | 532.73 | 532.74 | 532.68 | 532.74 | 2100.0 |
| 2024-05-23 05:35:00 | SPY | ETF | 532.73 | 532.73 | 532.73 | 532.73 | 355.0 |
| 2024-05-23 05:40:00 | SPY | ETF | 532.8 | 532.8 | 532.8 | 532.8 | 100.0 |
| 2024-05-23 05:45:00 | SPY | ETF | 532.8 | 532.8 | 532.74 | 532.74 | 694.0 |
| 2024-05-23 05:50:00 | SPY | ETF | 532.75 | 532.75 | 532.74 | 532.74 | 330.0 |
| 2024-05-23 06:05:00 | SPY | ETF | 532.7 | 532.71 | 532.7 | 532.71 | 500.0 |
| 2024-05-23 06:10:00 | SPY | ETF | 532.71 | 532.71 | 532.71 | 532.71 | 209.0 |
| 2024-05-23 06:15:00 | SPY | ETF | 532.66 | 532.66 | 532.66 | 532.66 | 900.0 |
| 2024-05-23 06:20:00 | SPY | ETF | 532.74 | 532.82 | 532.74 | 532.82 | 1223.0 |
| 2024-05-23 06:25:00 | SPY | ETF | 532.82 | 532.82 | 532.82 | 532.82 | 150.0 |
| 2024-05-23 06:30:00 | SPY | ETF | 532.84 | 532.85 | 532.84 | 532.85 | 600.0 |
| 2024-05-23 06:35:00 | SPY | ETF | 532.83 | 532.85 | 532.83 | 532.85 | 400.0 |
| 2024-05-23 06:40:00 | SPY | ETF | 532.88 | 532.88 | 532.84 | 532.87 | 800.0 |
| 2024-05-23 06:45:00 | SPY | ETF | 532.9 | 532.9 | 532.9 | 532.9 | 100.0 |
| 2024-05-23 06:50:00 | SPY | ETF | 532.97 | 533.0 | 532.97 | 533.0 | 600.0 |
| 2024-05-23 06:55:00 | SPY | ETF | 533.0 | 533.11 | 533.0 | 533.11 | 1200.0 |
| 2024-05-23 07:00:00 | SPY | ETF | 533.11 | 533.24 | 532.2 | 533.19 | 137011.0 |
| 2024-05-23 07:05:00 | SPY | ETF | 533.17 | 533.24 | 533.1 | 533.15 | 6212.0 |
| 2024-05-23 07:10:00 | SPY | ETF | 533.18 | 533.2 | 533.08 | 533.13 | 3798.0 |
| 2024-05-23 07:15:00 | SPY | ETF | 533.11 | 533.11 | 533.09 | 533.09 | 500.0 |
| 2024-05-23 07:20:00 | SPY | ETF | 533.12 | 533.18 | 533.1 | 533.18 | 2050.0 |
| 2024-05-23 07:25:00 | SPY | ETF | 533.2 | 533.31 | 533.2 | 533.3 | 1300.0 |
| 2024-05-23 07:30:00 | SPY | ETF | 533.3 | 533.55 | 533.28 | 533.5 | 27964.0 |
| 2024-05-23 07:35:00 | SPY | ETF | 533.45 | 533.5 | 533.42 | 533.5 | 12220.0 |
| 2024-05-23 07:40:00 | SPY | ETF | 533.5 | 533.5 | 533.35 | 533.47 | 30979.0 |
| 2024-05-23 07:45:00 | SPY | ETF | 533.45 | 533.51 | 533.45 | 533.49 | 14555.0 |
| 2024-05-23 07:50:00 | SPY | ETF | 533.54 | 533.55 | 533.46 | 533.46 | 14585.0 |
| 2024-05-23 07:55:00 | SPY | ETF | 533.47 | 533.58 | 533.45 | 533.53 | 20696.0 |
| 2024-05-23 08:00:00 | SPY | ETF | 533.18 | 533.71 | 532.75 | 533.36 | 74902.0 |
| 2024-05-23 08:05:00 | SPY | ETF | 533.5 | 533.79 | 533.11 | 533.75 | 49089.0 |
| 2024-05-23 08:10:00 | SPY | ETF | 533.76 | 533.82 | 531.57 | 533.7 | 12010.0 |
| 2024-05-23 08:15:00 | SPY | ETF | 533.7 | 533.76 | 533.65 | 533.7 | 63961.0 |
| 2024-05-23 08:20:00 | SPY | ETF | 533.7 | 533.92 | 533.69 | 533.88 | 34209.0 |
| 2024-05-23 08:25:00 | SPY | ETF | 533.86 | 533.9893 | 533.83 | 533.89 | 16721.0 |
> showing 50 of 112,031 rows — these rows as CSV