PREVIEW / stock_30min / 2008-08-22
file: by_date/stock_30min/2008/2008-08-22.parquet size: 1.2 MB rows: 66,918 symbols: 3,298
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-08-22 07:00:00 | AAPL | Stock | 6.2346 | 6.2346 | 6.2346 | 6.2346 | 9520.0 |
| 2008-08-22 07:30:00 | AAPL | Stock | 6.2711 | 6.2786 | 6.265 | 6.2771 | 509236.0 |
| 2008-08-22 08:00:00 | AAPL | Stock | 6.2682 | 6.275 | 6.2593 | 6.2714 | 1288280.0 |
| 2008-08-22 08:30:00 | AAPL | Stock | 6.2714 | 6.2771 | 6.2643 | 6.2714 | 908488.0 |
| 2008-08-22 09:00:00 | AAPL | Stock | 6.2732 | 6.2861 | 6.2714 | 6.2825 | 2481192.0 |
| 2008-08-22 09:30:00 | AAPL | Stock | 6.2804 | 6.3125 | 6.2704 | 6.2911 | 72892036.0 |
| 2008-08-22 10:00:00 | AAPL | Stock | 6.2918 | 6.3361 | 6.2821 | 6.3239 | 59331244.0 |
| 2008-08-22 10:30:00 | AAPL | Stock | 6.3239 | 6.3393 | 6.31 | 6.3107 | 38010868.0 |
| 2008-08-22 11:00:00 | AAPL | Stock | 6.311 | 6.3204 | 6.2964 | 6.3014 | 23429840.0 |
| 2008-08-22 11:30:00 | AAPL | Stock | 6.3014 | 6.325 | 6.294 | 6.3221 | 21562296.0 |
| 2008-08-22 12:00:00 | AAPL | Stock | 6.3225 | 6.3246 | 6.2964 | 6.3109 | 24797416.0 |
| 2008-08-22 12:30:00 | AAPL | Stock | 6.3114 | 6.3339 | 6.3072 | 6.3304 | 20084652.0 |
| 2008-08-22 13:00:00 | AAPL | Stock | 6.3304 | 6.3393 | 6.3171 | 6.3236 | 28775516.0 |
| 2008-08-22 13:30:00 | AAPL | Stock | 6.3239 | 6.3329 | 6.3107 | 6.3196 | 17321500.0 |
| 2008-08-22 14:00:00 | AAPL | Stock | 6.3195 | 6.3386 | 6.3004 | 6.3332 | 28787472.0 |
| 2008-08-22 14:30:00 | AAPL | Stock | 6.3336 | 6.3393 | 6.315 | 6.3179 | 25256252.0 |
| 2008-08-22 15:00:00 | AAPL | Stock | 6.3179 | 6.325 | 6.3043 | 6.3121 | 20243552.0 |
| 2008-08-22 15:30:00 | AAPL | Stock | 6.3121 | 6.3229 | 6.3029 | 6.3143 | 40607252.0 |
| 2008-08-22 16:00:00 | AAPL | Stock | 6.3111 | 6.3201 | 6.3089 | 6.3096 | 8586004.0 |
| 2008-08-22 16:30:00 | AAPL | Stock | 6.3096 | 6.3214 | 6.3096 | 6.3214 | 734860.0 |
| 2008-08-22 17:00:00 | AAPL | Stock | 6.3196 | 6.3243 | 6.3179 | 6.3214 | 152516.0 |
| 2008-08-22 17:30:00 | AAPL | Stock | 6.3239 | 6.3286 | 6.3239 | 6.3286 | 116032.0 |
| 2008-08-22 18:00:00 | AAPL | Stock | 6.3214 | 6.3232 | 6.3214 | 6.3232 | 19600.0 |
| 2008-08-22 18:30:00 | AAPL | Stock | 6.3232 | 6.3232 | 6.3186 | 6.3186 | 30940.0 |
| 2008-08-22 19:00:00 | AAPL | Stock | 6.3268 | 6.3275 | 6.3214 | 6.3214 | 65240.0 |
| 2008-08-22 19:30:00 | AAPL | Stock | 6.3268 | 6.3286 | 6.3268 | 6.3279 | 33600.0 |
| 2008-08-22 08:00:00 | MSFT | Stock | 27.28 | 27.39 | 27.28 | 27.39 | 1542.0 |
| 2008-08-22 08:30:00 | MSFT | Stock | 27.38 | 27.38 | 27.28 | 27.28 | 1100.0 |
| 2008-08-22 09:00:00 | MSFT | Stock | 27.29 | 27.38 | 27.22 | 27.22 | 29000.0 |
| 2008-08-22 09:30:00 | MSFT | Stock | 27.23 | 27.44 | 27.22 | 27.43 | 3688773.0 |
| 2008-08-22 10:00:00 | MSFT | Stock | 27.43 | 27.53 | 27.34 | 27.428 | 3686559.0 |
| 2008-08-22 10:30:00 | MSFT | Stock | 27.43 | 27.52 | 27.4 | 27.5 | 1908173.0 |
| 2008-08-22 11:00:00 | MSFT | Stock | 27.51 | 27.58 | 27.46 | 27.52 | 2944292.0 |
| 2008-08-22 11:30:00 | MSFT | Stock | 27.53 | 27.64 | 27.47 | 27.62 | 5329612.0 |
| 2008-08-22 12:00:00 | MSFT | Stock | 27.61 | 27.65 | 27.582 | 27.63 | 3712376.0 |
| 2008-08-22 12:30:00 | MSFT | Stock | 27.63 | 27.74 | 27.63 | 27.7 | 2707737.0 |
| 2008-08-22 13:00:00 | MSFT | Stock | 27.69 | 27.79 | 27.68 | 27.72 | 2511786.0 |
| 2008-08-22 13:30:00 | MSFT | Stock | 27.722 | 27.81 | 27.72 | 27.78 | 3210986.0 |
| 2008-08-22 14:00:00 | MSFT | Stock | 27.78 | 27.85 | 27.72 | 27.811 | 3360866.0 |
| 2008-08-22 14:30:00 | MSFT | Stock | 27.81 | 27.88 | 27.8 | 27.82 | 2341253.0 |
| 2008-08-22 15:00:00 | MSFT | Stock | 27.83 | 27.86 | 27.76 | 27.8 | 2524217.0 |
| 2008-08-22 15:30:00 | MSFT | Stock | 27.79 | 27.85 | 27.77 | 27.82 | 6915510.0 |
| 2008-08-22 16:00:00 | MSFT | Stock | 27.81 | 27.87 | 27.281 | 27.79 | 2159189.0 |
| 2008-08-22 16:30:00 | MSFT | Stock | 27.84 | 27.84 | 27.79 | 27.84 | 91823.0 |
| 2008-08-22 17:00:00 | MSFT | Stock | 27.79 | 27.79 | 27.43 | 27.43 | 1178.0 |
| 2008-08-22 17:30:00 | MSFT | Stock | 27.61 | 27.8 | 27.61 | 27.8 | 37600.0 |
| 2008-08-22 08:00:00 | NVDA | Stock | 0.3442 | 0.3445 | 0.3438 | 0.3438 | 100000.0 |
| 2008-08-22 08:30:00 | NVDA | Stock | 0.3418 | 0.3442 | 0.3418 | 0.3442 | 228000.0 |
| 2008-08-22 09:00:00 | NVDA | Stock | 0.3442 | 0.347 | 0.3438 | 0.3438 | 630720.0 |
| 2008-08-22 09:30:00 | NVDA | Stock | 0.3428 | 0.347 | 0.3388 | 0.3413 | 67638600.0 |
> showing 50 of 66,918 rows — these rows as CSV