PREVIEW / stock_30min / 2009-10-21
file: by_date/stock_30min/2009/2009-10-21.parquet size: 1.4 MB rows: 73,720 symbols: 3,400
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-10-21 04:00:00 | AAPL | Stock | 7.1607 | 7.1607 | 7.1343 | 7.1343 | 5600.0 |
| 2009-10-21 05:30:00 | AAPL | Stock | 7.1107 | 7.1107 | 7.1107 | 7.1107 | 8400.0 |
| 2009-10-21 06:30:00 | AAPL | Stock | 7.1082 | 7.1082 | 7.1082 | 7.1082 | 2800.0 |
| 2009-10-21 07:00:00 | AAPL | Stock | 7.1086 | 7.1225 | 7.1082 | 7.1125 | 95200.0 |
| 2009-10-21 07:30:00 | AAPL | Stock | 7.1107 | 7.1189 | 7.1036 | 7.1189 | 181440.0 |
| 2009-10-21 08:00:00 | AAPL | Stock | 7.1164 | 7.125 | 7.1071 | 7.1232 | 1085980.0 |
| 2009-10-21 08:30:00 | AAPL | Stock | 7.1236 | 7.1243 | 7.1125 | 7.1168 | 1008896.0 |
| 2009-10-21 09:00:00 | AAPL | Stock | 7.1161 | 7.1296 | 7.0993 | 7.1243 | 2210544.0 |
| 2009-10-21 09:30:00 | AAPL | Stock | 7.1257 | 7.2118 | 7.1154 | 7.2104 | 122316740.0 |
| 2009-10-21 10:00:00 | AAPL | Stock | 7.21 | 7.3079 | 7.2025 | 7.2993 | 151509764.0 |
| 2009-10-21 10:30:00 | AAPL | Stock | 7.2993 | 7.3393 | 7.2832 | 7.3271 | 122162488.0 |
| 2009-10-21 11:00:00 | AAPL | Stock | 7.3257 | 7.3643 | 7.3236 | 7.3471 | 89004216.0 |
| 2009-10-21 11:30:00 | AAPL | Stock | 7.3471 | 7.355 | 7.3125 | 7.3182 | 59639888.0 |
| 2009-10-21 12:00:00 | AAPL | Stock | 7.3182 | 7.3361 | 7.3011 | 7.3204 | 45033800.0 |
| 2009-10-21 12:30:00 | AAPL | Stock | 7.3214 | 7.355 | 7.3179 | 7.3518 | 32365620.0 |
| 2009-10-21 13:00:00 | AAPL | Stock | 7.3514 | 7.4036 | 7.3471 | 7.3875 | 67178552.0 |
| 2009-10-21 13:30:00 | AAPL | Stock | 7.3877 | 7.4318 | 7.3679 | 7.4318 | 77959280.0 |
| 2009-10-21 14:00:00 | AAPL | Stock | 7.4307 | 7.4539 | 7.3932 | 7.4204 | 97191164.0 |
| 2009-10-21 14:30:00 | AAPL | Stock | 7.4204 | 7.4239 | 7.3875 | 7.4136 | 71210972.0 |
| 2009-10-21 15:00:00 | AAPL | Stock | 7.4136 | 7.4157 | 7.3429 | 7.3507 | 88260564.0 |
| 2009-10-21 15:30:00 | AAPL | Stock | 7.3514 | 7.3568 | 7.2993 | 7.3207 | 147014000.0 |
| 2009-10-21 16:00:00 | AAPL | Stock | 7.32 | 7.3304 | 7.3107 | 7.3179 | 7341208.0 |
| 2009-10-21 16:30:00 | AAPL | Stock | 7.3186 | 7.3318 | 7.3143 | 7.3318 | 676144.0 |
| 2009-10-21 17:00:00 | AAPL | Stock | 7.0986 | 7.335 | 7.0986 | 7.3232 | 716828.0 |
| 2009-10-21 17:30:00 | AAPL | Stock | 7.3229 | 7.3286 | 7.3214 | 7.3286 | 245308.0 |
| 2009-10-21 18:00:00 | AAPL | Stock | 7.3304 | 7.3339 | 7.3186 | 7.3214 | 1547364.0 |
| 2009-10-21 18:30:00 | AAPL | Stock | 7.3254 | 7.3286 | 7.3214 | 7.3221 | 238448.0 |
| 2009-10-21 19:00:00 | AAPL | Stock | 7.3221 | 7.3232 | 7.3214 | 7.3214 | 233856.0 |
| 2009-10-21 19:30:00 | AAPL | Stock | 7.3214 | 7.325 | 7.3189 | 7.3214 | 263368.0 |
| 2009-10-21 07:00:00 | MSFT | Stock | 26.37 | 26.48 | 26.35 | 26.35 | 2787.0 |
| 2009-10-21 07:30:00 | MSFT | Stock | 26.44 | 26.44 | 26.37 | 26.37 | 1356.0 |
| 2009-10-21 08:00:00 | MSFT | Stock | 26.37 | 26.38 | 26.21 | 26.37 | 2952.0 |
| 2009-10-21 08:30:00 | MSFT | Stock | 26.37 | 26.4 | 26.32 | 26.4 | 2647.0 |
| 2009-10-21 09:00:00 | MSFT | Stock | 26.37 | 26.49 | 26.35 | 26.46 | 18198.0 |
| 2009-10-21 09:30:00 | MSFT | Stock | 26.43 | 26.7 | 26.39 | 26.618 | 6161708.0 |
| 2009-10-21 10:00:00 | MSFT | Stock | 26.62 | 26.72 | 26.58 | 26.66 | 5070017.0 |
| 2009-10-21 10:30:00 | MSFT | Stock | 26.66 | 26.75 | 26.61 | 26.61 | 5670328.0 |
| 2009-10-21 11:00:00 | MSFT | Stock | 26.62 | 26.63 | 26.51 | 26.585 | 4291074.0 |
| 2009-10-21 11:30:00 | MSFT | Stock | 26.59 | 26.59 | 26.5 | 26.54 | 2790416.0 |
| 2009-10-21 12:00:00 | MSFT | Stock | 26.54 | 26.65 | 26.51 | 26.65 | 2994929.0 |
| 2009-10-21 12:30:00 | MSFT | Stock | 26.64 | 26.65 | 26.61 | 26.61 | 2078325.0 |
| 2009-10-21 13:00:00 | MSFT | Stock | 26.612 | 26.64 | 26.55 | 26.608 | 2957545.0 |
| 2009-10-21 13:30:00 | MSFT | Stock | 26.6 | 26.68 | 26.59 | 26.65 | 1716899.0 |
| 2009-10-21 14:00:00 | MSFT | Stock | 26.63 | 26.665 | 26.53 | 26.63 | 3000000.0 |
| 2009-10-21 14:30:00 | MSFT | Stock | 26.62 | 26.71 | 26.61 | 26.65 | 3012219.0 |
| 2009-10-21 15:00:00 | MSFT | Stock | 26.65 | 26.74 | 26.6 | 26.64 | 5208775.0 |
| 2009-10-21 15:30:00 | MSFT | Stock | 26.638 | 26.64 | 26.45 | 26.61 | 10869145.0 |
| 2009-10-21 16:00:00 | MSFT | Stock | 26.61 | 26.62 | 26.52 | 26.55 | 3156481.0 |
| 2009-10-21 16:30:00 | MSFT | Stock | 26.54 | 26.61 | 26.54 | 26.55 | 5690.0 |
| 2009-10-21 17:00:00 | MSFT | Stock | 26.37 | 26.66 | 26.37 | 26.6 | 10076.0 |
> showing 50 of 73,720 rows — these rows as CSV