PREVIEW / stock_5min / 2009-10-16
file: by_date/stock_5min/2009/2009-10-16.parquet size: 4.7 MB rows: 317,413 symbols: 3,391
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-16 06:35:00 | AAPL | Stock | 6.8286 | 6.8286 | 6.7879 | 6.7879 | 22400.0 |
| 2009-10-16 06:40:00 | AAPL | Stock | 6.7857 | 6.8057 | 6.7857 | 6.8057 | 172200.0 |
| 2009-10-16 06:55:00 | AAPL | Stock | 6.8057 | 6.8057 | 6.8057 | 6.8057 | 21000.0 |
| 2009-10-16 07:00:00 | AAPL | Stock | 6.8025 | 6.8025 | 6.8025 | 6.8025 | 5600.0 |
| 2009-10-16 07:05:00 | AAPL | Stock | 6.7893 | 6.7893 | 6.7861 | 6.7864 | 32928.0 |
| 2009-10-16 07:10:00 | AAPL | Stock | 6.7868 | 6.7868 | 6.7868 | 6.7868 | 2800.0 |
| 2009-10-16 07:15:00 | AAPL | Stock | 6.7896 | 6.7896 | 6.7896 | 6.7896 | 8400.0 |
| 2009-10-16 07:20:00 | AAPL | Stock | 6.7879 | 6.7879 | 6.7857 | 6.7857 | 35672.0 |
| 2009-10-16 07:30:00 | AAPL | Stock | 6.7857 | 6.7857 | 6.7782 | 6.7782 | 21420.0 |
| 2009-10-16 07:35:00 | AAPL | Stock | 6.7743 | 6.7743 | 6.7686 | 6.7718 | 58184.0 |
| 2009-10-16 07:40:00 | AAPL | Stock | 6.7754 | 6.7754 | 6.7732 | 6.7732 | 15708.0 |
| 2009-10-16 07:50:00 | AAPL | Stock | 6.7732 | 6.7743 | 6.7725 | 6.7725 | 22400.0 |
| 2009-10-16 07:55:00 | AAPL | Stock | 6.7732 | 6.7736 | 6.7686 | 6.7686 | 18200.0 |
| 2009-10-16 08:00:00 | AAPL | Stock | 6.7818 | 6.7836 | 6.7625 | 6.7654 | 385196.0 |
| 2009-10-16 08:05:00 | AAPL | Stock | 6.7711 | 6.7746 | 6.7543 | 6.7607 | 285712.0 |
| 2009-10-16 08:10:00 | AAPL | Stock | 6.7589 | 6.7607 | 6.75 | 6.7539 | 711620.0 |
| 2009-10-16 08:15:00 | AAPL | Stock | 6.7543 | 6.7571 | 6.7525 | 6.7571 | 49280.0 |
| 2009-10-16 08:20:00 | AAPL | Stock | 6.7539 | 6.7571 | 6.7468 | 6.7468 | 355628.0 |
| 2009-10-16 08:25:00 | AAPL | Stock | 6.7464 | 6.7539 | 6.7446 | 6.7539 | 232960.0 |
| 2009-10-16 08:30:00 | AAPL | Stock | 6.7536 | 6.7564 | 6.7536 | 6.7539 | 112504.0 |
| 2009-10-16 08:35:00 | AAPL | Stock | 6.7543 | 6.7554 | 6.7461 | 6.75 | 79296.0 |
| 2009-10-16 08:40:00 | AAPL | Stock | 6.7464 | 6.7589 | 6.7464 | 6.7571 | 149856.0 |
| 2009-10-16 08:45:00 | AAPL | Stock | 6.7604 | 6.7607 | 6.75 | 6.7536 | 176456.0 |
| 2009-10-16 08:50:00 | AAPL | Stock | 6.7518 | 6.7543 | 6.75 | 6.7518 | 77000.0 |
| 2009-10-16 08:55:00 | AAPL | Stock | 6.7518 | 6.7536 | 6.7468 | 6.7489 | 185808.0 |
| 2009-10-16 09:00:00 | AAPL | Stock | 6.75 | 6.7629 | 6.75 | 6.7604 | 296212.0 |
| 2009-10-16 09:05:00 | AAPL | Stock | 6.7604 | 6.7632 | 6.7571 | 6.7614 | 263480.0 |
| 2009-10-16 09:10:00 | AAPL | Stock | 6.7625 | 6.7625 | 6.76 | 6.7607 | 53200.0 |
| 2009-10-16 09:15:00 | AAPL | Stock | 6.7625 | 6.7664 | 6.7625 | 6.7654 | 142156.0 |
| 2009-10-16 09:20:00 | AAPL | Stock | 6.7614 | 6.7661 | 6.7589 | 6.7661 | 87640.0 |
| 2009-10-16 09:25:00 | AAPL | Stock | 6.7629 | 6.7629 | 6.7596 | 6.7604 | 29540.0 |
| 2009-10-16 09:30:00 | AAPL | Stock | 6.7621 | 6.7675 | 6.7282 | 6.7368 | 39039532.0 |
| 2009-10-16 09:35:00 | AAPL | Stock | 6.7371 | 6.7604 | 6.7343 | 6.7604 | 10469144.0 |
| 2009-10-16 09:40:00 | AAPL | Stock | 6.7604 | 6.7625 | 6.7464 | 6.7464 | 6217904.0 |
| 2009-10-16 09:45:00 | AAPL | Stock | 6.7468 | 6.7546 | 6.74 | 6.7514 | 7186368.0 |
| 2009-10-16 09:50:00 | AAPL | Stock | 6.7511 | 6.7764 | 6.7511 | 6.7561 | 9067884.0 |
| 2009-10-16 09:55:00 | AAPL | Stock | 6.7564 | 6.7986 | 6.7536 | 6.7721 | 18085144.0 |
| 2009-10-16 10:00:00 | AAPL | Stock | 6.7721 | 6.7729 | 6.7471 | 6.7546 | 9712220.0 |
| 2009-10-16 10:05:00 | AAPL | Stock | 6.7546 | 6.7589 | 6.7414 | 6.7421 | 7877492.0 |
| 2009-10-16 10:10:00 | AAPL | Stock | 6.7425 | 6.75 | 6.7386 | 6.7432 | 7762608.0 |
| 2009-10-16 10:15:00 | AAPL | Stock | 6.7432 | 6.7496 | 6.7339 | 6.7475 | 6324920.0 |
| 2009-10-16 10:20:00 | AAPL | Stock | 6.7468 | 6.7607 | 6.7457 | 6.7487 | 6855184.0 |
| 2009-10-16 10:25:00 | AAPL | Stock | 6.7489 | 6.7532 | 6.7446 | 6.7525 | 6025432.0 |
| 2009-10-16 10:30:00 | AAPL | Stock | 6.7525 | 6.7607 | 6.7511 | 6.7593 | 4435088.0 |
| 2009-10-16 10:35:00 | AAPL | Stock | 6.7586 | 6.7607 | 6.7539 | 6.7564 | 2741816.0 |
| 2009-10-16 10:40:00 | AAPL | Stock | 6.7561 | 6.7562 | 6.7471 | 6.7507 | 5680136.0 |
| 2009-10-16 10:45:00 | AAPL | Stock | 6.7511 | 6.7521 | 6.7443 | 6.7494 | 4331908.0 |
| 2009-10-16 10:50:00 | AAPL | Stock | 6.7493 | 6.7529 | 6.7429 | 6.7468 | 4685016.0 |
| 2009-10-16 10:55:00 | AAPL | Stock | 6.7461 | 6.7461 | 6.7386 | 6.7386 | 5452356.0 |
| 2009-10-16 11:00:00 | AAPL | Stock | 6.7382 | 6.7489 | 6.7354 | 6.7411 | 5761616.0 |
> showing 50 of 317,413 rows — these rows as CSV