PREVIEW / stock_1min / 2008-09-08
file: by_date/stock_1min/2008/2008-09-08.parquet size: 12.9 MB rows: 1,035,391 symbols: 2,701
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-09-08 04:15:00 | AAPL | Stock | 5.78 | 5.78 | 5.78 | 5.78 | 2800.0 |
| 2008-09-08 06:52:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 32200.0 |
| 2008-09-08 06:53:00 | AAPL | Stock | 5.8643 | 5.8643 | 5.8643 | 5.8643 | 2800.0 |
| 2008-09-08 06:55:00 | AAPL | Stock | 5.8643 | 5.875 | 5.8643 | 5.875 | 29484.0 |
| 2008-09-08 07:01:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.875 | 5.875 | 56000.0 |
| 2008-09-08 07:04:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 11116.0 |
| 2008-09-08 07:06:00 | AAPL | Stock | 5.8732 | 5.8732 | 5.8661 | 5.8661 | 12600.0 |
| 2008-09-08 07:12:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 56000.0 |
| 2008-09-08 07:13:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 26600.0 |
| 2008-09-08 07:16:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8429 | 5.8429 | 32060.0 |
| 2008-09-08 07:18:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 28000.0 |
| 2008-09-08 07:20:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 2800.0 |
| 2008-09-08 07:21:00 | AAPL | Stock | 5.8571 | 5.875 | 5.8571 | 5.8571 | 17780.0 |
| 2008-09-08 07:22:00 | AAPL | Stock | 5.8571 | 5.8839 | 5.8571 | 5.8571 | 56000.0 |
| 2008-09-08 07:26:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8482 | 5.8482 | 44800.0 |
| 2008-09-08 07:29:00 | AAPL | Stock | 5.8482 | 5.8482 | 5.8482 | 5.8482 | 5600.0 |
| 2008-09-08 07:30:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 5600.0 |
| 2008-09-08 07:31:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 13720.0 |
| 2008-09-08 07:32:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 28000.0 |
| 2008-09-08 07:33:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.855 | 5.8554 | 70000.0 |
| 2008-09-08 07:37:00 | AAPL | Stock | 5.8429 | 5.8429 | 5.8429 | 5.8429 | 12404.0 |
| 2008-09-08 07:41:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 39200.0 |
| 2008-09-08 07:44:00 | AAPL | Stock | 5.8446 | 5.8446 | 5.8446 | 5.8446 | 14000.0 |
| 2008-09-08 07:47:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8464 | 5.8464 | 2800.0 |
| 2008-09-08 07:52:00 | AAPL | Stock | 5.8568 | 5.8571 | 5.8568 | 5.8571 | 19544.0 |
| 2008-09-08 07:53:00 | AAPL | Stock | 5.8464 | 5.8464 | 5.8454 | 5.8454 | 8400.0 |
| 2008-09-08 07:54:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 58800.0 |
| 2008-09-08 07:55:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 2800.0 |
| 2008-09-08 07:56:00 | AAPL | Stock | 5.85 | 5.85 | 5.85 | 5.85 | 2800.0 |
| 2008-09-08 07:57:00 | AAPL | Stock | 5.8571 | 5.8643 | 5.8571 | 5.8643 | 80752.0 |
| 2008-09-08 07:59:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 5600.0 |
| 2008-09-08 08:00:00 | AAPL | Stock | 5.8571 | 5.8639 | 5.845 | 5.8571 | 258160.0 |
| 2008-09-08 08:01:00 | AAPL | Stock | 5.8571 | 5.8625 | 5.8571 | 5.8618 | 184100.0 |
| 2008-09-08 08:02:00 | AAPL | Stock | 5.8571 | 5.8625 | 5.8571 | 5.8625 | 55272.0 |
| 2008-09-08 08:03:00 | AAPL | Stock | 5.8643 | 5.8643 | 5.8643 | 5.8643 | 11200.0 |
| 2008-09-08 08:04:00 | AAPL | Stock | 5.8643 | 5.8714 | 5.8607 | 5.8625 | 25200.0 |
| 2008-09-08 08:05:00 | AAPL | Stock | 5.8575 | 5.8589 | 5.8571 | 5.8586 | 35588.0 |
| 2008-09-08 08:06:00 | AAPL | Stock | 5.8614 | 5.8614 | 5.8586 | 5.8604 | 20160.0 |
| 2008-09-08 08:07:00 | AAPL | Stock | 5.8593 | 5.8604 | 5.8571 | 5.8571 | 89488.0 |
| 2008-09-08 08:08:00 | AAPL | Stock | 5.8557 | 5.8582 | 5.8554 | 5.8582 | 64400.0 |
| 2008-09-08 08:09:00 | AAPL | Stock | 5.8589 | 5.8589 | 5.8529 | 5.8536 | 135940.0 |
| 2008-09-08 08:10:00 | AAPL | Stock | 5.8504 | 5.8504 | 5.8429 | 5.8429 | 166040.0 |
| 2008-09-08 08:11:00 | AAPL | Stock | 5.8496 | 5.8536 | 5.8489 | 5.8536 | 444360.0 |
| 2008-09-08 08:12:00 | AAPL | Stock | 5.8554 | 5.8571 | 5.8543 | 5.8543 | 122360.0 |
| 2008-09-08 08:13:00 | AAPL | Stock | 5.8543 | 5.8571 | 5.8543 | 5.8571 | 101920.0 |
| 2008-09-08 08:14:00 | AAPL | Stock | 5.8571 | 5.8607 | 5.8571 | 5.8571 | 76328.0 |
| 2008-09-08 08:15:00 | AAPL | Stock | 5.8571 | 5.8604 | 5.8554 | 5.8554 | 50400.0 |
| 2008-09-08 08:16:00 | AAPL | Stock | 5.8571 | 5.8614 | 5.8571 | 5.8614 | 119476.0 |
| 2008-09-08 08:17:00 | AAPL | Stock | 5.8618 | 5.8714 | 5.8618 | 5.8646 | 60200.0 |
| 2008-09-08 08:18:00 | AAPL | Stock | 5.8643 | 5.865 | 5.8607 | 5.8607 | 116760.0 |
> showing 50 of 1,035,391 rows — these rows as CSV