PREVIEW / stock_5min / 2020-03-16
file: by_date/stock_5min/2020/2020-03-16.parquet size: 6.6 MB rows: 415,841 symbols: 2,457
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-16 04:00:00 | AAPL | Stock | 63.17 | 64.075 | 63.0 | 63.4525 | 37840.0 |
| 2020-03-16 04:05:00 | AAPL | Stock | 63.275 | 63.66 | 63.075 | 63.66 | 34500.0 |
| 2020-03-16 04:10:00 | AAPL | Stock | 63.6875 | 63.6875 | 63.3 | 63.4925 | 31156.0 |
| 2020-03-16 04:15:00 | AAPL | Stock | 63.4925 | 63.4925 | 63.25 | 63.25 | 13804.0 |
| 2020-03-16 04:20:00 | AAPL | Stock | 63.25 | 63.3275 | 62.92 | 62.92 | 30936.0 |
| 2020-03-16 04:25:00 | AAPL | Stock | 62.75 | 62.7525 | 62.4975 | 62.4975 | 41080.0 |
| 2020-03-16 04:30:00 | AAPL | Stock | 62.375 | 62.4425 | 62.245 | 62.345 | 8756.0 |
| 2020-03-16 04:35:00 | AAPL | Stock | 62.135 | 62.4325 | 62.0 | 62.4325 | 44088.0 |
| 2020-03-16 04:40:00 | AAPL | Stock | 62.4325 | 62.4325 | 61.9975 | 62.0 | 6032.0 |
| 2020-03-16 04:45:00 | AAPL | Stock | 62.2125 | 62.275 | 62.025 | 62.1875 | 11672.0 |
| 2020-03-16 04:50:00 | AAPL | Stock | 62.05 | 62.05 | 61.5275 | 61.8 | 24020.0 |
| 2020-03-16 04:55:00 | AAPL | Stock | 61.775 | 61.9475 | 61.55 | 61.55 | 12488.0 |
| 2020-03-16 05:00:00 | AAPL | Stock | 61.7025 | 61.75 | 61.575 | 61.75 | 7888.0 |
| 2020-03-16 05:05:00 | AAPL | Stock | 61.6375 | 61.695 | 61.4325 | 61.4325 | 12816.0 |
| 2020-03-16 05:10:00 | AAPL | Stock | 61.4575 | 61.4575 | 61.4575 | 61.4575 | 800.0 |
| 2020-03-16 05:15:00 | AAPL | Stock | 61.625 | 61.625 | 61.415 | 61.6 | 72912.0 |
| 2020-03-16 05:20:00 | AAPL | Stock | 61.6 | 61.9225 | 61.6 | 61.8375 | 41848.0 |
| 2020-03-16 05:25:00 | AAPL | Stock | 61.7875 | 61.9975 | 61.7875 | 61.89 | 5156.0 |
| 2020-03-16 05:30:00 | AAPL | Stock | 61.925 | 61.9975 | 61.9 | 61.9975 | 3880.0 |
| 2020-03-16 05:35:00 | AAPL | Stock | 61.9125 | 61.925 | 61.805 | 61.805 | 9848.0 |
| 2020-03-16 05:40:00 | AAPL | Stock | 61.86 | 61.875 | 61.86 | 61.875 | 1972.0 |
| 2020-03-16 05:45:00 | AAPL | Stock | 61.9 | 62.125 | 61.9 | 62.125 | 14368.0 |
| 2020-03-16 05:50:00 | AAPL | Stock | 62.25 | 62.25 | 62.0 | 62.2125 | 11780.0 |
| 2020-03-16 05:55:00 | AAPL | Stock | 62.2 | 62.2025 | 61.9 | 62.025 | 16640.0 |
| 2020-03-16 06:00:00 | AAPL | Stock | 61.93 | 62.005 | 61.93 | 62.0025 | 17296.0 |
| 2020-03-16 06:05:00 | AAPL | Stock | 62.1 | 62.15 | 62.0325 | 62.04 | 15128.0 |
| 2020-03-16 06:10:00 | AAPL | Stock | 62.04 | 62.0775 | 61.8775 | 61.8775 | 59272.0 |
| 2020-03-16 06:15:00 | AAPL | Stock | 61.85 | 61.8975 | 61.7475 | 61.75 | 17504.0 |
| 2020-03-16 06:20:00 | AAPL | Stock | 61.75 | 61.7525 | 61.6 | 61.6 | 4000.0 |
| 2020-03-16 06:25:00 | AAPL | Stock | 61.6 | 61.6 | 61.5 | 61.5625 | 32960.0 |
| 2020-03-16 06:30:00 | AAPL | Stock | 61.5 | 61.625 | 61.36 | 61.6225 | 56704.0 |
| 2020-03-16 06:35:00 | AAPL | Stock | 61.505 | 61.7425 | 61.4 | 61.5 | 48296.0 |
| 2020-03-16 06:40:00 | AAPL | Stock | 61.5 | 61.5 | 61.2475 | 61.275 | 21760.0 |
| 2020-03-16 06:45:00 | AAPL | Stock | 61.275 | 61.3225 | 61.125 | 61.3225 | 12524.0 |
| 2020-03-16 06:50:00 | AAPL | Stock | 61.3 | 61.3225 | 61.1025 | 61.1025 | 20340.0 |
| 2020-03-16 06:55:00 | AAPL | Stock | 61.1875 | 61.2575 | 61.1375 | 61.2575 | 21972.0 |
| 2020-03-16 07:00:00 | AAPL | Stock | 61.275 | 62.075 | 61.1925 | 61.945 | 270784.0 |
| 2020-03-16 07:05:00 | AAPL | Stock | 61.75 | 61.875 | 61.5375 | 61.6875 | 115544.0 |
| 2020-03-16 07:10:00 | AAPL | Stock | 61.73 | 61.7325 | 61.55 | 61.5875 | 52408.0 |
| 2020-03-16 07:15:00 | AAPL | Stock | 61.5875 | 61.625 | 61.425 | 61.45 | 79648.0 |
| 2020-03-16 07:20:00 | AAPL | Stock | 61.45 | 61.575 | 61.3275 | 61.375 | 56756.0 |
| 2020-03-16 07:25:00 | AAPL | Stock | 61.4 | 61.45 | 61.305 | 61.375 | 54820.0 |
| 2020-03-16 07:30:00 | AAPL | Stock | 61.3775 | 61.395 | 61.325 | 61.395 | 36068.0 |
| 2020-03-16 07:35:00 | AAPL | Stock | 61.4375 | 61.855 | 61.4375 | 61.47 | 26640.0 |
| 2020-03-16 07:40:00 | AAPL | Stock | 61.425 | 61.455 | 61.035 | 61.125 | 364456.0 |
| 2020-03-16 07:45:00 | AAPL | Stock | 61.125 | 61.2875 | 61.0825 | 61.11 | 42720.0 |
| 2020-03-16 07:50:00 | AAPL | Stock | 61.11 | 61.19 | 60.8175 | 60.9525 | 108620.0 |
| 2020-03-16 07:55:00 | AAPL | Stock | 60.95 | 61.0 | 60.825 | 60.89 | 67584.0 |
| 2020-03-16 08:00:00 | AAPL | Stock | 61.25 | 61.9575 | 60.5625 | 61.325 | 683888.0 |
| 2020-03-16 08:05:00 | AAPL | Stock | 61.325 | 61.5 | 60.75 | 60.85 | 298520.0 |
> showing 50 of 415,841 rows — these rows as CSV