PREVIEW / stock_5min / 2024-04-04
file: by_date/stock_5min/2024/2024-04-04.parquet size: 6.7 MB rows: 406,837 symbols: 1,042
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-04-04 04:00:00 | AAPL | Stock | 169.99 | 170.1 | 169.99 | 170.1 | 2237.0 |
| 2024-04-04 04:05:00 | AAPL | Stock | 170.13 | 170.13 | 170.06 | 170.06 | 1166.0 |
| 2024-04-04 04:10:00 | AAPL | Stock | 170.13 | 170.13 | 170.01 | 170.01 | 687.0 |
| 2024-04-04 04:15:00 | AAPL | Stock | 169.91 | 169.91 | 169.9 | 169.9 | 254.0 |
| 2024-04-04 04:20:00 | AAPL | Stock | 170.01 | 170.01 | 169.94 | 170.0 | 621.0 |
| 2024-04-04 04:35:00 | AAPL | Stock | 170.15 | 170.15 | 170.13 | 170.13 | 200.0 |
| 2024-04-04 04:40:00 | AAPL | Stock | 170.1 | 170.12 | 170.1 | 170.12 | 480.0 |
| 2024-04-04 04:45:00 | AAPL | Stock | 170.18 | 170.18 | 170.18 | 170.18 | 149.0 |
| 2024-04-04 04:55:00 | AAPL | Stock | 170.05 | 170.06 | 170.05 | 170.06 | 687.0 |
| 2024-04-04 05:05:00 | AAPL | Stock | 170.06 | 170.06 | 170.06 | 170.06 | 100.0 |
| 2024-04-04 05:10:00 | AAPL | Stock | 170.1 | 170.1 | 170.1 | 170.1 | 103.0 |
| 2024-04-04 05:15:00 | AAPL | Stock | 170.13 | 170.2 | 170.13 | 170.2 | 1116.0 |
| 2024-04-04 05:20:00 | AAPL | Stock | 170.15 | 170.15 | 170.15 | 170.15 | 100.0 |
| 2024-04-04 05:25:00 | AAPL | Stock | 170.15 | 170.15 | 170.15 | 170.15 | 723.0 |
| 2024-04-04 05:30:00 | AAPL | Stock | 170.15 | 170.19 | 170.15 | 170.19 | 950.0 |
| 2024-04-04 06:00:00 | AAPL | Stock | 170.05 | 170.12 | 170.05 | 170.12 | 1200.0 |
| 2024-04-04 06:05:00 | AAPL | Stock | 170.0 | 170.0 | 170.0 | 170.0 | 500.0 |
| 2024-04-04 06:10:00 | AAPL | Stock | 170.01 | 170.01 | 170.01 | 170.01 | 200.0 |
| 2024-04-04 06:15:00 | AAPL | Stock | 170.1 | 170.1 | 170.1 | 170.1 | 400.0 |
| 2024-04-04 06:30:00 | AAPL | Stock | 170.08 | 170.08 | 170.08 | 170.08 | 100.0 |
| 2024-04-04 06:35:00 | AAPL | Stock | 170.0 | 170.0 | 170.0 | 170.0 | 225.0 |
| 2024-04-04 06:40:00 | AAPL | Stock | 170.0 | 170.0 | 170.0 | 170.0 | 100.0 |
| 2024-04-04 06:50:00 | AAPL | Stock | 170.02 | 170.12 | 170.02 | 170.12 | 525.0 |
| 2024-04-04 06:55:00 | AAPL | Stock | 170.12 | 170.14 | 170.12 | 170.14 | 227.0 |
| 2024-04-04 07:00:00 | AAPL | Stock | 170.2 | 170.3 | 170.2 | 170.3 | 2735.0 |
| 2024-04-04 07:05:00 | AAPL | Stock | 170.31 | 170.31 | 170.19 | 170.2 | 4107.0 |
| 2024-04-04 07:10:00 | AAPL | Stock | 170.22 | 170.26 | 170.22 | 170.25 | 1165.0 |
| 2024-04-04 07:15:00 | AAPL | Stock | 170.22 | 170.22 | 170.14 | 170.14 | 333.0 |
| 2024-04-04 07:20:00 | AAPL | Stock | 170.12 | 170.12 | 170.11 | 170.11 | 885.0 |
| 2024-04-04 07:25:00 | AAPL | Stock | 170.11 | 170.17 | 170.1 | 170.17 | 1948.0 |
| 2024-04-04 07:30:00 | AAPL | Stock | 170.2 | 170.2 | 170.2 | 170.2 | 423.0 |
| 2024-04-04 07:35:00 | AAPL | Stock | 170.24 | 170.25 | 170.24 | 170.25 | 2598.0 |
| 2024-04-04 07:40:00 | AAPL | Stock | 170.3 | 170.3 | 170.27 | 170.27 | 1050.0 |
| 2024-04-04 07:45:00 | AAPL | Stock | 170.29 | 170.29 | 170.24 | 170.24 | 744.0 |
| 2024-04-04 07:50:00 | AAPL | Stock | 170.22 | 170.23 | 170.22 | 170.23 | 1088.0 |
| 2024-04-04 07:55:00 | AAPL | Stock | 170.21 | 170.23 | 170.2 | 170.2 | 660.0 |
| 2024-04-04 08:00:00 | AAPL | Stock | 170.19 | 170.42 | 169.83 | 170.1 | 20261.0 |
| 2024-04-04 08:05:00 | AAPL | Stock | 170.14 | 170.21 | 170.14 | 170.2 | 2558.0 |
| 2024-04-04 08:10:00 | AAPL | Stock | 170.19 | 170.19 | 170.13 | 170.13 | 4117.0 |
| 2024-04-04 08:15:00 | AAPL | Stock | 170.15 | 170.15 | 170.11 | 170.11 | 673.0 |
| 2024-04-04 08:20:00 | AAPL | Stock | 170.11 | 170.13 | 170.06 | 170.1 | 4290.0 |
| 2024-04-04 08:25:00 | AAPL | Stock | 170.14 | 170.18 | 170.14 | 170.18 | 400.0 |
| 2024-04-04 08:30:00 | AAPL | Stock | 170.19 | 170.45 | 170.13 | 170.45 | 8728.0 |
| 2024-04-04 08:35:00 | AAPL | Stock | 170.38 | 170.5 | 170.38 | 170.43 | 5886.0 |
| 2024-04-04 08:40:00 | AAPL | Stock | 170.42 | 170.54 | 170.42 | 170.51 | 11394.0 |
| 2024-04-04 08:45:00 | AAPL | Stock | 170.53 | 170.66 | 170.49 | 170.66 | 12252.0 |
| 2024-04-04 08:50:00 | AAPL | Stock | 170.62 | 170.7 | 170.58 | 170.63 | 5630.0 |
| 2024-04-04 08:55:00 | AAPL | Stock | 170.66 | 170.79 | 170.65 | 170.75 | 18586.0 |
| 2024-04-04 09:00:00 | AAPL | Stock | 170.75 | 170.84 | 170.66 | 170.6603 | 14673.0 |
| 2024-04-04 09:05:00 | AAPL | Stock | 170.78 | 170.81 | 170.69 | 170.8 | 6863.0 |
> showing 50 of 406,837 rows — these rows as CSV