PREVIEW / stock_30min / 2009-03-11
file: by_date/stock_30min/2009/2009-03-11.parquet size: 1.2 MB rows: 69,318 symbols: 3,331
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-03-11 06:00:00 | AAPL | Stock | 3.1964 | 3.1964 | 3.1964 | 3.1964 | 8400.0 |
| 2009-03-11 07:00:00 | AAPL | Stock | 3.2004 | 3.2071 | 3.1979 | 3.2071 | 25200.0 |
| 2009-03-11 07:30:00 | AAPL | Stock | 3.2068 | 3.2107 | 3.1868 | 3.1868 | 161000.0 |
| 2009-03-11 08:00:00 | AAPL | Stock | 3.205 | 3.2054 | 3.1839 | 3.1982 | 660016.0 |
| 2009-03-11 08:30:00 | AAPL | Stock | 3.1982 | 3.2093 | 3.1964 | 3.2071 | 1104096.0 |
| 2009-03-11 09:00:00 | AAPL | Stock | 3.2093 | 3.2143 | 3.205 | 3.2086 | 1521408.0 |
| 2009-03-11 09:30:00 | AAPL | Stock | 3.2075 | 3.2982 | 3.1993 | 3.2903 | 142249212.0 |
| 2009-03-11 10:00:00 | AAPL | Stock | 3.2907 | 3.3196 | 3.2775 | 3.3196 | 100504684.0 |
| 2009-03-11 10:30:00 | AAPL | Stock | 3.3193 | 3.3286 | 3.2904 | 3.3179 | 57606248.0 |
| 2009-03-11 11:00:00 | AAPL | Stock | 3.3179 | 3.3386 | 3.3064 | 3.3125 | 53165980.0 |
| 2009-03-11 11:30:00 | AAPL | Stock | 3.3127 | 3.3239 | 3.2957 | 3.315 | 41822004.0 |
| 2009-03-11 12:00:00 | AAPL | Stock | 3.3154 | 3.3236 | 3.2989 | 3.3132 | 26431300.0 |
| 2009-03-11 12:30:00 | AAPL | Stock | 3.3125 | 3.3136 | 3.2943 | 3.2968 | 31858372.0 |
| 2009-03-11 13:00:00 | AAPL | Stock | 3.2964 | 3.3286 | 3.2957 | 3.3168 | 38646300.0 |
| 2009-03-11 13:30:00 | AAPL | Stock | 3.3171 | 3.3529 | 3.3168 | 3.3518 | 50442616.0 |
| 2009-03-11 14:00:00 | AAPL | Stock | 3.3521 | 3.3596 | 3.3118 | 3.3282 | 71343524.0 |
| 2009-03-11 14:30:00 | AAPL | Stock | 3.3279 | 3.3468 | 3.3239 | 3.3283 | 44361100.0 |
| 2009-03-11 15:00:00 | AAPL | Stock | 3.3282 | 3.3468 | 3.3182 | 3.3371 | 57891232.0 |
| 2009-03-11 15:30:00 | AAPL | Stock | 3.3368 | 3.3543 | 3.3075 | 3.31 | 96678260.0 |
| 2009-03-11 16:00:00 | AAPL | Stock | 3.3096 | 3.3328 | 3.3092 | 3.3196 | 20658484.0 |
| 2009-03-11 16:30:00 | AAPL | Stock | 3.3204 | 3.3318 | 3.3204 | 3.3279 | 259392.0 |
| 2009-03-11 17:00:00 | AAPL | Stock | 3.3214 | 3.3307 | 3.3214 | 3.3279 | 117740.0 |
| 2009-03-11 17:30:00 | AAPL | Stock | 3.3279 | 3.3307 | 3.3268 | 3.3304 | 104300.0 |
| 2009-03-11 18:00:00 | AAPL | Stock | 3.3304 | 3.3357 | 3.31 | 3.3286 | 1154020.0 |
| 2009-03-11 18:30:00 | AAPL | Stock | 3.3304 | 3.3357 | 3.3268 | 3.3354 | 52976.0 |
| 2009-03-11 19:00:00 | AAPL | Stock | 3.3286 | 3.3382 | 3.3286 | 3.3339 | 83048.0 |
| 2009-03-11 19:30:00 | AAPL | Stock | 3.3282 | 3.3282 | 3.3189 | 3.325 | 273840.0 |
| 2009-03-11 08:00:00 | MSFT | Stock | 16.57 | 16.67 | 16.57 | 16.65 | 11305.0 |
| 2009-03-11 08:30:00 | MSFT | Stock | 16.63 | 16.64 | 16.58 | 16.58 | 10678.0 |
| 2009-03-11 09:00:00 | MSFT | Stock | 16.59 | 16.65 | 16.53 | 16.62 | 35480.0 |
| 2009-03-11 09:30:00 | MSFT | Stock | 16.62 | 16.95 | 16.43 | 16.781 | 10719420.0 |
| 2009-03-11 10:00:00 | MSFT | Stock | 16.78 | 17.03 | 16.66 | 17.02 | 7509397.0 |
| 2009-03-11 10:30:00 | MSFT | Stock | 17.02 | 17.06 | 16.79 | 16.94 | 6096193.0 |
| 2009-03-11 11:00:00 | MSFT | Stock | 16.95 | 16.99 | 16.85 | 16.86 | 5519519.0 |
| 2009-03-11 11:30:00 | MSFT | Stock | 16.85 | 16.88 | 16.73 | 16.8 | 3421717.0 |
| 2009-03-11 12:00:00 | MSFT | Stock | 16.806 | 16.91 | 16.76 | 16.808 | 3056819.0 |
| 2009-03-11 12:30:00 | MSFT | Stock | 16.82 | 16.86 | 16.67 | 16.7 | 3300145.0 |
| 2009-03-11 13:00:00 | MSFT | Stock | 16.7 | 16.84 | 16.68 | 16.79 | 4236803.0 |
| 2009-03-11 13:30:00 | MSFT | Stock | 16.79 | 16.96 | 16.79 | 16.898 | 4992648.0 |
| 2009-03-11 14:00:00 | MSFT | Stock | 16.91 | 16.95 | 16.68 | 16.73 | 3097749.0 |
| 2009-03-11 14:30:00 | MSFT | Stock | 16.72 | 16.89 | 16.72 | 16.835 | 3482685.0 |
| 2009-03-11 15:00:00 | MSFT | Stock | 16.82 | 17.09 | 16.82 | 17.03 | 7781684.0 |
| 2009-03-11 15:30:00 | MSFT | Stock | 17.04 | 17.2 | 17.01 | 17.13 | 14204775.0 |
| 2009-03-11 16:00:00 | MSFT | Stock | 17.12 | 17.13 | 16.877 | 17.04 | 2688884.0 |
| 2009-03-11 16:30:00 | MSFT | Stock | 16.884 | 17.08 | 16.884 | 17.08 | 28241.0 |
| 2009-03-11 17:00:00 | MSFT | Stock | 17.11 | 17.11 | 17.05 | 17.09 | 239278.0 |
| 2009-03-11 17:30:00 | MSFT | Stock | 16.827 | 17.1 | 16.827 | 17.08 | 37055.0 |
| 2009-03-11 18:00:00 | MSFT | Stock | 17.11 | 17.11 | 17.08 | 17.08 | 178108.0 |
| 2009-03-11 18:30:00 | MSFT | Stock | 17.06 | 17.06 | 17.05 | 17.05 | 3626.0 |
| 2009-03-11 19:00:00 | MSFT | Stock | 17.04 | 17.05 | 17.01 | 17.05 | 10000.0 |
> showing 50 of 69,318 rows — these rows as CSV