PREVIEW / stock_30min / 2009-01-13
file: by_date/stock_30min/2009/2009-01-13.parquet size: 1.2 MB rows: 66,433 symbols: 3,315
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-01-13 04:30:00 | AAPL | Stock | 3.1414 | 3.1529 | 3.1414 | 3.1507 | 66416.0 |
| 2009-01-13 05:30:00 | AAPL | Stock | 3.1346 | 3.1346 | 3.1036 | 3.1036 | 46200.0 |
| 2009-01-13 06:00:00 | AAPL | Stock | 3.1286 | 3.1286 | 3.1286 | 3.1286 | 2800.0 |
| 2009-01-13 07:00:00 | AAPL | Stock | 3.1136 | 3.1211 | 3.1136 | 3.1211 | 123200.0 |
| 2009-01-13 07:30:00 | AAPL | Stock | 3.1232 | 3.1268 | 3.1179 | 3.1268 | 117040.0 |
| 2009-01-13 08:00:00 | AAPL | Stock | 3.1386 | 3.1664 | 3.1293 | 3.1311 | 558740.0 |
| 2009-01-13 08:30:00 | AAPL | Stock | 3.1325 | 3.1654 | 3.1286 | 3.1429 | 1045772.0 |
| 2009-01-13 09:00:00 | AAPL | Stock | 3.1411 | 3.1571 | 3.1411 | 3.1518 | 1448384.0 |
| 2009-01-13 09:30:00 | AAPL | Stock | 3.1514 | 3.205 | 3.1382 | 3.1882 | 99780464.0 |
| 2009-01-13 10:00:00 | AAPL | Stock | 3.1886 | 3.2004 | 3.1696 | 3.1727 | 58136008.0 |
| 2009-01-13 10:30:00 | AAPL | Stock | 3.1714 | 3.1764 | 3.1471 | 3.1686 | 51771020.0 |
| 2009-01-13 11:00:00 | AAPL | Stock | 3.1686 | 3.1718 | 3.1307 | 3.1457 | 52020976.0 |
| 2009-01-13 11:30:00 | AAPL | Stock | 3.1461 | 3.1618 | 3.1432 | 3.1514 | 46131820.0 |
| 2009-01-13 12:00:00 | AAPL | Stock | 3.1521 | 3.1593 | 3.1454 | 3.1496 | 34926304.0 |
| 2009-01-13 12:30:00 | AAPL | Stock | 3.1493 | 3.1507 | 3.1196 | 3.1218 | 42041636.0 |
| 2009-01-13 13:00:00 | AAPL | Stock | 3.1218 | 3.1261 | 3.0936 | 3.1021 | 47591460.0 |
| 2009-01-13 13:30:00 | AAPL | Stock | 3.1011 | 3.1768 | 3.0839 | 3.0875 | 44822764.0 |
| 2009-01-13 14:00:00 | AAPL | Stock | 3.0872 | 3.1071 | 3.0846 | 3.0893 | 43662612.0 |
| 2009-01-13 14:30:00 | AAPL | Stock | 3.0893 | 3.1429 | 3.0868 | 3.1296 | 71966972.0 |
| 2009-01-13 15:00:00 | AAPL | Stock | 3.1296 | 3.1321 | 3.1025 | 3.1264 | 76808200.0 |
| 2009-01-13 15:30:00 | AAPL | Stock | 3.1268 | 3.1418 | 3.1093 | 3.1318 | 98346556.0 |
| 2009-01-13 16:00:00 | AAPL | Stock | 3.1321 | 3.1786 | 3.1142 | 3.1314 | 20435688.0 |
| 2009-01-13 16:30:00 | AAPL | Stock | 3.1282 | 3.1388 | 3.1239 | 3.1282 | 153300.0 |
| 2009-01-13 17:00:00 | AAPL | Stock | 3.1275 | 3.1282 | 3.125 | 3.125 | 41720.0 |
| 2009-01-13 17:30:00 | AAPL | Stock | 3.1279 | 3.1354 | 3.1279 | 3.13 | 61180.0 |
| 2009-01-13 18:00:00 | AAPL | Stock | 3.125 | 3.1325 | 3.125 | 3.1321 | 2137520.0 |
| 2009-01-13 18:30:00 | AAPL | Stock | 3.1321 | 3.1339 | 3.1264 | 3.1286 | 121800.0 |
| 2009-01-13 19:00:00 | AAPL | Stock | 3.1339 | 3.1371 | 3.1321 | 3.1361 | 175560.0 |
| 2009-01-13 19:30:00 | AAPL | Stock | 3.1357 | 3.14 | 3.1304 | 3.1386 | 175112.0 |
| 2009-01-13 07:00:00 | MSFT | Stock | 19.51 | 19.53 | 19.51 | 19.53 | 270.0 |
| 2009-01-13 07:30:00 | MSFT | Stock | 19.52 | 19.52 | 19.51 | 19.51 | 428.0 |
| 2009-01-13 08:00:00 | MSFT | Stock | 19.4 | 19.4 | 19.37 | 19.38 | 2819.0 |
| 2009-01-13 08:30:00 | MSFT | Stock | 19.37 | 19.48 | 19.37 | 19.48 | 16074.0 |
| 2009-01-13 09:00:00 | MSFT | Stock | 19.48 | 19.56 | 19.45 | 19.53 | 39315.0 |
| 2009-01-13 09:30:00 | MSFT | Stock | 19.51 | 19.91 | 19.51 | 19.85 | 8466816.0 |
| 2009-01-13 10:00:00 | MSFT | Stock | 19.85 | 19.91 | 19.77 | 19.77 | 5656247.0 |
| 2009-01-13 10:30:00 | MSFT | Stock | 19.77 | 19.93 | 19.67 | 19.9 | 4357977.0 |
| 2009-01-13 11:00:00 | MSFT | Stock | 19.9 | 19.95 | 19.84 | 19.9 | 3944066.0 |
| 2009-01-13 11:30:00 | MSFT | Stock | 19.9 | 19.98 | 19.79 | 19.93 | 3431367.0 |
| 2009-01-13 12:00:00 | MSFT | Stock | 19.94 | 19.99 | 19.86 | 19.91 | 3178523.0 |
| 2009-01-13 12:30:00 | MSFT | Stock | 19.91 | 19.94 | 19.8 | 19.8 | 3301692.0 |
| 2009-01-13 13:00:00 | MSFT | Stock | 19.8 | 19.84 | 19.731 | 19.778 | 2077284.0 |
| 2009-01-13 13:30:00 | MSFT | Stock | 19.775 | 19.79 | 19.62 | 19.66 | 2486750.0 |
| 2009-01-13 14:00:00 | MSFT | Stock | 19.66 | 19.73 | 19.57 | 19.61 | 2479759.0 |
| 2009-01-13 14:30:00 | MSFT | Stock | 19.614 | 19.86 | 19.6 | 19.78 | 4790226.0 |
| 2009-01-13 15:00:00 | MSFT | Stock | 19.78 | 19.79 | 19.62 | 19.77 | 4950985.0 |
| 2009-01-13 15:30:00 | MSFT | Stock | 19.77 | 19.92 | 19.64 | 19.86 | 11152688.0 |
| 2009-01-13 16:00:00 | MSFT | Stock | 19.86 | 19.88 | 19.718 | 19.82 | 4943765.0 |
| 2009-01-13 16:30:00 | MSFT | Stock | 19.88 | 19.88 | 19.88 | 19.88 | 100.0 |
| 2009-01-13 17:00:00 | MSFT | Stock | 19.82 | 19.82 | 19.82 | 19.82 | 950.0 |
> showing 50 of 66,433 rows — these rows as CSV