PREVIEW / stock_30min / 2009-11-18
file: by_date/stock_30min/2009/2009-11-18.parquet size: 1.3 MB rows: 73,059 symbols: 3,430
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-18 04:00:00 | AAPL | Stock | 7.3964 | 7.4 | 7.3964 | 7.4 | 5600.0 |
| 2009-11-18 06:00:00 | AAPL | Stock | 7.4618 | 7.4618 | 7.4536 | 7.4536 | 14224.0 |
| 2009-11-18 06:30:00 | AAPL | Stock | 7.4414 | 7.4414 | 7.4411 | 7.4411 | 9800.0 |
| 2009-11-18 07:00:00 | AAPL | Stock | 7.4382 | 7.4382 | 7.4236 | 7.4286 | 128632.0 |
| 2009-11-18 07:30:00 | AAPL | Stock | 7.4286 | 7.4318 | 7.4232 | 7.425 | 273840.0 |
| 2009-11-18 08:00:00 | AAPL | Stock | 7.4232 | 7.4239 | 7.3929 | 7.4018 | 1128820.0 |
| 2009-11-18 08:30:00 | AAPL | Stock | 7.4018 | 7.4018 | 7.3786 | 7.39 | 994420.0 |
| 2009-11-18 09:00:00 | AAPL | Stock | 7.3843 | 7.3904 | 7.3693 | 7.3725 | 825916.0 |
| 2009-11-18 09:30:00 | AAPL | Stock | 7.3764 | 7.3929 | 7.3511 | 7.3596 | 51488696.0 |
| 2009-11-18 10:00:00 | AAPL | Stock | 7.3596 | 7.3689 | 7.3375 | 7.3645 | 34064520.0 |
| 2009-11-18 10:30:00 | AAPL | Stock | 7.3654 | 7.3821 | 7.3593 | 7.3775 | 24589068.0 |
| 2009-11-18 11:00:00 | AAPL | Stock | 7.3771 | 7.3832 | 7.3571 | 7.3611 | 15941632.0 |
| 2009-11-18 11:30:00 | AAPL | Stock | 7.3611 | 7.3675 | 7.3432 | 7.3607 | 15412600.0 |
| 2009-11-18 12:00:00 | AAPL | Stock | 7.3596 | 7.3639 | 7.3254 | 7.3357 | 35700028.0 |
| 2009-11-18 12:30:00 | AAPL | Stock | 7.3357 | 7.3525 | 7.3225 | 7.3232 | 21373044.0 |
| 2009-11-18 13:00:00 | AAPL | Stock | 7.3239 | 7.325 | 7.2857 | 7.2986 | 37951508.0 |
| 2009-11-18 13:30:00 | AAPL | Stock | 7.2986 | 7.3175 | 7.2975 | 7.3104 | 16242268.0 |
| 2009-11-18 14:00:00 | AAPL | Stock | 7.31 | 7.3471 | 7.3079 | 7.3325 | 23285612.0 |
| 2009-11-18 14:30:00 | AAPL | Stock | 7.3321 | 7.3357 | 7.3057 | 7.3082 | 23694804.0 |
| 2009-11-18 15:00:00 | AAPL | Stock | 7.3089 | 7.3411 | 7.3086 | 7.3357 | 19132764.0 |
| 2009-11-18 15:30:00 | AAPL | Stock | 7.3364 | 7.3557 | 7.3236 | 7.3557 | 33987744.0 |
| 2009-11-18 16:00:00 | AAPL | Stock | 7.3539 | 7.3611 | 7.3339 | 7.3564 | 11364052.0 |
| 2009-11-18 16:30:00 | AAPL | Stock | 7.3539 | 7.3589 | 7.3539 | 7.3571 | 65800.0 |
| 2009-11-18 17:00:00 | AAPL | Stock | 7.3521 | 7.3589 | 7.3521 | 7.3586 | 29008.0 |
| 2009-11-18 17:30:00 | AAPL | Stock | 7.3564 | 7.3589 | 7.3557 | 7.3557 | 24500.0 |
| 2009-11-18 18:00:00 | AAPL | Stock | 7.3557 | 7.3564 | 7.3521 | 7.3521 | 404208.0 |
| 2009-11-18 18:30:00 | AAPL | Stock | 7.3521 | 7.3521 | 7.35 | 7.35 | 93800.0 |
| 2009-11-18 19:00:00 | AAPL | Stock | 7.3496 | 7.35 | 7.3454 | 7.3464 | 144060.0 |
| 2009-11-18 19:30:00 | AAPL | Stock | 7.3464 | 7.3464 | 7.3339 | 7.3339 | 51800.0 |
| 2009-11-18 04:00:00 | MSFT | Stock | 30.0 | 30.0 | 30.0 | 30.0 | 1000.0 |
| 2009-11-18 07:00:00 | MSFT | Stock | 30.05 | 30.05 | 29.97 | 30.0 | 800.0 |
| 2009-11-18 07:30:00 | MSFT | Stock | 29.98 | 30.01 | 29.98 | 30.0 | 1100.0 |
| 2009-11-18 08:00:00 | MSFT | Stock | 30.0 | 30.15 | 30.0 | 30.12 | 33101.0 |
| 2009-11-18 08:30:00 | MSFT | Stock | 30.07 | 30.13 | 30.02 | 30.07 | 24329.0 |
| 2009-11-18 09:00:00 | MSFT | Stock | 30.08 | 30.08 | 29.93 | 30.0 | 173133.0 |
| 2009-11-18 09:30:00 | MSFT | Stock | 30.0 | 30.04 | 29.81 | 29.84 | 13244663.0 |
| 2009-11-18 10:00:00 | MSFT | Stock | 29.84 | 29.99 | 29.82 | 29.94 | 5109397.0 |
| 2009-11-18 10:30:00 | MSFT | Stock | 29.94 | 30.03 | 29.93 | 29.98 | 3938989.0 |
| 2009-11-18 11:00:00 | MSFT | Stock | 29.98 | 30.06 | 29.95 | 29.971 | 5467847.0 |
| 2009-11-18 11:30:00 | MSFT | Stock | 29.978 | 30.02 | 29.95 | 30.011 | 2871734.0 |
| 2009-11-18 12:00:00 | MSFT | Stock | 30.01 | 30.04 | 30.0 | 30.02 | 2927704.0 |
| 2009-11-18 12:30:00 | MSFT | Stock | 30.012 | 30.08 | 30.0 | 30.01 | 2790085.0 |
| 2009-11-18 13:00:00 | MSFT | Stock | 30.01 | 30.01 | 29.92 | 29.96 | 3501469.0 |
| 2009-11-18 13:30:00 | MSFT | Stock | 29.956 | 30.03 | 29.95 | 30.0 | 2163120.0 |
| 2009-11-18 14:00:00 | MSFT | Stock | 30.0 | 30.02 | 29.96 | 30.01 | 2224563.0 |
| 2009-11-18 14:30:00 | MSFT | Stock | 30.01 | 30.03 | 29.99 | 30.0 | 2010682.0 |
| 2009-11-18 15:00:00 | MSFT | Stock | 30.0 | 30.05 | 29.97 | 30.042 | 2558530.0 |
| 2009-11-18 15:30:00 | MSFT | Stock | 30.04 | 30.14 | 30.0 | 30.11 | 6599662.0 |
| 2009-11-18 16:00:00 | MSFT | Stock | 30.1 | 30.11 | 29.987 | 29.987 | 1961117.0 |
| 2009-11-18 16:30:00 | MSFT | Stock | 30.08 | 30.11 | 30.08 | 30.11 | 3016.0 |
> showing 50 of 73,059 rows — these rows as CSV