PREVIEW / stock_30min / 2009-11-16
file: by_date/stock_30min/2009/2009-11-16.parquet size: 1.4 MB rows: 73,982 symbols: 3,433
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-16 06:00:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-11-16 07:00:00 | AAPL | Stock | 7.3543 | 7.3568 | 7.3529 | 7.3536 | 144480.0 |
| 2009-11-16 07:30:00 | AAPL | Stock | 7.3536 | 7.3554 | 7.3286 | 7.3286 | 492548.0 |
| 2009-11-16 08:00:00 | AAPL | Stock | 7.3318 | 7.354 | 7.3214 | 7.3375 | 2265060.0 |
| 2009-11-16 08:30:00 | AAPL | Stock | 7.3354 | 7.3436 | 7.3279 | 7.343 | 1253392.0 |
| 2009-11-16 09:00:00 | AAPL | Stock | 7.3425 | 7.3479 | 7.3339 | 7.3361 | 999236.0 |
| 2009-11-16 09:30:00 | AAPL | Stock | 7.3371 | 7.4286 | 7.3218 | 7.405 | 95991728.0 |
| 2009-11-16 10:00:00 | AAPL | Stock | 7.4054 | 7.4286 | 7.3975 | 7.415 | 51544276.0 |
| 2009-11-16 10:30:00 | AAPL | Stock | 7.415 | 7.4264 | 7.3861 | 7.4039 | 38731420.0 |
| 2009-11-16 11:00:00 | AAPL | Stock | 7.4036 | 7.415 | 7.3964 | 7.3968 | 17012100.0 |
| 2009-11-16 11:30:00 | AAPL | Stock | 7.3975 | 7.4096 | 7.3975 | 7.4032 | 16303672.0 |
| 2009-11-16 12:00:00 | AAPL | Stock | 7.4023 | 7.4068 | 7.3714 | 7.385 | 23354296.0 |
| 2009-11-16 12:30:00 | AAPL | Stock | 7.3864 | 7.4068 | 7.3782 | 7.4068 | 14021672.0 |
| 2009-11-16 13:00:00 | AAPL | Stock | 7.4068 | 7.4139 | 7.4021 | 7.4111 | 22096676.0 |
| 2009-11-16 13:30:00 | AAPL | Stock | 7.4111 | 7.4221 | 7.4096 | 7.4136 | 18160996.0 |
| 2009-11-16 14:00:00 | AAPL | Stock | 7.4132 | 7.4189 | 7.4114 | 7.4123 | 15299620.0 |
| 2009-11-16 14:30:00 | AAPL | Stock | 7.4118 | 7.4161 | 7.3893 | 7.3957 | 28642460.0 |
| 2009-11-16 15:00:00 | AAPL | Stock | 7.3957 | 7.3992 | 7.3482 | 7.3486 | 43172416.0 |
| 2009-11-16 15:30:00 | AAPL | Stock | 7.3482 | 7.3839 | 7.3414 | 7.3732 | 53906804.0 |
| 2009-11-16 16:00:00 | AAPL | Stock | 7.3796 | 7.392 | 7.3682 | 7.3727 | 27275416.0 |
| 2009-11-16 16:30:00 | AAPL | Stock | 7.3714 | 7.4139 | 7.3714 | 7.3786 | 974204.0 |
| 2009-11-16 17:00:00 | AAPL | Stock | 7.3768 | 7.3796 | 7.3729 | 7.3786 | 112504.0 |
| 2009-11-16 17:30:00 | AAPL | Stock | 7.3793 | 7.3796 | 7.3768 | 7.3793 | 22820.0 |
| 2009-11-16 18:00:00 | AAPL | Stock | 7.3796 | 7.3796 | 7.37 | 7.3782 | 361116.0 |
| 2009-11-16 18:30:00 | AAPL | Stock | 7.3796 | 7.3796 | 7.3771 | 7.3779 | 23688.0 |
| 2009-11-16 19:00:00 | AAPL | Stock | 7.3804 | 7.3804 | 7.3796 | 7.3796 | 69132.0 |
| 2009-11-16 19:30:00 | AAPL | Stock | 7.3796 | 7.3811 | 7.375 | 7.3804 | 120456.0 |
| 2009-11-16 07:00:00 | MSFT | Stock | 29.76 | 29.8 | 29.64 | 29.64 | 1654.0 |
| 2009-11-16 07:30:00 | MSFT | Stock | 29.76 | 29.81 | 29.76 | 29.81 | 4200.0 |
| 2009-11-16 08:00:00 | MSFT | Stock | 29.84 | 29.84 | 29.75 | 29.8 | 12274.0 |
| 2009-11-16 08:30:00 | MSFT | Stock | 29.79 | 29.8 | 29.75 | 29.75 | 16609.0 |
| 2009-11-16 09:00:00 | MSFT | Stock | 29.75 | 29.84 | 29.62 | 29.63 | 96192.0 |
| 2009-11-16 09:30:00 | MSFT | Stock | 29.62 | 29.78 | 29.53 | 29.75 | 5318557.0 |
| 2009-11-16 10:00:00 | MSFT | Stock | 29.75 | 29.8 | 29.7 | 29.72 | 4194387.0 |
| 2009-11-16 10:30:00 | MSFT | Stock | 29.72 | 29.76 | 29.7 | 29.732 | 2569389.0 |
| 2009-11-16 11:00:00 | MSFT | Stock | 29.74 | 29.74 | 29.68 | 29.68 | 3362251.0 |
| 2009-11-16 11:30:00 | MSFT | Stock | 29.683 | 29.75 | 29.68 | 29.72 | 2598244.0 |
| 2009-11-16 12:00:00 | MSFT | Stock | 29.728 | 29.74 | 29.62 | 29.67 | 5125773.0 |
| 2009-11-16 12:30:00 | MSFT | Stock | 29.675 | 29.7 | 29.6 | 29.68 | 2379440.0 |
| 2009-11-16 13:00:00 | MSFT | Stock | 29.67 | 29.7 | 29.58 | 29.6 | 3337056.0 |
| 2009-11-16 13:30:00 | MSFT | Stock | 29.608 | 29.65 | 29.59 | 29.59 | 2568222.0 |
| 2009-11-16 14:00:00 | MSFT | Stock | 29.595 | 29.65 | 29.58 | 29.618 | 3323120.0 |
| 2009-11-16 14:30:00 | MSFT | Stock | 29.62 | 29.63 | 29.5 | 29.53 | 2659709.0 |
| 2009-11-16 15:00:00 | MSFT | Stock | 29.522 | 29.56 | 29.37 | 29.382 | 5485055.0 |
| 2009-11-16 15:30:00 | MSFT | Stock | 29.38 | 29.55 | 29.38 | 29.54 | 6153598.0 |
| 2009-11-16 16:00:00 | MSFT | Stock | 29.53 | 29.62 | 29.45 | 29.48 | 1873195.0 |
| 2009-11-16 16:30:00 | MSFT | Stock | 29.5 | 29.61 | 29.49 | 29.51 | 18814.0 |
| 2009-11-16 17:00:00 | MSFT | Stock | 29.5 | 29.54 | 29.45 | 29.5 | 8934.0 |
| 2009-11-16 17:30:00 | MSFT | Stock | 29.51 | 29.51 | 29.51 | 29.51 | 1500.0 |
| 2009-11-16 18:00:00 | MSFT | Stock | 29.51 | 29.54 | 29.51 | 29.54 | 282551.0 |
> showing 50 of 73,982 rows — these rows as CSV