PREVIEW / stock_5min / 2005-09-07
file: by_date/stock_5min/2005/2005-09-07.parquet size: 2.7 MB rows: 200,010 symbols: 2,069
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-07 08:00:00 | AAPL | Stock | 1.7518 | 1.7518 | 1.7429 | 1.7429 | 211540.0 |
| 2005-09-07 08:05:00 | AAPL | Stock | 1.7429 | 1.7439 | 1.7411 | 1.7439 | 385028.0 |
| 2005-09-07 08:10:00 | AAPL | Stock | 1.7439 | 1.7539 | 1.7414 | 1.7539 | 397544.0 |
| 2005-09-07 08:15:00 | AAPL | Stock | 1.7539 | 1.7539 | 1.7464 | 1.75 | 202440.0 |
| 2005-09-07 08:20:00 | AAPL | Stock | 1.7514 | 1.7575 | 1.7514 | 1.7554 | 260932.0 |
| 2005-09-07 08:25:00 | AAPL | Stock | 1.7554 | 1.7564 | 1.7511 | 1.755 | 134400.0 |
| 2005-09-07 08:30:00 | AAPL | Stock | 1.755 | 1.755 | 1.7529 | 1.7536 | 193592.0 |
| 2005-09-07 08:35:00 | AAPL | Stock | 1.7536 | 1.7543 | 1.7529 | 1.7529 | 369264.0 |
| 2005-09-07 08:40:00 | AAPL | Stock | 1.7536 | 1.755 | 1.7536 | 1.755 | 207900.0 |
| 2005-09-07 08:45:00 | AAPL | Stock | 1.7543 | 1.7575 | 1.7543 | 1.7554 | 436520.0 |
| 2005-09-07 08:50:00 | AAPL | Stock | 1.7554 | 1.7561 | 1.7525 | 1.7554 | 192780.0 |
| 2005-09-07 08:55:00 | AAPL | Stock | 1.7536 | 1.755 | 1.7507 | 1.7507 | 419216.0 |
| 2005-09-07 09:00:00 | AAPL | Stock | 1.7518 | 1.7532 | 1.7475 | 1.75 | 356412.0 |
| 2005-09-07 09:05:00 | AAPL | Stock | 1.7518 | 1.7539 | 1.7429 | 1.7429 | 185864.0 |
| 2005-09-07 09:10:00 | AAPL | Stock | 1.7543 | 1.7546 | 1.7521 | 1.7529 | 271124.0 |
| 2005-09-07 09:15:00 | AAPL | Stock | 1.7518 | 1.7536 | 1.7518 | 1.7532 | 152096.0 |
| 2005-09-07 09:20:00 | AAPL | Stock | 1.7536 | 1.7536 | 1.7529 | 1.7529 | 123200.0 |
| 2005-09-07 09:25:00 | AAPL | Stock | 1.7496 | 1.7568 | 1.7496 | 1.7529 | 1189636.0 |
| 2005-09-07 09:30:00 | AAPL | Stock | 1.7518 | 1.7643 | 1.7507 | 1.7561 | 46215484.0 |
| 2005-09-07 09:35:00 | AAPL | Stock | 1.7561 | 1.7571 | 1.75 | 1.7518 | 27953716.0 |
| 2005-09-07 09:40:00 | AAPL | Stock | 1.7518 | 1.7518 | 1.7364 | 1.7375 | 22410640.0 |
| 2005-09-07 09:45:00 | AAPL | Stock | 1.7375 | 1.7421 | 1.7261 | 1.7336 | 30577708.0 |
| 2005-09-07 09:50:00 | AAPL | Stock | 1.7336 | 1.7375 | 1.7286 | 1.7361 | 15739416.0 |
| 2005-09-07 09:55:00 | AAPL | Stock | 1.7357 | 1.7446 | 1.7343 | 1.7364 | 10645124.0 |
| 2005-09-07 10:00:00 | AAPL | Stock | 1.7364 | 1.7364 | 1.73 | 1.7329 | 12368636.0 |
| 2005-09-07 10:05:00 | AAPL | Stock | 1.7329 | 1.7354 | 1.7311 | 1.734 | 10283532.0 |
| 2005-09-07 10:10:00 | AAPL | Stock | 1.7343 | 1.7421 | 1.7339 | 1.7407 | 17120292.0 |
| 2005-09-07 10:15:00 | AAPL | Stock | 1.7407 | 1.7418 | 1.7354 | 1.7368 | 13438124.0 |
| 2005-09-07 10:20:00 | AAPL | Stock | 1.7368 | 1.7421 | 1.7346 | 1.7421 | 7894096.0 |
| 2005-09-07 10:25:00 | AAPL | Stock | 1.7425 | 1.7443 | 1.7382 | 1.7389 | 8754620.0 |
| 2005-09-07 10:30:00 | AAPL | Stock | 1.7389 | 1.7414 | 1.7368 | 1.7396 | 10375036.0 |
| 2005-09-07 10:35:00 | AAPL | Stock | 1.7395 | 1.7454 | 1.7393 | 1.7443 | 9220428.0 |
| 2005-09-07 10:40:00 | AAPL | Stock | 1.7446 | 1.7482 | 1.7418 | 1.7421 | 8761340.0 |
| 2005-09-07 10:45:00 | AAPL | Stock | 1.7421 | 1.7421 | 1.7361 | 1.7393 | 10281712.0 |
| 2005-09-07 10:50:00 | AAPL | Stock | 1.7389 | 1.7393 | 1.7325 | 1.7357 | 11296292.0 |
| 2005-09-07 10:55:00 | AAPL | Stock | 1.7354 | 1.7393 | 1.735 | 1.7379 | 6782328.0 |
| 2005-09-07 11:00:00 | AAPL | Stock | 1.7382 | 1.7414 | 1.7382 | 1.7396 | 6787676.0 |
| 2005-09-07 11:05:00 | AAPL | Stock | 1.7396 | 1.7411 | 1.7382 | 1.7389 | 5830076.0 |
| 2005-09-07 11:10:00 | AAPL | Stock | 1.7389 | 1.7393 | 1.7368 | 1.7379 | 4927384.0 |
| 2005-09-07 11:15:00 | AAPL | Stock | 1.7379 | 1.7382 | 1.7346 | 1.7357 | 6169800.0 |
| 2005-09-07 11:20:00 | AAPL | Stock | 1.7357 | 1.7393 | 1.7357 | 1.7386 | 3504312.0 |
| 2005-09-07 11:25:00 | AAPL | Stock | 1.7386 | 1.7389 | 1.7375 | 1.7375 | 2380532.0 |
| 2005-09-07 11:30:00 | AAPL | Stock | 1.7382 | 1.7389 | 1.7375 | 1.7379 | 2152108.0 |
| 2005-09-07 11:35:00 | AAPL | Stock | 1.7375 | 1.7386 | 1.7375 | 1.7379 | 1696856.0 |
| 2005-09-07 11:40:00 | AAPL | Stock | 1.7382 | 1.7389 | 1.7379 | 1.7386 | 2466996.0 |
| 2005-09-07 11:45:00 | AAPL | Stock | 1.7386 | 1.7396 | 1.7386 | 1.7389 | 2296784.0 |
| 2005-09-07 11:50:00 | AAPL | Stock | 1.7386 | 1.7389 | 1.7367 | 1.7371 | 4141088.0 |
| 2005-09-07 11:55:00 | AAPL | Stock | 1.7368 | 1.7382 | 1.7339 | 1.7343 | 9691836.0 |
| 2005-09-07 12:00:00 | AAPL | Stock | 1.7343 | 1.7346 | 1.7332 | 1.7335 | 5568360.0 |
| 2005-09-07 12:05:00 | AAPL | Stock | 1.7332 | 1.7354 | 1.7332 | 1.7346 | 3740828.0 |
> showing 50 of 200,010 rows — these rows as CSV