PREVIEW / stock_30min / 2005-06-24
file: by_date/stock_30min/2005/2005-06-24.parquet size: 934 KB rows: 48,620 symbols: 1,994
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-24 08:00:00 | AAPL | Stock | 1.3925 | 1.3929 | 1.3911 | 1.3911 | 275240.0 |
| 2005-06-24 08:30:00 | AAPL | Stock | 1.3911 | 1.3929 | 1.3893 | 1.3907 | 235200.0 |
| 2005-06-24 09:00:00 | AAPL | Stock | 1.3911 | 1.3964 | 1.3911 | 1.3964 | 471744.0 |
| 2005-06-24 09:30:00 | AAPL | Stock | 1.3961 | 1.3971 | 1.3704 | 1.3821 | 48472200.0 |
| 2005-06-24 10:00:00 | AAPL | Stock | 1.3821 | 1.3857 | 1.3732 | 1.3736 | 25191600.0 |
| 2005-06-24 10:30:00 | AAPL | Stock | 1.3743 | 1.3861 | 1.3739 | 1.3807 | 26946864.0 |
| 2005-06-24 11:00:00 | AAPL | Stock | 1.3814 | 1.3846 | 1.3789 | 1.3839 | 14320936.0 |
| 2005-06-24 11:30:00 | AAPL | Stock | 1.3836 | 1.3836 | 1.3704 | 1.3746 | 19262712.0 |
| 2005-06-24 12:00:00 | AAPL | Stock | 1.3749 | 1.3757 | 1.37 | 1.3718 | 15378384.0 |
| 2005-06-24 12:30:00 | AAPL | Stock | 1.3718 | 1.3725 | 1.3661 | 1.3661 | 9199288.0 |
| 2005-06-24 13:00:00 | AAPL | Stock | 1.3661 | 1.3675 | 1.3582 | 1.36 | 31336956.0 |
| 2005-06-24 13:30:00 | AAPL | Stock | 1.3604 | 1.3714 | 1.3479 | 1.3511 | 39012764.0 |
| 2005-06-24 14:00:00 | AAPL | Stock | 1.3507 | 1.3546 | 1.3457 | 1.3511 | 27034504.0 |
| 2005-06-24 14:30:00 | AAPL | Stock | 1.3518 | 1.3557 | 1.3479 | 1.3496 | 15784972.0 |
| 2005-06-24 15:00:00 | AAPL | Stock | 1.3496 | 1.3557 | 1.3482 | 1.3554 | 24515176.0 |
| 2005-06-24 15:30:00 | AAPL | Stock | 1.3554 | 1.3571 | 1.3489 | 1.35 | 51614164.0 |
| 2005-06-24 16:00:00 | AAPL | Stock | 1.3511 | 1.3511 | 1.3454 | 1.3464 | 1186276.0 |
| 2005-06-24 16:30:00 | AAPL | Stock | 1.3464 | 1.3488 | 1.3464 | 1.3485 | 14793604.0 |
| 2005-06-24 17:00:00 | AAPL | Stock | 1.3486 | 1.3489 | 1.3471 | 1.3476 | 686952.0 |
| 2005-06-24 17:30:00 | AAPL | Stock | 1.3487 | 1.3489 | 1.348 | 1.3489 | 7695940.0 |
| 2005-06-24 18:00:00 | AAPL | Stock | 1.3489 | 1.3493 | 1.3475 | 1.3488 | 21157024.0 |
| 2005-06-24 08:00:00 | MSFT | Stock | 25.45 | 25.45 | 25.33 | 25.35 | 8976.0 |
| 2005-06-24 08:30:00 | MSFT | Stock | 25.37 | 25.37 | 25.31 | 25.35 | 55984.0 |
| 2005-06-24 09:00:00 | MSFT | Stock | 25.35 | 25.37 | 25.22 | 25.22 | 249634.0 |
| 2005-06-24 09:30:00 | MSFT | Stock | 25.22 | 25.4 | 25.21 | 25.39 | 6565941.0 |
| 2005-06-24 10:00:00 | MSFT | Stock | 25.39 | 25.4 | 25.26 | 25.269 | 3181188.0 |
| 2005-06-24 10:30:00 | MSFT | Stock | 25.26 | 25.31 | 25.2 | 25.26 | 3377154.0 |
| 2005-06-24 11:00:00 | MSFT | Stock | 25.26 | 25.3 | 25.2 | 25.238 | 3356258.0 |
| 2005-06-24 11:30:00 | MSFT | Stock | 25.23 | 25.25 | 25.2 | 25.21 | 2694569.0 |
| 2005-06-24 12:00:00 | MSFT | Stock | 25.21 | 25.29 | 25.18 | 25.241 | 3067803.0 |
| 2005-06-24 12:30:00 | MSFT | Stock | 25.25 | 25.279 | 25.23 | 25.26 | 1668016.0 |
| 2005-06-24 13:00:00 | MSFT | Stock | 25.26 | 25.27 | 25.2 | 25.25 | 2472657.0 |
| 2005-06-24 13:30:00 | MSFT | Stock | 25.25 | 25.31 | 25.19 | 25.21 | 3322160.0 |
| 2005-06-24 14:00:00 | MSFT | Stock | 25.21 | 25.22 | 25.15 | 25.192 | 3135197.0 |
| 2005-06-24 14:30:00 | MSFT | Stock | 25.2 | 25.24 | 25.15 | 25.17 | 2980010.0 |
| 2005-06-24 15:00:00 | MSFT | Stock | 25.17 | 25.17 | 25.05 | 25.092 | 6710042.0 |
| 2005-06-24 15:30:00 | MSFT | Stock | 25.09 | 25.14 | 25.05 | 25.09 | 7613819.0 |
| 2005-06-24 16:00:00 | MSFT | Stock | 25.08 | 25.1 | 25.02 | 25.04 | 597985.0 |
| 2005-06-24 16:30:00 | MSFT | Stock | 25.08 | 25.08 | 25.039 | 25.08 | 2925857.0 |
| 2005-06-24 17:00:00 | MSFT | Stock | 25.08 | 25.08 | 25.04 | 25.08 | 114070.0 |
| 2005-06-24 17:30:00 | MSFT | Stock | 25.08 | 25.09 | 25.037 | 25.09 | 1618404.0 |
| 2005-06-24 18:00:00 | MSFT | Stock | 25.08 | 25.09 | 25.033 | 25.09 | 2493664.0 |
| 2005-06-24 08:00:00 | NVDA | Stock | 0.2329 | 0.2329 | 0.2329 | 0.2329 | 12000.0 |
| 2005-06-24 09:00:00 | NVDA | Stock | 0.2329 | 0.2329 | 0.2327 | 0.2327 | 756000.0 |
| 2005-06-24 09:30:00 | NVDA | Stock | 0.2327 | 0.2328 | 0.2296 | 0.2302 | 47687520.0 |
| 2005-06-24 10:00:00 | NVDA | Stock | 0.2303 | 0.231 | 0.2283 | 0.2284 | 42737880.0 |
| 2005-06-24 10:30:00 | NVDA | Stock | 0.2283 | 0.2292 | 0.2277 | 0.2287 | 43097400.0 |
| 2005-06-24 11:00:00 | NVDA | Stock | 0.2287 | 0.2303 | 0.2287 | 0.2296 | 22002840.0 |
| 2005-06-24 11:30:00 | NVDA | Stock | 0.2296 | 0.23 | 0.228 | 0.2284 | 16131600.0 |
| 2005-06-24 12:00:00 | NVDA | Stock | 0.2284 | 0.2294 | 0.2282 | 0.2292 | 13678560.0 |
> showing 50 of 48,620 rows — these rows as CSV