PREVIEW / stock_30min / 2006-06-14
file: by_date/stock_30min/2006/2006-06-14.parquet size: 938 KB rows: 51,095 symbols: 2,288
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-06-14 06:30:00 | AAPL | Stock | 2.0893 | 2.0893 | 2.0893 | 2.0893 | 25200.0 |
| 2006-06-14 07:00:00 | AAPL | Stock | 2.0893 | 2.0911 | 2.0893 | 2.0893 | 50400.0 |
| 2006-06-14 07:30:00 | AAPL | Stock | 2.0893 | 2.095 | 2.0714 | 2.0714 | 732200.0 |
| 2006-06-14 08:00:00 | AAPL | Stock | 2.0714 | 2.0779 | 2.0493 | 2.075 | 2992920.0 |
| 2006-06-14 08:30:00 | AAPL | Stock | 2.075 | 2.1 | 2.0679 | 2.0929 | 5238044.0 |
| 2006-06-14 09:00:00 | AAPL | Stock | 2.0925 | 2.1004 | 2.0818 | 2.0818 | 3424120.0 |
| 2006-06-14 09:30:00 | AAPL | Stock | 2.0814 | 2.0993 | 2.0632 | 2.0725 | 113958348.0 |
| 2006-06-14 10:00:00 | AAPL | Stock | 2.0729 | 2.0807 | 2.0593 | 2.0614 | 103146428.0 |
| 2006-06-14 10:30:00 | AAPL | Stock | 2.0621 | 2.0754 | 2.0514 | 2.0596 | 72888424.0 |
| 2006-06-14 11:00:00 | AAPL | Stock | 2.06 | 2.0636 | 2.0493 | 2.0539 | 45140424.0 |
| 2006-06-14 11:30:00 | AAPL | Stock | 2.0539 | 2.0607 | 2.0496 | 2.0546 | 35200760.0 |
| 2006-06-14 12:00:00 | AAPL | Stock | 2.0543 | 2.0789 | 2.0504 | 2.055 | 27734000.0 |
| 2006-06-14 12:30:00 | AAPL | Stock | 2.0546 | 2.0579 | 2.0518 | 2.0556 | 13859804.0 |
| 2006-06-14 13:00:00 | AAPL | Stock | 2.0554 | 2.0556 | 2.035 | 2.04 | 64769236.0 |
| 2006-06-14 13:30:00 | AAPL | Stock | 2.04 | 2.0429 | 2.0246 | 2.0414 | 66514840.0 |
| 2006-06-14 14:00:00 | AAPL | Stock | 2.0414 | 2.0529 | 2.0357 | 2.0493 | 64436988.0 |
| 2006-06-14 14:30:00 | AAPL | Stock | 2.0489 | 2.0525 | 2.0314 | 2.0318 | 66032204.0 |
| 2006-06-14 15:00:00 | AAPL | Stock | 2.0318 | 2.0393 | 2.0271 | 2.0329 | 66453352.0 |
| 2006-06-14 15:30:00 | AAPL | Stock | 2.0329 | 2.0618 | 2.0325 | 2.0571 | 110056548.0 |
| 2006-06-14 16:00:00 | AAPL | Stock | 2.0571 | 2.0589 | 2.0543 | 2.0557 | 2709672.0 |
| 2006-06-14 16:30:00 | AAPL | Stock | 2.0564 | 2.0575 | 2.0554 | 2.0571 | 2500652.0 |
| 2006-06-14 17:00:00 | AAPL | Stock | 2.0564 | 2.0604 | 2.0546 | 2.0582 | 371420.0 |
| 2006-06-14 17:30:00 | AAPL | Stock | 2.0582 | 2.0604 | 2.0575 | 2.0589 | 345800.0 |
| 2006-06-14 18:00:00 | AAPL | Stock | 2.0586 | 2.0621 | 2.0564 | 2.0589 | 262920.0 |
| 2006-06-14 06:30:00 | MSFT | Stock | 21.62 | 21.62 | 21.62 | 21.62 | 1750.0 |
| 2006-06-14 07:00:00 | MSFT | Stock | 21.63 | 21.63 | 21.63 | 21.63 | 900.0 |
| 2006-06-14 07:30:00 | MSFT | Stock | 21.75 | 21.75 | 21.65 | 21.7 | 30100.0 |
| 2006-06-14 08:00:00 | MSFT | Stock | 21.69 | 21.69 | 21.65 | 21.67 | 192964.0 |
| 2006-06-14 08:30:00 | MSFT | Stock | 21.68 | 21.69 | 21.53 | 21.61 | 220252.0 |
| 2006-06-14 09:00:00 | MSFT | Stock | 21.58 | 21.65 | 21.57 | 21.58 | 108285.0 |
| 2006-06-14 09:30:00 | MSFT | Stock | 21.59 | 21.73 | 21.55 | 21.67 | 7907512.0 |
| 2006-06-14 10:00:00 | MSFT | Stock | 21.67 | 21.91 | 21.66 | 21.85 | 12136440.0 |
| 2006-06-14 10:30:00 | MSFT | Stock | 21.85 | 21.87 | 21.69 | 21.71 | 8058071.0 |
| 2006-06-14 11:00:00 | MSFT | Stock | 21.71 | 21.8 | 21.67 | 21.79 | 5524063.0 |
| 2006-06-14 11:30:00 | MSFT | Stock | 21.8 | 21.9 | 21.78 | 21.84 | 6095066.0 |
| 2006-06-14 12:00:00 | MSFT | Stock | 21.83 | 21.882 | 21.75 | 21.83 | 3318465.0 |
| 2006-06-14 12:30:00 | MSFT | Stock | 21.83 | 21.83 | 21.7 | 21.71 | 2662595.0 |
| 2006-06-14 13:00:00 | MSFT | Stock | 21.718 | 21.72 | 21.57 | 21.62 | 3881886.0 |
| 2006-06-14 13:30:00 | MSFT | Stock | 21.62 | 21.74 | 21.57 | 21.71 | 4663473.0 |
| 2006-06-14 14:00:00 | MSFT | Stock | 21.7 | 21.8 | 21.67 | 21.79 | 6257926.0 |
| 2006-06-14 14:30:00 | MSFT | Stock | 21.8 | 21.81 | 21.61 | 21.65 | 5357342.0 |
| 2006-06-14 15:00:00 | MSFT | Stock | 21.64 | 21.67 | 21.57 | 21.63 | 5069273.0 |
| 2006-06-14 15:30:00 | MSFT | Stock | 21.63 | 21.94 | 21.63 | 21.87 | 12359065.0 |
| 2006-06-14 16:00:00 | MSFT | Stock | 21.87 | 21.92 | 21.76 | 21.9 | 649143.0 |
| 2006-06-14 16:30:00 | MSFT | Stock | 21.89 | 21.94 | 21.8 | 21.92 | 110700.0 |
| 2006-06-14 17:00:00 | MSFT | Stock | 21.92 | 21.92 | 21.92 | 21.92 | 5278.0 |
| 2006-06-14 17:30:00 | MSFT | Stock | 21.92 | 21.92 | 21.92 | 21.92 | 18500.0 |
| 2006-06-14 18:00:00 | MSFT | Stock | 21.92 | 21.93 | 21.92 | 21.92 | 5320.0 |
| 2006-06-14 08:30:00 | NVDA | Stock | 0.3317 | 0.3317 | 0.3317 | 0.3317 | 27000.0 |
| 2006-06-14 09:00:00 | NVDA | Stock | 0.3325 | 0.3333 | 0.3313 | 0.3313 | 126000.0 |
> showing 50 of 51,095 rows — these rows as CSV