PREVIEW / stock_30min / 2015-08-18
file: by_date/stock_30min/2015/2015-08-18.parquet size: 1.6 MB rows: 80,506 symbols: 3,444
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-08-18 04:00:00 | AAPL | Stock | 29.205 | 29.285 | 29.205 | 29.2375 | 18792.0 |
| 2015-08-18 04:30:00 | AAPL | Stock | 29.215 | 29.245 | 29.215 | 29.245 | 840.0 |
| 2015-08-18 05:00:00 | AAPL | Stock | 29.225 | 29.225 | 29.225 | 29.225 | 480.0 |
| 2015-08-18 05:30:00 | AAPL | Stock | 29.2025 | 29.2025 | 29.1325 | 29.1325 | 9228.0 |
| 2015-08-18 06:00:00 | AAPL | Stock | 29.1625 | 29.175 | 29.14 | 29.175 | 21468.0 |
| 2015-08-18 06:30:00 | AAPL | Stock | 29.175 | 29.2 | 29.15 | 29.2 | 16044.0 |
| 2015-08-18 07:00:00 | AAPL | Stock | 29.2 | 29.2 | 29.085 | 29.09 | 55300.0 |
| 2015-08-18 07:30:00 | AAPL | Stock | 29.0925 | 29.125 | 29.0925 | 29.1125 | 39756.0 |
| 2015-08-18 08:00:00 | AAPL | Stock | 29.1125 | 29.155 | 29.0825 | 29.1208 | 339944.0 |
| 2015-08-18 08:30:00 | AAPL | Stock | 29.1375 | 29.19 | 29.125 | 29.1575 | 261484.0 |
| 2015-08-18 09:00:00 | AAPL | Stock | 29.1575 | 29.1675 | 29.055 | 29.1075 | 468732.0 |
| 2015-08-18 09:30:00 | AAPL | Stock | 29.1075 | 29.2325 | 29.0025 | 29.1212 | 23907588.0 |
| 2015-08-18 10:00:00 | AAPL | Stock | 29.1202 | 29.2675 | 29.0725 | 29.1875 | 13512948.0 |
| 2015-08-18 10:30:00 | AAPL | Stock | 29.1875 | 29.285 | 29.17 | 29.2848 | 10114860.0 |
| 2015-08-18 11:00:00 | AAPL | Stock | 29.2825 | 29.325 | 29.23 | 29.255 | 10523208.0 |
| 2015-08-18 11:30:00 | AAPL | Stock | 29.255 | 29.2775 | 29.14 | 29.275 | 8861344.0 |
| 2015-08-18 12:00:00 | AAPL | Stock | 29.2725 | 29.36 | 29.2675 | 29.3125 | 6982148.0 |
| 2015-08-18 12:30:00 | AAPL | Stock | 29.31 | 29.325 | 29.2875 | 29.2925 | 3474284.0 |
| 2015-08-18 13:00:00 | AAPL | Stock | 29.29 | 29.295 | 29.2425 | 29.26 | 4490400.0 |
| 2015-08-18 13:30:00 | AAPL | Stock | 29.26 | 29.265 | 29.135 | 29.1875 | 7883380.0 |
| 2015-08-18 14:00:00 | AAPL | Stock | 29.1852 | 29.25 | 29.175 | 29.2412 | 4802628.0 |
| 2015-08-18 14:30:00 | AAPL | Stock | 29.24 | 29.2425 | 29.08 | 29.1 | 8302388.0 |
| 2015-08-18 15:00:00 | AAPL | Stock | 29.1002 | 29.1575 | 29.0875 | 29.1225 | 8750780.0 |
| 2015-08-18 15:30:00 | AAPL | Stock | 29.12 | 29.1375 | 29.0775 | 29.125 | 12493064.0 |
| 2015-08-18 16:00:00 | AAPL | Stock | 29.125 | 29.185 | 29.1175 | 29.175 | 5108588.0 |
| 2015-08-18 16:30:00 | AAPL | Stock | 29.175 | 29.18 | 29.155 | 29.165 | 27776.0 |
| 2015-08-18 17:00:00 | AAPL | Stock | 29.16 | 29.16 | 29.1475 | 29.15 | 14592.0 |
| 2015-08-18 17:30:00 | AAPL | Stock | 29.1325 | 29.14 | 29.125 | 29.125 | 18928.0 |
| 2015-08-18 18:00:00 | AAPL | Stock | 29.1275 | 29.135 | 29.1258 | 29.13 | 15396.0 |
| 2015-08-18 18:30:00 | AAPL | Stock | 29.1332 | 29.1425 | 29.1325 | 29.1325 | 34100.0 |
| 2015-08-18 19:00:00 | AAPL | Stock | 29.1325 | 29.135 | 29.13 | 29.1342 | 12736.0 |
| 2015-08-18 19:30:00 | AAPL | Stock | 29.135 | 29.145 | 29.135 | 29.1425 | 32108.0 |
| 2015-08-18 04:00:00 | MSFT | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 200.0 |
| 2015-08-18 08:00:00 | MSFT | Stock | 47.0 | 47.0 | 46.95 | 46.95 | 11150.0 |
| 2015-08-18 08:30:00 | MSFT | Stock | 46.99 | 47.03 | 46.99 | 47.01 | 15366.0 |
| 2015-08-18 09:00:00 | MSFT | Stock | 47.05 | 47.09 | 46.86 | 46.86 | 59500.0 |
| 2015-08-18 09:30:00 | MSFT | Stock | 46.86 | 47.05 | 46.7 | 46.99 | 3560606.0 |
| 2015-08-18 10:00:00 | MSFT | Stock | 46.985 | 47.25 | 46.91 | 47.06 | 2093314.0 |
| 2015-08-18 10:30:00 | MSFT | Stock | 47.06 | 47.3 | 47.05 | 47.27 | 1639713.0 |
| 2015-08-18 11:00:00 | MSFT | Stock | 47.27 | 47.365 | 47.18 | 47.27 | 1004646.0 |
| 2015-08-18 11:30:00 | MSFT | Stock | 47.27 | 47.33 | 47.185 | 47.33 | 650039.0 |
| 2015-08-18 12:00:00 | MSFT | Stock | 47.32 | 47.43 | 47.31 | 47.4 | 789889.0 |
| 2015-08-18 12:30:00 | MSFT | Stock | 47.4 | 47.4 | 47.25 | 47.27 | 879378.0 |
| 2015-08-18 13:00:00 | MSFT | Stock | 47.26 | 47.26 | 47.17 | 47.2 | 809735.0 |
| 2015-08-18 13:30:00 | MSFT | Stock | 47.2 | 47.27 | 47.1 | 47.166 | 1228695.0 |
| 2015-08-18 14:00:00 | MSFT | Stock | 47.17 | 47.24 | 47.115 | 47.226 | 875833.0 |
| 2015-08-18 14:30:00 | MSFT | Stock | 47.22 | 47.26 | 47.11 | 47.138 | 823022.0 |
| 2015-08-18 15:00:00 | MSFT | Stock | 47.135 | 47.24 | 47.08 | 47.17 | 1816503.0 |
| 2015-08-18 15:30:00 | MSFT | Stock | 47.17 | 47.32 | 47.1 | 47.27 | 3172880.0 |
| 2015-08-18 16:00:00 | MSFT | Stock | 47.27 | 47.348 | 47.21 | 47.348 | 2168886.0 |
> showing 50 of 80,506 rows — these rows as CSV