PREVIEW / stock_30min / 2005-06-21
file: by_date/stock_30min/2005/2005-06-21.parquet size: 810 KB rows: 44,447 symbols: 1,997
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-06-21 07:30:00 | AAPL | Stock | 1.3432 | 1.3432 | 1.3382 | 1.3382 | 44800.0 |
| 2005-06-21 08:00:00 | AAPL | Stock | 1.3304 | 1.3425 | 1.3304 | 1.3421 | 150248.0 |
| 2005-06-21 08:30:00 | AAPL | Stock | 1.3418 | 1.3454 | 1.3418 | 1.3429 | 115164.0 |
| 2005-06-21 09:00:00 | AAPL | Stock | 1.3429 | 1.3443 | 1.3411 | 1.3443 | 332248.0 |
| 2005-06-21 09:30:00 | AAPL | Stock | 1.3471 | 1.3536 | 1.3361 | 1.3382 | 71947456.0 |
| 2005-06-21 10:00:00 | AAPL | Stock | 1.3379 | 1.3518 | 1.335 | 1.3489 | 41918828.0 |
| 2005-06-21 10:30:00 | AAPL | Stock | 1.3489 | 1.3536 | 1.3404 | 1.3514 | 32756584.0 |
| 2005-06-21 11:00:00 | AAPL | Stock | 1.3514 | 1.3521 | 1.3475 | 1.3489 | 22331456.0 |
| 2005-06-21 11:30:00 | AAPL | Stock | 1.3489 | 1.3518 | 1.3457 | 1.3496 | 9235128.0 |
| 2005-06-21 12:00:00 | AAPL | Stock | 1.35 | 1.3532 | 1.3493 | 1.3525 | 8146096.0 |
| 2005-06-21 12:30:00 | AAPL | Stock | 1.3521 | 1.3532 | 1.3493 | 1.3507 | 8990464.0 |
| 2005-06-21 13:00:00 | AAPL | Stock | 1.3507 | 1.3536 | 1.3489 | 1.3525 | 15310064.0 |
| 2005-06-21 13:30:00 | AAPL | Stock | 1.3521 | 1.3575 | 1.3521 | 1.3557 | 13351100.0 |
| 2005-06-21 14:00:00 | AAPL | Stock | 1.3557 | 1.3593 | 1.3546 | 1.3561 | 18297328.0 |
| 2005-06-21 14:30:00 | AAPL | Stock | 1.3557 | 1.3639 | 1.3536 | 1.3611 | 33371156.0 |
| 2005-06-21 15:00:00 | AAPL | Stock | 1.3611 | 1.3621 | 1.3446 | 1.3468 | 49393204.0 |
| 2005-06-21 15:30:00 | AAPL | Stock | 1.3471 | 1.3539 | 1.3461 | 1.3521 | 34190632.0 |
| 2005-06-21 16:00:00 | AAPL | Stock | 1.352 | 1.3525 | 1.3497 | 1.3525 | 2520616.0 |
| 2005-06-21 16:30:00 | AAPL | Stock | 1.3525 | 1.3529 | 1.3525 | 1.3529 | 66220.0 |
| 2005-06-21 17:00:00 | AAPL | Stock | 1.3521 | 1.3525 | 1.3521 | 1.3521 | 50400.0 |
| 2005-06-21 17:30:00 | AAPL | Stock | 1.3529 | 1.3554 | 1.3504 | 1.3536 | 198800.0 |
| 2005-06-21 18:00:00 | AAPL | Stock | 1.3504 | 1.3514 | 1.3489 | 1.3514 | 123200.0 |
| 2005-06-21 08:00:00 | MSFT | Stock | 25.11 | 25.12 | 25.1 | 25.12 | 1140.0 |
| 2005-06-21 08:30:00 | MSFT | Stock | 25.12 | 25.12 | 25.1 | 25.1 | 2479.0 |
| 2005-06-21 09:00:00 | MSFT | Stock | 25.1 | 25.12 | 25.07 | 25.08 | 129558.0 |
| 2005-06-21 09:30:00 | MSFT | Stock | 25.08 | 25.15 | 25.05 | 25.07 | 5064791.0 |
| 2005-06-21 10:00:00 | MSFT | Stock | 25.07 | 25.1 | 25.04 | 25.1 | 5693021.0 |
| 2005-06-21 10:30:00 | MSFT | Stock | 25.1 | 25.14 | 25.05 | 25.07 | 4196462.0 |
| 2005-06-21 11:00:00 | MSFT | Stock | 25.06 | 25.1 | 25.05 | 25.06 | 4451644.0 |
| 2005-06-21 11:30:00 | MSFT | Stock | 25.06 | 25.09 | 25.05 | 25.09 | 3968436.0 |
| 2005-06-21 12:00:00 | MSFT | Stock | 25.081 | 25.19 | 25.05 | 25.16 | 12165389.0 |
| 2005-06-21 12:30:00 | MSFT | Stock | 25.16 | 25.19 | 25.13 | 25.15 | 5986528.0 |
| 2005-06-21 13:00:00 | MSFT | Stock | 25.14 | 25.16 | 25.08 | 25.15 | 2876827.0 |
| 2005-06-21 13:30:00 | MSFT | Stock | 25.15 | 25.19 | 25.12 | 25.12 | 3578402.0 |
| 2005-06-21 14:00:00 | MSFT | Stock | 25.125 | 25.15 | 25.11 | 25.13 | 2728266.0 |
| 2005-06-21 14:30:00 | MSFT | Stock | 25.14 | 25.15 | 25.1 | 25.14 | 5059122.0 |
| 2005-06-21 15:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.07 | 25.1 | 7693304.0 |
| 2005-06-21 15:30:00 | MSFT | Stock | 25.11 | 25.17 | 25.09 | 25.1 | 8075054.0 |
| 2005-06-21 16:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.04 | 25.09 | 499917.0 |
| 2005-06-21 16:30:00 | MSFT | Stock | 25.1 | 25.11 | 25.081 | 25.11 | 15514.0 |
| 2005-06-21 17:00:00 | MSFT | Stock | 25.09 | 25.09 | 25.09 | 25.09 | 200.0 |
| 2005-06-21 17:30:00 | MSFT | Stock | 25.1 | 25.15 | 25.1 | 25.11 | 7161.0 |
| 2005-06-21 18:00:00 | MSFT | Stock | 25.11 | 25.11 | 25.1 | 25.11 | 13400.0 |
| 2005-06-21 08:30:00 | NVDA | Stock | 0.228 | 0.228 | 0.228 | 0.228 | 24000.0 |
| 2005-06-21 09:00:00 | NVDA | Stock | 0.2302 | 0.2302 | 0.2287 | 0.2292 | 176400.0 |
| 2005-06-21 09:30:00 | NVDA | Stock | 0.2292 | 0.2304 | 0.227 | 0.228 | 77036640.0 |
| 2005-06-21 10:00:00 | NVDA | Stock | 0.2279 | 0.2298 | 0.2276 | 0.2292 | 31190520.0 |
| 2005-06-21 10:30:00 | NVDA | Stock | 0.2292 | 0.2297 | 0.228 | 0.2285 | 25596240.0 |
| 2005-06-21 11:00:00 | NVDA | Stock | 0.2285 | 0.2287 | 0.2276 | 0.2277 | 19727400.0 |
| 2005-06-21 11:30:00 | NVDA | Stock | 0.2277 | 0.2277 | 0.2272 | 0.2275 | 17385480.0 |
> showing 50 of 44,447 rows — these rows as CSV