PREVIEW / stock_5min / 2020-03-03
file: by_date/stock_5min/2020/2020-03-03.parquet size: 6.5 MB rows: 397,486 symbols: 2,416
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-03 04:00:00 | AAPL | Stock | 75.075 | 75.43 | 74.75 | 74.7825 | 30980.0 |
| 2020-03-03 04:05:00 | AAPL | Stock | 74.825 | 75.0 | 74.825 | 74.8775 | 10452.0 |
| 2020-03-03 04:10:00 | AAPL | Stock | 75.1825 | 75.2425 | 75.1 | 75.2325 | 19332.0 |
| 2020-03-03 04:15:00 | AAPL | Stock | 75.225 | 75.235 | 75.125 | 75.225 | 7376.0 |
| 2020-03-03 04:20:00 | AAPL | Stock | 75.2325 | 75.2325 | 74.925 | 75.0375 | 13716.0 |
| 2020-03-03 04:25:00 | AAPL | Stock | 75.0225 | 75.0225 | 75.005 | 75.005 | 800.0 |
| 2020-03-03 04:30:00 | AAPL | Stock | 75.0375 | 75.125 | 74.9 | 75.125 | 25748.0 |
| 2020-03-03 04:35:00 | AAPL | Stock | 75.155 | 75.2125 | 75.155 | 75.2125 | 10064.0 |
| 2020-03-03 04:40:00 | AAPL | Stock | 75.1825 | 75.3 | 75.1825 | 75.2125 | 10824.0 |
| 2020-03-03 04:45:00 | AAPL | Stock | 75.2625 | 75.3 | 75.1975 | 75.3 | 17848.0 |
| 2020-03-03 04:50:00 | AAPL | Stock | 75.25 | 75.37 | 75.25 | 75.265 | 33028.0 |
| 2020-03-03 04:55:00 | AAPL | Stock | 75.2125 | 75.25 | 75.1575 | 75.25 | 6000.0 |
| 2020-03-03 05:00:00 | AAPL | Stock | 75.25 | 75.325 | 75.2 | 75.275 | 9060.0 |
| 2020-03-03 05:05:00 | AAPL | Stock | 75.25 | 75.345 | 75.2125 | 75.2525 | 35056.0 |
| 2020-03-03 05:10:00 | AAPL | Stock | 75.225 | 75.23 | 75.175 | 75.175 | 6144.0 |
| 2020-03-03 05:15:00 | AAPL | Stock | 75.225 | 75.275 | 75.225 | 75.275 | 4368.0 |
| 2020-03-03 05:20:00 | AAPL | Stock | 75.275 | 75.3375 | 75.275 | 75.3375 | 2400.0 |
| 2020-03-03 05:25:00 | AAPL | Stock | 75.3375 | 75.3575 | 75.325 | 75.3575 | 10200.0 |
| 2020-03-03 05:30:00 | AAPL | Stock | 75.3375 | 75.375 | 75.3 | 75.35 | 17148.0 |
| 2020-03-03 05:35:00 | AAPL | Stock | 75.265 | 75.265 | 75.15 | 75.21 | 19836.0 |
| 2020-03-03 05:40:00 | AAPL | Stock | 75.1975 | 75.21 | 75.1925 | 75.2 | 22832.0 |
| 2020-03-03 05:45:00 | AAPL | Stock | 75.21 | 75.2925 | 75.21 | 75.2375 | 7116.0 |
| 2020-03-03 05:50:00 | AAPL | Stock | 75.2975 | 75.2975 | 75.225 | 75.27 | 27580.0 |
| 2020-03-03 05:55:00 | AAPL | Stock | 75.25 | 75.25 | 75.2375 | 75.2375 | 3404.0 |
| 2020-03-03 06:00:00 | AAPL | Stock | 75.23 | 75.23 | 75.0625 | 75.0625 | 8104.0 |
| 2020-03-03 06:05:00 | AAPL | Stock | 75.0 | 75.0 | 74.8825 | 75.0 | 21096.0 |
| 2020-03-03 06:10:00 | AAPL | Stock | 74.9975 | 74.9975 | 74.825 | 74.875 | 6984.0 |
| 2020-03-03 06:15:00 | AAPL | Stock | 74.9 | 74.9 | 74.7825 | 74.875 | 12820.0 |
| 2020-03-03 06:20:00 | AAPL | Stock | 74.875 | 75.0 | 74.785 | 74.8075 | 7088.0 |
| 2020-03-03 06:25:00 | AAPL | Stock | 74.8075 | 74.8725 | 74.5675 | 74.8 | 12948.0 |
| 2020-03-03 06:30:00 | AAPL | Stock | 74.85 | 74.915 | 74.8375 | 74.915 | 2488.0 |
| 2020-03-03 06:35:00 | AAPL | Stock | 74.93 | 74.93 | 74.825 | 74.825 | 1200.0 |
| 2020-03-03 06:40:00 | AAPL | Stock | 74.775 | 74.7775 | 74.6275 | 74.725 | 7588.0 |
| 2020-03-03 06:45:00 | AAPL | Stock | 74.7475 | 74.845 | 74.7475 | 74.845 | 8588.0 |
| 2020-03-03 06:50:00 | AAPL | Stock | 74.75 | 74.8175 | 74.6775 | 74.8175 | 10928.0 |
| 2020-03-03 06:55:00 | AAPL | Stock | 74.7625 | 74.805 | 74.7625 | 74.7775 | 5368.0 |
| 2020-03-03 07:00:00 | AAPL | Stock | 74.87 | 75.095 | 74.8 | 75.0025 | 143492.0 |
| 2020-03-03 07:05:00 | AAPL | Stock | 75.0025 | 75.05 | 74.7975 | 75.0475 | 100500.0 |
| 2020-03-03 07:10:00 | AAPL | Stock | 75.0025 | 75.25 | 74.9975 | 75.175 | 98244.0 |
| 2020-03-03 07:15:00 | AAPL | Stock | 75.18 | 75.35 | 75.175 | 75.3 | 119652.0 |
| 2020-03-03 07:20:00 | AAPL | Stock | 75.305 | 75.49 | 75.25 | 75.47 | 156988.0 |
| 2020-03-03 07:25:00 | AAPL | Stock | 75.47 | 75.55 | 75.305 | 75.525 | 158344.0 |
| 2020-03-03 07:30:00 | AAPL | Stock | 75.55 | 75.7925 | 75.3525 | 75.52 | 241916.0 |
| 2020-03-03 07:35:00 | AAPL | Stock | 75.5075 | 75.7125 | 75.0 | 75.245 | 289536.0 |
| 2020-03-03 07:40:00 | AAPL | Stock | 75.3 | 75.425 | 74.9125 | 74.9275 | 210504.0 |
| 2020-03-03 07:45:00 | AAPL | Stock | 74.93 | 75.0725 | 74.75 | 74.97 | 251240.0 |
| 2020-03-03 07:50:00 | AAPL | Stock | 74.9925 | 75.3 | 74.9775 | 75.2425 | 208812.0 |
| 2020-03-03 07:55:00 | AAPL | Stock | 75.205 | 75.45 | 75.125 | 75.1975 | 331520.0 |
| 2020-03-03 08:00:00 | AAPL | Stock | 75.13 | 75.7525 | 74.7875 | 74.89 | 879924.0 |
| 2020-03-03 08:05:00 | AAPL | Stock | 74.8925 | 74.95 | 74.7 | 74.8722 | 206128.0 |
> showing 50 of 397,486 rows — these rows as CSV