PREVIEW / stock_30min / 2006-03-09
file: by_date/stock_30min/2006/2006-03-09.parquet size: 914 KB rows: 49,179 symbols: 2,194
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-03-09 06:30:00 | AAPL | Stock | 2.3511 | 2.3511 | 2.3511 | 2.3511 | 2800.0 |
| 2006-03-09 07:00:00 | AAPL | Stock | 2.3786 | 2.3786 | 2.3786 | 2.3786 | 25676.0 |
| 2006-03-09 08:00:00 | AAPL | Stock | 2.3561 | 2.3632 | 2.3561 | 2.3571 | 1180004.0 |
| 2006-03-09 08:30:00 | AAPL | Stock | 2.3586 | 2.3607 | 2.3536 | 2.3596 | 789236.0 |
| 2006-03-09 09:00:00 | AAPL | Stock | 2.3593 | 2.365 | 2.3536 | 2.3557 | 2502388.0 |
| 2006-03-09 09:30:00 | AAPL | Stock | 2.3564 | 2.3739 | 2.3289 | 2.3711 | 123832716.0 |
| 2006-03-09 10:00:00 | AAPL | Stock | 2.3704 | 2.3707 | 2.3461 | 2.3543 | 81889248.0 |
| 2006-03-09 10:30:00 | AAPL | Stock | 2.3543 | 2.3621 | 2.3407 | 2.3407 | 54293148.0 |
| 2006-03-09 11:00:00 | AAPL | Stock | 2.3407 | 2.3486 | 2.3346 | 2.3443 | 38122084.0 |
| 2006-03-09 11:30:00 | AAPL | Stock | 2.3443 | 2.3446 | 2.3282 | 2.3346 | 32052160.0 |
| 2006-03-09 12:00:00 | AAPL | Stock | 2.3346 | 2.3393 | 2.3161 | 2.3332 | 56069524.0 |
| 2006-03-09 12:30:00 | AAPL | Stock | 2.3332 | 2.3393 | 2.3168 | 2.3236 | 44790676.0 |
| 2006-03-09 13:00:00 | AAPL | Stock | 2.3239 | 2.3239 | 2.2939 | 2.3061 | 76094648.0 |
| 2006-03-09 13:30:00 | AAPL | Stock | 2.3068 | 2.3125 | 2.2971 | 2.3029 | 46788980.0 |
| 2006-03-09 14:00:00 | AAPL | Stock | 2.3036 | 2.3161 | 2.2968 | 2.2989 | 45837876.0 |
| 2006-03-09 14:30:00 | AAPL | Stock | 2.2989 | 2.3029 | 2.2914 | 2.2981 | 40669020.0 |
| 2006-03-09 15:00:00 | AAPL | Stock | 2.2982 | 2.2996 | 2.2836 | 2.2857 | 55834016.0 |
| 2006-03-09 15:30:00 | AAPL | Stock | 2.2857 | 2.2904 | 2.2789 | 2.2829 | 90063232.0 |
| 2006-03-09 16:00:00 | AAPL | Stock | 2.2832 | 2.3196 | 2.2768 | 2.2789 | 1659532.0 |
| 2006-03-09 16:30:00 | AAPL | Stock | 2.2807 | 2.2818 | 2.2789 | 2.2814 | 570248.0 |
| 2006-03-09 17:00:00 | AAPL | Stock | 2.2814 | 2.2832 | 2.28 | 2.2821 | 473116.0 |
| 2006-03-09 17:30:00 | AAPL | Stock | 2.2821 | 2.2832 | 2.2804 | 2.2829 | 498876.0 |
| 2006-03-09 18:00:00 | AAPL | Stock | 2.2829 | 2.2832 | 2.2821 | 2.2821 | 819560.0 |
| 2006-03-09 07:00:00 | MSFT | Stock | 27.35 | 27.35 | 27.35 | 27.35 | 462.0 |
| 2006-03-09 07:30:00 | MSFT | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 400.0 |
| 2006-03-09 08:00:00 | MSFT | Stock | 27.36 | 27.38 | 27.32 | 27.33 | 11932.0 |
| 2006-03-09 08:30:00 | MSFT | Stock | 27.35 | 27.35 | 27.31 | 27.31 | 6037.0 |
| 2006-03-09 09:00:00 | MSFT | Stock | 27.28 | 27.33 | 27.21 | 27.27 | 442172.0 |
| 2006-03-09 09:30:00 | MSFT | Stock | 27.27 | 27.36 | 27.15 | 27.33 | 5451239.0 |
| 2006-03-09 10:00:00 | MSFT | Stock | 27.34 | 27.42 | 27.29 | 27.34 | 5423088.0 |
| 2006-03-09 10:30:00 | MSFT | Stock | 27.33 | 27.35 | 27.31 | 27.32 | 2314742.0 |
| 2006-03-09 11:00:00 | MSFT | Stock | 27.32 | 27.34 | 27.27 | 27.33 | 2073085.0 |
| 2006-03-09 11:30:00 | MSFT | Stock | 27.33 | 27.35 | 27.28 | 27.29 | 1298340.0 |
| 2006-03-09 12:00:00 | MSFT | Stock | 27.29 | 27.3 | 27.21 | 27.222 | 2341084.0 |
| 2006-03-09 12:30:00 | MSFT | Stock | 27.22 | 27.24 | 27.16 | 27.2 | 2339341.0 |
| 2006-03-09 13:00:00 | MSFT | Stock | 27.21 | 27.21 | 27.07 | 27.09 | 3233764.0 |
| 2006-03-09 13:30:00 | MSFT | Stock | 27.092 | 27.15 | 27.08 | 27.092 | 2450681.0 |
| 2006-03-09 14:00:00 | MSFT | Stock | 27.1 | 27.19 | 27.09 | 27.17 | 3064183.0 |
| 2006-03-09 14:30:00 | MSFT | Stock | 27.17 | 27.34 | 27.08 | 27.092 | 1895645.0 |
| 2006-03-09 15:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.03 | 27.06 | 3211443.0 |
| 2006-03-09 15:30:00 | MSFT | Stock | 27.06 | 27.09 | 27.0 | 27.01 | 6093860.0 |
| 2006-03-09 16:00:00 | MSFT | Stock | 27.02 | 27.072 | 26.97 | 26.97 | 848390.0 |
| 2006-03-09 16:30:00 | MSFT | Stock | 26.99 | 27.0 | 26.95 | 27.0 | 8523.0 |
| 2006-03-09 17:00:00 | MSFT | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 222.0 |
| 2006-03-09 17:30:00 | MSFT | Stock | 26.99 | 27.0 | 26.99 | 27.0 | 11138.0 |
| 2006-03-09 18:00:00 | MSFT | Stock | 26.99 | 26.99 | 26.95 | 26.97 | 2293.0 |
| 2006-03-09 08:00:00 | NVDA | Stock | 0.405 | 0.405 | 0.405 | 0.405 | 60000.0 |
| 2006-03-09 08:30:00 | NVDA | Stock | 0.4049 | 0.4071 | 0.4049 | 0.4065 | 368400.0 |
| 2006-03-09 09:00:00 | NVDA | Stock | 0.405 | 0.4052 | 0.4042 | 0.4047 | 852840.0 |
| 2006-03-09 09:30:00 | NVDA | Stock | 0.4046 | 0.4114 | 0.4046 | 0.4097 | 87895680.0 |
> showing 50 of 49,179 rows — these rows as CSV