PREVIEW / stock_5min / 2023-03-07
file: by_date/stock_5min/2023/2023-03-07.parquet size: 6.7 MB rows: 409,407 symbols: 1,803
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-07 04:00:00 | AAPL | Stock | 154.0 | 154.47 | 153.98 | 154.47 | 2967.0 |
| 2023-03-07 04:05:00 | AAPL | Stock | 154.5 | 154.72 | 154.4 | 154.4 | 3637.0 |
| 2023-03-07 04:10:00 | AAPL | Stock | 154.48 | 154.49 | 154.3 | 154.3 | 1627.0 |
| 2023-03-07 04:15:00 | AAPL | Stock | 154.28 | 154.4 | 154.28 | 154.33 | 1356.0 |
| 2023-03-07 04:20:00 | AAPL | Stock | 154.3 | 154.41 | 154.3 | 154.36 | 1139.0 |
| 2023-03-07 04:25:00 | AAPL | Stock | 154.34 | 154.34 | 154.29 | 154.29 | 792.0 |
| 2023-03-07 04:30:00 | AAPL | Stock | 154.29 | 154.36 | 154.27 | 154.27 | 3969.0 |
| 2023-03-07 04:35:00 | AAPL | Stock | 154.27 | 154.29 | 154.27 | 154.29 | 594.0 |
| 2023-03-07 04:40:00 | AAPL | Stock | 154.3 | 154.31 | 154.25 | 154.25 | 896.0 |
| 2023-03-07 04:50:00 | AAPL | Stock | 154.15 | 154.15 | 154.15 | 154.15 | 950.0 |
| 2023-03-07 05:00:00 | AAPL | Stock | 154.16 | 154.16 | 154.16 | 154.16 | 290.0 |
| 2023-03-07 05:05:00 | AAPL | Stock | 154.16 | 154.29 | 154.16 | 154.29 | 766.0 |
| 2023-03-07 05:15:00 | AAPL | Stock | 154.16 | 154.16 | 154.16 | 154.16 | 100.0 |
| 2023-03-07 05:20:00 | AAPL | Stock | 154.29 | 154.29 | 154.29 | 154.29 | 100.0 |
| 2023-03-07 05:30:00 | AAPL | Stock | 154.19 | 154.19 | 154.19 | 154.19 | 100.0 |
| 2023-03-07 05:35:00 | AAPL | Stock | 154.2 | 154.24 | 154.2 | 154.24 | 400.0 |
| 2023-03-07 05:40:00 | AAPL | Stock | 154.31 | 154.33 | 154.31 | 154.33 | 1255.0 |
| 2023-03-07 05:45:00 | AAPL | Stock | 154.21 | 154.21 | 154.2 | 154.2 | 659.0 |
| 2023-03-07 06:00:00 | AAPL | Stock | 154.26 | 154.29 | 154.26 | 154.29 | 496.0 |
| 2023-03-07 06:20:00 | AAPL | Stock | 154.33 | 154.33 | 154.23 | 154.23 | 2155.0 |
| 2023-03-07 06:25:00 | AAPL | Stock | 154.15 | 154.15 | 154.15 | 154.15 | 470.0 |
| 2023-03-07 06:30:00 | AAPL | Stock | 154.16 | 154.21 | 154.15 | 154.21 | 1192.0 |
| 2023-03-07 06:35:00 | AAPL | Stock | 154.23 | 154.23 | 154.23 | 154.23 | 100.0 |
| 2023-03-07 06:40:00 | AAPL | Stock | 154.27 | 154.27 | 154.25 | 154.25 | 1599.0 |
| 2023-03-07 06:45:00 | AAPL | Stock | 154.24 | 154.28 | 154.24 | 154.28 | 989.0 |
| 2023-03-07 06:50:00 | AAPL | Stock | 154.28 | 154.28 | 154.27 | 154.27 | 2760.0 |
| 2023-03-07 06:55:00 | AAPL | Stock | 154.23 | 154.23 | 154.17 | 154.18 | 2756.0 |
| 2023-03-07 07:00:00 | AAPL | Stock | 154.3 | 154.3 | 154.2 | 154.27 | 7977.0 |
| 2023-03-07 07:05:00 | AAPL | Stock | 154.3 | 154.38 | 154.29 | 154.38 | 8077.0 |
| 2023-03-07 07:10:00 | AAPL | Stock | 154.3 | 154.3 | 154.25 | 154.25 | 608.0 |
| 2023-03-07 07:15:00 | AAPL | Stock | 154.25 | 154.25 | 154.25 | 154.25 | 1184.0 |
| 2023-03-07 07:20:00 | AAPL | Stock | 154.28 | 154.28 | 154.21 | 154.21 | 3013.0 |
| 2023-03-07 07:25:00 | AAPL | Stock | 154.17 | 154.17 | 154.14 | 154.14 | 6745.0 |
| 2023-03-07 07:30:00 | AAPL | Stock | 154.12 | 154.13 | 154.06 | 154.06 | 889.0 |
| 2023-03-07 07:35:00 | AAPL | Stock | 154.14 | 154.14 | 154.11 | 154.13 | 683.0 |
| 2023-03-07 07:40:00 | AAPL | Stock | 154.14 | 154.2 | 154.07 | 154.18 | 4566.0 |
| 2023-03-07 07:45:00 | AAPL | Stock | 154.16 | 154.16 | 154.1 | 154.14 | 1708.0 |
| 2023-03-07 07:50:00 | AAPL | Stock | 154.16 | 154.2 | 154.16 | 154.2 | 230.0 |
| 2023-03-07 07:55:00 | AAPL | Stock | 154.18 | 154.19 | 154.13 | 154.13 | 914.0 |
| 2023-03-07 08:00:00 | AAPL | Stock | 154.19 | 154.7 | 153.446 | 154.2291 | 49944.0 |
| 2023-03-07 08:05:00 | AAPL | Stock | 154.182 | 154.2392 | 154.16 | 154.19 | 8094.0 |
| 2023-03-07 08:10:00 | AAPL | Stock | 154.173 | 154.2 | 154.05 | 154.05 | 8235.0 |
| 2023-03-07 08:15:00 | AAPL | Stock | 154.06 | 154.06 | 153.94 | 153.95 | 15128.0 |
| 2023-03-07 08:20:00 | AAPL | Stock | 153.95 | 154.13 | 153.95 | 154.13 | 10445.0 |
| 2023-03-07 08:25:00 | AAPL | Stock | 154.13 | 154.13 | 153.99 | 153.99 | 6983.0 |
| 2023-03-07 08:30:00 | AAPL | Stock | 154.0 | 154.15 | 153.99 | 154.15 | 6700.0 |
| 2023-03-07 08:35:00 | AAPL | Stock | 154.16 | 154.17 | 154.11 | 154.15 | 9622.0 |
| 2023-03-07 08:40:00 | AAPL | Stock | 154.14 | 154.17 | 154.08 | 154.17 | 8806.0 |
| 2023-03-07 08:45:00 | AAPL | Stock | 154.18 | 154.19 | 154.06 | 154.13 | 21733.0 |
| 2023-03-07 08:50:00 | AAPL | Stock | 154.09 | 154.1627 | 154.03 | 154.07 | 7135.0 |
> showing 50 of 409,407 rows — these rows as CSV