PREVIEW / stock_30min / 2008-12-24
file: by_date/stock_30min/2008/2008-12-24.parquet size: 757 KB rows: 38,209 symbols: 3,269
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-24 08:00:00 | AAPL | Stock | 3.075 | 3.075 | 3.0454 | 3.0482 | 711564.0 |
| 2008-12-24 08:30:00 | AAPL | Stock | 3.0564 | 3.0761 | 3.0536 | 3.0643 | 454888.0 |
| 2008-12-24 09:00:00 | AAPL | Stock | 3.0679 | 3.085 | 3.0625 | 3.0739 | 357784.0 |
| 2008-12-24 09:30:00 | AAPL | Stock | 3.0764 | 3.0804 | 3.0211 | 3.0429 | 69057940.0 |
| 2008-12-24 10:00:00 | AAPL | Stock | 3.0429 | 3.0464 | 3.0196 | 3.0286 | 51420096.0 |
| 2008-12-24 10:30:00 | AAPL | Stock | 3.0282 | 3.0479 | 3.0254 | 3.0312 | 40214552.0 |
| 2008-12-24 11:00:00 | AAPL | Stock | 3.0314 | 3.0457 | 3.0304 | 3.0314 | 24858372.0 |
| 2008-12-24 11:30:00 | AAPL | Stock | 3.0318 | 3.0382 | 3.0286 | 3.0321 | 20241732.0 |
| 2008-12-24 12:00:00 | AAPL | Stock | 3.0325 | 3.0354 | 3.0236 | 3.0311 | 23194948.0 |
| 2008-12-24 12:30:00 | AAPL | Stock | 3.0311 | 3.0493 | 3.0289 | 3.0393 | 32112164.0 |
| 2008-12-24 13:00:00 | AAPL | Stock | 3.035 | 3.04 | 3.0321 | 3.0343 | 5712616.0 |
| 2008-12-24 13:30:00 | AAPL | Stock | 3.0329 | 3.0357 | 3.0307 | 3.0357 | 104132.0 |
| 2008-12-24 14:00:00 | AAPL | Stock | 3.0371 | 3.0389 | 3.0371 | 3.0386 | 30800.0 |
| 2008-12-24 14:30:00 | AAPL | Stock | 3.0389 | 3.0389 | 3.0343 | 3.0389 | 15344.0 |
| 2008-12-24 15:00:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0339 | 3.0339 | 25200.0 |
| 2008-12-24 15:30:00 | AAPL | Stock | 3.0382 | 3.0382 | 3.0382 | 3.0382 | 2800.0 |
| 2008-12-24 16:30:00 | AAPL | Stock | 3.0364 | 3.0389 | 3.0357 | 3.0389 | 13972.0 |
| 2008-12-24 08:00:00 | MSFT | Stock | 19.37 | 19.37 | 19.26 | 19.26 | 7000.0 |
| 2008-12-24 08:30:00 | MSFT | Stock | 19.29 | 19.35 | 19.29 | 19.33 | 15279.0 |
| 2008-12-24 09:00:00 | MSFT | Stock | 19.33 | 19.42 | 19.28 | 19.28 | 20284.0 |
| 2008-12-24 09:30:00 | MSFT | Stock | 19.28 | 19.45 | 19.15 | 19.2 | 3181747.0 |
| 2008-12-24 10:00:00 | MSFT | Stock | 19.2 | 19.3 | 19.17 | 19.23 | 2714998.0 |
| 2008-12-24 10:30:00 | MSFT | Stock | 19.228 | 19.25 | 19.16 | 19.19 | 1854510.0 |
| 2008-12-24 11:00:00 | MSFT | Stock | 19.19 | 19.24 | 19.17 | 19.205 | 1670073.0 |
| 2008-12-24 11:30:00 | MSFT | Stock | 19.2 | 19.23 | 19.16 | 19.18 | 1598167.0 |
| 2008-12-24 12:00:00 | MSFT | Stock | 19.19 | 19.19 | 19.1 | 19.12 | 1621878.0 |
| 2008-12-24 12:30:00 | MSFT | Stock | 19.13 | 19.23 | 19.12 | 19.16 | 2967039.0 |
| 2008-12-24 13:00:00 | MSFT | Stock | 19.16 | 19.22 | 19.15 | 19.22 | 1155663.0 |
| 2008-12-24 13:30:00 | MSFT | Stock | 19.17 | 19.17 | 19.17 | 19.17 | 282.0 |
| 2008-12-24 14:00:00 | MSFT | Stock | 19.17 | 19.21 | 19.17 | 19.19 | 2200.0 |
| 2008-12-24 14:30:00 | MSFT | Stock | 19.21 | 19.22 | 19.18 | 19.18 | 2600.0 |
| 2008-12-24 15:00:00 | MSFT | Stock | 19.22 | 19.22 | 19.17 | 19.17 | 3500.0 |
| 2008-12-24 15:30:00 | MSFT | Stock | 19.23 | 19.24 | 19.18 | 19.18 | 5076.0 |
| 2008-12-24 16:00:00 | MSFT | Stock | 19.17 | 19.17 | 19.17 | 19.17 | 100.0 |
| 2008-12-24 09:30:00 | NVDA | Stock | 0.1938 | 0.1985 | 0.19 | 0.1903 | 37198720.0 |
| 2008-12-24 10:00:00 | NVDA | Stock | 0.1903 | 0.1923 | 0.189 | 0.1923 | 34048280.0 |
| 2008-12-24 10:30:00 | NVDA | Stock | 0.192 | 0.1925 | 0.1915 | 0.192 | 14532440.0 |
| 2008-12-24 11:00:00 | NVDA | Stock | 0.192 | 0.193 | 0.191 | 0.1913 | 14445680.0 |
| 2008-12-24 11:30:00 | NVDA | Stock | 0.1913 | 0.192 | 0.1911 | 0.1918 | 11760080.0 |
| 2008-12-24 12:00:00 | NVDA | Stock | 0.1918 | 0.1923 | 0.1915 | 0.192 | 10460480.0 |
| 2008-12-24 12:30:00 | NVDA | Stock | 0.1923 | 0.193 | 0.192 | 0.1925 | 19650600.0 |
| 2008-12-24 13:00:00 | NVDA | Stock | 0.193 | 0.193 | 0.193 | 0.193 | 3085520.0 |
| 2008-12-24 08:30:00 | AMZN | Stock | 2.563 | 2.563 | 2.5625 | 2.5625 | 8000.0 |
| 2008-12-24 09:00:00 | AMZN | Stock | 2.572 | 2.585 | 2.572 | 2.585 | 20000.0 |
| 2008-12-24 09:30:00 | AMZN | Stock | 2.583 | 2.5975 | 2.5585 | 2.565 | 7406300.0 |
| 2008-12-24 10:00:00 | AMZN | Stock | 2.5645 | 2.57 | 2.5505 | 2.5645 | 5306720.0 |
| 2008-12-24 10:30:00 | AMZN | Stock | 2.565 | 2.5785 | 2.564 | 2.5705 | 6934400.0 |
| 2008-12-24 11:00:00 | AMZN | Stock | 2.5705 | 2.5735 | 2.566 | 2.5665 | 2234780.0 |
| 2008-12-24 11:30:00 | AMZN | Stock | 2.5665 | 2.58 | 2.5617 | 2.5798 | 3011600.0 |
| 2008-12-24 12:00:00 | AMZN | Stock | 2.58 | 2.5845 | 2.572 | 2.5755 | 2189960.0 |
> showing 50 of 38,209 rows — these rows as CSV