PREVIEW / stock_30min / 2009-03-20
file: by_date/stock_30min/2009/2009-03-20.parquet size: 1.3 MB rows: 70,654 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2009-03-20 07:00:00 | AAPL | Stock | 3.5996 | 3.5996 | 3.5996 | 3.5996 | 2800.0 |
| 2009-03-20 08:00:00 | AAPL | Stock | 3.6079 | 3.6304 | 3.6025 | 3.6179 | 117768.0 |
| 2009-03-20 08:30:00 | AAPL | Stock | 3.6211 | 3.6268 | 3.6179 | 3.6232 | 103656.0 |
| 2009-03-20 09:00:00 | AAPL | Stock | 3.6214 | 3.645 | 3.6196 | 3.6429 | 1629600.0 |
| 2009-03-20 09:30:00 | AAPL | Stock | 3.6429 | 3.6825 | 3.6332 | 3.665 | 84926184.0 |
| 2009-03-20 10:00:00 | AAPL | Stock | 3.6657 | 3.6711 | 3.6418 | 3.6614 | 45261608.0 |
| 2009-03-20 10:30:00 | AAPL | Stock | 3.6614 | 3.6786 | 3.6556 | 3.6757 | 34491660.0 |
| 2009-03-20 11:00:00 | AAPL | Stock | 3.6757 | 3.6764 | 3.6414 | 3.6532 | 35878976.0 |
| 2009-03-20 11:30:00 | AAPL | Stock | 3.6532 | 3.67 | 3.6518 | 3.6657 | 26575948.0 |
| 2009-03-20 12:00:00 | AAPL | Stock | 3.6655 | 3.6721 | 3.6582 | 3.6589 | 21242116.0 |
| 2009-03-20 12:30:00 | AAPL | Stock | 3.6586 | 3.6689 | 3.6168 | 3.6304 | 39436544.0 |
| 2009-03-20 13:00:00 | AAPL | Stock | 3.63 | 3.6386 | 3.6161 | 3.6211 | 27753320.0 |
| 2009-03-20 13:30:00 | AAPL | Stock | 3.6207 | 3.6275 | 3.5954 | 3.6043 | 41335252.0 |
| 2009-03-20 14:00:00 | AAPL | Stock | 3.6046 | 3.6146 | 3.5918 | 3.6114 | 30496452.0 |
| 2009-03-20 14:30:00 | AAPL | Stock | 3.6114 | 3.625 | 3.5979 | 3.6171 | 41602288.0 |
| 2009-03-20 15:00:00 | AAPL | Stock | 3.6168 | 3.6254 | 3.5975 | 3.6057 | 39083324.0 |
| 2009-03-20 15:30:00 | AAPL | Stock | 3.6061 | 3.6268 | 3.6057 | 3.6246 | 78367688.0 |
| 2009-03-20 16:00:00 | AAPL | Stock | 3.6254 | 3.638 | 3.6071 | 3.6283 | 31440864.0 |
| 2009-03-20 16:30:00 | AAPL | Stock | 3.6154 | 3.6436 | 3.6154 | 3.6284 | 2109688.0 |
| 2009-03-20 17:00:00 | AAPL | Stock | 3.6282 | 3.6282 | 3.6282 | 3.6282 | 63112.0 |
| 2009-03-20 17:30:00 | AAPL | Stock | 3.6204 | 3.6204 | 3.6196 | 3.6196 | 145600.0 |
| 2009-03-20 18:00:00 | AAPL | Stock | 3.6161 | 3.6168 | 3.6107 | 3.6107 | 126000.0 |
| 2009-03-20 18:30:00 | AAPL | Stock | 3.6125 | 3.6161 | 3.6125 | 3.6125 | 51016.0 |
| 2009-03-20 19:00:00 | AAPL | Stock | 3.6179 | 3.6214 | 3.6179 | 3.6214 | 36400.0 |
| 2009-03-20 19:30:00 | AAPL | Stock | 3.6179 | 3.6211 | 3.6129 | 3.6211 | 16800.0 |
| 2009-03-20 08:00:00 | MSFT | Stock | 17.1 | 17.15 | 17.03 | 17.12 | 9564.0 |
| 2009-03-20 08:30:00 | MSFT | Stock | 17.15 | 17.15 | 17.15 | 17.15 | 4002.0 |
| 2009-03-20 09:00:00 | MSFT | Stock | 17.15 | 17.35 | 17.15 | 17.3 | 74990.0 |
| 2009-03-20 09:30:00 | MSFT | Stock | 17.3 | 17.65 | 17.26 | 17.464 | 25580031.0 |
| 2009-03-20 10:00:00 | MSFT | Stock | 17.47 | 17.51 | 17.18 | 17.4 | 5778419.0 |
| 2009-03-20 10:30:00 | MSFT | Stock | 17.41 | 17.49 | 17.36 | 17.462 | 3894139.0 |
| 2009-03-20 11:00:00 | MSFT | Stock | 17.46 | 17.475 | 17.31 | 17.34 | 4283785.0 |
| 2009-03-20 11:30:00 | MSFT | Stock | 17.33 | 17.46 | 17.31 | 17.38 | 2719873.0 |
| 2009-03-20 12:00:00 | MSFT | Stock | 17.38 | 17.49 | 17.378 | 17.45 | 2422569.0 |
| 2009-03-20 12:30:00 | MSFT | Stock | 17.45 | 17.5 | 17.26 | 17.309 | 4030665.0 |
| 2009-03-20 13:00:00 | MSFT | Stock | 17.3 | 17.34 | 17.1 | 17.118 | 2784135.0 |
| 2009-03-20 13:30:00 | MSFT | Stock | 17.11 | 17.19 | 16.97 | 17.001 | 3342621.0 |
| 2009-03-20 14:00:00 | MSFT | Stock | 17.0 | 17.5 | 16.96 | 17.02 | 2930306.0 |
| 2009-03-20 14:30:00 | MSFT | Stock | 17.01 | 17.03 | 16.88 | 16.97 | 2749306.0 |
| 2009-03-20 15:00:00 | MSFT | Stock | 16.97 | 17.03 | 16.95 | 17.01 | 3644720.0 |
| 2009-03-20 15:30:00 | MSFT | Stock | 17.015 | 17.11 | 16.98 | 17.04 | 8829259.0 |
| 2009-03-20 16:00:00 | MSFT | Stock | 17.05 | 17.4 | 16.94 | 17.058 | 5679924.0 |
| 2009-03-20 16:30:00 | MSFT | Stock | 17.02 | 17.25 | 16.972 | 17.05 | 352560.0 |
| 2009-03-20 17:00:00 | MSFT | Stock | 17.05 | 17.06 | 17.04 | 17.06 | 4130.0 |
| 2009-03-20 17:30:00 | MSFT | Stock | 17.08 | 17.1 | 17.04 | 17.1 | 6265.0 |
| 2009-03-20 18:00:00 | MSFT | Stock | 17.1 | 17.1 | 17.07 | 17.1 | 16840.0 |
| 2009-03-20 18:30:00 | MSFT | Stock | 17.1 | 17.1 | 17.05 | 17.05 | 4800.0 |
| 2009-03-20 19:00:00 | MSFT | Stock | 17.09 | 17.1 | 17.09 | 17.1 | 1225.0 |
| 2009-03-20 19:30:00 | MSFT | Stock | 17.04 | 17.08 | 17.04 | 17.08 | 285.0 |
| 2009-03-20 08:00:00 | NVDA | Stock | 0.252 | 0.252 | 0.2473 | 0.252 | 48000.0 |
> showing 50 of 70,654 rows — these rows as CSV