PREVIEW / stock_30min / 2006-03-31
file: by_date/stock_30min/2006/2006-03-31.parquet size: 939 KB rows: 50,805 symbols: 2,226
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-31 04:00:00 | AAPL | Stock | 2.2464 | 2.2464 | 2.2464 | 2.2464 | 8400.0 |
| 2006-03-31 06:30:00 | AAPL | Stock | 2.2411 | 2.2411 | 2.2411 | 2.2411 | 5600.0 |
| 2006-03-31 07:00:00 | AAPL | Stock | 2.2446 | 2.2446 | 2.2411 | 2.2411 | 5600.0 |
| 2006-03-31 07:30:00 | AAPL | Stock | 2.25 | 2.2571 | 2.25 | 2.2571 | 47600.0 |
| 2006-03-31 08:00:00 | AAPL | Stock | 2.2507 | 2.2564 | 2.2464 | 2.2464 | 802480.0 |
| 2006-03-31 08:30:00 | AAPL | Stock | 2.2464 | 2.2536 | 2.2443 | 2.25 | 1506904.0 |
| 2006-03-31 09:00:00 | AAPL | Stock | 2.2493 | 2.2593 | 2.2468 | 2.2589 | 3626364.0 |
| 2006-03-31 09:30:00 | AAPL | Stock | 2.2589 | 2.2718 | 2.2393 | 2.2504 | 148115744.0 |
| 2006-03-31 10:00:00 | AAPL | Stock | 2.2504 | 2.2521 | 2.2229 | 2.2264 | 105526204.0 |
| 2006-03-31 10:30:00 | AAPL | Stock | 2.2261 | 2.2586 | 2.2232 | 2.235 | 61886552.0 |
| 2006-03-31 11:00:00 | AAPL | Stock | 2.2346 | 2.25 | 2.2304 | 2.2439 | 58944704.0 |
| 2006-03-31 11:30:00 | AAPL | Stock | 2.2443 | 2.2584 | 2.2411 | 2.255 | 62608196.0 |
| 2006-03-31 12:00:00 | AAPL | Stock | 2.255 | 2.2714 | 2.2454 | 2.2493 | 52016524.0 |
| 2006-03-31 12:30:00 | AAPL | Stock | 2.2493 | 2.2504 | 2.2418 | 2.2446 | 29746332.0 |
| 2006-03-31 13:00:00 | AAPL | Stock | 2.2446 | 2.25 | 2.2421 | 2.2446 | 20797840.0 |
| 2006-03-31 13:30:00 | AAPL | Stock | 2.2446 | 2.2461 | 2.2346 | 2.2414 | 35261380.0 |
| 2006-03-31 14:00:00 | AAPL | Stock | 2.2411 | 2.2554 | 2.2411 | 2.2471 | 42359380.0 |
| 2006-03-31 14:30:00 | AAPL | Stock | 2.2475 | 2.2582 | 2.245 | 2.2546 | 42283696.0 |
| 2006-03-31 15:00:00 | AAPL | Stock | 2.2539 | 2.2593 | 2.2446 | 2.2496 | 52688692.0 |
| 2006-03-31 15:30:00 | AAPL | Stock | 2.2493 | 2.2536 | 2.24 | 2.2436 | 64259944.0 |
| 2006-03-31 16:00:00 | AAPL | Stock | 2.2418 | 2.2454 | 2.2361 | 2.2393 | 1786260.0 |
| 2006-03-31 16:30:00 | AAPL | Stock | 2.2393 | 2.2446 | 2.2386 | 2.2446 | 7490952.0 |
| 2006-03-31 17:00:00 | AAPL | Stock | 2.2446 | 2.2461 | 2.24 | 2.2446 | 576408.0 |
| 2006-03-31 17:30:00 | AAPL | Stock | 2.245 | 2.2461 | 2.2432 | 2.2432 | 37520.0 |
| 2006-03-31 18:00:00 | AAPL | Stock | 2.2429 | 2.2443 | 2.2418 | 2.2425 | 160160.0 |
| 2006-03-31 07:00:00 | MSFT | Stock | 27.14 | 27.17 | 27.14 | 27.17 | 2300.0 |
| 2006-03-31 07:30:00 | MSFT | Stock | 27.22 | 27.22 | 27.17 | 27.17 | 1420.0 |
| 2006-03-31 08:00:00 | MSFT | Stock | 27.22 | 27.22 | 27.17 | 27.17 | 4130.0 |
| 2006-03-31 08:30:00 | MSFT | Stock | 27.2 | 27.22 | 27.2 | 27.2 | 5015900.0 |
| 2006-03-31 09:00:00 | MSFT | Stock | 27.2 | 27.35 | 27.2 | 27.29 | 76297.0 |
| 2006-03-31 09:30:00 | MSFT | Stock | 27.3 | 27.541 | 27.27 | 27.46 | 6720030.0 |
| 2006-03-31 10:00:00 | MSFT | Stock | 27.46 | 27.53 | 27.4 | 27.46 | 2933455.0 |
| 2006-03-31 10:30:00 | MSFT | Stock | 27.45 | 27.49 | 27.405 | 27.45 | 2494023.0 |
| 2006-03-31 11:00:00 | MSFT | Stock | 27.45 | 27.45 | 27.36 | 27.37 | 3009320.0 |
| 2006-03-31 11:30:00 | MSFT | Stock | 27.37 | 27.43 | 27.35 | 27.39 | 2130173.0 |
| 2006-03-31 12:00:00 | MSFT | Stock | 27.4 | 27.43 | 27.38 | 27.4 | 4041448.0 |
| 2006-03-31 12:30:00 | MSFT | Stock | 27.39 | 27.49 | 27.378 | 27.46 | 2002416.0 |
| 2006-03-31 13:00:00 | MSFT | Stock | 27.462 | 27.47 | 27.31 | 27.33 | 1980648.0 |
| 2006-03-31 13:30:00 | MSFT | Stock | 27.34 | 27.34 | 27.29 | 27.31 | 1721566.0 |
| 2006-03-31 14:00:00 | MSFT | Stock | 27.31 | 27.39 | 27.27 | 27.31 | 2228470.0 |
| 2006-03-31 14:30:00 | MSFT | Stock | 27.31 | 27.4 | 27.3 | 27.34 | 2973930.0 |
| 2006-03-31 15:00:00 | MSFT | Stock | 27.34 | 27.37 | 27.27 | 27.27 | 2356968.0 |
| 2006-03-31 15:30:00 | MSFT | Stock | 27.27 | 27.33 | 27.21 | 27.24 | 12408498.0 |
| 2006-03-31 16:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.17 | 27.21 | 471573.0 |
| 2006-03-31 16:30:00 | MSFT | Stock | 27.228 | 27.228 | 27.21 | 27.21 | 1384072.0 |
| 2006-03-31 17:00:00 | MSFT | Stock | 27.23 | 27.24 | 27.21 | 27.24 | 503174.0 |
| 2006-03-31 17:30:00 | MSFT | Stock | 27.24 | 27.24 | 27.23 | 27.23 | 2100.0 |
| 2006-03-31 18:00:00 | MSFT | Stock | 27.22 | 27.22 | 27.22 | 27.22 | 100.0 |
| 2006-03-31 08:30:00 | NVDA | Stock | 0.4783 | 0.4783 | 0.4768 | 0.4775 | 192000.0 |
| 2006-03-31 09:00:00 | NVDA | Stock | 0.4771 | 0.4796 | 0.477 | 0.4781 | 510480.0 |
> showing 50 of 50,805 rows — these rows as CSV