PREVIEW / stock_30min / 2006-07-10
file: by_date/stock_30min/2006/2006-07-10.parquet size: 901 KB rows: 49,140 symbols: 2,317
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-07-10 08:00:00 | AAPL | Stock | 1.9911 | 1.9946 | 1.9911 | 1.9946 | 247240.0 |
| 2006-07-10 08:30:00 | AAPL | Stock | 1.9946 | 1.9957 | 1.9929 | 1.9936 | 155960.0 |
| 2006-07-10 09:00:00 | AAPL | Stock | 1.9943 | 1.9943 | 1.9889 | 1.9893 | 250880.0 |
| 2006-07-10 09:30:00 | AAPL | Stock | 1.9893 | 2.0118 | 1.9868 | 2.0075 | 61756940.0 |
| 2006-07-10 10:00:00 | AAPL | Stock | 2.0071 | 2.0175 | 2.0011 | 2.0068 | 49663124.0 |
| 2006-07-10 10:30:00 | AAPL | Stock | 2.0071 | 2.0129 | 1.9975 | 2.0043 | 38080308.0 |
| 2006-07-10 11:00:00 | AAPL | Stock | 2.0043 | 2.0043 | 1.9936 | 1.9975 | 32258464.0 |
| 2006-07-10 11:30:00 | AAPL | Stock | 1.9979 | 1.9986 | 1.9836 | 1.9839 | 33429116.0 |
| 2006-07-10 12:00:00 | AAPL | Stock | 1.9843 | 1.9886 | 1.9764 | 1.985 | 31660972.0 |
| 2006-07-10 12:30:00 | AAPL | Stock | 1.985 | 1.9889 | 1.9768 | 1.9779 | 16875796.0 |
| 2006-07-10 13:00:00 | AAPL | Stock | 1.9779 | 1.9789 | 1.9732 | 1.9732 | 26012896.0 |
| 2006-07-10 13:30:00 | AAPL | Stock | 1.9732 | 1.9743 | 1.9625 | 1.9679 | 36540784.0 |
| 2006-07-10 14:00:00 | AAPL | Stock | 1.9679 | 1.9714 | 1.9589 | 1.9629 | 38983196.0 |
| 2006-07-10 14:30:00 | AAPL | Stock | 1.9625 | 1.9625 | 1.9464 | 1.9511 | 57393868.0 |
| 2006-07-10 15:00:00 | AAPL | Stock | 1.9507 | 1.9671 | 1.9496 | 1.9618 | 49762048.0 |
| 2006-07-10 15:30:00 | AAPL | Stock | 1.9621 | 1.9679 | 1.9593 | 1.9629 | 52661924.0 |
| 2006-07-10 16:00:00 | AAPL | Stock | 1.9625 | 1.9643 | 1.9593 | 1.9607 | 667436.0 |
| 2006-07-10 16:30:00 | AAPL | Stock | 1.9618 | 1.9618 | 1.9593 | 1.9611 | 141708.0 |
| 2006-07-10 17:00:00 | AAPL | Stock | 1.9611 | 1.9618 | 1.96 | 1.9607 | 147224.0 |
| 2006-07-10 17:30:00 | AAPL | Stock | 1.96 | 1.9643 | 1.96 | 1.9643 | 160636.0 |
| 2006-07-10 18:00:00 | AAPL | Stock | 1.9643 | 1.9643 | 1.9607 | 1.9607 | 1852200.0 |
| 2006-07-10 08:00:00 | MSFT | Stock | 23.33 | 23.37 | 23.33 | 23.36 | 23514.0 |
| 2006-07-10 08:30:00 | MSFT | Stock | 23.37 | 23.38 | 23.34 | 23.35 | 15602.0 |
| 2006-07-10 09:00:00 | MSFT | Stock | 23.38 | 23.46 | 23.35 | 23.42 | 153040.0 |
| 2006-07-10 09:30:00 | MSFT | Stock | 23.43 | 23.55 | 23.41 | 23.54 | 5391228.0 |
| 2006-07-10 10:00:00 | MSFT | Stock | 23.54 | 23.66 | 23.52 | 23.59 | 3846672.0 |
| 2006-07-10 10:30:00 | MSFT | Stock | 23.6 | 23.6 | 23.51 | 23.55 | 3361039.0 |
| 2006-07-10 11:00:00 | MSFT | Stock | 23.55 | 23.56 | 23.47 | 23.48 | 1972926.0 |
| 2006-07-10 11:30:00 | MSFT | Stock | 23.47 | 23.51 | 23.47 | 23.5 | 1732533.0 |
| 2006-07-10 12:00:00 | MSFT | Stock | 23.49 | 23.54 | 23.47 | 23.537 | 1462269.0 |
| 2006-07-10 12:30:00 | MSFT | Stock | 23.53 | 23.55 | 23.5 | 23.5 | 1342512.0 |
| 2006-07-10 13:00:00 | MSFT | Stock | 23.5 | 23.55 | 23.43 | 23.505 | 2892783.0 |
| 2006-07-10 13:30:00 | MSFT | Stock | 23.5 | 23.54 | 23.38 | 23.49 | 3309424.0 |
| 2006-07-10 14:00:00 | MSFT | Stock | 23.482 | 23.5 | 23.45 | 23.49 | 1722326.0 |
| 2006-07-10 14:30:00 | MSFT | Stock | 23.49 | 23.49 | 23.4 | 23.41 | 3432037.0 |
| 2006-07-10 15:00:00 | MSFT | Stock | 23.41 | 23.46 | 23.38 | 23.43 | 4355455.0 |
| 2006-07-10 15:30:00 | MSFT | Stock | 23.43 | 23.54 | 23.43 | 23.48 | 4578138.0 |
| 2006-07-10 16:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.48 | 23.49 | 217624.0 |
| 2006-07-10 16:30:00 | MSFT | Stock | 23.49 | 23.5 | 23.48 | 23.5 | 18264.0 |
| 2006-07-10 17:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.48 | 23.48 | 500.0 |
| 2006-07-10 17:30:00 | MSFT | Stock | 23.5 | 23.5 | 23.48 | 23.48 | 970.0 |
| 2006-07-10 18:00:00 | MSFT | Stock | 23.48 | 23.48 | 23.48 | 23.48 | 500.0 |
| 2006-07-10 08:00:00 | NVDA | Stock | 0.3243 | 0.3245 | 0.3243 | 0.3245 | 42000.0 |
| 2006-07-10 09:00:00 | NVDA | Stock | 0.3248 | 0.325 | 0.3238 | 0.3238 | 130260.0 |
| 2006-07-10 09:30:00 | NVDA | Stock | 0.3236 | 0.326 | 0.3225 | 0.323 | 26285220.0 |
| 2006-07-10 10:00:00 | NVDA | Stock | 0.3232 | 0.3245 | 0.3195 | 0.321 | 33647040.0 |
| 2006-07-10 10:30:00 | NVDA | Stock | 0.321 | 0.3213 | 0.3192 | 0.3197 | 39229260.0 |
| 2006-07-10 11:00:00 | NVDA | Stock | 0.3195 | 0.3198 | 0.3167 | 0.3183 | 29628660.0 |
| 2006-07-10 11:30:00 | NVDA | Stock | 0.3183 | 0.3187 | 0.3147 | 0.3157 | 26143560.0 |
| 2006-07-10 12:00:00 | NVDA | Stock | 0.3155 | 0.3165 | 0.3142 | 0.316 | 24090480.0 |
> showing 50 of 49,140 rows — these rows as CSV