PREVIEW / stock_30min / 2010-06-24
file: by_date/stock_30min/2010/2010-06-24.parquet size: 1.3 MB rows: 72,884 symbols: 3,437
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-24 05:30:00 | AAPL | Stock | 9.6429 | 9.6429 | 9.6429 | 9.6429 | 28000.0 |
| 2010-06-24 07:00:00 | AAPL | Stock | 9.6489 | 9.6518 | 9.6286 | 9.6436 | 47460.0 |
| 2010-06-24 07:30:00 | AAPL | Stock | 9.6321 | 9.6389 | 9.6021 | 9.6136 | 446964.0 |
| 2010-06-24 08:00:00 | AAPL | Stock | 9.6121 | 9.6429 | 9.5989 | 9.6107 | 2514540.0 |
| 2010-06-24 08:30:00 | AAPL | Stock | 9.6089 | 9.7104 | 9.6089 | 9.6836 | 5623296.0 |
| 2010-06-24 09:00:00 | AAPL | Stock | 9.6832 | 9.7125 | 9.6807 | 9.6821 | 2320304.0 |
| 2010-06-24 09:30:00 | AAPL | Stock | 9.6829 | 9.757 | 9.6307 | 9.64 | 124564272.0 |
| 2010-06-24 10:00:00 | AAPL | Stock | 9.6414 | 9.7211 | 9.6404 | 9.6893 | 78576316.0 |
| 2010-06-24 10:30:00 | AAPL | Stock | 9.6893 | 9.6929 | 9.6071 | 9.6471 | 51317504.0 |
| 2010-06-24 11:00:00 | AAPL | Stock | 9.6471 | 9.6479 | 9.6071 | 9.6304 | 47058648.0 |
| 2010-06-24 11:30:00 | AAPL | Stock | 9.6311 | 9.6864 | 9.6225 | 9.6586 | 36430128.0 |
| 2010-06-24 12:00:00 | AAPL | Stock | 9.6589 | 9.6875 | 9.6379 | 9.6443 | 25562096.0 |
| 2010-06-24 12:30:00 | AAPL | Stock | 9.6459 | 9.6553 | 9.6111 | 9.6461 | 27660948.0 |
| 2010-06-24 13:00:00 | AAPL | Stock | 9.6461 | 9.6768 | 9.6257 | 9.6601 | 24421096.0 |
| 2010-06-24 13:30:00 | AAPL | Stock | 9.6596 | 9.7314 | 9.6586 | 9.7261 | 45088708.0 |
| 2010-06-24 14:00:00 | AAPL | Stock | 9.7254 | 9.7261 | 9.6761 | 9.6936 | 34140820.0 |
| 2010-06-24 14:30:00 | AAPL | Stock | 9.6927 | 9.6927 | 9.6189 | 9.6346 | 51912056.0 |
| 2010-06-24 15:00:00 | AAPL | Stock | 9.6337 | 9.6532 | 9.575 | 9.6168 | 72627856.0 |
| 2010-06-24 15:30:00 | AAPL | Stock | 9.6146 | 9.6282 | 9.5893 | 9.5975 | 56576296.0 |
| 2010-06-24 16:00:00 | AAPL | Stock | 9.5975 | 9.6562 | 9.5961 | 9.6161 | 16150204.0 |
| 2010-06-24 16:30:00 | AAPL | Stock | 9.6164 | 9.6354 | 9.6118 | 9.6293 | 847448.0 |
| 2010-06-24 17:00:00 | AAPL | Stock | 9.6257 | 9.6536 | 9.6218 | 9.6468 | 1489460.0 |
| 2010-06-24 17:30:00 | AAPL | Stock | 9.6482 | 9.6536 | 9.6393 | 9.6446 | 298396.0 |
| 2010-06-24 18:00:00 | AAPL | Stock | 9.6429 | 9.6486 | 9.6071 | 9.6429 | 214620.0 |
| 2010-06-24 18:30:00 | AAPL | Stock | 9.6446 | 9.6482 | 9.6382 | 9.6464 | 125468.0 |
| 2010-06-24 19:00:00 | AAPL | Stock | 9.6471 | 9.6529 | 9.6446 | 9.6482 | 156380.0 |
| 2010-06-24 19:30:00 | AAPL | Stock | 9.6468 | 9.66 | 9.6429 | 9.6589 | 447832.0 |
| 2010-06-24 07:30:00 | MSFT | Stock | 25.2 | 25.2 | 25.11 | 25.18 | 4940.0 |
| 2010-06-24 08:00:00 | MSFT | Stock | 25.19 | 25.2 | 25.15 | 25.15 | 9823.0 |
| 2010-06-24 08:30:00 | MSFT | Stock | 25.2 | 25.45 | 25.2 | 25.45 | 233077.0 |
| 2010-06-24 09:00:00 | MSFT | Stock | 25.44 | 25.53 | 25.38 | 25.47 | 498155.0 |
| 2010-06-24 09:30:00 | MSFT | Stock | 25.46 | 25.72 | 25.21 | 25.23 | 11836332.0 |
| 2010-06-24 10:00:00 | MSFT | Stock | 25.23 | 25.39 | 25.14 | 25.18 | 8567597.0 |
| 2010-06-24 10:30:00 | MSFT | Stock | 25.19 | 25.19 | 25.02 | 25.105 | 6995662.0 |
| 2010-06-24 11:00:00 | MSFT | Stock | 25.11 | 25.18 | 24.99 | 25.061 | 6281146.0 |
| 2010-06-24 11:30:00 | MSFT | Stock | 25.06 | 25.195 | 25.04 | 25.14 | 2472805.0 |
| 2010-06-24 12:00:00 | MSFT | Stock | 25.135 | 25.195 | 25.08 | 25.09 | 2223114.0 |
| 2010-06-24 12:30:00 | MSFT | Stock | 25.1 | 25.11 | 24.99 | 25.08 | 3334764.0 |
| 2010-06-24 13:00:00 | MSFT | Stock | 25.08 | 25.23 | 25.05 | 25.22 | 2631658.0 |
| 2010-06-24 13:30:00 | MSFT | Stock | 25.215 | 25.39 | 25.1 | 25.39 | 2927194.0 |
| 2010-06-24 14:00:00 | MSFT | Stock | 25.385 | 25.44 | 25.24 | 25.285 | 4603219.0 |
| 2010-06-24 14:30:00 | MSFT | Stock | 25.289 | 25.29 | 25.01 | 25.05 | 3940063.0 |
| 2010-06-24 15:00:00 | MSFT | Stock | 25.05 | 25.12 | 24.98 | 25.039 | 7283573.0 |
| 2010-06-24 15:30:00 | MSFT | Stock | 25.032 | 25.158 | 24.93 | 25.0 | 11797169.0 |
| 2010-06-24 16:00:00 | MSFT | Stock | 25.0 | 25.17 | 24.946 | 25.05 | 7239187.0 |
| 2010-06-24 16:30:00 | MSFT | Stock | 25.05 | 25.09 | 25.01 | 25.09 | 40599.0 |
| 2010-06-24 17:00:00 | MSFT | Stock | 25.08 | 25.09 | 25.03 | 25.03 | 7550.0 |
| 2010-06-24 17:30:00 | MSFT | Stock | 25.03 | 25.12 | 25.02 | 25.12 | 13075.0 |
| 2010-06-24 18:00:00 | MSFT | Stock | 25.0 | 25.05 | 25.0 | 25.05 | 25237.0 |
| 2010-06-24 18:30:00 | MSFT | Stock | 25.09 | 25.09 | 25.07 | 25.07 | 2700.0 |
> showing 50 of 72,884 rows — these rows as CSV