PREVIEW / stock_5min / 2006-09-28
file: by_date/stock_5min/2006/2006-09-28.parquet size: 3.1 MB rows: 225,686 symbols: 2,381
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-28 08:00:00 | AAPL | Stock | 2.7279 | 2.7364 | 2.7268 | 2.7343 | 113120.0 |
| 2006-09-28 08:05:00 | AAPL | Stock | 2.7336 | 2.7375 | 2.7336 | 2.7371 | 253120.0 |
| 2006-09-28 08:10:00 | AAPL | Stock | 2.7371 | 2.7464 | 2.7371 | 2.7432 | 532560.0 |
| 2006-09-28 08:15:00 | AAPL | Stock | 2.7432 | 2.7446 | 2.7411 | 2.7439 | 187740.0 |
| 2006-09-28 08:25:00 | AAPL | Stock | 2.7411 | 2.7425 | 2.7411 | 2.7414 | 114100.0 |
| 2006-09-28 08:30:00 | AAPL | Stock | 2.74 | 2.7432 | 2.7357 | 2.7429 | 548828.0 |
| 2006-09-28 08:35:00 | AAPL | Stock | 2.7393 | 2.7432 | 2.7393 | 2.7429 | 256200.0 |
| 2006-09-28 08:40:00 | AAPL | Stock | 2.7429 | 2.7429 | 2.7414 | 2.7414 | 15400.0 |
| 2006-09-28 08:45:00 | AAPL | Stock | 2.7432 | 2.7446 | 2.7432 | 2.7446 | 184800.0 |
| 2006-09-28 08:50:00 | AAPL | Stock | 2.7432 | 2.7482 | 2.7432 | 2.7475 | 1027684.0 |
| 2006-09-28 08:55:00 | AAPL | Stock | 2.7479 | 2.7496 | 2.7429 | 2.7482 | 864276.0 |
| 2006-09-28 09:00:00 | AAPL | Stock | 2.7496 | 2.7496 | 2.7482 | 2.7486 | 111720.0 |
| 2006-09-28 09:05:00 | AAPL | Stock | 2.7486 | 2.7493 | 2.7482 | 2.7482 | 167160.0 |
| 2006-09-28 09:10:00 | AAPL | Stock | 2.7482 | 2.7518 | 2.7482 | 2.7514 | 419300.0 |
| 2006-09-28 09:15:00 | AAPL | Stock | 2.75 | 2.7514 | 2.7482 | 2.7493 | 449456.0 |
| 2006-09-28 09:20:00 | AAPL | Stock | 2.7496 | 2.7532 | 2.7496 | 2.75 | 275800.0 |
| 2006-09-28 09:25:00 | AAPL | Stock | 2.7479 | 2.7536 | 2.7457 | 2.7507 | 836584.0 |
| 2006-09-28 09:30:00 | AAPL | Stock | 2.7507 | 2.7625 | 2.7475 | 2.7621 | 27556340.0 |
| 2006-09-28 09:35:00 | AAPL | Stock | 2.7618 | 2.7671 | 2.7596 | 2.76 | 20976816.0 |
| 2006-09-28 09:40:00 | AAPL | Stock | 2.76 | 2.7604 | 2.7464 | 2.7543 | 22269996.0 |
| 2006-09-28 09:45:00 | AAPL | Stock | 2.7539 | 2.7554 | 2.7457 | 2.7486 | 14467572.0 |
| 2006-09-28 09:50:00 | AAPL | Stock | 2.7489 | 2.7518 | 2.7404 | 2.7514 | 23119012.0 |
| 2006-09-28 09:55:00 | AAPL | Stock | 2.7511 | 2.7561 | 2.7475 | 2.7532 | 17238452.0 |
| 2006-09-28 10:00:00 | AAPL | Stock | 2.7532 | 2.7582 | 2.7461 | 2.7561 | 13721372.0 |
| 2006-09-28 10:05:00 | AAPL | Stock | 2.7561 | 2.7589 | 2.7507 | 2.7514 | 12184676.0 |
| 2006-09-28 10:10:00 | AAPL | Stock | 2.7514 | 2.7571 | 2.7507 | 2.7557 | 8226596.0 |
| 2006-09-28 10:15:00 | AAPL | Stock | 2.7557 | 2.7586 | 2.7529 | 2.7543 | 14300888.0 |
| 2006-09-28 10:20:00 | AAPL | Stock | 2.7546 | 2.7607 | 2.7511 | 2.7593 | 12152504.0 |
| 2006-09-28 10:25:00 | AAPL | Stock | 2.7596 | 2.7625 | 2.7439 | 2.745 | 25242224.0 |
| 2006-09-28 10:30:00 | AAPL | Stock | 2.745 | 2.7479 | 2.7354 | 2.7439 | 23798320.0 |
| 2006-09-28 10:35:00 | AAPL | Stock | 2.7439 | 2.7471 | 2.7364 | 2.7393 | 15643124.0 |
| 2006-09-28 10:40:00 | AAPL | Stock | 2.7393 | 2.7407 | 2.7229 | 2.7293 | 24957996.0 |
| 2006-09-28 10:45:00 | AAPL | Stock | 2.7296 | 2.73 | 2.7221 | 2.7239 | 19378996.0 |
| 2006-09-28 10:50:00 | AAPL | Stock | 2.7239 | 2.7379 | 2.7232 | 2.7357 | 13513752.0 |
| 2006-09-28 10:55:00 | AAPL | Stock | 2.7361 | 2.7414 | 2.735 | 2.7368 | 10798032.0 |
| 2006-09-28 11:00:00 | AAPL | Stock | 2.7368 | 2.7425 | 2.7343 | 2.7407 | 8001196.0 |
| 2006-09-28 11:05:00 | AAPL | Stock | 2.7404 | 2.7425 | 2.7389 | 2.7389 | 6448064.0 |
| 2006-09-28 11:10:00 | AAPL | Stock | 2.7389 | 2.7393 | 2.7329 | 2.7379 | 7012404.0 |
| 2006-09-28 11:15:00 | AAPL | Stock | 2.7379 | 2.7432 | 2.7375 | 2.7393 | 7589876.0 |
| 2006-09-28 11:20:00 | AAPL | Stock | 2.7396 | 2.74 | 2.7361 | 2.7375 | 5548424.0 |
| 2006-09-28 11:25:00 | AAPL | Stock | 2.7371 | 2.7375 | 2.7296 | 2.7329 | 10513328.0 |
| 2006-09-28 11:30:00 | AAPL | Stock | 2.7325 | 2.7332 | 2.7304 | 2.7329 | 7214480.0 |
| 2006-09-28 11:35:00 | AAPL | Stock | 2.7329 | 2.7336 | 2.7304 | 2.7304 | 3442236.0 |
| 2006-09-28 11:40:00 | AAPL | Stock | 2.7306 | 2.7306 | 2.7236 | 2.7243 | 7434420.0 |
| 2006-09-28 11:45:00 | AAPL | Stock | 2.7239 | 2.7264 | 2.7218 | 2.7239 | 10246768.0 |
| 2006-09-28 11:50:00 | AAPL | Stock | 2.7239 | 2.7242 | 2.7171 | 2.7239 | 11805696.0 |
| 2006-09-28 11:55:00 | AAPL | Stock | 2.7236 | 2.7246 | 2.7218 | 2.7225 | 3437924.0 |
| 2006-09-28 12:00:00 | AAPL | Stock | 2.7225 | 2.7246 | 2.7186 | 2.7225 | 7147028.0 |
| 2006-09-28 12:05:00 | AAPL | Stock | 2.7229 | 2.7232 | 2.7193 | 2.7204 | 5810644.0 |
| 2006-09-28 12:10:00 | AAPL | Stock | 2.7207 | 2.7232 | 2.7182 | 2.7211 | 6565076.0 |
> showing 50 of 225,686 rows — these rows as CSV