PREVIEW / stock_30min / 2024-09-10
file: by_date/stock_30min/2024/2024-09-10.parquet size: 2.0 MB rows: 95,957 symbols: 860
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-10 04:00:00 | AAPL | Stock | 219.69 | 219.8 | 217.63 | 218.9 | 46419.0 |
| 2024-09-10 04:30:00 | AAPL | Stock | 218.78 | 219.09 | 218.25 | 218.43 | 12602.0 |
| 2024-09-10 05:00:00 | AAPL | Stock | 218.22 | 218.34 | 217.75 | 218.0 | 21879.0 |
| 2024-09-10 05:30:00 | AAPL | Stock | 218.02 | 218.37 | 218.02 | 218.25 | 6116.0 |
| 2024-09-10 06:00:00 | AAPL | Stock | 218.14 | 218.38 | 218.0 | 218.38 | 4404.0 |
| 2024-09-10 06:30:00 | AAPL | Stock | 218.36 | 218.95 | 218.28 | 218.49 | 11124.0 |
| 2024-09-10 07:00:00 | AAPL | Stock | 218.5 | 218.95 | 217.98 | 218.6 | 50913.0 |
| 2024-09-10 07:30:00 | AAPL | Stock | 218.61 | 218.8 | 218.1 | 218.74 | 36682.0 |
| 2024-09-10 08:00:00 | AAPL | Stock | 218.525 | 220.01 | 217.82 | 219.35 | 119040.0 |
| 2024-09-10 08:30:00 | AAPL | Stock | 219.3605 | 219.79 | 219.16 | 219.2 | 65310.0 |
| 2024-09-10 09:00:00 | AAPL | Stock | 219.2 | 219.3 | 218.3 | 218.9 | 162227.0 |
| 2024-09-10 09:30:00 | AAPL | Stock | 218.9 | 220.02 | 216.73 | 217.515 | 6294912.0 |
| 2024-09-10 10:00:00 | AAPL | Stock | 217.5 | 219.975 | 217.46 | 219.78 | 4151810.0 |
| 2024-09-10 10:30:00 | AAPL | Stock | 219.765 | 219.92 | 218.22 | 219.1599 | 2725413.0 |
| 2024-09-10 11:00:00 | AAPL | Stock | 219.15 | 220.22 | 218.944 | 219.95 | 2015422.0 |
| 2024-09-10 11:30:00 | AAPL | Stock | 219.95 | 220.41 | 218.26 | 218.34 | 1906963.0 |
| 2024-09-10 12:00:00 | AAPL | Stock | 218.32 | 218.83 | 218.0404 | 218.54 | 1592843.0 |
| 2024-09-10 12:30:00 | AAPL | Stock | 218.5301 | 219.94 | 218.49 | 219.5461 | 1392553.0 |
| 2024-09-10 13:00:00 | AAPL | Stock | 219.555 | 220.66 | 219.5301 | 220.27 | 1557883.0 |
| 2024-09-10 13:30:00 | AAPL | Stock | 220.27 | 220.9401 | 220.1959 | 220.81 | 1199822.0 |
| 2024-09-10 14:00:00 | AAPL | Stock | 220.81 | 221.48 | 220.64 | 220.82 | 1881953.0 |
| 2024-09-10 14:30:00 | AAPL | Stock | 220.83 | 221.045 | 220.21 | 220.3756 | 1156638.0 |
| 2024-09-10 15:00:00 | AAPL | Stock | 220.37 | 220.85 | 220.22 | 220.75 | 1605319.0 |
| 2024-09-10 15:30:00 | AAPL | Stock | 220.745 | 221.13 | 219.68 | 220.17 | 3663503.0 |
| 2024-09-10 16:00:00 | AAPL | Stock | 220.15 | 220.2 | 219.56 | 219.79 | 8439780.0 |
| 2024-09-10 16:30:00 | AAPL | Stock | 219.76 | 220.11 | 219.66 | 219.9 | 93107.0 |
| 2024-09-10 17:00:00 | AAPL | Stock | 219.84 | 219.84 | 219.7126 | 219.8248 | 7307.0 |
| 2024-09-10 17:30:00 | AAPL | Stock | 219.75 | 219.98 | 219.65 | 219.98 | 5047.0 |
| 2024-09-10 18:00:00 | AAPL | Stock | 219.88 | 219.97 | 219.7537 | 219.9 | 8857.0 |
| 2024-09-10 18:30:00 | AAPL | Stock | 219.8511 | 219.98 | 219.8511 | 219.96 | 4078.0 |
| 2024-09-10 19:00:00 | AAPL | Stock | 219.93 | 220.0 | 219.9281 | 219.95 | 6584.0 |
| 2024-09-10 19:30:00 | AAPL | Stock | 219.99 | 220.0 | 219.64 | 219.74 | 9270.0 |
| 2024-09-10 04:00:00 | MSFT | Stock | 407.2 | 407.2 | 406.6 | 406.65 | 610.0 |
| 2024-09-10 04:30:00 | MSFT | Stock | 407.01 | 407.01 | 406.58 | 406.59 | 2036.0 |
| 2024-09-10 05:00:00 | MSFT | Stock | 406.08 | 406.3 | 406.08 | 406.1 | 1204.0 |
| 2024-09-10 05:30:00 | MSFT | Stock | 406.52 | 407.11 | 406.52 | 407.1 | 852.0 |
| 2024-09-10 06:00:00 | MSFT | Stock | 407.25 | 407.59 | 406.98 | 406.98 | 6070.0 |
| 2024-09-10 06:30:00 | MSFT | Stock | 407.43 | 407.9 | 407.43 | 407.9 | 2021.0 |
| 2024-09-10 07:00:00 | MSFT | Stock | 407.38 | 407.63 | 407.11 | 407.4 | 1859.0 |
| 2024-09-10 07:30:00 | MSFT | Stock | 407.72 | 408.14 | 407.65 | 408.08 | 4479.0 |
| 2024-09-10 08:00:00 | MSFT | Stock | 407.78 | 408.76 | 405.07 | 408.68 | 10253.0 |
| 2024-09-10 08:30:00 | MSFT | Stock | 408.3925 | 409.1537 | 408.3925 | 408.9 | 8400.0 |
| 2024-09-10 09:00:00 | MSFT | Stock | 408.75 | 408.95 | 407.3545 | 407.3545 | 12089.0 |
| 2024-09-10 09:30:00 | MSFT | Stock | 408.03 | 415.35 | 407.7 | 414.27 | 1870337.0 |
| 2024-09-10 10:00:00 | MSFT | Stock | 414.28 | 416.33 | 413.25 | 415.27 | 1072022.0 |
| 2024-09-10 10:30:00 | MSFT | Stock | 415.285 | 415.47 | 412.3 | 412.735 | 654531.0 |
| 2024-09-10 11:00:00 | MSFT | Stock | 412.69 | 413.77 | 411.91 | 413.64 | 367993.0 |
| 2024-09-10 11:30:00 | MSFT | Stock | 413.64 | 414.065 | 409.58 | 409.71 | 473667.0 |
| 2024-09-10 12:00:00 | MSFT | Stock | 409.68 | 410.24 | 408.8 | 409.81 | 388743.0 |
| 2024-09-10 12:30:00 | MSFT | Stock | 409.78 | 411.34 | 409.39 | 410.62 | 308553.0 |
> showing 50 of 95,957 rows — these rows as CSV