PREVIEW / stock_5min / 2014-07-09
file: by_date/stock_5min/2014/2014-07-09.parquet size: 5.2 MB rows: 352,414 symbols: 3,570
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-09 04:00:00 | AAPL | Stock | 23.85 | 23.85 | 23.85 | 23.85 | 1200.0 |
| 2014-07-09 04:05:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 400.0 |
| 2014-07-09 04:20:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 680.0 |
| 2014-07-09 04:45:00 | AAPL | Stock | 23.8275 | 23.8275 | 23.8275 | 23.8275 | 1600.0 |
| 2014-07-09 04:50:00 | AAPL | Stock | 23.8125 | 23.8225 | 23.8125 | 23.8225 | 2000.0 |
| 2014-07-09 04:55:00 | AAPL | Stock | 23.8275 | 23.8275 | 23.8275 | 23.8275 | 400.0 |
| 2014-07-09 05:30:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 3200.0 |
| 2014-07-09 05:35:00 | AAPL | Stock | 23.815 | 23.815 | 23.815 | 23.815 | 800.0 |
| 2014-07-09 05:55:00 | AAPL | Stock | 23.815 | 23.8275 | 23.815 | 23.8275 | 2400.0 |
| 2014-07-09 06:10:00 | AAPL | Stock | 23.8375 | 23.8475 | 23.8375 | 23.8475 | 2640.0 |
| 2014-07-09 06:15:00 | AAPL | Stock | 23.8525 | 23.8525 | 23.8525 | 23.8525 | 400.0 |
| 2014-07-09 06:20:00 | AAPL | Stock | 23.8525 | 23.8525 | 23.85 | 23.85 | 800.0 |
| 2014-07-09 06:25:00 | AAPL | Stock | 23.845 | 23.845 | 23.845 | 23.845 | 800.0 |
| 2014-07-09 06:40:00 | AAPL | Stock | 23.8425 | 23.8425 | 23.8425 | 23.8425 | 400.0 |
| 2014-07-09 06:45:00 | AAPL | Stock | 23.8375 | 23.8375 | 23.8375 | 23.8375 | 4000.0 |
| 2014-07-09 06:50:00 | AAPL | Stock | 23.85 | 23.85 | 23.8475 | 23.8475 | 2000.0 |
| 2014-07-09 07:00:00 | AAPL | Stock | 23.84 | 23.8525 | 23.84 | 23.8525 | 12888.0 |
| 2014-07-09 07:05:00 | AAPL | Stock | 23.86 | 23.865 | 23.855 | 23.865 | 15628.0 |
| 2014-07-09 07:10:00 | AAPL | Stock | 23.865 | 23.875 | 23.865 | 23.875 | 12000.0 |
| 2014-07-09 07:15:00 | AAPL | Stock | 23.86 | 23.87 | 23.855 | 23.87 | 7200.0 |
| 2014-07-09 07:20:00 | AAPL | Stock | 23.8575 | 23.865 | 23.8575 | 23.86 | 4400.0 |
| 2014-07-09 07:25:00 | AAPL | Stock | 23.8625 | 23.865 | 23.8625 | 23.8625 | 19040.0 |
| 2014-07-09 07:30:00 | AAPL | Stock | 23.86 | 23.86 | 23.86 | 23.86 | 3200.0 |
| 2014-07-09 07:35:00 | AAPL | Stock | 23.8575 | 23.8625 | 23.8575 | 23.8625 | 9200.0 |
| 2014-07-09 07:40:00 | AAPL | Stock | 23.86 | 23.86 | 23.86 | 23.86 | 400.0 |
| 2014-07-09 07:45:00 | AAPL | Stock | 23.8625 | 23.8625 | 23.86 | 23.86 | 1100.0 |
| 2014-07-09 07:50:00 | AAPL | Stock | 23.8625 | 23.8675 | 23.8625 | 23.8675 | 2200.0 |
| 2014-07-09 07:55:00 | AAPL | Stock | 23.865 | 23.8675 | 23.8625 | 23.865 | 8200.0 |
| 2014-07-09 08:00:00 | AAPL | Stock | 23.865 | 23.8675 | 23.83 | 23.845 | 117076.0 |
| 2014-07-09 08:05:00 | AAPL | Stock | 23.845 | 23.85 | 23.8325 | 23.845 | 66688.0 |
| 2014-07-09 08:10:00 | AAPL | Stock | 23.8425 | 23.845 | 23.8375 | 23.845 | 34828.0 |
| 2014-07-09 08:15:00 | AAPL | Stock | 23.8425 | 23.845 | 23.8375 | 23.845 | 32000.0 |
| 2014-07-09 08:20:00 | AAPL | Stock | 23.845 | 23.8525 | 23.84 | 23.8525 | 32308.0 |
| 2014-07-09 08:25:00 | AAPL | Stock | 23.8575 | 23.8675 | 23.8575 | 23.8675 | 22840.0 |
| 2014-07-09 08:30:00 | AAPL | Stock | 23.8675 | 23.8725 | 23.8625 | 23.8725 | 23120.0 |
| 2014-07-09 08:35:00 | AAPL | Stock | 23.875 | 23.8825 | 23.8725 | 23.8825 | 31180.0 |
| 2014-07-09 08:40:00 | AAPL | Stock | 23.88 | 23.885 | 23.88 | 23.885 | 10336.0 |
| 2014-07-09 08:45:00 | AAPL | Stock | 23.8925 | 23.9125 | 23.8875 | 23.9075 | 54840.0 |
| 2014-07-09 08:50:00 | AAPL | Stock | 23.9125 | 23.9225 | 23.9 | 23.9025 | 51416.0 |
| 2014-07-09 08:55:00 | AAPL | Stock | 23.9025 | 23.9075 | 23.895 | 23.895 | 27948.0 |
| 2014-07-09 09:00:00 | AAPL | Stock | 23.895 | 23.8975 | 23.895 | 23.895 | 30692.0 |
| 2014-07-09 09:05:00 | AAPL | Stock | 23.9 | 23.9075 | 23.9 | 23.9025 | 44132.0 |
| 2014-07-09 09:10:00 | AAPL | Stock | 23.905 | 23.915 | 23.905 | 23.9125 | 57360.0 |
| 2014-07-09 09:15:00 | AAPL | Stock | 23.9125 | 23.925 | 23.9125 | 23.915 | 79360.0 |
| 2014-07-09 09:20:00 | AAPL | Stock | 23.9125 | 23.925 | 23.9075 | 23.9075 | 49396.0 |
| 2014-07-09 09:25:00 | AAPL | Stock | 23.91 | 23.9125 | 23.86 | 23.875 | 221720.0 |
| 2014-07-09 09:30:00 | AAPL | Stock | 23.86 | 23.9775 | 23.85 | 23.9585 | 6957108.0 |
| 2014-07-09 09:35:00 | AAPL | Stock | 23.96 | 23.9875 | 23.8875 | 23.9 | 4962628.0 |
| 2014-07-09 09:40:00 | AAPL | Stock | 23.9 | 23.9125 | 23.8025 | 23.85 | 5312940.0 |
| 2014-07-09 09:45:00 | AAPL | Stock | 23.855 | 23.9325 | 23.855 | 23.915 | 2889264.0 |
> showing 50 of 352,414 rows — these rows as CSV