PREVIEW / stock_1min / 2009-10-09
file: by_date/stock_1min/2009/2009-10-09.parquet size: 12.0 MB rows: 908,656 symbols: 2,748
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-10-09 04:50:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 06:19:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 6020.0 |
| 2009-10-09 06:48:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 2800.0 |
| 2009-10-09 07:01:00 | AAPL | Stock | 6.7714 | 6.7714 | 6.7714 | 6.7714 | 2800.0 |
| 2009-10-09 07:35:00 | AAPL | Stock | 6.7711 | 6.7711 | 6.7679 | 6.7679 | 11200.0 |
| 2009-10-09 07:40:00 | AAPL | Stock | 6.7679 | 6.7679 | 6.7679 | 6.7679 | 8400.0 |
| 2009-10-09 07:53:00 | AAPL | Stock | 6.7693 | 6.7693 | 6.7693 | 6.7693 | 2800.0 |
| 2009-10-09 07:56:00 | AAPL | Stock | 6.7721 | 6.7721 | 6.7714 | 6.7714 | 5600.0 |
| 2009-10-09 08:00:00 | AAPL | Stock | 6.7718 | 6.7718 | 6.7714 | 6.7714 | 8568.0 |
| 2009-10-09 08:01:00 | AAPL | Stock | 6.7732 | 6.7732 | 6.7732 | 6.7732 | 2800.0 |
| 2009-10-09 08:03:00 | AAPL | Stock | 6.7732 | 6.7732 | 6.7679 | 6.7679 | 30100.0 |
| 2009-10-09 08:04:00 | AAPL | Stock | 6.76 | 6.7679 | 6.76 | 6.7679 | 44800.0 |
| 2009-10-09 08:07:00 | AAPL | Stock | 6.7646 | 6.7646 | 6.7643 | 6.7643 | 16800.0 |
| 2009-10-09 08:08:00 | AAPL | Stock | 6.7639 | 6.7639 | 6.7639 | 6.7639 | 2800.0 |
| 2009-10-09 08:09:00 | AAPL | Stock | 6.7611 | 6.7611 | 6.7607 | 6.7607 | 5600.0 |
| 2009-10-09 08:13:00 | AAPL | Stock | 6.7589 | 6.7596 | 6.7589 | 6.7596 | 5600.0 |
| 2009-10-09 08:15:00 | AAPL | Stock | 6.7582 | 6.7589 | 6.7536 | 6.7536 | 44548.0 |
| 2009-10-09 08:16:00 | AAPL | Stock | 6.7543 | 6.7543 | 6.7393 | 6.7393 | 94472.0 |
| 2009-10-09 08:17:00 | AAPL | Stock | 6.75 | 6.75 | 6.7432 | 6.7436 | 51800.0 |
| 2009-10-09 08:18:00 | AAPL | Stock | 6.745 | 6.745 | 6.7432 | 6.7446 | 14000.0 |
| 2009-10-09 08:19:00 | AAPL | Stock | 6.7493 | 6.75 | 6.7454 | 6.7454 | 43400.0 |
| 2009-10-09 08:20:00 | AAPL | Stock | 6.7454 | 6.7493 | 6.7454 | 6.7493 | 23800.0 |
| 2009-10-09 08:21:00 | AAPL | Stock | 6.7479 | 6.75 | 6.745 | 6.75 | 26600.0 |
| 2009-10-09 08:22:00 | AAPL | Stock | 6.7479 | 6.7479 | 6.7464 | 6.7464 | 52080.0 |
| 2009-10-09 08:23:00 | AAPL | Stock | 6.745 | 6.7461 | 6.7436 | 6.7436 | 70252.0 |
| 2009-10-09 08:24:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7375 | 6.7375 | 55496.0 |
| 2009-10-09 08:26:00 | AAPL | Stock | 6.7411 | 6.7411 | 6.7411 | 6.7411 | 2800.0 |
| 2009-10-09 08:27:00 | AAPL | Stock | 6.7446 | 6.7454 | 6.7446 | 6.7454 | 8400.0 |
| 2009-10-09 08:29:00 | AAPL | Stock | 6.7414 | 6.7446 | 6.7414 | 6.7446 | 33600.0 |
| 2009-10-09 08:30:00 | AAPL | Stock | 6.7414 | 6.7454 | 6.7414 | 6.745 | 57120.0 |
| 2009-10-09 08:31:00 | AAPL | Stock | 6.7432 | 6.7432 | 6.7429 | 6.7429 | 40600.0 |
| 2009-10-09 08:32:00 | AAPL | Stock | 6.7411 | 6.7414 | 6.7357 | 6.7357 | 36400.0 |
| 2009-10-09 08:34:00 | AAPL | Stock | 6.7336 | 6.7336 | 6.7332 | 6.7332 | 9240.0 |
| 2009-10-09 08:36:00 | AAPL | Stock | 6.7393 | 6.7454 | 6.7393 | 6.745 | 28840.0 |
| 2009-10-09 08:37:00 | AAPL | Stock | 6.7446 | 6.7446 | 6.7446 | 6.7446 | 16800.0 |
| 2009-10-09 08:38:00 | AAPL | Stock | 6.7446 | 6.7446 | 6.7429 | 6.7429 | 16800.0 |
| 2009-10-09 08:40:00 | AAPL | Stock | 6.7439 | 6.7439 | 6.7439 | 6.7439 | 5600.0 |
| 2009-10-09 08:42:00 | AAPL | Stock | 6.7396 | 6.7396 | 6.7393 | 6.7393 | 41160.0 |
| 2009-10-09 08:44:00 | AAPL | Stock | 6.7375 | 6.7375 | 6.7375 | 6.7375 | 21280.0 |
| 2009-10-09 08:45:00 | AAPL | Stock | 6.7371 | 6.7371 | 6.7371 | 6.7371 | 13552.0 |
| 2009-10-09 08:47:00 | AAPL | Stock | 6.7382 | 6.7382 | 6.7382 | 6.7382 | 5600.0 |
| 2009-10-09 08:48:00 | AAPL | Stock | 6.7432 | 6.7432 | 6.7432 | 6.7432 | 2800.0 |
| 2009-10-09 08:51:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7411 | 6.7411 | 8400.0 |
| 2009-10-09 08:52:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7429 | 6.7429 | 10808.0 |
| 2009-10-09 08:54:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7411 | 6.7411 | 5992.0 |
| 2009-10-09 08:55:00 | AAPL | Stock | 6.7446 | 6.7446 | 6.7411 | 6.7432 | 43680.0 |
| 2009-10-09 08:56:00 | AAPL | Stock | 6.7454 | 6.7454 | 6.7446 | 6.7446 | 34160.0 |
| 2009-10-09 08:57:00 | AAPL | Stock | 6.7464 | 6.7482 | 6.7464 | 6.7482 | 5600.0 |
| 2009-10-09 08:58:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7429 | 6.7429 | 14000.0 |
| 2009-10-09 08:59:00 | AAPL | Stock | 6.7457 | 6.7457 | 6.7429 | 6.7429 | 35952.0 |
> showing 50 of 908,656 rows — these rows as CSV