PREVIEW / stock_30min / 2004-09-02
file: by_date/stock_30min/2004/2004-09-02.parquet size: 735 KB rows: 40,321 symbols: 1,829
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-09-02 08:00:00 | AAPL | Stock | 0.6384 | 0.6429 | 0.6339 | 0.64 | 353360.0 |
| 2004-09-02 08:30:00 | AAPL | Stock | 0.6393 | 0.6393 | 0.6393 | 0.6393 | 5600.0 |
| 2004-09-02 09:00:00 | AAPL | Stock | 0.6375 | 0.6379 | 0.6334 | 0.6339 | 3161368.0 |
| 2004-09-02 09:30:00 | AAPL | Stock | 0.6339 | 0.6388 | 0.6302 | 0.6309 | 55230504.0 |
| 2004-09-02 10:00:00 | AAPL | Stock | 0.6309 | 0.6348 | 0.6309 | 0.6336 | 31126536.0 |
| 2004-09-02 10:30:00 | AAPL | Stock | 0.6339 | 0.6339 | 0.6302 | 0.632 | 31542728.0 |
| 2004-09-02 11:00:00 | AAPL | Stock | 0.632 | 0.6327 | 0.6243 | 0.6271 | 40033392.0 |
| 2004-09-02 11:30:00 | AAPL | Stock | 0.6271 | 0.6271 | 0.6232 | 0.6254 | 18709600.0 |
| 2004-09-02 12:00:00 | AAPL | Stock | 0.6252 | 0.6255 | 0.622 | 0.6245 | 13980456.0 |
| 2004-09-02 12:30:00 | AAPL | Stock | 0.6245 | 0.6262 | 0.6232 | 0.6241 | 11318328.0 |
| 2004-09-02 13:00:00 | AAPL | Stock | 0.6245 | 0.6268 | 0.6232 | 0.6261 | 12736976.0 |
| 2004-09-02 13:30:00 | AAPL | Stock | 0.6261 | 0.6277 | 0.6252 | 0.6275 | 8411088.0 |
| 2004-09-02 14:00:00 | AAPL | Stock | 0.6275 | 0.632 | 0.6273 | 0.6291 | 23054248.0 |
| 2004-09-02 14:30:00 | AAPL | Stock | 0.6291 | 0.6316 | 0.6263 | 0.6302 | 26691224.0 |
| 2004-09-02 15:00:00 | AAPL | Stock | 0.63 | 0.6373 | 0.6291 | 0.6346 | 44449720.0 |
| 2004-09-02 15:30:00 | AAPL | Stock | 0.6348 | 0.6395 | 0.633 | 0.637 | 61383784.0 |
| 2004-09-02 16:00:00 | AAPL | Stock | 0.6371 | 0.638 | 0.6205 | 0.625 | 4789736.0 |
| 2004-09-02 16:30:00 | AAPL | Stock | 0.625 | 0.6368 | 0.625 | 0.6346 | 1752800.0 |
| 2004-09-02 17:30:00 | AAPL | Stock | 0.628 | 0.628 | 0.6279 | 0.6279 | 72800.0 |
| 2004-09-02 18:00:00 | AAPL | Stock | 0.6279 | 0.6279 | 0.6279 | 0.6279 | 28000.0 |
| 2004-09-02 08:00:00 | MSFT | Stock | 27.41 | 27.41 | 27.41 | 27.41 | 100.0 |
| 2004-09-02 08:30:00 | MSFT | Stock | 27.36 | 27.36 | 27.27 | 27.3 | 12100.0 |
| 2004-09-02 09:00:00 | MSFT | Stock | 27.35 | 27.4 | 27.28 | 27.38 | 128003.0 |
| 2004-09-02 09:30:00 | MSFT | Stock | 27.38 | 27.49 | 27.35 | 27.45 | 4042308.0 |
| 2004-09-02 10:00:00 | MSFT | Stock | 27.45 | 27.54 | 27.44 | 27.49 | 3820692.0 |
| 2004-09-02 10:30:00 | MSFT | Stock | 27.47 | 27.55 | 27.47 | 27.55 | 3289061.0 |
| 2004-09-02 11:00:00 | MSFT | Stock | 27.55 | 27.57 | 27.449 | 27.47 | 2845508.0 |
| 2004-09-02 11:30:00 | MSFT | Stock | 27.47 | 27.5 | 27.44 | 27.45 | 1374624.0 |
| 2004-09-02 12:00:00 | MSFT | Stock | 27.46 | 27.48 | 27.43 | 27.46 | 871259.0 |
| 2004-09-02 12:30:00 | MSFT | Stock | 27.47 | 27.48 | 27.45 | 27.45 | 712601.0 |
| 2004-09-02 13:00:00 | MSFT | Stock | 27.45 | 27.46 | 27.42 | 27.45 | 1216300.0 |
| 2004-09-02 13:30:00 | MSFT | Stock | 27.45 | 27.45 | 27.4 | 27.41 | 1070901.0 |
| 2004-09-02 14:00:00 | MSFT | Stock | 27.42 | 27.5 | 27.39 | 27.5 | 3007396.0 |
| 2004-09-02 14:30:00 | MSFT | Stock | 27.5 | 27.57 | 27.45 | 27.56 | 5011242.0 |
| 2004-09-02 15:00:00 | MSFT | Stock | 27.56 | 27.67 | 27.51 | 27.61 | 6691518.0 |
| 2004-09-02 15:30:00 | MSFT | Stock | 27.61 | 27.68 | 27.58 | 27.63 | 5848586.0 |
| 2004-09-02 16:00:00 | MSFT | Stock | 27.63 | 27.65 | 27.3 | 27.35 | 939955.0 |
| 2004-09-02 16:30:00 | MSFT | Stock | 27.35 | 27.62 | 27.25 | 27.3 | 147366.0 |
| 2004-09-02 17:00:00 | MSFT | Stock | 27.33 | 27.35 | 27.3 | 27.35 | 17900.0 |
| 2004-09-02 17:30:00 | MSFT | Stock | 27.35 | 27.35 | 27.3 | 27.3 | 14399.0 |
| 2004-09-02 18:00:00 | MSFT | Stock | 27.3 | 27.34 | 27.3 | 27.34 | 42400.0 |
| 2004-09-02 08:30:00 | NVDA | Stock | 0.1058 | 0.1058 | 0.1058 | 0.1058 | 30240.0 |
| 2004-09-02 09:00:00 | NVDA | Stock | 0.1056 | 0.1062 | 0.1055 | 0.1057 | 16621320.0 |
| 2004-09-02 09:30:00 | NVDA | Stock | 0.1064 | 0.1078 | 0.1053 | 0.1062 | 95726280.0 |
| 2004-09-02 10:00:00 | NVDA | Stock | 0.1062 | 0.1067 | 0.1061 | 0.1064 | 56537520.0 |
| 2004-09-02 10:30:00 | NVDA | Stock | 0.1066 | 0.1068 | 0.1062 | 0.1067 | 35796120.0 |
| 2004-09-02 11:00:00 | NVDA | Stock | 0.1067 | 0.1069 | 0.1062 | 0.1062 | 29507400.0 |
| 2004-09-02 11:30:00 | NVDA | Stock | 0.1062 | 0.107 | 0.1061 | 0.1069 | 31072800.0 |
| 2004-09-02 12:00:00 | NVDA | Stock | 0.1069 | 0.1071 | 0.1067 | 0.1071 | 22331280.0 |
| 2004-09-02 12:30:00 | NVDA | Stock | 0.1072 | 0.1072 | 0.1071 | 0.1071 | 9592560.0 |
> showing 50 of 40,321 rows — these rows as CSV