PREVIEW / stock_5min / 2008-02-25
file: by_date/stock_5min/2008/2008-02-25.parquet size: 4.4 MB rows: 318,830 symbols: 3,266
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-02-25 04:15:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 5600.0 |
| 2008-02-25 05:45:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.285 | 4.285 | 14000.0 |
| 2008-02-25 05:50:00 | AAPL | Stock | 4.285 | 4.285 | 4.2829 | 4.2832 | 19180.0 |
| 2008-02-25 05:55:00 | AAPL | Stock | 4.2854 | 4.2854 | 4.2836 | 4.2836 | 5600.0 |
| 2008-02-25 06:10:00 | AAPL | Stock | 4.2804 | 4.2804 | 4.2804 | 4.2804 | 11200.0 |
| 2008-02-25 06:15:00 | AAPL | Stock | 4.2775 | 4.2775 | 4.2718 | 4.2718 | 11200.0 |
| 2008-02-25 06:50:00 | AAPL | Stock | 4.2793 | 4.2857 | 4.2789 | 4.2857 | 16800.0 |
| 2008-02-25 07:20:00 | AAPL | Stock | 4.2789 | 4.2789 | 4.2789 | 4.2789 | 2800.0 |
| 2008-02-25 07:25:00 | AAPL | Stock | 4.2811 | 4.2811 | 4.2804 | 4.2804 | 5600.0 |
| 2008-02-25 07:30:00 | AAPL | Stock | 4.2782 | 4.2786 | 4.2782 | 4.2786 | 14000.0 |
| 2008-02-25 07:35:00 | AAPL | Stock | 4.2682 | 4.2682 | 4.2682 | 4.2682 | 5600.0 |
| 2008-02-25 07:40:00 | AAPL | Stock | 4.2732 | 4.2732 | 4.2732 | 4.2732 | 5600.0 |
| 2008-02-25 07:45:00 | AAPL | Stock | 4.2732 | 4.2732 | 4.2643 | 4.2643 | 168000.0 |
| 2008-02-25 07:50:00 | AAPL | Stock | 4.2643 | 4.2643 | 4.2571 | 4.2571 | 47600.0 |
| 2008-02-25 07:55:00 | AAPL | Stock | 4.2571 | 4.2571 | 4.2571 | 4.2571 | 2800.0 |
| 2008-02-25 08:00:00 | AAPL | Stock | 4.2732 | 4.2732 | 4.2446 | 4.2464 | 689948.0 |
| 2008-02-25 08:05:00 | AAPL | Stock | 4.2464 | 4.2486 | 4.24 | 4.2446 | 694400.0 |
| 2008-02-25 08:10:00 | AAPL | Stock | 4.2446 | 4.2446 | 4.2371 | 4.2429 | 835940.0 |
| 2008-02-25 08:15:00 | AAPL | Stock | 4.24 | 4.2439 | 4.2375 | 4.2439 | 348600.0 |
| 2008-02-25 08:20:00 | AAPL | Stock | 4.2414 | 4.2414 | 4.2304 | 4.2321 | 802424.0 |
| 2008-02-25 08:25:00 | AAPL | Stock | 4.2307 | 4.2407 | 4.225 | 4.2375 | 788200.0 |
| 2008-02-25 08:30:00 | AAPL | Stock | 4.2361 | 4.2361 | 4.2304 | 4.2321 | 231140.0 |
| 2008-02-25 08:35:00 | AAPL | Stock | 4.2346 | 4.2404 | 4.2346 | 4.2346 | 135240.0 |
| 2008-02-25 08:40:00 | AAPL | Stock | 4.2361 | 4.2393 | 4.2339 | 4.2371 | 344680.0 |
| 2008-02-25 08:45:00 | AAPL | Stock | 4.2354 | 4.2411 | 4.2354 | 4.2407 | 208600.0 |
| 2008-02-25 08:50:00 | AAPL | Stock | 4.2375 | 4.24 | 4.2375 | 4.2393 | 186480.0 |
| 2008-02-25 08:55:00 | AAPL | Stock | 4.2389 | 4.2393 | 4.2375 | 4.2375 | 136360.0 |
| 2008-02-25 09:00:00 | AAPL | Stock | 4.2375 | 4.2389 | 4.2371 | 4.2371 | 179368.0 |
| 2008-02-25 09:05:00 | AAPL | Stock | 4.2371 | 4.2414 | 4.2371 | 4.2393 | 231112.0 |
| 2008-02-25 09:10:00 | AAPL | Stock | 4.24 | 4.245 | 4.2389 | 4.2414 | 254548.0 |
| 2008-02-25 09:15:00 | AAPL | Stock | 4.2414 | 4.2439 | 4.2411 | 4.2411 | 340088.0 |
| 2008-02-25 09:20:00 | AAPL | Stock | 4.2404 | 4.2411 | 4.2371 | 4.2371 | 181860.0 |
| 2008-02-25 09:25:00 | AAPL | Stock | 4.2371 | 4.2375 | 4.2339 | 4.2361 | 1106560.0 |
| 2008-02-25 09:30:00 | AAPL | Stock | 4.2354 | 4.2775 | 4.2321 | 4.2711 | 35422268.0 |
| 2008-02-25 09:35:00 | AAPL | Stock | 4.2707 | 4.2918 | 4.2393 | 4.2703 | 35987196.0 |
| 2008-02-25 09:40:00 | AAPL | Stock | 4.2711 | 4.2911 | 4.2593 | 4.2679 | 25793572.0 |
| 2008-02-25 09:45:00 | AAPL | Stock | 4.2679 | 4.2679 | 4.2468 | 4.2514 | 20422024.0 |
| 2008-02-25 09:50:00 | AAPL | Stock | 4.2521 | 4.2582 | 4.235 | 4.2507 | 20707596.0 |
| 2008-02-25 09:55:00 | AAPL | Stock | 4.2504 | 4.2511 | 4.2029 | 4.2036 | 30083928.0 |
| 2008-02-25 10:00:00 | AAPL | Stock | 4.2036 | 4.2232 | 4.185 | 4.2011 | 40333048.0 |
| 2008-02-25 10:05:00 | AAPL | Stock | 4.2011 | 4.2139 | 4.1946 | 4.2107 | 27436724.0 |
| 2008-02-25 10:10:00 | AAPL | Stock | 4.2114 | 4.2236 | 4.2004 | 4.2111 | 23389436.0 |
| 2008-02-25 10:15:00 | AAPL | Stock | 4.2114 | 4.2443 | 4.2111 | 4.2379 | 26702116.0 |
| 2008-02-25 10:20:00 | AAPL | Stock | 4.2379 | 4.2536 | 4.2293 | 4.2429 | 23243472.0 |
| 2008-02-25 10:25:00 | AAPL | Stock | 4.2429 | 4.2675 | 4.2418 | 4.2643 | 24353756.0 |
| 2008-02-25 10:30:00 | AAPL | Stock | 4.2642 | 4.2707 | 4.2536 | 4.2539 | 20909504.0 |
| 2008-02-25 10:35:00 | AAPL | Stock | 4.2543 | 4.2736 | 4.2521 | 4.2589 | 12906740.0 |
| 2008-02-25 10:40:00 | AAPL | Stock | 4.2589 | 4.2639 | 4.2395 | 4.25 | 14395416.0 |
| 2008-02-25 10:45:00 | AAPL | Stock | 4.2496 | 4.2621 | 4.245 | 4.2554 | 23839004.0 |
| 2008-02-25 10:50:00 | AAPL | Stock | 4.2558 | 4.2646 | 4.2343 | 4.2382 | 17314668.0 |
> showing 50 of 318,830 rows — these rows as CSV