PREVIEW / stock_30min / 2000-07-14
file: by_date/stock_30min/2000/2000-07-14.parquet size: 440 KB rows: 25,337 symbols: 1,190
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 |
|---|---|---|---|---|---|---|---|
| 2000-07-14 08:00:00 | AAPL | Stock | 1.0095 | 1.0095 | 1.0089 | 1.0089 | 515200.0 |
| 2000-07-14 08:30:00 | AAPL | Stock | 1.0251 | 1.0324 | 1.0089 | 1.0324 | 56000.0 |
| 2000-07-14 09:00:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.0179 | 1.0201 | 879200.0 |
| 2000-07-14 09:30:00 | AAPL | Stock | 1.0201 | 1.0379 | 1.0156 | 1.0279 | 24836000.0 |
| 2000-07-14 10:00:00 | AAPL | Stock | 1.0279 | 1.0313 | 1.0179 | 1.0301 | 13837600.0 |
| 2000-07-14 10:30:00 | AAPL | Stock | 1.029 | 1.0368 | 1.0268 | 1.0301 | 9352000.0 |
| 2000-07-14 11:00:00 | AAPL | Stock | 1.0301 | 1.0379 | 1.0268 | 1.0368 | 16223200.0 |
| 2000-07-14 11:30:00 | AAPL | Stock | 1.0368 | 1.0379 | 1.0268 | 1.0335 | 6524000.0 |
| 2000-07-14 12:00:00 | AAPL | Stock | 1.0324 | 1.0379 | 1.0279 | 1.0313 | 10920000.0 |
| 2000-07-14 12:30:00 | AAPL | Stock | 1.0301 | 1.0324 | 1.019 | 1.0257 | 12566400.0 |
| 2000-07-14 13:00:00 | AAPL | Stock | 1.0257 | 1.0313 | 1.0234 | 1.0246 | 10063200.0 |
| 2000-07-14 13:30:00 | AAPL | Stock | 1.0246 | 1.0324 | 1.0246 | 1.0301 | 5101600.0 |
| 2000-07-14 14:00:00 | AAPL | Stock | 1.029 | 1.0379 | 1.029 | 1.0379 | 13938400.0 |
| 2000-07-14 14:30:00 | AAPL | Stock | 1.0379 | 1.0536 | 1.0379 | 1.0458 | 17662400.0 |
| 2000-07-14 15:00:00 | AAPL | Stock | 1.0458 | 1.0458 | 1.019 | 1.0313 | 18188800.0 |
| 2000-07-14 15:30:00 | AAPL | Stock | 1.0301 | 1.0324 | 1.0179 | 1.0301 | 18620000.0 |
| 2000-07-14 16:00:00 | AAPL | Stock | 1.0313 | 1.0324 | 1.0179 | 1.0324 | 4127200.0 |
| 2000-07-14 16:30:00 | AAPL | Stock | 1.0296 | 1.0357 | 1.0296 | 1.0335 | 190400.0 |
| 2000-07-14 17:00:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0296 | 1.0296 | 1136800.0 |
| 2000-07-14 17:30:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0357 | 1.0357 | 16800.0 |
| 2000-07-14 18:00:00 | AAPL | Stock | 1.0357 | 1.0357 | 1.0357 | 1.0357 | 11200.0 |
| 2000-07-14 08:00:00 | MSFT | Stock | 40.125 | 40.125 | 39.625 | 39.875 | 17600.0 |
| 2000-07-14 08:30:00 | MSFT | Stock | 39.9375 | 40.0938 | 39.5 | 40.0469 | 46400.0 |
| 2000-07-14 09:00:00 | MSFT | Stock | 40.0 | 40.0625 | 39.75 | 39.7812 | 762200.0 |
| 2000-07-14 09:30:00 | MSFT | Stock | 39.75 | 39.7812 | 39.3125 | 39.4062 | 8290200.0 |
| 2000-07-14 10:00:00 | MSFT | Stock | 39.4062 | 39.5625 | 39.2188 | 39.5312 | 7426800.0 |
| 2000-07-14 10:30:00 | MSFT | Stock | 39.5625 | 39.625 | 39.4375 | 39.5 | 3033800.0 |
| 2000-07-14 11:00:00 | MSFT | Stock | 39.4688 | 39.5625 | 39.375 | 39.4375 | 1933200.0 |
| 2000-07-14 11:30:00 | MSFT | Stock | 39.4688 | 39.5312 | 39.2188 | 39.4375 | 2984800.0 |
| 2000-07-14 12:00:00 | MSFT | Stock | 39.4375 | 39.4688 | 39.3125 | 39.375 | 2760000.0 |
| 2000-07-14 12:30:00 | MSFT | Stock | 39.4062 | 39.5938 | 39.375 | 39.4062 | 3727400.0 |
| 2000-07-14 13:00:00 | MSFT | Stock | 39.4062 | 39.5625 | 39.375 | 39.5625 | 1775200.0 |
| 2000-07-14 13:30:00 | MSFT | Stock | 39.5312 | 39.5938 | 39.4688 | 39.5938 | 1494600.0 |
| 2000-07-14 14:00:00 | MSFT | Stock | 39.5625 | 39.5938 | 39.5 | 39.5625 | 1519400.0 |
| 2000-07-14 14:30:00 | MSFT | Stock | 39.5312 | 39.8438 | 39.5312 | 39.8125 | 2659000.0 |
| 2000-07-14 15:00:00 | MSFT | Stock | 39.8125 | 39.875 | 39.3438 | 39.4062 | 5149800.0 |
| 2000-07-14 15:30:00 | MSFT | Stock | 39.4375 | 39.625 | 39.3438 | 39.4688 | 4803600.0 |
| 2000-07-14 16:00:00 | MSFT | Stock | 39.4375 | 39.5625 | 39.375 | 39.4688 | 1773200.0 |
| 2000-07-14 16:30:00 | MSFT | Stock | 39.5625 | 39.7656 | 39.2812 | 39.4688 | 157000.0 |
| 2000-07-14 17:00:00 | MSFT | Stock | 39.4688 | 39.5 | 39.375 | 39.4688 | 397600.0 |
| 2000-07-14 17:30:00 | MSFT | Stock | 39.4375 | 39.5625 | 39.4375 | 39.5 | 2600.0 |
| 2000-07-14 18:00:00 | MSFT | Stock | 39.5 | 39.5 | 39.4375 | 39.5 | 2600.0 |
| 2000-07-14 08:30:00 | NVDA | Stock | 0.3094 | 0.3125 | 0.3094 | 0.3125 | 192000.0 |
| 2000-07-14 09:00:00 | NVDA | Stock | 0.3125 | 0.3164 | 0.3104 | 0.3164 | 2712000.0 |
| 2000-07-14 09:30:00 | NVDA | Stock | 0.3161 | 0.3221 | 0.3099 | 0.3109 | 53280000.0 |
| 2000-07-14 10:00:00 | NVDA | Stock | 0.3109 | 0.3109 | 0.3 | 0.3052 | 43800000.0 |
| 2000-07-14 10:30:00 | NVDA | Stock | 0.3052 | 0.3161 | 0.3042 | 0.3141 | 20976000.0 |
| 2000-07-14 11:00:00 | NVDA | Stock | 0.3104 | 0.3161 | 0.3055 | 0.3104 | 26304000.0 |
| 2000-07-14 11:30:00 | NVDA | Stock | 0.3112 | 0.3146 | 0.3089 | 0.3117 | 14496000.0 |
| 2000-07-14 12:00:00 | NVDA | Stock | 0.3109 | 0.3141 | 0.3102 | 0.3102 | 16080000.0 |
> showing 50 of 25,337 rows — these rows as CSV