PREVIEW / stock_5min / 2015-01-20
file: by_date/stock_5min/2015/2015-01-20.parquet size: 5.5 MB rows: 365,946 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-20 04:00:00 | AAPL | Stock | 26.755 | 26.755 | 26.72 | 26.7425 | 5200.0 |
| 2015-01-20 04:05:00 | AAPL | Stock | 26.735 | 26.7375 | 26.735 | 26.7375 | 5200.0 |
| 2015-01-20 04:20:00 | AAPL | Stock | 26.7175 | 26.7175 | 26.705 | 26.705 | 6164.0 |
| 2015-01-20 04:30:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 800.0 |
| 2015-01-20 04:35:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 2000.0 |
| 2015-01-20 04:40:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 800.0 |
| 2015-01-20 04:50:00 | AAPL | Stock | 26.675 | 26.6975 | 26.67 | 26.6975 | 2400.0 |
| 2015-01-20 04:55:00 | AAPL | Stock | 26.67 | 26.67 | 26.67 | 26.67 | 400.0 |
| 2015-01-20 05:10:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 800.0 |
| 2015-01-20 05:15:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 800.0 |
| 2015-01-20 05:20:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 1200.0 |
| 2015-01-20 05:30:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 400.0 |
| 2015-01-20 05:35:00 | AAPL | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 2800.0 |
| 2015-01-20 05:40:00 | AAPL | Stock | 26.7 | 26.75 | 26.6975 | 26.75 | 13148.0 |
| 2015-01-20 05:45:00 | AAPL | Stock | 26.7275 | 26.7275 | 26.7275 | 26.7275 | 400.0 |
| 2015-01-20 05:50:00 | AAPL | Stock | 26.74 | 26.75 | 26.74 | 26.75 | 9680.0 |
| 2015-01-20 06:00:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 6000.0 |
| 2015-01-20 06:10:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 400.0 |
| 2015-01-20 06:15:00 | AAPL | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 2800.0 |
| 2015-01-20 06:25:00 | AAPL | Stock | 26.74 | 26.74 | 26.74 | 26.74 | 400.0 |
| 2015-01-20 06:30:00 | AAPL | Stock | 26.74 | 26.74 | 26.725 | 26.725 | 8380.0 |
| 2015-01-20 06:35:00 | AAPL | Stock | 26.725 | 26.735 | 26.725 | 26.725 | 4400.0 |
| 2015-01-20 06:40:00 | AAPL | Stock | 26.725 | 26.725 | 26.725 | 26.725 | 2000.0 |
| 2015-01-20 06:50:00 | AAPL | Stock | 26.74 | 26.74 | 26.7375 | 26.74 | 1200.0 |
| 2015-01-20 06:55:00 | AAPL | Stock | 26.75 | 26.805 | 26.75 | 26.795 | 39220.0 |
| 2015-01-20 07:00:00 | AAPL | Stock | 26.8125 | 26.85 | 26.7875 | 26.7875 | 23420.0 |
| 2015-01-20 07:05:00 | AAPL | Stock | 26.7875 | 26.8125 | 26.7875 | 26.8125 | 4180.0 |
| 2015-01-20 07:10:00 | AAPL | Stock | 26.8 | 26.8125 | 26.795 | 26.795 | 2868.0 |
| 2015-01-20 07:15:00 | AAPL | Stock | 26.7925 | 26.8225 | 26.7925 | 26.8225 | 12168.0 |
| 2015-01-20 07:20:00 | AAPL | Stock | 26.8225 | 26.8375 | 26.8125 | 26.8375 | 20760.0 |
| 2015-01-20 07:25:00 | AAPL | Stock | 26.85 | 26.85 | 26.8225 | 26.8225 | 51468.0 |
| 2015-01-20 07:30:00 | AAPL | Stock | 26.825 | 26.825 | 26.8025 | 26.825 | 25152.0 |
| 2015-01-20 07:35:00 | AAPL | Stock | 26.825 | 26.87 | 26.8125 | 26.8575 | 41984.0 |
| 2015-01-20 07:40:00 | AAPL | Stock | 26.8575 | 26.8575 | 26.845 | 26.8575 | 28280.0 |
| 2015-01-20 07:45:00 | AAPL | Stock | 26.865 | 26.865 | 26.845 | 26.85 | 9772.0 |
| 2015-01-20 07:50:00 | AAPL | Stock | 26.85 | 26.86 | 26.85 | 26.85 | 8144.0 |
| 2015-01-20 07:55:00 | AAPL | Stock | 26.8625 | 26.875 | 26.8575 | 26.8675 | 52772.0 |
| 2015-01-20 08:00:00 | AAPL | Stock | 26.8675 | 26.8875 | 26.7875 | 26.855 | 283836.0 |
| 2015-01-20 08:05:00 | AAPL | Stock | 26.84 | 26.86 | 26.8 | 26.8025 | 128356.0 |
| 2015-01-20 08:10:00 | AAPL | Stock | 26.8 | 26.8175 | 26.7925 | 26.8175 | 151008.0 |
| 2015-01-20 08:15:00 | AAPL | Stock | 26.82 | 26.8375 | 26.8 | 26.8375 | 65264.0 |
| 2015-01-20 08:20:00 | AAPL | Stock | 26.8475 | 26.87 | 26.8475 | 26.86 | 74132.0 |
| 2015-01-20 08:25:00 | AAPL | Stock | 26.8625 | 26.865 | 26.845 | 26.8525 | 51868.0 |
| 2015-01-20 08:30:00 | AAPL | Stock | 26.8525 | 26.8525 | 26.84 | 26.8425 | 24732.0 |
| 2015-01-20 08:35:00 | AAPL | Stock | 26.8425 | 26.8525 | 26.84 | 26.845 | 27416.0 |
| 2015-01-20 08:40:00 | AAPL | Stock | 26.8425 | 26.855 | 26.84 | 26.855 | 36580.0 |
| 2015-01-20 08:45:00 | AAPL | Stock | 26.855 | 26.86 | 26.8325 | 26.8375 | 88460.0 |
| 2015-01-20 08:50:00 | AAPL | Stock | 26.83 | 26.8375 | 26.8275 | 26.835 | 41500.0 |
| 2015-01-20 08:55:00 | AAPL | Stock | 26.83 | 26.8325 | 26.8125 | 26.815 | 89248.0 |
| 2015-01-20 09:00:00 | AAPL | Stock | 26.8025 | 26.8025 | 26.765 | 26.795 | 83152.0 |
> showing 50 of 365,946 rows — these rows as CSV