PREVIEW / stock_30min / 2024-03-05
file: by_date/stock_30min/2024/2024-03-05.parquet size: 2.1 MB rows: 101,677 symbols: 1,119
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-03-05 04:00:00 | AAPL | Stock | 173.0 | 173.4 | 172.21 | 172.48 | 34818.0 |
| 2024-03-05 04:30:00 | AAPL | Stock | 172.47 | 172.5 | 172.3 | 172.48 | 16704.0 |
| 2024-03-05 05:00:00 | AAPL | Stock | 172.48 | 172.53 | 172.33 | 172.4 | 10278.0 |
| 2024-03-05 05:30:00 | AAPL | Stock | 172.47 | 172.5 | 172.42 | 172.44 | 8558.0 |
| 2024-03-05 06:00:00 | AAPL | Stock | 172.42 | 172.42 | 172.3 | 172.42 | 5988.0 |
| 2024-03-05 06:30:00 | AAPL | Stock | 172.4 | 172.48 | 171.65 | 171.82 | 49191.0 |
| 2024-03-05 07:00:00 | AAPL | Stock | 171.76 | 172.22 | 171.41 | 171.7 | 113676.0 |
| 2024-03-05 07:30:00 | AAPL | Stock | 171.7 | 171.7 | 171.0 | 171.02 | 152866.0 |
| 2024-03-05 08:00:00 | AAPL | Stock | 172.18 | 174.33 | 170.78 | 171.05 | 544888.0 |
| 2024-03-05 08:30:00 | AAPL | Stock | 171.05 | 171.4 | 171.0 | 171.1765 | 205975.0 |
| 2024-03-05 09:00:00 | AAPL | Stock | 171.2 | 171.5 | 170.49 | 170.8 | 500840.0 |
| 2024-03-05 09:30:00 | AAPL | Stock | 170.76 | 172.04 | 170.07 | 170.485 | 13888191.0 |
| 2024-03-05 10:00:00 | AAPL | Stock | 170.5 | 171.0 | 169.9 | 169.91 | 7373770.0 |
| 2024-03-05 10:30:00 | AAPL | Stock | 169.92 | 170.44 | 169.62 | 170.41 | 6544155.0 |
| 2024-03-05 11:00:00 | AAPL | Stock | 170.41 | 170.82 | 170.0 | 170.42 | 3732883.0 |
| 2024-03-05 11:30:00 | AAPL | Stock | 170.415 | 170.4399 | 169.86 | 170.25 | 3353386.0 |
| 2024-03-05 12:00:00 | AAPL | Stock | 170.2501 | 170.895 | 170.11 | 170.785 | 3070060.0 |
| 2024-03-05 12:30:00 | AAPL | Stock | 170.785 | 170.8287 | 170.235 | 170.2979 | 2555259.0 |
| 2024-03-05 13:00:00 | AAPL | Stock | 170.3 | 170.76 | 170.15 | 170.47 | 2732954.0 |
| 2024-03-05 13:30:00 | AAPL | Stock | 170.46 | 170.475 | 169.95 | 169.985 | 3059660.0 |
| 2024-03-05 14:00:00 | AAPL | Stock | 169.99 | 170.38 | 169.94 | 170.04 | 2968761.0 |
| 2024-03-05 14:30:00 | AAPL | Stock | 170.0499 | 170.14 | 169.79 | 170.045 | 3114419.0 |
| 2024-03-05 15:00:00 | AAPL | Stock | 170.0401 | 170.25 | 169.815 | 169.98 | 3598427.0 |
| 2024-03-05 15:30:00 | AAPL | Stock | 169.98 | 170.22 | 169.8 | 170.17 | 7127126.0 |
| 2024-03-05 16:00:00 | AAPL | Stock | 170.12 | 170.29 | 170.06 | 170.21 | 12106833.0 |
| 2024-03-05 16:30:00 | AAPL | Stock | 170.22 | 170.3599 | 170.0335 | 170.32 | 222307.0 |
| 2024-03-05 17:00:00 | AAPL | Stock | 170.321 | 170.49 | 170.3 | 170.41 | 48186.0 |
| 2024-03-05 17:30:00 | AAPL | Stock | 170.42 | 170.46 | 170.11 | 170.22 | 33010.0 |
| 2024-03-05 18:00:00 | AAPL | Stock | 170.1723 | 170.25 | 170.01 | 170.09 | 30533.0 |
| 2024-03-05 18:30:00 | AAPL | Stock | 170.08 | 170.16 | 169.83 | 169.92 | 35228.0 |
| 2024-03-05 19:00:00 | AAPL | Stock | 169.9 | 170.06 | 169.9 | 170.01 | 14370.0 |
| 2024-03-05 19:30:00 | AAPL | Stock | 170.0 | 170.01 | 169.8 | 169.86 | 39262.0 |
| 2024-03-05 04:00:00 | MSFT | Stock | 412.85 | 412.85 | 411.7 | 412.65 | 4157.0 |
| 2024-03-05 04:30:00 | MSFT | Stock | 413.0 | 413.18 | 412.72 | 412.73 | 3303.0 |
| 2024-03-05 05:00:00 | MSFT | Stock | 412.7 | 412.75 | 412.53 | 412.53 | 1209.0 |
| 2024-03-05 05:30:00 | MSFT | Stock | 412.64 | 412.64 | 412.4 | 412.4 | 644.0 |
| 2024-03-05 06:00:00 | MSFT | Stock | 412.35 | 412.66 | 412.35 | 412.66 | 978.0 |
| 2024-03-05 06:30:00 | MSFT | Stock | 412.8 | 412.87 | 412.75 | 412.87 | 776.0 |
| 2024-03-05 07:00:00 | MSFT | Stock | 412.75 | 414.0 | 412.49 | 414.0 | 18177.0 |
| 2024-03-05 07:30:00 | MSFT | Stock | 413.29 | 414.34 | 413.29 | 413.58 | 8673.0 |
| 2024-03-05 08:00:00 | MSFT | Stock | 412.5 | 414.149 | 412.5 | 412.77 | 21482.0 |
| 2024-03-05 08:30:00 | MSFT | Stock | 412.57 | 412.76 | 412.36 | 412.52 | 5640.0 |
| 2024-03-05 09:00:00 | MSFT | Stock | 412.5 | 414.07 | 412.25 | 414.07 | 25296.0 |
| 2024-03-05 09:30:00 | MSFT | Stock | 414.09 | 414.25 | 406.27 | 407.07 | 2660293.0 |
| 2024-03-05 10:00:00 | MSFT | Stock | 407.07 | 407.46 | 404.67 | 405.25 | 2182453.0 |
| 2024-03-05 10:30:00 | MSFT | Stock | 405.24 | 405.24 | 402.12 | 403.43 | 1645291.0 |
| 2024-03-05 11:00:00 | MSFT | Stock | 403.45 | 405.19 | 403.18 | 404.7 | 875910.0 |
| 2024-03-05 11:30:00 | MSFT | Stock | 404.695 | 404.83 | 402.92 | 404.14 | 737779.0 |
| 2024-03-05 12:00:00 | MSFT | Stock | 404.18 | 404.71 | 403.98 | 404.415 | 483889.0 |
| 2024-03-05 12:30:00 | MSFT | Stock | 404.44 | 404.57 | 403.36 | 403.37 | 412553.0 |
> showing 50 of 101,677 rows — these rows as CSV