PREVIEW / stock_1min / 2008-02-25
file: by_date/stock_1min/2008/2008-02-25.parquet size: 12.5 MB rows: 1,014,895 symbols: 2,669
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:17:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 5600.0 |
| 2008-02-25 05:47:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.285 | 4.285 | 14000.0 |
| 2008-02-25 05:52:00 | AAPL | Stock | 4.285 | 4.285 | 4.2829 | 4.2829 | 16380.0 |
| 2008-02-25 05:53:00 | AAPL | Stock | 4.2832 | 4.2832 | 4.2832 | 4.2832 | 2800.0 |
| 2008-02-25 05:59: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:18:00 | AAPL | Stock | 4.2775 | 4.2775 | 4.2718 | 4.2718 | 11200.0 |
| 2008-02-25 06:51: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.2811 | 4.2811 | 2800.0 |
| 2008-02-25 07:28:00 | AAPL | Stock | 4.2804 | 4.2804 | 4.2804 | 4.2804 | 2800.0 |
| 2008-02-25 07:33:00 | AAPL | Stock | 4.2782 | 4.2786 | 4.2782 | 4.2786 | 11200.0 |
| 2008-02-25 07:34:00 | AAPL | Stock | 4.2786 | 4.2786 | 4.2786 | 4.2786 | 2800.0 |
| 2008-02-25 07:37:00 | AAPL | Stock | 4.2682 | 4.2682 | 4.2682 | 4.2682 | 5600.0 |
| 2008-02-25 07:43: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.27 | 4.27 | 16800.0 |
| 2008-02-25 07:46:00 | AAPL | Stock | 4.2714 | 4.2714 | 4.2661 | 4.2661 | 145600.0 |
| 2008-02-25 07:49:00 | AAPL | Stock | 4.2643 | 4.2643 | 4.2643 | 4.2643 | 5600.0 |
| 2008-02-25 07:50:00 | AAPL | Stock | 4.2643 | 4.2643 | 4.2621 | 4.2625 | 14000.0 |
| 2008-02-25 07:51:00 | AAPL | Stock | 4.2625 | 4.2625 | 4.2625 | 4.2625 | 8400.0 |
| 2008-02-25 07:53:00 | AAPL | Stock | 4.2607 | 4.2607 | 4.2604 | 4.2604 | 19600.0 |
| 2008-02-25 07:54:00 | AAPL | Stock | 4.2575 | 4.2575 | 4.2571 | 4.2571 | 5600.0 |
| 2008-02-25 07:58: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.2571 | 4.2643 | 172144.0 |
| 2008-02-25 08:01:00 | AAPL | Stock | 4.2607 | 4.2607 | 4.2554 | 4.2554 | 78400.0 |
| 2008-02-25 08:02:00 | AAPL | Stock | 4.2554 | 4.2571 | 4.2536 | 4.2571 | 102200.0 |
| 2008-02-25 08:03:00 | AAPL | Stock | 4.2536 | 4.255 | 4.2446 | 4.2464 | 217588.0 |
| 2008-02-25 08:04:00 | AAPL | Stock | 4.2457 | 4.2486 | 4.2457 | 4.2464 | 119616.0 |
| 2008-02-25 08:05:00 | AAPL | Stock | 4.2464 | 4.2464 | 4.2425 | 4.2429 | 196784.0 |
| 2008-02-25 08:06:00 | AAPL | Stock | 4.2429 | 4.2443 | 4.2411 | 4.2411 | 208600.0 |
| 2008-02-25 08:07:00 | AAPL | Stock | 4.2429 | 4.2443 | 4.24 | 4.2443 | 112000.0 |
| 2008-02-25 08:08:00 | AAPL | Stock | 4.2446 | 4.2468 | 4.2446 | 4.2468 | 142996.0 |
| 2008-02-25 08:09:00 | AAPL | Stock | 4.2486 | 4.2486 | 4.2446 | 4.2446 | 34020.0 |
| 2008-02-25 08:10:00 | AAPL | Stock | 4.2446 | 4.2446 | 4.2429 | 4.2429 | 225036.0 |
| 2008-02-25 08:11:00 | AAPL | Stock | 4.2425 | 4.2429 | 4.2411 | 4.2411 | 181300.0 |
| 2008-02-25 08:12:00 | AAPL | Stock | 4.24 | 4.2404 | 4.2393 | 4.2393 | 121800.0 |
| 2008-02-25 08:13:00 | AAPL | Stock | 4.2382 | 4.2414 | 4.2371 | 4.2404 | 181440.0 |
| 2008-02-25 08:14:00 | AAPL | Stock | 4.2414 | 4.2429 | 4.2414 | 4.2429 | 126364.0 |
| 2008-02-25 08:15:00 | AAPL | Stock | 4.24 | 4.24 | 4.2393 | 4.2393 | 50680.0 |
| 2008-02-25 08:16:00 | AAPL | Stock | 4.2396 | 4.2396 | 4.2382 | 4.2389 | 84000.0 |
| 2008-02-25 08:17:00 | AAPL | Stock | 4.2382 | 4.2382 | 4.2375 | 4.2375 | 105000.0 |
| 2008-02-25 08:18:00 | AAPL | Stock | 4.2393 | 4.2393 | 4.2382 | 4.2382 | 8400.0 |
| 2008-02-25 08:19:00 | AAPL | Stock | 4.2382 | 4.2439 | 4.2382 | 4.2439 | 100520.0 |
| 2008-02-25 08:20:00 | AAPL | Stock | 4.2414 | 4.2414 | 4.2393 | 4.2393 | 93100.0 |
| 2008-02-25 08:21:00 | AAPL | Stock | 4.2393 | 4.2393 | 4.2364 | 4.2364 | 148064.0 |
| 2008-02-25 08:22:00 | AAPL | Stock | 4.2375 | 4.2393 | 4.2357 | 4.2357 | 86520.0 |
| 2008-02-25 08:23:00 | AAPL | Stock | 4.2357 | 4.2393 | 4.2357 | 4.2393 | 68712.0 |
| 2008-02-25 08:24:00 | AAPL | Stock | 4.2393 | 4.2393 | 4.2304 | 4.2321 | 406028.0 |
| 2008-02-25 08:25:00 | AAPL | Stock | 4.2307 | 4.2325 | 4.2264 | 4.2296 | 233044.0 |
| 2008-02-25 08:26:00 | AAPL | Stock | 4.2304 | 4.2304 | 4.2293 | 4.2293 | 155400.0 |
> showing 50 of 1,014,895 rows — these rows as CSV