PREVIEW / stock_5min / 2008-10-06
file: by_date/stock_5min/2008/2008-10-06.parquet size: 4.9 MB rows: 343,854 symbols: 3,394
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-10-06 07:00:00 | AAPL | Stock | 3.3004 | 3.3004 | 3.3004 | 3.3004 | 6160.0 |
| 2008-10-06 07:10:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 10780.0 |
| 2008-10-06 07:15:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3036 | 3.3125 | 97020.0 |
| 2008-10-06 07:20:00 | AAPL | Stock | 3.325 | 3.3304 | 3.2946 | 3.3036 | 128800.0 |
| 2008-10-06 07:25:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2768 | 3.2857 | 86632.0 |
| 2008-10-06 07:30:00 | AAPL | Stock | 3.2861 | 3.2946 | 3.2714 | 3.2946 | 50540.0 |
| 2008-10-06 07:35:00 | AAPL | Stock | 3.2943 | 3.2946 | 3.2857 | 3.2943 | 151200.0 |
| 2008-10-06 07:40:00 | AAPL | Stock | 3.2964 | 3.3 | 3.2857 | 3.2857 | 97048.0 |
| 2008-10-06 07:45:00 | AAPL | Stock | 3.2993 | 3.3196 | 3.2993 | 3.3196 | 57400.0 |
| 2008-10-06 07:50:00 | AAPL | Stock | 3.3171 | 3.3482 | 3.3075 | 3.3429 | 486920.0 |
| 2008-10-06 07:55:00 | AAPL | Stock | 3.3393 | 3.3607 | 3.3393 | 3.3429 | 163800.0 |
| 2008-10-06 08:00:00 | AAPL | Stock | 3.35 | 3.3739 | 3.3375 | 3.3393 | 899192.0 |
| 2008-10-06 08:05:00 | AAPL | Stock | 3.3389 | 3.3393 | 3.295 | 3.3136 | 653744.0 |
| 2008-10-06 08:10:00 | AAPL | Stock | 3.3139 | 3.3393 | 3.3104 | 3.3375 | 399336.0 |
| 2008-10-06 08:15:00 | AAPL | Stock | 3.3371 | 3.3739 | 3.3111 | 3.3111 | 1928948.0 |
| 2008-10-06 08:20:00 | AAPL | Stock | 3.3118 | 3.3389 | 3.3111 | 3.33 | 551908.0 |
| 2008-10-06 08:25:00 | AAPL | Stock | 3.3318 | 3.3393 | 3.3221 | 3.3282 | 354452.0 |
| 2008-10-06 08:30:00 | AAPL | Stock | 3.3293 | 3.34 | 3.3293 | 3.3386 | 463736.0 |
| 2008-10-06 08:35:00 | AAPL | Stock | 3.3382 | 3.3557 | 3.3382 | 3.3554 | 631820.0 |
| 2008-10-06 08:40:00 | AAPL | Stock | 3.355 | 3.355 | 3.3393 | 3.3414 | 364700.0 |
| 2008-10-06 08:45:00 | AAPL | Stock | 3.3425 | 3.3521 | 3.3414 | 3.3496 | 546000.0 |
| 2008-10-06 08:50:00 | AAPL | Stock | 3.3482 | 3.3493 | 3.3304 | 3.3304 | 511532.0 |
| 2008-10-06 08:55:00 | AAPL | Stock | 3.3286 | 3.3389 | 3.3232 | 3.3289 | 615440.0 |
| 2008-10-06 09:00:00 | AAPL | Stock | 3.3271 | 3.3314 | 3.3036 | 3.3121 | 936880.0 |
| 2008-10-06 09:05:00 | AAPL | Stock | 3.3121 | 3.3311 | 3.3079 | 3.3179 | 545608.0 |
| 2008-10-06 09:10:00 | AAPL | Stock | 3.3193 | 3.3293 | 3.3193 | 3.3218 | 934276.0 |
| 2008-10-06 09:15:00 | AAPL | Stock | 3.3243 | 3.3336 | 3.3214 | 3.3336 | 385420.0 |
| 2008-10-06 09:20:00 | AAPL | Stock | 3.3325 | 3.3414 | 3.3232 | 3.3261 | 710836.0 |
| 2008-10-06 09:25:00 | AAPL | Stock | 3.325 | 3.3429 | 3.2811 | 3.2836 | 5631360.0 |
| 2008-10-06 09:30:00 | AAPL | Stock | 3.2843 | 3.355 | 3.2539 | 3.355 | 49859824.0 |
| 2008-10-06 09:35:00 | AAPL | Stock | 3.3543 | 3.3696 | 3.2964 | 3.3186 | 43107820.0 |
| 2008-10-06 09:40:00 | AAPL | Stock | 3.3189 | 3.3375 | 3.3007 | 3.3214 | 28690172.0 |
| 2008-10-06 09:45:00 | AAPL | Stock | 3.3214 | 3.3214 | 3.2857 | 3.3074 | 24131912.0 |
| 2008-10-06 09:50:00 | AAPL | Stock | 3.3082 | 3.3286 | 3.2882 | 3.3 | 21227584.0 |
| 2008-10-06 09:55:00 | AAPL | Stock | 3.2993 | 3.3304 | 3.2879 | 3.3207 | 33826016.0 |
| 2008-10-06 10:00:00 | AAPL | Stock | 3.3199 | 3.3571 | 3.2925 | 3.3021 | 29622320.0 |
| 2008-10-06 10:05:00 | AAPL | Stock | 3.3011 | 3.34 | 3.2896 | 3.3337 | 30519580.0 |
| 2008-10-06 10:10:00 | AAPL | Stock | 3.3329 | 3.3529 | 3.2679 | 3.2714 | 33550832.0 |
| 2008-10-06 10:15:00 | AAPL | Stock | 3.2696 | 3.29 | 3.2321 | 3.2443 | 30459128.0 |
| 2008-10-06 10:20:00 | AAPL | Stock | 3.2454 | 3.2886 | 3.24 | 3.275 | 22198260.0 |
| 2008-10-06 10:25:00 | AAPL | Stock | 3.2743 | 3.285 | 3.2307 | 3.25 | 22532804.0 |
| 2008-10-06 10:30:00 | AAPL | Stock | 3.25 | 3.2668 | 3.2214 | 3.2221 | 23919308.0 |
| 2008-10-06 10:35:00 | AAPL | Stock | 3.2214 | 3.2293 | 3.1429 | 3.1818 | 36797768.0 |
| 2008-10-06 10:40:00 | AAPL | Stock | 3.1829 | 3.2029 | 3.1264 | 3.1393 | 36804152.0 |
| 2008-10-06 10:45:00 | AAPL | Stock | 3.1389 | 3.2221 | 3.1339 | 3.2146 | 43408372.0 |
| 2008-10-06 10:50:00 | AAPL | Stock | 3.2161 | 3.2589 | 3.2139 | 3.2557 | 32304524.0 |
| 2008-10-06 10:55:00 | AAPL | Stock | 3.2554 | 3.2936 | 3.2468 | 3.29 | 29582224.0 |
| 2008-10-06 11:00:00 | AAPL | Stock | 3.2921 | 3.2921 | 3.2321 | 3.2787 | 26471480.0 |
| 2008-10-06 11:05:00 | AAPL | Stock | 3.2832 | 3.2836 | 3.2471 | 3.2807 | 22028412.0 |
| 2008-10-06 11:10:00 | AAPL | Stock | 3.28 | 3.2871 | 3.2304 | 3.2341 | 25543224.0 |
> showing 50 of 343,854 rows — these rows as CSV