PREVIEW / stock_30min / 2005-07-08
file: by_date/stock_30min/2005/2005-07-08.parquet size: 829 KB rows: 44,624 symbols: 2,025
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-08 08:00:00 | AAPL | Stock | 1.35 | 1.3546 | 1.35 | 1.3546 | 149940.0 |
| 2005-07-08 08:30:00 | AAPL | Stock | 1.3518 | 1.355 | 1.345 | 1.3525 | 821240.0 |
| 2005-07-08 09:00:00 | AAPL | Stock | 1.3525 | 1.3543 | 1.3479 | 1.3521 | 1026900.0 |
| 2005-07-08 09:30:00 | AAPL | Stock | 1.3525 | 1.3539 | 1.3432 | 1.3464 | 40234600.0 |
| 2005-07-08 10:00:00 | AAPL | Stock | 1.3468 | 1.3475 | 1.3382 | 1.3443 | 28511812.0 |
| 2005-07-08 10:30:00 | AAPL | Stock | 1.3439 | 1.3461 | 1.34 | 1.3432 | 18201736.0 |
| 2005-07-08 11:00:00 | AAPL | Stock | 1.3436 | 1.3436 | 1.3393 | 1.3407 | 15986908.0 |
| 2005-07-08 11:30:00 | AAPL | Stock | 1.3407 | 1.3436 | 1.3407 | 1.3418 | 8888264.0 |
| 2005-07-08 12:00:00 | AAPL | Stock | 1.3418 | 1.3521 | 1.3414 | 1.3521 | 18919236.0 |
| 2005-07-08 12:30:00 | AAPL | Stock | 1.3521 | 1.3557 | 1.3511 | 1.3521 | 16885428.0 |
| 2005-07-08 13:00:00 | AAPL | Stock | 1.3521 | 1.3543 | 1.3489 | 1.3507 | 10871112.0 |
| 2005-07-08 13:30:00 | AAPL | Stock | 1.3504 | 1.3546 | 1.3475 | 1.3539 | 10618356.0 |
| 2005-07-08 14:00:00 | AAPL | Stock | 1.3539 | 1.3604 | 1.3532 | 1.3596 | 23663668.0 |
| 2005-07-08 14:30:00 | AAPL | Stock | 1.3596 | 1.3636 | 1.3593 | 1.3611 | 15310708.0 |
| 2005-07-08 15:00:00 | AAPL | Stock | 1.3611 | 1.3668 | 1.3604 | 1.3654 | 33494776.0 |
| 2005-07-08 15:30:00 | AAPL | Stock | 1.3657 | 1.3671 | 1.3589 | 1.3661 | 39067336.0 |
| 2005-07-08 16:00:00 | AAPL | Stock | 1.3654 | 1.3714 | 1.3618 | 1.3682 | 3393712.0 |
| 2005-07-08 16:30:00 | AAPL | Stock | 1.3679 | 1.3704 | 1.3679 | 1.3704 | 51240.0 |
| 2005-07-08 17:00:00 | AAPL | Stock | 1.3679 | 1.3679 | 1.3664 | 1.3671 | 96880.0 |
| 2005-07-08 17:30:00 | AAPL | Stock | 1.3686 | 1.3686 | 1.3686 | 1.3686 | 5600.0 |
| 2005-07-08 18:00:00 | AAPL | Stock | 1.3679 | 1.3679 | 1.3679 | 1.3679 | 28000.0 |
| 2005-07-08 08:00:00 | MSFT | Stock | 24.74 | 24.74 | 24.73 | 24.73 | 7907.0 |
| 2005-07-08 08:30:00 | MSFT | Stock | 24.73 | 24.73 | 24.68 | 24.7 | 31228.0 |
| 2005-07-08 09:00:00 | MSFT | Stock | 24.71 | 24.73 | 24.61 | 24.64 | 129261.0 |
| 2005-07-08 09:30:00 | MSFT | Stock | 24.64 | 24.69 | 24.63 | 24.68 | 5123513.0 |
| 2005-07-08 10:00:00 | MSFT | Stock | 24.682 | 24.75 | 24.66 | 24.7 | 3502979.0 |
| 2005-07-08 10:30:00 | MSFT | Stock | 24.7 | 24.75 | 24.69 | 24.72 | 2915302.0 |
| 2005-07-08 11:00:00 | MSFT | Stock | 24.72 | 24.73 | 24.66 | 24.68 | 3192628.0 |
| 2005-07-08 11:30:00 | MSFT | Stock | 24.68 | 24.74 | 24.68 | 24.72 | 2698412.0 |
| 2005-07-08 12:00:00 | MSFT | Stock | 24.72 | 24.82 | 24.71 | 24.82 | 4198003.0 |
| 2005-07-08 12:30:00 | MSFT | Stock | 24.82 | 24.91 | 24.812 | 24.86 | 4047913.0 |
| 2005-07-08 13:00:00 | MSFT | Stock | 24.86 | 24.89 | 24.85 | 24.89 | 1829273.0 |
| 2005-07-08 13:30:00 | MSFT | Stock | 24.88 | 24.92 | 24.82 | 24.89 | 3755884.0 |
| 2005-07-08 14:00:00 | MSFT | Stock | 24.9 | 25.05 | 24.88 | 25.01 | 5344451.0 |
| 2005-07-08 14:30:00 | MSFT | Stock | 25.01 | 25.05 | 24.98 | 25.02 | 3692698.0 |
| 2005-07-08 15:00:00 | MSFT | Stock | 25.02 | 25.12 | 25.01 | 25.11 | 3907051.0 |
| 2005-07-08 15:30:00 | MSFT | Stock | 25.112 | 25.121 | 25.045 | 25.08 | 7008518.0 |
| 2005-07-08 16:00:00 | MSFT | Stock | 25.09 | 25.17 | 24.847 | 25.08 | 2490143.0 |
| 2005-07-08 16:30:00 | MSFT | Stock | 25.07 | 25.1 | 25.07 | 25.1 | 10487.0 |
| 2005-07-08 17:00:00 | MSFT | Stock | 25.09 | 25.09 | 25.09 | 25.09 | 2026.0 |
| 2005-07-08 17:30:00 | MSFT | Stock | 25.09 | 25.09 | 25.09 | 25.09 | 3100.0 |
| 2005-07-08 18:00:00 | MSFT | Stock | 25.08 | 25.08 | 25.08 | 25.08 | 300.0 |
| 2005-07-08 08:00:00 | NVDA | Stock | 0.2333 | 0.2344 | 0.2333 | 0.2344 | 129000.0 |
| 2005-07-08 08:30:00 | NVDA | Stock | 0.2337 | 0.2339 | 0.2337 | 0.2338 | 120000.0 |
| 2005-07-08 09:00:00 | NVDA | Stock | 0.2337 | 0.2337 | 0.2317 | 0.2324 | 651000.0 |
| 2005-07-08 09:30:00 | NVDA | Stock | 0.233 | 0.2332 | 0.23 | 0.2301 | 44460120.0 |
| 2005-07-08 10:00:00 | NVDA | Stock | 0.2301 | 0.2311 | 0.23 | 0.2302 | 20827440.0 |
| 2005-07-08 10:30:00 | NVDA | Stock | 0.2302 | 0.2317 | 0.23 | 0.2315 | 33221400.0 |
| 2005-07-08 11:00:00 | NVDA | Stock | 0.2316 | 0.2328 | 0.2308 | 0.2326 | 27501600.0 |
| 2005-07-08 11:30:00 | NVDA | Stock | 0.2327 | 0.2335 | 0.2324 | 0.2329 | 35836200.0 |
> showing 50 of 44,624 rows — these rows as CSV