PREVIEW / stock_30min / 2001-04-18
file: by_date/stock_30min/2001/2001-04-18.parquet size: 546 KB rows: 28,609 symbols: 1,292
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-18 08:00:00 | AAPL | Stock | 0.3691 | 0.3818 | 0.3686 | 0.3759 | 996800.0 |
| 2001-04-18 08:30:00 | AAPL | Stock | 0.3759 | 0.3839 | 0.3759 | 0.3795 | 644000.0 |
| 2001-04-18 09:00:00 | AAPL | Stock | 0.3811 | 0.3875 | 0.375 | 0.3843 | 5756800.0 |
| 2001-04-18 09:30:00 | AAPL | Stock | 0.3852 | 0.3884 | 0.3764 | 0.388 | 119772800.0 |
| 2001-04-18 10:00:00 | AAPL | Stock | 0.388 | 0.3939 | 0.3845 | 0.3882 | 101326400.0 |
| 2001-04-18 10:30:00 | AAPL | Stock | 0.3882 | 0.4018 | 0.3836 | 0.3991 | 48395200.0 |
| 2001-04-18 11:00:00 | AAPL | Stock | 0.3975 | 0.4111 | 0.3946 | 0.4107 | 139115200.0 |
| 2001-04-18 11:30:00 | AAPL | Stock | 0.4104 | 0.4179 | 0.408 | 0.4155 | 81732000.0 |
| 2001-04-18 12:00:00 | AAPL | Stock | 0.4155 | 0.4179 | 0.4116 | 0.4177 | 47460000.0 |
| 2001-04-18 12:30:00 | AAPL | Stock | 0.4177 | 0.42 | 0.4168 | 0.4195 | 37200800.0 |
| 2001-04-18 13:00:00 | AAPL | Stock | 0.4184 | 0.4264 | 0.4168 | 0.4241 | 52528000.0 |
| 2001-04-18 13:30:00 | AAPL | Stock | 0.4236 | 0.4259 | 0.4205 | 0.4241 | 37699200.0 |
| 2001-04-18 14:00:00 | AAPL | Stock | 0.4241 | 0.4259 | 0.4229 | 0.4257 | 48277600.0 |
| 2001-04-18 14:30:00 | AAPL | Stock | 0.4257 | 0.4263 | 0.4071 | 0.4086 | 64825600.0 |
| 2001-04-18 15:00:00 | AAPL | Stock | 0.4088 | 0.4136 | 0.398 | 0.3982 | 65066400.0 |
| 2001-04-18 15:30:00 | AAPL | Stock | 0.3986 | 0.4098 | 0.393 | 0.4068 | 95692800.0 |
| 2001-04-18 16:00:00 | AAPL | Stock | 0.4061 | 0.4161 | 0.3839 | 0.407 | 14005600.0 |
| 2001-04-18 16:30:00 | AAPL | Stock | 0.4061 | 0.407 | 0.4061 | 0.407 | 95200.0 |
| 2001-04-18 17:00:00 | AAPL | Stock | 0.425 | 0.4802 | 0.407 | 0.4641 | 40768000.0 |
| 2001-04-18 17:30:00 | AAPL | Stock | 0.4643 | 0.4821 | 0.4593 | 0.4643 | 20680800.0 |
| 2001-04-18 18:00:00 | AAPL | Stock | 0.4643 | 0.4686 | 0.4634 | 0.4675 | 9016000.0 |
| 2001-04-18 08:00:00 | MSFT | Stock | 30.97 | 31.995 | 30.97 | 31.5 | 156000.0 |
| 2001-04-18 08:30:00 | MSFT | Stock | 31.5 | 31.8 | 31.5 | 31.75 | 491400.0 |
| 2001-04-18 09:00:00 | MSFT | Stock | 31.7 | 31.995 | 31.0 | 31.695 | 1610400.0 |
| 2001-04-18 09:30:00 | MSFT | Stock | 31.695 | 31.875 | 31.59 | 31.86 | 23616000.0 |
| 2001-04-18 10:00:00 | MSFT | Stock | 31.855 | 32.045 | 31.82 | 31.945 | 10909200.0 |
| 2001-04-18 10:30:00 | MSFT | Stock | 31.95 | 32.75 | 31.775 | 32.125 | 7231000.0 |
| 2001-04-18 11:00:00 | MSFT | Stock | 32.255 | 32.6 | 31.91 | 32.325 | 23111400.0 |
| 2001-04-18 11:30:00 | MSFT | Stock | 32.33 | 32.625 | 32.3 | 32.55 | 12030000.0 |
| 2001-04-18 12:00:00 | MSFT | Stock | 32.555 | 32.65 | 32.45 | 32.625 | 6467200.0 |
| 2001-04-18 12:30:00 | MSFT | Stock | 32.625 | 32.75 | 32.575 | 32.685 | 5633800.0 |
| 2001-04-18 13:00:00 | MSFT | Stock | 32.685 | 32.885 | 32.65 | 32.87 | 7163400.0 |
| 2001-04-18 13:30:00 | MSFT | Stock | 32.86 | 32.935 | 32.81 | 32.9 | 5534600.0 |
| 2001-04-18 14:00:00 | MSFT | Stock | 32.9 | 32.98 | 32.795 | 32.955 | 6441600.0 |
| 2001-04-18 14:30:00 | MSFT | Stock | 32.955 | 33.15 | 32.925 | 32.95 | 9770000.0 |
| 2001-04-18 15:00:00 | MSFT | Stock | 32.95 | 33.1 | 32.8 | 32.875 | 10482200.0 |
| 2001-04-18 15:30:00 | MSFT | Stock | 32.875 | 32.935 | 32.615 | 32.745 | 13125000.0 |
| 2001-04-18 16:00:00 | MSFT | Stock | 32.72 | 32.9 | 31.75 | 32.715 | 5730400.0 |
| 2001-04-18 16:30:00 | MSFT | Stock | 32.825 | 33.485 | 32.285 | 33.375 | 1025400.0 |
| 2001-04-18 17:00:00 | MSFT | Stock | 33.4 | 33.485 | 33.34 | 33.4 | 113200.0 |
| 2001-04-18 17:30:00 | MSFT | Stock | 33.445 | 33.55 | 33.375 | 33.45 | 84600.0 |
| 2001-04-18 18:00:00 | MSFT | Stock | 33.45 | 33.5 | 33.35 | 33.45 | 16200.0 |
| 2001-04-18 08:00:00 | NVDA | Stock | 0.3083 | 0.3142 | 0.3083 | 0.3106 | 1392000.0 |
| 2001-04-18 08:30:00 | NVDA | Stock | 0.3107 | 0.3147 | 0.3104 | 0.3117 | 3288000.0 |
| 2001-04-18 09:00:00 | NVDA | Stock | 0.3125 | 0.3135 | 0.3089 | 0.3122 | 8952000.0 |
| 2001-04-18 09:30:00 | NVDA | Stock | 0.3122 | 0.324 | 0.3122 | 0.3238 | 212688000.0 |
| 2001-04-18 10:00:00 | NVDA | Stock | 0.324 | 0.3269 | 0.3217 | 0.3258 | 166584000.0 |
| 2001-04-18 10:30:00 | NVDA | Stock | 0.3258 | 0.3333 | 0.3201 | 0.3292 | 153576000.0 |
| 2001-04-18 11:00:00 | NVDA | Stock | 0.33 | 0.3354 | 0.3292 | 0.3314 | 196056000.0 |
| 2001-04-18 11:30:00 | NVDA | Stock | 0.3312 | 0.334 | 0.3281 | 0.3308 | 159384000.0 |
> showing 50 of 28,609 rows — these rows as CSV