PREVIEW / stock_30min / 2024-02-14
file: by_date/stock_30min/2024/2024-02-14.parquet size: 2.1 MB rows: 101,001 symbols: 1,136
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-02-14 04:00:00 | AAPL | Stock | 185.43 | 185.65 | 185.42 | 185.58 | 7067.0 |
| 2024-02-14 04:30:00 | AAPL | Stock | 185.58 | 185.65 | 185.58 | 185.61 | 4827.0 |
| 2024-02-14 05:00:00 | AAPL | Stock | 185.61 | 185.61 | 185.33 | 185.45 | 6291.0 |
| 2024-02-14 05:30:00 | AAPL | Stock | 185.46 | 185.65 | 185.4 | 185.54 | 4859.0 |
| 2024-02-14 06:00:00 | AAPL | Stock | 185.5 | 185.5 | 185.35 | 185.38 | 3053.0 |
| 2024-02-14 06:30:00 | AAPL | Stock | 185.42 | 185.5 | 185.36 | 185.5 | 3201.0 |
| 2024-02-14 07:00:00 | AAPL | Stock | 185.5 | 185.9 | 185.5 | 185.75 | 12579.0 |
| 2024-02-14 07:30:00 | AAPL | Stock | 185.75 | 185.75 | 185.39 | 185.51 | 27357.0 |
| 2024-02-14 08:00:00 | AAPL | Stock | 185.79 | 185.94 | 185.24 | 185.39 | 53462.0 |
| 2024-02-14 08:30:00 | AAPL | Stock | 185.4 | 185.45 | 185.21 | 185.3 | 46736.0 |
| 2024-02-14 09:00:00 | AAPL | Stock | 185.36 | 185.45 | 185.04 | 185.3 | 78047.0 |
| 2024-02-14 09:30:00 | AAPL | Stock | 185.32 | 185.53 | 183.91 | 184.02 | 4694311.0 |
| 2024-02-14 10:00:00 | AAPL | Stock | 184.03 | 184.27 | 183.42 | 183.8 | 3935394.0 |
| 2024-02-14 10:30:00 | AAPL | Stock | 183.805 | 183.96 | 183.11 | 183.1801 | 3283172.0 |
| 2024-02-14 11:00:00 | AAPL | Stock | 183.185 | 183.59 | 182.8035 | 183.49 | 2855919.0 |
| 2024-02-14 11:30:00 | AAPL | Stock | 183.49 | 183.6 | 182.93 | 182.995 | 1988648.0 |
| 2024-02-14 12:00:00 | AAPL | Stock | 183.0 | 183.015 | 182.51 | 182.8 | 2251558.0 |
| 2024-02-14 12:30:00 | AAPL | Stock | 182.8 | 182.9274 | 182.55 | 182.715 | 1597760.0 |
| 2024-02-14 13:00:00 | AAPL | Stock | 182.72 | 182.886 | 182.44 | 182.57 | 1831041.0 |
| 2024-02-14 13:30:00 | AAPL | Stock | 182.58 | 183.16 | 182.53 | 182.95 | 1599820.0 |
| 2024-02-14 14:00:00 | AAPL | Stock | 182.95 | 183.19 | 182.49 | 183.15 | 1676270.0 |
| 2024-02-14 14:30:00 | AAPL | Stock | 183.16 | 183.21 | 182.81 | 182.9176 | 1702119.0 |
| 2024-02-14 15:00:00 | AAPL | Stock | 182.92 | 183.56 | 182.83 | 183.525 | 2008924.0 |
| 2024-02-14 15:30:00 | AAPL | Stock | 183.53 | 184.27 | 183.4245 | 184.02 | 5223339.0 |
| 2024-02-14 16:00:00 | AAPL | Stock | 184.04 | 184.49 | 181.88 | 183.13 | 6427828.0 |
| 2024-02-14 16:30:00 | AAPL | Stock | 183.18 | 184.15 | 182.5 | 182.64 | 207410.0 |
| 2024-02-14 17:00:00 | AAPL | Stock | 182.61 | 184.15 | 182.42 | 183.06 | 447853.0 |
| 2024-02-14 17:30:00 | AAPL | Stock | 183.05 | 183.3074 | 182.8896 | 183.3 | 50742.0 |
| 2024-02-14 18:00:00 | AAPL | Stock | 183.3 | 183.35 | 183.25 | 183.28 | 47548.0 |
| 2024-02-14 18:30:00 | AAPL | Stock | 183.25 | 183.29 | 183.12 | 183.12 | 14184.0 |
| 2024-02-14 19:00:00 | AAPL | Stock | 183.14 | 183.3 | 183.12 | 183.24 | 11029.0 |
| 2024-02-14 19:30:00 | AAPL | Stock | 183.2099 | 183.2895 | 183.1001 | 183.13 | 13885.0 |
| 2024-02-14 04:00:00 | MSFT | Stock | 408.85 | 409.86 | 408.85 | 409.86 | 1270.0 |
| 2024-02-14 04:30:00 | MSFT | Stock | 409.94 | 410.75 | 409.94 | 410.68 | 3022.0 |
| 2024-02-14 05:00:00 | MSFT | Stock | 410.62 | 411.19 | 410.62 | 410.86 | 5311.0 |
| 2024-02-14 05:30:00 | MSFT | Stock | 410.75 | 410.75 | 410.38 | 410.72 | 2975.0 |
| 2024-02-14 06:00:00 | MSFT | Stock | 410.6 | 410.6 | 409.95 | 409.95 | 2860.0 |
| 2024-02-14 06:30:00 | MSFT | Stock | 410.0 | 410.0 | 409.8 | 410.0 | 1866.0 |
| 2024-02-14 07:00:00 | MSFT | Stock | 410.15 | 410.15 | 409.0 | 409.59 | 12777.0 |
| 2024-02-14 07:30:00 | MSFT | Stock | 409.53 | 409.63 | 409.05 | 409.05 | 13970.0 |
| 2024-02-14 08:00:00 | MSFT | Stock | 409.59 | 409.9 | 407.54 | 408.6 | 43451.0 |
| 2024-02-14 08:30:00 | MSFT | Stock | 408.75 | 408.84 | 408.0 | 408.43 | 20584.0 |
| 2024-02-14 09:00:00 | MSFT | Stock | 408.73 | 408.7997 | 408.1 | 408.1 | 28419.0 |
| 2024-02-14 09:30:00 | MSFT | Stock | 408.07 | 408.77 | 404.57 | 405.31 | 2359570.0 |
| 2024-02-14 10:00:00 | MSFT | Stock | 405.325 | 407.0239 | 405.04 | 406.89 | 1485623.0 |
| 2024-02-14 10:30:00 | MSFT | Stock | 406.92 | 407.18 | 405.68 | 405.76 | 840977.0 |
| 2024-02-14 11:00:00 | MSFT | Stock | 405.75 | 406.7728 | 405.47 | 406.7 | 585685.0 |
| 2024-02-14 11:30:00 | MSFT | Stock | 406.7 | 406.89 | 405.19 | 405.41 | 611562.0 |
| 2024-02-14 12:00:00 | MSFT | Stock | 405.45 | 407.15 | 405.03 | 407.12 | 552958.0 |
| 2024-02-14 12:30:00 | MSFT | Stock | 407.12 | 407.57 | 406.9 | 407.06 | 413867.0 |
> showing 50 of 101,001 rows — these rows as CSV