PREVIEW / stock_5min / 2024-07-16
file: by_date/stock_5min/2024/2024-07-16.parquet size: 6.9 MB rows: 416,531 symbols: 910
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-16 04:00:00 | AAPL | Stock | 236.0 | 236.0 | 234.8 | 234.8 | 5105.0 |
| 2024-07-16 04:05:00 | AAPL | Stock | 234.8 | 234.8 | 234.43 | 234.43 | 1531.0 |
| 2024-07-16 04:10:00 | AAPL | Stock | 234.59 | 235.0 | 234.57 | 235.0 | 1322.0 |
| 2024-07-16 04:15:00 | AAPL | Stock | 234.95 | 234.99 | 234.95 | 234.99 | 610.0 |
| 2024-07-16 04:20:00 | AAPL | Stock | 234.94 | 235.39 | 234.94 | 235.39 | 1691.0 |
| 2024-07-16 04:25:00 | AAPL | Stock | 235.45 | 235.48 | 235.35 | 235.4 | 2273.0 |
| 2024-07-16 04:30:00 | AAPL | Stock | 235.42 | 235.44 | 235.42 | 235.44 | 882.0 |
| 2024-07-16 04:35:00 | AAPL | Stock | 235.44 | 235.47 | 235.25 | 235.25 | 2159.0 |
| 2024-07-16 04:40:00 | AAPL | Stock | 235.38 | 235.38 | 235.3 | 235.3 | 994.0 |
| 2024-07-16 04:45:00 | AAPL | Stock | 235.21 | 235.21 | 234.95 | 234.95 | 1160.0 |
| 2024-07-16 04:50:00 | AAPL | Stock | 234.92 | 234.92 | 234.7 | 234.89 | 2651.0 |
| 2024-07-16 04:55:00 | AAPL | Stock | 235.05 | 235.05 | 235.01 | 235.01 | 381.0 |
| 2024-07-16 05:00:00 | AAPL | Stock | 235.05 | 235.05 | 235.0 | 235.05 | 644.0 |
| 2024-07-16 05:05:00 | AAPL | Stock | 235.05 | 235.05 | 234.99 | 234.99 | 945.0 |
| 2024-07-16 05:10:00 | AAPL | Stock | 234.89 | 234.89 | 234.7 | 234.84 | 1753.0 |
| 2024-07-16 05:15:00 | AAPL | Stock | 234.84 | 234.84 | 234.84 | 234.84 | 100.0 |
| 2024-07-16 05:20:00 | AAPL | Stock | 234.94 | 234.94 | 234.94 | 234.94 | 457.0 |
| 2024-07-16 05:25:00 | AAPL | Stock | 234.91 | 234.91 | 234.9 | 234.9 | 584.0 |
| 2024-07-16 05:30:00 | AAPL | Stock | 234.9 | 234.9 | 234.86 | 234.89 | 1248.0 |
| 2024-07-16 05:35:00 | AAPL | Stock | 235.0 | 235.0 | 234.86 | 234.86 | 1782.0 |
| 2024-07-16 05:40:00 | AAPL | Stock | 234.86 | 234.86 | 234.86 | 234.86 | 268.0 |
| 2024-07-16 05:55:00 | AAPL | Stock | 234.92 | 234.99 | 234.92 | 234.99 | 739.0 |
| 2024-07-16 06:00:00 | AAPL | Stock | 235.0 | 235.02 | 235.0 | 235.02 | 316.0 |
| 2024-07-16 06:05:00 | AAPL | Stock | 235.02 | 235.03 | 235.02 | 235.03 | 280.0 |
| 2024-07-16 06:10:00 | AAPL | Stock | 235.04 | 235.1 | 235.04 | 235.1 | 595.0 |
| 2024-07-16 06:15:00 | AAPL | Stock | 235.1 | 235.18 | 235.1 | 235.18 | 766.0 |
| 2024-07-16 06:20:00 | AAPL | Stock | 235.2 | 235.29 | 235.2 | 235.29 | 1027.0 |
| 2024-07-16 06:25:00 | AAPL | Stock | 235.28 | 235.28 | 235.26 | 235.26 | 962.0 |
| 2024-07-16 06:30:00 | AAPL | Stock | 235.25 | 235.25 | 235.25 | 235.25 | 455.0 |
| 2024-07-16 06:35:00 | AAPL | Stock | 235.25 | 235.25 | 235.18 | 235.18 | 300.0 |
| 2024-07-16 06:40:00 | AAPL | Stock | 235.15 | 235.15 | 235.15 | 235.15 | 200.0 |
| 2024-07-16 06:45:00 | AAPL | Stock | 235.16 | 235.16 | 235.16 | 235.16 | 333.0 |
| 2024-07-16 06:50:00 | AAPL | Stock | 235.15 | 235.15 | 235.15 | 235.15 | 100.0 |
| 2024-07-16 07:00:00 | AAPL | Stock | 235.15 | 235.28 | 235.12 | 235.26 | 3757.0 |
| 2024-07-16 07:05:00 | AAPL | Stock | 235.3 | 235.3 | 235.2 | 235.2 | 1408.0 |
| 2024-07-16 07:10:00 | AAPL | Stock | 235.17 | 235.2 | 235.14 | 235.14 | 1311.0 |
| 2024-07-16 07:15:00 | AAPL | Stock | 235.1 | 235.1 | 235.0 | 235.04 | 4539.0 |
| 2024-07-16 07:20:00 | AAPL | Stock | 235.0 | 235.05 | 235.0 | 235.05 | 2649.0 |
| 2024-07-16 07:25:00 | AAPL | Stock | 235.0 | 235.0 | 234.99 | 234.99 | 1681.0 |
| 2024-07-16 07:30:00 | AAPL | Stock | 234.96 | 234.99 | 234.96 | 234.99 | 1712.0 |
| 2024-07-16 07:35:00 | AAPL | Stock | 234.99 | 235.16 | 234.9 | 234.9 | 2819.0 |
| 2024-07-16 07:40:00 | AAPL | Stock | 235.01 | 235.1 | 235.01 | 235.1 | 552.0 |
| 2024-07-16 07:45:00 | AAPL | Stock | 235.11 | 235.18 | 235.11 | 235.18 | 952.0 |
| 2024-07-16 07:50:00 | AAPL | Stock | 235.18 | 235.18 | 235.18 | 235.18 | 1076.0 |
| 2024-07-16 07:55:00 | AAPL | Stock | 235.15 | 235.18 | 235.15 | 235.18 | 326.0 |
| 2024-07-16 08:00:00 | AAPL | Stock | 235.08 | 236.65 | 234.5345 | 235.2382 | 66873.0 |
| 2024-07-16 08:05:00 | AAPL | Stock | 235.22 | 235.2583 | 235.22 | 235.23 | 1655.0 |
| 2024-07-16 08:10:00 | AAPL | Stock | 235.2094 | 235.22 | 235.2 | 235.21 | 3477.0 |
| 2024-07-16 08:15:00 | AAPL | Stock | 235.2 | 235.21 | 235.15 | 235.18 | 7493.0 |
| 2024-07-16 08:20:00 | AAPL | Stock | 235.15 | 235.19 | 235.15 | 235.19 | 2421.0 |
> showing 50 of 416,531 rows — these rows as CSV