PREVIEW / stock_1min / 2008-03-27
file: by_date/stock_1min/2008/2008-03-27.parquet size: 12.2 MB rows: 988,702 symbols: 2,676
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-03-27 06:16:00 | AAPL | Stock | 5.1775 | 5.1775 | 5.1775 | 5.1775 | 3976.0 |
| 2008-03-27 06:22:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 2800.0 |
| 2008-03-27 06:28:00 | AAPL | Stock | 5.1714 | 5.1714 | 5.1639 | 5.1639 | 16800.0 |
| 2008-03-27 06:30:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1489 | 5.1489 | 100800.0 |
| 2008-03-27 06:35:00 | AAPL | Stock | 5.1489 | 5.1489 | 5.1489 | 5.1489 | 2800.0 |
| 2008-03-27 06:37:00 | AAPL | Stock | 5.1379 | 5.1379 | 5.1375 | 5.1375 | 16800.0 |
| 2008-03-27 06:46:00 | AAPL | Stock | 5.1457 | 5.1489 | 5.1457 | 5.1489 | 16800.0 |
| 2008-03-27 06:47:00 | AAPL | Stock | 5.1489 | 5.1489 | 5.1489 | 5.1489 | 2800.0 |
| 2008-03-27 07:00:00 | AAPL | Stock | 5.1489 | 5.1518 | 5.1489 | 5.1518 | 5600.0 |
| 2008-03-27 07:02:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 2800.0 |
| 2008-03-27 07:03:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 15400.0 |
| 2008-03-27 07:04:00 | AAPL | Stock | 5.1482 | 5.1482 | 5.1482 | 5.1482 | 28000.0 |
| 2008-03-27 07:08:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 30800.0 |
| 2008-03-27 07:09:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 5600.0 |
| 2008-03-27 07:12:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 8400.0 |
| 2008-03-27 07:13:00 | AAPL | Stock | 5.1518 | 5.1518 | 5.1518 | 5.1518 | 29540.0 |
| 2008-03-27 07:14:00 | AAPL | Stock | 5.1639 | 5.1639 | 5.1518 | 5.1518 | 42000.0 |
| 2008-03-27 07:17:00 | AAPL | Stock | 5.1589 | 5.1589 | 5.1589 | 5.1589 | 2800.0 |
| 2008-03-27 07:20:00 | AAPL | Stock | 5.1586 | 5.1589 | 5.1586 | 5.1589 | 16800.0 |
| 2008-03-27 07:21:00 | AAPL | Stock | 5.1639 | 5.1639 | 5.1639 | 5.1639 | 5600.0 |
| 2008-03-27 07:22:00 | AAPL | Stock | 5.1696 | 5.1714 | 5.1696 | 5.1714 | 37940.0 |
| 2008-03-27 07:27:00 | AAPL | Stock | 5.1696 | 5.1696 | 5.1696 | 5.1696 | 63840.0 |
| 2008-03-27 07:29:00 | AAPL | Stock | 5.1646 | 5.1646 | 5.1646 | 5.1646 | 7000.0 |
| 2008-03-27 07:30:00 | AAPL | Stock | 5.1643 | 5.1643 | 5.1607 | 5.1607 | 39200.0 |
| 2008-03-27 07:37:00 | AAPL | Stock | 5.1536 | 5.1536 | 5.1507 | 5.1507 | 13132.0 |
| 2008-03-27 07:38:00 | AAPL | Stock | 5.1536 | 5.1536 | 5.1536 | 5.1536 | 56000.0 |
| 2008-03-27 07:40:00 | AAPL | Stock | 5.15 | 5.15 | 5.15 | 5.15 | 69776.0 |
| 2008-03-27 07:42:00 | AAPL | Stock | 5.15 | 5.1554 | 5.15 | 5.1554 | 29456.0 |
| 2008-03-27 07:45:00 | AAPL | Stock | 5.1554 | 5.1571 | 5.1554 | 5.1554 | 33600.0 |
| 2008-03-27 07:46:00 | AAPL | Stock | 5.1504 | 5.1504 | 5.1504 | 5.1504 | 3416.0 |
| 2008-03-27 07:48:00 | AAPL | Stock | 5.1504 | 5.1504 | 5.15 | 5.15 | 44800.0 |
| 2008-03-27 07:49:00 | AAPL | Stock | 5.15 | 5.15 | 5.15 | 5.15 | 5600.0 |
| 2008-03-27 07:51:00 | AAPL | Stock | 5.1582 | 5.1582 | 5.1582 | 5.1582 | 5600.0 |
| 2008-03-27 07:53:00 | AAPL | Stock | 5.1582 | 5.1582 | 5.1582 | 5.1582 | 5600.0 |
| 2008-03-27 07:55:00 | AAPL | Stock | 5.1507 | 5.1507 | 5.1507 | 5.1507 | 6776.0 |
| 2008-03-27 08:00:00 | AAPL | Stock | 5.15 | 5.15 | 5.1407 | 5.1407 | 330568.0 |
| 2008-03-27 08:01:00 | AAPL | Stock | 5.1375 | 5.1375 | 5.1375 | 5.1375 | 5376.0 |
| 2008-03-27 08:02:00 | AAPL | Stock | 5.1425 | 5.1425 | 5.1375 | 5.1375 | 68880.0 |
| 2008-03-27 08:03:00 | AAPL | Stock | 5.1375 | 5.1393 | 5.1332 | 5.1339 | 50456.0 |
| 2008-03-27 08:04:00 | AAPL | Stock | 5.1321 | 5.1321 | 5.1321 | 5.1321 | 27300.0 |
| 2008-03-27 08:05:00 | AAPL | Stock | 5.1336 | 5.1336 | 5.1289 | 5.1289 | 25200.0 |
| 2008-03-27 08:06:00 | AAPL | Stock | 5.1286 | 5.1289 | 5.1264 | 5.1286 | 49000.0 |
| 2008-03-27 08:07:00 | AAPL | Stock | 5.1261 | 5.1329 | 5.125 | 5.13 | 81928.0 |
| 2008-03-27 08:08:00 | AAPL | Stock | 5.1321 | 5.1357 | 5.1321 | 5.1357 | 21000.0 |
| 2008-03-27 08:10:00 | AAPL | Stock | 5.1339 | 5.1357 | 5.1339 | 5.135 | 17304.0 |
| 2008-03-27 08:11:00 | AAPL | Stock | 5.135 | 5.135 | 5.135 | 5.135 | 4536.0 |
| 2008-03-27 08:12:00 | AAPL | Stock | 5.1368 | 5.1375 | 5.1343 | 5.1343 | 21532.0 |
| 2008-03-27 08:13:00 | AAPL | Stock | 5.1339 | 5.1339 | 5.1339 | 5.1339 | 3640.0 |
| 2008-03-27 08:16:00 | AAPL | Stock | 5.1375 | 5.1375 | 5.1357 | 5.1357 | 10136.0 |
| 2008-03-27 08:18:00 | AAPL | Stock | 5.1379 | 5.1429 | 5.1379 | 5.1386 | 30688.0 |
> showing 50 of 988,702 rows — these rows as CSV