PREVIEW / stock_30min / 2010-08-05
file: by_date/stock_30min/2010/2010-08-05.parquet size: 1.3 MB rows: 73,111 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-05 04:00:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 8400.0 |
| 2010-08-05 05:30:00 | AAPL | Stock | 9.4018 | 9.4018 | 9.4018 | 9.4018 | 17500.0 |
| 2010-08-05 07:00:00 | AAPL | Stock | 9.4193 | 9.4286 | 9.3964 | 9.3964 | 148204.0 |
| 2010-08-05 07:30:00 | AAPL | Stock | 9.4107 | 9.4246 | 9.4 | 9.4107 | 19600.0 |
| 2010-08-05 08:00:00 | AAPL | Stock | 9.3971 | 9.4186 | 9.3893 | 9.3996 | 774340.0 |
| 2010-08-05 08:30:00 | AAPL | Stock | 9.385 | 9.3929 | 9.3732 | 9.3768 | 1940932.0 |
| 2010-08-05 09:00:00 | AAPL | Stock | 9.3768 | 9.3786 | 9.3396 | 9.3396 | 2036916.0 |
| 2010-08-05 09:30:00 | AAPL | Stock | 9.3475 | 9.3993 | 9.3232 | 9.3582 | 50369592.0 |
| 2010-08-05 10:00:00 | AAPL | Stock | 9.3589 | 9.38 | 9.3529 | 9.3771 | 26666052.0 |
| 2010-08-05 10:30:00 | AAPL | Stock | 9.3757 | 9.3786 | 9.3171 | 9.3257 | 32186224.0 |
| 2010-08-05 11:00:00 | AAPL | Stock | 9.3262 | 9.3361 | 9.3054 | 9.3286 | 27767376.0 |
| 2010-08-05 11:30:00 | AAPL | Stock | 9.3282 | 9.3454 | 9.3143 | 9.3311 | 16295552.0 |
| 2010-08-05 12:00:00 | AAPL | Stock | 9.3331 | 9.3425 | 9.3275 | 9.3296 | 8651524.0 |
| 2010-08-05 12:30:00 | AAPL | Stock | 9.3311 | 9.3375 | 9.3107 | 9.3261 | 13968976.0 |
| 2010-08-05 13:00:00 | AAPL | Stock | 9.3261 | 9.335 | 9.3107 | 9.3293 | 10998288.0 |
| 2010-08-05 13:30:00 | AAPL | Stock | 9.3302 | 9.3546 | 9.3214 | 9.3496 | 14784476.0 |
| 2010-08-05 14:00:00 | AAPL | Stock | 9.35 | 9.3532 | 9.3214 | 9.35 | 12448128.0 |
| 2010-08-05 14:30:00 | AAPL | Stock | 9.3505 | 9.3571 | 9.3382 | 9.345 | 13907880.0 |
| 2010-08-05 15:00:00 | AAPL | Stock | 9.3436 | 9.365 | 9.3436 | 9.3521 | 20646892.0 |
| 2010-08-05 15:30:00 | AAPL | Stock | 9.3525 | 9.3575 | 9.3329 | 9.3464 | 29851220.0 |
| 2010-08-05 16:00:00 | AAPL | Stock | 9.3464 | 9.3474 | 9.3379 | 9.3429 | 4079348.0 |
| 2010-08-05 16:30:00 | AAPL | Stock | 9.3429 | 9.3541 | 9.3429 | 9.3436 | 248248.0 |
| 2010-08-05 17:00:00 | AAPL | Stock | 9.3429 | 9.3475 | 9.3418 | 9.345 | 87920.0 |
| 2010-08-05 17:30:00 | AAPL | Stock | 9.3446 | 9.3446 | 9.3404 | 9.3429 | 59192.0 |
| 2010-08-05 18:00:00 | AAPL | Stock | 9.3457 | 9.3457 | 9.3404 | 9.3404 | 29176.0 |
| 2010-08-05 18:30:00 | AAPL | Stock | 9.3414 | 9.3464 | 9.34 | 9.34 | 76664.0 |
| 2010-08-05 19:00:00 | AAPL | Stock | 9.34 | 9.34 | 9.3357 | 9.3375 | 105924.0 |
| 2010-08-05 19:30:00 | AAPL | Stock | 9.3393 | 9.3393 | 9.3393 | 9.3393 | 35336.0 |
| 2010-08-05 20:00:00 | AAPL | Stock | 9.335 | 9.335 | 9.335 | 9.335 | 19600.0 |
| 2010-08-05 07:00:00 | MSFT | Stock | 25.87 | 25.93 | 25.87 | 25.9 | 2900.0 |
| 2010-08-05 07:30:00 | MSFT | Stock | 25.87 | 25.87 | 25.86 | 25.87 | 1500.0 |
| 2010-08-05 08:00:00 | MSFT | Stock | 25.85 | 25.86 | 25.79 | 25.8 | 13490.0 |
| 2010-08-05 08:30:00 | MSFT | Stock | 25.73 | 25.76 | 25.63 | 25.63 | 21930.0 |
| 2010-08-05 09:00:00 | MSFT | Stock | 25.729 | 25.729 | 25.41 | 25.49 | 37166.0 |
| 2010-08-05 09:30:00 | MSFT | Stock | 25.5 | 25.58 | 25.45 | 25.5 | 5500174.0 |
| 2010-08-05 10:00:00 | MSFT | Stock | 25.5 | 25.54 | 25.37 | 25.41 | 5397826.0 |
| 2010-08-05 10:30:00 | MSFT | Stock | 25.41 | 25.44 | 25.31 | 25.31 | 5881648.0 |
| 2010-08-05 11:00:00 | MSFT | Stock | 25.32 | 25.32 | 25.21 | 25.285 | 6797071.0 |
| 2010-08-05 11:30:00 | MSFT | Stock | 25.29 | 25.33 | 25.23 | 25.26 | 4543648.0 |
| 2010-08-05 12:00:00 | MSFT | Stock | 25.26 | 25.38 | 25.252 | 25.345 | 4542630.0 |
| 2010-08-05 12:30:00 | MSFT | Stock | 25.35 | 25.38 | 25.32 | 25.32 | 2769515.0 |
| 2010-08-05 13:00:00 | MSFT | Stock | 25.325 | 25.341 | 25.29 | 25.32 | 2567752.0 |
| 2010-08-05 13:30:00 | MSFT | Stock | 25.33 | 25.39 | 25.31 | 25.37 | 4111955.0 |
| 2010-08-05 14:00:00 | MSFT | Stock | 25.38 | 25.4 | 25.33 | 25.33 | 3788394.0 |
| 2010-08-05 14:30:00 | MSFT | Stock | 25.33 | 25.37 | 25.31 | 25.35 | 2915975.0 |
| 2010-08-05 15:00:00 | MSFT | Stock | 25.35 | 25.4 | 25.34 | 25.345 | 4459113.0 |
| 2010-08-05 15:30:00 | MSFT | Stock | 25.34 | 25.37 | 25.29 | 25.37 | 9122163.0 |
| 2010-08-05 16:00:00 | MSFT | Stock | 25.37 | 25.39 | 25.3 | 25.37 | 1594232.0 |
| 2010-08-05 16:30:00 | MSFT | Stock | 25.356 | 25.73 | 25.331 | 25.4 | 38280.0 |
| 2010-08-05 17:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.37 | 25.37 | 13920.0 |
> showing 50 of 73,111 rows — these rows as CSV