PREVIEW / stock_5min / 2010-07-08
file: by_date/stock_5min/2010/2010-07-08.parquet size: 4.7 MB rows: 327,946 symbols: 3,459
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-07-08 04:40:00 | AAPL | Stock | 9.2714 | 9.2789 | 9.2714 | 9.2789 | 8400.0 |
| 2010-07-08 04:45:00 | AAPL | Stock | 9.2789 | 9.2789 | 9.2789 | 9.2789 | 5600.0 |
| 2010-07-08 05:00:00 | AAPL | Stock | 9.2804 | 9.2804 | 9.2804 | 9.2804 | 2800.0 |
| 2010-07-08 05:15:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 2800.0 |
| 2010-07-08 05:40:00 | AAPL | Stock | 9.2754 | 9.2754 | 9.275 | 9.275 | 47740.0 |
| 2010-07-08 05:45:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 8260.0 |
| 2010-07-08 06:20:00 | AAPL | Stock | 9.2768 | 9.2768 | 9.2768 | 9.2768 | 2800.0 |
| 2010-07-08 06:35:00 | AAPL | Stock | 9.3018 | 9.3018 | 9.3018 | 9.3018 | 8400.0 |
| 2010-07-08 07:00:00 | AAPL | Stock | 9.2768 | 9.2857 | 9.2679 | 9.2679 | 151340.0 |
| 2010-07-08 07:05:00 | AAPL | Stock | 9.2711 | 9.2714 | 9.2554 | 9.2625 | 55188.0 |
| 2010-07-08 07:15:00 | AAPL | Stock | 9.2629 | 9.2629 | 9.2629 | 9.2629 | 2800.0 |
| 2010-07-08 07:20:00 | AAPL | Stock | 9.2704 | 9.2807 | 9.2704 | 9.2771 | 249200.0 |
| 2010-07-08 07:25:00 | AAPL | Stock | 9.2732 | 9.2732 | 9.2661 | 9.2661 | 11200.0 |
| 2010-07-08 07:30:00 | AAPL | Stock | 9.2679 | 9.2679 | 9.2629 | 9.2629 | 45220.0 |
| 2010-07-08 07:35:00 | AAPL | Stock | 9.2593 | 9.2593 | 9.25 | 9.2521 | 60200.0 |
| 2010-07-08 07:40:00 | AAPL | Stock | 9.2479 | 9.2479 | 9.245 | 9.245 | 39200.0 |
| 2010-07-08 07:45:00 | AAPL | Stock | 9.2607 | 9.2643 | 9.2607 | 9.2643 | 5600.0 |
| 2010-07-08 07:55:00 | AAPL | Stock | 9.2621 | 9.2621 | 9.2621 | 9.2621 | 5600.0 |
| 2010-07-08 08:00:00 | AAPL | Stock | 9.2575 | 9.275 | 9.25 | 9.275 | 452340.0 |
| 2010-07-08 08:05:00 | AAPL | Stock | 9.275 | 9.2971 | 9.275 | 9.2946 | 515592.0 |
| 2010-07-08 08:10:00 | AAPL | Stock | 9.2925 | 9.2993 | 9.2857 | 9.2957 | 211260.0 |
| 2010-07-08 08:15:00 | AAPL | Stock | 9.2986 | 9.2996 | 9.2929 | 9.2936 | 281904.0 |
| 2010-07-08 08:20:00 | AAPL | Stock | 9.2932 | 9.2957 | 9.2854 | 9.2925 | 755216.0 |
| 2010-07-08 08:25:00 | AAPL | Stock | 9.2893 | 9.2929 | 9.2854 | 9.2854 | 296940.0 |
| 2010-07-08 08:30:00 | AAPL | Stock | 9.2857 | 9.3357 | 9.2857 | 9.3321 | 1834504.0 |
| 2010-07-08 08:35:00 | AAPL | Stock | 9.3318 | 9.3764 | 9.3307 | 9.365 | 2011044.0 |
| 2010-07-08 08:40:00 | AAPL | Stock | 9.3639 | 9.3782 | 9.3625 | 9.3671 | 925904.0 |
| 2010-07-08 08:45:00 | AAPL | Stock | 9.3686 | 9.3807 | 9.3636 | 9.3636 | 1150688.0 |
| 2010-07-08 08:50:00 | AAPL | Stock | 9.3632 | 9.3811 | 9.3629 | 9.3782 | 759388.0 |
| 2010-07-08 08:55:00 | AAPL | Stock | 9.3786 | 9.3811 | 9.3679 | 9.3679 | 929516.0 |
| 2010-07-08 09:00:00 | AAPL | Stock | 9.37 | 9.3925 | 9.37 | 9.3768 | 997164.0 |
| 2010-07-08 09:05:00 | AAPL | Stock | 9.3782 | 9.3832 | 9.3771 | 9.3825 | 555156.0 |
| 2010-07-08 09:10:00 | AAPL | Stock | 9.3796 | 9.3893 | 9.3789 | 9.3875 | 703360.0 |
| 2010-07-08 09:15:00 | AAPL | Stock | 9.3861 | 9.3889 | 9.3804 | 9.3821 | 462364.0 |
| 2010-07-08 09:20:00 | AAPL | Stock | 9.3811 | 9.3832 | 9.375 | 9.3782 | 368928.0 |
| 2010-07-08 09:25:00 | AAPL | Stock | 9.3764 | 9.3893 | 9.3664 | 9.3757 | 804160.0 |
| 2010-07-08 09:30:00 | AAPL | Stock | 9.3764 | 9.3893 | 9.3461 | 9.3736 | 31342388.0 |
| 2010-07-08 09:35:00 | AAPL | Stock | 9.3714 | 9.3861 | 9.35 | 9.3536 | 21908684.0 |
| 2010-07-08 09:40:00 | AAPL | Stock | 9.3536 | 9.3554 | 9.3171 | 9.3246 | 21059080.0 |
| 2010-07-08 09:45:00 | AAPL | Stock | 9.3232 | 9.3304 | 9.3086 | 9.3239 | 16744896.0 |
| 2010-07-08 09:50:00 | AAPL | Stock | 9.3239 | 9.3454 | 9.3225 | 9.3407 | 12692148.0 |
| 2010-07-08 09:55:00 | AAPL | Stock | 9.3407 | 9.3428 | 9.3243 | 9.3316 | 10231872.0 |
| 2010-07-08 10:00:00 | AAPL | Stock | 9.3311 | 9.34 | 9.3193 | 9.3204 | 10992520.0 |
| 2010-07-08 10:05:00 | AAPL | Stock | 9.3196 | 9.3215 | 9.3 | 9.3136 | 13851768.0 |
| 2010-07-08 10:10:00 | AAPL | Stock | 9.3139 | 9.3264 | 9.2964 | 9.3168 | 16683380.0 |
| 2010-07-08 10:15:00 | AAPL | Stock | 9.3154 | 9.3275 | 9.3071 | 9.3193 | 9025296.0 |
| 2010-07-08 10:20:00 | AAPL | Stock | 9.3189 | 9.3368 | 9.3121 | 9.3286 | 12453588.0 |
| 2010-07-08 10:25:00 | AAPL | Stock | 9.3291 | 9.3489 | 9.3257 | 9.3421 | 8597232.0 |
| 2010-07-08 10:30:00 | AAPL | Stock | 9.3429 | 9.3446 | 9.3254 | 9.3325 | 6178956.0 |
| 2010-07-08 10:35:00 | AAPL | Stock | 9.3346 | 9.3357 | 9.3225 | 9.3293 | 6840904.0 |
> showing 50 of 327,946 rows — these rows as CSV