PREVIEW / stock_30min / 2004-08-26
file: by_date/stock_30min/2004/2004-08-26.parquet size: 725 KB rows: 40,088 symbols: 1,822
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-26 08:30:00 | AAPL | Stock | 0.5893 | 0.5902 | 0.5893 | 0.5902 | 11200.0 |
| 2004-08-26 09:00:00 | AAPL | Stock | 0.5902 | 0.5909 | 0.5902 | 0.5909 | 868000.0 |
| 2004-08-26 09:30:00 | AAPL | Stock | 0.5921 | 0.5945 | 0.5846 | 0.5934 | 72207520.0 |
| 2004-08-26 10:00:00 | AAPL | Stock | 0.593 | 0.6063 | 0.592 | 0.6037 | 90003760.0 |
| 2004-08-26 10:30:00 | AAPL | Stock | 0.6036 | 0.6048 | 0.6 | 0.6048 | 42548296.0 |
| 2004-08-26 11:00:00 | AAPL | Stock | 0.6048 | 0.6116 | 0.6046 | 0.6095 | 100444344.0 |
| 2004-08-26 11:30:00 | AAPL | Stock | 0.6093 | 0.6186 | 0.6082 | 0.6173 | 83072864.0 |
| 2004-08-26 12:00:00 | AAPL | Stock | 0.6175 | 0.6243 | 0.6141 | 0.623 | 98468832.0 |
| 2004-08-26 12:30:00 | AAPL | Stock | 0.6229 | 0.6282 | 0.6221 | 0.6229 | 109844392.0 |
| 2004-08-26 13:00:00 | AAPL | Stock | 0.6229 | 0.623 | 0.6164 | 0.6184 | 52330544.0 |
| 2004-08-26 13:30:00 | AAPL | Stock | 0.6184 | 0.6213 | 0.6171 | 0.6207 | 32465608.0 |
| 2004-08-26 14:00:00 | AAPL | Stock | 0.6207 | 0.6223 | 0.6163 | 0.6214 | 67966080.0 |
| 2004-08-26 14:30:00 | AAPL | Stock | 0.6214 | 0.6216 | 0.6186 | 0.6202 | 38262336.0 |
| 2004-08-26 15:00:00 | AAPL | Stock | 0.6202 | 0.6248 | 0.6198 | 0.6245 | 49769776.0 |
| 2004-08-26 15:30:00 | AAPL | Stock | 0.6245 | 0.6246 | 0.6189 | 0.6195 | 85517320.0 |
| 2004-08-26 16:00:00 | AAPL | Stock | 0.6196 | 0.6196 | 0.6179 | 0.6179 | 4256896.0 |
| 2004-08-26 16:30:00 | AAPL | Stock | 0.6179 | 0.6189 | 0.6179 | 0.6184 | 3346728.0 |
| 2004-08-26 17:00:00 | AAPL | Stock | 0.6186 | 0.6186 | 0.6186 | 0.6186 | 5600.0 |
| 2004-08-26 17:30:00 | AAPL | Stock | 0.6188 | 0.6189 | 0.6188 | 0.6189 | 119280.0 |
| 2004-08-26 18:00:00 | AAPL | Stock | 0.6189 | 0.6189 | 0.6186 | 0.6189 | 134400.0 |
| 2004-08-26 08:30:00 | MSFT | Stock | 27.5 | 27.55 | 27.46 | 27.46 | 2400.0 |
| 2004-08-26 09:00:00 | MSFT | Stock | 27.5 | 27.55 | 27.45 | 27.45 | 104200.0 |
| 2004-08-26 09:30:00 | MSFT | Stock | 27.46 | 27.6 | 27.44 | 27.55 | 3796167.0 |
| 2004-08-26 10:00:00 | MSFT | Stock | 27.55 | 27.6 | 27.5 | 27.52 | 3482701.0 |
| 2004-08-26 10:30:00 | MSFT | Stock | 27.52 | 27.53 | 27.42 | 27.47 | 3962168.0 |
| 2004-08-26 11:00:00 | MSFT | Stock | 27.47 | 27.55 | 27.46 | 27.52 | 2410758.0 |
| 2004-08-26 11:30:00 | MSFT | Stock | 27.5224 | 27.53 | 27.46 | 27.48 | 1603054.0 |
| 2004-08-26 12:00:00 | MSFT | Stock | 27.5 | 27.58 | 27.49 | 27.56 | 1294389.0 |
| 2004-08-26 12:30:00 | MSFT | Stock | 27.55 | 27.56 | 27.51 | 27.51 | 1071252.0 |
| 2004-08-26 13:00:00 | MSFT | Stock | 27.51 | 27.52 | 27.47 | 27.48 | 1193769.0 |
| 2004-08-26 13:30:00 | MSFT | Stock | 27.48 | 27.52 | 27.41 | 27.469 | 1833544.0 |
| 2004-08-26 14:00:00 | MSFT | Stock | 27.47 | 27.54 | 27.41 | 27.53 | 2838557.0 |
| 2004-08-26 14:30:00 | MSFT | Stock | 27.52 | 27.53 | 27.47 | 27.48 | 1499908.0 |
| 2004-08-26 15:00:00 | MSFT | Stock | 27.47 | 27.56 | 27.45 | 27.54 | 2867553.0 |
| 2004-08-26 15:30:00 | MSFT | Stock | 27.54 | 27.58 | 27.43 | 27.45 | 5337212.0 |
| 2004-08-26 16:00:00 | MSFT | Stock | 27.45 | 27.509 | 27.35 | 27.41 | 708841.0 |
| 2004-08-26 16:30:00 | MSFT | Stock | 27.42 | 27.55 | 27.38 | 27.54 | 137846.0 |
| 2004-08-26 17:00:00 | MSFT | Stock | 27.53 | 27.55 | 27.47 | 27.55 | 28144.0 |
| 2004-08-26 17:30:00 | MSFT | Stock | 27.4739 | 27.4739 | 27.4739 | 27.4739 | 1000.0 |
| 2004-08-26 18:00:00 | MSFT | Stock | 27.55 | 27.55 | 27.51 | 27.51 | 3500.0 |
| 2004-08-26 08:00:00 | NVDA | Stock | 0.1061 | 0.1061 | 0.1047 | 0.1047 | 228000.0 |
| 2004-08-26 08:30:00 | NVDA | Stock | 0.1047 | 0.1053 | 0.1046 | 0.1053 | 120000.0 |
| 2004-08-26 09:00:00 | NVDA | Stock | 0.105 | 0.1053 | 0.105 | 0.1053 | 396000.0 |
| 2004-08-26 09:30:00 | NVDA | Stock | 0.1052 | 0.1058 | 0.1046 | 0.1056 | 91351920.0 |
| 2004-08-26 10:00:00 | NVDA | Stock | 0.1055 | 0.1065 | 0.1053 | 0.1059 | 90663960.0 |
| 2004-08-26 10:30:00 | NVDA | Stock | 0.1061 | 0.1061 | 0.1047 | 0.105 | 47834880.0 |
| 2004-08-26 11:00:00 | NVDA | Stock | 0.105 | 0.1062 | 0.105 | 0.1057 | 39748440.0 |
| 2004-08-26 11:30:00 | NVDA | Stock | 0.1058 | 0.1061 | 0.1053 | 0.1054 | 22625160.0 |
| 2004-08-26 12:00:00 | NVDA | Stock | 0.1054 | 0.1058 | 0.1052 | 0.1058 | 18978840.0 |
| 2004-08-26 12:30:00 | NVDA | Stock | 0.1057 | 0.1058 | 0.1055 | 0.1056 | 16821840.0 |
> showing 50 of 40,088 rows — these rows as CSV