PREVIEW / stock_5min / 2008-09-29
file: by_date/stock_5min/2008/2008-09-29.parquet size: 4.8 MB rows: 339,671 symbols: 3,378
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-29 06:20:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 22400.0 |
| 2008-09-29 06:50:00 | AAPL | Stock | 4.4171 | 4.4171 | 4.4171 | 4.4171 | 2800.0 |
| 2008-09-29 06:55:00 | AAPL | Stock | 4.3571 | 4.3571 | 4.3571 | 4.3571 | 74032.0 |
| 2008-09-29 07:00:00 | AAPL | Stock | 4.3396 | 4.3418 | 4.2857 | 4.3232 | 572908.0 |
| 2008-09-29 07:05:00 | AAPL | Stock | 4.3204 | 4.3214 | 4.3036 | 4.3036 | 33600.0 |
| 2008-09-29 07:10:00 | AAPL | Stock | 4.3036 | 4.3211 | 4.2854 | 4.2857 | 301840.0 |
| 2008-09-29 07:15:00 | AAPL | Stock | 4.2857 | 4.3193 | 4.2857 | 4.3 | 286188.0 |
| 2008-09-29 07:20:00 | AAPL | Stock | 4.3125 | 4.3264 | 4.3071 | 4.315 | 164948.0 |
| 2008-09-29 07:25:00 | AAPL | Stock | 4.3064 | 4.3214 | 4.3064 | 4.3179 | 75572.0 |
| 2008-09-29 07:30:00 | AAPL | Stock | 4.3196 | 4.3257 | 4.3075 | 4.3079 | 105308.0 |
| 2008-09-29 07:35:00 | AAPL | Stock | 4.3193 | 4.3396 | 4.3193 | 4.3393 | 149100.0 |
| 2008-09-29 07:40:00 | AAPL | Stock | 4.3221 | 4.3221 | 4.2979 | 4.3189 | 148120.0 |
| 2008-09-29 07:45:00 | AAPL | Stock | 4.3214 | 4.3214 | 4.3214 | 4.3214 | 117600.0 |
| 2008-09-29 07:50:00 | AAPL | Stock | 4.3171 | 4.3214 | 4.2854 | 4.2857 | 344764.0 |
| 2008-09-29 07:55:00 | AAPL | Stock | 4.2882 | 4.3143 | 4.2857 | 4.3 | 191100.0 |
| 2008-09-29 08:00:00 | AAPL | Stock | 4.3054 | 4.3293 | 4.2879 | 4.3293 | 883736.0 |
| 2008-09-29 08:05:00 | AAPL | Stock | 4.3321 | 4.3571 | 4.32 | 4.3429 | 1354024.0 |
| 2008-09-29 08:10:00 | AAPL | Stock | 4.3393 | 4.3429 | 4.2857 | 4.3239 | 1239728.0 |
| 2008-09-29 08:15:00 | AAPL | Stock | 4.3232 | 4.3286 | 4.3146 | 4.3214 | 598920.0 |
| 2008-09-29 08:20:00 | AAPL | Stock | 4.3214 | 4.3286 | 4.3107 | 4.3179 | 311612.0 |
| 2008-09-29 08:25:00 | AAPL | Stock | 4.3168 | 4.3293 | 4.315 | 4.3218 | 335804.0 |
| 2008-09-29 08:30:00 | AAPL | Stock | 4.3221 | 4.3457 | 4.3214 | 4.3221 | 449652.0 |
| 2008-09-29 08:35:00 | AAPL | Stock | 4.3279 | 4.3393 | 4.3214 | 4.3393 | 921480.0 |
| 2008-09-29 08:40:00 | AAPL | Stock | 4.3389 | 4.345 | 4.3307 | 4.3436 | 433552.0 |
| 2008-09-29 08:45:00 | AAPL | Stock | 4.3421 | 4.3482 | 4.3286 | 4.3336 | 488236.0 |
| 2008-09-29 08:50:00 | AAPL | Stock | 4.3346 | 4.3357 | 4.3071 | 4.3093 | 1115716.0 |
| 2008-09-29 08:55:00 | AAPL | Stock | 4.3114 | 4.3211 | 4.3075 | 4.3161 | 214032.0 |
| 2008-09-29 09:00:00 | AAPL | Stock | 4.3182 | 4.3214 | 4.3036 | 4.3064 | 478856.0 |
| 2008-09-29 09:05:00 | AAPL | Stock | 4.3075 | 4.3304 | 4.3071 | 4.3304 | 639660.0 |
| 2008-09-29 09:10:00 | AAPL | Stock | 4.3304 | 4.3304 | 4.2321 | 4.2621 | 3885224.0 |
| 2008-09-29 09:15:00 | AAPL | Stock | 4.2632 | 4.2632 | 4.2321 | 4.2386 | 1854328.0 |
| 2008-09-29 09:20:00 | AAPL | Stock | 4.2393 | 4.2625 | 4.2393 | 4.25 | 1124956.0 |
| 2008-09-29 09:25:00 | AAPL | Stock | 4.2511 | 4.2804 | 4.2321 | 4.275 | 4151868.0 |
| 2008-09-29 09:30:00 | AAPL | Stock | 4.275 | 4.275 | 4.1839 | 4.2004 | 49794500.0 |
| 2008-09-29 09:35:00 | AAPL | Stock | 4.2007 | 4.2214 | 4.1786 | 4.1786 | 47426428.0 |
| 2008-09-29 09:40:00 | AAPL | Stock | 4.1786 | 4.1961 | 4.1457 | 4.1557 | 52205832.0 |
| 2008-09-29 09:45:00 | AAPL | Stock | 4.1558 | 4.1566 | 4.025 | 4.0289 | 79247644.0 |
| 2008-09-29 09:50:00 | AAPL | Stock | 4.0279 | 4.0562 | 3.9289 | 3.9568 | 89740868.0 |
| 2008-09-29 09:55:00 | AAPL | Stock | 3.9568 | 3.9911 | 3.8929 | 3.9911 | 83728260.0 |
| 2008-09-29 10:00:00 | AAPL | Stock | 3.9907 | 4.0193 | 3.9589 | 3.9643 | 59612728.0 |
| 2008-09-29 10:05:00 | AAPL | Stock | 3.9636 | 3.9929 | 3.9286 | 3.932 | 50880452.0 |
| 2008-09-29 10:10:00 | AAPL | Stock | 3.9314 | 3.955 | 3.87 | 3.8845 | 57923012.0 |
| 2008-09-29 10:15:00 | AAPL | Stock | 3.8836 | 3.8946 | 3.8325 | 3.8732 | 63931644.0 |
| 2008-09-29 10:20:00 | AAPL | Stock | 3.8725 | 3.8754 | 3.8043 | 3.8418 | 44743664.0 |
| 2008-09-29 10:25:00 | AAPL | Stock | 3.8418 | 3.8839 | 3.8193 | 3.8193 | 54332488.0 |
| 2008-09-29 10:30:00 | AAPL | Stock | 3.8186 | 3.8882 | 3.7775 | 3.8804 | 52696588.0 |
| 2008-09-29 10:35:00 | AAPL | Stock | 3.8811 | 3.9068 | 3.8411 | 3.8839 | 39754456.0 |
| 2008-09-29 10:40:00 | AAPL | Stock | 3.8829 | 3.8954 | 3.8439 | 3.8686 | 27757184.0 |
| 2008-09-29 10:45:00 | AAPL | Stock | 3.8682 | 3.9286 | 3.8561 | 3.925 | 33806388.0 |
| 2008-09-29 10:50:00 | AAPL | Stock | 3.9257 | 3.9363 | 3.9125 | 3.9161 | 36800316.0 |
> showing 50 of 339,671 rows — these rows as CSV