PREVIEW / stock_30min / 2004-07-29
file: by_date/stock_30min/2004/2004-07-29.parquet size: 753 KB rows: 40,588 symbols: 1,813
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-07-29 08:30:00 | AAPL | Stock | 0.5786 | 0.5786 | 0.5764 | 0.5764 | 168000.0 |
| 2004-07-29 09:00:00 | AAPL | Stock | 0.5798 | 0.5814 | 0.5798 | 0.5814 | 387072.0 |
| 2004-07-29 09:30:00 | AAPL | Stock | 0.5804 | 0.5821 | 0.5796 | 0.5802 | 23128560.0 |
| 2004-07-29 10:00:00 | AAPL | Stock | 0.5805 | 0.5813 | 0.5775 | 0.5784 | 25848144.0 |
| 2004-07-29 10:30:00 | AAPL | Stock | 0.578 | 0.5789 | 0.5738 | 0.5779 | 15954456.0 |
| 2004-07-29 11:00:00 | AAPL | Stock | 0.5777 | 0.5786 | 0.5745 | 0.5754 | 10115112.0 |
| 2004-07-29 11:30:00 | AAPL | Stock | 0.5755 | 0.5773 | 0.5743 | 0.5746 | 6403376.0 |
| 2004-07-29 12:00:00 | AAPL | Stock | 0.5746 | 0.5802 | 0.5741 | 0.5791 | 11921056.0 |
| 2004-07-29 12:30:00 | AAPL | Stock | 0.5791 | 0.583 | 0.5791 | 0.5821 | 16496704.0 |
| 2004-07-29 13:00:00 | AAPL | Stock | 0.5823 | 0.5861 | 0.5818 | 0.5836 | 20982192.0 |
| 2004-07-29 13:30:00 | AAPL | Stock | 0.5836 | 0.5841 | 0.582 | 0.5821 | 12330416.0 |
| 2004-07-29 14:00:00 | AAPL | Stock | 0.5821 | 0.5827 | 0.5795 | 0.5807 | 13775272.0 |
| 2004-07-29 14:30:00 | AAPL | Stock | 0.5809 | 0.5832 | 0.5802 | 0.5832 | 11213496.0 |
| 2004-07-29 15:00:00 | AAPL | Stock | 0.5832 | 0.5857 | 0.5825 | 0.5827 | 18666480.0 |
| 2004-07-29 15:30:00 | AAPL | Stock | 0.5827 | 0.5857 | 0.5809 | 0.583 | 20728568.0 |
| 2004-07-29 16:00:00 | AAPL | Stock | 0.583 | 0.5841 | 0.5821 | 0.5821 | 1791776.0 |
| 2004-07-29 16:30:00 | AAPL | Stock | 0.5825 | 0.5836 | 0.5825 | 0.5827 | 557200.0 |
| 2004-07-29 17:00:00 | AAPL | Stock | 0.5827 | 0.5829 | 0.582 | 0.5829 | 236880.0 |
| 2004-07-29 17:30:00 | AAPL | Stock | 0.583 | 0.583 | 0.583 | 0.583 | 16800.0 |
| 2004-07-29 08:00:00 | MSFT | Stock | 28.62 | 28.7 | 28.595 | 28.7 | 42182.0 |
| 2004-07-29 08:30:00 | MSFT | Stock | 28.71 | 28.74 | 28.68 | 28.73 | 34200.0 |
| 2004-07-29 09:00:00 | MSFT | Stock | 28.72 | 28.79 | 28.7 | 28.79 | 140899.0 |
| 2004-07-29 09:30:00 | MSFT | Stock | 28.78 | 28.8 | 28.71 | 28.779 | 3548903.0 |
| 2004-07-29 10:00:00 | MSFT | Stock | 28.78 | 28.78 | 28.57 | 28.62 | 4267843.0 |
| 2004-07-29 10:30:00 | MSFT | Stock | 28.62 | 28.64 | 28.47 | 28.57 | 4478779.0 |
| 2004-07-29 11:00:00 | MSFT | Stock | 28.57 | 28.62 | 28.48 | 28.491 | 3406921.0 |
| 2004-07-29 11:30:00 | MSFT | Stock | 28.49 | 28.55 | 28.46 | 28.52 | 2598849.0 |
| 2004-07-29 12:00:00 | MSFT | Stock | 28.52 | 28.63 | 28.47 | 28.6 | 2999507.0 |
| 2004-07-29 12:30:00 | MSFT | Stock | 28.6 | 28.63 | 28.51 | 28.53 | 3058303.0 |
| 2004-07-29 13:00:00 | MSFT | Stock | 28.53 | 28.61 | 28.5 | 28.54 | 2435545.0 |
| 2004-07-29 13:30:00 | MSFT | Stock | 28.54 | 28.55 | 28.449 | 28.45 | 2750700.0 |
| 2004-07-29 14:00:00 | MSFT | Stock | 28.45 | 28.46 | 28.25 | 28.31 | 5611098.0 |
| 2004-07-29 14:30:00 | MSFT | Stock | 28.31 | 28.42 | 28.29 | 28.42 | 5318792.0 |
| 2004-07-29 15:00:00 | MSFT | Stock | 28.42 | 28.5 | 28.36 | 28.43 | 6299575.0 |
| 2004-07-29 15:30:00 | MSFT | Stock | 28.44 | 28.5 | 28.29 | 28.47 | 9025367.0 |
| 2004-07-29 16:00:00 | MSFT | Stock | 28.47 | 28.51 | 28.42 | 28.45 | 730794.0 |
| 2004-07-29 16:30:00 | MSFT | Stock | 28.46 | 28.54 | 28.29 | 28.49 | 80676.0 |
| 2004-07-29 17:00:00 | MSFT | Stock | 28.5 | 28.51 | 28.46 | 28.47 | 41300.0 |
| 2004-07-29 17:30:00 | MSFT | Stock | 28.45 | 28.45 | 28.45 | 28.45 | 1100.0 |
| 2004-07-29 18:00:00 | MSFT | Stock | 28.45 | 28.46 | 28.45 | 28.46 | 2300.0 |
| 2004-07-29 08:00:00 | NVDA | Stock | 0.1196 | 0.1196 | 0.1192 | 0.1192 | 1560000.0 |
| 2004-07-29 08:30:00 | NVDA | Stock | 0.1202 | 0.1202 | 0.1202 | 0.1202 | 120000.0 |
| 2004-07-29 09:00:00 | NVDA | Stock | 0.1212 | 0.1212 | 0.12 | 0.1207 | 578640.0 |
| 2004-07-29 09:30:00 | NVDA | Stock | 0.1203 | 0.1297 | 0.1203 | 0.128 | 170394720.0 |
| 2004-07-29 10:00:00 | NVDA | Stock | 0.1281 | 0.1282 | 0.1255 | 0.1259 | 78549120.0 |
| 2004-07-29 10:30:00 | NVDA | Stock | 0.1259 | 0.1277 | 0.1257 | 0.1271 | 86138760.0 |
| 2004-07-29 11:00:00 | NVDA | Stock | 0.1271 | 0.128 | 0.127 | 0.127 | 41138400.0 |
| 2004-07-29 11:30:00 | NVDA | Stock | 0.1271 | 0.1275 | 0.1265 | 0.1271 | 35630160.0 |
| 2004-07-29 12:00:00 | NVDA | Stock | 0.1269 | 0.1288 | 0.1265 | 0.1287 | 31490520.0 |
| 2004-07-29 12:30:00 | NVDA | Stock | 0.1287 | 0.1297 | 0.1283 | 0.1292 | 33230160.0 |
> showing 50 of 40,588 rows — these rows as CSV