PREVIEW / stock_30min / 2017-07-11
file: by_date/stock_30min/2017/2017-07-11.parquet size: 1.6 MB rows: 81,120 symbols: 3,001
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 |
|---|---|---|---|---|---|---|---|
| 2017-07-11 04:00:00 | AAPL | Stock | 36.2325 | 36.275 | 36.225 | 36.25 | 10132.0 |
| 2017-07-11 05:00:00 | AAPL | Stock | 36.25 | 36.25 | 36.25 | 36.25 | 1148.0 |
| 2017-07-11 05:30:00 | AAPL | Stock | 36.2125 | 36.2125 | 36.2125 | 36.2125 | 4000.0 |
| 2017-07-11 06:00:00 | AAPL | Stock | 36.2275 | 36.2275 | 36.2025 | 36.2025 | 3100.0 |
| 2017-07-11 06:30:00 | AAPL | Stock | 36.2125 | 36.2375 | 36.19 | 36.2375 | 29600.0 |
| 2017-07-11 07:00:00 | AAPL | Stock | 36.2125 | 36.225 | 36.1225 | 36.15 | 43660.0 |
| 2017-07-11 07:30:00 | AAPL | Stock | 36.15 | 36.1525 | 36.1025 | 36.125 | 44884.0 |
| 2017-07-11 08:00:00 | AAPL | Stock | 36.125 | 36.2375 | 36.0875 | 36.12 | 173628.0 |
| 2017-07-11 08:30:00 | AAPL | Stock | 36.1225 | 36.18 | 36.11 | 36.17 | 36764.0 |
| 2017-07-11 09:00:00 | AAPL | Stock | 36.15 | 36.195 | 36.11 | 36.1825 | 219856.0 |
| 2017-07-11 09:30:00 | AAPL | Stock | 36.1825 | 36.2675 | 36.105 | 36.2045 | 9828996.0 |
| 2017-07-11 10:00:00 | AAPL | Stock | 36.205 | 36.4012 | 36.16 | 36.3925 | 7217168.0 |
| 2017-07-11 10:30:00 | AAPL | Stock | 36.3875 | 36.4325 | 36.31 | 36.3365 | 4099988.0 |
| 2017-07-11 11:00:00 | AAPL | Stock | 36.335 | 36.35 | 36.095 | 36.1875 | 6907012.0 |
| 2017-07-11 11:30:00 | AAPL | Stock | 36.1875 | 36.3225 | 36.175 | 36.28 | 3945124.0 |
| 2017-07-11 12:00:00 | AAPL | Stock | 36.28 | 36.305 | 36.1825 | 36.225 | 2958228.0 |
| 2017-07-11 12:30:00 | AAPL | Stock | 36.2275 | 36.295 | 36.2 | 36.2775 | 1902896.0 |
| 2017-07-11 13:00:00 | AAPL | Stock | 36.28 | 36.3475 | 36.25 | 36.32 | 2797072.0 |
| 2017-07-11 13:30:00 | AAPL | Stock | 36.3212 | 36.4325 | 36.3172 | 36.4125 | 3928048.0 |
| 2017-07-11 14:00:00 | AAPL | Stock | 36.4125 | 36.4625 | 36.3892 | 36.4138 | 2928388.0 |
| 2017-07-11 14:30:00 | AAPL | Stock | 36.415 | 36.4275 | 36.3525 | 36.365 | 2748952.0 |
| 2017-07-11 15:00:00 | AAPL | Stock | 36.3638 | 36.4412 | 36.3575 | 36.38 | 3168736.0 |
| 2017-07-11 15:30:00 | AAPL | Stock | 36.38 | 36.445 | 36.3725 | 36.3875 | 7047964.0 |
| 2017-07-11 16:00:00 | AAPL | Stock | 36.3875 | 36.4175 | 36.3825 | 36.3825 | 7938172.0 |
| 2017-07-11 16:30:00 | AAPL | Stock | 36.3825 | 36.3875 | 36.37 | 36.37 | 28164.0 |
| 2017-07-11 17:00:00 | AAPL | Stock | 36.37 | 36.3875 | 36.37 | 36.3875 | 7232.0 |
| 2017-07-11 17:30:00 | AAPL | Stock | 36.3875 | 36.3875 | 36.3825 | 36.3825 | 1220.0 |
| 2017-07-11 18:00:00 | AAPL | Stock | 36.3875 | 36.395 | 36.3825 | 36.3875 | 168720.0 |
| 2017-07-11 18:30:00 | AAPL | Stock | 36.3825 | 36.3875 | 36.3825 | 36.3875 | 2760.0 |
| 2017-07-11 19:00:00 | AAPL | Stock | 36.3875 | 36.3875 | 36.3875 | 36.3875 | 1420.0 |
| 2017-07-11 19:30:00 | AAPL | Stock | 36.39 | 36.395 | 36.3875 | 36.3875 | 7896.0 |
| 2017-07-11 08:00:00 | MSFT | Stock | 69.91 | 69.91 | 69.8 | 69.8 | 3888.0 |
| 2017-07-11 08:30:00 | MSFT | Stock | 69.93 | 69.93 | 69.84 | 69.84 | 250.0 |
| 2017-07-11 09:00:00 | MSFT | Stock | 69.75 | 69.99 | 69.75 | 69.99 | 15176.0 |
| 2017-07-11 09:30:00 | MSFT | Stock | 70.0 | 70.17 | 69.75 | 70.14 | 1789545.0 |
| 2017-07-11 10:00:00 | MSFT | Stock | 70.14 | 70.67 | 70.11 | 70.585 | 1817761.0 |
| 2017-07-11 10:30:00 | MSFT | Stock | 70.585 | 70.68 | 70.35 | 70.375 | 994429.0 |
| 2017-07-11 11:00:00 | MSFT | Stock | 70.376 | 70.48 | 69.82 | 69.93 | 1646426.0 |
| 2017-07-11 11:30:00 | MSFT | Stock | 69.92 | 70.13 | 69.91 | 70.09 | 1202103.0 |
| 2017-07-11 12:00:00 | MSFT | Stock | 70.09 | 70.145 | 69.85 | 69.955 | 554567.0 |
| 2017-07-11 12:30:00 | MSFT | Stock | 69.96 | 70.09 | 69.9 | 70.0 | 395860.0 |
| 2017-07-11 13:00:00 | MSFT | Stock | 70.0 | 70.03 | 69.925 | 69.955 | 345295.0 |
| 2017-07-11 13:30:00 | MSFT | Stock | 69.96 | 70.17 | 69.93 | 70.135 | 666107.0 |
| 2017-07-11 14:00:00 | MSFT | Stock | 70.14 | 70.23 | 70.045 | 70.11 | 601282.0 |
| 2017-07-11 14:30:00 | MSFT | Stock | 70.105 | 70.15 | 70.01 | 70.02 | 553574.0 |
| 2017-07-11 15:00:00 | MSFT | Stock | 70.025 | 70.12 | 70.01 | 70.09 | 990304.0 |
| 2017-07-11 15:30:00 | MSFT | Stock | 70.09 | 70.21 | 69.99 | 70.0 | 2671707.0 |
| 2017-07-11 16:00:00 | MSFT | Stock | 70.0 | 70.1 | 69.99 | 70.0 | 2012648.0 |
| 2017-07-11 16:30:00 | MSFT | Stock | 70.0 | 70.03 | 70.0 | 70.03 | 5176.0 |
| 2017-07-11 17:00:00 | MSFT | Stock | 70.36 | 70.36 | 70.02 | 70.02 | 350.0 |
> showing 50 of 81,120 rows — these rows as CSV