PREVIEW / stock_5min / 2003-08-14
file: by_date/stock_5min/2003/2003-08-14.parquet size: 2.0 MB rows: 142,004 symbols: 1,607
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 |
|---|---|---|---|---|---|---|---|
| 2003-08-14 09:25:00 | AAPL | Stock | 0.3602 | 0.3602 | 0.3593 | 0.3593 | 212800.0 |
| 2003-08-14 09:30:00 | AAPL | Stock | 0.3609 | 0.362 | 0.3593 | 0.3614 | 2891840.0 |
| 2003-08-14 09:35:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3609 | 0.3614 | 1056776.0 |
| 2003-08-14 09:40:00 | AAPL | Stock | 0.3616 | 0.362 | 0.3613 | 0.3618 | 2119320.0 |
| 2003-08-14 09:45:00 | AAPL | Stock | 0.3618 | 0.363 | 0.3593 | 0.3604 | 2962400.0 |
| 2003-08-14 09:50:00 | AAPL | Stock | 0.36 | 0.3609 | 0.3598 | 0.3598 | 2172800.0 |
| 2003-08-14 09:55:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3568 | 0.3595 | 2317952.0 |
| 2003-08-14 10:00:00 | AAPL | Stock | 0.3595 | 0.3614 | 0.3589 | 0.3595 | 1984528.0 |
| 2003-08-14 10:05:00 | AAPL | Stock | 0.3593 | 0.3602 | 0.3591 | 0.3598 | 2402400.0 |
| 2003-08-14 10:10:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3577 | 0.3577 | 3516632.0 |
| 2003-08-14 10:15:00 | AAPL | Stock | 0.3577 | 0.3591 | 0.3573 | 0.3589 | 2063600.0 |
| 2003-08-14 10:20:00 | AAPL | Stock | 0.3589 | 0.3595 | 0.358 | 0.3582 | 2149112.0 |
| 2003-08-14 10:25:00 | AAPL | Stock | 0.3582 | 0.3589 | 0.358 | 0.3589 | 2565752.0 |
| 2003-08-14 10:30:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.358 | 0.3582 | 1024800.0 |
| 2003-08-14 10:35:00 | AAPL | Stock | 0.358 | 0.358 | 0.3573 | 0.3575 | 2315600.0 |
| 2003-08-14 10:40:00 | AAPL | Stock | 0.3575 | 0.3579 | 0.3573 | 0.3573 | 3147200.0 |
| 2003-08-14 10:45:00 | AAPL | Stock | 0.3577 | 0.3579 | 0.3573 | 0.3577 | 1103648.0 |
| 2003-08-14 10:50:00 | AAPL | Stock | 0.3577 | 0.3577 | 0.3573 | 0.3575 | 1445248.0 |
| 2003-08-14 10:55:00 | AAPL | Stock | 0.3575 | 0.3577 | 0.3573 | 0.3575 | 532000.0 |
| 2003-08-14 11:00:00 | AAPL | Stock | 0.3575 | 0.3577 | 0.3573 | 0.3575 | 677600.0 |
| 2003-08-14 11:05:00 | AAPL | Stock | 0.3575 | 0.3582 | 0.3573 | 0.3575 | 1966496.0 |
| 2003-08-14 11:10:00 | AAPL | Stock | 0.3573 | 0.358 | 0.3571 | 0.3577 | 1583008.0 |
| 2003-08-14 11:15:00 | AAPL | Stock | 0.3579 | 0.3589 | 0.3575 | 0.3589 | 1097600.0 |
| 2003-08-14 11:20:00 | AAPL | Stock | 0.3589 | 0.3593 | 0.3588 | 0.3589 | 1770104.0 |
| 2003-08-14 11:25:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3588 | 0.3588 | 1190728.0 |
| 2003-08-14 11:30:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.358 | 0.358 | 1864800.0 |
| 2003-08-14 11:35:00 | AAPL | Stock | 0.3582 | 0.3588 | 0.3581 | 0.3584 | 414400.0 |
| 2003-08-14 11:40:00 | AAPL | Stock | 0.3584 | 0.3584 | 0.3582 | 0.3582 | 357840.0 |
| 2003-08-14 11:45:00 | AAPL | Stock | 0.3584 | 0.3586 | 0.358 | 0.3584 | 753592.0 |
| 2003-08-14 11:50:00 | AAPL | Stock | 0.3586 | 0.3588 | 0.3586 | 0.3586 | 1041600.0 |
| 2003-08-14 11:55:00 | AAPL | Stock | 0.3586 | 0.3593 | 0.3582 | 0.3589 | 3219384.0 |
| 2003-08-14 12:00:00 | AAPL | Stock | 0.3589 | 0.3595 | 0.3588 | 0.3588 | 998256.0 |
| 2003-08-14 12:05:00 | AAPL | Stock | 0.3589 | 0.3607 | 0.3586 | 0.36 | 4060448.0 |
| 2003-08-14 12:10:00 | AAPL | Stock | 0.36 | 0.3607 | 0.36 | 0.3604 | 2153592.0 |
| 2003-08-14 12:15:00 | AAPL | Stock | 0.3605 | 0.3614 | 0.3604 | 0.3613 | 1160376.0 |
| 2003-08-14 12:20:00 | AAPL | Stock | 0.3611 | 0.3613 | 0.3602 | 0.3602 | 2428440.0 |
| 2003-08-14 12:25:00 | AAPL | Stock | 0.36 | 0.36 | 0.3591 | 0.3591 | 688800.0 |
| 2003-08-14 12:30:00 | AAPL | Stock | 0.3593 | 0.3598 | 0.3591 | 0.3597 | 560000.0 |
| 2003-08-14 12:35:00 | AAPL | Stock | 0.3598 | 0.3598 | 0.3588 | 0.3589 | 1335264.0 |
| 2003-08-14 12:40:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3582 | 0.3586 | 1859200.0 |
| 2003-08-14 12:45:00 | AAPL | Stock | 0.3586 | 0.3589 | 0.3582 | 0.3588 | 2487688.0 |
| 2003-08-14 12:50:00 | AAPL | Stock | 0.3591 | 0.3591 | 0.3582 | 0.3584 | 711200.0 |
| 2003-08-14 12:55:00 | AAPL | Stock | 0.3588 | 0.3591 | 0.3584 | 0.3591 | 89600.0 |
| 2003-08-14 13:00:00 | AAPL | Stock | 0.3588 | 0.3595 | 0.3588 | 0.3595 | 700000.0 |
| 2003-08-14 13:05:00 | AAPL | Stock | 0.3594 | 0.3595 | 0.3593 | 0.3593 | 380800.0 |
| 2003-08-14 13:10:00 | AAPL | Stock | 0.3593 | 0.3593 | 0.3591 | 0.3593 | 67200.0 |
| 2003-08-14 13:15:00 | AAPL | Stock | 0.3591 | 0.3591 | 0.3586 | 0.3586 | 683200.0 |
| 2003-08-14 13:20:00 | AAPL | Stock | 0.3584 | 0.3588 | 0.3584 | 0.3586 | 249648.0 |
| 2003-08-14 13:25:00 | AAPL | Stock | 0.3586 | 0.3588 | 0.3585 | 0.3588 | 267176.0 |
| 2003-08-14 13:30:00 | AAPL | Stock | 0.3586 | 0.3593 | 0.3586 | 0.3591 | 386400.0 |
> showing 50 of 142,004 rows — these rows as CSV