PREVIEW / stock_5min / 2002-09-09
file: by_date/stock_5min/2002/2002-09-09.parquet size: 1.8 MB rows: 121,243 symbols: 1,469
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-09 09:20:00 | AAPL | Stock | 0.2552 | 0.2552 | 0.2552 | 0.2552 | 95200.0 |
| 2002-09-09 09:25:00 | AAPL | Stock | 0.2552 | 0.2557 | 0.2552 | 0.2552 | 137200.0 |
| 2002-09-09 09:30:00 | AAPL | Stock | 0.255 | 0.2552 | 0.2529 | 0.2532 | 2986032.0 |
| 2002-09-09 09:35:00 | AAPL | Stock | 0.2538 | 0.2539 | 0.2532 | 0.2536 | 2284800.0 |
| 2002-09-09 09:40:00 | AAPL | Stock | 0.2538 | 0.2552 | 0.2534 | 0.2543 | 2376080.0 |
| 2002-09-09 09:45:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2532 | 0.2532 | 1934800.0 |
| 2002-09-09 09:50:00 | AAPL | Stock | 0.2537 | 0.2541 | 0.2532 | 0.2536 | 2217600.0 |
| 2002-09-09 09:55:00 | AAPL | Stock | 0.2534 | 0.2545 | 0.2534 | 0.2541 | 1301048.0 |
| 2002-09-09 10:00:00 | AAPL | Stock | 0.2541 | 0.2541 | 0.2529 | 0.2532 | 3069920.0 |
| 2002-09-09 10:05:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.2527 | 0.2532 | 4356800.0 |
| 2002-09-09 10:10:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.2527 | 0.2536 | 3406816.0 |
| 2002-09-09 10:15:00 | AAPL | Stock | 0.2536 | 0.2538 | 0.2534 | 0.2538 | 2525600.0 |
| 2002-09-09 10:20:00 | AAPL | Stock | 0.2538 | 0.2541 | 0.2529 | 0.2532 | 2154880.0 |
| 2002-09-09 10:25:00 | AAPL | Stock | 0.253 | 0.2536 | 0.253 | 0.253 | 2027200.0 |
| 2002-09-09 10:30:00 | AAPL | Stock | 0.253 | 0.2532 | 0.2527 | 0.2529 | 3511200.0 |
| 2002-09-09 10:35:00 | AAPL | Stock | 0.253 | 0.253 | 0.2527 | 0.2527 | 683200.0 |
| 2002-09-09 10:40:00 | AAPL | Stock | 0.2527 | 0.2532 | 0.2527 | 0.2529 | 812000.0 |
| 2002-09-09 10:45:00 | AAPL | Stock | 0.2527 | 0.2532 | 0.2527 | 0.2532 | 420000.0 |
| 2002-09-09 10:50:00 | AAPL | Stock | 0.253 | 0.2536 | 0.253 | 0.2536 | 924000.0 |
| 2002-09-09 10:55:00 | AAPL | Stock | 0.2536 | 0.2538 | 0.2532 | 0.2536 | 1316448.0 |
| 2002-09-09 11:00:00 | AAPL | Stock | 0.2538 | 0.2539 | 0.2532 | 0.2538 | 1058400.0 |
| 2002-09-09 11:05:00 | AAPL | Stock | 0.2536 | 0.2538 | 0.2532 | 0.2532 | 2210600.0 |
| 2002-09-09 11:10:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.253 | 0.2532 | 1114400.0 |
| 2002-09-09 11:15:00 | AAPL | Stock | 0.2532 | 0.2536 | 0.2532 | 0.2534 | 1478400.0 |
| 2002-09-09 11:20:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2532 | 0.2534 | 2542400.0 |
| 2002-09-09 11:25:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.253 | 0.2532 | 1041600.0 |
| 2002-09-09 11:30:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.253 | 0.253 | 896000.0 |
| 2002-09-09 11:35:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.253 | 0.2532 | 179200.0 |
| 2002-09-09 11:40:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2532 | 0.2532 | 184800.0 |
| 2002-09-09 11:45:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.253 | 0.2534 | 576800.0 |
| 2002-09-09 11:50:00 | AAPL | Stock | 0.2532 | 0.2538 | 0.2532 | 0.2538 | 557088.0 |
| 2002-09-09 11:55:00 | AAPL | Stock | 0.2536 | 0.2536 | 0.2529 | 0.2531 | 1512000.0 |
| 2002-09-09 12:00:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.2527 | 0.2532 | 1646400.0 |
| 2002-09-09 12:05:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2532 | 0.2534 | 201600.0 |
| 2002-09-09 12:10:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.2532 | 0.2534 | 212800.0 |
| 2002-09-09 12:15:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2532 | 0.2532 | 800800.0 |
| 2002-09-09 12:20:00 | AAPL | Stock | 0.2532 | 0.2534 | 0.2532 | 0.2534 | 868000.0 |
| 2002-09-09 12:25:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2534 | 0.2534 | 28000.0 |
| 2002-09-09 12:30:00 | AAPL | Stock | 0.2534 | 0.2536 | 0.2534 | 0.2536 | 285600.0 |
| 2002-09-09 12:35:00 | AAPL | Stock | 0.2534 | 0.2536 | 0.2532 | 0.2534 | 1136800.0 |
| 2002-09-09 12:40:00 | AAPL | Stock | 0.2535 | 0.2536 | 0.2532 | 0.2536 | 526400.0 |
| 2002-09-09 12:45:00 | AAPL | Stock | 0.2537 | 0.2543 | 0.2536 | 0.2536 | 1075200.0 |
| 2002-09-09 12:50:00 | AAPL | Stock | 0.2536 | 0.2543 | 0.2534 | 0.2539 | 1680000.0 |
| 2002-09-09 12:55:00 | AAPL | Stock | 0.2541 | 0.2548 | 0.2538 | 0.2543 | 3155600.0 |
| 2002-09-09 13:00:00 | AAPL | Stock | 0.2543 | 0.2552 | 0.2541 | 0.2552 | 1725696.0 |
| 2002-09-09 13:05:00 | AAPL | Stock | 0.2552 | 0.2555 | 0.2539 | 0.2541 | 1426936.0 |
| 2002-09-09 13:10:00 | AAPL | Stock | 0.2543 | 0.2545 | 0.2539 | 0.2539 | 376824.0 |
| 2002-09-09 13:15:00 | AAPL | Stock | 0.2545 | 0.2546 | 0.2543 | 0.2543 | 713608.0 |
| 2002-09-09 13:20:00 | AAPL | Stock | 0.2543 | 0.2548 | 0.2539 | 0.2546 | 464800.0 |
| 2002-09-09 13:25:00 | AAPL | Stock | 0.2546 | 0.2559 | 0.2546 | 0.2557 | 2116240.0 |
> showing 50 of 121,243 rows — these rows as CSV