PREVIEW / stock_30min / 2006-08-15
file: by_date/stock_30min/2006/2006-08-15.parquet size: 916 KB rows: 50,476 symbols: 2,326
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-08-15 07:30:00 | AAPL | Stock | 2.2857 | 2.2857 | 2.2857 | 2.2857 | 2800.0 |
| 2006-08-15 08:00:00 | AAPL | Stock | 2.2857 | 2.3079 | 2.285 | 2.3029 | 1164688.0 |
| 2006-08-15 08:30:00 | AAPL | Stock | 2.3029 | 2.3243 | 2.3 | 2.3186 | 5137104.0 |
| 2006-08-15 09:00:00 | AAPL | Stock | 2.3189 | 2.3343 | 2.3171 | 2.3311 | 5749632.0 |
| 2006-08-15 09:30:00 | AAPL | Stock | 2.3336 | 2.3368 | 2.3143 | 2.3271 | 149062088.0 |
| 2006-08-15 10:00:00 | AAPL | Stock | 2.3271 | 2.3475 | 2.3232 | 2.3368 | 108135832.0 |
| 2006-08-15 10:30:00 | AAPL | Stock | 2.3371 | 2.3571 | 2.3368 | 2.3493 | 81943372.0 |
| 2006-08-15 11:00:00 | AAPL | Stock | 2.3493 | 2.3564 | 2.3446 | 2.3493 | 56821632.0 |
| 2006-08-15 11:30:00 | AAPL | Stock | 2.3496 | 2.3571 | 2.3446 | 2.3514 | 47852392.0 |
| 2006-08-15 12:00:00 | AAPL | Stock | 2.3514 | 2.36 | 2.3511 | 2.3532 | 44373952.0 |
| 2006-08-15 12:30:00 | AAPL | Stock | 2.3532 | 2.3643 | 2.3529 | 2.3611 | 35287560.0 |
| 2006-08-15 13:00:00 | AAPL | Stock | 2.3607 | 2.3639 | 2.3543 | 2.3554 | 42576296.0 |
| 2006-08-15 13:30:00 | AAPL | Stock | 2.3554 | 2.3696 | 2.355 | 2.36 | 49318836.0 |
| 2006-08-15 14:00:00 | AAPL | Stock | 2.36 | 2.3679 | 2.3514 | 2.3639 | 43963976.0 |
| 2006-08-15 14:30:00 | AAPL | Stock | 2.3639 | 2.3725 | 2.3614 | 2.3679 | 61925668.0 |
| 2006-08-15 15:00:00 | AAPL | Stock | 2.3675 | 2.3711 | 2.3636 | 2.3689 | 38497060.0 |
| 2006-08-15 15:30:00 | AAPL | Stock | 2.3689 | 2.375 | 2.3621 | 2.3739 | 73733212.0 |
| 2006-08-15 16:00:00 | AAPL | Stock | 2.3739 | 2.375 | 2.3499 | 2.3499 | 2650340.0 |
| 2006-08-15 16:30:00 | AAPL | Stock | 2.3501 | 2.3746 | 2.3501 | 2.3736 | 2230956.0 |
| 2006-08-15 17:00:00 | AAPL | Stock | 2.3739 | 2.375 | 2.3732 | 2.3732 | 186200.0 |
| 2006-08-15 17:30:00 | AAPL | Stock | 2.3736 | 2.375 | 2.3732 | 2.375 | 205800.0 |
| 2006-08-15 18:00:00 | AAPL | Stock | 2.375 | 2.375 | 2.3714 | 2.3746 | 202496.0 |
| 2006-08-15 08:00:00 | MSFT | Stock | 24.53 | 24.53 | 24.39 | 24.39 | 1370324.0 |
| 2006-08-15 08:30:00 | MSFT | Stock | 24.45 | 24.57 | 24.45 | 24.52 | 104463.0 |
| 2006-08-15 09:00:00 | MSFT | Stock | 24.55 | 24.56 | 24.51 | 24.55 | 140899.0 |
| 2006-08-15 09:30:00 | MSFT | Stock | 24.55 | 24.57 | 24.44 | 24.5 | 4675091.0 |
| 2006-08-15 10:00:00 | MSFT | Stock | 24.5 | 24.52 | 24.46 | 24.49 | 3351499.0 |
| 2006-08-15 10:30:00 | MSFT | Stock | 24.5 | 24.57 | 24.49 | 24.56 | 3185988.0 |
| 2006-08-15 11:00:00 | MSFT | Stock | 24.56 | 24.6 | 24.55 | 24.56 | 2980583.0 |
| 2006-08-15 11:30:00 | MSFT | Stock | 24.57 | 24.59 | 24.5 | 24.55 | 2656465.0 |
| 2006-08-15 12:00:00 | MSFT | Stock | 24.55 | 24.59 | 24.53 | 24.54 | 1882239.0 |
| 2006-08-15 12:30:00 | MSFT | Stock | 24.54 | 24.56 | 24.53 | 24.54 | 1520446.0 |
| 2006-08-15 13:00:00 | MSFT | Stock | 24.54 | 24.55 | 24.51 | 24.54 | 1343316.0 |
| 2006-08-15 13:30:00 | MSFT | Stock | 24.55 | 24.59 | 24.54 | 24.573 | 2201623.0 |
| 2006-08-15 14:00:00 | MSFT | Stock | 24.58 | 24.58 | 24.55 | 24.57 | 1476894.0 |
| 2006-08-15 14:30:00 | MSFT | Stock | 24.57 | 24.6 | 24.55 | 24.59 | 2917781.0 |
| 2006-08-15 15:00:00 | MSFT | Stock | 24.59 | 24.65 | 24.57 | 24.61 | 3510054.0 |
| 2006-08-15 15:30:00 | MSFT | Stock | 24.62 | 24.64 | 24.53 | 24.61 | 13519607.0 |
| 2006-08-15 16:00:00 | MSFT | Stock | 24.61 | 24.64 | 24.59 | 24.6 | 220582.0 |
| 2006-08-15 16:30:00 | MSFT | Stock | 24.59 | 24.63 | 24.59 | 24.63 | 755477.0 |
| 2006-08-15 17:00:00 | MSFT | Stock | 24.59 | 24.59 | 24.59 | 24.59 | 119.0 |
| 2006-08-15 17:30:00 | MSFT | Stock | 24.59 | 24.6 | 24.59 | 24.6 | 1890.0 |
| 2006-08-15 18:00:00 | MSFT | Stock | 24.62 | 24.62 | 24.59 | 24.59 | 874.0 |
| 2006-08-15 08:00:00 | NVDA | Stock | 0.3887 | 0.3915 | 0.3887 | 0.3915 | 12000.0 |
| 2006-08-15 08:30:00 | NVDA | Stock | 0.395 | 0.3952 | 0.3942 | 0.3948 | 469200.0 |
| 2006-08-15 09:00:00 | NVDA | Stock | 0.3952 | 0.3982 | 0.3938 | 0.3982 | 1472400.0 |
| 2006-08-15 09:30:00 | NVDA | Stock | 0.398 | 0.3997 | 0.3942 | 0.398 | 73989180.0 |
| 2006-08-15 10:00:00 | NVDA | Stock | 0.398 | 0.4025 | 0.3957 | 0.4015 | 50499240.0 |
| 2006-08-15 10:30:00 | NVDA | Stock | 0.4015 | 0.4093 | 0.4013 | 0.4068 | 103452060.0 |
| 2006-08-15 11:00:00 | NVDA | Stock | 0.4068 | 0.411 | 0.4068 | 0.4087 | 60052380.0 |
> showing 50 of 50,476 rows — these rows as CSV