PREVIEW / stock_30min / 2006-03-17
file: by_date/stock_30min/2006/2006-03-17.parquet size: 911 KB rows: 48,498 symbols: 2,204
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-17 07:00:00 | AAPL | Stock | 2.3196 | 2.3196 | 2.3196 | 2.3196 | 5600.0 |
| 2006-03-17 07:30:00 | AAPL | Stock | 2.3179 | 2.3179 | 2.3125 | 2.3125 | 92400.0 |
| 2006-03-17 08:00:00 | AAPL | Stock | 2.3143 | 2.3179 | 2.3121 | 2.3143 | 1531208.0 |
| 2006-03-17 08:30:00 | AAPL | Stock | 2.3146 | 2.3171 | 2.3125 | 2.3125 | 1121932.0 |
| 2006-03-17 09:00:00 | AAPL | Stock | 2.3129 | 2.315 | 2.3071 | 2.3121 | 2432920.0 |
| 2006-03-17 09:30:00 | AAPL | Stock | 2.3125 | 2.3175 | 2.2896 | 2.3064 | 222384008.0 |
| 2006-03-17 10:00:00 | AAPL | Stock | 2.3061 | 2.3207 | 2.3054 | 2.3111 | 76782468.0 |
| 2006-03-17 10:30:00 | AAPL | Stock | 2.3114 | 2.3129 | 2.2975 | 2.3018 | 55346732.0 |
| 2006-03-17 11:00:00 | AAPL | Stock | 2.3018 | 2.3139 | 2.2975 | 2.3025 | 54363036.0 |
| 2006-03-17 11:30:00 | AAPL | Stock | 2.3018 | 2.3093 | 2.3007 | 2.3036 | 34943328.0 |
| 2006-03-17 12:00:00 | AAPL | Stock | 2.3036 | 2.3118 | 2.3032 | 2.3107 | 33819856.0 |
| 2006-03-17 12:30:00 | AAPL | Stock | 2.3107 | 2.3139 | 2.305 | 2.3111 | 33535516.0 |
| 2006-03-17 13:00:00 | AAPL | Stock | 2.3114 | 2.3171 | 2.3036 | 2.3061 | 36268652.0 |
| 2006-03-17 13:30:00 | AAPL | Stock | 2.3061 | 2.3125 | 2.2986 | 2.3036 | 31178168.0 |
| 2006-03-17 14:00:00 | AAPL | Stock | 2.3036 | 2.3118 | 2.3035 | 2.3118 | 21090692.0 |
| 2006-03-17 14:30:00 | AAPL | Stock | 2.3114 | 2.3164 | 2.3064 | 2.3089 | 33119072.0 |
| 2006-03-17 15:00:00 | AAPL | Stock | 2.3089 | 2.3136 | 2.3043 | 2.305 | 36513568.0 |
| 2006-03-17 15:30:00 | AAPL | Stock | 2.3054 | 2.3407 | 2.2982 | 2.3079 | 78794520.0 |
| 2006-03-17 16:00:00 | AAPL | Stock | 2.3079 | 2.3093 | 2.2968 | 2.3057 | 10682952.0 |
| 2006-03-17 16:30:00 | AAPL | Stock | 2.3057 | 2.3091 | 2.3054 | 2.3086 | 1971760.0 |
| 2006-03-17 17:00:00 | AAPL | Stock | 2.3075 | 2.3093 | 2.3071 | 2.3089 | 138880.0 |
| 2006-03-17 17:30:00 | AAPL | Stock | 2.3071 | 2.3089 | 2.3071 | 2.3089 | 309540.0 |
| 2006-03-17 18:00:00 | AAPL | Stock | 2.3071 | 2.3107 | 2.3071 | 2.3107 | 360948.0 |
| 2006-03-17 04:00:00 | MSFT | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 800.0 |
| 2006-03-17 07:00:00 | MSFT | Stock | 27.27 | 27.27 | 27.27 | 27.27 | 950.0 |
| 2006-03-17 08:00:00 | MSFT | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 600.0 |
| 2006-03-17 08:30:00 | MSFT | Stock | 27.27 | 27.28 | 27.25 | 27.28 | 1220.0 |
| 2006-03-17 09:00:00 | MSFT | Stock | 27.25 | 27.38 | 27.25 | 27.38 | 249826.0 |
| 2006-03-17 09:30:00 | MSFT | Stock | 27.35 | 27.43 | 27.27 | 27.4 | 21687629.0 |
| 2006-03-17 10:00:00 | MSFT | Stock | 27.4 | 27.46 | 27.39 | 27.45 | 6040187.0 |
| 2006-03-17 10:30:00 | MSFT | Stock | 27.45 | 27.53 | 27.4 | 27.42 | 9302892.0 |
| 2006-03-17 11:00:00 | MSFT | Stock | 27.42 | 27.48 | 27.4 | 27.46 | 3543482.0 |
| 2006-03-17 11:30:00 | MSFT | Stock | 27.462 | 27.55 | 27.46 | 27.55 | 3380728.0 |
| 2006-03-17 12:00:00 | MSFT | Stock | 27.55 | 27.6 | 27.5 | 27.6 | 3240829.0 |
| 2006-03-17 12:30:00 | MSFT | Stock | 27.59 | 27.66 | 27.59 | 27.6 | 4490363.0 |
| 2006-03-17 13:00:00 | MSFT | Stock | 27.6 | 27.63 | 27.51 | 27.52 | 4164782.0 |
| 2006-03-17 13:30:00 | MSFT | Stock | 27.52 | 27.54 | 27.5 | 27.54 | 2306412.0 |
| 2006-03-17 14:00:00 | MSFT | Stock | 27.54 | 27.55 | 27.48 | 27.49 | 3224988.0 |
| 2006-03-17 14:30:00 | MSFT | Stock | 27.49 | 27.51 | 27.43 | 27.45 | 5509797.0 |
| 2006-03-17 15:00:00 | MSFT | Stock | 27.45 | 27.47 | 27.39 | 27.4 | 5443995.0 |
| 2006-03-17 15:30:00 | MSFT | Stock | 27.39 | 27.51 | 27.35 | 27.46 | 14183054.0 |
| 2006-03-17 16:00:00 | MSFT | Stock | 27.5 | 27.61 | 27.27 | 27.52 | 4192325.0 |
| 2006-03-17 16:30:00 | MSFT | Stock | 27.52 | 27.55 | 27.5 | 27.55 | 1134342.0 |
| 2006-03-17 17:00:00 | MSFT | Stock | 27.52 | 27.56 | 27.5 | 27.5 | 13700.0 |
| 2006-03-17 17:30:00 | MSFT | Stock | 27.51 | 27.51 | 27.51 | 27.51 | 1600.0 |
| 2006-03-17 18:00:00 | MSFT | Stock | 27.5 | 27.54 | 27.48 | 27.54 | 1841.0 |
| 2006-03-17 07:30:00 | NVDA | Stock | 0.4017 | 0.4017 | 0.4017 | 0.4017 | 12000.0 |
| 2006-03-17 08:00:00 | NVDA | Stock | 0.4017 | 0.4023 | 0.4017 | 0.4022 | 160800.0 |
| 2006-03-17 08:30:00 | NVDA | Stock | 0.4021 | 0.4021 | 0.4021 | 0.4021 | 12000.0 |
| 2006-03-17 09:00:00 | NVDA | Stock | 0.4015 | 0.4019 | 0.4 | 0.4004 | 1008000.0 |
> showing 50 of 48,498 rows — these rows as CSV