PREVIEW / stock_30min / 2007-07-02
file: by_date/stock_30min/2007/2007-07-02.parquet size: 1.1 MB rows: 64,841 symbols: 3,039
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-07-02 09:30:00 | AAPL | Stock | 4.3232 | 4.3604 | 4.2607 | 4.3464 | 273012376.0 |
| 2007-07-02 10:00:00 | AAPL | Stock | 4.3464 | 4.3571 | 4.3036 | 4.3186 | 106228500.0 |
| 2007-07-02 10:30:00 | AAPL | Stock | 4.3189 | 4.3293 | 4.3057 | 4.3264 | 61908168.0 |
| 2007-07-02 11:00:00 | AAPL | Stock | 4.3257 | 4.3536 | 4.3204 | 4.3368 | 67218004.0 |
| 2007-07-02 11:30:00 | AAPL | Stock | 4.3361 | 4.3432 | 4.3179 | 4.3293 | 30459016.0 |
| 2007-07-02 12:00:00 | AAPL | Stock | 4.3289 | 4.3571 | 4.3289 | 4.3393 | 62621468.0 |
| 2007-07-02 12:30:00 | AAPL | Stock | 4.3391 | 4.3411 | 4.3186 | 4.3321 | 48315904.0 |
| 2007-07-02 13:00:00 | AAPL | Stock | 4.3318 | 4.3375 | 4.3268 | 4.3321 | 27672372.0 |
| 2007-07-02 13:30:00 | AAPL | Stock | 4.3314 | 4.3332 | 4.3179 | 4.3254 | 30456440.0 |
| 2007-07-02 14:00:00 | AAPL | Stock | 4.3254 | 4.335 | 4.3107 | 4.3211 | 40465684.0 |
| 2007-07-02 14:30:00 | AAPL | Stock | 4.3214 | 4.3304 | 4.3107 | 4.3214 | 32737320.0 |
| 2007-07-02 15:00:00 | AAPL | Stock | 4.3211 | 4.3421 | 4.3 | 4.3329 | 49207116.0 |
| 2007-07-02 15:30:00 | AAPL | Stock | 4.3332 | 4.3375 | 4.3071 | 4.3307 | 77723464.0 |
| 2007-07-02 16:00:00 | AAPL | Stock | 4.3304 | 4.3307 | 4.3282 | 4.3307 | 5025552.0 |
| 2007-07-02 09:30:00 | MSFT | Stock | 29.67 | 29.8 | 29.6 | 29.73 | 5838872.0 |
| 2007-07-02 10:00:00 | MSFT | Stock | 29.74 | 29.77 | 29.58 | 29.58 | 4808402.0 |
| 2007-07-02 10:30:00 | MSFT | Stock | 29.59 | 29.68 | 29.56 | 29.68 | 3012260.0 |
| 2007-07-02 11:00:00 | MSFT | Stock | 29.68 | 29.73 | 29.56 | 29.63 | 3646036.0 |
| 2007-07-02 11:30:00 | MSFT | Stock | 29.62 | 29.71 | 29.55 | 29.57 | 1979636.0 |
| 2007-07-02 12:00:00 | MSFT | Stock | 29.553 | 29.58 | 29.49 | 29.54 | 3286233.0 |
| 2007-07-02 12:30:00 | MSFT | Stock | 29.54 | 29.63 | 29.53 | 29.62 | 2193421.0 |
| 2007-07-02 13:00:00 | MSFT | Stock | 29.62 | 29.65 | 29.6 | 29.61 | 1413938.0 |
| 2007-07-02 13:30:00 | MSFT | Stock | 29.61 | 29.78 | 29.6 | 29.735 | 2417225.0 |
| 2007-07-02 14:00:00 | MSFT | Stock | 29.74 | 29.79 | 29.72 | 29.77 | 1698693.0 |
| 2007-07-02 14:30:00 | MSFT | Stock | 29.775 | 29.79 | 29.71 | 29.77 | 2573406.0 |
| 2007-07-02 15:00:00 | MSFT | Stock | 29.76 | 29.79 | 29.73 | 29.74 | 2697220.0 |
| 2007-07-02 15:30:00 | MSFT | Stock | 29.75 | 29.77 | 29.67 | 29.75 | 5017787.0 |
| 2007-07-02 16:00:00 | MSFT | Stock | 29.74 | 29.74 | 29.74 | 29.74 | 1054824.0 |
| 2007-07-02 08:30:00 | NVDA | Stock | 0.6885 | 0.69 | 0.6885 | 0.69 | 8187420.0 |
| 2007-07-02 09:00:00 | NVDA | Stock | 0.6932 | 0.6983 | 0.6932 | 0.6983 | 616800.0 |
| 2007-07-02 09:30:00 | NVDA | Stock | 0.6983 | 0.7 | 0.6962 | 0.6985 | 47281980.0 |
| 2007-07-02 10:00:00 | NVDA | Stock | 0.6983 | 0.7098 | 0.6983 | 0.7085 | 62974680.0 |
| 2007-07-02 10:30:00 | NVDA | Stock | 0.7087 | 0.7133 | 0.707 | 0.713 | 55786320.0 |
| 2007-07-02 11:00:00 | NVDA | Stock | 0.7132 | 0.7175 | 0.7128 | 0.7153 | 58330800.0 |
| 2007-07-02 11:30:00 | NVDA | Stock | 0.7153 | 0.7165 | 0.7113 | 0.7113 | 42693060.0 |
| 2007-07-02 12:00:00 | NVDA | Stock | 0.7115 | 0.7163 | 0.7095 | 0.7107 | 37412940.0 |
| 2007-07-02 12:30:00 | NVDA | Stock | 0.7107 | 0.7135 | 0.7105 | 0.7128 | 22527780.0 |
| 2007-07-02 13:00:00 | NVDA | Stock | 0.7128 | 0.7137 | 0.7113 | 0.7118 | 20139600.0 |
| 2007-07-02 13:30:00 | NVDA | Stock | 0.712 | 0.715 | 0.7117 | 0.7128 | 18799500.0 |
| 2007-07-02 14:00:00 | NVDA | Stock | 0.7128 | 0.7153 | 0.712 | 0.7153 | 23928120.0 |
| 2007-07-02 14:30:00 | NVDA | Stock | 0.7152 | 0.7158 | 0.7138 | 0.7153 | 27052980.0 |
| 2007-07-02 15:00:00 | NVDA | Stock | 0.7152 | 0.7173 | 0.7137 | 0.7155 | 47981880.0 |
| 2007-07-02 15:30:00 | NVDA | Stock | 0.7155 | 0.7173 | 0.715 | 0.7172 | 50145240.0 |
| 2007-07-02 16:00:00 | NVDA | Stock | 0.7172 | 0.7172 | 0.7158 | 0.7168 | 557640.0 |
| 2007-07-02 17:00:00 | NVDA | Stock | 0.7168 | 0.7168 | 0.7168 | 0.7168 | 24000.0 |
| 2007-07-02 19:30:00 | NVDA | Stock | 0.7167 | 0.7168 | 0.7167 | 0.7168 | 36900.0 |
| 2007-07-02 08:00:00 | AMZN | Stock | 3.425 | 3.44 | 3.425 | 3.44 | 33800.0 |
| 2007-07-02 08:30:00 | AMZN | Stock | 3.4275 | 3.445 | 3.4205 | 3.444 | 1718700.0 |
| 2007-07-02 09:00:00 | AMZN | Stock | 3.4435 | 3.4435 | 3.4305 | 3.4415 | 88700.0 |
| 2007-07-02 09:30:00 | AMZN | Stock | 3.433 | 3.4495 | 3.41 | 3.4305 | 10731200.0 |
> showing 50 of 64,841 rows — these rows as CSV