PREVIEW / stock_30min / 2024-02-02
file: by_date/stock_30min/2024/2024-02-02.parquet size: 2.0 MB rows: 98,302 symbols: 1,160
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-02 04:00:00 | AAPL | Stock | 182.4 | 183.01 | 182.02 | 182.22 | 78672.0 |
| 2024-02-02 04:30:00 | AAPL | Stock | 182.36 | 182.5 | 182.22 | 182.44 | 14611.0 |
| 2024-02-02 05:00:00 | AAPL | Stock | 182.4 | 182.4 | 181.8 | 182.07 | 26606.0 |
| 2024-02-02 05:30:00 | AAPL | Stock | 182.03 | 182.2 | 181.26 | 181.4 | 42098.0 |
| 2024-02-02 06:00:00 | AAPL | Stock | 181.39 | 182.04 | 181.38 | 181.87 | 43635.0 |
| 2024-02-02 06:30:00 | AAPL | Stock | 181.94 | 182.6 | 181.94 | 182.5 | 99763.0 |
| 2024-02-02 07:00:00 | AAPL | Stock | 182.31 | 182.5 | 181.16 | 181.85 | 130376.0 |
| 2024-02-02 07:30:00 | AAPL | Stock | 181.85 | 182.0 | 180.75 | 180.8 | 176985.0 |
| 2024-02-02 08:00:00 | AAPL | Stock | 182.0 | 183.0 | 180.6 | 180.8 | 531239.0 |
| 2024-02-02 08:30:00 | AAPL | Stock | 180.87 | 181.37 | 179.8 | 180.19 | 672997.0 |
| 2024-02-02 09:00:00 | AAPL | Stock | 180.19 | 181.11 | 179.5 | 179.88 | 602120.0 |
| 2024-02-02 09:30:00 | AAPL | Stock | 179.87 | 183.72 | 179.25 | 182.48 | 17282464.0 |
| 2024-02-02 10:00:00 | AAPL | Stock | 182.502 | 184.17 | 182.44 | 183.315 | 7018158.0 |
| 2024-02-02 10:30:00 | AAPL | Stock | 183.33 | 185.94 | 183.16 | 185.665 | 6268702.0 |
| 2024-02-02 11:00:00 | AAPL | Stock | 185.67 | 187.33 | 185.13 | 187.0 | 6626323.0 |
| 2024-02-02 11:30:00 | AAPL | Stock | 187.01 | 187.1 | 185.83 | 186.33 | 4455001.0 |
| 2024-02-02 12:00:00 | AAPL | Stock | 186.335 | 187.1 | 186.18 | 187.0209 | 3118696.0 |
| 2024-02-02 12:30:00 | AAPL | Stock | 187.03 | 187.12 | 185.12 | 185.275 | 3934733.0 |
| 2024-02-02 13:00:00 | AAPL | Stock | 185.275 | 186.16 | 184.854 | 186.035 | 3195951.0 |
| 2024-02-02 13:30:00 | AAPL | Stock | 186.04 | 186.24 | 185.66 | 185.915 | 2139767.0 |
| 2024-02-02 14:00:00 | AAPL | Stock | 185.93 | 186.14 | 185.59 | 186.08 | 2023157.0 |
| 2024-02-02 14:30:00 | AAPL | Stock | 186.09 | 187.02 | 186.08 | 186.9803 | 2596610.0 |
| 2024-02-02 15:00:00 | AAPL | Stock | 186.99 | 187.07 | 186.45 | 186.73 | 3502009.0 |
| 2024-02-02 15:30:00 | AAPL | Stock | 186.735 | 186.89 | 185.83 | 185.84 | 6576937.0 |
| 2024-02-02 16:00:00 | AAPL | Stock | 185.84 | 185.88 | 185.26 | 185.55 | 9347038.0 |
| 2024-02-02 16:30:00 | AAPL | Stock | 185.54 | 185.85 | 185.2 | 185.33 | 121642.0 |
| 2024-02-02 17:00:00 | AAPL | Stock | 185.2524 | 185.4 | 185.2 | 185.2 | 38291.0 |
| 2024-02-02 17:30:00 | AAPL | Stock | 185.2 | 185.36 | 185.09 | 185.36 | 40044.0 |
| 2024-02-02 18:00:00 | AAPL | Stock | 185.37 | 185.5 | 185.33 | 185.46 | 20253.0 |
| 2024-02-02 18:30:00 | AAPL | Stock | 185.42 | 185.46 | 185.21 | 185.25 | 8393.0 |
| 2024-02-02 19:00:00 | AAPL | Stock | 185.25 | 185.32 | 185.11 | 185.14 | 6593.0 |
| 2024-02-02 19:30:00 | AAPL | Stock | 185.12 | 185.31 | 185.06 | 185.11 | 14493.0 |
| 2024-02-02 04:00:00 | MSFT | Stock | 407.7 | 408.1 | 407.29 | 407.35 | 9655.0 |
| 2024-02-02 04:30:00 | MSFT | Stock | 407.35 | 407.43 | 407.01 | 407.43 | 4331.0 |
| 2024-02-02 05:00:00 | MSFT | Stock | 407.6 | 407.89 | 407.52 | 407.89 | 2678.0 |
| 2024-02-02 05:30:00 | MSFT | Stock | 407.89 | 408.32 | 407.86 | 408.08 | 2891.0 |
| 2024-02-02 06:00:00 | MSFT | Stock | 408.01 | 408.2 | 408.0 | 408.05 | 3568.0 |
| 2024-02-02 06:30:00 | MSFT | Stock | 408.11 | 408.11 | 407.95 | 408.0 | 2051.0 |
| 2024-02-02 07:00:00 | MSFT | Stock | 408.09 | 408.25 | 407.55 | 407.9 | 21854.0 |
| 2024-02-02 07:30:00 | MSFT | Stock | 407.87 | 408.2 | 407.85 | 408.2 | 13365.0 |
| 2024-02-02 08:00:00 | MSFT | Stock | 408.0 | 410.92 | 407.52 | 408.74 | 72757.0 |
| 2024-02-02 08:30:00 | MSFT | Stock | 408.52 | 408.52 | 405.0 | 405.36 | 100341.0 |
| 2024-02-02 09:00:00 | MSFT | Stock | 405.6 | 407.3 | 403.39 | 403.72 | 99192.0 |
| 2024-02-02 09:30:00 | MSFT | Stock | 403.93 | 409.6 | 403.56 | 407.66 | 3319347.0 |
| 2024-02-02 10:00:00 | MSFT | Stock | 407.54 | 409.95 | 407.52 | 408.0718 | 1773288.0 |
| 2024-02-02 10:30:00 | MSFT | Stock | 408.09 | 409.1821 | 406.84 | 408.035 | 1233049.0 |
| 2024-02-02 11:00:00 | MSFT | Stock | 408.06 | 408.63 | 407.32 | 407.97 | 812038.0 |
| 2024-02-02 11:30:00 | MSFT | Stock | 407.945 | 410.31 | 407.945 | 409.8215 | 1318937.0 |
| 2024-02-02 12:00:00 | MSFT | Stock | 409.83 | 411.2317 | 409.64 | 411.17 | 925844.0 |
| 2024-02-02 12:30:00 | MSFT | Stock | 411.19 | 411.745 | 409.94 | 411.645 | 1193617.0 |
> showing 50 of 98,302 rows — these rows as CSV