PREVIEW / stock_30min / 2008-11-12
file: by_date/stock_30min/2008/2008-11-12.parquet size: 1.2 MB rows: 69,288 symbols: 3,303
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-12 07:30:00 | AAPL | Stock | 3.3821 | 3.3821 | 3.3821 | 3.3821 | 2800.0 |
| 2008-11-12 08:00:00 | AAPL | Stock | 3.3825 | 3.3918 | 3.3125 | 3.3214 | 2001860.0 |
| 2008-11-12 08:30:00 | AAPL | Stock | 3.3257 | 3.3286 | 3.2982 | 3.3132 | 1816920.0 |
| 2008-11-12 09:00:00 | AAPL | Stock | 3.3132 | 3.3168 | 3.2954 | 3.2996 | 3129868.0 |
| 2008-11-12 09:30:00 | AAPL | Stock | 3.3029 | 3.3132 | 3.2496 | 3.2711 | 163635752.0 |
| 2008-11-12 10:00:00 | AAPL | Stock | 3.2704 | 3.3021 | 3.2632 | 3.2737 | 108743040.0 |
| 2008-11-12 10:30:00 | AAPL | Stock | 3.2746 | 3.33 | 3.2689 | 3.3093 | 127817984.0 |
| 2008-11-12 11:00:00 | AAPL | Stock | 3.3096 | 3.3296 | 3.2857 | 3.3177 | 85551452.0 |
| 2008-11-12 11:30:00 | AAPL | Stock | 3.3179 | 3.3189 | 3.2857 | 3.2975 | 56591780.0 |
| 2008-11-12 12:00:00 | AAPL | Stock | 3.2968 | 3.3018 | 3.2768 | 3.2921 | 46453428.0 |
| 2008-11-12 12:30:00 | AAPL | Stock | 3.2924 | 3.3018 | 3.28 | 3.3007 | 39492740.0 |
| 2008-11-12 13:00:00 | AAPL | Stock | 3.3011 | 3.3043 | 3.2768 | 3.2857 | 41278776.0 |
| 2008-11-12 13:30:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2439 | 3.2564 | 63282548.0 |
| 2008-11-12 14:00:00 | AAPL | Stock | 3.2557 | 3.2611 | 3.2232 | 3.2475 | 81070332.0 |
| 2008-11-12 14:30:00 | AAPL | Stock | 3.2479 | 3.265 | 3.2264 | 3.2275 | 79560180.0 |
| 2008-11-12 15:00:00 | AAPL | Stock | 3.2268 | 3.2321 | 3.2146 | 3.2246 | 89696376.0 |
| 2008-11-12 15:30:00 | AAPL | Stock | 3.2243 | 3.2514 | 3.2171 | 3.2186 | 139520612.0 |
| 2008-11-12 16:00:00 | AAPL | Stock | 3.2186 | 3.2871 | 3.2164 | 3.2214 | 25092900.0 |
| 2008-11-12 16:30:00 | AAPL | Stock | 3.2186 | 3.2674 | 3.2179 | 3.2179 | 3972528.0 |
| 2008-11-12 17:00:00 | AAPL | Stock | 3.2171 | 3.2171 | 3.1071 | 3.1107 | 4342744.0 |
| 2008-11-12 17:30:00 | AAPL | Stock | 3.1107 | 3.1246 | 3.1036 | 3.1239 | 1183532.0 |
| 2008-11-12 18:00:00 | AAPL | Stock | 3.1207 | 3.125 | 3.1107 | 3.1246 | 823228.0 |
| 2008-11-12 18:30:00 | AAPL | Stock | 3.125 | 3.1382 | 3.125 | 3.1354 | 354228.0 |
| 2008-11-12 19:00:00 | AAPL | Stock | 3.135 | 3.1357 | 3.1154 | 3.1268 | 396928.0 |
| 2008-11-12 19:30:00 | AAPL | Stock | 3.1271 | 3.1321 | 3.1193 | 3.1275 | 374052.0 |
| 2008-11-12 05:00:00 | MSFT | Stock | 21.09 | 21.09 | 21.09 | 21.09 | 180.0 |
| 2008-11-12 07:30:00 | MSFT | Stock | 21.13 | 21.14 | 21.13 | 21.14 | 1484.0 |
| 2008-11-12 08:00:00 | MSFT | Stock | 21.12 | 21.12 | 21.01 | 21.08 | 11150.0 |
| 2008-11-12 08:30:00 | MSFT | Stock | 21.08 | 21.1 | 20.95 | 20.95 | 19168.0 |
| 2008-11-12 09:00:00 | MSFT | Stock | 20.91 | 20.93 | 20.85 | 20.86 | 218593.0 |
| 2008-11-12 09:30:00 | MSFT | Stock | 20.89 | 21.0 | 20.83 | 20.85 | 7476224.0 |
| 2008-11-12 10:00:00 | MSFT | Stock | 20.84 | 20.95 | 20.8 | 20.818 | 6681114.0 |
| 2008-11-12 10:30:00 | MSFT | Stock | 20.811 | 20.87 | 20.67 | 20.814 | 7714893.0 |
| 2008-11-12 11:00:00 | MSFT | Stock | 20.82 | 20.87 | 20.7 | 20.83 | 5007835.0 |
| 2008-11-12 11:30:00 | MSFT | Stock | 20.83 | 20.86 | 20.65 | 20.8 | 3676562.0 |
| 2008-11-12 12:00:00 | MSFT | Stock | 20.8 | 20.85 | 20.67 | 20.742 | 3701693.0 |
| 2008-11-12 12:30:00 | MSFT | Stock | 20.74 | 20.84 | 20.74 | 20.81 | 3076423.0 |
| 2008-11-12 13:00:00 | MSFT | Stock | 20.812 | 20.83 | 20.67 | 20.77 | 3051312.0 |
| 2008-11-12 13:30:00 | MSFT | Stock | 20.77 | 20.8 | 20.61 | 20.66 | 3184627.0 |
| 2008-11-12 14:00:00 | MSFT | Stock | 20.66 | 20.7 | 20.54 | 20.65 | 5250730.0 |
| 2008-11-12 14:30:00 | MSFT | Stock | 20.642 | 20.71 | 20.53 | 20.54 | 4171505.0 |
| 2008-11-12 15:00:00 | MSFT | Stock | 20.54 | 20.57 | 20.4 | 20.44 | 6013774.0 |
| 2008-11-12 15:30:00 | MSFT | Stock | 20.45 | 20.54 | 20.28 | 20.3 | 12778885.0 |
| 2008-11-12 16:00:00 | MSFT | Stock | 20.3 | 20.729 | 20.298 | 20.36 | 16914525.0 |
| 2008-11-12 16:30:00 | MSFT | Stock | 20.36 | 21.359 | 20.25 | 20.25 | 425532.0 |
| 2008-11-12 17:00:00 | MSFT | Stock | 20.33 | 20.33 | 19.85 | 19.91 | 181684.0 |
| 2008-11-12 17:30:00 | MSFT | Stock | 19.92 | 19.98 | 19.88 | 19.9 | 41749.0 |
| 2008-11-12 18:00:00 | MSFT | Stock | 19.9 | 19.97 | 19.88 | 19.94 | 20191.0 |
| 2008-11-12 18:30:00 | MSFT | Stock | 19.93 | 19.95 | 19.89 | 19.9 | 12388.0 |
| 2008-11-12 19:00:00 | MSFT | Stock | 19.9 | 19.9 | 19.8 | 19.87 | 14274.0 |
> showing 50 of 69,288 rows — these rows as CSV