PREVIEW / stock_30min / 2008-02-11
file: by_date/stock_30min/2008/2008-02-11.parquet size: 1.2 MB rows: 69,430 symbols: 3,264
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-02-11 06:00:00 | AAPL | Stock | 4.4911 | 4.5 | 4.4911 | 4.5 | 36400.0 |
| 2008-02-11 06:30:00 | AAPL | Stock | 4.5104 | 4.5357 | 4.5043 | 4.5336 | 316400.0 |
| 2008-02-11 07:00:00 | AAPL | Stock | 4.5357 | 4.5536 | 4.5279 | 4.5525 | 175756.0 |
| 2008-02-11 07:30:00 | AAPL | Stock | 4.5436 | 4.5536 | 4.5321 | 4.5357 | 337400.0 |
| 2008-02-11 08:00:00 | AAPL | Stock | 4.5321 | 4.5707 | 4.5282 | 4.5679 | 4391492.0 |
| 2008-02-11 08:30:00 | AAPL | Stock | 4.5679 | 4.5836 | 4.5654 | 4.5821 | 6483708.0 |
| 2008-02-11 09:00:00 | AAPL | Stock | 4.5821 | 4.5871 | 4.5593 | 4.5714 | 7908236.0 |
| 2008-02-11 09:30:00 | AAPL | Stock | 4.5718 | 4.6107 | 4.5486 | 4.5929 | 196543172.0 |
| 2008-02-11 10:00:00 | AAPL | Stock | 4.5932 | 4.605 | 4.5429 | 4.5768 | 118442016.0 |
| 2008-02-11 10:30:00 | AAPL | Stock | 4.5771 | 4.5996 | 4.5629 | 4.5961 | 67319784.0 |
| 2008-02-11 11:00:00 | AAPL | Stock | 4.5961 | 4.6057 | 4.5786 | 4.58 | 59995320.0 |
| 2008-02-11 11:30:00 | AAPL | Stock | 4.5803 | 4.5893 | 4.5571 | 4.5632 | 61916176.0 |
| 2008-02-11 12:00:00 | AAPL | Stock | 4.5629 | 4.5957 | 4.5629 | 4.5796 | 45496388.0 |
| 2008-02-11 12:30:00 | AAPL | Stock | 4.5789 | 4.6071 | 4.5764 | 4.5968 | 60250708.0 |
| 2008-02-11 13:00:00 | AAPL | Stock | 4.5964 | 4.6232 | 4.5964 | 4.6225 | 72363144.0 |
| 2008-02-11 13:30:00 | AAPL | Stock | 4.6225 | 4.627 | 4.6086 | 4.6187 | 54258428.0 |
| 2008-02-11 14:00:00 | AAPL | Stock | 4.6186 | 4.6421 | 4.6129 | 4.6143 | 76265532.0 |
| 2008-02-11 14:30:00 | AAPL | Stock | 4.6136 | 4.6168 | 4.5932 | 4.6029 | 77931756.0 |
| 2008-02-11 15:00:00 | AAPL | Stock | 4.6032 | 4.6357 | 4.5911 | 4.635 | 84006552.0 |
| 2008-02-11 15:30:00 | AAPL | Stock | 4.6346 | 4.6375 | 4.5857 | 4.6232 | 148510684.0 |
| 2008-02-11 16:00:00 | AAPL | Stock | 4.6235 | 4.6329 | 4.5639 | 4.6225 | 54364772.0 |
| 2008-02-11 16:30:00 | AAPL | Stock | 4.6243 | 4.625 | 4.5969 | 4.6207 | 2262064.0 |
| 2008-02-11 17:00:00 | AAPL | Stock | 4.6243 | 4.63 | 4.6243 | 4.625 | 328216.0 |
| 2008-02-11 17:30:00 | AAPL | Stock | 4.5829 | 4.6321 | 4.5589 | 4.6318 | 947828.0 |
| 2008-02-11 18:00:00 | AAPL | Stock | 4.6318 | 4.6318 | 4.625 | 4.6293 | 131236.0 |
| 2008-02-11 18:30:00 | AAPL | Stock | 4.6254 | 4.6282 | 4.625 | 4.6279 | 112840.0 |
| 2008-02-11 19:00:00 | AAPL | Stock | 4.6275 | 4.6279 | 4.6246 | 4.625 | 165228.0 |
| 2008-02-11 19:30:00 | AAPL | Stock | 4.625 | 4.6275 | 4.6232 | 4.625 | 228480.0 |
| 2008-02-11 05:00:00 | MSFT | Stock | 28.84 | 28.84 | 28.84 | 28.84 | 100.0 |
| 2008-02-11 06:00:00 | MSFT | Stock | 28.84 | 28.84 | 28.3 | 28.3 | 1300.0 |
| 2008-02-11 06:30:00 | MSFT | Stock | 28.59 | 28.59 | 28.59 | 28.59 | 100.0 |
| 2008-02-11 07:00:00 | MSFT | Stock | 28.22 | 28.46 | 28.22 | 28.23 | 16188.0 |
| 2008-02-11 07:30:00 | MSFT | Stock | 28.23 | 28.4 | 28.23 | 28.37 | 47200.0 |
| 2008-02-11 08:00:00 | MSFT | Stock | 28.4 | 28.56 | 28.35 | 28.56 | 135341.0 |
| 2008-02-11 08:30:00 | MSFT | Stock | 28.56 | 28.75 | 28.5 | 28.7 | 196176.0 |
| 2008-02-11 09:00:00 | MSFT | Stock | 28.67 | 28.72 | 28.5 | 28.52 | 283748.0 |
| 2008-02-11 09:30:00 | MSFT | Stock | 28.58 | 28.6 | 27.91 | 27.962 | 21062044.0 |
| 2008-02-11 10:00:00 | MSFT | Stock | 27.97 | 28.05 | 27.95 | 28.03 | 13677773.0 |
| 2008-02-11 10:30:00 | MSFT | Stock | 28.02 | 28.12 | 27.96 | 28.11 | 16130760.0 |
| 2008-02-11 11:00:00 | MSFT | Stock | 28.1 | 28.19 | 27.96 | 28.01 | 12061768.0 |
| 2008-02-11 11:30:00 | MSFT | Stock | 28.0 | 28.02 | 27.93 | 27.97 | 9611407.0 |
| 2008-02-11 12:00:00 | MSFT | Stock | 27.98 | 28.06 | 27.97 | 28.039 | 7615428.0 |
| 2008-02-11 12:30:00 | MSFT | Stock | 28.03 | 28.1 | 27.98 | 28.08 | 6971494.0 |
| 2008-02-11 13:00:00 | MSFT | Stock | 28.08 | 28.15 | 28.01 | 28.15 | 10366316.0 |
| 2008-02-11 13:30:00 | MSFT | Stock | 28.15 | 28.17 | 28.08 | 28.13 | 8092066.0 |
| 2008-02-11 14:00:00 | MSFT | Stock | 28.12 | 28.2 | 28.09 | 28.17 | 8303751.0 |
| 2008-02-11 14:30:00 | MSFT | Stock | 28.17 | 28.35 | 28.13 | 28.31 | 9580180.0 |
| 2008-02-11 15:00:00 | MSFT | Stock | 28.31 | 28.34 | 28.05 | 28.26 | 12663702.0 |
| 2008-02-11 15:30:00 | MSFT | Stock | 28.26 | 28.27 | 28.05 | 28.19 | 15285358.0 |
| 2008-02-11 16:00:00 | MSFT | Stock | 28.2 | 28.6 | 28.06 | 28.15 | 4288104.0 |
> showing 50 of 69,430 rows — these rows as CSV