PREVIEW / stock_30min / 2023-10-13
file: by_date/stock_30min/2023/2023-10-13.parquet size: 2.0 MB rows: 96,410 symbols: 1,361
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-13 04:00:00 | AAPL | Stock | 181.05 | 181.12 | 181.0 | 181.0 | 2420.0 |
| 2023-10-13 04:30:00 | AAPL | Stock | 180.93 | 180.93 | 180.65 | 180.8 | 8784.0 |
| 2023-10-13 05:00:00 | AAPL | Stock | 180.73 | 180.73 | 180.52 | 180.71 | 6197.0 |
| 2023-10-13 05:30:00 | AAPL | Stock | 180.71 | 180.71 | 180.22 | 180.22 | 8851.0 |
| 2023-10-13 06:00:00 | AAPL | Stock | 180.32 | 180.32 | 180.04 | 180.09 | 10510.0 |
| 2023-10-13 06:30:00 | AAPL | Stock | 180.1 | 180.37 | 180.08 | 180.25 | 5664.0 |
| 2023-10-13 07:00:00 | AAPL | Stock | 180.35 | 180.45 | 180.25 | 180.29 | 9262.0 |
| 2023-10-13 07:30:00 | AAPL | Stock | 180.31 | 180.35 | 180.11 | 180.25 | 17663.0 |
| 2023-10-13 08:00:00 | AAPL | Stock | 180.1512 | 181.23 | 180.1 | 180.31 | 45481.0 |
| 2023-10-13 08:30:00 | AAPL | Stock | 180.36 | 181.09 | 180.35 | 181.05 | 52417.0 |
| 2023-10-13 09:00:00 | AAPL | Stock | 181.03 | 181.44 | 180.92 | 181.39 | 86148.0 |
| 2023-10-13 09:30:00 | AAPL | Stock | 181.39 | 181.93 | 180.93 | 181.17 | 4203983.0 |
| 2023-10-13 10:00:00 | AAPL | Stock | 181.15 | 181.26 | 180.36 | 180.53 | 2788890.0 |
| 2023-10-13 10:30:00 | AAPL | Stock | 180.52 | 180.765 | 179.3701 | 179.625 | 2680714.0 |
| 2023-10-13 11:00:00 | AAPL | Stock | 179.62 | 179.69 | 178.95 | 179.19 | 2665773.0 |
| 2023-10-13 11:30:00 | AAPL | Stock | 179.19 | 179.3625 | 178.47 | 178.61 | 2424208.0 |
| 2023-10-13 12:00:00 | AAPL | Stock | 178.6 | 179.27 | 178.5301 | 179.255 | 1930936.0 |
| 2023-10-13 12:30:00 | AAPL | Stock | 179.26 | 179.47 | 178.84 | 179.06 | 1657352.0 |
| 2023-10-13 13:00:00 | AAPL | Stock | 179.06 | 179.105 | 178.22 | 178.26 | 2217693.0 |
| 2023-10-13 13:30:00 | AAPL | Stock | 178.261 | 179.02 | 178.14 | 178.82 | 2402796.0 |
| 2023-10-13 14:00:00 | AAPL | Stock | 178.82 | 179.31 | 178.69 | 179.24 | 2097346.0 |
| 2023-10-13 14:30:00 | AAPL | Stock | 179.245 | 179.54 | 178.9688 | 179.3399 | 2367813.0 |
| 2023-10-13 15:00:00 | AAPL | Stock | 179.33 | 179.74 | 178.85 | 178.935 | 2392596.0 |
| 2023-10-13 15:30:00 | AAPL | Stock | 178.94 | 179.09 | 178.52 | 178.87 | 4697071.0 |
| 2023-10-13 16:00:00 | AAPL | Stock | 178.88 | 178.9 | 178.6 | 178.65 | 6197233.0 |
| 2023-10-13 16:30:00 | AAPL | Stock | 178.68 | 178.85 | 178.55 | 178.65 | 49769.0 |
| 2023-10-13 17:00:00 | AAPL | Stock | 178.6502 | 178.85 | 178.6 | 178.63 | 80793.0 |
| 2023-10-13 17:30:00 | AAPL | Stock | 178.61 | 178.65 | 178.54 | 178.57 | 6241.0 |
| 2023-10-13 18:00:00 | AAPL | Stock | 178.58 | 178.65 | 178.5367 | 178.56 | 4636.0 |
| 2023-10-13 18:30:00 | AAPL | Stock | 178.57 | 178.64 | 178.57 | 178.64 | 7471.0 |
| 2023-10-13 19:00:00 | AAPL | Stock | 178.64 | 178.64 | 178.52 | 178.52 | 3385.0 |
| 2023-10-13 19:30:00 | AAPL | Stock | 178.53 | 178.54 | 178.4 | 178.41 | 7632.0 |
| 2023-10-13 04:00:00 | MSFT | Stock | 331.8 | 331.8 | 331.5 | 331.5 | 800.0 |
| 2023-10-13 04:30:00 | MSFT | Stock | 331.37 | 331.37 | 331.03 | 331.03 | 604.0 |
| 2023-10-13 05:00:00 | MSFT | Stock | 330.77 | 330.77 | 330.01 | 330.05 | 748.0 |
| 2023-10-13 05:30:00 | MSFT | Stock | 330.06 | 330.07 | 328.88 | 328.88 | 3062.0 |
| 2023-10-13 06:00:00 | MSFT | Stock | 329.29 | 329.6 | 329.29 | 329.4 | 2880.0 |
| 2023-10-13 06:30:00 | MSFT | Stock | 329.41 | 329.41 | 329.41 | 329.41 | 132.0 |
| 2023-10-13 07:00:00 | MSFT | Stock | 329.7 | 329.86 | 329.51 | 329.81 | 2669.0 |
| 2023-10-13 07:30:00 | MSFT | Stock | 329.85 | 330.04 | 329.85 | 330.04 | 649.0 |
| 2023-10-13 08:00:00 | MSFT | Stock | 329.77 | 331.52 | 329.48 | 330.01 | 13945.0 |
| 2023-10-13 08:30:00 | MSFT | Stock | 330.01 | 331.5 | 330.01 | 331.28 | 11675.0 |
| 2023-10-13 09:00:00 | MSFT | Stock | 331.441 | 332.72 | 331.0 | 332.47 | 25626.0 |
| 2023-10-13 09:30:00 | MSFT | Stock | 332.41 | 333.83 | 331.53 | 333.49 | 1829683.0 |
| 2023-10-13 10:00:00 | MSFT | Stock | 333.53 | 333.75 | 331.115 | 331.575 | 1183460.0 |
| 2023-10-13 10:30:00 | MSFT | Stock | 331.56 | 332.24 | 330.12 | 330.19 | 966382.0 |
| 2023-10-13 11:00:00 | MSFT | Stock | 330.15 | 330.4 | 328.38 | 328.67 | 1088199.0 |
| 2023-10-13 11:30:00 | MSFT | Stock | 328.66 | 329.12 | 327.6 | 327.86 | 593900.0 |
| 2023-10-13 12:00:00 | MSFT | Stock | 327.86 | 328.0 | 327.1 | 327.95 | 759493.0 |
| 2023-10-13 12:30:00 | MSFT | Stock | 327.945 | 328.78 | 327.91 | 328.245 | 432885.0 |
> showing 50 of 96,410 rows — these rows as CSV