PREVIEW / stock_5min / 2007-11-20
file: by_date/stock_5min/2007/2007-11-20.parquet size: 4.5 MB rows: 320,990 symbols: 3,212
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-20 06:40:00 | AAPL | Stock | 5.9525 | 5.9525 | 5.9525 | 5.9525 | 24164.0 |
| 2007-11-20 06:45:00 | AAPL | Stock | 5.9686 | 5.9686 | 5.9643 | 5.9643 | 13160.0 |
| 2007-11-20 06:50:00 | AAPL | Stock | 5.9896 | 6.0121 | 5.9896 | 6.0121 | 79800.0 |
| 2007-11-20 06:55:00 | AAPL | Stock | 6.0139 | 6.0175 | 6.0121 | 6.0175 | 56000.0 |
| 2007-11-20 07:00:00 | AAPL | Stock | 6.0175 | 6.0175 | 5.9911 | 5.9911 | 146552.0 |
| 2007-11-20 07:05:00 | AAPL | Stock | 5.9911 | 6.0036 | 5.9911 | 6.0036 | 61264.0 |
| 2007-11-20 07:10:00 | AAPL | Stock | 6.0054 | 6.0054 | 5.9964 | 5.9964 | 56112.0 |
| 2007-11-20 07:15:00 | AAPL | Stock | 5.9964 | 5.9982 | 5.9964 | 5.9982 | 8400.0 |
| 2007-11-20 07:20:00 | AAPL | Stock | 5.9982 | 5.9982 | 5.9979 | 5.9979 | 86800.0 |
| 2007-11-20 07:25:00 | AAPL | Stock | 5.9911 | 5.9982 | 5.9911 | 5.9982 | 89600.0 |
| 2007-11-20 07:30:00 | AAPL | Stock | 5.9982 | 6.0 | 5.9929 | 5.9929 | 111972.0 |
| 2007-11-20 07:35:00 | AAPL | Stock | 5.9946 | 6.0004 | 5.9679 | 5.9679 | 258272.0 |
| 2007-11-20 07:40:00 | AAPL | Stock | 5.9821 | 5.9821 | 5.9625 | 5.9625 | 54320.0 |
| 2007-11-20 07:45:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9575 | 5.9643 | 107520.0 |
| 2007-11-20 07:50:00 | AAPL | Stock | 5.9643 | 5.9643 | 5.9179 | 5.9479 | 313460.0 |
| 2007-11-20 07:55:00 | AAPL | Stock | 5.9307 | 5.9643 | 5.9286 | 5.9636 | 138068.0 |
| 2007-11-20 08:00:00 | AAPL | Stock | 5.9518 | 5.9732 | 5.9454 | 5.9732 | 1136212.0 |
| 2007-11-20 08:05:00 | AAPL | Stock | 5.9714 | 5.9768 | 5.9643 | 5.9768 | 1009848.0 |
| 2007-11-20 08:10:00 | AAPL | Stock | 5.9732 | 5.9814 | 5.9714 | 5.9732 | 684404.0 |
| 2007-11-20 08:15:00 | AAPL | Stock | 5.9732 | 5.9757 | 5.9611 | 5.9611 | 322504.0 |
| 2007-11-20 08:20:00 | AAPL | Stock | 5.96 | 5.96 | 5.9389 | 5.94 | 690116.0 |
| 2007-11-20 08:25:00 | AAPL | Stock | 5.9418 | 5.9443 | 5.9296 | 5.9346 | 427140.0 |
| 2007-11-20 08:30:00 | AAPL | Stock | 5.9361 | 5.9411 | 5.92 | 5.9286 | 839356.0 |
| 2007-11-20 08:35:00 | AAPL | Stock | 5.9286 | 5.9304 | 5.9107 | 5.9254 | 678916.0 |
| 2007-11-20 08:40:00 | AAPL | Stock | 5.9246 | 5.9286 | 5.9025 | 5.9079 | 676396.0 |
| 2007-11-20 08:45:00 | AAPL | Stock | 5.9089 | 5.9139 | 5.8993 | 5.9107 | 521388.0 |
| 2007-11-20 08:50:00 | AAPL | Stock | 5.9121 | 5.925 | 5.9121 | 5.9236 | 243516.0 |
| 2007-11-20 08:55:00 | AAPL | Stock | 5.925 | 5.9393 | 5.9186 | 5.9286 | 759444.0 |
| 2007-11-20 09:00:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9179 | 5.9261 | 351680.0 |
| 2007-11-20 09:05:00 | AAPL | Stock | 5.9264 | 5.9357 | 5.92 | 5.9357 | 402136.0 |
| 2007-11-20 09:10:00 | AAPL | Stock | 5.935 | 5.9418 | 5.9286 | 5.9289 | 428904.0 |
| 2007-11-20 09:15:00 | AAPL | Stock | 5.9275 | 5.9289 | 5.9139 | 5.9164 | 201628.0 |
| 2007-11-20 09:20:00 | AAPL | Stock | 5.9136 | 5.9193 | 5.9107 | 5.9107 | 158144.0 |
| 2007-11-20 09:25:00 | AAPL | Stock | 5.9107 | 5.9225 | 5.9 | 5.9179 | 736148.0 |
| 2007-11-20 09:30:00 | AAPL | Stock | 5.9179 | 5.9957 | 5.8936 | 5.9321 | 28536144.0 |
| 2007-11-20 09:35:00 | AAPL | Stock | 5.9321 | 5.9636 | 5.9286 | 5.9621 | 22882048.0 |
| 2007-11-20 09:40:00 | AAPL | Stock | 5.9621 | 5.9786 | 5.9543 | 5.9736 | 29461012.0 |
| 2007-11-20 09:45:00 | AAPL | Stock | 5.9736 | 6.01 | 5.9736 | 6.0015 | 26492228.0 |
| 2007-11-20 09:50:00 | AAPL | Stock | 6.0014 | 6.0432 | 5.9911 | 6.0339 | 32620280.0 |
| 2007-11-20 09:55:00 | AAPL | Stock | 6.0339 | 6.0554 | 6.0214 | 6.0393 | 30079112.0 |
| 2007-11-20 10:00:00 | AAPL | Stock | 6.0397 | 6.0857 | 6.0393 | 6.07 | 33395824.0 |
| 2007-11-20 10:05:00 | AAPL | Stock | 6.0711 | 6.0814 | 6.045 | 6.0764 | 23751560.0 |
| 2007-11-20 10:10:00 | AAPL | Stock | 6.0768 | 6.1032 | 6.0625 | 6.0661 | 33720204.0 |
| 2007-11-20 10:15:00 | AAPL | Stock | 6.065 | 6.0714 | 6.0457 | 6.0675 | 19029500.0 |
| 2007-11-20 10:20:00 | AAPL | Stock | 6.0679 | 6.0714 | 6.0275 | 6.0377 | 18646320.0 |
| 2007-11-20 10:25:00 | AAPL | Stock | 6.0371 | 6.0521 | 6.03 | 6.0514 | 18618964.0 |
| 2007-11-20 10:30:00 | AAPL | Stock | 6.0514 | 6.0668 | 6.035 | 6.0621 | 14604324.0 |
| 2007-11-20 10:35:00 | AAPL | Stock | 6.0625 | 6.0789 | 6.0579 | 6.0729 | 18968124.0 |
| 2007-11-20 10:40:00 | AAPL | Stock | 6.0718 | 6.0979 | 6.07 | 6.0864 | 19948264.0 |
| 2007-11-20 10:45:00 | AAPL | Stock | 6.0864 | 6.1107 | 6.0857 | 6.0921 | 24362912.0 |
> showing 50 of 320,990 rows — these rows as CSV