PREVIEW / stock_1min / 2013-09-18
file: by_date/stock_1min/2013/2013-09-18.parquet size: 14.0 MB rows: 1,011,865 symbols: 2,846
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-09-18 04:00:00 | AAPL | Stock | 16.2857 | 16.3679 | 16.2857 | 16.3679 | 17500.0 |
| 2013-09-18 04:01:00 | AAPL | Stock | 16.365 | 16.365 | 16.365 | 16.365 | 5600.0 |
| 2013-09-18 04:05:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2013-09-18 04:06:00 | AAPL | Stock | 16.3796 | 16.3796 | 16.3796 | 16.3796 | 5600.0 |
| 2013-09-18 04:09:00 | AAPL | Stock | 16.4068 | 16.4068 | 16.4068 | 16.4068 | 4760.0 |
| 2013-09-18 04:18:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3907 | 16.3907 | 5600.0 |
| 2013-09-18 04:20:00 | AAPL | Stock | 16.4064 | 16.4107 | 16.4064 | 16.4107 | 13160.0 |
| 2013-09-18 04:29:00 | AAPL | Stock | 16.3986 | 16.3986 | 16.3907 | 16.3907 | 8400.0 |
| 2013-09-18 04:32:00 | AAPL | Stock | 16.3843 | 16.3843 | 16.3843 | 16.3843 | 2800.0 |
| 2013-09-18 04:37:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2013-09-18 04:38:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2013-09-18 04:39:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2013-09-18 04:42:00 | AAPL | Stock | 16.3893 | 16.3893 | 16.3893 | 16.3893 | 2800.0 |
| 2013-09-18 04:43:00 | AAPL | Stock | 16.3893 | 16.3893 | 16.3893 | 16.3893 | 2800.0 |
| 2013-09-18 04:44:00 | AAPL | Stock | 16.3893 | 16.3893 | 16.3893 | 16.3893 | 11200.0 |
| 2013-09-18 04:45:00 | AAPL | Stock | 16.3843 | 16.3843 | 16.3843 | 16.3843 | 2800.0 |
| 2013-09-18 04:49:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 2800.0 |
| 2013-09-18 04:53:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3643 | 16.3643 | 2800.0 |
| 2013-09-18 04:55:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3714 | 16.3714 | 22400.0 |
| 2013-09-18 04:58:00 | AAPL | Stock | 16.3625 | 16.3679 | 16.3625 | 16.3625 | 11200.0 |
| 2013-09-18 04:59:00 | AAPL | Stock | 16.3625 | 16.3625 | 16.3561 | 16.3561 | 16800.0 |
| 2013-09-18 05:01:00 | AAPL | Stock | 16.3607 | 16.3625 | 16.3607 | 16.3625 | 8400.0 |
| 2013-09-18 05:02:00 | AAPL | Stock | 16.3621 | 16.3625 | 16.3621 | 16.3625 | 5600.0 |
| 2013-09-18 05:05:00 | AAPL | Stock | 16.3625 | 16.3625 | 16.3575 | 16.3625 | 47600.0 |
| 2013-09-18 05:19:00 | AAPL | Stock | 16.3786 | 16.3857 | 16.3786 | 16.3814 | 14000.0 |
| 2013-09-18 05:26:00 | AAPL | Stock | 16.3811 | 16.3811 | 16.3811 | 16.3811 | 2800.0 |
| 2013-09-18 05:42:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 28000.0 |
| 2013-09-18 05:43:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 11200.0 |
| 2013-09-18 05:44:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 11200.0 |
| 2013-09-18 05:45:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 11200.0 |
| 2013-09-18 05:46:00 | AAPL | Stock | 16.3821 | 16.3929 | 16.3821 | 16.3929 | 30184.0 |
| 2013-09-18 05:51:00 | AAPL | Stock | 16.385 | 16.385 | 16.3821 | 16.3821 | 8400.0 |
| 2013-09-18 05:53:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 2800.0 |
| 2013-09-18 05:58:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 16800.0 |
| 2013-09-18 06:01:00 | AAPL | Stock | 16.3696 | 16.3696 | 16.3696 | 16.3696 | 2800.0 |
| 2013-09-18 06:02:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 5600.0 |
| 2013-09-18 06:03:00 | AAPL | Stock | 16.3668 | 16.3679 | 16.3668 | 16.3679 | 13384.0 |
| 2013-09-18 06:04:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 2800.0 |
| 2013-09-18 06:06:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 5600.0 |
| 2013-09-18 06:16:00 | AAPL | Stock | 16.3861 | 16.3861 | 16.3861 | 16.3861 | 2800.0 |
| 2013-09-18 06:21:00 | AAPL | Stock | 16.385 | 16.385 | 16.385 | 16.385 | 2800.0 |
| 2013-09-18 06:30:00 | AAPL | Stock | 16.3757 | 16.3757 | 16.3729 | 16.3729 | 14000.0 |
| 2013-09-18 06:44:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 8400.0 |
| 2013-09-18 06:52:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3607 | 16.3607 | 14000.0 |
| 2013-09-18 06:55:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 2800.0 |
| 2013-09-18 06:56:00 | AAPL | Stock | 16.3639 | 16.3639 | 16.3607 | 16.3607 | 5600.0 |
| 2013-09-18 06:57:00 | AAPL | Stock | 16.3586 | 16.3607 | 16.3586 | 16.3607 | 14000.0 |
| 2013-09-18 07:01:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 16800.0 |
| 2013-09-18 07:03:00 | AAPL | Stock | 16.3818 | 16.3818 | 16.375 | 16.375 | 24920.0 |
| 2013-09-18 07:04:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 8400.0 |
> showing 50 of 1,011,865 rows — these rows as CSV