PREVIEW / stock_5min / 2000-12-18
file: by_date/stock_5min/2000/2000-12-18.parquet size: 1.4 MB rows: 105,039 symbols: 1,267
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 |
|---|---|---|---|---|---|---|---|
| 2000-12-18 08:00:00 | AAPL | Stock | 0.2545 | 0.2556 | 0.2511 | 0.2511 | 722400.0 |
| 2000-12-18 08:30:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2578 | 0.2578 | 5600.0 |
| 2000-12-18 08:35:00 | AAPL | Stock | 0.2589 | 0.2595 | 0.2578 | 0.2578 | 728000.0 |
| 2000-12-18 08:40:00 | AAPL | Stock | 0.2595 | 0.2595 | 0.2595 | 0.2595 | 5600.0 |
| 2000-12-18 08:45:00 | AAPL | Stock | 0.2595 | 0.2595 | 0.2567 | 0.2567 | 50400.0 |
| 2000-12-18 08:50:00 | AAPL | Stock | 0.2567 | 0.2589 | 0.2567 | 0.2589 | 162400.0 |
| 2000-12-18 08:55:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.2589 | 0.2589 | 56000.0 |
| 2000-12-18 09:00:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.2589 | 0.2589 | 61600.0 |
| 2000-12-18 09:10:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2578 | 0.2578 | 140000.0 |
| 2000-12-18 09:15:00 | AAPL | Stock | 0.2567 | 0.2589 | 0.2556 | 0.2589 | 84000.0 |
| 2000-12-18 09:20:00 | AAPL | Stock | 0.2589 | 0.26 | 0.2578 | 0.26 | 823200.0 |
| 2000-12-18 09:25:00 | AAPL | Stock | 0.26 | 0.2612 | 0.26 | 0.2612 | 649600.0 |
| 2000-12-18 09:30:00 | AAPL | Stock | 0.26 | 0.2612 | 0.2589 | 0.26 | 15125600.0 |
| 2000-12-18 09:35:00 | AAPL | Stock | 0.26 | 0.2612 | 0.2589 | 0.2612 | 3880800.0 |
| 2000-12-18 09:40:00 | AAPL | Stock | 0.2612 | 0.2612 | 0.26 | 0.26 | 5639200.0 |
| 2000-12-18 09:45:00 | AAPL | Stock | 0.26 | 0.2612 | 0.2567 | 0.2567 | 4995200.0 |
| 2000-12-18 09:50:00 | AAPL | Stock | 0.2567 | 0.2589 | 0.2567 | 0.2578 | 3970400.0 |
| 2000-12-18 09:55:00 | AAPL | Stock | 0.2567 | 0.2578 | 0.2567 | 0.2578 | 3953600.0 |
| 2000-12-18 10:00:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2556 | 0.2578 | 4552800.0 |
| 2000-12-18 10:05:00 | AAPL | Stock | 0.2578 | 0.26 | 0.2567 | 0.2589 | 5555200.0 |
| 2000-12-18 10:10:00 | AAPL | Stock | 0.26 | 0.26 | 0.2578 | 0.2578 | 4368000.0 |
| 2000-12-18 10:15:00 | AAPL | Stock | 0.2578 | 0.2589 | 0.2567 | 0.2578 | 5084800.0 |
| 2000-12-18 10:20:00 | AAPL | Stock | 0.2578 | 0.2589 | 0.2567 | 0.2567 | 3024000.0 |
| 2000-12-18 10:25:00 | AAPL | Stock | 0.2578 | 0.2589 | 0.2567 | 0.2567 | 4597600.0 |
| 2000-12-18 10:30:00 | AAPL | Stock | 0.2567 | 0.2578 | 0.2567 | 0.2578 | 3158400.0 |
| 2000-12-18 10:35:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2556 | 0.2556 | 2357600.0 |
| 2000-12-18 10:40:00 | AAPL | Stock | 0.2567 | 0.2567 | 0.2556 | 0.2567 | 5000800.0 |
| 2000-12-18 10:45:00 | AAPL | Stock | 0.2556 | 0.2567 | 0.2556 | 0.2556 | 2161600.0 |
| 2000-12-18 10:50:00 | AAPL | Stock | 0.2556 | 0.2567 | 0.2545 | 0.2556 | 5628000.0 |
| 2000-12-18 10:55:00 | AAPL | Stock | 0.2556 | 0.2556 | 0.2533 | 0.2545 | 5124000.0 |
| 2000-12-18 11:00:00 | AAPL | Stock | 0.2545 | 0.2567 | 0.2533 | 0.2556 | 3343200.0 |
| 2000-12-18 11:05:00 | AAPL | Stock | 0.2567 | 0.2567 | 0.2545 | 0.2556 | 1092000.0 |
| 2000-12-18 11:10:00 | AAPL | Stock | 0.2556 | 0.2556 | 0.2545 | 0.2556 | 1792000.0 |
| 2000-12-18 11:15:00 | AAPL | Stock | 0.2556 | 0.2556 | 0.2545 | 0.2545 | 2665600.0 |
| 2000-12-18 11:20:00 | AAPL | Stock | 0.2556 | 0.2556 | 0.2533 | 0.2533 | 3012800.0 |
| 2000-12-18 11:25:00 | AAPL | Stock | 0.2533 | 0.2556 | 0.2533 | 0.2545 | 1618400.0 |
| 2000-12-18 11:30:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2533 | 0.2545 | 2256800.0 |
| 2000-12-18 11:35:00 | AAPL | Stock | 0.2545 | 0.2545 | 0.2533 | 0.2533 | 1663200.0 |
| 2000-12-18 11:40:00 | AAPL | Stock | 0.2545 | 0.2545 | 0.2533 | 0.2545 | 1607200.0 |
| 2000-12-18 11:45:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2533 | 0.2545 | 2620800.0 |
| 2000-12-18 11:50:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2533 | 0.2545 | 459200.0 |
| 2000-12-18 11:55:00 | AAPL | Stock | 0.2556 | 0.2556 | 0.2533 | 0.2545 | 1355200.0 |
| 2000-12-18 12:00:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2533 | 0.2533 | 722400.0 |
| 2000-12-18 12:05:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2533 | 0.2533 | 991200.0 |
| 2000-12-18 12:10:00 | AAPL | Stock | 0.2533 | 0.2545 | 0.2511 | 0.2511 | 4799200.0 |
| 2000-12-18 12:15:00 | AAPL | Stock | 0.2511 | 0.2522 | 0.2511 | 0.2522 | 2923200.0 |
| 2000-12-18 12:20:00 | AAPL | Stock | 0.2511 | 0.2522 | 0.2511 | 0.2511 | 1596000.0 |
| 2000-12-18 12:25:00 | AAPL | Stock | 0.2511 | 0.2522 | 0.2511 | 0.2522 | 2391200.0 |
| 2000-12-18 12:30:00 | AAPL | Stock | 0.2522 | 0.2522 | 0.2511 | 0.2511 | 890400.0 |
| 2000-12-18 12:35:00 | AAPL | Stock | 0.2522 | 0.2522 | 0.2511 | 0.2522 | 3270400.0 |
> showing 50 of 105,039 rows — these rows as CSV