PREVIEW / stock_1min / 2010-06-28
file: by_date/stock_1min/2010/2010-06-28.parquet size: 13.0 MB rows: 1,010,004 symbols: 2,805
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-06-28 04:15:00 | AAPL | Stock | 9.5289 | 9.5289 | 9.5289 | 9.5289 | 2800.0 |
| 2010-06-28 04:31:00 | AAPL | Stock | 9.5646 | 9.5646 | 9.5646 | 9.5646 | 2800.0 |
| 2010-06-28 04:36:00 | AAPL | Stock | 9.5536 | 9.5536 | 9.5536 | 9.5536 | 2800.0 |
| 2010-06-28 05:08:00 | AAPL | Stock | 9.5571 | 9.5571 | 9.5571 | 9.5571 | 32760.0 |
| 2010-06-28 06:14:00 | AAPL | Stock | 9.5893 | 9.5893 | 9.5893 | 9.5893 | 10248.0 |
| 2010-06-28 06:18:00 | AAPL | Stock | 9.5893 | 9.5893 | 9.5893 | 9.5893 | 2800.0 |
| 2010-06-28 06:46:00 | AAPL | Stock | 9.5786 | 9.5786 | 9.5786 | 9.5786 | 2800.0 |
| 2010-06-28 06:50:00 | AAPL | Stock | 9.5786 | 9.5786 | 9.5786 | 9.5786 | 5544.0 |
| 2010-06-28 07:00:00 | AAPL | Stock | 9.5625 | 9.5625 | 9.5196 | 9.5196 | 32760.0 |
| 2010-06-28 07:04:00 | AAPL | Stock | 9.5536 | 9.5646 | 9.5536 | 9.5646 | 12600.0 |
| 2010-06-28 07:07:00 | AAPL | Stock | 9.5679 | 9.5679 | 9.5679 | 9.5679 | 2856.0 |
| 2010-06-28 07:09:00 | AAPL | Stock | 9.5679 | 9.5679 | 9.5679 | 9.5679 | 4200.0 |
| 2010-06-28 07:11:00 | AAPL | Stock | 9.5486 | 9.5486 | 9.5486 | 9.5486 | 2800.0 |
| 2010-06-28 07:14:00 | AAPL | Stock | 9.5625 | 9.5625 | 9.5625 | 9.5625 | 2800.0 |
| 2010-06-28 07:17:00 | AAPL | Stock | 9.5625 | 9.5625 | 9.5625 | 9.5625 | 6300.0 |
| 2010-06-28 07:28:00 | AAPL | Stock | 9.5629 | 9.5629 | 9.5629 | 9.5629 | 2800.0 |
| 2010-06-28 07:31:00 | AAPL | Stock | 9.5625 | 9.5625 | 9.5596 | 9.5596 | 11900.0 |
| 2010-06-28 07:34:00 | AAPL | Stock | 9.5536 | 9.5536 | 9.5536 | 9.5536 | 2800.0 |
| 2010-06-28 07:35:00 | AAPL | Stock | 9.5461 | 9.5461 | 9.5446 | 9.5446 | 27384.0 |
| 2010-06-28 07:38:00 | AAPL | Stock | 9.5475 | 9.5475 | 9.5475 | 9.5475 | 12936.0 |
| 2010-06-28 07:42:00 | AAPL | Stock | 9.5532 | 9.5618 | 9.5532 | 9.5618 | 14000.0 |
| 2010-06-28 07:43:00 | AAPL | Stock | 9.5618 | 9.5618 | 9.5618 | 9.5618 | 5600.0 |
| 2010-06-28 07:47:00 | AAPL | Stock | 9.5614 | 9.5614 | 9.5614 | 9.5614 | 2800.0 |
| 2010-06-28 07:49:00 | AAPL | Stock | 9.5618 | 9.5621 | 9.5614 | 9.5614 | 11200.0 |
| 2010-06-28 07:51:00 | AAPL | Stock | 9.5604 | 9.5604 | 9.5604 | 9.5604 | 2800.0 |
| 2010-06-28 07:53:00 | AAPL | Stock | 9.5571 | 9.5571 | 9.5571 | 9.5571 | 2800.0 |
| 2010-06-28 07:55:00 | AAPL | Stock | 9.5518 | 9.5518 | 9.5518 | 9.5518 | 2800.0 |
| 2010-06-28 07:56:00 | AAPL | Stock | 9.5518 | 9.5518 | 9.5518 | 9.5518 | 8400.0 |
| 2010-06-28 07:59:00 | AAPL | Stock | 9.5525 | 9.5525 | 9.5525 | 9.5525 | 14000.0 |
| 2010-06-28 08:00:00 | AAPL | Stock | 9.5521 | 9.5618 | 9.5439 | 9.5461 | 59696.0 |
| 2010-06-28 08:01:00 | AAPL | Stock | 9.5439 | 9.5532 | 9.5289 | 9.5357 | 65408.0 |
| 2010-06-28 08:02:00 | AAPL | Stock | 9.5304 | 9.5411 | 9.5304 | 9.5411 | 18144.0 |
| 2010-06-28 08:03:00 | AAPL | Stock | 9.5446 | 9.5482 | 9.5414 | 9.5482 | 29680.0 |
| 2010-06-28 08:04:00 | AAPL | Stock | 9.5429 | 9.55 | 9.5429 | 9.5493 | 34160.0 |
| 2010-06-28 08:05:00 | AAPL | Stock | 9.5468 | 9.5468 | 9.5461 | 9.5461 | 11200.0 |
| 2010-06-28 08:06:00 | AAPL | Stock | 9.5429 | 9.5429 | 9.5411 | 9.5411 | 16800.0 |
| 2010-06-28 08:07:00 | AAPL | Stock | 9.5411 | 9.5436 | 9.5359 | 9.5359 | 34160.0 |
| 2010-06-28 08:08:00 | AAPL | Stock | 9.5389 | 9.5439 | 9.5357 | 9.5404 | 134260.0 |
| 2010-06-28 08:09:00 | AAPL | Stock | 9.5389 | 9.5423 | 9.5321 | 9.5321 | 57960.0 |
| 2010-06-28 08:10:00 | AAPL | Stock | 9.5289 | 9.5293 | 9.5275 | 9.5275 | 22400.0 |
| 2010-06-28 08:11:00 | AAPL | Stock | 9.5293 | 9.5293 | 9.5179 | 9.5179 | 96152.0 |
| 2010-06-28 08:12:00 | AAPL | Stock | 9.52 | 9.5211 | 9.5086 | 9.5125 | 25760.0 |
| 2010-06-28 08:13:00 | AAPL | Stock | 9.5171 | 9.5179 | 9.5132 | 9.5179 | 16800.0 |
| 2010-06-28 08:14:00 | AAPL | Stock | 9.5214 | 9.525 | 9.5214 | 9.5214 | 45920.0 |
| 2010-06-28 08:15:00 | AAPL | Stock | 9.5214 | 9.5214 | 9.5107 | 9.5179 | 58380.0 |
| 2010-06-28 08:16:00 | AAPL | Stock | 9.5186 | 9.5186 | 9.5175 | 9.5179 | 25200.0 |
| 2010-06-28 08:17:00 | AAPL | Stock | 9.5179 | 9.5179 | 9.5179 | 9.5179 | 8120.0 |
| 2010-06-28 08:18:00 | AAPL | Stock | 9.525 | 9.525 | 9.5179 | 9.5179 | 11200.0 |
| 2010-06-28 08:19:00 | AAPL | Stock | 9.52 | 9.52 | 9.5175 | 9.5175 | 34440.0 |
| 2010-06-28 08:20:00 | AAPL | Stock | 9.5171 | 9.5179 | 9.515 | 9.5168 | 25200.0 |
> showing 50 of 1,010,004 rows — these rows as CSV