PREVIEW / stock_30min / 2005-06-14
file: by_date/stock_30min/2005/2005-06-14.parquet size: 831 KB rows: 45,195 symbols: 1,993
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-14 08:00:00 | AAPL | Stock | 1.2825 | 1.2846 | 1.2825 | 1.2846 | 84028.0 |
| 2005-06-14 08:30:00 | AAPL | Stock | 1.285 | 1.2936 | 1.285 | 1.29 | 361732.0 |
| 2005-06-14 09:00:00 | AAPL | Stock | 1.29 | 1.2911 | 1.2857 | 1.2861 | 548352.0 |
| 2005-06-14 09:30:00 | AAPL | Stock | 1.2829 | 1.2911 | 1.2775 | 1.2843 | 70733600.0 |
| 2005-06-14 10:00:00 | AAPL | Stock | 1.2846 | 1.2893 | 1.2768 | 1.2804 | 36817984.0 |
| 2005-06-14 10:30:00 | AAPL | Stock | 1.2804 | 1.2854 | 1.2768 | 1.2825 | 20792352.0 |
| 2005-06-14 11:00:00 | AAPL | Stock | 1.2825 | 1.2875 | 1.2818 | 1.2821 | 15793484.0 |
| 2005-06-14 11:30:00 | AAPL | Stock | 1.2818 | 1.2843 | 1.2807 | 1.2839 | 13055028.0 |
| 2005-06-14 12:00:00 | AAPL | Stock | 1.2836 | 1.2854 | 1.2818 | 1.2829 | 10799684.0 |
| 2005-06-14 12:30:00 | AAPL | Stock | 1.2832 | 1.2875 | 1.2821 | 1.2857 | 13956012.0 |
| 2005-06-14 13:00:00 | AAPL | Stock | 1.2857 | 1.2857 | 1.2793 | 1.2821 | 17076668.0 |
| 2005-06-14 13:30:00 | AAPL | Stock | 1.2821 | 1.2861 | 1.2786 | 1.2861 | 24046428.0 |
| 2005-06-14 14:00:00 | AAPL | Stock | 1.2861 | 1.2893 | 1.2821 | 1.2821 | 31044272.0 |
| 2005-06-14 14:30:00 | AAPL | Stock | 1.2818 | 1.2839 | 1.2796 | 1.2836 | 13980148.0 |
| 2005-06-14 15:00:00 | AAPL | Stock | 1.2832 | 1.2861 | 1.2825 | 1.2825 | 29245272.0 |
| 2005-06-14 15:30:00 | AAPL | Stock | 1.2829 | 1.2864 | 1.2811 | 1.285 | 40402236.0 |
| 2005-06-14 16:00:00 | AAPL | Stock | 1.2854 | 1.2861 | 1.2821 | 1.2854 | 1308720.0 |
| 2005-06-14 16:30:00 | AAPL | Stock | 1.2857 | 1.2893 | 1.2857 | 1.2875 | 685608.0 |
| 2005-06-14 17:00:00 | AAPL | Stock | 1.2875 | 1.2875 | 1.2875 | 1.2875 | 85400.0 |
| 2005-06-14 17:30:00 | AAPL | Stock | 1.2875 | 1.2875 | 1.2837 | 1.2857 | 1605912.0 |
| 2005-06-14 18:00:00 | AAPL | Stock | 1.2875 | 1.3068 | 1.2875 | 1.3029 | 3223444.0 |
| 2005-06-14 07:30:00 | MSFT | Stock | 25.31 | 25.31 | 25.31 | 25.31 | 2200.0 |
| 2005-06-14 08:00:00 | MSFT | Stock | 25.33 | 25.35 | 25.32 | 25.32 | 6500.0 |
| 2005-06-14 08:30:00 | MSFT | Stock | 25.34 | 25.38 | 25.34 | 25.37 | 20398.0 |
| 2005-06-14 09:00:00 | MSFT | Stock | 25.36 | 25.37 | 25.28 | 25.28 | 182471.0 |
| 2005-06-14 09:30:00 | MSFT | Stock | 25.31 | 25.44 | 25.268 | 25.41 | 7215774.0 |
| 2005-06-14 10:00:00 | MSFT | Stock | 25.41 | 25.42 | 25.34 | 25.35 | 3869042.0 |
| 2005-06-14 10:30:00 | MSFT | Stock | 25.36 | 25.4 | 25.29 | 25.33 | 3753510.0 |
| 2005-06-14 11:00:00 | MSFT | Stock | 25.34 | 25.41 | 25.31 | 25.31 | 2235197.0 |
| 2005-06-14 11:30:00 | MSFT | Stock | 25.32 | 25.35 | 25.29 | 25.31 | 2972720.0 |
| 2005-06-14 12:00:00 | MSFT | Stock | 25.31 | 25.32 | 25.24 | 25.27 | 3136236.0 |
| 2005-06-14 12:30:00 | MSFT | Stock | 25.27 | 25.31 | 25.26 | 25.31 | 1460675.0 |
| 2005-06-14 13:00:00 | MSFT | Stock | 25.31 | 25.31 | 25.25 | 25.31 | 1904609.0 |
| 2005-06-14 13:30:00 | MSFT | Stock | 25.31 | 25.39 | 25.3 | 25.39 | 3200871.0 |
| 2005-06-14 14:00:00 | MSFT | Stock | 25.39 | 25.4 | 25.27 | 25.3 | 2915739.0 |
| 2005-06-14 14:30:00 | MSFT | Stock | 25.29 | 25.31 | 25.25 | 25.29 | 3663639.0 |
| 2005-06-14 15:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.28 | 25.31 | 1829906.0 |
| 2005-06-14 15:30:00 | MSFT | Stock | 25.32 | 25.37 | 25.27 | 25.37 | 4658800.0 |
| 2005-06-14 16:00:00 | MSFT | Stock | 25.36 | 25.4 | 25.35 | 25.38 | 296899.0 |
| 2005-06-14 16:30:00 | MSFT | Stock | 25.37 | 25.37 | 25.36 | 25.37 | 16042.0 |
| 2005-06-14 17:00:00 | MSFT | Stock | 25.37 | 25.37 | 25.37 | 25.37 | 3110.0 |
| 2005-06-14 17:30:00 | MSFT | Stock | 25.316 | 25.37 | 25.307 | 25.36 | 876495.0 |
| 2005-06-14 18:00:00 | MSFT | Stock | 25.36 | 25.36 | 25.321 | 25.321 | 3210.0 |
| 2005-06-14 08:30:00 | NVDA | Stock | 0.2383 | 0.2392 | 0.2382 | 0.2392 | 288000.0 |
| 2005-06-14 09:00:00 | NVDA | Stock | 0.2384 | 0.2384 | 0.2381 | 0.2381 | 446880.0 |
| 2005-06-14 09:30:00 | NVDA | Stock | 0.2384 | 0.2423 | 0.238 | 0.242 | 104422920.0 |
| 2005-06-14 10:00:00 | NVDA | Stock | 0.242 | 0.242 | 0.2357 | 0.236 | 96682200.0 |
| 2005-06-14 10:30:00 | NVDA | Stock | 0.236 | 0.2364 | 0.2328 | 0.2332 | 141428280.0 |
| 2005-06-14 11:00:00 | NVDA | Stock | 0.2332 | 0.2337 | 0.2296 | 0.231 | 194865480.0 |
| 2005-06-14 11:30:00 | NVDA | Stock | 0.231 | 0.2318 | 0.2262 | 0.2262 | 174647520.0 |
> showing 50 of 45,195 rows — these rows as CSV