PREVIEW / stock_5min / 2010-10-25
file: by_date/stock_5min/2010/2010-10-25.parquet size: 4.7 MB rows: 322,122 symbols: 3,497
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-10-25 04:00:00 | AAPL | Stock | 10.9286 | 10.9961 | 10.9286 | 10.9961 | 28000.0 |
| 2010-10-25 04:15:00 | AAPL | Stock | 11.0329 | 11.0411 | 11.0329 | 11.0411 | 8960.0 |
| 2010-10-25 04:30:00 | AAPL | Stock | 11.0361 | 11.0361 | 11.0361 | 11.0361 | 5600.0 |
| 2010-10-25 04:35:00 | AAPL | Stock | 11.0361 | 11.0454 | 11.0182 | 11.0454 | 8400.0 |
| 2010-10-25 04:45:00 | AAPL | Stock | 11.0411 | 11.0411 | 11.0411 | 11.0411 | 2800.0 |
| 2010-10-25 05:25:00 | AAPL | Stock | 11.0411 | 11.0411 | 11.0357 | 11.0357 | 30800.0 |
| 2010-10-25 05:35:00 | AAPL | Stock | 11.0436 | 11.0436 | 11.0368 | 11.0436 | 8400.0 |
| 2010-10-25 06:20:00 | AAPL | Stock | 11.0343 | 11.0343 | 11.0343 | 11.0343 | 5600.0 |
| 2010-10-25 06:25:00 | AAPL | Stock | 11.0343 | 11.0343 | 11.0343 | 11.0343 | 5600.0 |
| 2010-10-25 06:35:00 | AAPL | Stock | 11.0286 | 11.0286 | 11.0286 | 11.0286 | 2800.0 |
| 2010-10-25 06:40:00 | AAPL | Stock | 11.03 | 11.03 | 11.03 | 11.03 | 5600.0 |
| 2010-10-25 07:05:00 | AAPL | Stock | 11.0446 | 11.05 | 11.0196 | 11.0196 | 55440.0 |
| 2010-10-25 07:15:00 | AAPL | Stock | 11.0489 | 11.0511 | 11.0454 | 11.0511 | 43372.0 |
| 2010-10-25 07:20:00 | AAPL | Stock | 11.0625 | 11.0643 | 11.0532 | 11.0589 | 138292.0 |
| 2010-10-25 07:25:00 | AAPL | Stock | 11.0636 | 11.0643 | 11.0625 | 11.0625 | 23380.0 |
| 2010-10-25 07:30:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0607 | 11.0607 | 42000.0 |
| 2010-10-25 07:35:00 | AAPL | Stock | 11.0575 | 11.0654 | 11.0575 | 11.0654 | 16800.0 |
| 2010-10-25 07:40:00 | AAPL | Stock | 11.0532 | 11.0611 | 11.0518 | 11.0518 | 77308.0 |
| 2010-10-25 07:45:00 | AAPL | Stock | 11.0457 | 11.0457 | 11.0279 | 11.0279 | 129556.0 |
| 2010-10-25 07:50:00 | AAPL | Stock | 11.0393 | 11.0393 | 11.0393 | 11.0393 | 22400.0 |
| 2010-10-25 07:55:00 | AAPL | Stock | 11.0379 | 11.0379 | 11.0346 | 11.0357 | 47600.0 |
| 2010-10-25 08:00:00 | AAPL | Stock | 11.0393 | 11.0446 | 11.0357 | 11.0411 | 301392.0 |
| 2010-10-25 08:05:00 | AAPL | Stock | 11.0375 | 11.0396 | 10.9982 | 11.0371 | 377720.0 |
| 2010-10-25 08:10:00 | AAPL | Stock | 11.0411 | 11.0454 | 11.0364 | 11.0421 | 707140.0 |
| 2010-10-25 08:15:00 | AAPL | Stock | 11.0425 | 11.0446 | 11.0375 | 11.0393 | 168336.0 |
| 2010-10-25 08:20:00 | AAPL | Stock | 11.0379 | 11.0411 | 11.0293 | 11.0379 | 373128.0 |
| 2010-10-25 08:25:00 | AAPL | Stock | 11.0357 | 11.0393 | 11.0329 | 11.0386 | 138096.0 |
| 2010-10-25 08:30:00 | AAPL | Stock | 11.0382 | 11.0393 | 11.0357 | 11.0386 | 215040.0 |
| 2010-10-25 08:35:00 | AAPL | Stock | 11.04 | 11.04 | 11.0296 | 11.0325 | 276528.0 |
| 2010-10-25 08:40:00 | AAPL | Stock | 11.0321 | 11.0368 | 11.0321 | 11.0368 | 229320.0 |
| 2010-10-25 08:45:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0314 | 11.0343 | 75180.0 |
| 2010-10-25 08:50:00 | AAPL | Stock | 11.0336 | 11.0354 | 11.0307 | 11.0314 | 94360.0 |
| 2010-10-25 08:55:00 | AAPL | Stock | 11.0332 | 11.0332 | 11.0286 | 11.0293 | 269080.0 |
| 2010-10-25 09:00:00 | AAPL | Stock | 11.03 | 11.0321 | 11.0289 | 11.0314 | 53200.0 |
| 2010-10-25 09:05:00 | AAPL | Stock | 11.0314 | 11.0407 | 11.0314 | 11.0325 | 289800.0 |
| 2010-10-25 09:10:00 | AAPL | Stock | 11.0325 | 11.0371 | 11.0325 | 11.035 | 78960.0 |
| 2010-10-25 09:15:00 | AAPL | Stock | 11.0354 | 11.0357 | 11.0289 | 11.0289 | 53200.0 |
| 2010-10-25 09:20:00 | AAPL | Stock | 11.0289 | 11.0357 | 11.0289 | 11.0332 | 61600.0 |
| 2010-10-25 09:25:00 | AAPL | Stock | 11.0332 | 11.0407 | 11.0318 | 11.0407 | 321440.0 |
| 2010-10-25 09:30:00 | AAPL | Stock | 11.0396 | 11.0704 | 11.0157 | 11.0682 | 16738932.0 |
| 2010-10-25 09:35:00 | AAPL | Stock | 11.0671 | 11.11 | 11.0671 | 11.11 | 20985132.0 |
| 2010-10-25 09:40:00 | AAPL | Stock | 11.11 | 11.1286 | 11.0875 | 11.0968 | 16997036.0 |
| 2010-10-25 09:45:00 | AAPL | Stock | 11.0973 | 11.1164 | 11.0932 | 11.1109 | 7417256.0 |
| 2010-10-25 09:50:00 | AAPL | Stock | 11.1083 | 11.1139 | 11.1 | 11.1036 | 4876844.0 |
| 2010-10-25 09:55:00 | AAPL | Stock | 11.1066 | 11.1066 | 11.0875 | 11.0982 | 7340004.0 |
| 2010-10-25 10:00:00 | AAPL | Stock | 11.0982 | 11.1107 | 11.0729 | 11.0886 | 10254692.0 |
| 2010-10-25 10:05:00 | AAPL | Stock | 11.0896 | 11.1068 | 11.0804 | 11.0946 | 7119980.0 |
| 2010-10-25 10:10:00 | AAPL | Stock | 11.0943 | 11.11 | 11.0914 | 11.0939 | 6628692.0 |
| 2010-10-25 10:15:00 | AAPL | Stock | 11.0939 | 11.1054 | 11.0821 | 11.0936 | 7429268.0 |
| 2010-10-25 10:20:00 | AAPL | Stock | 11.0936 | 11.1175 | 11.0854 | 11.1082 | 12107452.0 |
> showing 50 of 322,122 rows — these rows as CSV