PREVIEW / stock_30min / 2006-03-14
file: by_date/stock_30min/2006/2006-03-14.parquet size: 913 KB rows: 49,779 symbols: 2,205
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-14 04:30:00 | AAPL | Stock | 2.3496 | 2.3496 | 2.3496 | 2.3496 | 4620.0 |
| 2006-03-14 05:30:00 | AAPL | Stock | 2.3446 | 2.3446 | 2.3446 | 2.3446 | 2800.0 |
| 2006-03-14 07:00:00 | AAPL | Stock | 2.3393 | 2.3393 | 2.3379 | 2.3379 | 11200.0 |
| 2006-03-14 07:30:00 | AAPL | Stock | 2.3432 | 2.3432 | 2.3393 | 2.3393 | 11200.0 |
| 2006-03-14 08:00:00 | AAPL | Stock | 2.3393 | 2.3425 | 2.3236 | 2.3393 | 772884.0 |
| 2006-03-14 08:30:00 | AAPL | Stock | 2.3393 | 2.3429 | 2.3361 | 2.3386 | 910588.0 |
| 2006-03-14 09:00:00 | AAPL | Stock | 2.3386 | 2.3507 | 2.3382 | 2.3507 | 1534596.0 |
| 2006-03-14 09:30:00 | AAPL | Stock | 2.3489 | 2.3611 | 2.3393 | 2.3592 | 84839272.0 |
| 2006-03-14 10:00:00 | AAPL | Stock | 2.3589 | 2.3786 | 2.3589 | 2.365 | 103231604.0 |
| 2006-03-14 10:30:00 | AAPL | Stock | 2.3646 | 2.3711 | 2.3557 | 2.3639 | 57115128.0 |
| 2006-03-14 11:00:00 | AAPL | Stock | 2.3636 | 2.3704 | 2.3593 | 2.3671 | 28874160.0 |
| 2006-03-14 11:30:00 | AAPL | Stock | 2.3671 | 2.3732 | 2.3611 | 2.3646 | 33013960.0 |
| 2006-03-14 12:00:00 | AAPL | Stock | 2.3646 | 2.3711 | 2.3646 | 2.37 | 20923476.0 |
| 2006-03-14 12:30:00 | AAPL | Stock | 2.3696 | 2.3711 | 2.3646 | 2.3668 | 18958996.0 |
| 2006-03-14 13:00:00 | AAPL | Stock | 2.3675 | 2.3893 | 2.3668 | 2.385 | 46286296.0 |
| 2006-03-14 13:30:00 | AAPL | Stock | 2.385 | 2.3893 | 2.3811 | 2.3882 | 37036188.0 |
| 2006-03-14 14:00:00 | AAPL | Stock | 2.3886 | 2.3911 | 2.3807 | 2.3871 | 36082984.0 |
| 2006-03-14 14:30:00 | AAPL | Stock | 2.3871 | 2.3954 | 2.3839 | 2.3943 | 37789752.0 |
| 2006-03-14 15:00:00 | AAPL | Stock | 2.3943 | 2.3986 | 2.3911 | 2.3932 | 39735864.0 |
| 2006-03-14 15:30:00 | AAPL | Stock | 2.3936 | 2.4043 | 2.3932 | 2.4043 | 79589272.0 |
| 2006-03-14 16:00:00 | AAPL | Stock | 2.4036 | 2.4057 | 2.3779 | 2.4054 | 4429600.0 |
| 2006-03-14 16:30:00 | AAPL | Stock | 2.4046 | 2.4143 | 2.4046 | 2.4089 | 766584.0 |
| 2006-03-14 17:00:00 | AAPL | Stock | 2.4089 | 2.4107 | 2.4079 | 2.4096 | 306292.0 |
| 2006-03-14 17:30:00 | AAPL | Stock | 2.4104 | 2.4143 | 2.4104 | 2.4143 | 366408.0 |
| 2006-03-14 18:00:00 | AAPL | Stock | 2.4143 | 2.4193 | 2.4143 | 2.4143 | 292460.0 |
| 2006-03-14 05:30:00 | MSFT | Stock | 26.93 | 26.93 | 26.93 | 26.93 | 200.0 |
| 2006-03-14 06:30:00 | MSFT | Stock | 27.08 | 27.3 | 27.08 | 27.3 | 5000.0 |
| 2006-03-14 08:00:00 | MSFT | Stock | 27.1 | 27.1 | 27.03 | 27.04 | 3650.0 |
| 2006-03-14 08:30:00 | MSFT | Stock | 27.04 | 27.07 | 27.04 | 27.07 | 2060.0 |
| 2006-03-14 09:00:00 | MSFT | Stock | 27.04 | 27.08 | 26.98 | 27.04 | 79044.0 |
| 2006-03-14 09:30:00 | MSFT | Stock | 27.04 | 27.28 | 26.99 | 27.25 | 4406951.0 |
| 2006-03-14 10:00:00 | MSFT | Stock | 27.26 | 27.27 | 27.13 | 27.16 | 2132753.0 |
| 2006-03-14 10:30:00 | MSFT | Stock | 27.17 | 27.23 | 27.14 | 27.22 | 2352818.0 |
| 2006-03-14 11:00:00 | MSFT | Stock | 27.23 | 27.25 | 27.2 | 27.2 | 1275809.0 |
| 2006-03-14 11:30:00 | MSFT | Stock | 27.21 | 27.25 | 27.18 | 27.225 | 1506637.0 |
| 2006-03-14 12:00:00 | MSFT | Stock | 27.22 | 27.27 | 27.2 | 27.2 | 2121943.0 |
| 2006-03-14 12:30:00 | MSFT | Stock | 27.21 | 27.23 | 27.2 | 27.212 | 1056325.0 |
| 2006-03-14 13:00:00 | MSFT | Stock | 27.21 | 27.37 | 27.21 | 27.36 | 4604678.0 |
| 2006-03-14 13:30:00 | MSFT | Stock | 27.37 | 27.38 | 27.25 | 27.28 | 3026977.0 |
| 2006-03-14 14:00:00 | MSFT | Stock | 27.27 | 27.31 | 27.26 | 27.29 | 2138753.0 |
| 2006-03-14 14:30:00 | MSFT | Stock | 27.28 | 27.31 | 27.27 | 27.282 | 1783113.0 |
| 2006-03-14 15:00:00 | MSFT | Stock | 27.28 | 27.32 | 27.24 | 27.24 | 3684588.0 |
| 2006-03-14 15:30:00 | MSFT | Stock | 27.24 | 27.28 | 27.2 | 27.2 | 8024335.0 |
| 2006-03-14 16:00:00 | MSFT | Stock | 27.19 | 27.23 | 27.17 | 27.18 | 288727.0 |
| 2006-03-14 16:30:00 | MSFT | Stock | 27.2 | 27.2 | 27.16 | 27.16 | 28234.0 |
| 2006-03-14 17:00:00 | MSFT | Stock | 27.19 | 27.2 | 27.18 | 27.2 | 2700.0 |
| 2006-03-14 17:30:00 | MSFT | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 900.0 |
| 2006-03-14 18:00:00 | MSFT | Stock | 27.2 | 27.23 | 27.2 | 27.23 | 1534.0 |
| 2006-03-14 09:00:00 | NVDA | Stock | 0.4001 | 0.4003 | 0.4 | 0.4002 | 124920.0 |
| 2006-03-14 09:30:00 | NVDA | Stock | 0.4 | 0.4084 | 0.3985 | 0.4073 | 73264080.0 |
> showing 50 of 49,779 rows — these rows as CSV