PREVIEW / stock_30min / 2001-08-23
file: by_date/stock_30min/2001/2001-08-23.parquet size: 532 KB rows: 28,293 symbols: 1,327
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-08-23 08:00:00 | AAPL | Stock | 0.3257 | 0.3257 | 0.3257 | 0.3257 | 1153600.0 |
| 2001-08-23 09:00:00 | AAPL | Stock | 0.3232 | 0.325 | 0.3232 | 0.325 | 112000.0 |
| 2001-08-23 09:30:00 | AAPL | Stock | 0.325 | 0.3266 | 0.3229 | 0.3246 | 13658400.0 |
| 2001-08-23 10:00:00 | AAPL | Stock | 0.3246 | 0.3275 | 0.3241 | 0.327 | 11429600.0 |
| 2001-08-23 10:30:00 | AAPL | Stock | 0.327 | 0.3273 | 0.3234 | 0.3259 | 15528800.0 |
| 2001-08-23 11:00:00 | AAPL | Stock | 0.3261 | 0.3261 | 0.3236 | 0.3255 | 6484800.0 |
| 2001-08-23 11:30:00 | AAPL | Stock | 0.3255 | 0.3255 | 0.3219 | 0.3222 | 3780000.0 |
| 2001-08-23 12:00:00 | AAPL | Stock | 0.3221 | 0.3229 | 0.3205 | 0.3213 | 7901600.0 |
| 2001-08-23 12:30:00 | AAPL | Stock | 0.3211 | 0.3234 | 0.3205 | 0.3209 | 4849600.0 |
| 2001-08-23 13:00:00 | AAPL | Stock | 0.3207 | 0.3216 | 0.3184 | 0.3188 | 13899200.0 |
| 2001-08-23 13:30:00 | AAPL | Stock | 0.3188 | 0.3193 | 0.3175 | 0.3175 | 8411200.0 |
| 2001-08-23 14:00:00 | AAPL | Stock | 0.3175 | 0.32 | 0.3146 | 0.3164 | 26415200.0 |
| 2001-08-23 14:30:00 | AAPL | Stock | 0.3163 | 0.3195 | 0.3145 | 0.3195 | 26084800.0 |
| 2001-08-23 15:00:00 | AAPL | Stock | 0.3193 | 0.3211 | 0.3179 | 0.3209 | 11586400.0 |
| 2001-08-23 15:30:00 | AAPL | Stock | 0.3211 | 0.3211 | 0.3139 | 0.318 | 13165600.0 |
| 2001-08-23 16:00:00 | AAPL | Stock | 0.318 | 0.3192 | 0.3145 | 0.318 | 11575200.0 |
| 2001-08-23 16:30:00 | AAPL | Stock | 0.3179 | 0.3189 | 0.3179 | 0.318 | 4480000.0 |
| 2001-08-23 17:00:00 | AAPL | Stock | 0.3186 | 0.3189 | 0.318 | 0.318 | 2508800.0 |
| 2001-08-23 17:30:00 | AAPL | Stock | 0.318 | 0.318 | 0.318 | 0.318 | 330400.0 |
| 2001-08-23 18:00:00 | AAPL | Stock | 0.318 | 0.3225 | 0.318 | 0.3225 | 1422400.0 |
| 2001-08-23 08:00:00 | MSFT | Stock | 30.33 | 30.33 | 30.3 | 30.325 | 19200.0 |
| 2001-08-23 08:30:00 | MSFT | Stock | 30.325 | 30.75 | 30.325 | 30.4 | 44800.0 |
| 2001-08-23 09:00:00 | MSFT | Stock | 30.375 | 30.4 | 30.3 | 30.335 | 124600.0 |
| 2001-08-23 09:30:00 | MSFT | Stock | 30.335 | 30.755 | 30.22 | 30.72 | 5190000.0 |
| 2001-08-23 10:00:00 | MSFT | Stock | 30.66 | 30.765 | 30.56 | 30.6 | 3269200.0 |
| 2001-08-23 10:30:00 | MSFT | Stock | 30.6 | 30.645 | 30.395 | 30.51 | 2589400.0 |
| 2001-08-23 11:00:00 | MSFT | Stock | 30.515 | 30.65 | 30.405 | 30.61 | 2778400.0 |
| 2001-08-23 11:30:00 | MSFT | Stock | 30.615 | 30.65 | 30.43 | 30.505 | 1705600.0 |
| 2001-08-23 12:00:00 | MSFT | Stock | 30.5098 | 30.5305 | 30.43 | 30.44 | 1070000.0 |
| 2001-08-23 12:30:00 | MSFT | Stock | 30.4405 | 30.625 | 30.44 | 30.52 | 2391400.0 |
| 2001-08-23 13:00:00 | MSFT | Stock | 30.525 | 30.575 | 30.4 | 30.425 | 1432200.0 |
| 2001-08-23 13:30:00 | MSFT | Stock | 30.43 | 30.52 | 30.375 | 30.415 | 1421000.0 |
| 2001-08-23 14:00:00 | MSFT | Stock | 30.42 | 30.55 | 30.01 | 30.07 | 3049000.0 |
| 2001-08-23 14:30:00 | MSFT | Stock | 30.07 | 30.135 | 29.89 | 30.075 | 2546000.0 |
| 2001-08-23 15:00:00 | MSFT | Stock | 30.075 | 30.195 | 29.96 | 30.09 | 3080600.0 |
| 2001-08-23 15:30:00 | MSFT | Stock | 30.095 | 30.105 | 29.55 | 29.56 | 6140400.0 |
| 2001-08-23 16:00:00 | MSFT | Stock | 29.56 | 30.73 | 29.45 | 29.7 | 4359200.0 |
| 2001-08-23 16:30:00 | MSFT | Stock | 29.6339 | 30.3542 | 29.56 | 29.56 | 1695800.0 |
| 2001-08-23 17:00:00 | MSFT | Stock | 29.875 | 29.875 | 29.56 | 29.75 | 353800.0 |
| 2001-08-23 17:30:00 | MSFT | Stock | 29.56 | 29.95 | 29.56 | 29.95 | 50000.0 |
| 2001-08-23 18:00:00 | MSFT | Stock | 29.95 | 29.985 | 29.56 | 29.97 | 205200.0 |
| 2001-08-23 08:00:00 | NVDA | Stock | 0.3527 | 0.3527 | 0.3525 | 0.3525 | 120000.0 |
| 2001-08-23 08:30:00 | NVDA | Stock | 0.3516 | 0.3552 | 0.3506 | 0.3541 | 2472000.0 |
| 2001-08-23 09:00:00 | NVDA | Stock | 0.3542 | 0.3542 | 0.3503 | 0.3523 | 11760000.0 |
| 2001-08-23 09:30:00 | NVDA | Stock | 0.3523 | 0.3552 | 0.3465 | 0.3548 | 171648000.0 |
| 2001-08-23 10:00:00 | NVDA | Stock | 0.3548 | 0.3566 | 0.3504 | 0.3513 | 127752000.0 |
| 2001-08-23 10:30:00 | NVDA | Stock | 0.3515 | 0.3518 | 0.3479 | 0.3491 | 78648000.0 |
| 2001-08-23 11:00:00 | NVDA | Stock | 0.349 | 0.3518 | 0.3487 | 0.3513 | 30456000.0 |
| 2001-08-23 11:30:00 | NVDA | Stock | 0.3508 | 0.3513 | 0.348 | 0.3496 | 27288000.0 |
| 2001-08-23 12:00:00 | NVDA | Stock | 0.3498 | 0.3513 | 0.3494 | 0.3508 | 25704000.0 |
> showing 50 of 28,293 rows — these rows as CSV