PREVIEW / stock_5min / 2010-01-20
file: by_date/stock_5min/2010/2010-01-20.parquet size: 4.8 MB rows: 326,183 symbols: 3,424
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-01-20 04:15:00 | AAPL | Stock | 7.6786 | 7.6786 | 7.6714 | 7.6714 | 14000.0 |
| 2010-01-20 05:10:00 | AAPL | Stock | 7.665 | 7.6839 | 7.665 | 7.6839 | 16800.0 |
| 2010-01-20 06:00:00 | AAPL | Stock | 7.6836 | 7.6836 | 7.6836 | 7.6836 | 5600.0 |
| 2010-01-20 06:10:00 | AAPL | Stock | 7.6714 | 7.6714 | 7.67 | 7.67 | 28000.0 |
| 2010-01-20 06:50:00 | AAPL | Stock | 7.6829 | 7.6829 | 7.6829 | 7.6829 | 2800.0 |
| 2010-01-20 06:55:00 | AAPL | Stock | 7.6825 | 7.6825 | 7.6782 | 7.6782 | 68964.0 |
| 2010-01-20 07:00:00 | AAPL | Stock | 7.6714 | 7.6714 | 7.665 | 7.665 | 16800.0 |
| 2010-01-20 07:05:00 | AAPL | Stock | 7.6536 | 7.6536 | 7.6532 | 7.6532 | 5600.0 |
| 2010-01-20 07:10:00 | AAPL | Stock | 7.6536 | 7.6607 | 7.6521 | 7.6607 | 74844.0 |
| 2010-01-20 07:15:00 | AAPL | Stock | 7.6557 | 7.6557 | 7.6557 | 7.6557 | 2800.0 |
| 2010-01-20 07:20:00 | AAPL | Stock | 7.6575 | 7.6575 | 7.6571 | 7.6571 | 47600.0 |
| 2010-01-20 07:25:00 | AAPL | Stock | 7.6607 | 7.6679 | 7.6575 | 7.6679 | 35000.0 |
| 2010-01-20 07:35:00 | AAPL | Stock | 7.6586 | 7.6661 | 7.6586 | 7.6661 | 13328.0 |
| 2010-01-20 07:40:00 | AAPL | Stock | 7.6671 | 7.6671 | 7.6604 | 7.6668 | 185976.0 |
| 2010-01-20 07:45:00 | AAPL | Stock | 7.6607 | 7.6675 | 7.6607 | 7.6675 | 14000.0 |
| 2010-01-20 07:50:00 | AAPL | Stock | 7.6679 | 7.6679 | 7.6675 | 7.6675 | 16800.0 |
| 2010-01-20 07:55:00 | AAPL | Stock | 7.6675 | 7.6786 | 7.6675 | 7.6786 | 28000.0 |
| 2010-01-20 08:00:00 | AAPL | Stock | 7.6732 | 7.675 | 7.6596 | 7.6643 | 529760.0 |
| 2010-01-20 08:05:00 | AAPL | Stock | 7.6596 | 7.6839 | 7.6589 | 7.6818 | 670544.0 |
| 2010-01-20 08:10:00 | AAPL | Stock | 7.6811 | 7.6832 | 7.6768 | 7.6832 | 133560.0 |
| 2010-01-20 08:15:00 | AAPL | Stock | 7.6821 | 7.6832 | 7.6746 | 7.6746 | 99764.0 |
| 2010-01-20 08:20:00 | AAPL | Stock | 7.6732 | 7.6746 | 7.6671 | 7.6671 | 117264.0 |
| 2010-01-20 08:25:00 | AAPL | Stock | 7.6664 | 7.6664 | 7.6539 | 7.6636 | 164388.0 |
| 2010-01-20 08:30:00 | AAPL | Stock | 7.6629 | 7.6654 | 7.66 | 7.6625 | 106820.0 |
| 2010-01-20 08:35:00 | AAPL | Stock | 7.6614 | 7.6614 | 7.6589 | 7.6589 | 37520.0 |
| 2010-01-20 08:40:00 | AAPL | Stock | 7.6589 | 7.6589 | 7.6482 | 7.6504 | 226492.0 |
| 2010-01-20 08:45:00 | AAPL | Stock | 7.6496 | 7.65 | 7.6396 | 7.645 | 429016.0 |
| 2010-01-20 08:50:00 | AAPL | Stock | 7.6464 | 7.6521 | 7.6432 | 7.6521 | 182420.0 |
| 2010-01-20 08:55:00 | AAPL | Stock | 7.65 | 7.6518 | 7.6464 | 7.6518 | 42000.0 |
| 2010-01-20 09:00:00 | AAPL | Stock | 7.6486 | 7.6514 | 7.6411 | 7.6411 | 142492.0 |
| 2010-01-20 09:05:00 | AAPL | Stock | 7.6411 | 7.645 | 7.6357 | 7.6389 | 332612.0 |
| 2010-01-20 09:10:00 | AAPL | Stock | 7.6389 | 7.6418 | 7.6357 | 7.6393 | 259056.0 |
| 2010-01-20 09:15:00 | AAPL | Stock | 7.6411 | 7.65 | 7.6411 | 7.6489 | 404040.0 |
| 2010-01-20 09:20:00 | AAPL | Stock | 7.6489 | 7.6586 | 7.6457 | 7.6543 | 552356.0 |
| 2010-01-20 09:25:00 | AAPL | Stock | 7.6554 | 7.675 | 7.6536 | 7.6732 | 452396.0 |
| 2010-01-20 09:30:00 | AAPL | Stock | 7.6729 | 7.6982 | 7.6214 | 7.6286 | 30623600.0 |
| 2010-01-20 09:35:00 | AAPL | Stock | 7.6282 | 7.6391 | 7.6107 | 7.6354 | 16282252.0 |
| 2010-01-20 09:40:00 | AAPL | Stock | 7.6361 | 7.6454 | 7.6179 | 7.6186 | 10416896.0 |
| 2010-01-20 09:45:00 | AAPL | Stock | 7.6189 | 7.6239 | 7.5982 | 7.6043 | 16537248.0 |
| 2010-01-20 09:50:00 | AAPL | Stock | 7.6032 | 7.6093 | 7.5893 | 7.5893 | 12837496.0 |
| 2010-01-20 09:55:00 | AAPL | Stock | 7.5893 | 7.6036 | 7.5768 | 7.5932 | 15432228.0 |
| 2010-01-20 10:00:00 | AAPL | Stock | 7.5932 | 7.6029 | 7.5732 | 7.58 | 12316920.0 |
| 2010-01-20 10:05:00 | AAPL | Stock | 7.5814 | 7.5843 | 7.5568 | 7.5579 | 18319000.0 |
| 2010-01-20 10:10:00 | AAPL | Stock | 7.5579 | 7.5664 | 7.545 | 7.5482 | 14560896.0 |
| 2010-01-20 10:15:00 | AAPL | Stock | 7.5482 | 7.5625 | 7.5386 | 7.5579 | 11532304.0 |
| 2010-01-20 10:20:00 | AAPL | Stock | 7.5564 | 7.5671 | 7.5246 | 7.5361 | 18589900.0 |
| 2010-01-20 10:25:00 | AAPL | Stock | 7.5354 | 7.5364 | 7.5079 | 7.515 | 15150660.0 |
| 2010-01-20 10:30:00 | AAPL | Stock | 7.5146 | 7.5253 | 7.5011 | 7.5189 | 16430624.0 |
| 2010-01-20 10:35:00 | AAPL | Stock | 7.5189 | 7.5264 | 7.5086 | 7.5211 | 10306604.0 |
| 2010-01-20 10:40:00 | AAPL | Stock | 7.5196 | 7.5346 | 7.5196 | 7.5336 | 12047728.0 |
> showing 50 of 326,183 rows — these rows as CSV