PREVIEW / stock_30min / 2010-03-04
file: by_date/stock_30min/2010/2010-03-04.parquet size: 1.3 MB rows: 72,396 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-04 07:00:00 | AAPL | Stock | 7.4836 | 7.4839 | 7.4836 | 7.4836 | 53284.0 |
| 2010-03-04 07:30:00 | AAPL | Stock | 7.4836 | 7.4836 | 7.4704 | 7.4711 | 25200.0 |
| 2010-03-04 08:00:00 | AAPL | Stock | 7.475 | 7.4793 | 7.4607 | 7.4693 | 216748.0 |
| 2010-03-04 08:30:00 | AAPL | Stock | 7.475 | 7.4839 | 7.4693 | 7.4839 | 851760.0 |
| 2010-03-04 09:00:00 | AAPL | Stock | 7.4839 | 7.4882 | 7.4739 | 7.4779 | 461076.0 |
| 2010-03-04 09:30:00 | AAPL | Stock | 7.4761 | 7.5329 | 7.4511 | 7.525 | 72160760.0 |
| 2010-03-04 10:00:00 | AAPL | Stock | 7.525 | 7.5264 | 7.4811 | 7.5032 | 49173096.0 |
| 2010-03-04 10:30:00 | AAPL | Stock | 7.5043 | 7.505 | 7.4661 | 7.4893 | 33591096.0 |
| 2010-03-04 11:00:00 | AAPL | Stock | 7.4907 | 7.5125 | 7.4875 | 7.5054 | 23164512.0 |
| 2010-03-04 11:30:00 | AAPL | Stock | 7.5054 | 7.5164 | 7.4929 | 7.5118 | 15989176.0 |
| 2010-03-04 12:00:00 | AAPL | Stock | 7.5118 | 7.515 | 7.4986 | 7.5068 | 13946632.0 |
| 2010-03-04 12:30:00 | AAPL | Stock | 7.5075 | 7.5132 | 7.5 | 7.5036 | 9923620.0 |
| 2010-03-04 13:00:00 | AAPL | Stock | 7.5043 | 7.5143 | 7.5018 | 7.506 | 12189240.0 |
| 2010-03-04 13:30:00 | AAPL | Stock | 7.5056 | 7.5057 | 7.4929 | 7.4982 | 13091736.0 |
| 2010-03-04 14:00:00 | AAPL | Stock | 7.4984 | 7.5139 | 7.4971 | 7.5099 | 15739528.0 |
| 2010-03-04 14:30:00 | AAPL | Stock | 7.5107 | 7.5282 | 7.5079 | 7.5229 | 26636904.0 |
| 2010-03-04 15:00:00 | AAPL | Stock | 7.5225 | 7.5243 | 7.5018 | 7.5168 | 20162576.0 |
| 2010-03-04 15:30:00 | AAPL | Stock | 7.5179 | 7.5311 | 7.5129 | 7.5268 | 37498692.0 |
| 2010-03-04 16:00:00 | AAPL | Stock | 7.5254 | 7.5314 | 7.4694 | 7.5279 | 9068276.0 |
| 2010-03-04 16:30:00 | AAPL | Stock | 7.5097 | 7.5279 | 7.5097 | 7.5268 | 123396.0 |
| 2010-03-04 17:00:00 | AAPL | Stock | 7.5268 | 7.5286 | 7.5257 | 7.5275 | 149744.0 |
| 2010-03-04 17:30:00 | AAPL | Stock | 7.53 | 7.5304 | 7.5282 | 7.5304 | 146412.0 |
| 2010-03-04 18:00:00 | AAPL | Stock | 7.5304 | 7.6214 | 7.5304 | 7.6066 | 5595520.0 |
| 2010-03-04 18:30:00 | AAPL | Stock | 7.6054 | 7.6071 | 7.5932 | 7.5964 | 811104.0 |
| 2010-03-04 19:00:00 | AAPL | Stock | 7.5946 | 7.6032 | 7.5946 | 7.6018 | 520772.0 |
| 2010-03-04 19:30:00 | AAPL | Stock | 7.6004 | 7.6036 | 7.5982 | 7.6 | 536956.0 |
| 2010-03-04 08:00:00 | MSFT | Stock | 28.57 | 28.58 | 28.5 | 28.58 | 4110.0 |
| 2010-03-04 08:30:00 | MSFT | Stock | 28.58 | 28.59 | 28.55 | 28.55 | 8906.0 |
| 2010-03-04 09:00:00 | MSFT | Stock | 28.55 | 28.55 | 28.47 | 28.48 | 7020.0 |
| 2010-03-04 09:30:00 | MSFT | Stock | 28.48 | 28.49 | 28.27 | 28.4 | 5633838.0 |
| 2010-03-04 10:00:00 | MSFT | Stock | 28.39 | 28.49 | 28.35 | 28.48 | 3045192.0 |
| 2010-03-04 10:30:00 | MSFT | Stock | 28.48 | 28.49 | 28.34 | 28.41 | 3061896.0 |
| 2010-03-04 11:00:00 | MSFT | Stock | 28.41 | 28.45 | 28.37 | 28.44 | 3593698.0 |
| 2010-03-04 11:30:00 | MSFT | Stock | 28.445 | 28.45 | 28.38 | 28.428 | 2000043.0 |
| 2010-03-04 12:00:00 | MSFT | Stock | 28.43 | 28.44 | 28.39 | 28.415 | 1911940.0 |
| 2010-03-04 12:30:00 | MSFT | Stock | 28.42 | 28.49 | 28.405 | 28.46 | 2380259.0 |
| 2010-03-04 13:00:00 | MSFT | Stock | 28.461 | 28.52 | 28.44 | 28.48 | 1822042.0 |
| 2010-03-04 13:30:00 | MSFT | Stock | 28.48 | 28.48 | 28.39 | 28.47 | 1598494.0 |
| 2010-03-04 14:00:00 | MSFT | Stock | 28.46 | 28.57 | 28.44 | 28.56 | 2616632.0 |
| 2010-03-04 14:30:00 | MSFT | Stock | 28.57 | 28.6 | 28.53 | 28.534 | 2164562.0 |
| 2010-03-04 15:00:00 | MSFT | Stock | 28.532 | 28.58 | 28.47 | 28.575 | 2121240.0 |
| 2010-03-04 15:30:00 | MSFT | Stock | 28.58 | 28.65 | 28.54 | 28.63 | 5618710.0 |
| 2010-03-04 16:00:00 | MSFT | Stock | 28.63 | 28.63 | 28.42 | 28.63 | 3815825.0 |
| 2010-03-04 16:30:00 | MSFT | Stock | 28.516 | 28.65 | 28.477 | 28.59 | 48784.0 |
| 2010-03-04 17:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.6 | 28.6 | 500.0 |
| 2010-03-04 17:30:00 | MSFT | Stock | 28.59 | 28.59 | 28.57 | 28.57 | 461.0 |
| 2010-03-04 18:00:00 | MSFT | Stock | 28.57 | 28.63 | 28.5 | 28.57 | 2366.0 |
| 2010-03-04 19:00:00 | MSFT | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 300.0 |
| 2010-03-04 19:30:00 | MSFT | Stock | 28.56 | 28.62 | 28.56 | 28.56 | 3000.0 |
| 2010-03-04 08:00:00 | NVDA | Stock | 0.42 | 0.4213 | 0.42 | 0.4213 | 88520.0 |
> showing 50 of 72,396 rows — these rows as CSV