PREVIEW / stock_30min / 2006-11-29
file: by_date/stock_30min/2006/2006-11-29.parquet size: 978 KB rows: 52,342 symbols: 2,460
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-29 07:00:00 | AAPL | Stock | 3.3021 | 3.3214 | 3.3021 | 3.3171 | 501200.0 |
| 2006-11-29 07:30:00 | AAPL | Stock | 3.3211 | 3.3536 | 3.3164 | 3.3357 | 2579080.0 |
| 2006-11-29 08:00:00 | AAPL | Stock | 3.3339 | 3.3357 | 3.3164 | 3.3236 | 5375216.0 |
| 2006-11-29 08:30:00 | AAPL | Stock | 3.3243 | 3.335 | 3.3243 | 3.3346 | 3661000.0 |
| 2006-11-29 09:00:00 | AAPL | Stock | 3.335 | 3.3357 | 3.3196 | 3.3221 | 5042884.0 |
| 2006-11-29 09:30:00 | AAPL | Stock | 3.3214 | 3.3268 | 3.295 | 3.2996 | 136602340.0 |
| 2006-11-29 10:00:00 | AAPL | Stock | 3.2999 | 3.3175 | 3.2893 | 3.3129 | 121985836.0 |
| 2006-11-29 10:30:00 | AAPL | Stock | 3.3132 | 3.3161 | 3.2804 | 3.2943 | 104339228.0 |
| 2006-11-29 11:00:00 | AAPL | Stock | 3.2936 | 3.3011 | 3.2829 | 3.2861 | 64044540.0 |
| 2006-11-29 11:30:00 | AAPL | Stock | 3.2861 | 3.2871 | 3.2582 | 3.2593 | 102187372.0 |
| 2006-11-29 12:00:00 | AAPL | Stock | 3.2593 | 3.2729 | 3.2461 | 3.2521 | 75090484.0 |
| 2006-11-29 12:30:00 | AAPL | Stock | 3.2521 | 3.2771 | 3.2514 | 3.2696 | 52647896.0 |
| 2006-11-29 13:00:00 | AAPL | Stock | 3.2693 | 3.2696 | 3.2393 | 3.245 | 66164420.0 |
| 2006-11-29 13:30:00 | AAPL | Stock | 3.2453 | 3.2857 | 3.2232 | 3.2396 | 92519056.0 |
| 2006-11-29 14:00:00 | AAPL | Stock | 3.2393 | 3.2475 | 3.2289 | 3.2371 | 46582928.0 |
| 2006-11-29 14:30:00 | AAPL | Stock | 3.2369 | 3.2857 | 3.2354 | 3.2746 | 84211904.0 |
| 2006-11-29 15:00:00 | AAPL | Stock | 3.2729 | 3.2957 | 3.2725 | 3.2814 | 89725076.0 |
| 2006-11-29 15:30:00 | AAPL | Stock | 3.2811 | 3.2929 | 3.275 | 3.2786 | 87446744.0 |
| 2006-11-29 16:00:00 | AAPL | Stock | 3.2768 | 3.2807 | 3.2714 | 3.2786 | 3457020.0 |
| 2006-11-29 16:30:00 | AAPL | Stock | 3.2804 | 3.2818 | 3.2786 | 3.2818 | 586348.0 |
| 2006-11-29 17:00:00 | AAPL | Stock | 3.2818 | 3.2854 | 3.2818 | 3.2821 | 555156.0 |
| 2006-11-29 17:30:00 | AAPL | Stock | 3.2821 | 3.2836 | 3.2821 | 3.2825 | 226716.0 |
| 2006-11-29 18:00:00 | AAPL | Stock | 3.2814 | 3.2829 | 3.2786 | 3.2786 | 152460.0 |
| 2006-11-29 18:30:00 | AAPL | Stock | 3.2818 | 3.2818 | 3.2786 | 3.2786 | 73780.0 |
| 2006-11-29 19:00:00 | AAPL | Stock | 3.2814 | 3.2821 | 3.2786 | 3.2786 | 680736.0 |
| 2006-11-29 19:30:00 | AAPL | Stock | 3.2786 | 3.2811 | 3.2786 | 3.2811 | 136640.0 |
| 2006-11-29 07:30:00 | MSFT | Stock | 29.46 | 29.47 | 29.46 | 29.47 | 900.0 |
| 2006-11-29 08:00:00 | MSFT | Stock | 29.4 | 29.45 | 29.4 | 29.4 | 35650.0 |
| 2006-11-29 08:30:00 | MSFT | Stock | 29.44 | 29.52 | 29.42 | 29.48 | 43314.0 |
| 2006-11-29 09:00:00 | MSFT | Stock | 29.5 | 29.54 | 29.4 | 29.44 | 294783.0 |
| 2006-11-29 09:30:00 | MSFT | Stock | 29.44 | 29.55 | 29.43 | 29.55 | 6219067.0 |
| 2006-11-29 10:00:00 | MSFT | Stock | 29.54 | 29.69 | 29.49 | 29.65 | 6479686.0 |
| 2006-11-29 10:30:00 | MSFT | Stock | 29.65 | 29.66 | 29.53 | 29.59 | 4616456.0 |
| 2006-11-29 11:00:00 | MSFT | Stock | 29.6 | 29.7 | 29.59 | 29.637 | 3644759.0 |
| 2006-11-29 11:30:00 | MSFT | Stock | 29.64 | 29.7 | 29.59 | 29.679 | 2801542.0 |
| 2006-11-29 12:00:00 | MSFT | Stock | 29.67 | 29.69 | 29.62 | 29.63 | 2601531.0 |
| 2006-11-29 12:30:00 | MSFT | Stock | 29.63 | 29.66 | 29.59 | 29.6 | 1563069.0 |
| 2006-11-29 13:00:00 | MSFT | Stock | 29.61 | 29.61 | 29.49 | 29.517 | 4700991.0 |
| 2006-11-29 13:30:00 | MSFT | Stock | 29.51 | 29.56 | 29.46 | 29.55 | 2535394.0 |
| 2006-11-29 14:00:00 | MSFT | Stock | 29.54 | 29.55 | 29.51 | 29.51 | 2418219.0 |
| 2006-11-29 14:30:00 | MSFT | Stock | 29.518 | 29.6 | 29.518 | 29.58 | 4309113.0 |
| 2006-11-29 15:00:00 | MSFT | Stock | 29.57 | 29.78 | 29.54 | 29.59 | 3516775.0 |
| 2006-11-29 15:30:00 | MSFT | Stock | 29.6 | 29.63 | 29.5 | 29.58 | 4327219.0 |
| 2006-11-29 16:00:00 | MSFT | Stock | 29.58 | 29.6 | 29.56 | 29.58 | 2401083.0 |
| 2006-11-29 16:30:00 | MSFT | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 10500.0 |
| 2006-11-29 17:30:00 | MSFT | Stock | 29.59 | 29.59 | 29.59 | 29.59 | 100.0 |
| 2006-11-29 18:00:00 | MSFT | Stock | 29.59 | 29.59 | 29.569 | 29.569 | 691.0 |
| 2006-11-29 18:30:00 | MSFT | Stock | 29.59 | 29.59 | 29.59 | 29.59 | 200.0 |
| 2006-11-29 19:00:00 | MSFT | Stock | 29.6 | 29.6 | 29.59 | 29.59 | 1640.0 |
| 2006-11-29 19:30:00 | MSFT | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 200.0 |
> showing 50 of 52,342 rows — these rows as CSV