PREVIEW / stock_1min / 2013-04-04
file: by_date/stock_1min/2013/2013-04-04.parquet size: 13.0 MB rows: 959,086 symbols: 2,802
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-04-04 04:00:00 | AAPL | Stock | 15.4893 | 15.4893 | 15.4893 | 15.4893 | 8400.0 |
| 2013-04-04 05:20:00 | AAPL | Stock | 15.5 | 15.5 | 15.5 | 15.5 | 5600.0 |
| 2013-04-04 06:24:00 | AAPL | Stock | 15.5336 | 15.5336 | 15.5268 | 15.5268 | 16688.0 |
| 2013-04-04 06:31:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 5600.0 |
| 2013-04-04 06:50:00 | AAPL | Stock | 15.5343 | 15.5343 | 15.5343 | 15.5343 | 2800.0 |
| 2013-04-04 06:51:00 | AAPL | Stock | 15.5343 | 15.5343 | 15.5343 | 15.5343 | 2800.0 |
| 2013-04-04 06:52:00 | AAPL | Stock | 15.5343 | 15.5343 | 15.5343 | 15.5343 | 2800.0 |
| 2013-04-04 07:00:00 | AAPL | Stock | 15.5325 | 15.5325 | 15.5325 | 15.5325 | 7000.0 |
| 2013-04-04 07:07:00 | AAPL | Stock | 15.5357 | 15.5475 | 15.5354 | 15.5475 | 23996.0 |
| 2013-04-04 07:12:00 | AAPL | Stock | 15.5496 | 15.5496 | 15.5496 | 15.5496 | 5460.0 |
| 2013-04-04 07:14:00 | AAPL | Stock | 15.55 | 15.55 | 15.55 | 15.55 | 25200.0 |
| 2013-04-04 07:15:00 | AAPL | Stock | 15.5536 | 15.5607 | 15.5536 | 15.5607 | 30800.0 |
| 2013-04-04 07:18:00 | AAPL | Stock | 15.5607 | 15.5625 | 15.5375 | 15.5375 | 33600.0 |
| 2013-04-04 07:25:00 | AAPL | Stock | 15.5511 | 15.5536 | 15.5511 | 15.5536 | 18676.0 |
| 2013-04-04 07:26:00 | AAPL | Stock | 15.5543 | 15.5543 | 15.5543 | 15.5543 | 2800.0 |
| 2013-04-04 07:28:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 3360.0 |
| 2013-04-04 07:29:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 5600.0 |
| 2013-04-04 07:30:00 | AAPL | Stock | 15.5571 | 15.5571 | 15.5571 | 15.5571 | 2800.0 |
| 2013-04-04 07:35:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.5536 | 15.5536 | 17640.0 |
| 2013-04-04 07:36:00 | AAPL | Stock | 15.5532 | 15.5536 | 15.55 | 15.5536 | 10108.0 |
| 2013-04-04 07:42:00 | AAPL | Stock | 15.5321 | 15.55 | 15.5321 | 15.55 | 11648.0 |
| 2013-04-04 07:46:00 | AAPL | Stock | 15.5429 | 15.5429 | 15.5429 | 15.5429 | 2800.0 |
| 2013-04-04 07:47:00 | AAPL | Stock | 15.5321 | 15.5321 | 15.5321 | 15.5321 | 2800.0 |
| 2013-04-04 07:48:00 | AAPL | Stock | 15.5289 | 15.5289 | 15.5289 | 15.5289 | 2800.0 |
| 2013-04-04 07:49:00 | AAPL | Stock | 15.535 | 15.5354 | 15.535 | 15.5354 | 12796.0 |
| 2013-04-04 07:50:00 | AAPL | Stock | 15.525 | 15.525 | 15.525 | 15.525 | 11760.0 |
| 2013-04-04 07:52:00 | AAPL | Stock | 15.5271 | 15.5271 | 15.5271 | 15.5271 | 5600.0 |
| 2013-04-04 07:55:00 | AAPL | Stock | 15.5271 | 15.5271 | 15.5271 | 15.5271 | 11200.0 |
| 2013-04-04 07:57:00 | AAPL | Stock | 15.5271 | 15.5271 | 15.5271 | 15.5271 | 5600.0 |
| 2013-04-04 07:58:00 | AAPL | Stock | 15.5182 | 15.5182 | 15.5182 | 15.5182 | 2800.0 |
| 2013-04-04 08:00:00 | AAPL | Stock | 15.5343 | 15.5607 | 15.5175 | 15.5268 | 112056.0 |
| 2013-04-04 08:01:00 | AAPL | Stock | 15.5214 | 15.5225 | 15.5125 | 15.5125 | 14700.0 |
| 2013-04-04 08:02:00 | AAPL | Stock | 15.5179 | 15.5268 | 15.5125 | 15.5189 | 129640.0 |
| 2013-04-04 08:03:00 | AAPL | Stock | 15.525 | 15.525 | 15.5182 | 15.5182 | 22120.0 |
| 2013-04-04 08:04:00 | AAPL | Stock | 15.5232 | 15.5232 | 15.5143 | 15.5143 | 19600.0 |
| 2013-04-04 08:05:00 | AAPL | Stock | 15.5132 | 15.5139 | 15.3929 | 15.5107 | 81144.0 |
| 2013-04-04 08:06:00 | AAPL | Stock | 15.5079 | 15.5079 | 15.5071 | 15.5071 | 10920.0 |
| 2013-04-04 08:07:00 | AAPL | Stock | 15.5043 | 15.5043 | 15.4821 | 15.4821 | 111300.0 |
| 2013-04-04 08:08:00 | AAPL | Stock | 15.4811 | 15.4875 | 15.4811 | 15.4875 | 8120.0 |
| 2013-04-04 08:09:00 | AAPL | Stock | 15.4736 | 15.4818 | 15.4736 | 15.4768 | 16800.0 |
| 2013-04-04 08:10:00 | AAPL | Stock | 15.4857 | 15.4911 | 15.4857 | 15.49 | 10920.0 |
| 2013-04-04 08:11:00 | AAPL | Stock | 15.49 | 15.5 | 15.485 | 15.5 | 30520.0 |
| 2013-04-04 08:12:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.4904 | 15.4904 | 5600.0 |
| 2013-04-04 08:13:00 | AAPL | Stock | 15.5 | 15.5 | 15.5 | 15.5 | 5600.0 |
| 2013-04-04 08:14:00 | AAPL | Stock | 15.5057 | 15.5079 | 15.4993 | 15.4993 | 40572.0 |
| 2013-04-04 08:15:00 | AAPL | Stock | 15.4911 | 15.4911 | 15.485 | 15.4911 | 27356.0 |
| 2013-04-04 08:18:00 | AAPL | Stock | 15.4982 | 15.4982 | 15.4982 | 15.4982 | 2800.0 |
| 2013-04-04 08:19:00 | AAPL | Stock | 15.4982 | 15.5004 | 15.4932 | 15.5004 | 14000.0 |
| 2013-04-04 08:20:00 | AAPL | Stock | 15.5004 | 15.5004 | 15.5004 | 15.5004 | 14000.0 |
| 2013-04-04 08:22:00 | AAPL | Stock | 15.4964 | 15.4964 | 15.4964 | 15.4964 | 8400.0 |
> showing 50 of 959,086 rows — these rows as CSV