PREVIEW / stock_30min / 2008-05-09
file: by_date/stock_30min/2008/2008-05-09.parquet size: 1.2 MB rows: 68,061 symbols: 3,271
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-05-09 07:00:00 | AAPL | Stock | 6.5661 | 6.5857 | 6.5661 | 6.5857 | 11200.0 |
| 2008-05-09 07:30:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.5571 | 6.5571 | 99400.0 |
| 2008-05-09 08:00:00 | AAPL | Stock | 6.5561 | 6.5714 | 6.5529 | 6.5607 | 1526252.0 |
| 2008-05-09 08:30:00 | AAPL | Stock | 6.5589 | 6.5804 | 6.5589 | 6.5729 | 2467864.0 |
| 2008-05-09 09:00:00 | AAPL | Stock | 6.5732 | 6.575 | 6.5357 | 6.5361 | 2409596.0 |
| 2008-05-09 09:30:00 | AAPL | Stock | 6.5379 | 6.5714 | 6.5325 | 6.5507 | 101418856.0 |
| 2008-05-09 10:00:00 | AAPL | Stock | 6.5507 | 6.5804 | 6.5471 | 6.5507 | 65473940.0 |
| 2008-05-09 10:30:00 | AAPL | Stock | 6.5511 | 6.5779 | 6.525 | 6.55 | 81006156.0 |
| 2008-05-09 11:00:00 | AAPL | Stock | 6.55 | 6.5554 | 6.5332 | 6.5396 | 40812184.0 |
| 2008-05-09 11:30:00 | AAPL | Stock | 6.54 | 6.5429 | 6.5054 | 6.5207 | 42421876.0 |
| 2008-05-09 12:00:00 | AAPL | Stock | 6.5204 | 6.5221 | 6.4775 | 6.4911 | 44366168.0 |
| 2008-05-09 12:30:00 | AAPL | Stock | 6.4911 | 6.5211 | 6.4886 | 6.5179 | 34437844.0 |
| 2008-05-09 13:00:00 | AAPL | Stock | 6.5179 | 6.5221 | 6.4968 | 6.5043 | 31932292.0 |
| 2008-05-09 13:30:00 | AAPL | Stock | 6.5043 | 6.5232 | 6.4875 | 6.5186 | 33831140.0 |
| 2008-05-09 14:00:00 | AAPL | Stock | 6.5182 | 6.5346 | 6.5096 | 6.5132 | 34760796.0 |
| 2008-05-09 14:30:00 | AAPL | Stock | 6.5139 | 6.5321 | 6.5114 | 6.5229 | 28897064.0 |
| 2008-05-09 15:00:00 | AAPL | Stock | 6.5232 | 6.5532 | 6.5125 | 6.5461 | 45690204.0 |
| 2008-05-09 15:30:00 | AAPL | Stock | 6.5454 | 6.5579 | 6.5318 | 6.5468 | 64842624.0 |
| 2008-05-09 16:00:00 | AAPL | Stock | 6.5489 | 6.5568 | 6.5004 | 6.5464 | 5113108.0 |
| 2008-05-09 16:30:00 | AAPL | Stock | 6.5518 | 6.5536 | 6.5446 | 6.5529 | 256928.0 |
| 2008-05-09 17:00:00 | AAPL | Stock | 6.5507 | 6.5625 | 6.5482 | 6.5571 | 309792.0 |
| 2008-05-09 17:30:00 | AAPL | Stock | 6.5571 | 6.5586 | 6.5543 | 6.5571 | 90160.0 |
| 2008-05-09 18:00:00 | AAPL | Stock | 6.5546 | 6.5554 | 6.5507 | 6.5536 | 62580.0 |
| 2008-05-09 18:30:00 | AAPL | Stock | 6.5532 | 6.5571 | 6.5532 | 6.5571 | 116620.0 |
| 2008-05-09 19:00:00 | AAPL | Stock | 6.5554 | 6.5568 | 6.5554 | 6.5568 | 16520.0 |
| 2008-05-09 19:30:00 | AAPL | Stock | 6.5564 | 6.5564 | 6.5525 | 6.5546 | 165200.0 |
| 2008-05-09 06:30:00 | MSFT | Stock | 29.25 | 29.25 | 29.25 | 29.25 | 100.0 |
| 2008-05-09 08:00:00 | MSFT | Stock | 29.2 | 29.2 | 29.04 | 29.04 | 9635.0 |
| 2008-05-09 08:30:00 | MSFT | Stock | 29.08 | 29.15 | 29.04 | 29.08 | 8990.0 |
| 2008-05-09 09:00:00 | MSFT | Stock | 29.07 | 29.2 | 29.07 | 29.15 | 112921.0 |
| 2008-05-09 09:30:00 | MSFT | Stock | 29.18 | 29.21 | 28.95 | 29.12 | 6988621.0 |
| 2008-05-09 10:00:00 | MSFT | Stock | 29.12 | 29.25 | 29.1 | 29.21 | 5346026.0 |
| 2008-05-09 10:30:00 | MSFT | Stock | 29.21 | 29.55 | 29.2 | 29.44 | 6088431.0 |
| 2008-05-09 11:00:00 | MSFT | Stock | 29.45 | 29.52 | 29.39 | 29.47 | 3882497.0 |
| 2008-05-09 11:30:00 | MSFT | Stock | 29.47 | 29.5 | 29.35 | 29.43 | 3897536.0 |
| 2008-05-09 12:00:00 | MSFT | Stock | 29.43 | 29.46 | 29.39 | 29.42 | 2517995.0 |
| 2008-05-09 12:30:00 | MSFT | Stock | 29.42 | 29.48 | 29.418 | 29.43 | 1578062.0 |
| 2008-05-09 13:00:00 | MSFT | Stock | 29.43 | 29.44 | 29.27 | 29.27 | 2170357.0 |
| 2008-05-09 13:30:00 | MSFT | Stock | 29.28 | 29.39 | 29.24 | 29.36 | 1711349.0 |
| 2008-05-09 14:00:00 | MSFT | Stock | 29.361 | 29.4 | 29.31 | 29.37 | 2437504.0 |
| 2008-05-09 14:30:00 | MSFT | Stock | 29.37 | 29.39 | 29.34 | 29.37 | 2857025.0 |
| 2008-05-09 15:00:00 | MSFT | Stock | 29.36 | 29.43 | 29.32 | 29.43 | 3762273.0 |
| 2008-05-09 15:30:00 | MSFT | Stock | 29.43 | 29.44 | 29.34 | 29.39 | 5928610.0 |
| 2008-05-09 16:00:00 | MSFT | Stock | 29.39 | 29.47 | 29.31 | 29.33 | 903396.0 |
| 2008-05-09 16:30:00 | MSFT | Stock | 29.39 | 29.39 | 29.32 | 29.37 | 8446.0 |
| 2008-05-09 17:00:00 | MSFT | Stock | 29.35 | 29.37 | 29.3 | 29.35 | 15654.0 |
| 2008-05-09 17:30:00 | MSFT | Stock | 29.108 | 29.38 | 29.108 | 29.37 | 31778.0 |
| 2008-05-09 18:00:00 | MSFT | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 1000.0 |
| 2008-05-09 18:30:00 | MSFT | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 3051.0 |
| 2008-05-09 19:00:00 | MSFT | Stock | 29.37 | 29.37 | 29.37 | 29.37 | 740.0 |
> showing 50 of 68,061 rows — these rows as CSV