PREVIEW / stock_5min / 2004-12-23
file: by_date/stock_5min/2004/2004-12-23.parquet size: 2.4 MB rows: 179,390 symbols: 1,904
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 |
|---|---|---|---|---|---|---|---|
| 2004-12-23 08:00:00 | AAPL | Stock | 1.1391 | 1.1391 | 1.1391 | 1.1391 | 14000.0 |
| 2004-12-23 08:05:00 | AAPL | Stock | 1.1391 | 1.1391 | 1.1384 | 1.1384 | 24584.0 |
| 2004-12-23 08:10:00 | AAPL | Stock | 1.1389 | 1.1391 | 1.1389 | 1.1391 | 122584.0 |
| 2004-12-23 08:15:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 22400.0 |
| 2004-12-23 08:20:00 | AAPL | Stock | 1.1395 | 1.1395 | 1.1391 | 1.1391 | 80640.0 |
| 2004-12-23 08:25:00 | AAPL | Stock | 1.1391 | 1.1391 | 1.1391 | 1.1391 | 8960.0 |
| 2004-12-23 08:40:00 | AAPL | Stock | 1.1375 | 1.1375 | 1.1375 | 1.1375 | 5600.0 |
| 2004-12-23 08:45:00 | AAPL | Stock | 1.1389 | 1.1393 | 1.1389 | 1.1393 | 235200.0 |
| 2004-12-23 08:55:00 | AAPL | Stock | 1.1393 | 1.1393 | 1.1393 | 1.1393 | 84000.0 |
| 2004-12-23 09:00:00 | AAPL | Stock | 1.14 | 1.14 | 1.14 | 1.14 | 28000.0 |
| 2004-12-23 09:05:00 | AAPL | Stock | 1.1402 | 1.1402 | 1.1395 | 1.1402 | 95200.0 |
| 2004-12-23 09:10:00 | AAPL | Stock | 1.14 | 1.14 | 1.14 | 1.14 | 5600.0 |
| 2004-12-23 09:20:00 | AAPL | Stock | 1.1395 | 1.1396 | 1.1377 | 1.1377 | 100800.0 |
| 2004-12-23 09:25:00 | AAPL | Stock | 1.1395 | 1.1395 | 1.1359 | 1.1384 | 628880.0 |
| 2004-12-23 09:30:00 | AAPL | Stock | 1.1384 | 1.1407 | 1.1357 | 1.1364 | 11707472.0 |
| 2004-12-23 09:35:00 | AAPL | Stock | 1.1368 | 1.1446 | 1.1364 | 1.1441 | 11334848.0 |
| 2004-12-23 09:40:00 | AAPL | Stock | 1.1443 | 1.1473 | 1.1395 | 1.1423 | 11919824.0 |
| 2004-12-23 09:45:00 | AAPL | Stock | 1.1423 | 1.1452 | 1.1414 | 1.1432 | 5638584.0 |
| 2004-12-23 09:50:00 | AAPL | Stock | 1.1429 | 1.1445 | 1.142 | 1.1432 | 6529320.0 |
| 2004-12-23 09:55:00 | AAPL | Stock | 1.1434 | 1.1461 | 1.1432 | 1.1452 | 7030520.0 |
| 2004-12-23 10:00:00 | AAPL | Stock | 1.1452 | 1.1454 | 1.1429 | 1.1441 | 4900112.0 |
| 2004-12-23 10:05:00 | AAPL | Stock | 1.1441 | 1.1441 | 1.1405 | 1.1429 | 5896352.0 |
| 2004-12-23 10:10:00 | AAPL | Stock | 1.1429 | 1.1446 | 1.1423 | 1.1429 | 3413144.0 |
| 2004-12-23 10:15:00 | AAPL | Stock | 1.1429 | 1.147 | 1.1429 | 1.1457 | 9068752.0 |
| 2004-12-23 10:20:00 | AAPL | Stock | 1.1464 | 1.1468 | 1.1441 | 1.1447 | 4017608.0 |
| 2004-12-23 10:25:00 | AAPL | Stock | 1.1448 | 1.1457 | 1.1432 | 1.1434 | 3127656.0 |
| 2004-12-23 10:30:00 | AAPL | Stock | 1.1434 | 1.1446 | 1.1425 | 1.143 | 6833792.0 |
| 2004-12-23 10:35:00 | AAPL | Stock | 1.143 | 1.1464 | 1.1429 | 1.1438 | 4211816.0 |
| 2004-12-23 10:40:00 | AAPL | Stock | 1.1436 | 1.1441 | 1.1429 | 1.1429 | 3831632.0 |
| 2004-12-23 10:45:00 | AAPL | Stock | 1.1429 | 1.1436 | 1.1423 | 1.1432 | 2458008.0 |
| 2004-12-23 10:50:00 | AAPL | Stock | 1.1434 | 1.1434 | 1.1427 | 1.1432 | 2219672.0 |
| 2004-12-23 10:55:00 | AAPL | Stock | 1.1432 | 1.1432 | 1.1427 | 1.143 | 2922024.0 |
| 2004-12-23 11:00:00 | AAPL | Stock | 1.1429 | 1.1432 | 1.1429 | 1.1432 | 2347296.0 |
| 2004-12-23 11:05:00 | AAPL | Stock | 1.143 | 1.1434 | 1.1429 | 1.1431 | 3594080.0 |
| 2004-12-23 11:10:00 | AAPL | Stock | 1.1434 | 1.1436 | 1.1427 | 1.143 | 3408496.0 |
| 2004-12-23 11:15:00 | AAPL | Stock | 1.143 | 1.1446 | 1.1413 | 1.1416 | 3284064.0 |
| 2004-12-23 11:20:00 | AAPL | Stock | 1.1413 | 1.1425 | 1.1393 | 1.1411 | 3981320.0 |
| 2004-12-23 11:25:00 | AAPL | Stock | 1.1411 | 1.1429 | 1.1401 | 1.1413 | 3266928.0 |
| 2004-12-23 11:30:00 | AAPL | Stock | 1.1407 | 1.1429 | 1.1407 | 1.1413 | 1377096.0 |
| 2004-12-23 11:35:00 | AAPL | Stock | 1.1416 | 1.1421 | 1.1402 | 1.1416 | 3773000.0 |
| 2004-12-23 11:40:00 | AAPL | Stock | 1.1418 | 1.142 | 1.1407 | 1.1409 | 4162536.0 |
| 2004-12-23 11:45:00 | AAPL | Stock | 1.1409 | 1.1411 | 1.1402 | 1.1402 | 2220568.0 |
| 2004-12-23 11:50:00 | AAPL | Stock | 1.1403 | 1.1416 | 1.1402 | 1.1416 | 3967488.0 |
| 2004-12-23 11:55:00 | AAPL | Stock | 1.1414 | 1.1416 | 1.1409 | 1.1409 | 1074528.0 |
| 2004-12-23 12:00:00 | AAPL | Stock | 1.1411 | 1.142 | 1.1411 | 1.1413 | 1122240.0 |
| 2004-12-23 12:05:00 | AAPL | Stock | 1.1413 | 1.1416 | 1.14 | 1.1405 | 1297968.0 |
| 2004-12-23 12:10:00 | AAPL | Stock | 1.1407 | 1.1411 | 1.14 | 1.1404 | 1636152.0 |
| 2004-12-23 12:15:00 | AAPL | Stock | 1.1405 | 1.1411 | 1.1404 | 1.1409 | 1146040.0 |
| 2004-12-23 12:20:00 | AAPL | Stock | 1.1409 | 1.1411 | 1.1405 | 1.1409 | 838488.0 |
| 2004-12-23 12:25:00 | AAPL | Stock | 1.1411 | 1.142 | 1.1404 | 1.1418 | 1760752.0 |
> showing 50 of 179,390 rows — these rows as CSV