PREVIEW / stock_30min / 2005-06-09
file: by_date/stock_30min/2005/2005-06-09.parquet size: 815 KB rows: 44,219 symbols: 1,983
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-09 08:00:00 | AAPL | Stock | 1.3143 | 1.3157 | 1.3143 | 1.3157 | 25900.0 |
| 2005-06-09 08:30:00 | AAPL | Stock | 1.3157 | 1.3157 | 1.3157 | 1.3157 | 25200.0 |
| 2005-06-09 09:00:00 | AAPL | Stock | 1.3168 | 1.3218 | 1.3164 | 1.3196 | 1006432.0 |
| 2005-06-09 09:30:00 | AAPL | Stock | 1.3214 | 1.3339 | 1.3189 | 1.3311 | 41525176.0 |
| 2005-06-09 10:00:00 | AAPL | Stock | 1.3307 | 1.3325 | 1.3175 | 1.3225 | 36406328.0 |
| 2005-06-09 10:30:00 | AAPL | Stock | 1.3221 | 1.3257 | 1.315 | 1.3246 | 28631540.0 |
| 2005-06-09 11:00:00 | AAPL | Stock | 1.3246 | 1.33 | 1.3236 | 1.3286 | 30638832.0 |
| 2005-06-09 11:30:00 | AAPL | Stock | 1.3286 | 1.3346 | 1.3279 | 1.3346 | 26454428.0 |
| 2005-06-09 12:00:00 | AAPL | Stock | 1.3343 | 1.3457 | 1.3343 | 1.3439 | 36891540.0 |
| 2005-06-09 12:30:00 | AAPL | Stock | 1.3443 | 1.3507 | 1.3418 | 1.3493 | 30660336.0 |
| 2005-06-09 13:00:00 | AAPL | Stock | 1.35 | 1.355 | 1.3468 | 1.3475 | 41798288.0 |
| 2005-06-09 13:30:00 | AAPL | Stock | 1.3475 | 1.3486 | 1.3439 | 1.3475 | 21762160.0 |
| 2005-06-09 14:00:00 | AAPL | Stock | 1.3471 | 1.3479 | 1.3411 | 1.3428 | 21437416.0 |
| 2005-06-09 14:30:00 | AAPL | Stock | 1.3429 | 1.3482 | 1.3396 | 1.3454 | 22712732.0 |
| 2005-06-09 15:00:00 | AAPL | Stock | 1.3457 | 1.35 | 1.3443 | 1.345 | 19262544.0 |
| 2005-06-09 15:30:00 | AAPL | Stock | 1.3446 | 1.3475 | 1.3421 | 1.345 | 25682412.0 |
| 2005-06-09 16:00:00 | AAPL | Stock | 1.3446 | 1.3464 | 1.3439 | 1.3464 | 1902712.0 |
| 2005-06-09 16:30:00 | AAPL | Stock | 1.3464 | 1.3464 | 1.3421 | 1.3425 | 372400.0 |
| 2005-06-09 17:00:00 | AAPL | Stock | 1.3425 | 1.3425 | 1.3254 | 1.3321 | 1612660.0 |
| 2005-06-09 17:30:00 | AAPL | Stock | 1.3436 | 1.3436 | 1.3343 | 1.3375 | 141736.0 |
| 2005-06-09 18:00:00 | AAPL | Stock | 1.3393 | 1.3396 | 1.3371 | 1.3371 | 119700.0 |
| 2005-06-09 07:30:00 | MSFT | Stock | 25.4 | 25.4 | 25.4 | 25.4 | 400.0 |
| 2005-06-09 08:00:00 | MSFT | Stock | 25.4 | 25.42 | 25.38 | 25.4 | 3400.0 |
| 2005-06-09 08:30:00 | MSFT | Stock | 25.42 | 25.42 | 25.39 | 25.39 | 1896.0 |
| 2005-06-09 09:00:00 | MSFT | Stock | 25.38 | 25.4 | 25.35 | 25.39 | 66872.0 |
| 2005-06-09 09:30:00 | MSFT | Stock | 25.4 | 25.48 | 25.36 | 25.42 | 5593406.0 |
| 2005-06-09 10:00:00 | MSFT | Stock | 25.42 | 25.47 | 25.38 | 25.4 | 4811547.0 |
| 2005-06-09 10:30:00 | MSFT | Stock | 25.4 | 25.41 | 25.36 | 25.38 | 2805392.0 |
| 2005-06-09 11:00:00 | MSFT | Stock | 25.38 | 25.41 | 25.35 | 25.37 | 2989706.0 |
| 2005-06-09 11:30:00 | MSFT | Stock | 25.37 | 25.45 | 25.37 | 25.432 | 3532327.0 |
| 2005-06-09 12:00:00 | MSFT | Stock | 25.43 | 25.611 | 25.43 | 25.58 | 5175705.0 |
| 2005-06-09 12:30:00 | MSFT | Stock | 25.58 | 25.6 | 25.48 | 25.49 | 3602451.0 |
| 2005-06-09 13:00:00 | MSFT | Stock | 25.48 | 25.49 | 25.36 | 25.41 | 2795315.0 |
| 2005-06-09 13:30:00 | MSFT | Stock | 25.42 | 25.44 | 25.39 | 25.42 | 2980250.0 |
| 2005-06-09 14:00:00 | MSFT | Stock | 25.41 | 25.45 | 25.4 | 25.42 | 2580411.0 |
| 2005-06-09 14:30:00 | MSFT | Stock | 25.43 | 25.49 | 25.41 | 25.442 | 3057679.0 |
| 2005-06-09 15:00:00 | MSFT | Stock | 25.44 | 25.52 | 25.43 | 25.47 | 4212629.0 |
| 2005-06-09 15:30:00 | MSFT | Stock | 25.47 | 25.51 | 25.43 | 25.5 | 6294681.0 |
| 2005-06-09 16:00:00 | MSFT | Stock | 25.5 | 25.58 | 25.44 | 25.47 | 366479.0 |
| 2005-06-09 16:30:00 | MSFT | Stock | 25.49 | 25.49 | 25.49 | 25.49 | 300.0 |
| 2005-06-09 17:00:00 | MSFT | Stock | 25.535 | 25.535 | 25.47 | 25.47 | 10600.0 |
| 2005-06-09 17:30:00 | MSFT | Stock | 25.48 | 25.48 | 25.47 | 25.47 | 1246.0 |
| 2005-06-09 18:00:00 | MSFT | Stock | 25.47 | 25.48 | 25.47 | 25.48 | 507.0 |
| 2005-06-09 09:00:00 | NVDA | Stock | 0.2275 | 0.2275 | 0.2243 | 0.2243 | 889800.0 |
| 2005-06-09 09:30:00 | NVDA | Stock | 0.2246 | 0.2275 | 0.2243 | 0.2274 | 48780960.0 |
| 2005-06-09 10:00:00 | NVDA | Stock | 0.2274 | 0.2292 | 0.2268 | 0.2287 | 67711080.0 |
| 2005-06-09 10:30:00 | NVDA | Stock | 0.2287 | 0.2291 | 0.2277 | 0.229 | 29272320.0 |
| 2005-06-09 11:00:00 | NVDA | Stock | 0.229 | 0.2296 | 0.2285 | 0.2288 | 22840800.0 |
| 2005-06-09 11:30:00 | NVDA | Stock | 0.2288 | 0.2312 | 0.2288 | 0.2311 | 49415280.0 |
| 2005-06-09 12:00:00 | NVDA | Stock | 0.2311 | 0.2331 | 0.2311 | 0.2329 | 47237760.0 |
> showing 50 of 44,219 rows — these rows as CSV