PREVIEW / stock_30min / 2005-10-12
file: by_date/stock_30min/2005/2005-10-12.parquet size: 874 KB rows: 47,235 symbols: 2,094
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-12 05:00:00 | AAPL | Stock | 1.6682 | 1.6682 | 1.6682 | 1.6682 | 56000.0 |
| 2005-10-12 05:30:00 | AAPL | Stock | 1.6889 | 1.6889 | 1.6889 | 1.6889 | 2800.0 |
| 2005-10-12 06:00:00 | AAPL | Stock | 1.6875 | 1.6921 | 1.6789 | 1.6921 | 36400.0 |
| 2005-10-12 06:30:00 | AAPL | Stock | 1.6789 | 1.6821 | 1.6789 | 1.6821 | 44800.0 |
| 2005-10-12 07:00:00 | AAPL | Stock | 1.6839 | 1.6946 | 1.6768 | 1.6871 | 827540.0 |
| 2005-10-12 07:30:00 | AAPL | Stock | 1.6875 | 1.6929 | 1.6857 | 1.6886 | 1354780.0 |
| 2005-10-12 08:00:00 | AAPL | Stock | 1.6907 | 1.7268 | 1.6793 | 1.7193 | 60633496.0 |
| 2005-10-12 08:30:00 | AAPL | Stock | 1.7193 | 1.7232 | 1.7071 | 1.7186 | 30181872.0 |
| 2005-10-12 09:00:00 | AAPL | Stock | 1.7182 | 1.7404 | 1.7114 | 1.7375 | 55156528.0 |
| 2005-10-12 09:30:00 | AAPL | Stock | 1.7375 | 1.7743 | 1.7096 | 1.7675 | 580502608.0 |
| 2005-10-12 10:00:00 | AAPL | Stock | 1.7675 | 1.7854 | 1.7554 | 1.7839 | 283913336.0 |
| 2005-10-12 10:30:00 | AAPL | Stock | 1.7839 | 1.7929 | 1.7593 | 1.7707 | 227229632.0 |
| 2005-10-12 11:00:00 | AAPL | Stock | 1.7714 | 1.7964 | 1.7675 | 1.7932 | 132994792.0 |
| 2005-10-12 11:30:00 | AAPL | Stock | 1.7939 | 1.7961 | 1.7643 | 1.7646 | 126703808.0 |
| 2005-10-12 12:00:00 | AAPL | Stock | 1.7643 | 1.7814 | 1.7625 | 1.7771 | 77504028.0 |
| 2005-10-12 12:30:00 | AAPL | Stock | 1.7771 | 1.7868 | 1.7654 | 1.7814 | 106273272.0 |
| 2005-10-12 13:00:00 | AAPL | Stock | 1.7814 | 1.7857 | 1.7479 | 1.7746 | 221339244.0 |
| 2005-10-12 13:30:00 | AAPL | Stock | 1.775 | 1.7936 | 1.7418 | 1.7711 | 249101916.0 |
| 2005-10-12 14:00:00 | AAPL | Stock | 1.7714 | 1.7714 | 1.7414 | 1.7457 | 148440320.0 |
| 2005-10-12 14:30:00 | AAPL | Stock | 1.7454 | 1.7529 | 1.735 | 1.7436 | 122975776.0 |
| 2005-10-12 15:00:00 | AAPL | Stock | 1.7443 | 1.7825 | 1.7346 | 1.7536 | 100964640.0 |
| 2005-10-12 15:30:00 | AAPL | Stock | 1.7532 | 1.7743 | 1.7461 | 1.7589 | 144652200.0 |
| 2005-10-12 16:00:00 | AAPL | Stock | 1.7589 | 1.7639 | 1.7536 | 1.7536 | 3573892.0 |
| 2005-10-12 16:30:00 | AAPL | Stock | 1.7532 | 1.7568 | 1.7529 | 1.7568 | 262332.0 |
| 2005-10-12 17:00:00 | AAPL | Stock | 1.7586 | 1.7604 | 1.7554 | 1.7582 | 267176.0 |
| 2005-10-12 17:30:00 | AAPL | Stock | 1.7582 | 1.7605 | 1.7568 | 1.7593 | 1788024.0 |
| 2005-10-12 18:00:00 | AAPL | Stock | 1.7593 | 1.7593 | 1.7582 | 1.7582 | 1018500.0 |
| 2005-10-12 08:00:00 | MSFT | Stock | 24.38 | 24.41 | 24.31 | 24.31 | 43290.0 |
| 2005-10-12 08:30:00 | MSFT | Stock | 24.33 | 24.36 | 24.33 | 24.36 | 1500.0 |
| 2005-10-12 09:00:00 | MSFT | Stock | 24.36 | 24.5 | 24.35 | 24.49 | 131567.0 |
| 2005-10-12 09:30:00 | MSFT | Stock | 24.49 | 24.7 | 24.41 | 24.67 | 7504618.0 |
| 2005-10-12 10:00:00 | MSFT | Stock | 24.672 | 24.7 | 24.48 | 24.53 | 6148391.0 |
| 2005-10-12 10:30:00 | MSFT | Stock | 24.53 | 24.6 | 24.45 | 24.53 | 4321531.0 |
| 2005-10-12 11:00:00 | MSFT | Stock | 24.53 | 24.54 | 24.45 | 24.502 | 4302066.0 |
| 2005-10-12 11:30:00 | MSFT | Stock | 24.51 | 24.53 | 24.41 | 24.43 | 4468906.0 |
| 2005-10-12 12:00:00 | MSFT | Stock | 24.43 | 24.48 | 24.33 | 24.36 | 5996180.0 |
| 2005-10-12 12:30:00 | MSFT | Stock | 24.36 | 24.43 | 24.3 | 24.35 | 3604711.0 |
| 2005-10-12 13:00:00 | MSFT | Stock | 24.342 | 24.41 | 24.31 | 24.34 | 4103678.0 |
| 2005-10-12 13:30:00 | MSFT | Stock | 24.34 | 24.37 | 24.27 | 24.37 | 3723795.0 |
| 2005-10-12 14:00:00 | MSFT | Stock | 24.36 | 24.45 | 24.31 | 24.4 | 6457696.0 |
| 2005-10-12 14:30:00 | MSFT | Stock | 24.4 | 24.44 | 24.32 | 24.35 | 3190638.0 |
| 2005-10-12 15:00:00 | MSFT | Stock | 24.36 | 24.43 | 24.31 | 24.39 | 4467931.0 |
| 2005-10-12 15:30:00 | MSFT | Stock | 24.39 | 24.41 | 24.3 | 24.3 | 10632089.0 |
| 2005-10-12 16:00:00 | MSFT | Stock | 24.31 | 24.63 | 24.29 | 24.29 | 1218673.0 |
| 2005-10-12 16:30:00 | MSFT | Stock | 24.3 | 24.34 | 24.3 | 24.32 | 18620.0 |
| 2005-10-12 17:00:00 | MSFT | Stock | 24.33 | 24.35 | 24.31 | 24.32 | 51593.0 |
| 2005-10-12 17:30:00 | MSFT | Stock | 24.31 | 24.35 | 24.31 | 24.33 | 20739.0 |
| 2005-10-12 18:00:00 | MSFT | Stock | 24.35 | 24.35 | 24.31 | 24.35 | 100936.0 |
| 2005-10-12 09:00:00 | NVDA | Stock | 0.2648 | 0.2648 | 0.2648 | 0.2648 | 12000.0 |
| 2005-10-12 09:30:00 | NVDA | Stock | 0.2644 | 0.2691 | 0.2641 | 0.2691 | 87810360.0 |
> showing 50 of 47,235 rows — these rows as CSV