PREVIEW / stock_30min / 2009-11-09
file: by_date/stock_30min/2009/2009-11-09.parquet size: 1.4 MB rows: 74,718 symbols: 3,416
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-09 04:00:00 | AAPL | Stock | 6.9582 | 6.9604 | 6.9582 | 6.9604 | 5600.0 |
| 2009-11-09 04:30:00 | AAPL | Stock | 6.9675 | 6.9675 | 6.9614 | 6.9614 | 5600.0 |
| 2009-11-09 05:00:00 | AAPL | Stock | 7.0139 | 7.0139 | 7.0139 | 7.0139 | 2800.0 |
| 2009-11-09 07:00:00 | AAPL | Stock | 7.0071 | 7.0154 | 6.9989 | 7.0011 | 156576.0 |
| 2009-11-09 07:30:00 | AAPL | Stock | 7.0118 | 7.0361 | 7.0043 | 7.0357 | 161980.0 |
| 2009-11-09 08:00:00 | AAPL | Stock | 7.0268 | 7.0479 | 7.0179 | 7.0357 | 1422064.0 |
| 2009-11-09 08:30:00 | AAPL | Stock | 7.0357 | 7.0411 | 7.0286 | 7.0386 | 789376.0 |
| 2009-11-09 09:00:00 | AAPL | Stock | 7.0386 | 7.0425 | 7.0311 | 7.0311 | 1078196.0 |
| 2009-11-09 09:30:00 | AAPL | Stock | 7.0336 | 7.0893 | 7.0093 | 7.0675 | 78811740.0 |
| 2009-11-09 10:00:00 | AAPL | Stock | 7.0671 | 7.1239 | 7.0671 | 7.1071 | 59282160.0 |
| 2009-11-09 10:30:00 | AAPL | Stock | 7.1057 | 7.1304 | 7.1 | 7.1179 | 32351088.0 |
| 2009-11-09 11:00:00 | AAPL | Stock | 7.1186 | 7.1282 | 7.105 | 7.1275 | 23228352.0 |
| 2009-11-09 11:30:00 | AAPL | Stock | 7.1275 | 7.1411 | 7.1164 | 7.1364 | 23267384.0 |
| 2009-11-09 12:00:00 | AAPL | Stock | 7.1364 | 7.1375 | 7.1259 | 7.1264 | 14151872.0 |
| 2009-11-09 12:30:00 | AAPL | Stock | 7.1266 | 7.1407 | 7.1222 | 7.1407 | 15290800.0 |
| 2009-11-09 13:00:00 | AAPL | Stock | 7.1407 | 7.1571 | 7.1321 | 7.1479 | 33260556.0 |
| 2009-11-09 13:30:00 | AAPL | Stock | 7.1482 | 7.17 | 7.145 | 7.1621 | 26740112.0 |
| 2009-11-09 14:00:00 | AAPL | Stock | 7.1616 | 7.1661 | 7.1457 | 7.1554 | 23679992.0 |
| 2009-11-09 14:30:00 | AAPL | Stock | 7.1554 | 7.1864 | 7.1529 | 7.1782 | 38965220.0 |
| 2009-11-09 15:00:00 | AAPL | Stock | 7.1786 | 7.1857 | 7.1714 | 7.177 | 25494504.0 |
| 2009-11-09 15:30:00 | AAPL | Stock | 7.1771 | 7.2107 | 7.165 | 7.1964 | 56871920.0 |
| 2009-11-09 16:00:00 | AAPL | Stock | 7.1961 | 7.2143 | 7.1274 | 7.1896 | 10367000.0 |
| 2009-11-09 16:30:00 | AAPL | Stock | 7.1929 | 7.195 | 7.1875 | 7.1893 | 495740.0 |
| 2009-11-09 17:00:00 | AAPL | Stock | 7.1929 | 7.1964 | 7.1929 | 7.1964 | 60900.0 |
| 2009-11-09 17:30:00 | AAPL | Stock | 7.195 | 7.1954 | 7.1914 | 7.1929 | 135800.0 |
| 2009-11-09 18:00:00 | AAPL | Stock | 7.1929 | 7.2071 | 7.1929 | 7.2064 | 1874488.0 |
| 2009-11-09 18:30:00 | AAPL | Stock | 7.2054 | 7.2075 | 7.2046 | 7.2057 | 184072.0 |
| 2009-11-09 19:00:00 | AAPL | Stock | 7.2057 | 7.2121 | 7.2057 | 7.2071 | 128856.0 |
| 2009-11-09 19:30:00 | AAPL | Stock | 7.2089 | 7.2089 | 7.1893 | 7.1964 | 443436.0 |
| 2009-11-09 06:30:00 | MSFT | Stock | 28.68 | 28.68 | 28.68 | 28.68 | 100.0 |
| 2009-11-09 07:00:00 | MSFT | Stock | 28.68 | 28.73 | 28.68 | 28.73 | 600.0 |
| 2009-11-09 07:30:00 | MSFT | Stock | 28.77 | 28.79 | 28.75 | 28.79 | 2000.0 |
| 2009-11-09 08:00:00 | MSFT | Stock | 28.76 | 28.84 | 28.75 | 28.75 | 7556.0 |
| 2009-11-09 08:30:00 | MSFT | Stock | 28.8 | 28.81 | 28.466 | 28.65 | 36294.0 |
| 2009-11-09 09:00:00 | MSFT | Stock | 28.63 | 28.7 | 28.59 | 28.62 | 57460.0 |
| 2009-11-09 09:30:00 | MSFT | Stock | 28.61 | 28.74 | 28.53 | 28.6 | 5796291.0 |
| 2009-11-09 10:00:00 | MSFT | Stock | 28.6 | 28.66 | 28.58 | 28.66 | 4614318.0 |
| 2009-11-09 10:30:00 | MSFT | Stock | 28.66 | 28.73 | 28.63 | 28.71 | 2743753.0 |
| 2009-11-09 11:00:00 | MSFT | Stock | 28.71 | 28.78 | 28.64 | 28.71 | 3567298.0 |
| 2009-11-09 11:30:00 | MSFT | Stock | 28.71 | 28.72 | 28.66 | 28.69 | 2493215.0 |
| 2009-11-09 12:00:00 | MSFT | Stock | 28.698 | 28.74 | 28.67 | 28.72 | 2663181.0 |
| 2009-11-09 12:30:00 | MSFT | Stock | 28.73 | 28.77 | 28.69 | 28.77 | 3043626.0 |
| 2009-11-09 13:00:00 | MSFT | Stock | 28.77 | 28.83 | 28.75 | 28.8 | 2347020.0 |
| 2009-11-09 13:30:00 | MSFT | Stock | 28.8 | 28.89 | 28.79 | 28.86 | 3841071.0 |
| 2009-11-09 14:00:00 | MSFT | Stock | 28.86 | 28.98 | 28.85 | 28.98 | 3134208.0 |
| 2009-11-09 14:30:00 | MSFT | Stock | 28.97 | 29.0 | 28.96 | 28.99 | 3335491.0 |
| 2009-11-09 15:00:00 | MSFT | Stock | 28.992 | 29.0 | 28.97 | 28.985 | 3830204.0 |
| 2009-11-09 15:30:00 | MSFT | Stock | 28.985 | 29.0 | 28.95 | 28.99 | 7660236.0 |
| 2009-11-09 16:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.561 | 29.0 | 6011105.0 |
| 2009-11-09 16:30:00 | MSFT | Stock | 28.99 | 29.0 | 28.97 | 29.0 | 71811.0 |
> showing 50 of 74,718 rows — these rows as CSV