PREVIEW / stock_30min / 2010-09-15
file: by_date/stock_30min/2010/2010-09-15.parquet size: 1.3 MB rows: 72,483 symbols: 3,455
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-15 07:00:00 | AAPL | Stock | 9.5893 | 9.5946 | 9.5743 | 9.5821 | 35000.0 |
| 2010-09-15 07:30:00 | AAPL | Stock | 9.5854 | 9.6014 | 9.5854 | 9.6 | 30800.0 |
| 2010-09-15 08:00:00 | AAPL | Stock | 9.6004 | 9.6107 | 9.5786 | 9.5943 | 885444.0 |
| 2010-09-15 08:30:00 | AAPL | Stock | 9.5825 | 9.5943 | 9.5582 | 9.5779 | 1055236.0 |
| 2010-09-15 09:00:00 | AAPL | Stock | 9.5775 | 9.585 | 9.5632 | 9.5782 | 881048.0 |
| 2010-09-15 09:30:00 | AAPL | Stock | 9.5775 | 9.6304 | 9.5657 | 9.6175 | 70096600.0 |
| 2010-09-15 10:00:00 | AAPL | Stock | 9.6175 | 9.6368 | 9.6007 | 9.6232 | 47769288.0 |
| 2010-09-15 10:30:00 | AAPL | Stock | 9.6243 | 9.6357 | 9.6154 | 9.6336 | 29606276.0 |
| 2010-09-15 11:00:00 | AAPL | Stock | 9.6339 | 9.635 | 9.6068 | 9.6114 | 25716068.0 |
| 2010-09-15 11:30:00 | AAPL | Stock | 9.6129 | 9.6271 | 9.6093 | 9.6246 | 15648836.0 |
| 2010-09-15 12:00:00 | AAPL | Stock | 9.6248 | 9.6386 | 9.6232 | 9.6371 | 20256544.0 |
| 2010-09-15 12:30:00 | AAPL | Stock | 9.6375 | 9.6411 | 9.6268 | 9.64 | 15575196.0 |
| 2010-09-15 13:00:00 | AAPL | Stock | 9.64 | 9.6425 | 9.6346 | 9.6346 | 17891860.0 |
| 2010-09-15 13:30:00 | AAPL | Stock | 9.6354 | 9.6421 | 9.6343 | 9.6417 | 13115116.0 |
| 2010-09-15 14:00:00 | AAPL | Stock | 9.6417 | 9.6418 | 9.6289 | 9.6316 | 16417688.0 |
| 2010-09-15 14:30:00 | AAPL | Stock | 9.6311 | 9.6429 | 9.625 | 9.6404 | 30818816.0 |
| 2010-09-15 15:00:00 | AAPL | Stock | 9.64 | 9.6536 | 9.6329 | 9.6518 | 43391180.0 |
| 2010-09-15 15:30:00 | AAPL | Stock | 9.6511 | 9.6564 | 9.6429 | 9.6511 | 49423080.0 |
| 2010-09-15 16:00:00 | AAPL | Stock | 9.6536 | 9.6539 | 9.5732 | 9.6402 | 14386036.0 |
| 2010-09-15 16:30:00 | AAPL | Stock | 9.6514 | 9.6546 | 9.6448 | 9.6536 | 507864.0 |
| 2010-09-15 17:00:00 | AAPL | Stock | 9.6227 | 9.6571 | 9.6227 | 9.6518 | 361256.0 |
| 2010-09-15 17:30:00 | AAPL | Stock | 9.6554 | 9.6654 | 9.6554 | 9.665 | 213304.0 |
| 2010-09-15 18:00:00 | AAPL | Stock | 9.6661 | 9.6679 | 9.6507 | 9.6596 | 264880.0 |
| 2010-09-15 18:30:00 | AAPL | Stock | 9.6596 | 9.6679 | 9.6589 | 9.6643 | 271096.0 |
| 2010-09-15 19:00:00 | AAPL | Stock | 9.6679 | 9.6679 | 9.6639 | 9.6639 | 76300.0 |
| 2010-09-15 19:30:00 | AAPL | Stock | 9.6636 | 9.6871 | 9.6632 | 9.6864 | 1320424.0 |
| 2010-09-15 07:30:00 | MSFT | Stock | 24.97 | 24.97 | 24.97 | 24.97 | 500.0 |
| 2010-09-15 08:00:00 | MSFT | Stock | 25.0 | 25.0 | 24.97 | 24.99 | 4555.0 |
| 2010-09-15 08:30:00 | MSFT | Stock | 24.99 | 25.02 | 24.95 | 25.0 | 21502.0 |
| 2010-09-15 09:00:00 | MSFT | Stock | 25.01 | 25.21 | 24.98 | 25.08 | 95657.0 |
| 2010-09-15 09:30:00 | MSFT | Stock | 25.09 | 25.1 | 24.92 | 25.012 | 4543674.0 |
| 2010-09-15 10:00:00 | MSFT | Stock | 25.015 | 25.08 | 24.96 | 25.04 | 3743633.0 |
| 2010-09-15 10:30:00 | MSFT | Stock | 25.045 | 25.07 | 25.02 | 25.03 | 3333629.0 |
| 2010-09-15 11:00:00 | MSFT | Stock | 25.04 | 25.05 | 24.99 | 25.015 | 3002422.0 |
| 2010-09-15 11:30:00 | MSFT | Stock | 25.02 | 25.06 | 24.97 | 25.04 | 2503444.0 |
| 2010-09-15 12:00:00 | MSFT | Stock | 25.045 | 25.12 | 25.04 | 25.1 | 1943939.0 |
| 2010-09-15 12:30:00 | MSFT | Stock | 25.09 | 25.2 | 25.07 | 25.17 | 1966410.0 |
| 2010-09-15 13:00:00 | MSFT | Stock | 25.17 | 25.22 | 25.16 | 25.21 | 1852930.0 |
| 2010-09-15 13:30:00 | MSFT | Stock | 25.22 | 25.22 | 25.13 | 25.15 | 3792894.0 |
| 2010-09-15 14:00:00 | MSFT | Stock | 25.15 | 25.16 | 25.08 | 25.11 | 4105201.0 |
| 2010-09-15 14:30:00 | MSFT | Stock | 25.12 | 25.12 | 25.01 | 25.09 | 4259469.0 |
| 2010-09-15 15:00:00 | MSFT | Stock | 25.08 | 25.17 | 25.06 | 25.142 | 4616295.0 |
| 2010-09-15 15:30:00 | MSFT | Stock | 25.14 | 25.16 | 25.08 | 25.11 | 8861924.0 |
| 2010-09-15 16:00:00 | MSFT | Stock | 25.1 | 25.17 | 25.028 | 25.17 | 6104178.0 |
| 2010-09-15 16:30:00 | MSFT | Stock | 25.17 | 25.17 | 25.11 | 25.16 | 28188.0 |
| 2010-09-15 17:00:00 | MSFT | Stock | 25.021 | 25.17 | 25.021 | 25.09 | 44746.0 |
| 2010-09-15 17:30:00 | MSFT | Stock | 25.15 | 25.16 | 25.12 | 25.12 | 3500.0 |
| 2010-09-15 18:00:00 | MSFT | Stock | 25.13 | 25.16 | 25.11 | 25.16 | 130676.0 |
| 2010-09-15 18:30:00 | MSFT | Stock | 25.12 | 25.12 | 25.12 | 25.12 | 400.0 |
| 2010-09-15 19:00:00 | MSFT | Stock | 25.14 | 25.14 | 25.14 | 25.14 | 500.0 |
> showing 50 of 72,483 rows — these rows as CSV