PREVIEW / stock_30min / 2008-02-28
file: by_date/stock_30min/2008/2008-02-28.parquet size: 1.2 MB rows: 68,381 symbols: 3,262
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-28 04:00:00 | AAPL | Stock | 4.5586 | 4.5586 | 4.5539 | 4.5539 | 5600.0 |
| 2008-02-28 04:30:00 | AAPL | Stock | 4.5486 | 4.5486 | 4.5486 | 4.5486 | 5600.0 |
| 2008-02-28 05:30:00 | AAPL | Stock | 4.5468 | 4.5468 | 4.5296 | 4.5296 | 8400.0 |
| 2008-02-28 06:00:00 | AAPL | Stock | 4.5389 | 4.5468 | 4.5321 | 4.5357 | 25200.0 |
| 2008-02-28 06:30:00 | AAPL | Stock | 4.5536 | 4.5536 | 4.5357 | 4.5357 | 49420.0 |
| 2008-02-28 07:00:00 | AAPL | Stock | 4.5357 | 4.5411 | 4.5 | 4.5079 | 2127272.0 |
| 2008-02-28 07:30:00 | AAPL | Stock | 4.5071 | 4.5196 | 4.5018 | 4.5086 | 1403976.0 |
| 2008-02-28 08:00:00 | AAPL | Stock | 4.5082 | 4.5464 | 4.4843 | 4.5179 | 6330324.0 |
| 2008-02-28 08:30:00 | AAPL | Stock | 4.5157 | 4.5389 | 4.5036 | 4.535 | 9067520.0 |
| 2008-02-28 09:00:00 | AAPL | Stock | 4.5343 | 4.5475 | 4.5232 | 4.5432 | 11829440.0 |
| 2008-02-28 09:30:00 | AAPL | Stock | 4.5432 | 4.5864 | 4.4918 | 4.5675 | 282878176.0 |
| 2008-02-28 10:00:00 | AAPL | Stock | 4.5671 | 4.5839 | 4.5404 | 4.5829 | 140094780.0 |
| 2008-02-28 10:30:00 | AAPL | Stock | 4.5832 | 4.6146 | 4.5664 | 4.6107 | 131336660.0 |
| 2008-02-28 11:00:00 | AAPL | Stock | 4.61 | 4.6107 | 4.5754 | 4.5875 | 106911420.0 |
| 2008-02-28 11:30:00 | AAPL | Stock | 4.5879 | 4.6093 | 4.5714 | 4.6089 | 71502872.0 |
| 2008-02-28 12:00:00 | AAPL | Stock | 4.609 | 4.625 | 4.5975 | 4.6214 | 66982160.0 |
| 2008-02-28 12:30:00 | AAPL | Stock | 4.6225 | 4.6421 | 4.6214 | 4.6304 | 79298632.0 |
| 2008-02-28 13:00:00 | AAPL | Stock | 4.6304 | 4.6396 | 4.6179 | 4.6221 | 55123264.0 |
| 2008-02-28 13:30:00 | AAPL | Stock | 4.6221 | 4.6389 | 4.6096 | 4.6386 | 61787656.0 |
| 2008-02-28 14:00:00 | AAPL | Stock | 4.6382 | 4.6679 | 4.6289 | 4.6639 | 97057548.0 |
| 2008-02-28 14:30:00 | AAPL | Stock | 4.6643 | 4.7143 | 4.6589 | 4.7136 | 152740420.0 |
| 2008-02-28 15:00:00 | AAPL | Stock | 4.7139 | 4.7214 | 4.6682 | 4.6829 | 169589728.0 |
| 2008-02-28 15:30:00 | AAPL | Stock | 4.6829 | 4.6839 | 4.6346 | 4.6421 | 147498904.0 |
| 2008-02-28 16:00:00 | AAPL | Stock | 4.6393 | 4.6396 | 4.6025 | 4.625 | 19470360.0 |
| 2008-02-28 16:30:00 | AAPL | Stock | 4.6396 | 4.6469 | 4.6179 | 4.6268 | 1870092.0 |
| 2008-02-28 17:00:00 | AAPL | Stock | 4.6307 | 4.6357 | 4.6268 | 4.6357 | 1078000.0 |
| 2008-02-28 17:30:00 | AAPL | Stock | 4.6357 | 4.6496 | 4.6321 | 4.6429 | 596260.0 |
| 2008-02-28 18:00:00 | AAPL | Stock | 4.6429 | 4.6479 | 4.6321 | 4.6321 | 423276.0 |
| 2008-02-28 18:30:00 | AAPL | Stock | 4.6321 | 4.6382 | 4.6254 | 4.6289 | 118720.0 |
| 2008-02-28 19:00:00 | AAPL | Stock | 4.6314 | 4.6321 | 4.6232 | 4.6271 | 297136.0 |
| 2008-02-28 19:30:00 | AAPL | Stock | 4.6314 | 4.6321 | 4.6161 | 4.6214 | 769496.0 |
| 2008-02-28 08:00:00 | MSFT | Stock | 28.26 | 28.26 | 28.24 | 28.25 | 1068.0 |
| 2008-02-28 08:30:00 | MSFT | Stock | 28.2 | 28.2 | 28.15 | 28.16 | 8050.0 |
| 2008-02-28 09:00:00 | MSFT | Stock | 28.17 | 28.17 | 28.02 | 28.02 | 133683.0 |
| 2008-02-28 09:30:00 | MSFT | Stock | 28.02 | 28.12 | 27.96 | 28.0 | 8338899.0 |
| 2008-02-28 10:00:00 | MSFT | Stock | 28.0 | 28.23 | 27.98 | 28.218 | 9251315.0 |
| 2008-02-28 10:30:00 | MSFT | Stock | 28.21 | 28.27 | 28.1 | 28.19 | 5773577.0 |
| 2008-02-28 11:00:00 | MSFT | Stock | 28.19 | 28.2 | 28.01 | 28.04 | 5067501.0 |
| 2008-02-28 11:30:00 | MSFT | Stock | 28.04 | 28.05 | 27.97 | 28.01 | 5386362.0 |
| 2008-02-28 12:00:00 | MSFT | Stock | 28.003 | 28.02 | 27.93 | 27.98 | 2417828.0 |
| 2008-02-28 12:30:00 | MSFT | Stock | 27.99 | 28.07 | 27.97 | 28.0 | 2407631.0 |
| 2008-02-28 13:00:00 | MSFT | Stock | 28.0 | 28.03 | 27.94 | 27.94 | 3234172.0 |
| 2008-02-28 13:30:00 | MSFT | Stock | 27.94 | 28.05 | 27.94 | 28.02 | 4110001.0 |
| 2008-02-28 14:00:00 | MSFT | Stock | 28.03 | 28.07 | 27.97 | 28.0 | 6639418.0 |
| 2008-02-28 14:30:00 | MSFT | Stock | 27.99 | 28.01 | 27.9 | 27.91 | 5298408.0 |
| 2008-02-28 15:00:00 | MSFT | Stock | 27.905 | 27.92 | 27.8 | 27.88 | 9152266.0 |
| 2008-02-28 15:30:00 | MSFT | Stock | 27.87 | 27.95 | 27.83 | 27.92 | 11223606.0 |
| 2008-02-28 16:00:00 | MSFT | Stock | 27.91 | 28.007 | 27.7 | 27.93 | 3965793.0 |
| 2008-02-28 16:30:00 | MSFT | Stock | 27.89 | 27.96 | 27.78 | 27.96 | 553744.0 |
| 2008-02-28 17:00:00 | MSFT | Stock | 27.82 | 27.94 | 27.82 | 27.92 | 29093.0 |
> showing 50 of 68,381 rows — these rows as CSV