PREVIEW / stock_30min / 2015-08-24
file: by_date/stock_30min/2015/2015-08-24.parquet size: 1.7 MB rows: 90,482 symbols: 3,517
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-24 04:00:00 | AAPL | Stock | 26.36 | 26.36 | 25.25 | 25.35 | 403152.0 |
| 2015-08-24 04:30:00 | AAPL | Stock | 25.345 | 25.4 | 25.2875 | 25.33 | 227948.0 |
| 2015-08-24 05:00:00 | AAPL | Stock | 25.3875 | 25.495 | 25.31 | 25.4375 | 210612.0 |
| 2015-08-24 05:30:00 | AAPL | Stock | 25.4025 | 25.6825 | 25.4025 | 25.5625 | 184388.0 |
| 2015-08-24 06:00:00 | AAPL | Stock | 25.51 | 25.5875 | 25.22 | 25.35 | 406216.0 |
| 2015-08-24 06:30:00 | AAPL | Stock | 25.3475 | 25.5225 | 25.175 | 25.5 | 390232.0 |
| 2015-08-24 07:00:00 | AAPL | Stock | 25.525 | 25.5775 | 25.0725 | 25.3125 | 1631708.0 |
| 2015-08-24 07:30:00 | AAPL | Stock | 25.315 | 25.335 | 24.94 | 25.0 | 2599068.0 |
| 2015-08-24 08:00:00 | AAPL | Stock | 25.0 | 25.5725 | 24.4975 | 24.785 | 8058912.0 |
| 2015-08-24 08:30:00 | AAPL | Stock | 24.785 | 25.05 | 24.775 | 24.9075 | 3955460.0 |
| 2015-08-24 09:00:00 | AAPL | Stock | 24.9075 | 25.2125 | 23.7125 | 23.725 | 10625440.0 |
| 2015-08-24 09:30:00 | AAPL | Stock | 23.725 | 25.8625 | 23.0 | 25.395 | 134918916.0 |
| 2015-08-24 10:00:00 | AAPL | Stock | 25.3975 | 26.45 | 25.25 | 26.1142 | 60127112.0 |
| 2015-08-24 10:30:00 | AAPL | Stock | 26.1132 | 26.305 | 25.6975 | 26.1175 | 37264796.0 |
| 2015-08-24 11:00:00 | AAPL | Stock | 26.1138 | 26.215 | 25.8325 | 26.155 | 28325068.0 |
| 2015-08-24 11:30:00 | AAPL | Stock | 26.1538 | 27.055 | 26.0025 | 26.95 | 46643692.0 |
| 2015-08-24 12:00:00 | AAPL | Stock | 26.9525 | 27.2 | 26.7725 | 26.9525 | 37350832.0 |
| 2015-08-24 12:30:00 | AAPL | Stock | 26.95 | 27.0 | 26.6625 | 26.9475 | 24683592.0 |
| 2015-08-24 13:00:00 | AAPL | Stock | 26.935 | 27.11 | 26.72 | 26.7775 | 19980884.0 |
| 2015-08-24 13:30:00 | AAPL | Stock | 26.775 | 26.778 | 26.285 | 26.3125 | 30839636.0 |
| 2015-08-24 14:00:00 | AAPL | Stock | 26.3128 | 26.455 | 26.0672 | 26.2025 | 24215928.0 |
| 2015-08-24 14:30:00 | AAPL | Stock | 26.2025 | 26.3125 | 25.5908 | 25.665 | 24914392.0 |
| 2015-08-24 15:00:00 | AAPL | Stock | 25.6675 | 26.07 | 25.34 | 25.5698 | 34278832.0 |
| 2015-08-24 15:30:00 | AAPL | Stock | 25.5925 | 26.42 | 25.4525 | 25.7825 | 42666064.0 |
| 2015-08-24 16:00:00 | AAPL | Stock | 25.78 | 26.3025 | 24.9175 | 25.825 | 21426484.0 |
| 2015-08-24 16:30:00 | AAPL | Stock | 25.8375 | 26.25 | 25.8125 | 25.95 | 622632.0 |
| 2015-08-24 17:00:00 | AAPL | Stock | 25.9375 | 25.9375 | 25.775 | 25.86 | 286360.0 |
| 2015-08-24 17:30:00 | AAPL | Stock | 25.8675 | 25.8725 | 25.775 | 25.78 | 95812.0 |
| 2015-08-24 18:00:00 | AAPL | Stock | 25.7925 | 25.945 | 25.7892 | 25.9375 | 180516.0 |
| 2015-08-24 18:30:00 | AAPL | Stock | 25.928 | 25.995 | 25.928 | 25.975 | 166976.0 |
| 2015-08-24 19:00:00 | AAPL | Stock | 25.9625 | 26.0475 | 25.9375 | 26.0 | 118764.0 |
| 2015-08-24 19:30:00 | AAPL | Stock | 26.015 | 26.07 | 26.0 | 26.0625 | 190920.0 |
| 2015-08-24 04:00:00 | MSFT | Stock | 42.35 | 42.35 | 41.6 | 41.71 | 8442.0 |
| 2015-08-24 04:30:00 | MSFT | Stock | 41.6 | 41.6 | 41.54 | 41.54 | 1840.0 |
| 2015-08-24 05:00:00 | MSFT | Stock | 41.65 | 41.85 | 41.65 | 41.81 | 6069.0 |
| 2015-08-24 05:30:00 | MSFT | Stock | 41.84 | 41.85 | 41.8 | 41.8 | 2100.0 |
| 2015-08-24 06:00:00 | MSFT | Stock | 41.82 | 42.0 | 41.64 | 41.64 | 5800.0 |
| 2015-08-24 06:30:00 | MSFT | Stock | 41.65 | 41.87 | 41.61 | 41.76 | 15394.0 |
| 2015-08-24 07:00:00 | MSFT | Stock | 41.72 | 41.74 | 41.51 | 41.59 | 15350.0 |
| 2015-08-24 07:30:00 | MSFT | Stock | 41.5 | 41.6 | 41.32 | 41.4 | 116704.0 |
| 2015-08-24 08:00:00 | MSFT | Stock | 41.43 | 41.61 | 41.05 | 41.26 | 60191.0 |
| 2015-08-24 08:30:00 | MSFT | Stock | 41.27 | 41.45 | 41.05 | 41.14 | 30720.0 |
| 2015-08-24 09:00:00 | MSFT | Stock | 41.14 | 41.45 | 40.25 | 40.81 | 192639.0 |
| 2015-08-24 09:30:00 | MSFT | Stock | 40.45 | 42.69 | 39.72 | 42.4 | 11540105.0 |
| 2015-08-24 10:00:00 | MSFT | Stock | 42.4 | 43.07 | 41.56 | 42.09 | 10687918.0 |
| 2015-08-24 10:30:00 | MSFT | Stock | 42.08 | 42.73 | 41.7 | 42.47 | 6771162.0 |
| 2015-08-24 11:00:00 | MSFT | Stock | 42.47 | 42.54 | 41.96 | 42.24 | 3621302.0 |
| 2015-08-24 11:30:00 | MSFT | Stock | 42.24 | 43.14 | 42.12 | 43.04 | 4825192.0 |
| 2015-08-24 12:00:00 | MSFT | Stock | 43.03 | 43.31 | 42.75 | 43.131 | 4188686.0 |
| 2015-08-24 12:30:00 | MSFT | Stock | 43.13 | 43.22 | 42.69 | 42.93 | 3078305.0 |
> showing 50 of 90,482 rows — these rows as CSV