PREVIEW / stock_30min / 2008-07-21
file: by_date/stock_30min/2008/2008-07-21.parquet size: 1.2 MB rows: 68,021 symbols: 3,327
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-21 05:00:00 | AAPL | Stock | 5.9161 | 5.9161 | 5.9161 | 5.9161 | 28000.0 |
| 2008-07-21 05:30:00 | AAPL | Stock | 5.9171 | 5.9171 | 5.9171 | 5.9171 | 8400.0 |
| 2008-07-21 06:30:00 | AAPL | Stock | 5.9271 | 5.95 | 5.9271 | 5.95 | 8960.0 |
| 2008-07-21 07:00:00 | AAPL | Stock | 5.9464 | 5.9729 | 5.9464 | 5.9539 | 225148.0 |
| 2008-07-21 07:30:00 | AAPL | Stock | 5.9554 | 5.9643 | 5.9393 | 5.95 | 270760.0 |
| 2008-07-21 08:00:00 | AAPL | Stock | 5.9482 | 5.9571 | 5.9446 | 5.9514 | 3351432.0 |
| 2008-07-21 08:30:00 | AAPL | Stock | 5.95 | 5.9643 | 5.9421 | 5.9518 | 4274144.0 |
| 2008-07-21 09:00:00 | AAPL | Stock | 5.9518 | 5.9632 | 5.9289 | 5.9607 | 5469240.0 |
| 2008-07-21 09:30:00 | AAPL | Stock | 5.9604 | 5.9821 | 5.8611 | 5.8929 | 124881316.0 |
| 2008-07-21 10:00:00 | AAPL | Stock | 5.8929 | 5.9046 | 5.8407 | 5.8632 | 92320060.0 |
| 2008-07-21 10:30:00 | AAPL | Stock | 5.8632 | 5.8932 | 5.855 | 5.8579 | 47598656.0 |
| 2008-07-21 11:00:00 | AAPL | Stock | 5.8576 | 5.8679 | 5.8239 | 5.8554 | 51241260.0 |
| 2008-07-21 11:30:00 | AAPL | Stock | 5.8557 | 5.8586 | 5.7543 | 5.7775 | 77040488.0 |
| 2008-07-21 12:00:00 | AAPL | Stock | 5.7775 | 5.8261 | 5.7718 | 5.7911 | 55919976.0 |
| 2008-07-21 12:30:00 | AAPL | Stock | 5.7914 | 5.8136 | 5.7725 | 5.7832 | 41687044.0 |
| 2008-07-21 13:00:00 | AAPL | Stock | 5.7832 | 5.8511 | 5.7793 | 5.8296 | 63544292.0 |
| 2008-07-21 13:30:00 | AAPL | Stock | 5.8295 | 5.8768 | 5.7857 | 5.8231 | 57372672.0 |
| 2008-07-21 14:00:00 | AAPL | Stock | 5.8243 | 5.8621 | 5.8107 | 5.8536 | 54420380.0 |
| 2008-07-21 14:30:00 | AAPL | Stock | 5.8536 | 5.8643 | 5.8211 | 5.8607 | 52680404.0 |
| 2008-07-21 15:00:00 | AAPL | Stock | 5.8614 | 5.9068 | 5.8257 | 5.9043 | 90069728.0 |
| 2008-07-21 15:30:00 | AAPL | Stock | 5.9039 | 5.9525 | 5.8929 | 5.9457 | 152917576.0 |
| 2008-07-21 16:00:00 | AAPL | Stock | 5.9457 | 5.9925 | 5.8579 | 5.9025 | 81161360.0 |
| 2008-07-21 16:30:00 | AAPL | Stock | 5.8936 | 5.9591 | 5.5714 | 5.5839 | 118917624.0 |
| 2008-07-21 17:00:00 | AAPL | Stock | 5.5857 | 5.6143 | 5.4004 | 5.4275 | 51078020.0 |
| 2008-07-21 17:30:00 | AAPL | Stock | 5.4286 | 5.9289 | 5.2714 | 5.3336 | 63521248.0 |
| 2008-07-21 18:00:00 | AAPL | Stock | 5.3357 | 5.3357 | 5.27 | 5.2786 | 24882844.0 |
| 2008-07-21 18:30:00 | AAPL | Stock | 5.2793 | 5.2989 | 5.2711 | 5.2896 | 6566000.0 |
| 2008-07-21 19:00:00 | AAPL | Stock | 5.2896 | 5.3357 | 5.2896 | 5.3336 | 5282368.0 |
| 2008-07-21 19:30:00 | AAPL | Stock | 5.3321 | 5.3536 | 5.3221 | 5.3464 | 5195400.0 |
| 2008-07-21 07:00:00 | MSFT | Stock | 25.99 | 26.05 | 25.99 | 26.04 | 2930.0 |
| 2008-07-21 07:30:00 | MSFT | Stock | 26.08 | 26.08 | 26.0 | 26.0 | 4500.0 |
| 2008-07-21 08:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.8 | 25.85 | 18555.0 |
| 2008-07-21 08:30:00 | MSFT | Stock | 25.85 | 25.87 | 25.75 | 25.81 | 19222.0 |
| 2008-07-21 09:00:00 | MSFT | Stock | 25.82 | 25.86 | 25.62 | 25.67 | 62651.0 |
| 2008-07-21 09:30:00 | MSFT | Stock | 25.7 | 26.135 | 25.66 | 26.135 | 8912272.0 |
| 2008-07-21 10:00:00 | MSFT | Stock | 26.13 | 26.17 | 25.98 | 25.98 | 8612200.0 |
| 2008-07-21 10:30:00 | MSFT | Stock | 25.98 | 25.99 | 25.81 | 25.91 | 5606660.0 |
| 2008-07-21 11:00:00 | MSFT | Stock | 25.91 | 25.97 | 25.73 | 25.74 | 4881938.0 |
| 2008-07-21 11:30:00 | MSFT | Stock | 25.75 | 25.775 | 25.66 | 25.71 | 5111281.0 |
| 2008-07-21 12:00:00 | MSFT | Stock | 25.71 | 25.71 | 25.54 | 25.64 | 5052214.0 |
| 2008-07-21 12:30:00 | MSFT | Stock | 25.63 | 25.68 | 25.56 | 25.58 | 3210540.0 |
| 2008-07-21 13:00:00 | MSFT | Stock | 25.58 | 26.15 | 25.56 | 25.608 | 2746956.0 |
| 2008-07-21 13:30:00 | MSFT | Stock | 25.61 | 25.68 | 25.57 | 25.66 | 4649965.0 |
| 2008-07-21 14:00:00 | MSFT | Stock | 25.67 | 25.71 | 25.6 | 25.61 | 5390023.0 |
| 2008-07-21 14:30:00 | MSFT | Stock | 25.6 | 25.62 | 25.54 | 25.552 | 3513748.0 |
| 2008-07-21 15:00:00 | MSFT | Stock | 25.56 | 25.61 | 25.53 | 25.56 | 5428540.0 |
| 2008-07-21 15:30:00 | MSFT | Stock | 25.55 | 25.66 | 25.53 | 25.63 | 7288036.0 |
| 2008-07-21 16:00:00 | MSFT | Stock | 25.63 | 25.751 | 25.585 | 25.6 | 3267783.0 |
| 2008-07-21 16:30:00 | MSFT | Stock | 25.62 | 25.64 | 25.4 | 25.41 | 1559176.0 |
| 2008-07-21 17:00:00 | MSFT | Stock | 25.41 | 25.41 | 25.35 | 25.35 | 26185.0 |
> showing 50 of 68,021 rows — these rows as CSV