PREVIEW / stock_5min / 2020-02-19
file: by_date/stock_5min/2020/2020-02-19.parquet size: 6.1 MB rows: 372,413 symbols: 2,443
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-02-19 04:00:00 | AAPL | Stock | 80.0375 | 80.2475 | 80.0375 | 80.2475 | 9360.0 |
| 2020-02-19 04:05:00 | AAPL | Stock | 80.1975 | 80.1975 | 80.1975 | 80.1975 | 5416.0 |
| 2020-02-19 04:10:00 | AAPL | Stock | 80.125 | 80.125 | 80.125 | 80.125 | 1820.0 |
| 2020-02-19 04:20:00 | AAPL | Stock | 80.165 | 80.165 | 80.1625 | 80.1625 | 2280.0 |
| 2020-02-19 04:30:00 | AAPL | Stock | 80.2325 | 80.2475 | 80.2325 | 80.2475 | 2400.0 |
| 2020-02-19 04:35:00 | AAPL | Stock | 80.2025 | 80.2025 | 80.175 | 80.175 | 6384.0 |
| 2020-02-19 04:40:00 | AAPL | Stock | 80.1625 | 80.1625 | 80.15 | 80.15 | 2400.0 |
| 2020-02-19 04:45:00 | AAPL | Stock | 80.1475 | 80.15 | 80.1475 | 80.15 | 3840.0 |
| 2020-02-19 04:55:00 | AAPL | Stock | 80.1275 | 80.1275 | 80.075 | 80.075 | 1932.0 |
| 2020-02-19 05:00:00 | AAPL | Stock | 80.1375 | 80.1375 | 80.1375 | 80.1375 | 800.0 |
| 2020-02-19 05:05:00 | AAPL | Stock | 80.1375 | 80.1375 | 80.1375 | 80.1375 | 1600.0 |
| 2020-02-19 05:10:00 | AAPL | Stock | 80.1375 | 80.175 | 80.1375 | 80.175 | 5736.0 |
| 2020-02-19 05:15:00 | AAPL | Stock | 80.205 | 80.2575 | 80.205 | 80.2575 | 2800.0 |
| 2020-02-19 05:20:00 | AAPL | Stock | 80.265 | 80.27 | 80.265 | 80.27 | 1200.0 |
| 2020-02-19 05:25:00 | AAPL | Stock | 80.31 | 80.31 | 80.25 | 80.25 | 3232.0 |
| 2020-02-19 05:30:00 | AAPL | Stock | 80.275 | 80.315 | 80.275 | 80.315 | 1640.0 |
| 2020-02-19 05:35:00 | AAPL | Stock | 80.3375 | 80.3375 | 80.3375 | 80.3375 | 400.0 |
| 2020-02-19 05:40:00 | AAPL | Stock | 80.25 | 80.25 | 80.25 | 80.25 | 400.0 |
| 2020-02-19 05:45:00 | AAPL | Stock | 80.1825 | 80.1825 | 80.175 | 80.175 | 1600.0 |
| 2020-02-19 05:50:00 | AAPL | Stock | 80.2 | 80.2 | 80.2 | 80.2 | 400.0 |
| 2020-02-19 06:05:00 | AAPL | Stock | 80.175 | 80.175 | 80.175 | 80.175 | 5344.0 |
| 2020-02-19 06:10:00 | AAPL | Stock | 80.1225 | 80.1225 | 80.1225 | 80.1225 | 800.0 |
| 2020-02-19 06:25:00 | AAPL | Stock | 80.1225 | 80.14 | 80.1125 | 80.14 | 1588.0 |
| 2020-02-19 06:35:00 | AAPL | Stock | 80.15 | 80.15 | 80.15 | 80.15 | 400.0 |
| 2020-02-19 06:40:00 | AAPL | Stock | 80.1 | 80.1 | 80.1 | 80.1 | 7600.0 |
| 2020-02-19 06:45:00 | AAPL | Stock | 80.0125 | 80.1 | 80.0125 | 80.1 | 10000.0 |
| 2020-02-19 06:50:00 | AAPL | Stock | 80.0975 | 80.1475 | 80.0975 | 80.1475 | 2000.0 |
| 2020-02-19 07:00:00 | AAPL | Stock | 80.1125 | 80.175 | 80.1 | 80.1725 | 27532.0 |
| 2020-02-19 07:05:00 | AAPL | Stock | 80.145 | 80.15 | 80.1275 | 80.15 | 8076.0 |
| 2020-02-19 07:10:00 | AAPL | Stock | 80.1575 | 80.1625 | 80.1325 | 80.15 | 4000.0 |
| 2020-02-19 07:15:00 | AAPL | Stock | 80.1625 | 80.165 | 80.1625 | 80.1625 | 4072.0 |
| 2020-02-19 07:20:00 | AAPL | Stock | 80.1575 | 80.175 | 80.1575 | 80.165 | 5760.0 |
| 2020-02-19 07:25:00 | AAPL | Stock | 80.14 | 80.1875 | 80.14 | 80.1875 | 29768.0 |
| 2020-02-19 07:30:00 | AAPL | Stock | 80.19 | 80.2275 | 80.1875 | 80.2275 | 9772.0 |
| 2020-02-19 07:35:00 | AAPL | Stock | 80.2375 | 80.25 | 80.23 | 80.2425 | 9404.0 |
| 2020-02-19 07:40:00 | AAPL | Stock | 80.245 | 80.3125 | 80.225 | 80.29 | 33616.0 |
| 2020-02-19 07:45:00 | AAPL | Stock | 80.295 | 80.305 | 80.2625 | 80.2625 | 10188.0 |
| 2020-02-19 07:50:00 | AAPL | Stock | 80.2625 | 80.285 | 80.25 | 80.2825 | 6704.0 |
| 2020-02-19 07:55:00 | AAPL | Stock | 80.2825 | 80.32 | 80.28 | 80.32 | 24860.0 |
| 2020-02-19 08:00:00 | AAPL | Stock | 80.1475 | 80.3325 | 80.1 | 80.275 | 172120.0 |
| 2020-02-19 08:05:00 | AAPL | Stock | 80.2725 | 80.32 | 80.2125 | 80.2125 | 81004.0 |
| 2020-02-19 08:10:00 | AAPL | Stock | 80.1925 | 80.2855 | 80.155 | 80.2625 | 35916.0 |
| 2020-02-19 08:15:00 | AAPL | Stock | 80.25 | 80.25 | 80.2005 | 80.225 | 24104.0 |
| 2020-02-19 08:20:00 | AAPL | Stock | 80.235 | 80.276 | 80.215 | 80.215 | 33768.0 |
| 2020-02-19 08:25:00 | AAPL | Stock | 80.2125 | 80.225 | 80.09 | 80.1375 | 61648.0 |
| 2020-02-19 08:30:00 | AAPL | Stock | 80.1375 | 80.15 | 80.075 | 80.1 | 30996.0 |
| 2020-02-19 08:35:00 | AAPL | Stock | 80.1225 | 80.175 | 80.0975 | 80.125 | 34012.0 |
| 2020-02-19 08:40:00 | AAPL | Stock | 80.1325 | 80.175 | 80.115 | 80.13 | 32456.0 |
| 2020-02-19 08:45:00 | AAPL | Stock | 80.1605 | 80.175 | 80.125 | 80.1625 | 33760.0 |
| 2020-02-19 08:50:00 | AAPL | Stock | 80.1625 | 80.1625 | 80.125 | 80.1622 | 14400.0 |
> showing 50 of 372,413 rows — these rows as CSV