PREVIEW / stock_30min / 2009-07-23
file: by_date/stock_30min/2009/2009-07-23.parquet size: 1.3 MB rows: 72,454 symbols: 3,359
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-07-23 04:00:00 | AAPL | Stock | 5.6207 | 5.6207 | 5.6207 | 5.6207 | 8400.0 |
| 2009-07-23 07:00:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 26600.0 |
| 2009-07-23 07:30:00 | AAPL | Stock | 5.6068 | 5.6161 | 5.6068 | 5.6161 | 124600.0 |
| 2009-07-23 08:00:00 | AAPL | Stock | 5.6071 | 5.6125 | 5.595 | 5.6 | 815892.0 |
| 2009-07-23 08:30:00 | AAPL | Stock | 5.6054 | 5.6175 | 5.5893 | 5.5929 | 721588.0 |
| 2009-07-23 09:00:00 | AAPL | Stock | 5.5929 | 5.5968 | 5.5757 | 5.5921 | 1241828.0 |
| 2009-07-23 09:30:00 | AAPL | Stock | 5.5939 | 5.6286 | 5.5557 | 5.6286 | 77228844.0 |
| 2009-07-23 10:00:00 | AAPL | Stock | 5.6286 | 5.6418 | 5.6121 | 5.6236 | 51595516.0 |
| 2009-07-23 10:30:00 | AAPL | Stock | 5.6236 | 5.6407 | 5.6139 | 5.6203 | 43711500.0 |
| 2009-07-23 11:00:00 | AAPL | Stock | 5.6207 | 5.6482 | 5.6093 | 5.6464 | 48890408.0 |
| 2009-07-23 11:30:00 | AAPL | Stock | 5.6464 | 5.6511 | 5.635 | 5.6364 | 28465052.0 |
| 2009-07-23 12:00:00 | AAPL | Stock | 5.6371 | 5.6482 | 5.635 | 5.6436 | 18305084.0 |
| 2009-07-23 12:30:00 | AAPL | Stock | 5.6443 | 5.6545 | 5.6357 | 5.6525 | 23332148.0 |
| 2009-07-23 13:00:00 | AAPL | Stock | 5.6521 | 5.6586 | 5.6446 | 5.6513 | 21390516.0 |
| 2009-07-23 13:30:00 | AAPL | Stock | 5.6511 | 5.6586 | 5.6393 | 5.6402 | 21050792.0 |
| 2009-07-23 14:00:00 | AAPL | Stock | 5.6407 | 5.6421 | 5.6136 | 5.6139 | 35509712.0 |
| 2009-07-23 14:30:00 | AAPL | Stock | 5.6146 | 5.6339 | 5.6139 | 5.6239 | 27837600.0 |
| 2009-07-23 15:00:00 | AAPL | Stock | 5.6239 | 5.6486 | 5.6239 | 5.6393 | 35903532.0 |
| 2009-07-23 15:30:00 | AAPL | Stock | 5.6393 | 5.6493 | 5.6086 | 5.6368 | 66267236.0 |
| 2009-07-23 16:00:00 | AAPL | Stock | 5.6368 | 5.6394 | 5.5793 | 5.5807 | 17471524.0 |
| 2009-07-23 16:30:00 | AAPL | Stock | 5.6382 | 5.6382 | 5.5646 | 5.5775 | 2466856.0 |
| 2009-07-23 17:00:00 | AAPL | Stock | 5.5775 | 5.5875 | 5.5714 | 5.5732 | 856408.0 |
| 2009-07-23 17:30:00 | AAPL | Stock | 5.5721 | 5.5839 | 5.5714 | 5.5821 | 342328.0 |
| 2009-07-23 18:00:00 | AAPL | Stock | 5.5807 | 5.6364 | 5.5732 | 5.5821 | 486388.0 |
| 2009-07-23 18:30:00 | AAPL | Stock | 5.5818 | 5.5936 | 5.5804 | 5.5929 | 452956.0 |
| 2009-07-23 19:00:00 | AAPL | Stock | 5.59 | 5.5914 | 5.5875 | 5.5907 | 89404.0 |
| 2009-07-23 19:30:00 | AAPL | Stock | 5.5918 | 5.5921 | 5.5739 | 5.5804 | 208236.0 |
| 2009-07-23 07:00:00 | MSFT | Stock | 24.99 | 24.99 | 24.99 | 24.99 | 1000.0 |
| 2009-07-23 07:30:00 | MSFT | Stock | 24.91 | 24.96 | 24.9 | 24.9 | 8800.0 |
| 2009-07-23 08:00:00 | MSFT | Stock | 24.93 | 24.99 | 24.84 | 24.96 | 62238.0 |
| 2009-07-23 08:30:00 | MSFT | Stock | 24.95 | 24.97 | 24.9 | 24.94 | 29885.0 |
| 2009-07-23 09:00:00 | MSFT | Stock | 24.94 | 24.97 | 24.9 | 24.93 | 28227.0 |
| 2009-07-23 09:30:00 | MSFT | Stock | 24.93 | 25.08 | 24.84 | 25.08 | 6642406.0 |
| 2009-07-23 10:00:00 | MSFT | Stock | 25.08 | 25.21 | 25.03 | 25.1 | 7988037.0 |
| 2009-07-23 10:30:00 | MSFT | Stock | 25.1 | 25.331 | 25.08 | 25.267 | 6578726.0 |
| 2009-07-23 11:00:00 | MSFT | Stock | 25.27 | 25.4 | 25.25 | 25.34 | 6450825.0 |
| 2009-07-23 11:30:00 | MSFT | Stock | 25.34 | 25.5 | 25.29 | 25.36 | 4574481.0 |
| 2009-07-23 12:00:00 | MSFT | Stock | 25.37 | 25.42 | 25.29 | 25.42 | 3565158.0 |
| 2009-07-23 12:30:00 | MSFT | Stock | 25.42 | 25.46 | 25.34 | 25.46 | 4531942.0 |
| 2009-07-23 13:00:00 | MSFT | Stock | 25.457 | 25.61 | 25.4 | 25.6 | 5823501.0 |
| 2009-07-23 13:30:00 | MSFT | Stock | 25.592 | 25.66 | 25.57 | 25.583 | 4369991.0 |
| 2009-07-23 14:00:00 | MSFT | Stock | 25.59 | 25.59 | 25.44 | 25.5 | 5584609.0 |
| 2009-07-23 14:30:00 | MSFT | Stock | 25.51 | 25.65 | 25.48 | 25.628 | 5099980.0 |
| 2009-07-23 15:00:00 | MSFT | Stock | 25.62 | 25.72 | 25.52 | 25.548 | 9547291.0 |
| 2009-07-23 15:30:00 | MSFT | Stock | 25.54 | 25.58 | 25.34 | 25.57 | 16529300.0 |
| 2009-07-23 16:00:00 | MSFT | Stock | 25.57 | 25.6 | 23.31 | 23.37 | 11047472.0 |
| 2009-07-23 16:30:00 | MSFT | Stock | 23.37 | 25.56 | 23.35 | 23.5 | 3100695.0 |
| 2009-07-23 17:00:00 | MSFT | Stock | 23.5 | 23.73 | 23.45 | 23.6 | 1387342.0 |
| 2009-07-23 17:30:00 | MSFT | Stock | 23.61 | 23.65 | 23.49 | 23.5 | 546423.0 |
| 2009-07-23 18:00:00 | MSFT | Stock | 23.52 | 25.56 | 23.5 | 23.76 | 597698.0 |
> showing 50 of 72,454 rows — these rows as CSV