PREVIEW / stock_5min / 2010-03-23
file: by_date/stock_5min/2010/2010-03-23.parquet size: 4.8 MB rows: 325,978 symbols: 3,474
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-23 07:10:00 | AAPL | Stock | 8.0454 | 8.0454 | 8.0454 | 8.0454 | 12600.0 |
| 2010-03-23 07:30:00 | AAPL | Stock | 8.0368 | 8.0368 | 8.0368 | 8.0368 | 2800.0 |
| 2010-03-23 07:40:00 | AAPL | Stock | 8.0464 | 8.0464 | 8.0457 | 8.0464 | 14000.0 |
| 2010-03-23 07:45:00 | AAPL | Stock | 8.0368 | 8.0464 | 8.0368 | 8.0464 | 5600.0 |
| 2010-03-23 07:50:00 | AAPL | Stock | 8.0379 | 8.0379 | 8.0321 | 8.0321 | 106400.0 |
| 2010-03-23 07:55:00 | AAPL | Stock | 8.0357 | 8.0411 | 8.0346 | 8.0411 | 72800.0 |
| 2010-03-23 08:00:00 | AAPL | Stock | 8.0414 | 8.0518 | 8.0368 | 8.0475 | 137452.0 |
| 2010-03-23 08:05:00 | AAPL | Stock | 8.0482 | 8.0493 | 8.045 | 8.0493 | 129220.0 |
| 2010-03-23 08:10:00 | AAPL | Stock | 8.0514 | 8.0614 | 8.0514 | 8.0554 | 223440.0 |
| 2010-03-23 08:15:00 | AAPL | Stock | 8.0604 | 8.0621 | 8.0464 | 8.0496 | 251300.0 |
| 2010-03-23 08:20:00 | AAPL | Stock | 8.0514 | 8.0539 | 8.05 | 8.0536 | 139916.0 |
| 2010-03-23 08:25:00 | AAPL | Stock | 8.0554 | 8.0564 | 8.0536 | 8.0546 | 104888.0 |
| 2010-03-23 08:30:00 | AAPL | Stock | 8.0536 | 8.055 | 8.0489 | 8.0514 | 293748.0 |
| 2010-03-23 08:35:00 | AAPL | Stock | 8.0504 | 8.0521 | 8.0464 | 8.0468 | 64904.0 |
| 2010-03-23 08:40:00 | AAPL | Stock | 8.0468 | 8.0489 | 8.0446 | 8.0486 | 42000.0 |
| 2010-03-23 08:45:00 | AAPL | Stock | 8.0518 | 8.0529 | 8.0518 | 8.0518 | 28000.0 |
| 2010-03-23 08:50:00 | AAPL | Stock | 8.0518 | 8.0529 | 8.0514 | 8.0514 | 52612.0 |
| 2010-03-23 08:55:00 | AAPL | Stock | 8.0521 | 8.0521 | 8.05 | 8.0504 | 55468.0 |
| 2010-03-23 09:00:00 | AAPL | Stock | 8.0504 | 8.0593 | 8.0504 | 8.0593 | 295092.0 |
| 2010-03-23 09:05:00 | AAPL | Stock | 8.0593 | 8.0604 | 8.0555 | 8.0579 | 181944.0 |
| 2010-03-23 09:10:00 | AAPL | Stock | 8.0604 | 8.0729 | 8.0604 | 8.0675 | 640192.0 |
| 2010-03-23 09:15:00 | AAPL | Stock | 8.0643 | 8.0668 | 8.0589 | 8.0636 | 64036.0 |
| 2010-03-23 09:20:00 | AAPL | Stock | 8.0614 | 8.0689 | 8.0607 | 8.0625 | 106400.0 |
| 2010-03-23 09:25:00 | AAPL | Stock | 8.0643 | 8.0675 | 8.055 | 8.0571 | 269220.0 |
| 2010-03-23 09:30:00 | AAPL | Stock | 8.0546 | 8.0679 | 8.0389 | 8.0451 | 12728296.0 |
| 2010-03-23 09:35:00 | AAPL | Stock | 8.0439 | 8.0529 | 8.0364 | 8.0433 | 8725976.0 |
| 2010-03-23 09:40:00 | AAPL | Stock | 8.0436 | 8.075 | 8.0386 | 8.0614 | 14569520.0 |
| 2010-03-23 09:45:00 | AAPL | Stock | 8.0614 | 8.0643 | 8.03 | 8.04 | 13042400.0 |
| 2010-03-23 09:50:00 | AAPL | Stock | 8.04 | 8.0625 | 8.0311 | 8.0596 | 9948428.0 |
| 2010-03-23 09:55:00 | AAPL | Stock | 8.06 | 8.0607 | 8.0482 | 8.0557 | 5590228.0 |
| 2010-03-23 10:00:00 | AAPL | Stock | 8.0557 | 8.0707 | 8.0368 | 8.0371 | 11182304.0 |
| 2010-03-23 10:05:00 | AAPL | Stock | 8.0375 | 8.0605 | 8.0368 | 8.0593 | 8009204.0 |
| 2010-03-23 10:10:00 | AAPL | Stock | 8.0596 | 8.0679 | 8.0536 | 8.0629 | 8505140.0 |
| 2010-03-23 10:15:00 | AAPL | Stock | 8.0636 | 8.0743 | 8.0614 | 8.0696 | 10656072.0 |
| 2010-03-23 10:20:00 | AAPL | Stock | 8.0696 | 8.0743 | 8.06 | 8.065 | 9407188.0 |
| 2010-03-23 10:25:00 | AAPL | Stock | 8.0641 | 8.0661 | 8.05 | 8.0575 | 5949076.0 |
| 2010-03-23 10:30:00 | AAPL | Stock | 8.0589 | 8.0689 | 8.0539 | 8.0679 | 3815252.0 |
| 2010-03-23 10:35:00 | AAPL | Stock | 8.0679 | 8.0689 | 8.0464 | 8.0539 | 6541892.0 |
| 2010-03-23 10:40:00 | AAPL | Stock | 8.0539 | 8.0557 | 8.0396 | 8.047 | 5031460.0 |
| 2010-03-23 10:45:00 | AAPL | Stock | 8.0479 | 8.0489 | 8.0404 | 8.0439 | 3486420.0 |
| 2010-03-23 10:50:00 | AAPL | Stock | 8.0438 | 8.0491 | 8.0409 | 8.0466 | 4720660.0 |
| 2010-03-23 10:55:00 | AAPL | Stock | 8.0457 | 8.0468 | 8.0232 | 8.0289 | 11032924.0 |
| 2010-03-23 11:00:00 | AAPL | Stock | 8.0289 | 8.0296 | 8.0036 | 8.0054 | 11312952.0 |
| 2010-03-23 11:05:00 | AAPL | Stock | 8.0054 | 8.0207 | 8.0043 | 8.0204 | 6708772.0 |
| 2010-03-23 11:10:00 | AAPL | Stock | 8.0199 | 8.0375 | 8.0139 | 8.0368 | 6691468.0 |
| 2010-03-23 11:15:00 | AAPL | Stock | 8.035 | 8.0357 | 8.0296 | 8.0329 | 2863532.0 |
| 2010-03-23 11:20:00 | AAPL | Stock | 8.0318 | 8.0468 | 8.0318 | 8.0421 | 3896872.0 |
| 2010-03-23 11:25:00 | AAPL | Stock | 8.0411 | 8.0419 | 8.0275 | 8.0311 | 4134620.0 |
| 2010-03-23 11:30:00 | AAPL | Stock | 8.0318 | 8.0389 | 8.0289 | 8.0364 | 3169404.0 |
| 2010-03-23 11:35:00 | AAPL | Stock | 8.0364 | 8.0376 | 8.0321 | 8.0371 | 1984024.0 |
> showing 50 of 325,978 rows — these rows as CSV