PREVIEW / stock_30min / 2009-04-17
file: by_date/stock_30min/2009/2009-04-17.parquet size: 1.3 MB rows: 70,180 symbols: 3,330
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-04-17 07:00:00 | AAPL | Stock | 4.3182 | 4.3193 | 4.3182 | 4.3193 | 19600.0 |
| 2009-04-17 07:30:00 | AAPL | Stock | 4.3375 | 4.3375 | 4.3375 | 4.3375 | 11480.0 |
| 2009-04-17 08:00:00 | AAPL | Stock | 4.3339 | 4.3511 | 4.3196 | 4.3196 | 457268.0 |
| 2009-04-17 08:30:00 | AAPL | Stock | 4.3182 | 4.325 | 4.2968 | 4.3025 | 458948.0 |
| 2009-04-17 09:00:00 | AAPL | Stock | 4.3025 | 4.3179 | 4.2875 | 4.3179 | 1333836.0 |
| 2009-04-17 09:30:00 | AAPL | Stock | 4.3161 | 4.3482 | 4.2946 | 4.3476 | 67102224.0 |
| 2009-04-17 10:00:00 | AAPL | Stock | 4.3479 | 4.3707 | 4.3439 | 4.36 | 39346804.0 |
| 2009-04-17 10:30:00 | AAPL | Stock | 4.36 | 4.365 | 4.3404 | 4.3539 | 28556920.0 |
| 2009-04-17 11:00:00 | AAPL | Stock | 4.3546 | 4.3839 | 4.3464 | 4.3804 | 24809848.0 |
| 2009-04-17 11:30:00 | AAPL | Stock | 4.3807 | 4.3911 | 4.375 | 4.3775 | 22323728.0 |
| 2009-04-17 12:00:00 | AAPL | Stock | 4.3779 | 4.3886 | 4.3686 | 4.3875 | 19810840.0 |
| 2009-04-17 12:30:00 | AAPL | Stock | 4.3879 | 4.3921 | 4.3621 | 4.3896 | 21515144.0 |
| 2009-04-17 13:00:00 | AAPL | Stock | 4.3893 | 4.4089 | 4.3879 | 4.4082 | 24756788.0 |
| 2009-04-17 13:30:00 | AAPL | Stock | 4.4079 | 4.4357 | 4.4 | 4.43 | 37170308.0 |
| 2009-04-17 14:00:00 | AAPL | Stock | 4.43 | 4.4343 | 4.4125 | 4.42 | 27397300.0 |
| 2009-04-17 14:30:00 | AAPL | Stock | 4.4204 | 4.4286 | 4.4 | 4.4061 | 25614092.0 |
| 2009-04-17 15:00:00 | AAPL | Stock | 4.4068 | 4.4375 | 4.4043 | 4.42 | 39349380.0 |
| 2009-04-17 15:30:00 | AAPL | Stock | 4.42 | 4.43 | 4.4032 | 4.4071 | 60240796.0 |
| 2009-04-17 16:00:00 | AAPL | Stock | 4.4064 | 4.4184 | 4.3731 | 4.4079 | 15119048.0 |
| 2009-04-17 16:30:00 | AAPL | Stock | 4.4079 | 4.4172 | 4.4079 | 4.4146 | 656544.0 |
| 2009-04-17 17:00:00 | AAPL | Stock | 4.4161 | 4.4171 | 4.4143 | 4.4143 | 152432.0 |
| 2009-04-17 17:30:00 | AAPL | Stock | 4.4146 | 4.4193 | 4.4146 | 4.4193 | 42840.0 |
| 2009-04-17 18:00:00 | AAPL | Stock | 4.4193 | 4.4214 | 4.4179 | 4.4179 | 137340.0 |
| 2009-04-17 18:30:00 | AAPL | Stock | 4.4207 | 4.4207 | 4.4196 | 4.4196 | 28252.0 |
| 2009-04-17 19:00:00 | AAPL | Stock | 4.4207 | 4.4211 | 4.4196 | 4.4196 | 37800.0 |
| 2009-04-17 19:30:00 | AAPL | Stock | 4.4196 | 4.4207 | 4.4179 | 4.4207 | 118860.0 |
| 2009-04-17 07:00:00 | MSFT | Stock | 19.64 | 19.64 | 19.64 | 19.64 | 250.0 |
| 2009-04-17 07:30:00 | MSFT | Stock | 19.64 | 19.64 | 19.64 | 19.64 | 750.0 |
| 2009-04-17 08:00:00 | MSFT | Stock | 19.66 | 19.69 | 19.66 | 19.66 | 3377.0 |
| 2009-04-17 08:30:00 | MSFT | Stock | 19.62 | 19.65 | 19.58 | 19.58 | 2909.0 |
| 2009-04-17 09:00:00 | MSFT | Stock | 19.58 | 19.69 | 19.51 | 19.69 | 23877.0 |
| 2009-04-17 09:30:00 | MSFT | Stock | 19.67 | 19.7 | 19.0 | 19.52 | 5838135.0 |
| 2009-04-17 10:00:00 | MSFT | Stock | 19.52 | 19.545 | 19.35 | 19.37 | 3674794.0 |
| 2009-04-17 10:30:00 | MSFT | Stock | 19.37 | 19.38 | 19.13 | 19.15 | 3879864.0 |
| 2009-04-17 11:00:00 | MSFT | Stock | 19.15 | 19.22 | 19.09 | 19.169 | 4217454.0 |
| 2009-04-17 11:30:00 | MSFT | Stock | 19.17 | 19.28 | 19.14 | 19.23 | 2435448.0 |
| 2009-04-17 12:00:00 | MSFT | Stock | 19.23 | 19.26 | 19.152 | 19.24 | 1253414.0 |
| 2009-04-17 12:30:00 | MSFT | Stock | 19.23 | 19.24 | 19.1 | 19.19 | 2421869.0 |
| 2009-04-17 13:00:00 | MSFT | Stock | 19.188 | 19.28 | 19.18 | 19.235 | 1850452.0 |
| 2009-04-17 13:30:00 | MSFT | Stock | 19.23 | 19.27 | 19.19 | 19.26 | 2162292.0 |
| 2009-04-17 14:00:00 | MSFT | Stock | 19.26 | 19.32 | 19.21 | 19.318 | 3312008.0 |
| 2009-04-17 14:30:00 | MSFT | Stock | 19.32 | 19.4 | 19.18 | 19.212 | 3187244.0 |
| 2009-04-17 15:00:00 | MSFT | Stock | 19.215 | 19.35 | 19.2 | 19.29 | 2987138.0 |
| 2009-04-17 15:30:00 | MSFT | Stock | 19.29 | 19.39 | 19.15 | 19.18 | 10240928.0 |
| 2009-04-17 16:00:00 | MSFT | Stock | 19.2 | 19.406 | 19.15 | 19.334 | 4070947.0 |
| 2009-04-17 16:30:00 | MSFT | Stock | 19.2 | 19.27 | 19.16 | 19.27 | 88171.0 |
| 2009-04-17 17:00:00 | MSFT | Stock | 19.2 | 19.26 | 19.16 | 19.2 | 15680.0 |
| 2009-04-17 17:30:00 | MSFT | Stock | 19.2 | 19.25 | 19.2 | 19.25 | 12359.0 |
| 2009-04-17 18:00:00 | MSFT | Stock | 19.25 | 19.26 | 19.23 | 19.25 | 14890.0 |
| 2009-04-17 18:30:00 | MSFT | Stock | 19.25 | 19.27 | 19.22 | 19.22 | 5496.0 |
> showing 50 of 70,180 rows — these rows as CSV