PREVIEW / stock_30min / 2007-11-14
file: by_date/stock_30min/2007/2007-11-14.parquet size: 1.2 MB rows: 70,531 symbols: 3,204
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-14 04:30:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2107 | 6.2107 | 13888.0 |
| 2007-11-14 05:00:00 | AAPL | Stock | 6.2214 | 6.2436 | 6.2161 | 6.2339 | 89824.0 |
| 2007-11-14 05:30:00 | AAPL | Stock | 6.2246 | 6.2496 | 6.22 | 6.22 | 47600.0 |
| 2007-11-14 06:00:00 | AAPL | Stock | 6.2339 | 6.235 | 6.22 | 6.22 | 28000.0 |
| 2007-11-14 06:30:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.1982 | 6.2089 | 332864.0 |
| 2007-11-14 07:00:00 | AAPL | Stock | 6.1982 | 6.1982 | 6.1375 | 6.1607 | 551264.0 |
| 2007-11-14 07:30:00 | AAPL | Stock | 6.1446 | 6.1625 | 6.1111 | 6.1607 | 1385832.0 |
| 2007-11-14 08:00:00 | AAPL | Stock | 6.1607 | 6.1921 | 6.1279 | 6.1789 | 8774836.0 |
| 2007-11-14 08:30:00 | AAPL | Stock | 6.1839 | 6.2875 | 6.1839 | 6.2725 | 20787256.0 |
| 2007-11-14 09:00:00 | AAPL | Stock | 6.2746 | 6.3393 | 6.2571 | 6.3271 | 18777136.0 |
| 2007-11-14 09:30:00 | AAPL | Stock | 6.3275 | 6.3418 | 6.1861 | 6.2086 | 251612116.0 |
| 2007-11-14 10:00:00 | AAPL | Stock | 6.2079 | 6.2814 | 6.1904 | 6.2614 | 134039248.0 |
| 2007-11-14 10:30:00 | AAPL | Stock | 6.2604 | 6.2618 | 6.1996 | 6.2277 | 87202472.0 |
| 2007-11-14 11:00:00 | AAPL | Stock | 6.2264 | 6.2411 | 6.1429 | 6.1875 | 105992320.0 |
| 2007-11-14 11:30:00 | AAPL | Stock | 6.1864 | 6.2018 | 6.1171 | 6.1693 | 90345864.0 |
| 2007-11-14 12:00:00 | AAPL | Stock | 6.17 | 6.2429 | 6.1679 | 6.2161 | 69176576.0 |
| 2007-11-14 12:30:00 | AAPL | Stock | 6.2171 | 6.2182 | 6.1518 | 6.1639 | 48610800.0 |
| 2007-11-14 13:00:00 | AAPL | Stock | 6.1629 | 6.2054 | 6.1543 | 6.1986 | 38833760.0 |
| 2007-11-14 13:30:00 | AAPL | Stock | 6.1982 | 6.2118 | 6.1379 | 6.1386 | 54145196.0 |
| 2007-11-14 14:00:00 | AAPL | Stock | 6.1393 | 6.1668 | 6.1136 | 6.1329 | 61071920.0 |
| 2007-11-14 14:30:00 | AAPL | Stock | 6.1329 | 6.1525 | 5.9943 | 6.0011 | 111154540.0 |
| 2007-11-14 15:00:00 | AAPL | Stock | 6.0011 | 6.0625 | 5.9761 | 6.0425 | 127817480.0 |
| 2007-11-14 15:30:00 | AAPL | Stock | 6.0449 | 6.045 | 5.8479 | 5.9318 | 194099444.0 |
| 2007-11-14 16:00:00 | AAPL | Stock | 5.9321 | 6.1449 | 5.9204 | 5.9482 | 17897124.0 |
| 2007-11-14 16:30:00 | AAPL | Stock | 5.95 | 6.1448 | 5.9322 | 5.9639 | 3800720.0 |
| 2007-11-14 17:00:00 | AAPL | Stock | 5.9325 | 6.0947 | 5.9325 | 5.9325 | 2159024.0 |
| 2007-11-14 17:30:00 | AAPL | Stock | 6.07 | 6.0881 | 5.9146 | 5.9286 | 1291556.0 |
| 2007-11-14 18:00:00 | AAPL | Stock | 5.915 | 5.955 | 5.9143 | 5.9257 | 1037792.0 |
| 2007-11-14 18:30:00 | AAPL | Stock | 5.9286 | 5.9464 | 5.9286 | 5.9411 | 161084.0 |
| 2007-11-14 19:00:00 | AAPL | Stock | 5.9411 | 5.9486 | 5.9329 | 5.9486 | 96600.0 |
| 2007-11-14 19:30:00 | AAPL | Stock | 5.9546 | 5.9554 | 5.9371 | 5.9464 | 191184.0 |
| 2007-11-14 08:00:00 | MSFT | Stock | 34.37 | 34.47 | 34.37 | 34.47 | 5907.0 |
| 2007-11-14 08:30:00 | MSFT | Stock | 34.47 | 34.8 | 34.47 | 34.67 | 105499.0 |
| 2007-11-14 09:00:00 | MSFT | Stock | 34.67 | 34.7 | 34.52 | 34.65 | 220150.0 |
| 2007-11-14 09:30:00 | MSFT | Stock | 34.65 | 34.75 | 34.13 | 34.199 | 11939382.0 |
| 2007-11-14 10:00:00 | MSFT | Stock | 34.2 | 34.41 | 34.19 | 34.37 | 6241755.0 |
| 2007-11-14 10:30:00 | MSFT | Stock | 34.37 | 34.37 | 34.22 | 34.23 | 3643230.0 |
| 2007-11-14 11:00:00 | MSFT | Stock | 34.22 | 34.23 | 33.83 | 33.83 | 8980370.0 |
| 2007-11-14 11:30:00 | MSFT | Stock | 33.84 | 33.95 | 33.835 | 33.931 | 4490732.0 |
| 2007-11-14 12:00:00 | MSFT | Stock | 33.94 | 34.12 | 33.93 | 34.06 | 3726133.0 |
| 2007-11-14 12:30:00 | MSFT | Stock | 34.06 | 34.06 | 33.98 | 33.99 | 2814569.0 |
| 2007-11-14 13:00:00 | MSFT | Stock | 33.99 | 34.17 | 33.95 | 34.12 | 3791030.0 |
| 2007-11-14 13:30:00 | MSFT | Stock | 34.12 | 34.13 | 33.95 | 33.97 | 3879725.0 |
| 2007-11-14 14:00:00 | MSFT | Stock | 33.97 | 34.06 | 33.96 | 34.005 | 3009098.0 |
| 2007-11-14 14:30:00 | MSFT | Stock | 34.01 | 34.03 | 33.95 | 33.95 | 3231163.0 |
| 2007-11-14 15:00:00 | MSFT | Stock | 33.95 | 34.12 | 33.9 | 34.11 | 5981598.0 |
| 2007-11-14 15:30:00 | MSFT | Stock | 34.11 | 34.12 | 33.75 | 33.93 | 17123019.0 |
| 2007-11-14 16:00:00 | MSFT | Stock | 33.92 | 34.095 | 33.9 | 33.94 | 2240395.0 |
| 2007-11-14 16:30:00 | MSFT | Stock | 34.09 | 34.09 | 33.921 | 33.93 | 2638171.0 |
| 2007-11-14 17:00:00 | MSFT | Stock | 33.93 | 34.46 | 33.93 | 33.93 | 540206.0 |
> showing 50 of 70,531 rows — these rows as CSV