PREVIEW / stock_5min / 2008-10-01
file: by_date/stock_5min/2008/2008-10-01.parquet size: 4.4 MB rows: 313,236 symbols: 3,347
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-01 05:55:00 | AAPL | Stock | 4.0714 | 4.0714 | 4.0714 | 4.0714 | 5600.0 |
| 2008-10-01 06:30:00 | AAPL | Stock | 4.0714 | 4.0714 | 4.0714 | 4.0714 | 2800.0 |
| 2008-10-01 07:00:00 | AAPL | Stock | 4.0539 | 4.0539 | 4.0539 | 4.0539 | 5600.0 |
| 2008-10-01 07:10:00 | AAPL | Stock | 4.0693 | 4.0693 | 4.0693 | 4.0693 | 4900.0 |
| 2008-10-01 07:15:00 | AAPL | Stock | 4.0693 | 4.0693 | 4.0693 | 4.0693 | 8400.0 |
| 2008-10-01 07:20:00 | AAPL | Stock | 4.0693 | 4.0693 | 4.0693 | 4.0693 | 8400.0 |
| 2008-10-01 07:25:00 | AAPL | Stock | 4.0693 | 4.0704 | 4.0546 | 4.0546 | 39200.0 |
| 2008-10-01 07:30:00 | AAPL | Stock | 4.0543 | 4.0543 | 4.0439 | 4.0439 | 98000.0 |
| 2008-10-01 07:35:00 | AAPL | Stock | 4.0439 | 4.0439 | 4.0439 | 4.0439 | 5600.0 |
| 2008-10-01 07:40:00 | AAPL | Stock | 4.0532 | 4.0532 | 4.0532 | 4.0532 | 5600.0 |
| 2008-10-01 07:50:00 | AAPL | Stock | 4.0518 | 4.0518 | 4.0518 | 4.0518 | 14000.0 |
| 2008-10-01 07:55:00 | AAPL | Stock | 4.0439 | 4.0439 | 4.0354 | 4.0357 | 477400.0 |
| 2008-10-01 08:00:00 | AAPL | Stock | 4.0482 | 4.0496 | 4.0179 | 4.0268 | 272832.0 |
| 2008-10-01 08:05:00 | AAPL | Stock | 4.0257 | 4.0304 | 4.0214 | 4.0304 | 236040.0 |
| 2008-10-01 08:10:00 | AAPL | Stock | 4.0286 | 4.0332 | 3.9964 | 3.9964 | 701484.0 |
| 2008-10-01 08:15:00 | AAPL | Stock | 4.0079 | 4.0179 | 4.0 | 4.0029 | 365372.0 |
| 2008-10-01 08:20:00 | AAPL | Stock | 4.005 | 4.0071 | 3.9911 | 3.9957 | 572348.0 |
| 2008-10-01 08:25:00 | AAPL | Stock | 3.9918 | 4.005 | 3.9857 | 4.0043 | 312788.0 |
| 2008-10-01 08:30:00 | AAPL | Stock | 4.0007 | 4.0075 | 4.0 | 4.0071 | 271180.0 |
| 2008-10-01 08:35:00 | AAPL | Stock | 4.0064 | 4.0104 | 4.0014 | 4.0014 | 129220.0 |
| 2008-10-01 08:40:00 | AAPL | Stock | 4.0011 | 4.0036 | 3.9964 | 4.0032 | 317744.0 |
| 2008-10-01 08:45:00 | AAPL | Stock | 4.0039 | 4.0243 | 4.0039 | 4.0214 | 230300.0 |
| 2008-10-01 08:50:00 | AAPL | Stock | 4.0214 | 4.0268 | 4.0075 | 4.0157 | 302344.0 |
| 2008-10-01 08:55:00 | AAPL | Stock | 4.0146 | 4.0146 | 4.0004 | 4.0032 | 132888.0 |
| 2008-10-01 09:00:00 | AAPL | Stock | 4.0054 | 4.0125 | 4.0 | 4.0082 | 482524.0 |
| 2008-10-01 09:05:00 | AAPL | Stock | 4.0064 | 4.0157 | 4.0061 | 4.0086 | 142800.0 |
| 2008-10-01 09:10:00 | AAPL | Stock | 4.0082 | 4.0082 | 4.0018 | 4.0021 | 171780.0 |
| 2008-10-01 09:15:00 | AAPL | Stock | 4.0021 | 4.0111 | 4.0004 | 4.0043 | 212352.0 |
| 2008-10-01 09:20:00 | AAPL | Stock | 4.0029 | 4.0111 | 3.9986 | 4.0071 | 351400.0 |
| 2008-10-01 09:25:00 | AAPL | Stock | 4.0036 | 4.0107 | 3.9929 | 3.9961 | 892556.0 |
| 2008-10-01 09:30:00 | AAPL | Stock | 3.9961 | 4.0125 | 3.9575 | 3.9639 | 33110000.0 |
| 2008-10-01 09:35:00 | AAPL | Stock | 3.9638 | 3.9779 | 3.9286 | 3.9407 | 33121144.0 |
| 2008-10-01 09:40:00 | AAPL | Stock | 3.9407 | 3.9782 | 3.9393 | 3.9764 | 23546516.0 |
| 2008-10-01 09:45:00 | AAPL | Stock | 3.9764 | 3.9864 | 3.9575 | 3.9636 | 21419328.0 |
| 2008-10-01 09:50:00 | AAPL | Stock | 3.9643 | 3.9668 | 3.9489 | 3.9543 | 16496788.0 |
| 2008-10-01 09:55:00 | AAPL | Stock | 3.9536 | 3.9821 | 3.9475 | 3.98 | 17523044.0 |
| 2008-10-01 10:00:00 | AAPL | Stock | 3.9811 | 3.9821 | 3.9421 | 3.9536 | 29531936.0 |
| 2008-10-01 10:05:00 | AAPL | Stock | 3.9532 | 3.9643 | 3.9304 | 3.9332 | 22583848.0 |
| 2008-10-01 10:10:00 | AAPL | Stock | 3.9332 | 3.9364 | 3.915 | 3.926 | 27291292.0 |
| 2008-10-01 10:15:00 | AAPL | Stock | 3.9271 | 3.9371 | 3.9107 | 3.9281 | 20737948.0 |
| 2008-10-01 10:20:00 | AAPL | Stock | 3.93 | 3.9357 | 3.9164 | 3.9182 | 15116696.0 |
| 2008-10-01 10:25:00 | AAPL | Stock | 3.9175 | 3.9214 | 3.895 | 3.9079 | 19539492.0 |
| 2008-10-01 10:30:00 | AAPL | Stock | 3.9075 | 3.9086 | 3.8839 | 3.8943 | 19400024.0 |
| 2008-10-01 10:35:00 | AAPL | Stock | 3.8964 | 3.8989 | 3.8696 | 3.87 | 16478924.0 |
| 2008-10-01 10:40:00 | AAPL | Stock | 3.8704 | 3.8921 | 3.8664 | 3.87 | 16719836.0 |
| 2008-10-01 10:45:00 | AAPL | Stock | 3.8711 | 3.8818 | 3.8482 | 3.8518 | 16575916.0 |
| 2008-10-01 10:50:00 | AAPL | Stock | 3.8504 | 3.8689 | 3.8414 | 3.8646 | 18492460.0 |
| 2008-10-01 10:55:00 | AAPL | Stock | 3.865 | 3.8704 | 3.8454 | 3.8593 | 10778292.0 |
| 2008-10-01 11:00:00 | AAPL | Stock | 3.8589 | 3.8798 | 3.8571 | 3.867 | 16316804.0 |
| 2008-10-01 11:05:00 | AAPL | Stock | 3.8661 | 3.8721 | 3.8429 | 3.8482 | 10783892.0 |
> showing 50 of 313,236 rows — these rows as CSV