PREVIEW / stock_5min / 2009-01-21
file: by_date/stock_5min/2009/2009-01-21.parquet size: 4.5 MB rows: 307,414 symbols: 3,308
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-21 06:40:00 | AAPL | Stock | 2.8375 | 2.8375 | 2.8375 | 2.8375 | 18200.0 |
| 2009-01-21 07:00:00 | AAPL | Stock | 2.8375 | 2.8489 | 2.8375 | 2.8489 | 11200.0 |
| 2009-01-21 07:05:00 | AAPL | Stock | 2.8375 | 2.8375 | 2.8371 | 2.8371 | 85344.0 |
| 2009-01-21 07:15:00 | AAPL | Stock | 2.8371 | 2.8375 | 2.8371 | 2.8375 | 12880.0 |
| 2009-01-21 07:20:00 | AAPL | Stock | 2.8375 | 2.8375 | 2.8339 | 2.8339 | 72800.0 |
| 2009-01-21 07:25:00 | AAPL | Stock | 2.8304 | 2.8304 | 2.8239 | 2.8239 | 15400.0 |
| 2009-01-21 08:00:00 | AAPL | Stock | 2.8282 | 2.8357 | 2.8243 | 2.8286 | 177464.0 |
| 2009-01-21 08:05:00 | AAPL | Stock | 2.8275 | 2.8286 | 2.8239 | 2.8268 | 132132.0 |
| 2009-01-21 08:10:00 | AAPL | Stock | 2.8264 | 2.8304 | 2.8264 | 2.8271 | 166404.0 |
| 2009-01-21 08:15:00 | AAPL | Stock | 2.8279 | 2.8286 | 2.8246 | 2.8264 | 129500.0 |
| 2009-01-21 08:25:00 | AAPL | Stock | 2.8282 | 2.8304 | 2.8282 | 2.8304 | 235508.0 |
| 2009-01-21 08:30:00 | AAPL | Stock | 2.8304 | 2.8379 | 2.8286 | 2.8379 | 431564.0 |
| 2009-01-21 08:35:00 | AAPL | Stock | 2.8357 | 2.8446 | 2.8332 | 2.8429 | 269976.0 |
| 2009-01-21 08:40:00 | AAPL | Stock | 2.8443 | 2.8464 | 2.8375 | 2.8375 | 334208.0 |
| 2009-01-21 08:45:00 | AAPL | Stock | 2.8393 | 2.8396 | 2.8354 | 2.8357 | 120932.0 |
| 2009-01-21 08:50:00 | AAPL | Stock | 2.8371 | 2.8411 | 2.8332 | 2.8393 | 75600.0 |
| 2009-01-21 08:55:00 | AAPL | Stock | 2.8393 | 2.8432 | 2.8393 | 2.8432 | 47600.0 |
| 2009-01-21 09:00:00 | AAPL | Stock | 2.8436 | 2.8464 | 2.8436 | 2.8457 | 72576.0 |
| 2009-01-21 09:05:00 | AAPL | Stock | 2.8446 | 2.8464 | 2.8418 | 2.8443 | 262612.0 |
| 2009-01-21 09:10:00 | AAPL | Stock | 2.8443 | 2.8464 | 2.8418 | 2.8418 | 189728.0 |
| 2009-01-21 09:15:00 | AAPL | Stock | 2.8418 | 2.8439 | 2.8393 | 2.8429 | 504028.0 |
| 2009-01-21 09:20:00 | AAPL | Stock | 2.8421 | 2.8475 | 2.8379 | 2.8421 | 274400.0 |
| 2009-01-21 09:25:00 | AAPL | Stock | 2.8425 | 2.8429 | 2.8371 | 2.8393 | 222068.0 |
| 2009-01-21 09:30:00 | AAPL | Stock | 2.8375 | 2.8518 | 2.8325 | 2.8489 | 16985612.0 |
| 2009-01-21 09:35:00 | AAPL | Stock | 2.8493 | 2.8671 | 2.8454 | 2.8525 | 19346824.0 |
| 2009-01-21 09:40:00 | AAPL | Stock | 2.8525 | 2.8539 | 2.8429 | 2.8491 | 13299776.0 |
| 2009-01-21 09:45:00 | AAPL | Stock | 2.8482 | 2.8879 | 2.8479 | 2.8839 | 22220492.0 |
| 2009-01-21 09:50:00 | AAPL | Stock | 2.8846 | 2.9143 | 2.8804 | 2.9086 | 24137232.0 |
| 2009-01-21 09:55:00 | AAPL | Stock | 2.9084 | 2.9086 | 2.8857 | 2.8893 | 15653848.0 |
| 2009-01-21 10:00:00 | AAPL | Stock | 2.8914 | 2.8989 | 2.8857 | 2.8868 | 12193832.0 |
| 2009-01-21 10:05:00 | AAPL | Stock | 2.8864 | 2.8954 | 2.8739 | 2.8757 | 12210604.0 |
| 2009-01-21 10:10:00 | AAPL | Stock | 2.8757 | 2.8864 | 2.8714 | 2.875 | 10375680.0 |
| 2009-01-21 10:15:00 | AAPL | Stock | 2.875 | 2.8882 | 2.8736 | 2.8843 | 11783716.0 |
| 2009-01-21 10:20:00 | AAPL | Stock | 2.8839 | 2.8904 | 2.8732 | 2.8779 | 11742052.0 |
| 2009-01-21 10:25:00 | AAPL | Stock | 2.8775 | 2.8836 | 2.8625 | 2.8646 | 11346524.0 |
| 2009-01-21 10:30:00 | AAPL | Stock | 2.8639 | 2.8721 | 2.8621 | 2.8661 | 8315440.0 |
| 2009-01-21 10:35:00 | AAPL | Stock | 2.8661 | 2.8675 | 2.8568 | 2.8582 | 14000700.0 |
| 2009-01-21 10:40:00 | AAPL | Stock | 2.8582 | 2.8589 | 2.8518 | 2.8564 | 8907276.0 |
| 2009-01-21 10:45:00 | AAPL | Stock | 2.8579 | 2.8686 | 2.8575 | 2.8593 | 9579388.0 |
| 2009-01-21 10:50:00 | AAPL | Stock | 2.8593 | 2.8636 | 2.8543 | 2.86 | 8272628.0 |
| 2009-01-21 10:55:00 | AAPL | Stock | 2.8589 | 2.8596 | 2.8482 | 2.8511 | 9367484.0 |
| 2009-01-21 11:00:00 | AAPL | Stock | 2.8511 | 2.8607 | 2.8493 | 2.8586 | 6828136.0 |
| 2009-01-21 11:05:00 | AAPL | Stock | 2.8579 | 2.8696 | 2.8579 | 2.8661 | 7352128.0 |
| 2009-01-21 11:10:00 | AAPL | Stock | 2.8668 | 2.8668 | 2.8579 | 2.8593 | 5609520.0 |
| 2009-01-21 11:15:00 | AAPL | Stock | 2.8593 | 2.8639 | 2.8571 | 2.8614 | 6814024.0 |
| 2009-01-21 11:20:00 | AAPL | Stock | 2.8611 | 2.8671 | 2.8589 | 2.865 | 6339984.0 |
| 2009-01-21 11:25:00 | AAPL | Stock | 2.865 | 2.8661 | 2.8571 | 2.8643 | 7468748.0 |
| 2009-01-21 11:30:00 | AAPL | Stock | 2.865 | 2.8693 | 2.8589 | 2.8607 | 7774032.0 |
| 2009-01-21 11:35:00 | AAPL | Stock | 2.8607 | 2.8657 | 2.8589 | 2.8625 | 5868828.0 |
| 2009-01-21 11:40:00 | AAPL | Stock | 2.8625 | 2.8696 | 2.8596 | 2.8646 | 4519004.0 |
> showing 50 of 307,414 rows — these rows as CSV