PREVIEW / stock_30min / 2004-08-23
file: by_date/stock_30min/2004/2004-08-23.parquet size: 743 KB rows: 40,617 symbols: 1,823
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-23 09:00:00 | AAPL | Stock | 0.5509 | 0.5518 | 0.5505 | 0.5518 | 266560.0 |
| 2004-08-23 09:30:00 | AAPL | Stock | 0.5511 | 0.5518 | 0.5464 | 0.5496 | 25754288.0 |
| 2004-08-23 10:00:00 | AAPL | Stock | 0.5493 | 0.5563 | 0.5488 | 0.5563 | 19424832.0 |
| 2004-08-23 10:30:00 | AAPL | Stock | 0.5563 | 0.5584 | 0.5554 | 0.5561 | 21501368.0 |
| 2004-08-23 11:00:00 | AAPL | Stock | 0.5559 | 0.5564 | 0.552 | 0.5527 | 21063896.0 |
| 2004-08-23 11:30:00 | AAPL | Stock | 0.5529 | 0.5538 | 0.552 | 0.5521 | 12730256.0 |
| 2004-08-23 12:00:00 | AAPL | Stock | 0.5521 | 0.5536 | 0.5504 | 0.5505 | 10865960.0 |
| 2004-08-23 12:30:00 | AAPL | Stock | 0.5505 | 0.5518 | 0.5491 | 0.5509 | 13287064.0 |
| 2004-08-23 13:00:00 | AAPL | Stock | 0.5509 | 0.5532 | 0.5505 | 0.5527 | 16431688.0 |
| 2004-08-23 13:30:00 | AAPL | Stock | 0.5527 | 0.5545 | 0.5527 | 0.5541 | 17085320.0 |
| 2004-08-23 14:00:00 | AAPL | Stock | 0.5543 | 0.5555 | 0.5528 | 0.5532 | 18070696.0 |
| 2004-08-23 14:30:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.5509 | 0.5511 | 12372080.0 |
| 2004-08-23 15:00:00 | AAPL | Stock | 0.5511 | 0.5521 | 0.5488 | 0.552 | 13159328.0 |
| 2004-08-23 15:30:00 | AAPL | Stock | 0.5518 | 0.5554 | 0.5511 | 0.555 | 36953728.0 |
| 2004-08-23 16:00:00 | AAPL | Stock | 0.555 | 0.5555 | 0.5541 | 0.5545 | 5025328.0 |
| 2004-08-23 16:30:00 | AAPL | Stock | 0.555 | 0.555 | 0.555 | 0.555 | 56000.0 |
| 2004-08-23 08:00:00 | MSFT | Stock | 27.25 | 27.3 | 27.115 | 27.18 | 152500.0 |
| 2004-08-23 08:30:00 | MSFT | Stock | 27.2 | 27.21 | 27.19 | 27.19 | 10803.0 |
| 2004-08-23 09:00:00 | MSFT | Stock | 27.22 | 28.0 | 27.2 | 27.28 | 67744.0 |
| 2004-08-23 09:30:00 | MSFT | Stock | 27.28 | 27.3 | 27.13 | 27.18 | 3771426.0 |
| 2004-08-23 10:00:00 | MSFT | Stock | 27.17 | 27.26 | 27.16 | 27.22 | 2755069.0 |
| 2004-08-23 10:30:00 | MSFT | Stock | 27.21 | 27.27 | 27.2 | 27.24 | 2444922.0 |
| 2004-08-23 11:00:00 | MSFT | Stock | 27.24 | 27.29 | 27.19 | 27.27 | 3142291.0 |
| 2004-08-23 11:30:00 | MSFT | Stock | 27.27 | 27.33 | 27.25 | 27.29 | 2250903.0 |
| 2004-08-23 12:00:00 | MSFT | Stock | 27.3 | 27.32 | 27.23 | 27.23 | 2020692.0 |
| 2004-08-23 12:30:00 | MSFT | Stock | 27.23 | 27.28 | 27.2 | 27.2 | 1547844.0 |
| 2004-08-23 13:00:00 | MSFT | Stock | 27.2 | 27.28 | 27.17 | 27.19 | 3891669.0 |
| 2004-08-23 13:30:00 | MSFT | Stock | 27.18 | 27.27 | 27.17 | 27.24 | 3046914.0 |
| 2004-08-23 14:00:00 | MSFT | Stock | 27.24 | 27.3 | 27.23 | 27.26 | 2925184.0 |
| 2004-08-23 14:30:00 | MSFT | Stock | 27.27 | 27.27 | 27.21 | 27.23 | 2530675.0 |
| 2004-08-23 15:00:00 | MSFT | Stock | 27.24 | 27.25 | 27.12 | 27.189 | 3927258.0 |
| 2004-08-23 15:30:00 | MSFT | Stock | 27.18 | 27.26 | 27.18 | 27.25 | 3202366.0 |
| 2004-08-23 16:00:00 | MSFT | Stock | 27.24 | 27.3 | 27.24 | 27.28 | 493045.0 |
| 2004-08-23 16:30:00 | MSFT | Stock | 27.26 | 27.27 | 27.25 | 27.26 | 2707.0 |
| 2004-08-23 17:00:00 | MSFT | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 1701.0 |
| 2004-08-23 17:30:00 | MSFT | Stock | 27.27 | 27.28 | 27.27 | 27.28 | 1000.0 |
| 2004-08-23 18:00:00 | MSFT | Stock | 27.25 | 27.25 | 27.25 | 27.25 | 100.0 |
| 2004-08-23 08:00:00 | NVDA | Stock | 0.1025 | 0.1043 | 0.0983 | 0.1042 | 768000.0 |
| 2004-08-23 08:30:00 | NVDA | Stock | 0.1043 | 0.1046 | 0.1043 | 0.1046 | 186000.0 |
| 2004-08-23 09:00:00 | NVDA | Stock | 0.1048 | 0.1053 | 0.1043 | 0.1045 | 3253200.0 |
| 2004-08-23 09:30:00 | NVDA | Stock | 0.1052 | 0.106 | 0.104 | 0.1041 | 164480280.0 |
| 2004-08-23 10:00:00 | NVDA | Stock | 0.1041 | 0.1062 | 0.104 | 0.1058 | 96003360.0 |
| 2004-08-23 10:30:00 | NVDA | Stock | 0.1058 | 0.1058 | 0.105 | 0.1058 | 63550200.0 |
| 2004-08-23 11:00:00 | NVDA | Stock | 0.1058 | 0.1061 | 0.1052 | 0.1055 | 53429400.0 |
| 2004-08-23 11:30:00 | NVDA | Stock | 0.1054 | 0.1059 | 0.1052 | 0.1056 | 45546000.0 |
| 2004-08-23 12:00:00 | NVDA | Stock | 0.1056 | 0.1059 | 0.1054 | 0.1055 | 30707160.0 |
| 2004-08-23 12:30:00 | NVDA | Stock | 0.1054 | 0.1057 | 0.1054 | 0.1056 | 27060600.0 |
| 2004-08-23 13:00:00 | NVDA | Stock | 0.1055 | 0.1055 | 0.1047 | 0.1047 | 35988960.0 |
| 2004-08-23 13:30:00 | NVDA | Stock | 0.1047 | 0.1058 | 0.1047 | 0.1057 | 29317680.0 |
| 2004-08-23 14:00:00 | NVDA | Stock | 0.1056 | 0.1057 | 0.1054 | 0.1057 | 34024440.0 |
> showing 50 of 40,617 rows — these rows as CSV