PREVIEW / stock_1min / 2013-02-19
file: by_date/stock_1min/2013/2013-02-19.parquet size: 13.6 MB rows: 1,000,182 symbols: 2,827
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-19 04:00:00 | AAPL | Stock | 16.4589 | 16.4589 | 16.4589 | 16.4589 | 5600.0 |
| 2013-02-19 04:41:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 8400.0 |
| 2013-02-19 04:42:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 2800.0 |
| 2013-02-19 05:00:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.5071 | 16.5071 | 5600.0 |
| 2013-02-19 05:01:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5 | 16.5 | 14000.0 |
| 2013-02-19 05:02:00 | AAPL | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 9800.0 |
| 2013-02-19 05:32:00 | AAPL | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 13020.0 |
| 2013-02-19 06:02:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.5071 | 16.5071 | 7000.0 |
| 2013-02-19 06:04:00 | AAPL | Stock | 16.5071 | 16.5071 | 16.5071 | 16.5071 | 7280.0 |
| 2013-02-19 06:26:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 7056.0 |
| 2013-02-19 06:27:00 | AAPL | Stock | 16.5318 | 16.5354 | 16.5318 | 16.5354 | 6804.0 |
| 2013-02-19 06:37:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 2800.0 |
| 2013-02-19 06:38:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 2800.0 |
| 2013-02-19 06:40:00 | AAPL | Stock | 16.5111 | 16.5111 | 16.5089 | 16.5089 | 5600.0 |
| 2013-02-19 07:01:00 | AAPL | Stock | 16.5089 | 16.5089 | 16.5089 | 16.5089 | 16800.0 |
| 2013-02-19 07:02:00 | AAPL | Stock | 16.5171 | 16.5196 | 16.5171 | 16.5179 | 46172.0 |
| 2013-02-19 07:03:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 5208.0 |
| 2013-02-19 07:04:00 | AAPL | Stock | 16.5029 | 16.5029 | 16.5029 | 16.5029 | 5208.0 |
| 2013-02-19 07:06:00 | AAPL | Stock | 16.5064 | 16.5064 | 16.5064 | 16.5064 | 2800.0 |
| 2013-02-19 07:08:00 | AAPL | Stock | 16.5096 | 16.5096 | 16.5096 | 16.5096 | 2800.0 |
| 2013-02-19 07:09:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 9156.0 |
| 2013-02-19 07:10:00 | AAPL | Stock | 16.5268 | 16.5268 | 16.5268 | 16.5268 | 5600.0 |
| 2013-02-19 07:13:00 | AAPL | Stock | 16.5354 | 16.5357 | 16.5354 | 16.5357 | 25200.0 |
| 2013-02-19 07:14:00 | AAPL | Stock | 16.5464 | 16.5464 | 16.5464 | 16.5464 | 2800.0 |
| 2013-02-19 07:15:00 | AAPL | Stock | 16.5368 | 16.5464 | 16.5368 | 16.5464 | 8400.0 |
| 2013-02-19 07:16:00 | AAPL | Stock | 16.5429 | 16.5429 | 16.5429 | 16.5429 | 2800.0 |
| 2013-02-19 07:21:00 | AAPL | Stock | 16.5357 | 16.5357 | 16.5268 | 16.5268 | 12292.0 |
| 2013-02-19 07:24:00 | AAPL | Stock | 16.5286 | 16.53 | 16.5286 | 16.53 | 14000.0 |
| 2013-02-19 07:29:00 | AAPL | Stock | 16.5179 | 16.53 | 16.5179 | 16.53 | 30800.0 |
| 2013-02-19 07:30:00 | AAPL | Stock | 16.5304 | 16.5304 | 16.5179 | 16.5179 | 5600.0 |
| 2013-02-19 07:32:00 | AAPL | Stock | 16.5218 | 16.5218 | 16.5218 | 16.5218 | 2800.0 |
| 2013-02-19 07:33:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 2800.0 |
| 2013-02-19 07:36:00 | AAPL | Stock | 16.5304 | 16.5304 | 16.5304 | 16.5304 | 5600.0 |
| 2013-02-19 07:37:00 | AAPL | Stock | 16.5321 | 16.5321 | 16.5321 | 16.5321 | 2800.0 |
| 2013-02-19 07:38:00 | AAPL | Stock | 16.5346 | 16.5532 | 16.5336 | 16.5532 | 168840.0 |
| 2013-02-19 07:39:00 | AAPL | Stock | 16.5589 | 16.5621 | 16.5589 | 16.5621 | 22540.0 |
| 2013-02-19 07:40:00 | AAPL | Stock | 16.5618 | 16.5625 | 16.5375 | 16.5375 | 31472.0 |
| 2013-02-19 07:49:00 | AAPL | Stock | 16.5464 | 16.5464 | 16.5464 | 16.5464 | 2800.0 |
| 2013-02-19 07:50:00 | AAPL | Stock | 16.5432 | 16.5432 | 16.5429 | 16.5429 | 13720.0 |
| 2013-02-19 07:51:00 | AAPL | Stock | 16.5411 | 16.5411 | 16.5357 | 16.5357 | 81340.0 |
| 2013-02-19 07:52:00 | AAPL | Stock | 16.5407 | 16.5407 | 16.5407 | 16.5407 | 11200.0 |
| 2013-02-19 07:56:00 | AAPL | Stock | 16.5407 | 16.5511 | 16.5371 | 16.5396 | 22820.0 |
| 2013-02-19 07:57:00 | AAPL | Stock | 16.54 | 16.54 | 16.54 | 16.54 | 2800.0 |
| 2013-02-19 07:59:00 | AAPL | Stock | 16.5446 | 16.5532 | 16.5446 | 16.5532 | 30380.0 |
| 2013-02-19 08:00:00 | AAPL | Stock | 16.5493 | 16.5625 | 16.5 | 16.5179 | 260428.0 |
| 2013-02-19 08:01:00 | AAPL | Stock | 16.5214 | 16.5214 | 16.5179 | 16.5179 | 24024.0 |
| 2013-02-19 08:02:00 | AAPL | Stock | 16.5189 | 16.5271 | 16.5189 | 16.5271 | 11200.0 |
| 2013-02-19 08:03:00 | AAPL | Stock | 16.5243 | 16.5286 | 16.5243 | 16.5286 | 5600.0 |
| 2013-02-19 08:04:00 | AAPL | Stock | 16.5254 | 16.5254 | 16.5179 | 16.5182 | 36092.0 |
| 2013-02-19 08:05:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5125 | 16.5125 | 30800.0 |
> showing 50 of 1,000,182 rows — these rows as CSV