PREVIEW / stock_1min / 2009-04-02
file: by_date/stock_1min/2009/2009-04-02.parquet size: 13.7 MB rows: 1,039,217 symbols: 2,712
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-02 04:32:00 | AAPL | Stock | 3.9321 | 3.9321 | 3.9321 | 3.9321 | 2800.0 |
| 2009-04-02 05:06:00 | AAPL | Stock | 3.9321 | 3.9321 | 3.9321 | 3.9321 | 17248.0 |
| 2009-04-02 05:22:00 | AAPL | Stock | 3.9696 | 3.9696 | 3.9696 | 3.9696 | 2800.0 |
| 2009-04-02 05:36:00 | AAPL | Stock | 3.9779 | 3.9786 | 3.9779 | 3.9786 | 6300.0 |
| 2009-04-02 05:55:00 | AAPL | Stock | 3.9796 | 3.9796 | 3.9796 | 3.9796 | 9800.0 |
| 2009-04-02 06:02:00 | AAPL | Stock | 3.9582 | 3.9589 | 3.9582 | 3.9589 | 12600.0 |
| 2009-04-02 06:34:00 | AAPL | Stock | 3.965 | 3.965 | 3.965 | 3.965 | 2800.0 |
| 2009-04-02 06:44:00 | AAPL | Stock | 3.9821 | 3.9821 | 3.9821 | 3.9821 | 2800.0 |
| 2009-04-02 06:54:00 | AAPL | Stock | 3.965 | 3.965 | 3.965 | 3.965 | 2800.0 |
| 2009-04-02 06:59:00 | AAPL | Stock | 3.9646 | 3.9646 | 3.9646 | 3.9646 | 2800.0 |
| 2009-04-02 07:09:00 | AAPL | Stock | 3.9646 | 3.9646 | 3.9643 | 3.9643 | 8400.0 |
| 2009-04-02 07:32:00 | AAPL | Stock | 3.9546 | 3.9546 | 3.9546 | 3.9546 | 5600.0 |
| 2009-04-02 07:38:00 | AAPL | Stock | 3.9454 | 3.9454 | 3.9454 | 3.9454 | 28000.0 |
| 2009-04-02 07:39:00 | AAPL | Stock | 3.9375 | 3.9382 | 3.9375 | 3.9382 | 22400.0 |
| 2009-04-02 07:40:00 | AAPL | Stock | 3.9375 | 3.9375 | 3.9375 | 3.9375 | 5320.0 |
| 2009-04-02 07:45:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 2800.0 |
| 2009-04-02 07:50:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 7000.0 |
| 2009-04-02 07:52:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 2800.0 |
| 2009-04-02 07:53:00 | AAPL | Stock | 3.9514 | 3.9514 | 3.9514 | 3.9514 | 2800.0 |
| 2009-04-02 07:56:00 | AAPL | Stock | 3.9371 | 3.9371 | 3.9371 | 3.9371 | 2800.0 |
| 2009-04-02 08:00:00 | AAPL | Stock | 3.9411 | 3.9518 | 3.8818 | 3.9371 | 2021376.0 |
| 2009-04-02 08:01:00 | AAPL | Stock | 3.9489 | 3.9489 | 3.9464 | 3.9464 | 22400.0 |
| 2009-04-02 08:02:00 | AAPL | Stock | 3.9489 | 3.9489 | 3.9371 | 3.9371 | 31528.0 |
| 2009-04-02 08:03:00 | AAPL | Stock | 3.9393 | 3.9464 | 3.9393 | 3.9464 | 27300.0 |
| 2009-04-02 08:04:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9393 | 3.9393 | 83300.0 |
| 2009-04-02 08:05:00 | AAPL | Stock | 3.9429 | 3.9429 | 3.9429 | 3.9429 | 2800.0 |
| 2009-04-02 08:06:00 | AAPL | Stock | 3.9421 | 3.9429 | 3.9393 | 3.9393 | 76440.0 |
| 2009-04-02 08:07:00 | AAPL | Stock | 3.9429 | 3.9429 | 3.9418 | 3.9429 | 30240.0 |
| 2009-04-02 08:08:00 | AAPL | Stock | 3.9382 | 3.9382 | 3.9382 | 3.9382 | 13720.0 |
| 2009-04-02 08:09:00 | AAPL | Stock | 3.9411 | 3.9411 | 3.9382 | 3.9382 | 30800.0 |
| 2009-04-02 08:10:00 | AAPL | Stock | 3.9379 | 3.9379 | 3.9379 | 3.9379 | 15484.0 |
| 2009-04-02 08:11:00 | AAPL | Stock | 3.9382 | 3.9382 | 3.9371 | 3.9371 | 8400.0 |
| 2009-04-02 08:12:00 | AAPL | Stock | 3.9393 | 3.9393 | 3.9371 | 3.9371 | 22400.0 |
| 2009-04-02 08:13:00 | AAPL | Stock | 3.9382 | 3.9393 | 3.9364 | 3.9393 | 21000.0 |
| 2009-04-02 08:14:00 | AAPL | Stock | 3.9393 | 3.9393 | 3.9393 | 3.9393 | 32200.0 |
| 2009-04-02 08:15:00 | AAPL | Stock | 3.9393 | 3.9429 | 3.9393 | 3.9429 | 26040.0 |
| 2009-04-02 08:16:00 | AAPL | Stock | 3.9429 | 3.9464 | 3.9429 | 3.9464 | 59948.0 |
| 2009-04-02 08:18:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9457 | 3.9461 | 25200.0 |
| 2009-04-02 08:21:00 | AAPL | Stock | 3.9429 | 3.9429 | 3.9429 | 3.9429 | 8400.0 |
| 2009-04-02 08:24:00 | AAPL | Stock | 3.9425 | 3.9425 | 3.9425 | 3.9425 | 6748.0 |
| 2009-04-02 08:25:00 | AAPL | Stock | 3.9425 | 3.9432 | 3.9425 | 3.9432 | 12852.0 |
| 2009-04-02 08:26:00 | AAPL | Stock | 3.9429 | 3.9432 | 3.9429 | 3.9432 | 15708.0 |
| 2009-04-02 08:27:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9464 | 3.9464 | 110600.0 |
| 2009-04-02 08:28:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9464 | 3.9464 | 94640.0 |
| 2009-04-02 08:29:00 | AAPL | Stock | 3.9464 | 3.9464 | 3.9446 | 3.9446 | 39200.0 |
| 2009-04-02 08:30:00 | AAPL | Stock | 3.9439 | 3.9464 | 3.9439 | 3.9464 | 21000.0 |
| 2009-04-02 08:31:00 | AAPL | Stock | 3.9446 | 3.9446 | 3.9411 | 3.9411 | 167972.0 |
| 2009-04-02 08:32:00 | AAPL | Stock | 3.9411 | 3.9411 | 3.9411 | 3.9411 | 17696.0 |
| 2009-04-02 08:33:00 | AAPL | Stock | 3.9411 | 3.9421 | 3.9411 | 3.9411 | 19880.0 |
| 2009-04-02 08:34:00 | AAPL | Stock | 3.9411 | 3.9411 | 3.9375 | 3.9375 | 62216.0 |
> showing 50 of 1,039,217 rows — these rows as CSV