PREVIEW / stock_30min / 2006-03-08
file: by_date/stock_30min/2006/2006-03-08.parquet size: 918 KB rows: 48,740 symbols: 2,194
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-03-08 08:00:00 | AAPL | Stock | 2.3571 | 2.3643 | 2.3539 | 2.3554 | 362012.0 |
| 2006-03-08 08:30:00 | AAPL | Stock | 2.3568 | 2.3586 | 2.3554 | 2.3557 | 554512.0 |
| 2006-03-08 09:00:00 | AAPL | Stock | 2.3554 | 2.37 | 2.3514 | 2.3675 | 1599220.0 |
| 2006-03-08 09:30:00 | AAPL | Stock | 2.3675 | 2.3886 | 2.3489 | 2.3836 | 94145576.0 |
| 2006-03-08 10:00:00 | AAPL | Stock | 2.3836 | 2.4 | 2.3661 | 2.3668 | 96343296.0 |
| 2006-03-08 10:30:00 | AAPL | Stock | 2.3671 | 2.385 | 2.3668 | 2.3779 | 58059372.0 |
| 2006-03-08 11:00:00 | AAPL | Stock | 2.3786 | 2.3814 | 2.365 | 2.3711 | 37031652.0 |
| 2006-03-08 11:30:00 | AAPL | Stock | 2.3711 | 2.3711 | 2.3364 | 2.3379 | 59163272.0 |
| 2006-03-08 12:00:00 | AAPL | Stock | 2.3379 | 2.3532 | 2.3339 | 2.3511 | 34743184.0 |
| 2006-03-08 12:30:00 | AAPL | Stock | 2.3518 | 2.3564 | 2.3411 | 2.3529 | 31069248.0 |
| 2006-03-08 13:00:00 | AAPL | Stock | 2.3532 | 2.3564 | 2.3429 | 2.3464 | 21379120.0 |
| 2006-03-08 13:30:00 | AAPL | Stock | 2.3468 | 2.3532 | 2.3421 | 2.3507 | 16681392.0 |
| 2006-03-08 14:00:00 | AAPL | Stock | 2.3507 | 2.3711 | 2.3454 | 2.3639 | 44075332.0 |
| 2006-03-08 14:30:00 | AAPL | Stock | 2.3643 | 2.3714 | 2.3521 | 2.3625 | 57008588.0 |
| 2006-03-08 15:00:00 | AAPL | Stock | 2.3621 | 2.3657 | 2.3575 | 2.3614 | 28162092.0 |
| 2006-03-08 15:30:00 | AAPL | Stock | 2.3614 | 2.3614 | 2.3429 | 2.3454 | 49043008.0 |
| 2006-03-08 16:00:00 | AAPL | Stock | 2.3411 | 2.3475 | 2.3379 | 2.3439 | 1597148.0 |
| 2006-03-08 16:30:00 | AAPL | Stock | 2.3429 | 2.345 | 2.3404 | 2.3404 | 12531288.0 |
| 2006-03-08 17:00:00 | AAPL | Stock | 2.3404 | 2.3436 | 2.3404 | 2.3436 | 174160.0 |
| 2006-03-08 17:30:00 | AAPL | Stock | 2.3429 | 2.3461 | 2.3411 | 2.3425 | 1264592.0 |
| 2006-03-08 18:00:00 | AAPL | Stock | 2.3421 | 2.345 | 2.3411 | 2.3411 | 179172.0 |
| 2006-03-08 05:30:00 | MSFT | Stock | 27.02 | 27.02 | 26.99 | 26.99 | 1010.0 |
| 2006-03-08 06:30:00 | MSFT | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 900.0 |
| 2006-03-08 07:30:00 | MSFT | Stock | 27.02 | 27.02 | 26.95 | 26.98 | 10482.0 |
| 2006-03-08 08:00:00 | MSFT | Stock | 26.98 | 27.01 | 26.97 | 27.01 | 18646.0 |
| 2006-03-08 08:30:00 | MSFT | Stock | 26.98 | 26.98 | 26.96 | 26.96 | 4300.0 |
| 2006-03-08 09:00:00 | MSFT | Stock | 26.98 | 27.0 | 26.97 | 27.0 | 16884.0 |
| 2006-03-08 09:30:00 | MSFT | Stock | 26.99 | 27.33 | 26.97 | 27.31 | 7471972.0 |
| 2006-03-08 10:00:00 | MSFT | Stock | 27.31 | 27.44 | 27.28 | 27.38 | 7802702.0 |
| 2006-03-08 10:30:00 | MSFT | Stock | 27.39 | 27.49 | 27.3 | 27.41 | 6308283.0 |
| 2006-03-08 11:00:00 | MSFT | Stock | 27.41 | 27.42 | 27.31 | 27.38 | 4348028.0 |
| 2006-03-08 11:30:00 | MSFT | Stock | 27.39 | 27.39 | 27.23 | 27.3 | 3404939.0 |
| 2006-03-08 12:00:00 | MSFT | Stock | 27.3 | 27.38 | 27.29 | 27.38 | 1583424.0 |
| 2006-03-08 12:30:00 | MSFT | Stock | 27.38 | 27.42 | 27.33 | 27.35 | 2394689.0 |
| 2006-03-08 13:00:00 | MSFT | Stock | 27.352 | 27.39 | 27.3 | 27.34 | 1814409.0 |
| 2006-03-08 13:30:00 | MSFT | Stock | 27.34 | 27.37 | 27.29 | 27.35 | 1555104.0 |
| 2006-03-08 14:00:00 | MSFT | Stock | 27.34 | 27.44 | 27.308 | 27.42 | 2576152.0 |
| 2006-03-08 14:30:00 | MSFT | Stock | 27.42 | 27.5 | 27.41 | 27.44 | 3921212.0 |
| 2006-03-08 15:00:00 | MSFT | Stock | 27.45 | 27.5 | 27.34 | 27.4 | 4477533.0 |
| 2006-03-08 15:30:00 | MSFT | Stock | 27.4 | 27.41 | 27.24 | 27.26 | 6203028.0 |
| 2006-03-08 16:00:00 | MSFT | Stock | 27.26 | 27.32 | 27.23 | 27.3 | 425296.0 |
| 2006-03-08 16:30:00 | MSFT | Stock | 27.28 | 27.28 | 27.25 | 27.28 | 972565.0 |
| 2006-03-08 17:00:00 | MSFT | Stock | 27.29 | 27.3 | 27.29 | 27.3 | 2758.0 |
| 2006-03-08 17:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.26 | 27.26 | 111594.0 |
| 2006-03-08 18:00:00 | MSFT | Stock | 27.29 | 27.29 | 27.249 | 27.249 | 7114.0 |
| 2006-03-08 08:00:00 | NVDA | Stock | 0.4029 | 0.4029 | 0.4029 | 0.4029 | 36000.0 |
| 2006-03-08 08:30:00 | NVDA | Stock | 0.3992 | 0.3992 | 0.3992 | 0.3992 | 60000.0 |
| 2006-03-08 09:00:00 | NVDA | Stock | 0.3992 | 0.4018 | 0.3991 | 0.401 | 852000.0 |
| 2006-03-08 09:30:00 | NVDA | Stock | 0.4019 | 0.4019 | 0.3967 | 0.3988 | 77863080.0 |
| 2006-03-08 10:00:00 | NVDA | Stock | 0.3988 | 0.3996 | 0.3937 | 0.3939 | 51576000.0 |
> showing 50 of 48,740 rows — these rows as CSV