PREVIEW / stock_1min / 2009-11-05
file: by_date/stock_1min/2009/2009-11-05.parquet size: 12.8 MB rows: 973,284 symbols: 2,765
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-05 04:38:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 2800.0 |
| 2009-11-05 06:02:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 2800.0 |
| 2009-11-05 06:51:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.8286 | 6.8286 | 4396.0 |
| 2009-11-05 07:40:00 | AAPL | Stock | 6.8339 | 6.8339 | 6.8229 | 6.8229 | 14000.0 |
| 2009-11-05 08:00:00 | AAPL | Stock | 6.8339 | 6.8454 | 6.8339 | 6.8454 | 22400.0 |
| 2009-11-05 08:01:00 | AAPL | Stock | 6.8443 | 6.8443 | 6.8443 | 6.8443 | 2800.0 |
| 2009-11-05 08:02:00 | AAPL | Stock | 6.8454 | 6.8514 | 6.8454 | 6.8482 | 26236.0 |
| 2009-11-05 08:03:00 | AAPL | Stock | 6.8504 | 6.8571 | 6.8504 | 6.8571 | 112980.0 |
| 2009-11-05 08:04:00 | AAPL | Stock | 6.8571 | 6.8632 | 6.8571 | 6.8632 | 30156.0 |
| 2009-11-05 08:05:00 | AAPL | Stock | 6.8575 | 6.8575 | 6.8575 | 6.8575 | 16800.0 |
| 2009-11-05 08:06:00 | AAPL | Stock | 6.8639 | 6.8639 | 6.8607 | 6.8607 | 38080.0 |
| 2009-11-05 08:07:00 | AAPL | Stock | 6.8632 | 6.8643 | 6.8632 | 6.8643 | 8400.0 |
| 2009-11-05 08:08:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8564 | 6.8564 | 21056.0 |
| 2009-11-05 08:11:00 | AAPL | Stock | 6.8571 | 6.8604 | 6.8571 | 6.8604 | 35672.0 |
| 2009-11-05 08:12:00 | AAPL | Stock | 6.8571 | 6.8607 | 6.8571 | 6.8571 | 42000.0 |
| 2009-11-05 08:13:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 4200.0 |
| 2009-11-05 08:14:00 | AAPL | Stock | 6.8607 | 6.8607 | 6.8571 | 6.8571 | 9800.0 |
| 2009-11-05 08:15:00 | AAPL | Stock | 6.86 | 6.86 | 6.86 | 6.86 | 2800.0 |
| 2009-11-05 08:17:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 14000.0 |
| 2009-11-05 08:18:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 11200.0 |
| 2009-11-05 08:19:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 38780.0 |
| 2009-11-05 08:20:00 | AAPL | Stock | 6.8571 | 6.8604 | 6.8571 | 6.8589 | 11200.0 |
| 2009-11-05 08:23:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8543 | 6.8543 | 36260.0 |
| 2009-11-05 08:24:00 | AAPL | Stock | 6.8571 | 6.8589 | 6.8525 | 6.8589 | 20608.0 |
| 2009-11-05 08:25:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8504 | 6.8504 | 5600.0 |
| 2009-11-05 08:26:00 | AAPL | Stock | 6.85 | 6.85 | 6.85 | 6.85 | 10080.0 |
| 2009-11-05 08:27:00 | AAPL | Stock | 6.8464 | 6.8464 | 6.8464 | 6.8464 | 8400.0 |
| 2009-11-05 08:28:00 | AAPL | Stock | 6.8461 | 6.8461 | 6.8461 | 6.8461 | 2800.0 |
| 2009-11-05 08:29:00 | AAPL | Stock | 6.85 | 6.85 | 6.85 | 6.85 | 13860.0 |
| 2009-11-05 08:30:00 | AAPL | Stock | 6.8464 | 6.8571 | 6.8464 | 6.8571 | 43848.0 |
| 2009-11-05 08:31:00 | AAPL | Stock | 6.8521 | 6.8521 | 6.8504 | 6.8504 | 8400.0 |
| 2009-11-05 08:32:00 | AAPL | Stock | 6.8507 | 6.8507 | 6.8507 | 6.8507 | 5292.0 |
| 2009-11-05 08:33:00 | AAPL | Stock | 6.8504 | 6.8568 | 6.8504 | 6.8561 | 30296.0 |
| 2009-11-05 08:34:00 | AAPL | Stock | 6.8521 | 6.8521 | 6.8511 | 6.8518 | 22400.0 |
| 2009-11-05 08:36:00 | AAPL | Stock | 6.8557 | 6.8589 | 6.8557 | 6.8589 | 56000.0 |
| 2009-11-05 08:37:00 | AAPL | Stock | 6.8586 | 6.8636 | 6.8586 | 6.8632 | 38024.0 |
| 2009-11-05 08:38:00 | AAPL | Stock | 6.8636 | 6.8639 | 6.8611 | 6.8629 | 25200.0 |
| 2009-11-05 08:39:00 | AAPL | Stock | 6.8632 | 6.8636 | 6.8632 | 6.8632 | 14000.0 |
| 2009-11-05 08:40:00 | AAPL | Stock | 6.8621 | 6.875 | 6.8621 | 6.8725 | 179900.0 |
| 2009-11-05 08:41:00 | AAPL | Stock | 6.8654 | 6.8714 | 6.8654 | 6.8696 | 55160.0 |
| 2009-11-05 08:42:00 | AAPL | Stock | 6.865 | 6.8668 | 6.8643 | 6.8661 | 30240.0 |
| 2009-11-05 08:43:00 | AAPL | Stock | 6.865 | 6.8711 | 6.865 | 6.8711 | 74200.0 |
| 2009-11-05 08:44:00 | AAPL | Stock | 6.8712 | 6.8712 | 6.8693 | 6.8693 | 9464.0 |
| 2009-11-05 08:45:00 | AAPL | Stock | 6.8679 | 6.8704 | 6.8679 | 6.8696 | 50764.0 |
| 2009-11-05 08:46:00 | AAPL | Stock | 6.8704 | 6.8704 | 6.8671 | 6.8671 | 53200.0 |
| 2009-11-05 08:47:00 | AAPL | Stock | 6.8661 | 6.8696 | 6.8661 | 6.8696 | 49980.0 |
| 2009-11-05 08:48:00 | AAPL | Stock | 6.8711 | 6.8711 | 6.8693 | 6.8704 | 30800.0 |
| 2009-11-05 08:49:00 | AAPL | Stock | 6.8711 | 6.8714 | 6.8707 | 6.8714 | 21532.0 |
| 2009-11-05 08:50:00 | AAPL | Stock | 6.8711 | 6.8714 | 6.8711 | 6.8714 | 27888.0 |
| 2009-11-05 08:52:00 | AAPL | Stock | 6.8686 | 6.8686 | 6.8668 | 6.8668 | 45640.0 |
> showing 50 of 973,284 rows — these rows as CSV