PREVIEW / stock_30min / 2007-03-29
file: by_date/stock_30min/2007/2007-03-29.parquet size: 1.0 MB rows: 55,097 symbols: 2,548
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-29 05:30:00 | AAPL | Stock | 3.3489 | 3.3489 | 3.3489 | 3.3489 | 4200.0 |
| 2007-03-29 07:00:00 | AAPL | Stock | 3.3554 | 3.3679 | 3.3554 | 3.3679 | 182504.0 |
| 2007-03-29 07:30:00 | AAPL | Stock | 3.3582 | 3.3625 | 3.3554 | 3.3554 | 88844.0 |
| 2007-03-29 08:00:00 | AAPL | Stock | 3.3607 | 3.3607 | 3.3496 | 3.3511 | 1509508.0 |
| 2007-03-29 08:30:00 | AAPL | Stock | 3.3518 | 3.3607 | 3.3518 | 3.3579 | 2545956.0 |
| 2007-03-29 09:00:00 | AAPL | Stock | 3.3589 | 3.3657 | 3.3557 | 3.3625 | 2862888.0 |
| 2007-03-29 09:30:00 | AAPL | Stock | 3.3636 | 3.3639 | 3.3364 | 3.3456 | 97463660.0 |
| 2007-03-29 10:00:00 | AAPL | Stock | 3.345 | 3.3518 | 3.3314 | 3.3468 | 59295600.0 |
| 2007-03-29 10:30:00 | AAPL | Stock | 3.3469 | 3.3479 | 3.335 | 3.3379 | 46144364.0 |
| 2007-03-29 11:00:00 | AAPL | Stock | 3.3379 | 3.3482 | 3.3371 | 3.3468 | 34765164.0 |
| 2007-03-29 11:30:00 | AAPL | Stock | 3.3471 | 3.3543 | 3.3304 | 3.3311 | 45284316.0 |
| 2007-03-29 12:00:00 | AAPL | Stock | 3.3311 | 3.3354 | 3.3214 | 3.3243 | 53823196.0 |
| 2007-03-29 12:30:00 | AAPL | Stock | 3.3254 | 3.3339 | 3.3216 | 3.3293 | 28002380.0 |
| 2007-03-29 13:00:00 | AAPL | Stock | 3.3289 | 3.3357 | 3.3196 | 3.3296 | 38472616.0 |
| 2007-03-29 13:30:00 | AAPL | Stock | 3.33 | 3.3314 | 3.3136 | 3.3164 | 32884936.0 |
| 2007-03-29 14:00:00 | AAPL | Stock | 3.3164 | 3.3186 | 3.2939 | 3.3025 | 75214440.0 |
| 2007-03-29 14:30:00 | AAPL | Stock | 3.3021 | 3.3139 | 3.2957 | 3.3121 | 43363236.0 |
| 2007-03-29 15:00:00 | AAPL | Stock | 3.3125 | 3.3346 | 3.305 | 3.3321 | 64742804.0 |
| 2007-03-29 15:30:00 | AAPL | Stock | 3.3325 | 3.3482 | 3.3279 | 3.3479 | 75761728.0 |
| 2007-03-29 16:00:00 | AAPL | Stock | 3.3482 | 3.3504 | 3.345 | 3.3461 | 11306512.0 |
| 2007-03-29 16:30:00 | AAPL | Stock | 3.3482 | 3.35 | 3.3454 | 3.3475 | 1394148.0 |
| 2007-03-29 17:00:00 | AAPL | Stock | 3.3482 | 3.3496 | 3.3475 | 3.3496 | 157948.0 |
| 2007-03-29 17:30:00 | AAPL | Stock | 3.3482 | 3.3504 | 3.3482 | 3.35 | 102788.0 |
| 2007-03-29 18:00:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3457 | 3.3461 | 180404.0 |
| 2007-03-29 18:30:00 | AAPL | Stock | 3.3464 | 3.3464 | 3.345 | 3.345 | 48692.0 |
| 2007-03-29 19:00:00 | AAPL | Stock | 3.3446 | 3.3457 | 3.3436 | 3.3436 | 38920.0 |
| 2007-03-29 19:30:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3446 | 3.3479 | 98700.0 |
| 2007-03-29 08:00:00 | MSFT | Stock | 27.7 | 27.72 | 27.7 | 27.72 | 6660.0 |
| 2007-03-29 08:30:00 | MSFT | Stock | 27.72 | 27.82 | 27.72 | 27.82 | 30054.0 |
| 2007-03-29 09:00:00 | MSFT | Stock | 27.8 | 27.84 | 27.75 | 27.84 | 41375.0 |
| 2007-03-29 09:30:00 | MSFT | Stock | 27.84 | 27.845 | 27.68 | 27.75 | 4068203.0 |
| 2007-03-29 10:00:00 | MSFT | Stock | 27.74 | 27.77 | 27.68 | 27.75 | 2293239.0 |
| 2007-03-29 10:30:00 | MSFT | Stock | 27.74 | 27.76 | 27.63 | 27.681 | 2931683.0 |
| 2007-03-29 11:00:00 | MSFT | Stock | 27.68 | 27.77 | 27.65 | 27.73 | 2638757.0 |
| 2007-03-29 11:30:00 | MSFT | Stock | 27.731 | 27.74 | 27.57 | 27.57 | 2647117.0 |
| 2007-03-29 12:00:00 | MSFT | Stock | 27.58 | 27.69 | 27.57 | 27.64 | 2316738.0 |
| 2007-03-29 12:30:00 | MSFT | Stock | 27.64 | 27.7 | 27.59 | 27.61 | 1762470.0 |
| 2007-03-29 13:00:00 | MSFT | Stock | 27.61 | 27.67 | 27.53 | 27.65 | 2539719.0 |
| 2007-03-29 13:30:00 | MSFT | Stock | 27.65 | 27.66 | 27.56 | 27.57 | 2268629.0 |
| 2007-03-29 14:00:00 | MSFT | Stock | 27.57 | 27.59 | 27.52 | 27.561 | 3537131.0 |
| 2007-03-29 14:30:00 | MSFT | Stock | 27.56 | 27.68 | 27.49 | 27.67 | 2608903.0 |
| 2007-03-29 15:00:00 | MSFT | Stock | 27.67 | 27.71 | 27.62 | 27.682 | 2843401.0 |
| 2007-03-29 15:30:00 | MSFT | Stock | 27.68 | 27.75 | 27.63 | 27.74 | 7688122.0 |
| 2007-03-29 16:00:00 | MSFT | Stock | 27.74 | 27.76 | 27.68 | 27.72 | 981173.0 |
| 2007-03-29 16:30:00 | MSFT | Stock | 27.75 | 27.75 | 27.68 | 27.68 | 310715.0 |
| 2007-03-29 17:00:00 | MSFT | Stock | 27.71 | 27.71 | 27.7 | 27.7 | 925.0 |
| 2007-03-29 18:30:00 | MSFT | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 800.0 |
| 2007-03-29 19:30:00 | MSFT | Stock | 27.69 | 27.69 | 27.68 | 27.68 | 425.0 |
| 2007-03-29 08:00:00 | NVDA | Stock | 0.4907 | 0.4917 | 0.4907 | 0.4917 | 90000.0 |
| 2007-03-29 08:30:00 | NVDA | Stock | 0.4917 | 0.4925 | 0.4917 | 0.4917 | 353160.0 |
> showing 50 of 55,097 rows — these rows as CSV