PREVIEW / stock_1min / 2010-10-28
file: by_date/stock_1min/2010/2010-10-28.parquet size: 12.6 MB rows: 954,896 symbols: 2,815
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-10-28 04:01:00 | AAPL | Stock | 10.93 | 10.93 | 10.93 | 10.93 | 2800.0 |
| 2010-10-28 05:18:00 | AAPL | Stock | 10.9657 | 10.9657 | 10.9657 | 10.9657 | 2800.0 |
| 2010-10-28 05:33:00 | AAPL | Stock | 10.9596 | 10.9596 | 10.9596 | 10.9596 | 2800.0 |
| 2010-10-28 05:37:00 | AAPL | Stock | 10.9629 | 10.9629 | 10.9629 | 10.9629 | 2800.0 |
| 2010-10-28 05:42:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-10-28 06:33:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.9643 | 10.9643 | 2800.0 |
| 2010-10-28 07:05:00 | AAPL | Stock | 10.9286 | 10.9286 | 10.9286 | 10.9286 | 2800.0 |
| 2010-10-28 07:14:00 | AAPL | Stock | 10.9625 | 10.9625 | 10.9625 | 10.9625 | 2800.0 |
| 2010-10-28 07:22:00 | AAPL | Stock | 10.9482 | 10.9554 | 10.9482 | 10.9554 | 5600.0 |
| 2010-10-28 07:28:00 | AAPL | Stock | 10.9536 | 10.9536 | 10.9536 | 10.9536 | 11200.0 |
| 2010-10-28 07:33:00 | AAPL | Stock | 10.955 | 10.955 | 10.9536 | 10.955 | 180040.0 |
| 2010-10-28 07:34:00 | AAPL | Stock | 10.9543 | 10.955 | 10.9543 | 10.955 | 64400.0 |
| 2010-10-28 07:35:00 | AAPL | Stock | 10.9543 | 10.9543 | 10.9543 | 10.9543 | 2800.0 |
| 2010-10-28 07:38:00 | AAPL | Stock | 10.9543 | 10.9543 | 10.9543 | 10.9543 | 8400.0 |
| 2010-10-28 07:39:00 | AAPL | Stock | 10.9546 | 10.955 | 10.9546 | 10.9546 | 105560.0 |
| 2010-10-28 07:40:00 | AAPL | Stock | 10.9543 | 10.9543 | 10.9543 | 10.9543 | 2800.0 |
| 2010-10-28 07:41:00 | AAPL | Stock | 10.9525 | 10.9525 | 10.9393 | 10.9393 | 15400.0 |
| 2010-10-28 07:42:00 | AAPL | Stock | 10.945 | 10.945 | 10.9375 | 10.9375 | 30800.0 |
| 2010-10-28 07:45:00 | AAPL | Stock | 10.9379 | 10.9379 | 10.9379 | 10.9379 | 2800.0 |
| 2010-10-28 07:53:00 | AAPL | Stock | 10.9464 | 10.9529 | 10.9464 | 10.9529 | 74480.0 |
| 2010-10-28 07:57:00 | AAPL | Stock | 10.95 | 10.95 | 10.95 | 10.95 | 9800.0 |
| 2010-10-28 08:00:00 | AAPL | Stock | 10.9518 | 10.9529 | 10.9468 | 10.9471 | 54404.0 |
| 2010-10-28 08:01:00 | AAPL | Stock | 10.9479 | 10.9479 | 10.9411 | 10.9432 | 249396.0 |
| 2010-10-28 08:02:00 | AAPL | Stock | 10.9507 | 10.9507 | 10.9464 | 10.9464 | 18200.0 |
| 2010-10-28 08:03:00 | AAPL | Stock | 10.9464 | 10.9464 | 10.9432 | 10.9432 | 73500.0 |
| 2010-10-28 08:04:00 | AAPL | Stock | 10.9432 | 10.9432 | 10.9411 | 10.9411 | 182756.0 |
| 2010-10-28 08:05:00 | AAPL | Stock | 10.9411 | 10.9414 | 10.935 | 10.935 | 58800.0 |
| 2010-10-28 08:06:00 | AAPL | Stock | 10.9329 | 10.9361 | 10.9329 | 10.9354 | 23800.0 |
| 2010-10-28 08:07:00 | AAPL | Stock | 10.9357 | 10.9411 | 10.9339 | 10.9346 | 44940.0 |
| 2010-10-28 08:08:00 | AAPL | Stock | 10.9361 | 10.9361 | 10.9361 | 10.9361 | 8400.0 |
| 2010-10-28 08:09:00 | AAPL | Stock | 10.9429 | 10.9429 | 10.9429 | 10.9429 | 6356.0 |
| 2010-10-28 08:10:00 | AAPL | Stock | 10.9375 | 10.9375 | 10.9375 | 10.9375 | 7000.0 |
| 2010-10-28 08:11:00 | AAPL | Stock | 10.9393 | 10.9393 | 10.9393 | 10.9393 | 2800.0 |
| 2010-10-28 08:12:00 | AAPL | Stock | 10.9429 | 10.9429 | 10.9411 | 10.9429 | 12320.0 |
| 2010-10-28 08:13:00 | AAPL | Stock | 10.9439 | 10.9454 | 10.9439 | 10.9454 | 5600.0 |
| 2010-10-28 08:15:00 | AAPL | Stock | 10.9411 | 10.9464 | 10.9411 | 10.9464 | 30240.0 |
| 2010-10-28 08:17:00 | AAPL | Stock | 10.9418 | 10.95 | 10.9414 | 10.95 | 33600.0 |
| 2010-10-28 08:18:00 | AAPL | Stock | 10.95 | 10.955 | 10.95 | 10.9536 | 407456.0 |
| 2010-10-28 08:19:00 | AAPL | Stock | 10.9539 | 10.9643 | 10.9539 | 10.9643 | 124124.0 |
| 2010-10-28 08:20:00 | AAPL | Stock | 10.9643 | 10.9643 | 10.955 | 10.9557 | 127120.0 |
| 2010-10-28 08:21:00 | AAPL | Stock | 10.9518 | 10.9632 | 10.9511 | 10.9611 | 119000.0 |
| 2010-10-28 08:22:00 | AAPL | Stock | 10.9629 | 10.9632 | 10.955 | 10.9557 | 106596.0 |
| 2010-10-28 08:23:00 | AAPL | Stock | 10.9607 | 10.9632 | 10.9607 | 10.9632 | 65324.0 |
| 2010-10-28 08:24:00 | AAPL | Stock | 10.9629 | 10.9632 | 10.9589 | 10.9632 | 34244.0 |
| 2010-10-28 08:25:00 | AAPL | Stock | 10.9632 | 10.9639 | 10.9593 | 10.9593 | 89740.0 |
| 2010-10-28 08:26:00 | AAPL | Stock | 10.9589 | 10.9589 | 10.9589 | 10.9589 | 5740.0 |
| 2010-10-28 08:27:00 | AAPL | Stock | 10.9589 | 10.9593 | 10.9589 | 10.9589 | 13356.0 |
| 2010-10-28 08:28:00 | AAPL | Stock | 10.9589 | 10.9589 | 10.9554 | 10.9571 | 81200.0 |
| 2010-10-28 08:29:00 | AAPL | Stock | 10.9579 | 10.9579 | 10.9579 | 10.9579 | 2800.0 |
| 2010-10-28 08:30:00 | AAPL | Stock | 10.9589 | 10.9632 | 10.9518 | 10.9589 | 857500.0 |
> showing 50 of 954,896 rows — these rows as CSV