PREVIEW / stock_30min / 2006-05-01
file: by_date/stock_30min/2006/2006-05-01.parquet size: 942 KB rows: 50,381 symbols: 2,246
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-05-01 08:00:00 | AAPL | Stock | 2.5179 | 2.5314 | 2.5179 | 2.5271 | 568008.0 |
| 2006-05-01 08:30:00 | AAPL | Stock | 2.5282 | 2.5293 | 2.5107 | 2.5107 | 2468620.0 |
| 2006-05-01 09:00:00 | AAPL | Stock | 2.5214 | 2.5293 | 2.5139 | 2.5271 | 1609076.0 |
| 2006-05-01 09:30:00 | AAPL | Stock | 2.5275 | 2.5536 | 2.5221 | 2.5368 | 88388804.0 |
| 2006-05-01 10:00:00 | AAPL | Stock | 2.5368 | 2.5464 | 2.5268 | 2.5396 | 75322744.0 |
| 2006-05-01 10:30:00 | AAPL | Stock | 2.5396 | 2.555 | 2.5389 | 2.5457 | 94005828.0 |
| 2006-05-01 11:00:00 | AAPL | Stock | 2.5457 | 2.5496 | 2.5407 | 2.5471 | 35881020.0 |
| 2006-05-01 11:30:00 | AAPL | Stock | 2.5471 | 2.5496 | 2.5414 | 2.5429 | 22510376.0 |
| 2006-05-01 12:00:00 | AAPL | Stock | 2.5429 | 2.5439 | 2.5311 | 2.5339 | 34824972.0 |
| 2006-05-01 12:30:00 | AAPL | Stock | 2.5343 | 2.5421 | 2.5286 | 2.5411 | 28263116.0 |
| 2006-05-01 13:00:00 | AAPL | Stock | 2.5418 | 2.5425 | 2.5364 | 2.5382 | 16077292.0 |
| 2006-05-01 13:30:00 | AAPL | Stock | 2.5382 | 2.54 | 2.5321 | 2.5343 | 19769316.0 |
| 2006-05-01 14:00:00 | AAPL | Stock | 2.5343 | 2.5364 | 2.5279 | 2.5304 | 50907500.0 |
| 2006-05-01 14:30:00 | AAPL | Stock | 2.5307 | 2.5404 | 2.5293 | 2.5357 | 23661120.0 |
| 2006-05-01 15:00:00 | AAPL | Stock | 2.5354 | 2.5389 | 2.5089 | 2.5096 | 76852216.0 |
| 2006-05-01 15:30:00 | AAPL | Stock | 2.5093 | 2.51 | 2.47 | 2.4886 | 161027972.0 |
| 2006-05-01 16:00:00 | AAPL | Stock | 2.4857 | 2.4911 | 2.4843 | 2.4893 | 1272852.0 |
| 2006-05-01 16:30:00 | AAPL | Stock | 2.4907 | 2.4911 | 2.4857 | 2.4879 | 380772.0 |
| 2006-05-01 17:00:00 | AAPL | Stock | 2.4875 | 2.4909 | 2.4875 | 2.4886 | 1596896.0 |
| 2006-05-01 17:30:00 | AAPL | Stock | 2.4882 | 2.4903 | 2.4857 | 2.4903 | 371028.0 |
| 2006-05-01 18:00:00 | AAPL | Stock | 2.4857 | 2.49 | 2.4857 | 2.4893 | 212660.0 |
| 2006-05-01 07:00:00 | MSFT | Stock | 24.22 | 24.27 | 24.17 | 24.17 | 2300.0 |
| 2006-05-01 07:30:00 | MSFT | Stock | 24.17 | 24.22 | 24.17 | 24.19 | 2900.0 |
| 2006-05-01 08:00:00 | MSFT | Stock | 24.2 | 24.23 | 24.17 | 24.21 | 245711.0 |
| 2006-05-01 08:30:00 | MSFT | Stock | 24.21 | 24.28 | 24.061 | 24.25 | 1151813.0 |
| 2006-05-01 09:00:00 | MSFT | Stock | 24.24 | 24.34 | 24.15 | 24.32 | 734756.0 |
| 2006-05-01 09:30:00 | MSFT | Stock | 24.32 | 25.0 | 24.09 | 24.3 | 20713300.0 |
| 2006-05-01 10:00:00 | MSFT | Stock | 24.31 | 24.38 | 24.25 | 24.33 | 15809563.0 |
| 2006-05-01 10:30:00 | MSFT | Stock | 24.32 | 24.5 | 24.32 | 24.41 | 13440581.0 |
| 2006-05-01 11:00:00 | MSFT | Stock | 24.408 | 24.46 | 24.15 | 24.46 | 18490310.0 |
| 2006-05-01 11:30:00 | MSFT | Stock | 24.45 | 24.5 | 24.42 | 24.44 | 12039882.0 |
| 2006-05-01 12:00:00 | MSFT | Stock | 24.45 | 24.48 | 24.36 | 24.36 | 7739903.0 |
| 2006-05-01 12:30:00 | MSFT | Stock | 24.36 | 24.44 | 24.33 | 24.39 | 9437004.0 |
| 2006-05-01 13:00:00 | MSFT | Stock | 24.39 | 24.47 | 24.35 | 24.4 | 11006044.0 |
| 2006-05-01 13:30:00 | MSFT | Stock | 24.39 | 24.47 | 24.35 | 24.36 | 11175686.0 |
| 2006-05-01 14:00:00 | MSFT | Stock | 24.36 | 24.48 | 24.35 | 24.39 | 7613537.0 |
| 2006-05-01 14:30:00 | MSFT | Stock | 24.39 | 24.48 | 24.37 | 24.4 | 5185757.0 |
| 2006-05-01 15:00:00 | MSFT | Stock | 24.4 | 24.48 | 24.3 | 24.36 | 12188132.0 |
| 2006-05-01 15:30:00 | MSFT | Stock | 24.36 | 24.4 | 24.24 | 24.28 | 23872947.0 |
| 2006-05-01 16:00:00 | MSFT | Stock | 24.26 | 24.35 | 24.24 | 24.31 | 885019.0 |
| 2006-05-01 16:30:00 | MSFT | Stock | 24.31 | 24.32 | 24.25 | 24.3 | 40627.0 |
| 2006-05-01 17:00:00 | MSFT | Stock | 24.32 | 24.33 | 24.246 | 24.32 | 144047.0 |
| 2006-05-01 17:30:00 | MSFT | Stock | 24.32 | 24.33 | 24.249 | 24.249 | 57881.0 |
| 2006-05-01 18:00:00 | MSFT | Stock | 24.33 | 24.34 | 24.25 | 24.34 | 211582.0 |
| 2006-05-01 08:00:00 | NVDA | Stock | 0.487 | 0.487 | 0.487 | 0.487 | 162120.0 |
| 2006-05-01 08:30:00 | NVDA | Stock | 0.487 | 0.4917 | 0.4855 | 0.4855 | 4249680.0 |
| 2006-05-01 09:00:00 | NVDA | Stock | 0.489 | 0.4923 | 0.487 | 0.4923 | 1400640.0 |
| 2006-05-01 09:30:00 | NVDA | Stock | 0.4903 | 0.5027 | 0.4903 | 0.4995 | 80948460.0 |
| 2006-05-01 10:00:00 | NVDA | Stock | 0.4995 | 0.5005 | 0.4933 | 0.4967 | 47193720.0 |
| 2006-05-01 10:30:00 | NVDA | Stock | 0.4967 | 0.5017 | 0.4965 | 0.5013 | 25724160.0 |
> showing 50 of 50,381 rows — these rows as CSV