PREVIEW / stock_1min / 2008-07-14
file: by_date/stock_1min/2008/2008-07-14.parquet size: 12.7 MB rows: 1,022,026 symbols: 2,731
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-07-14 06:16:00 | AAPL | Stock | 6.225 | 6.225 | 6.225 | 6.225 | 2800.0 |
| 2008-07-14 06:41:00 | AAPL | Stock | 6.2246 | 6.225 | 6.2246 | 6.225 | 25200.0 |
| 2008-07-14 07:01:00 | AAPL | Stock | 6.2636 | 6.2639 | 6.2636 | 6.2636 | 36400.0 |
| 2008-07-14 07:06:00 | AAPL | Stock | 6.2443 | 6.2443 | 6.2443 | 6.2443 | 16800.0 |
| 2008-07-14 07:12:00 | AAPL | Stock | 6.2604 | 6.2639 | 6.2604 | 6.2639 | 114660.0 |
| 2008-07-14 07:13:00 | AAPL | Stock | 6.2607 | 6.2607 | 6.2607 | 6.2607 | 14000.0 |
| 2008-07-14 07:16:00 | AAPL | Stock | 6.2639 | 6.2643 | 6.2639 | 6.2643 | 50540.0 |
| 2008-07-14 07:19:00 | AAPL | Stock | 6.2768 | 6.2768 | 6.2768 | 6.2768 | 28000.0 |
| 2008-07-14 07:21:00 | AAPL | Stock | 6.2696 | 6.2696 | 6.2696 | 6.2696 | 19600.0 |
| 2008-07-14 07:24:00 | AAPL | Stock | 6.2714 | 6.2714 | 6.2714 | 6.2714 | 2800.0 |
| 2008-07-14 07:25:00 | AAPL | Stock | 6.2854 | 6.2857 | 6.2839 | 6.2857 | 134400.0 |
| 2008-07-14 07:29:00 | AAPL | Stock | 6.27 | 6.2964 | 6.27 | 6.2964 | 51800.0 |
| 2008-07-14 07:30:00 | AAPL | Stock | 6.2961 | 6.3007 | 6.2961 | 6.3007 | 19600.0 |
| 2008-07-14 07:32:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2964 | 6.2964 | 14000.0 |
| 2008-07-14 07:37:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2964 | 6.2964 | 14000.0 |
| 2008-07-14 07:39:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2964 | 6.2964 | 14000.0 |
| 2008-07-14 07:40:00 | AAPL | Stock | 6.2964 | 6.2964 | 6.2964 | 6.2964 | 2800.0 |
| 2008-07-14 07:41:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 3920.0 |
| 2008-07-14 07:43:00 | AAPL | Stock | 6.2857 | 6.3014 | 6.2857 | 6.3014 | 26880.0 |
| 2008-07-14 07:44:00 | AAPL | Stock | 6.2896 | 6.2896 | 6.2896 | 6.2896 | 50400.0 |
| 2008-07-14 07:45:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 28000.0 |
| 2008-07-14 07:46:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2857 | 6.2857 | 28000.0 |
| 2008-07-14 07:51:00 | AAPL | Stock | 6.2854 | 6.2854 | 6.2854 | 6.2854 | 5600.0 |
| 2008-07-14 07:52:00 | AAPL | Stock | 6.2854 | 6.2854 | 6.2854 | 6.2854 | 2800.0 |
| 2008-07-14 07:55:00 | AAPL | Stock | 6.285 | 6.285 | 6.2718 | 6.2718 | 106400.0 |
| 2008-07-14 08:00:00 | AAPL | Stock | 6.275 | 6.2786 | 6.2696 | 6.275 | 182616.0 |
| 2008-07-14 08:01:00 | AAPL | Stock | 6.2736 | 6.2736 | 6.2643 | 6.2675 | 148400.0 |
| 2008-07-14 08:02:00 | AAPL | Stock | 6.2643 | 6.2643 | 6.25 | 6.2589 | 131068.0 |
| 2008-07-14 08:03:00 | AAPL | Stock | 6.2586 | 6.2654 | 6.2586 | 6.2586 | 76020.0 |
| 2008-07-14 08:04:00 | AAPL | Stock | 6.2593 | 6.2643 | 6.2593 | 6.2643 | 6720.0 |
| 2008-07-14 08:05:00 | AAPL | Stock | 6.2654 | 6.2654 | 6.2596 | 6.2596 | 26880.0 |
| 2008-07-14 08:06:00 | AAPL | Stock | 6.2596 | 6.2596 | 6.2596 | 6.2596 | 8960.0 |
| 2008-07-14 08:07:00 | AAPL | Stock | 6.2596 | 6.2643 | 6.2596 | 6.2596 | 20104.0 |
| 2008-07-14 08:08:00 | AAPL | Stock | 6.2593 | 6.2593 | 6.2511 | 6.2511 | 54460.0 |
| 2008-07-14 08:09:00 | AAPL | Stock | 6.2561 | 6.2589 | 6.2514 | 6.2514 | 100100.0 |
| 2008-07-14 08:10:00 | AAPL | Stock | 6.2514 | 6.2589 | 6.2511 | 6.2589 | 136948.0 |
| 2008-07-14 08:11:00 | AAPL | Stock | 6.2589 | 6.2621 | 6.2554 | 6.2554 | 59500.0 |
| 2008-07-14 08:12:00 | AAPL | Stock | 6.2539 | 6.2539 | 6.2539 | 6.2539 | 2800.0 |
| 2008-07-14 08:13:00 | AAPL | Stock | 6.2536 | 6.2589 | 6.2536 | 6.2589 | 39508.0 |
| 2008-07-14 08:14:00 | AAPL | Stock | 6.255 | 6.2564 | 6.2518 | 6.2539 | 23520.0 |
| 2008-07-14 08:15:00 | AAPL | Stock | 6.2518 | 6.2518 | 6.2518 | 6.2518 | 8400.0 |
| 2008-07-14 08:16:00 | AAPL | Stock | 6.2539 | 6.2571 | 6.2536 | 6.2571 | 30800.0 |
| 2008-07-14 08:17:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2543 | 6.2571 | 16800.0 |
| 2008-07-14 08:18:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2571 | 6.2571 | 11200.0 |
| 2008-07-14 08:19:00 | AAPL | Stock | 6.2586 | 6.2589 | 6.2586 | 6.2589 | 16800.0 |
| 2008-07-14 08:20:00 | AAPL | Stock | 6.2564 | 6.2564 | 6.2557 | 6.2557 | 6384.0 |
| 2008-07-14 08:21:00 | AAPL | Stock | 6.2539 | 6.2557 | 6.2536 | 6.2557 | 58800.0 |
| 2008-07-14 08:22:00 | AAPL | Stock | 6.2571 | 6.2589 | 6.2571 | 6.2589 | 32620.0 |
| 2008-07-14 08:23:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2571 | 6.2571 | 8400.0 |
| 2008-07-14 08:24:00 | AAPL | Stock | 6.2571 | 6.2571 | 6.2571 | 6.2571 | 11200.0 |
> showing 50 of 1,022,026 rows — these rows as CSV