PREVIEW / stock_30min / 2005-07-13
file: by_date/stock_30min/2005/2005-07-13.parquet size: 807 KB rows: 43,745 symbols: 2,030
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-13 07:30:00 | AAPL | Stock | 1.375 | 1.375 | 1.3643 | 1.3646 | 393400.0 |
| 2005-07-13 08:00:00 | AAPL | Stock | 1.3611 | 1.3732 | 1.3607 | 1.3729 | 393960.0 |
| 2005-07-13 08:30:00 | AAPL | Stock | 1.3686 | 1.3696 | 1.3643 | 1.3668 | 418824.0 |
| 2005-07-13 09:00:00 | AAPL | Stock | 1.3671 | 1.3679 | 1.3518 | 1.3657 | 2321704.0 |
| 2005-07-13 09:30:00 | AAPL | Stock | 1.3675 | 1.3729 | 1.3621 | 1.3682 | 73370724.0 |
| 2005-07-13 10:00:00 | AAPL | Stock | 1.3686 | 1.3707 | 1.3536 | 1.3564 | 70649628.0 |
| 2005-07-13 10:30:00 | AAPL | Stock | 1.3564 | 1.36 | 1.3543 | 1.3582 | 50846768.0 |
| 2005-07-13 11:00:00 | AAPL | Stock | 1.3586 | 1.3671 | 1.3582 | 1.3661 | 42947492.0 |
| 2005-07-13 11:30:00 | AAPL | Stock | 1.3661 | 1.3671 | 1.3593 | 1.36 | 24318896.0 |
| 2005-07-13 12:00:00 | AAPL | Stock | 1.36 | 1.365 | 1.3579 | 1.3643 | 24743040.0 |
| 2005-07-13 12:30:00 | AAPL | Stock | 1.3646 | 1.365 | 1.3607 | 1.3636 | 22551676.0 |
| 2005-07-13 13:00:00 | AAPL | Stock | 1.3636 | 1.3636 | 1.3607 | 1.3611 | 12919676.0 |
| 2005-07-13 13:30:00 | AAPL | Stock | 1.3611 | 1.3643 | 1.36 | 1.3639 | 25572428.0 |
| 2005-07-13 14:00:00 | AAPL | Stock | 1.3639 | 1.3664 | 1.3611 | 1.3639 | 22191596.0 |
| 2005-07-13 14:30:00 | AAPL | Stock | 1.3639 | 1.3693 | 1.3625 | 1.3685 | 41100892.0 |
| 2005-07-13 15:00:00 | AAPL | Stock | 1.3686 | 1.3729 | 1.3664 | 1.3714 | 57733284.0 |
| 2005-07-13 15:30:00 | AAPL | Stock | 1.3714 | 1.375 | 1.3668 | 1.3718 | 92356516.0 |
| 2005-07-13 16:00:00 | AAPL | Stock | 1.37 | 1.3929 | 1.3529 | 1.3889 | 13572776.0 |
| 2005-07-13 16:30:00 | AAPL | Stock | 1.3857 | 1.4036 | 1.3504 | 1.3982 | 123272744.0 |
| 2005-07-13 17:00:00 | AAPL | Stock | 1.3979 | 1.4143 | 1.3896 | 1.4079 | 49578452.0 |
| 2005-07-13 17:30:00 | AAPL | Stock | 1.4079 | 1.4121 | 1.4018 | 1.4107 | 21712572.0 |
| 2005-07-13 18:00:00 | AAPL | Stock | 1.4107 | 1.4196 | 1.4082 | 1.4182 | 8653428.0 |
| 2005-07-13 08:00:00 | MSFT | Stock | 25.63 | 25.63 | 25.61 | 25.61 | 11175.0 |
| 2005-07-13 08:30:00 | MSFT | Stock | 25.6 | 25.62 | 25.57 | 25.62 | 7953.0 |
| 2005-07-13 09:00:00 | MSFT | Stock | 25.61 | 25.61 | 25.48 | 25.49 | 136520.0 |
| 2005-07-13 09:30:00 | MSFT | Stock | 25.53 | 25.7 | 25.48 | 25.62 | 5661890.0 |
| 2005-07-13 10:00:00 | MSFT | Stock | 25.62 | 25.65 | 25.53 | 25.58 | 3104665.0 |
| 2005-07-13 10:30:00 | MSFT | Stock | 25.58 | 25.67 | 25.57 | 25.58 | 4034416.0 |
| 2005-07-13 11:00:00 | MSFT | Stock | 25.58 | 25.67 | 25.57 | 25.67 | 3796483.0 |
| 2005-07-13 11:30:00 | MSFT | Stock | 25.67 | 25.69 | 25.65 | 25.66 | 1798995.0 |
| 2005-07-13 12:00:00 | MSFT | Stock | 25.66 | 25.69 | 25.57 | 25.59 | 5322050.0 |
| 2005-07-13 12:30:00 | MSFT | Stock | 25.59 | 25.61 | 25.51 | 25.528 | 2037078.0 |
| 2005-07-13 13:00:00 | MSFT | Stock | 25.522 | 25.595 | 25.51 | 25.56 | 1145579.0 |
| 2005-07-13 13:30:00 | MSFT | Stock | 25.55 | 25.56 | 25.509 | 25.54 | 1852321.0 |
| 2005-07-13 14:00:00 | MSFT | Stock | 25.54 | 25.59 | 25.53 | 25.558 | 2367435.0 |
| 2005-07-13 14:30:00 | MSFT | Stock | 25.55 | 25.62 | 25.55 | 25.61 | 2418149.0 |
| 2005-07-13 15:00:00 | MSFT | Stock | 25.6 | 25.71 | 25.59 | 25.68 | 4041455.0 |
| 2005-07-13 15:30:00 | MSFT | Stock | 25.67 | 25.75 | 25.612 | 25.65 | 5920318.0 |
| 2005-07-13 16:00:00 | MSFT | Stock | 25.67 | 25.68 | 25.26 | 25.67 | 280694.0 |
| 2005-07-13 16:30:00 | MSFT | Stock | 25.66 | 25.68 | 25.66 | 25.68 | 94127.0 |
| 2005-07-13 17:00:00 | MSFT | Stock | 25.66 | 25.69 | 25.66 | 25.69 | 177446.0 |
| 2005-07-13 17:30:00 | MSFT | Stock | 25.67 | 25.67 | 25.66 | 25.66 | 500.0 |
| 2005-07-13 18:00:00 | MSFT | Stock | 25.69 | 25.69 | 25.65 | 25.65 | 5170.0 |
| 2005-07-13 08:00:00 | NVDA | Stock | 0.2304 | 0.2396 | 0.2304 | 0.2395 | 312000.0 |
| 2005-07-13 09:00:00 | NVDA | Stock | 0.2387 | 0.2387 | 0.2377 | 0.2382 | 1626120.0 |
| 2005-07-13 09:30:00 | NVDA | Stock | 0.2377 | 0.2383 | 0.2357 | 0.236 | 76666080.0 |
| 2005-07-13 10:00:00 | NVDA | Stock | 0.236 | 0.2363 | 0.2351 | 0.2355 | 88671480.0 |
| 2005-07-13 10:30:00 | NVDA | Stock | 0.2355 | 0.2365 | 0.2337 | 0.234 | 52222920.0 |
| 2005-07-13 11:00:00 | NVDA | Stock | 0.2341 | 0.2348 | 0.233 | 0.2347 | 60204600.0 |
| 2005-07-13 11:30:00 | NVDA | Stock | 0.2346 | 0.2358 | 0.2342 | 0.2356 | 31383480.0 |
> showing 50 of 43,745 rows — these rows as CSV