PREVIEW / stock_30min / 2010-11-11
file: by_date/stock_30min/2010/2010-11-11.parquet size: 1.4 MB rows: 73,868 symbols: 3,491
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-11-11 04:00:00 | AAPL | Stock | 11.25 | 11.2607 | 11.25 | 11.2607 | 5600.0 |
| 2010-11-11 04:30:00 | AAPL | Stock | 11.2982 | 11.2982 | 11.2982 | 11.2982 | 2800.0 |
| 2010-11-11 05:00:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 05:30:00 | AAPL | Stock | 11.2893 | 11.2893 | 11.2893 | 11.2893 | 2800.0 |
| 2010-11-11 06:00:00 | AAPL | Stock | 11.2954 | 11.2954 | 11.2911 | 11.2911 | 11200.0 |
| 2010-11-11 06:30:00 | AAPL | Stock | 11.2664 | 11.2857 | 11.2664 | 11.2857 | 5600.0 |
| 2010-11-11 07:00:00 | AAPL | Stock | 11.2782 | 11.3179 | 11.2782 | 11.2871 | 84000.0 |
| 2010-11-11 07:30:00 | AAPL | Stock | 11.2693 | 11.27 | 11.2554 | 11.2571 | 130200.0 |
| 2010-11-11 08:00:00 | AAPL | Stock | 11.2607 | 11.2961 | 11.2571 | 11.2832 | 1008084.0 |
| 2010-11-11 08:30:00 | AAPL | Stock | 11.2786 | 11.2793 | 11.2657 | 11.2657 | 588560.0 |
| 2010-11-11 09:00:00 | AAPL | Stock | 11.2675 | 11.2779 | 11.2507 | 11.2521 | 1152536.0 |
| 2010-11-11 09:30:00 | AAPL | Stock | 11.2518 | 11.3293 | 11.2232 | 11.3146 | 78556604.0 |
| 2010-11-11 10:00:00 | AAPL | Stock | 11.3143 | 11.3714 | 11.2921 | 11.3514 | 46941692.0 |
| 2010-11-11 10:30:00 | AAPL | Stock | 11.3507 | 11.3536 | 11.3064 | 11.3461 | 28044548.0 |
| 2010-11-11 11:00:00 | AAPL | Stock | 11.3475 | 11.3496 | 11.2982 | 11.3039 | 18632796.0 |
| 2010-11-11 11:30:00 | AAPL | Stock | 11.3036 | 11.3471 | 11.2993 | 11.3396 | 17490676.0 |
| 2010-11-11 12:00:00 | AAPL | Stock | 11.3382 | 11.3646 | 11.3346 | 11.3543 | 15814120.0 |
| 2010-11-11 12:30:00 | AAPL | Stock | 11.3546 | 11.3604 | 11.3218 | 11.3286 | 14119168.0 |
| 2010-11-11 13:00:00 | AAPL | Stock | 11.3279 | 11.3285 | 11.3039 | 11.32 | 15344084.0 |
| 2010-11-11 13:30:00 | AAPL | Stock | 11.3196 | 11.3571 | 11.3089 | 11.3471 | 16919056.0 |
| 2010-11-11 14:00:00 | AAPL | Stock | 11.3475 | 11.3564 | 11.3332 | 11.3439 | 12755652.0 |
| 2010-11-11 14:30:00 | AAPL | Stock | 11.3446 | 11.3625 | 11.3182 | 11.3257 | 17003140.0 |
| 2010-11-11 15:00:00 | AAPL | Stock | 11.3252 | 11.3321 | 11.305 | 11.3168 | 20135500.0 |
| 2010-11-11 15:30:00 | AAPL | Stock | 11.3175 | 11.3179 | 11.2911 | 11.305 | 41472592.0 |
| 2010-11-11 16:00:00 | AAPL | Stock | 11.3068 | 11.3289 | 11.259 | 11.3111 | 7063112.0 |
| 2010-11-11 16:30:00 | AAPL | Stock | 11.3093 | 11.3173 | 11.3047 | 11.3139 | 216664.0 |
| 2010-11-11 17:00:00 | AAPL | Stock | 11.3111 | 11.3132 | 11.3082 | 11.3132 | 35000.0 |
| 2010-11-11 17:30:00 | AAPL | Stock | 11.3107 | 11.3186 | 11.3107 | 11.3132 | 181664.0 |
| 2010-11-11 18:00:00 | AAPL | Stock | 11.3171 | 11.3171 | 11.3054 | 11.3054 | 105028.0 |
| 2010-11-11 18:30:00 | AAPL | Stock | 11.3086 | 11.3107 | 11.3086 | 11.3089 | 28000.0 |
| 2010-11-11 19:00:00 | AAPL | Stock | 11.3089 | 11.3171 | 11.3057 | 11.3171 | 48664.0 |
| 2010-11-11 19:30:00 | AAPL | Stock | 11.3157 | 11.3311 | 11.3157 | 11.3286 | 199052.0 |
| 2010-11-11 06:00:00 | MSFT | Stock | 26.74 | 26.74 | 26.74 | 26.74 | 1000.0 |
| 2010-11-11 07:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.65 | 26.7 | 3338.0 |
| 2010-11-11 07:30:00 | MSFT | Stock | 26.68 | 26.68 | 26.57 | 26.63 | 16200.0 |
| 2010-11-11 08:00:00 | MSFT | Stock | 26.6 | 26.65 | 26.56 | 26.6 | 29207.0 |
| 2010-11-11 08:30:00 | MSFT | Stock | 26.6 | 26.64 | 26.6 | 26.61 | 26700.0 |
| 2010-11-11 09:00:00 | MSFT | Stock | 26.63 | 26.69 | 26.6 | 26.67 | 55058.0 |
| 2010-11-11 09:30:00 | MSFT | Stock | 26.67 | 26.69 | 26.28 | 26.475 | 11839342.0 |
| 2010-11-11 10:00:00 | MSFT | Stock | 26.475 | 26.52 | 26.41 | 26.44 | 5409116.0 |
| 2010-11-11 10:30:00 | MSFT | Stock | 26.447 | 26.51 | 26.4 | 26.5 | 4463830.0 |
| 2010-11-11 11:00:00 | MSFT | Stock | 26.5 | 26.55 | 26.48 | 26.518 | 5015084.0 |
| 2010-11-11 11:30:00 | MSFT | Stock | 26.515 | 26.62 | 26.5 | 26.607 | 3829667.0 |
| 2010-11-11 12:00:00 | MSFT | Stock | 26.6 | 26.61 | 26.55 | 26.565 | 2553284.0 |
| 2010-11-11 12:30:00 | MSFT | Stock | 26.565 | 26.57 | 26.46 | 26.51 | 4665619.0 |
| 2010-11-11 13:00:00 | MSFT | Stock | 26.52 | 26.54 | 26.49 | 26.515 | 1734053.0 |
| 2010-11-11 13:30:00 | MSFT | Stock | 26.53 | 26.62 | 26.51 | 26.61 | 3244231.0 |
| 2010-11-11 14:00:00 | MSFT | Stock | 26.62 | 26.7 | 26.58 | 26.66 | 2272030.0 |
| 2010-11-11 14:30:00 | MSFT | Stock | 26.67 | 26.72 | 26.665 | 26.69 | 3333678.0 |
| 2010-11-11 15:00:00 | MSFT | Stock | 26.691 | 26.7 | 26.63 | 26.7 | 2753748.0 |
> showing 50 of 73,868 rows — these rows as CSV