PREVIEW / stock_30min / 2024-03-08
file: by_date/stock_30min/2024/2024-03-08.parquet size: 2.1 MB rows: 100,846 symbols: 1,099
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-03-08 04:00:00 | AAPL | Stock | 169.6 | 169.6 | 169.29 | 169.4 | 14398.0 |
| 2024-03-08 04:30:00 | AAPL | Stock | 169.38 | 169.59 | 169.38 | 169.49 | 6822.0 |
| 2024-03-08 05:00:00 | AAPL | Stock | 169.46 | 169.59 | 169.46 | 169.56 | 5650.0 |
| 2024-03-08 05:30:00 | AAPL | Stock | 169.6 | 170.19 | 169.6 | 170.07 | 10001.0 |
| 2024-03-08 06:00:00 | AAPL | Stock | 170.0 | 170.28 | 169.88 | 169.88 | 18737.0 |
| 2024-03-08 06:30:00 | AAPL | Stock | 169.84 | 169.92 | 169.63 | 169.65 | 5989.0 |
| 2024-03-08 07:00:00 | AAPL | Stock | 169.64 | 169.7 | 169.29 | 169.38 | 26948.0 |
| 2024-03-08 07:30:00 | AAPL | Stock | 169.37 | 169.72 | 169.36 | 169.72 | 20636.0 |
| 2024-03-08 08:00:00 | AAPL | Stock | 169.48 | 170.0 | 169.01 | 169.83 | 138609.0 |
| 2024-03-08 08:30:00 | AAPL | Stock | 169.85 | 170.47 | 169.4 | 170.16 | 242006.0 |
| 2024-03-08 09:00:00 | AAPL | Stock | 170.16 | 170.22 | 168.98 | 168.98 | 251611.0 |
| 2024-03-08 09:30:00 | AAPL | Stock | 168.98 | 170.86 | 168.94 | 170.73 | 7219597.0 |
| 2024-03-08 10:00:00 | AAPL | Stock | 170.74 | 171.849 | 170.65 | 171.78 | 5389317.0 |
| 2024-03-08 10:30:00 | AAPL | Stock | 171.78 | 171.9 | 171.02 | 171.3687 | 2981299.0 |
| 2024-03-08 11:00:00 | AAPL | Stock | 171.36 | 172.05 | 171.17 | 171.62 | 4093676.0 |
| 2024-03-08 11:30:00 | AAPL | Stock | 171.62 | 172.48 | 170.93 | 171.49 | 4717760.0 |
| 2024-03-08 12:00:00 | AAPL | Stock | 171.48 | 172.77 | 171.36 | 172.715 | 3936621.0 |
| 2024-03-08 12:30:00 | AAPL | Stock | 172.72 | 172.79 | 171.73 | 171.84 | 3149450.0 |
| 2024-03-08 13:00:00 | AAPL | Stock | 171.84 | 172.38 | 171.71 | 172.23 | 2463810.0 |
| 2024-03-08 13:30:00 | AAPL | Stock | 172.235 | 172.49 | 172.09 | 172.4217 | 2425999.0 |
| 2024-03-08 14:00:00 | AAPL | Stock | 172.43 | 173.5 | 172.396 | 173.47 | 3969967.0 |
| 2024-03-08 14:30:00 | AAPL | Stock | 173.47 | 173.7 | 172.7 | 172.711 | 3430316.0 |
| 2024-03-08 15:00:00 | AAPL | Stock | 172.71 | 172.97 | 171.345 | 171.4 | 3989332.0 |
| 2024-03-08 15:30:00 | AAPL | Stock | 171.41 | 171.7328 | 170.72 | 170.74 | 7492760.0 |
| 2024-03-08 16:00:00 | AAPL | Stock | 170.73 | 171.17 | 170.73 | 171.07 | 6971137.0 |
| 2024-03-08 16:30:00 | AAPL | Stock | 171.08 | 171.12 | 170.73 | 171.09 | 106761.0 |
| 2024-03-08 17:00:00 | AAPL | Stock | 171.1 | 171.16 | 171.0103 | 171.03 | 22899.0 |
| 2024-03-08 17:30:00 | AAPL | Stock | 171.05 | 171.05 | 170.75 | 170.99 | 24419.0 |
| 2024-03-08 18:00:00 | AAPL | Stock | 170.98 | 170.99 | 170.84 | 170.9 | 10677.0 |
| 2024-03-08 18:30:00 | AAPL | Stock | 170.92 | 170.92 | 170.6481 | 170.6481 | 25035.0 |
| 2024-03-08 19:00:00 | AAPL | Stock | 170.69 | 170.71 | 170.46 | 170.46 | 29290.0 |
| 2024-03-08 19:30:00 | AAPL | Stock | 170.46 | 170.48 | 170.0 | 170.48 | 49487.0 |
| 2024-03-08 04:00:00 | MSFT | Stock | 409.84 | 409.84 | 408.2 | 408.4 | 936.0 |
| 2024-03-08 04:30:00 | MSFT | Stock | 408.76 | 409.1 | 408.76 | 409.1 | 945.0 |
| 2024-03-08 05:00:00 | MSFT | Stock | 409.08 | 409.09 | 408.02 | 408.02 | 8287.0 |
| 2024-03-08 05:30:00 | MSFT | Stock | 408.0 | 408.0 | 407.35 | 407.65 | 1493.0 |
| 2024-03-08 06:00:00 | MSFT | Stock | 407.5 | 407.5 | 407.35 | 407.35 | 579.0 |
| 2024-03-08 06:30:00 | MSFT | Stock | 407.2 | 407.2 | 407.0 | 407.02 | 4674.0 |
| 2024-03-08 07:00:00 | MSFT | Stock | 407.41 | 408.0 | 407.19 | 407.36 | 2723.0 |
| 2024-03-08 07:30:00 | MSFT | Stock | 407.07 | 407.5 | 407.05 | 407.5 | 2401.0 |
| 2024-03-08 08:00:00 | MSFT | Stock | 407.28 | 409.04 | 407.0501 | 407.66 | 14090.0 |
| 2024-03-08 08:30:00 | MSFT | Stock | 407.6 | 409.19 | 406.15 | 407.84 | 23184.0 |
| 2024-03-08 09:00:00 | MSFT | Stock | 407.9866 | 408.65 | 407.15 | 407.84 | 39309.0 |
| 2024-03-08 09:30:00 | MSFT | Stock | 407.83 | 409.19 | 406.63 | 409.08 | 1458197.0 |
| 2024-03-08 10:00:00 | MSFT | Stock | 409.08 | 410.42 | 408.99 | 410.075 | 904891.0 |
| 2024-03-08 10:30:00 | MSFT | Stock | 410.1227 | 410.16 | 408.36 | 408.8201 | 826551.0 |
| 2024-03-08 11:00:00 | MSFT | Stock | 408.84 | 408.8775 | 407.4001 | 408.0 | 776803.0 |
| 2024-03-08 11:30:00 | MSFT | Stock | 407.91 | 408.9099 | 406.53 | 407.285 | 780148.0 |
| 2024-03-08 12:00:00 | MSFT | Stock | 407.29 | 408.32 | 406.83 | 408.02 | 448085.0 |
| 2024-03-08 12:30:00 | MSFT | Stock | 408.05 | 408.11 | 404.5501 | 405.15 | 539618.0 |
> showing 50 of 100,846 rows — these rows as CSV