PREVIEW / stock_30min / 2006-05-18
file: by_date/stock_30min/2006/2006-05-18.parquet size: 912 KB rows: 49,344 symbols: 2,267
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-05-18 04:00:00 | AAPL | Stock | 2.3321 | 2.3321 | 2.3321 | 2.3321 | 33600.0 |
| 2006-05-18 07:00:00 | AAPL | Stock | 2.3464 | 2.3464 | 2.3464 | 2.3464 | 16800.0 |
| 2006-05-18 08:00:00 | AAPL | Stock | 2.3464 | 2.3554 | 2.3357 | 2.3429 | 1050728.0 |
| 2006-05-18 08:30:00 | AAPL | Stock | 2.3482 | 2.3514 | 2.3411 | 2.3475 | 572740.0 |
| 2006-05-18 09:00:00 | AAPL | Stock | 2.3475 | 2.3486 | 2.3411 | 2.3457 | 1021832.0 |
| 2006-05-18 09:30:00 | AAPL | Stock | 2.3457 | 2.3664 | 2.3254 | 2.3314 | 114381512.0 |
| 2006-05-18 10:00:00 | AAPL | Stock | 2.3314 | 2.3407 | 2.3189 | 2.3325 | 66712884.0 |
| 2006-05-18 10:30:00 | AAPL | Stock | 2.3325 | 2.3436 | 2.3204 | 2.3254 | 40412148.0 |
| 2006-05-18 11:00:00 | AAPL | Stock | 2.325 | 2.3261 | 2.3114 | 2.3246 | 48857228.0 |
| 2006-05-18 11:30:00 | AAPL | Stock | 2.3239 | 2.3268 | 2.3121 | 2.3186 | 36847524.0 |
| 2006-05-18 12:00:00 | AAPL | Stock | 2.3182 | 2.3268 | 2.3154 | 2.3229 | 27743352.0 |
| 2006-05-18 12:30:00 | AAPL | Stock | 2.3229 | 2.325 | 2.3182 | 2.3229 | 12554108.0 |
| 2006-05-18 13:00:00 | AAPL | Stock | 2.3221 | 2.3243 | 2.3161 | 2.3232 | 13920564.0 |
| 2006-05-18 13:30:00 | AAPL | Stock | 2.3235 | 2.3243 | 2.3179 | 2.3214 | 12096616.0 |
| 2006-05-18 14:00:00 | AAPL | Stock | 2.3214 | 2.325 | 2.3146 | 2.3164 | 17550568.0 |
| 2006-05-18 14:30:00 | AAPL | Stock | 2.3164 | 2.3229 | 2.3143 | 2.3211 | 20786584.0 |
| 2006-05-18 15:00:00 | AAPL | Stock | 2.3212 | 2.3212 | 2.2768 | 2.2836 | 75305104.0 |
| 2006-05-18 15:30:00 | AAPL | Stock | 2.2836 | 2.2871 | 2.2543 | 2.2546 | 152825120.0 |
| 2006-05-18 16:00:00 | AAPL | Stock | 2.2561 | 2.2636 | 2.2539 | 2.2579 | 3019408.0 |
| 2006-05-18 16:30:00 | AAPL | Stock | 2.2586 | 2.2693 | 2.2586 | 2.2607 | 986272.0 |
| 2006-05-18 17:00:00 | AAPL | Stock | 2.2596 | 2.2632 | 2.2568 | 2.2607 | 425292.0 |
| 2006-05-18 17:30:00 | AAPL | Stock | 2.2607 | 2.2671 | 2.2607 | 2.2671 | 1022336.0 |
| 2006-05-18 18:00:00 | AAPL | Stock | 2.2671 | 2.2671 | 2.2618 | 2.2621 | 305396.0 |
| 2006-05-18 05:30:00 | MSFT | Stock | 22.85 | 22.85 | 22.85 | 22.85 | 300.0 |
| 2006-05-18 07:30:00 | MSFT | Stock | 22.82 | 22.82 | 22.82 | 22.82 | 100.0 |
| 2006-05-18 08:00:00 | MSFT | Stock | 22.82 | 22.85 | 22.8 | 22.84 | 67849.0 |
| 2006-05-18 08:30:00 | MSFT | Stock | 22.84 | 22.85 | 22.81 | 22.84 | 52806.0 |
| 2006-05-18 09:00:00 | MSFT | Stock | 22.84 | 22.87 | 22.84 | 22.84 | 296489.0 |
| 2006-05-18 09:30:00 | MSFT | Stock | 22.84 | 22.96 | 22.83 | 22.96 | 12170932.0 |
| 2006-05-18 10:00:00 | MSFT | Stock | 22.96 | 23.02 | 22.85 | 22.87 | 7022907.0 |
| 2006-05-18 10:30:00 | MSFT | Stock | 22.87 | 22.89 | 22.84 | 22.88 | 3542335.0 |
| 2006-05-18 11:00:00 | MSFT | Stock | 22.88 | 22.89 | 22.76 | 22.86 | 4317677.0 |
| 2006-05-18 11:30:00 | MSFT | Stock | 22.86 | 22.95 | 22.85 | 22.91 | 4678865.0 |
| 2006-05-18 12:00:00 | MSFT | Stock | 22.91 | 23.0 | 22.87 | 22.93 | 5340248.0 |
| 2006-05-18 12:30:00 | MSFT | Stock | 22.94 | 23.13 | 22.93 | 23.06 | 6960559.0 |
| 2006-05-18 13:00:00 | MSFT | Stock | 23.06 | 23.14 | 22.99 | 23.12 | 9853756.0 |
| 2006-05-18 13:30:00 | MSFT | Stock | 23.12 | 23.14 | 23.03 | 23.07 | 4535683.0 |
| 2006-05-18 14:00:00 | MSFT | Stock | 23.08 | 23.12 | 23.02 | 23.03 | 5477518.0 |
| 2006-05-18 14:30:00 | MSFT | Stock | 23.04 | 23.12 | 22.95 | 22.99 | 5676072.0 |
| 2006-05-18 15:00:00 | MSFT | Stock | 22.98 | 22.99 | 22.85 | 22.86 | 6065431.0 |
| 2006-05-18 15:30:00 | MSFT | Stock | 22.87 | 22.97 | 22.8 | 22.81 | 10362334.0 |
| 2006-05-18 16:00:00 | MSFT | Stock | 22.81 | 22.88 | 22.76 | 22.87 | 405896.0 |
| 2006-05-18 16:30:00 | MSFT | Stock | 22.86 | 22.93 | 22.86 | 22.9 | 92579.0 |
| 2006-05-18 17:00:00 | MSFT | Stock | 22.9 | 22.93 | 22.82 | 22.93 | 39699.0 |
| 2006-05-18 17:30:00 | MSFT | Stock | 22.93 | 22.94 | 22.89 | 22.92 | 27137.0 |
| 2006-05-18 18:00:00 | MSFT | Stock | 22.91 | 22.93 | 22.91 | 22.93 | 2260.0 |
| 2006-05-18 07:00:00 | NVDA | Stock | 0.4188 | 0.4188 | 0.4188 | 0.4188 | 60000.0 |
| 2006-05-18 07:30:00 | NVDA | Stock | 0.4167 | 0.4167 | 0.4167 | 0.4167 | 66000.0 |
| 2006-05-18 08:00:00 | NVDA | Stock | 0.4192 | 0.4208 | 0.4192 | 0.4208 | 18000.0 |
| 2006-05-18 08:30:00 | NVDA | Stock | 0.4207 | 0.4207 | 0.4175 | 0.4203 | 484500.0 |
> showing 50 of 49,344 rows — these rows as CSV