PREVIEW / stock_30min / 2006-04-24
file: by_date/stock_30min/2006/2006-04-24.parquet size: 919 KB rows: 49,423 symbols: 2,246
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-04-24 08:00:00 | AAPL | Stock | 2.3864 | 2.3893 | 2.3857 | 2.3868 | 375900.0 |
| 2006-04-24 08:30:00 | AAPL | Stock | 2.3868 | 2.3964 | 2.3857 | 2.3893 | 1446592.0 |
| 2006-04-24 09:00:00 | AAPL | Stock | 2.3896 | 2.3925 | 2.3857 | 2.3907 | 804832.0 |
| 2006-04-24 09:30:00 | AAPL | Stock | 2.3875 | 2.39 | 2.3486 | 2.3543 | 100119460.0 |
| 2006-04-24 10:00:00 | AAPL | Stock | 2.3546 | 2.3887 | 2.3532 | 2.37 | 67911620.0 |
| 2006-04-24 10:30:00 | AAPL | Stock | 2.37 | 2.3889 | 2.3664 | 2.3779 | 60803064.0 |
| 2006-04-24 11:00:00 | AAPL | Stock | 2.3775 | 2.3811 | 2.3586 | 2.3671 | 54309136.0 |
| 2006-04-24 11:30:00 | AAPL | Stock | 2.3682 | 2.3732 | 2.3514 | 2.3546 | 47609016.0 |
| 2006-04-24 12:00:00 | AAPL | Stock | 2.3543 | 2.3589 | 2.345 | 2.3546 | 37249016.0 |
| 2006-04-24 12:30:00 | AAPL | Stock | 2.355 | 2.37 | 2.3525 | 2.3632 | 35068124.0 |
| 2006-04-24 13:00:00 | AAPL | Stock | 2.3636 | 2.3636 | 2.3532 | 2.3593 | 27909420.0 |
| 2006-04-24 13:30:00 | AAPL | Stock | 2.3593 | 2.3614 | 2.3521 | 2.3528 | 24685724.0 |
| 2006-04-24 14:00:00 | AAPL | Stock | 2.3525 | 2.36 | 2.3489 | 2.3521 | 34051556.0 |
| 2006-04-24 14:30:00 | AAPL | Stock | 2.3525 | 2.3561 | 2.3414 | 2.3432 | 41890044.0 |
| 2006-04-24 15:00:00 | AAPL | Stock | 2.3432 | 2.3561 | 2.3393 | 2.3532 | 48320300.0 |
| 2006-04-24 15:30:00 | AAPL | Stock | 2.3532 | 2.3621 | 2.3471 | 2.3496 | 76395984.0 |
| 2006-04-24 16:00:00 | AAPL | Stock | 2.3511 | 2.3518 | 2.3482 | 2.3518 | 2708832.0 |
| 2006-04-24 16:30:00 | AAPL | Stock | 2.3518 | 2.3529 | 2.3504 | 2.3507 | 245252.0 |
| 2006-04-24 17:00:00 | AAPL | Stock | 2.3511 | 2.3518 | 2.3482 | 2.3486 | 3826200.0 |
| 2006-04-24 17:30:00 | AAPL | Stock | 2.35 | 2.3511 | 2.35 | 2.3511 | 144788.0 |
| 2006-04-24 18:00:00 | AAPL | Stock | 2.3511 | 2.3536 | 2.3511 | 2.3536 | 135212.0 |
| 2006-04-24 06:00:00 | MSFT | Stock | 27.03 | 27.03 | 27.03 | 27.03 | 900.0 |
| 2006-04-24 07:30:00 | MSFT | Stock | 27.1 | 27.1 | 27.1 | 27.1 | 500.0 |
| 2006-04-24 08:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.06 | 27.06 | 9799.0 |
| 2006-04-24 08:30:00 | MSFT | Stock | 27.06 | 27.11 | 27.06 | 27.08 | 10766.0 |
| 2006-04-24 09:00:00 | MSFT | Stock | 27.08 | 27.12 | 27.04 | 27.09 | 153827.0 |
| 2006-04-24 09:30:00 | MSFT | Stock | 27.07 | 27.25 | 27.05 | 27.06 | 3204023.0 |
| 2006-04-24 10:00:00 | MSFT | Stock | 27.06 | 27.09 | 26.99 | 27.06 | 4749980.0 |
| 2006-04-24 10:30:00 | MSFT | Stock | 27.06 | 27.13 | 26.99 | 26.99 | 4983664.0 |
| 2006-04-24 11:00:00 | MSFT | Stock | 27.0 | 27.03 | 26.98 | 27.01 | 2513668.0 |
| 2006-04-24 11:30:00 | MSFT | Stock | 27.01 | 27.1 | 27.01 | 27.08 | 2061408.0 |
| 2006-04-24 12:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.05 | 27.08 | 2879733.0 |
| 2006-04-24 12:30:00 | MSFT | Stock | 27.09 | 27.25 | 27.08 | 27.23 | 2497015.0 |
| 2006-04-24 13:00:00 | MSFT | Stock | 27.23 | 27.24 | 27.14 | 27.21 | 2461828.0 |
| 2006-04-24 13:30:00 | MSFT | Stock | 27.22 | 27.24 | 27.18 | 27.23 | 1128471.0 |
| 2006-04-24 14:00:00 | MSFT | Stock | 27.23 | 27.25 | 27.16 | 27.19 | 1736814.0 |
| 2006-04-24 14:30:00 | MSFT | Stock | 27.19 | 27.21 | 27.14 | 27.16 | 1249320.0 |
| 2006-04-24 15:00:00 | MSFT | Stock | 27.15 | 27.2 | 27.13 | 27.18 | 1442843.0 |
| 2006-04-24 15:30:00 | MSFT | Stock | 27.183 | 27.25 | 27.1 | 27.14 | 8141846.0 |
| 2006-04-24 16:00:00 | MSFT | Stock | 27.14 | 27.14 | 27.11 | 27.11 | 68726.0 |
| 2006-04-24 16:30:00 | MSFT | Stock | 27.164 | 27.164 | 27.11 | 27.11 | 8217.0 |
| 2006-04-24 17:00:00 | MSFT | Stock | 27.11 | 27.11 | 27.11 | 27.11 | 508576.0 |
| 2006-04-24 17:30:00 | MSFT | Stock | 27.11 | 27.11 | 27.11 | 27.11 | 2099.0 |
| 2006-04-24 18:00:00 | MSFT | Stock | 27.12 | 27.12 | 27.11 | 27.11 | 2380.0 |
| 2006-04-24 08:00:00 | NVDA | Stock | 0.4678 | 0.4713 | 0.4678 | 0.4707 | 276840.0 |
| 2006-04-24 08:30:00 | NVDA | Stock | 0.4718 | 0.4718 | 0.4707 | 0.4707 | 109500.0 |
| 2006-04-24 09:00:00 | NVDA | Stock | 0.4692 | 0.4705 | 0.4675 | 0.4705 | 1099380.0 |
| 2006-04-24 09:30:00 | NVDA | Stock | 0.4708 | 0.4767 | 0.4625 | 0.4707 | 89225280.0 |
| 2006-04-24 10:00:00 | NVDA | Stock | 0.4707 | 0.4802 | 0.4697 | 0.4774 | 73522980.0 |
| 2006-04-24 10:30:00 | NVDA | Stock | 0.4775 | 0.4833 | 0.4767 | 0.4783 | 60343320.0 |
> showing 50 of 49,423 rows — these rows as CSV