PREVIEW / stock_1min / 2010-07-12
file: by_date/stock_1min/2010/2010-07-12.parquet size: 11.7 MB rows: 900,657 symbols: 2,808
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-12 04:16:00 | AAPL | Stock | 9.2507 | 9.2507 | 9.2507 | 9.2507 | 5236.0 |
| 2010-07-12 04:27:00 | AAPL | Stock | 9.2286 | 9.2286 | 9.2286 | 9.2286 | 2800.0 |
| 2010-07-12 07:11:00 | AAPL | Stock | 9.245 | 9.245 | 9.2429 | 9.2429 | 27440.0 |
| 2010-07-12 07:17:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 2800.0 |
| 2010-07-12 07:25:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 2800.0 |
| 2010-07-12 07:44:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 2800.0 |
| 2010-07-12 07:51:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 2800.0 |
| 2010-07-12 07:52:00 | AAPL | Stock | 9.2571 | 9.2571 | 9.2571 | 9.2571 | 8400.0 |
| 2010-07-12 08:00:00 | AAPL | Stock | 9.2586 | 9.2643 | 9.25 | 9.2643 | 71372.0 |
| 2010-07-12 08:01:00 | AAPL | Stock | 9.26 | 9.26 | 9.2589 | 9.2589 | 35448.0 |
| 2010-07-12 08:02:00 | AAPL | Stock | 9.25 | 9.2564 | 9.25 | 9.2564 | 14000.0 |
| 2010-07-12 08:03:00 | AAPL | Stock | 9.2496 | 9.25 | 9.2496 | 9.25 | 16660.0 |
| 2010-07-12 08:05:00 | AAPL | Stock | 9.25 | 9.2536 | 9.25 | 9.2536 | 7560.0 |
| 2010-07-12 08:06:00 | AAPL | Stock | 9.25 | 9.25 | 9.25 | 9.25 | 3780.0 |
| 2010-07-12 08:07:00 | AAPL | Stock | 9.25 | 9.2536 | 9.25 | 9.2536 | 8400.0 |
| 2010-07-12 08:08:00 | AAPL | Stock | 9.2536 | 9.2579 | 9.245 | 9.2554 | 18200.0 |
| 2010-07-12 08:09:00 | AAPL | Stock | 9.2571 | 9.2571 | 9.2571 | 9.2571 | 2800.0 |
| 2010-07-12 08:12:00 | AAPL | Stock | 9.2586 | 9.2586 | 9.2571 | 9.2571 | 15400.0 |
| 2010-07-12 08:13:00 | AAPL | Stock | 9.2571 | 9.2571 | 9.2571 | 9.2571 | 5600.0 |
| 2010-07-12 08:14:00 | AAPL | Stock | 9.2571 | 9.2582 | 9.2539 | 9.2539 | 16800.0 |
| 2010-07-12 08:15:00 | AAPL | Stock | 9.2571 | 9.2571 | 9.2571 | 9.2571 | 2800.0 |
| 2010-07-12 08:17:00 | AAPL | Stock | 9.2539 | 9.2539 | 9.2536 | 9.2536 | 31080.0 |
| 2010-07-12 08:18:00 | AAPL | Stock | 9.2543 | 9.2543 | 9.25 | 9.25 | 14000.0 |
| 2010-07-12 08:19:00 | AAPL | Stock | 9.2496 | 9.2496 | 9.2482 | 9.2482 | 18368.0 |
| 2010-07-12 08:22:00 | AAPL | Stock | 9.2482 | 9.2554 | 9.2482 | 9.2554 | 14000.0 |
| 2010-07-12 08:25:00 | AAPL | Stock | 9.2525 | 9.2554 | 9.2525 | 9.2554 | 33600.0 |
| 2010-07-12 08:27:00 | AAPL | Stock | 9.255 | 9.255 | 9.255 | 9.255 | 2800.0 |
| 2010-07-12 08:28:00 | AAPL | Stock | 9.2557 | 9.2557 | 9.2557 | 9.2557 | 2800.0 |
| 2010-07-12 08:29:00 | AAPL | Stock | 9.2546 | 9.2561 | 9.2546 | 9.2546 | 33600.0 |
| 2010-07-12 08:32:00 | AAPL | Stock | 9.2514 | 9.2514 | 9.2514 | 9.2514 | 5600.0 |
| 2010-07-12 08:33:00 | AAPL | Stock | 9.2521 | 9.2521 | 9.2518 | 9.2518 | 5600.0 |
| 2010-07-12 08:35:00 | AAPL | Stock | 9.2536 | 9.2536 | 9.2536 | 9.2536 | 5600.0 |
| 2010-07-12 08:37:00 | AAPL | Stock | 9.2557 | 9.2561 | 9.2557 | 9.2561 | 8120.0 |
| 2010-07-12 08:38:00 | AAPL | Stock | 9.2546 | 9.2546 | 9.2546 | 9.2546 | 2800.0 |
| 2010-07-12 08:40:00 | AAPL | Stock | 9.2757 | 9.2757 | 9.2757 | 9.2757 | 27188.0 |
| 2010-07-12 08:41:00 | AAPL | Stock | 9.2546 | 9.2546 | 9.2546 | 9.2546 | 2800.0 |
| 2010-07-12 08:42:00 | AAPL | Stock | 9.2568 | 9.2568 | 9.2568 | 9.2568 | 5600.0 |
| 2010-07-12 08:43:00 | AAPL | Stock | 9.2571 | 9.2639 | 9.2571 | 9.2636 | 91980.0 |
| 2010-07-12 08:44:00 | AAPL | Stock | 9.2607 | 9.2668 | 9.2607 | 9.2664 | 51240.0 |
| 2010-07-12 08:45:00 | AAPL | Stock | 9.2654 | 9.2661 | 9.2654 | 9.2661 | 8400.0 |
| 2010-07-12 08:46:00 | AAPL | Stock | 9.2657 | 9.2671 | 9.2657 | 9.2671 | 30184.0 |
| 2010-07-12 08:47:00 | AAPL | Stock | 9.2671 | 9.27 | 9.2671 | 9.27 | 20496.0 |
| 2010-07-12 08:48:00 | AAPL | Stock | 9.2711 | 9.2729 | 9.2711 | 9.2714 | 8400.0 |
| 2010-07-12 08:49:00 | AAPL | Stock | 9.275 | 9.2818 | 9.275 | 9.275 | 33600.0 |
| 2010-07-12 08:50:00 | AAPL | Stock | 9.2764 | 9.2818 | 9.2764 | 9.2793 | 39200.0 |
| 2010-07-12 08:51:00 | AAPL | Stock | 9.2729 | 9.2729 | 9.2714 | 9.2714 | 14000.0 |
| 2010-07-12 08:52:00 | AAPL | Stock | 9.2743 | 9.2743 | 9.2718 | 9.2718 | 5600.0 |
| 2010-07-12 08:53:00 | AAPL | Stock | 9.2764 | 9.2764 | 9.275 | 9.275 | 14000.0 |
| 2010-07-12 08:54:00 | AAPL | Stock | 9.275 | 9.275 | 9.275 | 9.275 | 19600.0 |
| 2010-07-12 08:55:00 | AAPL | Stock | 9.2696 | 9.2696 | 9.2696 | 9.2696 | 2800.0 |
> showing 50 of 900,657 rows — these rows as CSV