PREVIEW / stock_1min / 2009-11-06
file: by_date/stock_1min/2009/2009-11-06.parquet size: 12.2 MB rows: 929,622 symbols: 2,736
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-06 05:16:00 | AAPL | Stock | 6.9407 | 6.9407 | 6.9407 | 6.9407 | 5600.0 |
| 2009-11-06 05:27:00 | AAPL | Stock | 6.9629 | 6.9629 | 6.9514 | 6.9514 | 5600.0 |
| 2009-11-06 07:16:00 | AAPL | Stock | 6.9393 | 6.9393 | 6.9143 | 6.9143 | 5600.0 |
| 2009-11-06 07:19:00 | AAPL | Stock | 6.9504 | 6.9504 | 6.9504 | 6.9504 | 2800.0 |
| 2009-11-06 07:29:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2009-11-06 07:31:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 2800.0 |
| 2009-11-06 07:44:00 | AAPL | Stock | 6.9414 | 6.9414 | 6.9411 | 6.9414 | 65408.0 |
| 2009-11-06 07:45:00 | AAPL | Stock | 6.9414 | 6.9414 | 6.9414 | 6.9414 | 5600.0 |
| 2009-11-06 07:46:00 | AAPL | Stock | 6.9461 | 6.9464 | 6.9461 | 6.9464 | 14000.0 |
| 2009-11-06 07:49:00 | AAPL | Stock | 6.9461 | 6.9461 | 6.9461 | 6.9461 | 8400.0 |
| 2009-11-06 07:55:00 | AAPL | Stock | 6.9461 | 6.9461 | 6.9461 | 6.9461 | 5600.0 |
| 2009-11-06 08:00:00 | AAPL | Stock | 6.9464 | 6.955 | 6.9464 | 6.955 | 30800.0 |
| 2009-11-06 08:01:00 | AAPL | Stock | 6.95 | 6.95 | 6.9496 | 6.9496 | 23632.0 |
| 2009-11-06 08:02:00 | AAPL | Stock | 6.9504 | 6.9518 | 6.9496 | 6.95 | 33600.0 |
| 2009-11-06 08:03:00 | AAPL | Stock | 6.9464 | 6.95 | 6.9454 | 6.95 | 73920.0 |
| 2009-11-06 08:04:00 | AAPL | Stock | 6.95 | 6.9518 | 6.9496 | 6.9518 | 28000.0 |
| 2009-11-06 08:05:00 | AAPL | Stock | 6.9564 | 6.9571 | 6.9518 | 6.9571 | 33684.0 |
| 2009-11-06 08:06:00 | AAPL | Stock | 6.9571 | 6.9589 | 6.9554 | 6.9571 | 114100.0 |
| 2009-11-06 08:07:00 | AAPL | Stock | 6.9575 | 6.9579 | 6.9521 | 6.9521 | 51660.0 |
| 2009-11-06 08:08:00 | AAPL | Stock | 6.9557 | 6.9571 | 6.9496 | 6.95 | 70560.0 |
| 2009-11-06 08:09:00 | AAPL | Stock | 6.95 | 6.95 | 6.9498 | 6.95 | 36400.0 |
| 2009-11-06 08:10:00 | AAPL | Stock | 6.9482 | 6.9571 | 6.9482 | 6.9504 | 100324.0 |
| 2009-11-06 08:11:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 28000.0 |
| 2009-11-06 08:12:00 | AAPL | Stock | 6.95 | 6.9518 | 6.95 | 6.9518 | 42000.0 |
| 2009-11-06 08:13:00 | AAPL | Stock | 6.9518 | 6.9518 | 6.9429 | 6.9429 | 30800.0 |
| 2009-11-06 08:14:00 | AAPL | Stock | 6.945 | 6.945 | 6.945 | 6.945 | 2800.0 |
| 2009-11-06 08:15:00 | AAPL | Stock | 6.9496 | 6.9554 | 6.9496 | 6.9554 | 43120.0 |
| 2009-11-06 08:16:00 | AAPL | Stock | 6.9568 | 6.9589 | 6.9568 | 6.9589 | 8400.0 |
| 2009-11-06 08:17:00 | AAPL | Stock | 6.9554 | 6.9554 | 6.9554 | 6.9554 | 5600.0 |
| 2009-11-06 08:18:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 9800.0 |
| 2009-11-06 08:19:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 12600.0 |
| 2009-11-06 08:20:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9571 | 6.9571 | 7000.0 |
| 2009-11-06 08:21:00 | AAPL | Stock | 6.9557 | 6.9571 | 6.9557 | 6.9571 | 9800.0 |
| 2009-11-06 08:23:00 | AAPL | Stock | 6.9607 | 6.9607 | 6.9571 | 6.9571 | 81844.0 |
| 2009-11-06 08:25:00 | AAPL | Stock | 6.9607 | 6.9621 | 6.9607 | 6.9611 | 22400.0 |
| 2009-11-06 08:26:00 | AAPL | Stock | 6.9621 | 6.9621 | 6.9604 | 6.9618 | 83384.0 |
| 2009-11-06 08:27:00 | AAPL | Stock | 6.9621 | 6.9621 | 6.9568 | 6.9575 | 90020.0 |
| 2009-11-06 08:28:00 | AAPL | Stock | 6.9512 | 6.9618 | 6.9511 | 6.9589 | 80780.0 |
| 2009-11-06 08:29:00 | AAPL | Stock | 6.9536 | 6.9607 | 6.9464 | 6.9464 | 88200.0 |
| 2009-11-06 08:30:00 | AAPL | Stock | 6.9536 | 6.9536 | 6.9018 | 6.9064 | 430780.0 |
| 2009-11-06 08:31:00 | AAPL | Stock | 6.9132 | 6.9239 | 6.9107 | 6.9186 | 122500.0 |
| 2009-11-06 08:32:00 | AAPL | Stock | 6.9246 | 6.9318 | 6.9164 | 6.9168 | 219604.0 |
| 2009-11-06 08:33:00 | AAPL | Stock | 6.9243 | 6.9243 | 6.9039 | 6.9064 | 209832.0 |
| 2009-11-06 08:34:00 | AAPL | Stock | 6.9064 | 6.9075 | 6.8857 | 6.8893 | 425600.0 |
| 2009-11-06 08:35:00 | AAPL | Stock | 6.8875 | 6.8882 | 6.8729 | 6.8764 | 220388.0 |
| 2009-11-06 08:36:00 | AAPL | Stock | 6.8786 | 6.8929 | 6.8786 | 6.8875 | 176120.0 |
| 2009-11-06 08:37:00 | AAPL | Stock | 6.8875 | 6.8932 | 6.8875 | 6.8929 | 64120.0 |
| 2009-11-06 08:38:00 | AAPL | Stock | 6.8904 | 6.9004 | 6.8904 | 6.8954 | 61880.0 |
| 2009-11-06 08:39:00 | AAPL | Stock | 6.9004 | 6.9029 | 6.8964 | 6.9018 | 70000.0 |
| 2009-11-06 08:40:00 | AAPL | Stock | 6.9032 | 6.9036 | 6.8932 | 6.8946 | 75320.0 |
> showing 50 of 929,622 rows — these rows as CSV