PREVIEW / stock_30min / 2005-06-30
file: by_date/stock_30min/2005/2005-06-30.parquet size: 838 KB rows: 45,709 symbols: 2,030
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-30 08:00:00 | AAPL | Stock | 1.2989 | 1.3071 | 1.2989 | 1.3068 | 174720.0 |
| 2005-06-30 08:30:00 | AAPL | Stock | 1.3054 | 1.3125 | 1.3043 | 1.3111 | 402836.0 |
| 2005-06-30 09:00:00 | AAPL | Stock | 1.3107 | 1.3111 | 1.3021 | 1.3071 | 1368500.0 |
| 2005-06-30 09:30:00 | AAPL | Stock | 1.3075 | 1.3136 | 1.2968 | 1.2996 | 50112132.0 |
| 2005-06-30 10:00:00 | AAPL | Stock | 1.2996 | 1.3004 | 1.2971 | 1.2982 | 22864352.0 |
| 2005-06-30 10:30:00 | AAPL | Stock | 1.2982 | 1.3061 | 1.2979 | 1.3032 | 25157188.0 |
| 2005-06-30 11:00:00 | AAPL | Stock | 1.3032 | 1.3061 | 1.3007 | 1.305 | 22480220.0 |
| 2005-06-30 11:30:00 | AAPL | Stock | 1.305 | 1.3057 | 1.3021 | 1.3043 | 9486904.0 |
| 2005-06-30 12:00:00 | AAPL | Stock | 1.3043 | 1.3064 | 1.3029 | 1.3054 | 8515164.0 |
| 2005-06-30 12:30:00 | AAPL | Stock | 1.305 | 1.3168 | 1.305 | 1.3164 | 26768028.0 |
| 2005-06-30 13:00:00 | AAPL | Stock | 1.3167 | 1.3239 | 1.3154 | 1.3236 | 26403748.0 |
| 2005-06-30 13:30:00 | AAPL | Stock | 1.3236 | 1.3236 | 1.3189 | 1.3211 | 20697320.0 |
| 2005-06-30 14:00:00 | AAPL | Stock | 1.3211 | 1.3271 | 1.315 | 1.3168 | 50266496.0 |
| 2005-06-30 14:30:00 | AAPL | Stock | 1.3164 | 1.3171 | 1.31 | 1.3143 | 46921588.0 |
| 2005-06-30 15:00:00 | AAPL | Stock | 1.3143 | 1.3229 | 1.3132 | 1.3204 | 29063020.0 |
| 2005-06-30 15:30:00 | AAPL | Stock | 1.3204 | 1.3211 | 1.3121 | 1.3143 | 48611584.0 |
| 2005-06-30 16:00:00 | AAPL | Stock | 1.3139 | 1.3168 | 1.3104 | 1.3146 | 6036324.0 |
| 2005-06-30 16:30:00 | AAPL | Stock | 1.3125 | 1.3146 | 1.3114 | 1.3146 | 666764.0 |
| 2005-06-30 17:30:00 | AAPL | Stock | 1.315 | 1.315 | 1.315 | 1.315 | 44800.0 |
| 2005-06-30 18:00:00 | AAPL | Stock | 1.3136 | 1.3136 | 1.3136 | 1.3136 | 11200.0 |
| 2005-06-30 08:00:00 | MSFT | Stock | 25.1 | 25.15 | 25.1 | 25.15 | 2603.0 |
| 2005-06-30 08:30:00 | MSFT | Stock | 25.15 | 25.15 | 25.13 | 25.14 | 15410.0 |
| 2005-06-30 09:00:00 | MSFT | Stock | 25.14 | 25.15 | 25.05 | 25.06 | 286848.0 |
| 2005-06-30 09:30:00 | MSFT | Stock | 25.06 | 25.14 | 25.04 | 25.08 | 7202131.0 |
| 2005-06-30 10:00:00 | MSFT | Stock | 25.079 | 25.11 | 25.04 | 25.09 | 4466292.0 |
| 2005-06-30 10:30:00 | MSFT | Stock | 25.08 | 25.11 | 25.05 | 25.05 | 4968417.0 |
| 2005-06-30 11:00:00 | MSFT | Stock | 25.05 | 25.08 | 25.0 | 25.01 | 5795712.0 |
| 2005-06-30 11:30:00 | MSFT | Stock | 25.01 | 25.04 | 25.0 | 25.02 | 3223099.0 |
| 2005-06-30 12:00:00 | MSFT | Stock | 25.01 | 25.03 | 25.01 | 25.01 | 1580156.0 |
| 2005-06-30 12:30:00 | MSFT | Stock | 25.01 | 25.05 | 25.01 | 25.03 | 4091380.0 |
| 2005-06-30 13:00:00 | MSFT | Stock | 25.031 | 25.07 | 25.02 | 25.02 | 2396529.0 |
| 2005-06-30 13:30:00 | MSFT | Stock | 25.02 | 25.06 | 24.99 | 25.03 | 4036885.0 |
| 2005-06-30 14:00:00 | MSFT | Stock | 25.02 | 25.06 | 24.93 | 24.97 | 6016716.0 |
| 2005-06-30 14:30:00 | MSFT | Stock | 24.98 | 24.99 | 24.87 | 24.96 | 9267581.0 |
| 2005-06-30 15:00:00 | MSFT | Stock | 24.96 | 25.0 | 24.9 | 24.94 | 6566828.0 |
| 2005-06-30 15:30:00 | MSFT | Stock | 24.94 | 24.95 | 24.82 | 24.84 | 10884347.0 |
| 2005-06-30 16:00:00 | MSFT | Stock | 24.84 | 24.842 | 24.8 | 24.83 | 1391329.0 |
| 2005-06-30 16:30:00 | MSFT | Stock | 24.82 | 24.84 | 24.82 | 24.84 | 51867.0 |
| 2005-06-30 17:00:00 | MSFT | Stock | 24.82 | 24.987 | 24.8 | 24.82 | 1110927.0 |
| 2005-06-30 17:30:00 | MSFT | Stock | 24.81 | 24.82 | 24.81 | 24.81 | 6164.0 |
| 2005-06-30 18:00:00 | MSFT | Stock | 24.82 | 25.48 | 24.79 | 24.82 | 14430.0 |
| 2005-06-30 08:00:00 | NVDA | Stock | 0.225 | 0.225 | 0.225 | 0.225 | 24000.0 |
| 2005-06-30 08:30:00 | NVDA | Stock | 0.2234 | 0.2234 | 0.2234 | 0.2234 | 12000.0 |
| 2005-06-30 09:00:00 | NVDA | Stock | 0.2244 | 0.225 | 0.2233 | 0.225 | 4272000.0 |
| 2005-06-30 09:30:00 | NVDA | Stock | 0.2247 | 0.2262 | 0.2242 | 0.2247 | 81857160.0 |
| 2005-06-30 10:00:00 | NVDA | Stock | 0.2247 | 0.2268 | 0.2247 | 0.2258 | 34937760.0 |
| 2005-06-30 10:30:00 | NVDA | Stock | 0.2259 | 0.2266 | 0.2253 | 0.2257 | 15958440.0 |
| 2005-06-30 11:00:00 | NVDA | Stock | 0.2256 | 0.2256 | 0.2231 | 0.2232 | 60921600.0 |
| 2005-06-30 11:30:00 | NVDA | Stock | 0.2232 | 0.2242 | 0.222 | 0.2226 | 52760280.0 |
| 2005-06-30 12:00:00 | NVDA | Stock | 0.2226 | 0.2229 | 0.2217 | 0.2217 | 35658600.0 |
> showing 50 of 45,709 rows — these rows as CSV