PREVIEW / stock_5min / 2008-08-20
file: by_date/stock_5min/2008/2008-08-20.parquet size: 4.3 MB rows: 305,590 symbols: 3,303
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-08-20 07:00:00 | AAPL | Stock | 6.2779 | 6.2779 | 6.2232 | 6.2232 | 19600.0 |
| 2008-08-20 07:35:00 | AAPL | Stock | 6.2411 | 6.2411 | 6.2411 | 6.2411 | 5600.0 |
| 2008-08-20 07:40:00 | AAPL | Stock | 6.2343 | 6.2393 | 6.2343 | 6.2393 | 5600.0 |
| 2008-08-20 07:45:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.25 | 6.25 | 25200.0 |
| 2008-08-20 07:55:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.25 | 6.2507 | 23100.0 |
| 2008-08-20 08:00:00 | AAPL | Stock | 6.2507 | 6.2507 | 6.2336 | 6.2346 | 345856.0 |
| 2008-08-20 08:05:00 | AAPL | Stock | 6.2375 | 6.2393 | 6.2375 | 6.2382 | 117180.0 |
| 2008-08-20 08:10:00 | AAPL | Stock | 6.2375 | 6.2375 | 6.2268 | 6.2311 | 109480.0 |
| 2008-08-20 08:15:00 | AAPL | Stock | 6.2286 | 6.2307 | 6.225 | 6.2271 | 105700.0 |
| 2008-08-20 08:20:00 | AAPL | Stock | 6.2268 | 6.2286 | 6.2268 | 6.2286 | 53620.0 |
| 2008-08-20 08:25:00 | AAPL | Stock | 6.2286 | 6.2321 | 6.2286 | 6.2307 | 21000.0 |
| 2008-08-20 08:30:00 | AAPL | Stock | 6.2293 | 6.2321 | 6.2257 | 6.2257 | 71400.0 |
| 2008-08-20 08:35:00 | AAPL | Stock | 6.2282 | 6.2286 | 6.2268 | 6.2268 | 28700.0 |
| 2008-08-20 08:40:00 | AAPL | Stock | 6.2282 | 6.2411 | 6.2282 | 6.2407 | 246708.0 |
| 2008-08-20 08:45:00 | AAPL | Stock | 6.2407 | 6.2407 | 6.2339 | 6.235 | 168700.0 |
| 2008-08-20 08:50:00 | AAPL | Stock | 6.235 | 6.2379 | 6.2321 | 6.2321 | 140560.0 |
| 2008-08-20 08:55:00 | AAPL | Stock | 6.2321 | 6.2321 | 6.2282 | 6.2282 | 25200.0 |
| 2008-08-20 09:00:00 | AAPL | Stock | 6.2286 | 6.2339 | 6.2264 | 6.2304 | 257572.0 |
| 2008-08-20 09:05:00 | AAPL | Stock | 6.2311 | 6.2332 | 6.23 | 6.2332 | 285544.0 |
| 2008-08-20 09:10:00 | AAPL | Stock | 6.2321 | 6.2404 | 6.2321 | 6.2382 | 208460.0 |
| 2008-08-20 09:15:00 | AAPL | Stock | 6.2361 | 6.2407 | 6.2325 | 6.2407 | 130116.0 |
| 2008-08-20 09:20:00 | AAPL | Stock | 6.2404 | 6.2411 | 6.2379 | 6.2393 | 116200.0 |
| 2008-08-20 09:25:00 | AAPL | Stock | 6.2382 | 6.2454 | 6.2371 | 6.2421 | 598388.0 |
| 2008-08-20 09:30:00 | AAPL | Stock | 6.2411 | 6.2657 | 6.237 | 6.2518 | 20000680.0 |
| 2008-08-20 09:35:00 | AAPL | Stock | 6.2532 | 6.2614 | 6.2446 | 6.2479 | 12513872.0 |
| 2008-08-20 09:40:00 | AAPL | Stock | 6.2479 | 6.2486 | 6.225 | 6.2418 | 12099528.0 |
| 2008-08-20 09:45:00 | AAPL | Stock | 6.2404 | 6.2571 | 6.2182 | 6.2307 | 13076252.0 |
| 2008-08-20 09:50:00 | AAPL | Stock | 6.2315 | 6.2586 | 6.2315 | 6.2532 | 11507804.0 |
| 2008-08-20 09:55:00 | AAPL | Stock | 6.2532 | 6.2693 | 6.2521 | 6.2629 | 8671852.0 |
| 2008-08-20 10:00:00 | AAPL | Stock | 6.2629 | 6.2629 | 6.2375 | 6.2475 | 8839488.0 |
| 2008-08-20 10:05:00 | AAPL | Stock | 6.2471 | 6.2632 | 6.2457 | 6.2625 | 6730948.0 |
| 2008-08-20 10:10:00 | AAPL | Stock | 6.2625 | 6.2846 | 6.2589 | 6.2796 | 13077652.0 |
| 2008-08-20 10:15:00 | AAPL | Stock | 6.2796 | 6.2939 | 6.2743 | 6.28 | 10966452.0 |
| 2008-08-20 10:20:00 | AAPL | Stock | 6.2786 | 6.2914 | 6.2743 | 6.2861 | 7299040.0 |
| 2008-08-20 10:25:00 | AAPL | Stock | 6.2857 | 6.2879 | 6.2586 | 6.2593 | 6939408.0 |
| 2008-08-20 10:30:00 | AAPL | Stock | 6.26 | 6.2746 | 6.2584 | 6.2732 | 4850244.0 |
| 2008-08-20 10:35:00 | AAPL | Stock | 6.2739 | 6.2939 | 6.2729 | 6.2829 | 10774764.0 |
| 2008-08-20 10:40:00 | AAPL | Stock | 6.2818 | 6.2871 | 6.2729 | 6.2811 | 6550740.0 |
| 2008-08-20 10:45:00 | AAPL | Stock | 6.2821 | 6.2911 | 6.2689 | 6.285 | 6997116.0 |
| 2008-08-20 10:50:00 | AAPL | Stock | 6.285 | 6.3096 | 6.2803 | 6.3068 | 11765488.0 |
| 2008-08-20 10:55:00 | AAPL | Stock | 6.3064 | 6.3193 | 6.2961 | 6.3111 | 12971700.0 |
| 2008-08-20 11:00:00 | AAPL | Stock | 6.3129 | 6.3157 | 6.2982 | 6.3013 | 6403516.0 |
| 2008-08-20 11:05:00 | AAPL | Stock | 6.3004 | 6.31 | 6.2982 | 6.3084 | 4025168.0 |
| 2008-08-20 11:10:00 | AAPL | Stock | 6.3086 | 6.3161 | 6.2957 | 6.2971 | 5867484.0 |
| 2008-08-20 11:15:00 | AAPL | Stock | 6.2975 | 6.3014 | 6.2925 | 6.2971 | 3387860.0 |
| 2008-08-20 11:20:00 | AAPL | Stock | 6.2964 | 6.3025 | 6.2929 | 6.3014 | 2417716.0 |
| 2008-08-20 11:25:00 | AAPL | Stock | 6.3011 | 6.3025 | 6.2839 | 6.2896 | 3906812.0 |
| 2008-08-20 11:30:00 | AAPL | Stock | 6.2889 | 6.29 | 6.2721 | 6.2764 | 6615616.0 |
| 2008-08-20 11:35:00 | AAPL | Stock | 6.2762 | 6.2779 | 6.2689 | 6.2746 | 3897124.0 |
| 2008-08-20 11:40:00 | AAPL | Stock | 6.2746 | 6.2789 | 6.2646 | 6.275 | 4616500.0 |
> showing 50 of 305,590 rows — these rows as CSV