PREVIEW / stock_5min / 2024-09-05
file: by_date/stock_5min/2024/2024-09-05.parquet size: 6.3 MB rows: 384,848 symbols: 841
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-09-05 04:00:00 | AAPL | Stock | 220.2 | 220.5 | 220.13 | 220.24 | 3863.0 |
| 2024-09-05 04:05:00 | AAPL | Stock | 220.31 | 220.34 | 220.12 | 220.12 | 1129.0 |
| 2024-09-05 04:10:00 | AAPL | Stock | 220.21 | 220.24 | 220.2 | 220.22 | 509.0 |
| 2024-09-05 04:15:00 | AAPL | Stock | 220.27 | 220.29 | 220.18 | 220.19 | 400.0 |
| 2024-09-05 04:20:00 | AAPL | Stock | 220.27 | 220.33 | 220.26 | 220.26 | 1204.0 |
| 2024-09-05 04:25:00 | AAPL | Stock | 220.34 | 220.34 | 220.34 | 220.34 | 500.0 |
| 2024-09-05 04:30:00 | AAPL | Stock | 220.33 | 220.33 | 220.13 | 220.13 | 762.0 |
| 2024-09-05 04:40:00 | AAPL | Stock | 220.31 | 220.41 | 220.28 | 220.41 | 387.0 |
| 2024-09-05 04:50:00 | AAPL | Stock | 220.31 | 220.36 | 220.31 | 220.36 | 762.0 |
| 2024-09-05 04:55:00 | AAPL | Stock | 220.4 | 220.49 | 220.4 | 220.49 | 400.0 |
| 2024-09-05 05:00:00 | AAPL | Stock | 220.44 | 220.44 | 220.26 | 220.26 | 507.0 |
| 2024-09-05 05:10:00 | AAPL | Stock | 220.2 | 220.2 | 220.08 | 220.13 | 1120.0 |
| 2024-09-05 05:15:00 | AAPL | Stock | 220.28 | 220.28 | 220.03 | 220.03 | 662.0 |
| 2024-09-05 05:20:00 | AAPL | Stock | 220.1 | 220.12 | 220.03 | 220.03 | 857.0 |
| 2024-09-05 05:25:00 | AAPL | Stock | 220.01 | 220.01 | 219.9 | 219.91 | 1059.0 |
| 2024-09-05 05:35:00 | AAPL | Stock | 219.89 | 219.89 | 219.89 | 219.89 | 100.0 |
| 2024-09-05 05:40:00 | AAPL | Stock | 219.9 | 220.03 | 219.9 | 220.03 | 265.0 |
| 2024-09-05 05:45:00 | AAPL | Stock | 220.02 | 220.18 | 220.02 | 220.1 | 895.0 |
| 2024-09-05 05:50:00 | AAPL | Stock | 220.16 | 220.16 | 220.1 | 220.1 | 200.0 |
| 2024-09-05 06:00:00 | AAPL | Stock | 220.17 | 220.18 | 220.17 | 220.17 | 2010.0 |
| 2024-09-05 06:05:00 | AAPL | Stock | 220.18 | 220.2 | 220.12 | 220.2 | 795.0 |
| 2024-09-05 06:15:00 | AAPL | Stock | 220.05 | 220.05 | 220.05 | 220.05 | 447.0 |
| 2024-09-05 06:20:00 | AAPL | Stock | 220.1 | 220.1 | 220.1 | 220.1 | 100.0 |
| 2024-09-05 06:25:00 | AAPL | Stock | 220.04 | 220.04 | 219.95 | 220.03 | 1792.0 |
| 2024-09-05 06:30:00 | AAPL | Stock | 220.0 | 220.6 | 220.0 | 220.58 | 15385.0 |
| 2024-09-05 06:35:00 | AAPL | Stock | 220.59 | 220.93 | 220.54 | 220.92 | 2539.0 |
| 2024-09-05 06:40:00 | AAPL | Stock | 220.9 | 220.9 | 220.69 | 220.75 | 2146.0 |
| 2024-09-05 06:45:00 | AAPL | Stock | 220.84 | 221.0 | 220.84 | 221.0 | 2040.0 |
| 2024-09-05 06:50:00 | AAPL | Stock | 220.99 | 221.37 | 220.99 | 221.37 | 990.0 |
| 2024-09-05 06:55:00 | AAPL | Stock | 221.18 | 221.26 | 221.14 | 221.2 | 500.0 |
| 2024-09-05 07:00:00 | AAPL | Stock | 221.1 | 221.39 | 221.0 | 221.39 | 4699.0 |
| 2024-09-05 07:05:00 | AAPL | Stock | 221.27 | 221.27 | 221.04 | 221.1 | 5684.0 |
| 2024-09-05 07:10:00 | AAPL | Stock | 221.15 | 221.15 | 220.88 | 220.88 | 2416.0 |
| 2024-09-05 07:15:00 | AAPL | Stock | 220.95 | 220.98 | 220.65 | 220.65 | 1541.0 |
| 2024-09-05 07:25:00 | AAPL | Stock | 220.63 | 220.63 | 220.63 | 220.63 | 100.0 |
| 2024-09-05 07:30:00 | AAPL | Stock | 220.8 | 221.14 | 220.8 | 221.05 | 713.0 |
| 2024-09-05 07:35:00 | AAPL | Stock | 221.09 | 221.1 | 221.03 | 221.03 | 1328.0 |
| 2024-09-05 07:40:00 | AAPL | Stock | 220.92 | 220.92 | 220.9 | 220.9 | 999.0 |
| 2024-09-05 07:45:00 | AAPL | Stock | 220.94 | 220.94 | 220.71 | 220.71 | 3910.0 |
| 2024-09-05 07:50:00 | AAPL | Stock | 220.41 | 220.42 | 220.39 | 220.42 | 1055.0 |
| 2024-09-05 07:55:00 | AAPL | Stock | 220.49 | 220.51 | 220.43 | 220.44 | 1500.0 |
| 2024-09-05 08:00:00 | AAPL | Stock | 221.2 | 221.39 | 219.78 | 220.26 | 15695.0 |
| 2024-09-05 08:05:00 | AAPL | Stock | 220.3 | 220.45 | 220.0907 | 220.24 | 35375.0 |
| 2024-09-05 08:10:00 | AAPL | Stock | 220.46 | 220.56 | 220.25 | 220.3 | 3478.0 |
| 2024-09-05 08:15:00 | AAPL | Stock | 220.08 | 220.2878 | 219.5909 | 219.65 | 6529.0 |
| 2024-09-05 08:20:00 | AAPL | Stock | 219.58 | 219.6036 | 219.2355 | 219.25 | 8658.0 |
| 2024-09-05 08:25:00 | AAPL | Stock | 219.16 | 219.75 | 219.15 | 219.75 | 14992.0 |
| 2024-09-05 08:30:00 | AAPL | Stock | 219.86 | 220.8 | 219.75 | 220.44 | 29886.0 |
| 2024-09-05 08:35:00 | AAPL | Stock | 220.4 | 220.48 | 219.8801 | 220.05 | 25943.0 |
| 2024-09-05 08:40:00 | AAPL | Stock | 220.16 | 220.35 | 219.6144 | 220.3 | 6909.0 |
> showing 50 of 384,848 rows — these rows as CSV