PREVIEW / stock_30min / 2009-10-22
file: by_date/stock_30min/2009/2009-10-22.parquet size: 1.3 MB rows: 71,780 symbols: 3,390
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-22 04:00:00 | AAPL | Stock | 7.2893 | 7.2893 | 7.2679 | 7.2679 | 19600.0 |
| 2009-10-22 04:30:00 | AAPL | Stock | 7.2707 | 7.2707 | 7.2689 | 7.2689 | 11200.0 |
| 2009-10-22 05:00:00 | AAPL | Stock | 7.2507 | 7.2511 | 7.2504 | 7.2504 | 15316.0 |
| 2009-10-22 05:30:00 | AAPL | Stock | 7.2589 | 7.2589 | 7.25 | 7.25 | 8400.0 |
| 2009-10-22 06:30:00 | AAPL | Stock | 7.2746 | 7.2875 | 7.2746 | 7.2875 | 20440.0 |
| 2009-10-22 07:00:00 | AAPL | Stock | 7.3057 | 7.3214 | 7.2929 | 7.2968 | 95536.0 |
| 2009-10-22 07:30:00 | AAPL | Stock | 7.3 | 7.3036 | 7.2964 | 7.2964 | 84980.0 |
| 2009-10-22 08:00:00 | AAPL | Stock | 7.3 | 7.3861 | 7.3 | 7.3757 | 4806172.0 |
| 2009-10-22 08:30:00 | AAPL | Stock | 7.3757 | 7.3814 | 7.3186 | 7.3607 | 3546788.0 |
| 2009-10-22 09:00:00 | AAPL | Stock | 7.3607 | 7.3639 | 7.3036 | 7.3036 | 2842504.0 |
| 2009-10-22 09:30:00 | AAPL | Stock | 7.3111 | 7.4232 | 7.3 | 7.3611 | 157010784.0 |
| 2009-10-22 10:00:00 | AAPL | Stock | 7.3617 | 7.3968 | 7.3482 | 7.3599 | 86185176.0 |
| 2009-10-22 10:30:00 | AAPL | Stock | 7.3593 | 7.375 | 7.3129 | 7.3546 | 79532320.0 |
| 2009-10-22 11:00:00 | AAPL | Stock | 7.3546 | 7.3621 | 7.3214 | 7.3293 | 40657652.0 |
| 2009-10-22 11:30:00 | AAPL | Stock | 7.3271 | 7.3357 | 7.2636 | 7.2636 | 64161188.0 |
| 2009-10-22 12:00:00 | AAPL | Stock | 7.2639 | 7.3027 | 7.2632 | 7.2746 | 33378576.0 |
| 2009-10-22 12:30:00 | AAPL | Stock | 7.2743 | 7.3214 | 7.2743 | 7.3114 | 30247588.0 |
| 2009-10-22 13:00:00 | AAPL | Stock | 7.3111 | 7.3211 | 7.2857 | 7.2907 | 25228000.0 |
| 2009-10-22 13:30:00 | AAPL | Stock | 7.2907 | 7.3 | 7.2504 | 7.2675 | 46548180.0 |
| 2009-10-22 14:00:00 | AAPL | Stock | 7.2679 | 7.3214 | 7.2643 | 7.3061 | 52357284.0 |
| 2009-10-22 14:30:00 | AAPL | Stock | 7.3061 | 7.3318 | 7.2325 | 7.3257 | 44260552.0 |
| 2009-10-22 15:00:00 | AAPL | Stock | 7.3259 | 7.3443 | 7.3179 | 7.3389 | 50118740.0 |
| 2009-10-22 15:30:00 | AAPL | Stock | 7.3393 | 7.3464 | 7.3139 | 7.3286 | 52084592.0 |
| 2009-10-22 16:00:00 | AAPL | Stock | 7.3286 | 7.3461 | 7.3179 | 7.3364 | 9190552.0 |
| 2009-10-22 16:30:00 | AAPL | Stock | 7.3393 | 7.3464 | 7.3375 | 7.3418 | 330708.0 |
| 2009-10-22 17:00:00 | AAPL | Stock | 7.3414 | 7.3482 | 7.3414 | 7.3482 | 733068.0 |
| 2009-10-22 17:30:00 | AAPL | Stock | 7.3482 | 7.35 | 7.3446 | 7.35 | 106736.0 |
| 2009-10-22 18:00:00 | AAPL | Stock | 7.345 | 7.35 | 7.3171 | 7.3493 | 227220.0 |
| 2009-10-22 18:30:00 | AAPL | Stock | 7.3493 | 7.3564 | 7.3493 | 7.3539 | 181748.0 |
| 2009-10-22 19:00:00 | AAPL | Stock | 7.3543 | 7.3571 | 7.3529 | 7.3536 | 278908.0 |
| 2009-10-22 19:30:00 | AAPL | Stock | 7.3529 | 7.3571 | 7.3286 | 7.3518 | 239092.0 |
| 2009-10-22 20:00:00 | AAPL | Stock | 7.2846 | 7.2846 | 7.2846 | 7.2846 | 5600.0 |
| 2009-10-22 05:30:00 | MSFT | Stock | 26.63 | 26.63 | 26.63 | 26.63 | 2000.0 |
| 2009-10-22 07:00:00 | MSFT | Stock | 26.63 | 26.75 | 26.63 | 26.73 | 6298.0 |
| 2009-10-22 07:30:00 | MSFT | Stock | 26.75 | 26.75 | 26.72 | 26.72 | 6705.0 |
| 2009-10-22 08:00:00 | MSFT | Stock | 26.77 | 26.77 | 26.61 | 26.77 | 28184.0 |
| 2009-10-22 08:30:00 | MSFT | Stock | 26.74 | 26.75 | 26.58 | 26.7 | 164918.0 |
| 2009-10-22 09:00:00 | MSFT | Stock | 26.7 | 26.7 | 26.55 | 26.56 | 57253.0 |
| 2009-10-22 09:30:00 | MSFT | Stock | 26.56 | 26.72 | 26.35 | 26.46 | 6332305.0 |
| 2009-10-22 10:00:00 | MSFT | Stock | 26.46 | 26.47 | 26.3 | 26.35 | 4364212.0 |
| 2009-10-22 10:30:00 | MSFT | Stock | 26.36 | 26.38 | 26.17 | 26.2 | 5514596.0 |
| 2009-10-22 11:00:00 | MSFT | Stock | 26.2 | 26.23 | 26.15 | 26.16 | 4037663.0 |
| 2009-10-22 11:30:00 | MSFT | Stock | 26.16 | 26.3 | 26.13 | 26.29 | 3458400.0 |
| 2009-10-22 12:00:00 | MSFT | Stock | 26.28 | 26.4 | 26.25 | 26.31 | 3082596.0 |
| 2009-10-22 12:30:00 | MSFT | Stock | 26.31 | 26.44 | 26.31 | 26.41 | 2178975.0 |
| 2009-10-22 13:00:00 | MSFT | Stock | 26.42 | 26.49 | 26.415 | 26.483 | 1872534.0 |
| 2009-10-22 13:30:00 | MSFT | Stock | 26.488 | 26.49 | 26.32 | 26.41 | 2923376.0 |
| 2009-10-22 14:00:00 | MSFT | Stock | 26.41 | 26.59 | 26.41 | 26.58 | 3367394.0 |
| 2009-10-22 14:30:00 | MSFT | Stock | 26.58 | 26.6 | 26.48 | 26.538 | 4149622.0 |
| 2009-10-22 15:00:00 | MSFT | Stock | 26.54 | 26.6 | 26.45 | 26.49 | 5550342.0 |
> showing 50 of 71,780 rows — these rows as CSV