PREVIEW / stock_5min / 2010-06-08
file: by_date/stock_5min/2010/2010-06-08.parquet size: 4.9 MB rows: 334,672 symbols: 3,466
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-06-08 04:15:00 | AAPL | Stock | 9.0696 | 9.0696 | 9.0696 | 9.0696 | 2800.0 |
| 2010-06-08 05:00:00 | AAPL | Stock | 9.0018 | 9.0018 | 9.0018 | 9.0018 | 11340.0 |
| 2010-06-08 05:45:00 | AAPL | Stock | 9.0229 | 9.0229 | 9.0229 | 9.0229 | 14000.0 |
| 2010-06-08 06:55:00 | AAPL | Stock | 9.0036 | 9.0036 | 9.0036 | 9.0036 | 13720.0 |
| 2010-06-08 07:00:00 | AAPL | Stock | 9.0089 | 9.0089 | 9.0086 | 9.0089 | 31696.0 |
| 2010-06-08 07:10:00 | AAPL | Stock | 9.0143 | 9.0179 | 9.0143 | 9.0179 | 19600.0 |
| 2010-06-08 07:15:00 | AAPL | Stock | 9.0214 | 9.0321 | 9.0214 | 9.0321 | 30800.0 |
| 2010-06-08 07:20:00 | AAPL | Stock | 9.0214 | 9.0354 | 9.0214 | 9.0354 | 19600.0 |
| 2010-06-08 07:25:00 | AAPL | Stock | 9.025 | 9.025 | 9.0186 | 9.025 | 32200.0 |
| 2010-06-08 07:30:00 | AAPL | Stock | 9.0236 | 9.0329 | 9.0182 | 9.0314 | 59528.0 |
| 2010-06-08 07:35:00 | AAPL | Stock | 9.0304 | 9.0304 | 9.025 | 9.025 | 30800.0 |
| 2010-06-08 07:40:00 | AAPL | Stock | 9.0207 | 9.0271 | 9.0207 | 9.0214 | 22400.0 |
| 2010-06-08 07:45:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0089 | 9.0089 | 95200.0 |
| 2010-06-08 07:50:00 | AAPL | Stock | 9.0093 | 9.0129 | 9.0 | 9.0107 | 64456.0 |
| 2010-06-08 07:55:00 | AAPL | Stock | 9.0096 | 9.0096 | 9.0 | 9.0 | 14000.0 |
| 2010-06-08 08:00:00 | AAPL | Stock | 9.0086 | 9.0321 | 8.9982 | 9.0239 | 433916.0 |
| 2010-06-08 08:05:00 | AAPL | Stock | 9.0282 | 9.0607 | 9.025 | 9.0579 | 517356.0 |
| 2010-06-08 08:10:00 | AAPL | Stock | 9.0579 | 9.0611 | 9.05 | 9.0536 | 471968.0 |
| 2010-06-08 08:15:00 | AAPL | Stock | 9.0536 | 9.0893 | 9.0532 | 9.0886 | 1040368.0 |
| 2010-06-08 08:20:00 | AAPL | Stock | 9.0875 | 9.0939 | 9.0821 | 9.0821 | 1079064.0 |
| 2010-06-08 08:25:00 | AAPL | Stock | 9.0836 | 9.0836 | 9.0696 | 9.0696 | 519484.0 |
| 2010-06-08 08:30:00 | AAPL | Stock | 9.07 | 9.0732 | 9.0661 | 9.0711 | 233156.0 |
| 2010-06-08 08:35:00 | AAPL | Stock | 9.073 | 9.0789 | 9.0711 | 9.0711 | 450240.0 |
| 2010-06-08 08:40:00 | AAPL | Stock | 9.0707 | 9.0707 | 9.0591 | 9.0593 | 412300.0 |
| 2010-06-08 08:45:00 | AAPL | Stock | 9.0593 | 9.0621 | 9.0539 | 9.0582 | 154896.0 |
| 2010-06-08 08:50:00 | AAPL | Stock | 9.0586 | 9.0593 | 9.0436 | 9.0461 | 451500.0 |
| 2010-06-08 08:55:00 | AAPL | Stock | 9.0461 | 9.0546 | 9.0386 | 9.0432 | 512652.0 |
| 2010-06-08 09:00:00 | AAPL | Stock | 9.0432 | 9.0554 | 9.0432 | 9.0504 | 217224.0 |
| 2010-06-08 09:05:00 | AAPL | Stock | 9.0496 | 9.0518 | 9.0468 | 9.0468 | 133392.0 |
| 2010-06-08 09:10:00 | AAPL | Stock | 9.0482 | 9.0482 | 9.0386 | 9.0425 | 432320.0 |
| 2010-06-08 09:15:00 | AAPL | Stock | 9.0418 | 9.0418 | 9.0332 | 9.0396 | 412356.0 |
| 2010-06-08 09:20:00 | AAPL | Stock | 9.0393 | 9.04 | 9.0282 | 9.0354 | 379652.0 |
| 2010-06-08 09:25:00 | AAPL | Stock | 9.0325 | 9.0468 | 9.0286 | 9.0429 | 596960.0 |
| 2010-06-08 09:30:00 | AAPL | Stock | 9.0439 | 9.0493 | 8.9839 | 9.0361 | 25502624.0 |
| 2010-06-08 09:35:00 | AAPL | Stock | 9.04 | 9.0643 | 9.0196 | 9.0314 | 15985844.0 |
| 2010-06-08 09:40:00 | AAPL | Stock | 9.0286 | 9.0496 | 9.0148 | 9.0232 | 12644884.0 |
| 2010-06-08 09:45:00 | AAPL | Stock | 9.0232 | 9.025 | 8.9907 | 8.9911 | 16822652.0 |
| 2010-06-08 09:50:00 | AAPL | Stock | 8.9911 | 8.9918 | 8.9521 | 8.9721 | 23527196.0 |
| 2010-06-08 09:55:00 | AAPL | Stock | 8.9704 | 8.98 | 8.9293 | 8.9588 | 23120104.0 |
| 2010-06-08 10:00:00 | AAPL | Stock | 8.9604 | 9.0107 | 8.9557 | 9.0071 | 16378404.0 |
| 2010-06-08 10:05:00 | AAPL | Stock | 9.0054 | 9.0143 | 8.9732 | 9.0015 | 10982356.0 |
| 2010-06-08 10:10:00 | AAPL | Stock | 9.0043 | 9.005 | 8.965 | 8.9821 | 9056852.0 |
| 2010-06-08 10:15:00 | AAPL | Stock | 8.9818 | 8.9821 | 8.8861 | 8.898 | 26082616.0 |
| 2010-06-08 10:20:00 | AAPL | Stock | 8.8975 | 8.9079 | 8.8704 | 8.8754 | 21487928.0 |
| 2010-06-08 10:25:00 | AAPL | Stock | 8.8754 | 8.9107 | 8.8514 | 8.9105 | 21420140.0 |
| 2010-06-08 10:30:00 | AAPL | Stock | 8.9107 | 8.9386 | 8.9036 | 8.92 | 17911012.0 |
| 2010-06-08 10:35:00 | AAPL | Stock | 8.9214 | 8.9354 | 8.9043 | 8.9129 | 11093964.0 |
| 2010-06-08 10:40:00 | AAPL | Stock | 8.9114 | 8.9129 | 8.8779 | 8.885 | 11063024.0 |
| 2010-06-08 10:45:00 | AAPL | Stock | 8.8843 | 8.8989 | 8.8543 | 8.8946 | 12862836.0 |
| 2010-06-08 10:50:00 | AAPL | Stock | 8.8947 | 8.9032 | 8.8796 | 8.8964 | 8096536.0 |
> showing 50 of 334,672 rows — these rows as CSV