PREVIEW / stock_30min / 2006-06-20
file: by_date/stock_30min/2006/2006-06-20.parquet size: 900 KB rows: 49,407 symbols: 2,281
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-20 07:00:00 | AAPL | Stock | 2.0482 | 2.0482 | 2.0482 | 2.0482 | 16800.0 |
| 2006-06-20 07:30:00 | AAPL | Stock | 2.05 | 2.0511 | 2.0464 | 2.0464 | 47600.0 |
| 2006-06-20 08:00:00 | AAPL | Stock | 2.0468 | 2.0532 | 2.0443 | 2.0493 | 688436.0 |
| 2006-06-20 08:30:00 | AAPL | Stock | 2.0496 | 2.0596 | 2.0468 | 2.0571 | 1467984.0 |
| 2006-06-20 09:00:00 | AAPL | Stock | 2.0554 | 2.0632 | 2.0518 | 2.0575 | 1464372.0 |
| 2006-06-20 09:30:00 | AAPL | Stock | 2.0575 | 2.0721 | 2.0461 | 2.0543 | 95372368.0 |
| 2006-06-20 10:00:00 | AAPL | Stock | 2.0546 | 2.06 | 2.0464 | 2.0486 | 58903068.0 |
| 2006-06-20 10:30:00 | AAPL | Stock | 2.0482 | 2.0639 | 2.0479 | 2.0539 | 40934096.0 |
| 2006-06-20 11:00:00 | AAPL | Stock | 2.0539 | 2.0768 | 2.0529 | 2.0764 | 86780764.0 |
| 2006-06-20 11:30:00 | AAPL | Stock | 2.0761 | 2.0839 | 2.0721 | 2.0787 | 72216620.0 |
| 2006-06-20 12:00:00 | AAPL | Stock | 2.0789 | 2.0804 | 2.07 | 2.0704 | 39177068.0 |
| 2006-06-20 12:30:00 | AAPL | Stock | 2.0704 | 2.0736 | 2.0646 | 2.065 | 30114280.0 |
| 2006-06-20 13:00:00 | AAPL | Stock | 2.065 | 2.0668 | 2.0596 | 2.0614 | 25275012.0 |
| 2006-06-20 13:30:00 | AAPL | Stock | 2.0618 | 2.0686 | 2.0536 | 2.0586 | 43437156.0 |
| 2006-06-20 14:00:00 | AAPL | Stock | 2.0582 | 2.0621 | 2.0507 | 2.0568 | 36822128.0 |
| 2006-06-20 14:30:00 | AAPL | Stock | 2.0568 | 2.0657 | 2.0564 | 2.0636 | 35807744.0 |
| 2006-06-20 15:00:00 | AAPL | Stock | 2.0636 | 2.065 | 2.055 | 2.0614 | 29712956.0 |
| 2006-06-20 15:30:00 | AAPL | Stock | 2.0611 | 2.0629 | 2.0479 | 2.0521 | 65401952.0 |
| 2006-06-20 16:00:00 | AAPL | Stock | 2.0536 | 2.0546 | 2.05 | 2.0536 | 827988.0 |
| 2006-06-20 16:30:00 | AAPL | Stock | 2.0532 | 2.0564 | 2.0529 | 2.055 | 452704.0 |
| 2006-06-20 17:00:00 | AAPL | Stock | 2.0543 | 2.0546 | 2.0543 | 2.0546 | 34300.0 |
| 2006-06-20 17:30:00 | AAPL | Stock | 2.0546 | 2.0546 | 2.0518 | 2.0518 | 536088.0 |
| 2006-06-20 18:00:00 | AAPL | Stock | 2.0536 | 2.0546 | 2.0504 | 2.0504 | 49504.0 |
| 2006-06-20 08:00:00 | MSFT | Stock | 22.53 | 22.53 | 22.52 | 22.52 | 1200.0 |
| 2006-06-20 08:30:00 | MSFT | Stock | 22.54 | 22.55 | 22.54 | 22.54 | 6200.0 |
| 2006-06-20 09:00:00 | MSFT | Stock | 22.54 | 22.64 | 22.54 | 22.54 | 170785.0 |
| 2006-06-20 09:30:00 | MSFT | Stock | 22.54 | 22.76 | 22.53 | 22.65 | 12288602.0 |
| 2006-06-20 10:00:00 | MSFT | Stock | 22.64 | 22.66 | 22.51 | 22.53 | 10383405.0 |
| 2006-06-20 10:30:00 | MSFT | Stock | 22.53 | 22.66 | 22.53 | 22.6 | 5614695.0 |
| 2006-06-20 11:00:00 | MSFT | Stock | 22.61 | 22.7 | 22.55 | 22.67 | 7673493.0 |
| 2006-06-20 11:30:00 | MSFT | Stock | 22.663 | 22.74 | 22.6 | 22.65 | 6845420.0 |
| 2006-06-20 12:00:00 | MSFT | Stock | 22.65 | 22.69 | 22.62 | 22.65 | 3319664.0 |
| 2006-06-20 12:30:00 | MSFT | Stock | 22.65 | 22.7 | 22.62 | 22.68 | 3815148.0 |
| 2006-06-20 13:00:00 | MSFT | Stock | 22.69 | 22.69 | 22.63 | 22.66 | 2148626.0 |
| 2006-06-20 13:30:00 | MSFT | Stock | 22.66 | 22.67 | 22.6 | 22.603 | 3813097.0 |
| 2006-06-20 14:00:00 | MSFT | Stock | 22.6 | 22.65 | 22.58 | 22.64 | 6929094.0 |
| 2006-06-20 14:30:00 | MSFT | Stock | 22.64 | 22.68 | 22.6 | 22.65 | 4518253.0 |
| 2006-06-20 15:00:00 | MSFT | Stock | 22.64 | 22.68 | 22.62 | 22.64 | 5660538.0 |
| 2006-06-20 15:30:00 | MSFT | Stock | 22.64 | 22.67 | 22.5 | 22.58 | 12633646.0 |
| 2006-06-20 16:00:00 | MSFT | Stock | 22.57 | 22.65 | 22.55 | 22.63 | 263059.0 |
| 2006-06-20 16:30:00 | MSFT | Stock | 22.63 | 22.64 | 22.61 | 22.64 | 14698.0 |
| 2006-06-20 17:00:00 | MSFT | Stock | 22.63 | 22.65 | 22.63 | 22.65 | 6200.0 |
| 2006-06-20 17:30:00 | MSFT | Stock | 22.56 | 22.63 | 22.56 | 22.63 | 41254.0 |
| 2006-06-20 18:00:00 | MSFT | Stock | 22.63 | 22.63 | 22.6 | 22.6 | 5012.0 |
| 2006-06-20 08:00:00 | NVDA | Stock | 0.346 | 0.3467 | 0.3408 | 0.3412 | 584100.0 |
| 2006-06-20 08:30:00 | NVDA | Stock | 0.3408 | 0.3433 | 0.336 | 0.3427 | 885000.0 |
| 2006-06-20 09:00:00 | NVDA | Stock | 0.3427 | 0.344 | 0.3408 | 0.3417 | 1596360.0 |
| 2006-06-20 09:30:00 | NVDA | Stock | 0.3405 | 0.3458 | 0.3392 | 0.3407 | 66489480.0 |
| 2006-06-20 10:00:00 | NVDA | Stock | 0.3407 | 0.3423 | 0.34 | 0.342 | 36085920.0 |
| 2006-06-20 10:30:00 | NVDA | Stock | 0.342 | 0.3445 | 0.3412 | 0.3443 | 29323080.0 |
> showing 50 of 49,407 rows — these rows as CSV