PREVIEW / stock_30min / 2006-08-08
file: by_date/stock_30min/2006/2006-08-08.parquet size: 913 KB rows: 49,784 symbols: 2,337
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-08 06:00:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.3929 | 2.3929 | 65800.0 |
| 2006-08-08 07:00:00 | AAPL | Stock | 2.3946 | 2.3946 | 2.3946 | 2.3946 | 2800.0 |
| 2006-08-08 07:30:00 | AAPL | Stock | 2.3957 | 2.3957 | 2.3957 | 2.3957 | 2800.0 |
| 2006-08-08 08:00:00 | AAPL | Stock | 2.4004 | 2.4004 | 2.385 | 2.3964 | 1368360.0 |
| 2006-08-08 08:30:00 | AAPL | Stock | 2.3957 | 2.3964 | 2.3904 | 2.3964 | 507220.0 |
| 2006-08-08 09:00:00 | AAPL | Stock | 2.4 | 2.4064 | 2.3893 | 2.3961 | 1377208.0 |
| 2006-08-08 09:30:00 | AAPL | Stock | 2.3961 | 2.3969 | 2.3618 | 2.3814 | 108069920.0 |
| 2006-08-08 10:00:00 | AAPL | Stock | 2.3814 | 2.3846 | 2.3675 | 2.3729 | 60734520.0 |
| 2006-08-08 10:30:00 | AAPL | Stock | 2.3729 | 2.3854 | 2.3689 | 2.3814 | 40133884.0 |
| 2006-08-08 11:00:00 | AAPL | Stock | 2.3811 | 2.3861 | 2.3754 | 2.3821 | 35259560.0 |
| 2006-08-08 11:30:00 | AAPL | Stock | 2.3814 | 2.3854 | 2.3736 | 2.3754 | 28199948.0 |
| 2006-08-08 12:00:00 | AAPL | Stock | 2.3757 | 2.3832 | 2.3754 | 2.3768 | 21773332.0 |
| 2006-08-08 12:30:00 | AAPL | Stock | 2.3771 | 2.3804 | 2.3739 | 2.3796 | 18682496.0 |
| 2006-08-08 13:00:00 | AAPL | Stock | 2.3793 | 2.3796 | 2.3625 | 2.3636 | 36226792.0 |
| 2006-08-08 13:30:00 | AAPL | Stock | 2.3636 | 2.3711 | 2.3557 | 2.3571 | 52875956.0 |
| 2006-08-08 14:00:00 | AAPL | Stock | 2.3571 | 2.3796 | 2.3229 | 2.3421 | 158980500.0 |
| 2006-08-08 14:30:00 | AAPL | Stock | 2.342 | 2.3707 | 2.3275 | 2.3354 | 143036936.0 |
| 2006-08-08 15:00:00 | AAPL | Stock | 2.335 | 2.3404 | 2.315 | 2.3179 | 118359668.0 |
| 2006-08-08 15:30:00 | AAPL | Stock | 2.3175 | 2.3771 | 2.3039 | 2.3136 | 153831636.0 |
| 2006-08-08 16:00:00 | AAPL | Stock | 2.3139 | 2.3161 | 2.3104 | 2.3143 | 5397280.0 |
| 2006-08-08 16:30:00 | AAPL | Stock | 2.3143 | 2.3271 | 2.3121 | 2.3257 | 1016596.0 |
| 2006-08-08 17:00:00 | AAPL | Stock | 2.3254 | 2.3275 | 2.3232 | 2.3268 | 301364.0 |
| 2006-08-08 17:30:00 | AAPL | Stock | 2.3268 | 2.3282 | 2.325 | 2.3268 | 217672.0 |
| 2006-08-08 18:00:00 | AAPL | Stock | 2.3268 | 2.3304 | 2.3236 | 2.3236 | 77000.0 |
| 2006-08-08 08:00:00 | MSFT | Stock | 24.3 | 24.44 | 24.3 | 24.38 | 2423.0 |
| 2006-08-08 08:30:00 | MSFT | Stock | 24.32 | 24.32 | 24.3 | 24.31 | 2666.0 |
| 2006-08-08 09:00:00 | MSFT | Stock | 24.34 | 24.4 | 24.28 | 24.4 | 74012.0 |
| 2006-08-08 09:30:00 | MSFT | Stock | 24.39 | 24.46 | 24.33 | 24.4 | 3947338.0 |
| 2006-08-08 10:00:00 | MSFT | Stock | 24.41 | 24.52 | 24.4 | 24.46 | 5261060.0 |
| 2006-08-08 10:30:00 | MSFT | Stock | 24.46 | 24.5 | 24.35 | 24.44 | 1875607.0 |
| 2006-08-08 11:00:00 | MSFT | Stock | 24.43 | 24.49 | 24.43 | 24.49 | 3805633.0 |
| 2006-08-08 11:30:00 | MSFT | Stock | 24.482 | 24.49 | 24.43 | 24.43 | 1023358.0 |
| 2006-08-08 12:00:00 | MSFT | Stock | 24.437 | 24.48 | 24.43 | 24.46 | 954802.0 |
| 2006-08-08 12:30:00 | MSFT | Stock | 24.46 | 24.49 | 24.43 | 24.46 | 1978835.0 |
| 2006-08-08 13:00:00 | MSFT | Stock | 24.46 | 24.46 | 24.44 | 24.45 | 1213989.0 |
| 2006-08-08 13:30:00 | MSFT | Stock | 24.45 | 24.46 | 24.38 | 24.43 | 2263031.0 |
| 2006-08-08 14:00:00 | MSFT | Stock | 24.43 | 24.51 | 24.2 | 24.32 | 6987422.0 |
| 2006-08-08 14:30:00 | MSFT | Stock | 24.32 | 24.45 | 24.27 | 24.32 | 5366307.0 |
| 2006-08-08 15:00:00 | MSFT | Stock | 24.32 | 24.36 | 24.26 | 24.33 | 3694224.0 |
| 2006-08-08 15:30:00 | MSFT | Stock | 24.33 | 24.42 | 24.26 | 24.35 | 5791919.0 |
| 2006-08-08 16:00:00 | MSFT | Stock | 24.35 | 24.37 | 24.32 | 24.34 | 51920.0 |
| 2006-08-08 16:30:00 | MSFT | Stock | 24.34 | 24.42 | 24.34 | 24.42 | 17000.0 |
| 2006-08-08 17:00:00 | MSFT | Stock | 24.4 | 24.4 | 24.38 | 24.38 | 2100.0 |
| 2006-08-08 17:30:00 | MSFT | Stock | 24.37 | 24.38 | 24.37 | 24.38 | 1951.0 |
| 2006-08-08 18:00:00 | MSFT | Stock | 24.4 | 24.4 | 24.4 | 24.4 | 999.0 |
| 2006-08-08 09:00:00 | NVDA | Stock | 0.3972 | 0.3983 | 0.3958 | 0.3983 | 503460.0 |
| 2006-08-08 09:30:00 | NVDA | Stock | 0.3983 | 0.4058 | 0.3973 | 0.4052 | 71080020.0 |
| 2006-08-08 10:00:00 | NVDA | Stock | 0.405 | 0.4128 | 0.4048 | 0.4108 | 58907820.0 |
| 2006-08-08 10:30:00 | NVDA | Stock | 0.4108 | 0.4142 | 0.407 | 0.4103 | 65303760.0 |
| 2006-08-08 11:00:00 | NVDA | Stock | 0.4105 | 0.4127 | 0.4097 | 0.4108 | 35888340.0 |
> showing 50 of 49,784 rows — these rows as CSV