PREVIEW / stock_30min / 2006-07-07
file: by_date/stock_30min/2006/2006-07-07.parquet size: 914 KB rows: 49,329 symbols: 2,304
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-07-07 08:00:00 | AAPL | Stock | 2.0014 | 2.0014 | 1.9886 | 1.9929 | 651616.0 |
| 2006-07-07 08:30:00 | AAPL | Stock | 1.9954 | 2.005 | 1.9911 | 1.9939 | 1659868.0 |
| 2006-07-07 09:00:00 | AAPL | Stock | 1.9936 | 1.9936 | 1.9821 | 1.9825 | 3342164.0 |
| 2006-07-07 09:30:00 | AAPL | Stock | 1.9814 | 1.9846 | 1.9525 | 1.9636 | 132515124.0 |
| 2006-07-07 10:00:00 | AAPL | Stock | 1.9634 | 1.9729 | 1.9564 | 1.9664 | 75165300.0 |
| 2006-07-07 10:30:00 | AAPL | Stock | 1.9668 | 1.9764 | 1.9596 | 1.9704 | 62642160.0 |
| 2006-07-07 11:00:00 | AAPL | Stock | 1.9704 | 1.9814 | 1.9686 | 1.9807 | 32633692.0 |
| 2006-07-07 11:30:00 | AAPL | Stock | 1.9804 | 1.9993 | 1.98 | 1.9896 | 96406240.0 |
| 2006-07-07 12:00:00 | AAPL | Stock | 1.9904 | 2.0071 | 1.9846 | 2.0 | 50915732.0 |
| 2006-07-07 12:30:00 | AAPL | Stock | 2.0 | 2.0196 | 1.9986 | 2.0029 | 86290148.0 |
| 2006-07-07 13:00:00 | AAPL | Stock | 2.0029 | 2.0064 | 1.9889 | 1.9989 | 47505780.0 |
| 2006-07-07 13:30:00 | AAPL | Stock | 1.9989 | 2.0054 | 1.9918 | 2.0007 | 28932064.0 |
| 2006-07-07 14:00:00 | AAPL | Stock | 2.0007 | 2.0079 | 2.0 | 2.0029 | 22949472.0 |
| 2006-07-07 14:30:00 | AAPL | Stock | 2.0029 | 2.0029 | 1.9764 | 1.9775 | 55673072.0 |
| 2006-07-07 15:00:00 | AAPL | Stock | 1.9768 | 1.9814 | 1.9718 | 1.9779 | 44479120.0 |
| 2006-07-07 15:30:00 | AAPL | Stock | 1.9779 | 1.9854 | 1.9729 | 1.9796 | 49876876.0 |
| 2006-07-07 16:00:00 | AAPL | Stock | 1.9786 | 1.9964 | 1.9771 | 1.9821 | 1508500.0 |
| 2006-07-07 16:30:00 | AAPL | Stock | 1.9829 | 1.9857 | 1.9786 | 1.9832 | 1477000.0 |
| 2006-07-07 17:00:00 | AAPL | Stock | 1.9832 | 1.9857 | 1.9832 | 1.9857 | 338800.0 |
| 2006-07-07 17:30:00 | AAPL | Stock | 1.985 | 1.985 | 1.9846 | 1.9846 | 368200.0 |
| 2006-07-07 18:00:00 | AAPL | Stock | 1.9836 | 1.9857 | 1.9836 | 1.9857 | 25200.0 |
| 2006-07-07 08:00:00 | MSFT | Stock | 23.48 | 23.52 | 23.48 | 23.5 | 12800.0 |
| 2006-07-07 08:30:00 | MSFT | Stock | 23.5 | 23.58 | 23.48 | 23.5 | 68338.0 |
| 2006-07-07 09:00:00 | MSFT | Stock | 23.49 | 23.5 | 23.35 | 23.41 | 391387.0 |
| 2006-07-07 09:30:00 | MSFT | Stock | 23.39 | 23.55 | 23.38 | 23.52 | 7726955.0 |
| 2006-07-07 10:00:00 | MSFT | Stock | 23.51 | 23.52 | 23.43 | 23.47 | 6522311.0 |
| 2006-07-07 10:30:00 | MSFT | Stock | 23.48 | 23.48 | 23.4 | 23.42 | 3629122.0 |
| 2006-07-07 11:00:00 | MSFT | Stock | 23.42 | 23.43 | 23.38 | 23.41 | 2699031.0 |
| 2006-07-07 11:30:00 | MSFT | Stock | 23.41 | 23.5 | 23.4 | 23.422 | 2607233.0 |
| 2006-07-07 12:00:00 | MSFT | Stock | 23.42 | 23.43 | 23.41 | 23.42 | 1622564.0 |
| 2006-07-07 12:30:00 | MSFT | Stock | 23.422 | 23.49 | 23.41 | 23.42 | 1876250.0 |
| 2006-07-07 13:00:00 | MSFT | Stock | 23.42 | 23.43 | 23.38 | 23.4 | 2690802.0 |
| 2006-07-07 13:30:00 | MSFT | Stock | 23.42 | 23.45 | 23.39 | 23.45 | 2007761.0 |
| 2006-07-07 14:00:00 | MSFT | Stock | 23.44 | 23.47 | 23.42 | 23.44 | 1464315.0 |
| 2006-07-07 14:30:00 | MSFT | Stock | 23.45 | 23.45 | 23.36 | 23.39 | 5867686.0 |
| 2006-07-07 15:00:00 | MSFT | Stock | 23.39 | 23.44 | 23.37 | 23.38 | 4096504.0 |
| 2006-07-07 15:30:00 | MSFT | Stock | 23.38 | 23.45 | 23.3 | 23.31 | 7166247.0 |
| 2006-07-07 16:00:00 | MSFT | Stock | 23.31 | 23.39 | 23.29 | 23.32 | 218331.0 |
| 2006-07-07 16:30:00 | MSFT | Stock | 23.3 | 23.32 | 23.3 | 23.32 | 687.0 |
| 2006-07-07 17:00:00 | MSFT | Stock | 23.32 | 23.33 | 23.31 | 23.32 | 5900.0 |
| 2006-07-07 17:30:00 | MSFT | Stock | 23.32 | 23.33 | 23.32 | 23.32 | 550.0 |
| 2006-07-07 18:00:00 | MSFT | Stock | 23.33 | 23.33 | 23.31 | 23.32 | 800.0 |
| 2006-07-07 04:00:00 | NVDA | Stock | 0.3333 | 0.3333 | 0.3333 | 0.3333 | 36000.0 |
| 2006-07-07 08:00:00 | NVDA | Stock | 0.3333 | 0.3333 | 0.3332 | 0.3333 | 252120.0 |
| 2006-07-07 08:30:00 | NVDA | Stock | 0.3358 | 0.3358 | 0.3333 | 0.3333 | 174000.0 |
| 2006-07-07 09:00:00 | NVDA | Stock | 0.3332 | 0.3353 | 0.3308 | 0.3353 | 17184480.0 |
| 2006-07-07 09:30:00 | NVDA | Stock | 0.3355 | 0.3362 | 0.3278 | 0.3297 | 53992320.0 |
| 2006-07-07 10:00:00 | NVDA | Stock | 0.3295 | 0.3308 | 0.3267 | 0.3273 | 57538620.0 |
| 2006-07-07 10:30:00 | NVDA | Stock | 0.3275 | 0.3282 | 0.3262 | 0.3273 | 34965540.0 |
| 2006-07-07 11:00:00 | NVDA | Stock | 0.3273 | 0.3283 | 0.3263 | 0.3265 | 28522680.0 |
> showing 50 of 49,329 rows — these rows as CSV