PREVIEW / stock_30min / 2003-12-24
file: by_date/stock_30min/2003/2003-12-24.parquet size: 429 KB rows: 20,293 symbols: 1,675
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-24 08:00:00 | AAPL | Stock | 0.3542 | 0.3542 | 0.3542 | 0.3542 | 1086400.0 |
| 2003-12-24 08:30:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.3538 | 0.3538 | 1000048.0 |
| 2003-12-24 09:00:00 | AAPL | Stock | 0.3538 | 0.3538 | 0.352 | 0.3521 | 196000.0 |
| 2003-12-24 09:30:00 | AAPL | Stock | 0.3521 | 0.3568 | 0.3509 | 0.3564 | 13633592.0 |
| 2003-12-24 10:00:00 | AAPL | Stock | 0.3559 | 0.3593 | 0.3541 | 0.3588 | 22726816.0 |
| 2003-12-24 10:30:00 | AAPL | Stock | 0.3588 | 0.3604 | 0.3571 | 0.36 | 18213160.0 |
| 2003-12-24 11:00:00 | AAPL | Stock | 0.36 | 0.3639 | 0.36 | 0.3638 | 31214568.0 |
| 2003-12-24 11:30:00 | AAPL | Stock | 0.3638 | 0.3655 | 0.3634 | 0.3654 | 26263160.0 |
| 2003-12-24 12:00:00 | AAPL | Stock | 0.3654 | 0.3677 | 0.3652 | 0.3657 | 40821704.0 |
| 2003-12-24 12:30:00 | AAPL | Stock | 0.3657 | 0.3659 | 0.3638 | 0.3643 | 20590920.0 |
| 2003-12-24 13:00:00 | AAPL | Stock | 0.3646 | 0.3655 | 0.3643 | 0.3645 | 278152.0 |
| 2003-12-24 08:00:00 | MSFT | Stock | 27.1 | 27.17 | 27.1 | 27.15 | 1900.0 |
| 2003-12-24 08:30:00 | MSFT | Stock | 27.17 | 27.17 | 27.1 | 27.1 | 533168.0 |
| 2003-12-24 09:00:00 | MSFT | Stock | 27.06 | 27.15 | 27.04 | 27.14 | 123338.0 |
| 2003-12-24 09:30:00 | MSFT | Stock | 27.14 | 27.15 | 27.0 | 27.04 | 3462153.0 |
| 2003-12-24 10:00:00 | MSFT | Stock | 27.04 | 27.12 | 27.03 | 27.12 | 1668361.0 |
| 2003-12-24 10:30:00 | MSFT | Stock | 27.11 | 27.14 | 27.08 | 27.09 | 2412551.0 |
| 2003-12-24 11:00:00 | MSFT | Stock | 27.09 | 27.14 | 27.08 | 27.12 | 1622837.0 |
| 2003-12-24 11:30:00 | MSFT | Stock | 27.121 | 27.14 | 27.08 | 27.12 | 1666632.0 |
| 2003-12-24 12:00:00 | MSFT | Stock | 27.13 | 27.15 | 27.11 | 27.14 | 1375948.0 |
| 2003-12-24 12:30:00 | MSFT | Stock | 27.13 | 27.14 | 27.03 | 27.05 | 3301519.0 |
| 2003-12-24 13:00:00 | MSFT | Stock | 27.03 | 27.06 | 27.03 | 27.04 | 53097.0 |
| 2003-12-24 08:30:00 | NVDA | Stock | 0.1829 | 0.1832 | 0.1829 | 0.1832 | 994680.0 |
| 2003-12-24 09:00:00 | NVDA | Stock | 0.1821 | 0.1834 | 0.1821 | 0.183 | 900000.0 |
| 2003-12-24 09:30:00 | NVDA | Stock | 0.1829 | 0.1835 | 0.1812 | 0.1827 | 58792800.0 |
| 2003-12-24 10:00:00 | NVDA | Stock | 0.1825 | 0.1827 | 0.182 | 0.1825 | 22531800.0 |
| 2003-12-24 10:30:00 | NVDA | Stock | 0.1825 | 0.1833 | 0.1825 | 0.183 | 25323240.0 |
| 2003-12-24 11:00:00 | NVDA | Stock | 0.1831 | 0.1833 | 0.1826 | 0.1831 | 13306560.0 |
| 2003-12-24 11:30:00 | NVDA | Stock | 0.1831 | 0.1832 | 0.1829 | 0.1831 | 12541680.0 |
| 2003-12-24 12:00:00 | NVDA | Stock | 0.1831 | 0.1834 | 0.1829 | 0.1832 | 12933840.0 |
| 2003-12-24 12:30:00 | NVDA | Stock | 0.1831 | 0.1831 | 0.1817 | 0.1817 | 50595480.0 |
| 2003-12-24 13:00:00 | NVDA | Stock | 0.1817 | 0.1817 | 0.1815 | 0.1817 | 1338000.0 |
| 2003-12-24 08:00:00 | AMZN | Stock | 2.622 | 2.622 | 2.622 | 2.622 | 4000.0 |
| 2003-12-24 08:30:00 | AMZN | Stock | 2.62 | 2.6215 | 2.61 | 2.6215 | 88000.0 |
| 2003-12-24 09:00:00 | AMZN | Stock | 2.621 | 2.6235 | 2.6145 | 2.6145 | 268000.0 |
| 2003-12-24 09:30:00 | AMZN | Stock | 2.615 | 2.6655 | 2.6075 | 2.648 | 25934460.0 |
| 2003-12-24 10:00:00 | AMZN | Stock | 2.6475 | 2.6575 | 2.646 | 2.655 | 9969180.0 |
| 2003-12-24 10:30:00 | AMZN | Stock | 2.655 | 2.6675 | 2.631 | 2.6605 | 13945140.0 |
| 2003-12-24 11:00:00 | AMZN | Stock | 2.66 | 2.675 | 2.655 | 2.664 | 13477460.0 |
| 2003-12-24 11:30:00 | AMZN | Stock | 2.6635 | 2.694 | 2.661 | 2.6825 | 19918200.0 |
| 2003-12-24 12:00:00 | AMZN | Stock | 2.6825 | 2.6925 | 2.682 | 2.6895 | 9172960.0 |
| 2003-12-24 12:30:00 | AMZN | Stock | 2.6898 | 2.6935 | 2.656 | 2.6655 | 14853400.0 |
| 2003-12-24 13:00:00 | AMZN | Stock | 2.666 | 2.666 | 2.666 | 2.666 | 34000.0 |
| 2003-12-24 09:30:00 | CL | Stock | 24.625 | 24.68 | 24.52 | 24.55 | 438200.0 |
| 2003-12-24 10:00:00 | CL | Stock | 24.55 | 24.63 | 24.55 | 24.62 | 251400.0 |
| 2003-12-24 10:30:00 | CL | Stock | 24.625 | 24.635 | 24.54 | 24.57 | 358200.0 |
| 2003-12-24 11:00:00 | CL | Stock | 24.565 | 24.61 | 24.525 | 24.555 | 402600.0 |
| 2003-12-24 11:30:00 | CL | Stock | 24.555 | 24.59 | 24.5 | 24.515 | 609000.0 |
| 2003-12-24 12:00:00 | CL | Stock | 24.515 | 24.57 | 24.505 | 24.57 | 387000.0 |
| 2003-12-24 12:30:00 | CL | Stock | 24.57 | 24.57 | 24.52 | 24.565 | 448200.0 |
> showing 50 of 20,293 rows — these rows as CSV