PREVIEW / stock_30min / 2008-12-04
file: by_date/stock_30min/2008/2008-12-04.parquet size: 1.2 MB rows: 67,947 symbols: 3,337
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-04 05:00:00 | AAPL | Stock | 3.4257 | 3.4257 | 3.4257 | 3.4257 | 5600.0 |
| 2008-12-04 05:30:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 2800.0 |
| 2008-12-04 06:00:00 | AAPL | Stock | 3.45 | 3.4529 | 3.45 | 3.4529 | 16800.0 |
| 2008-12-04 07:00:00 | AAPL | Stock | 3.425 | 3.425 | 3.425 | 3.425 | 5600.0 |
| 2008-12-04 07:30:00 | AAPL | Stock | 3.4225 | 3.4232 | 3.4036 | 3.4143 | 146580.0 |
| 2008-12-04 08:00:00 | AAPL | Stock | 3.4111 | 3.4111 | 3.375 | 3.3857 | 2123800.0 |
| 2008-12-04 08:30:00 | AAPL | Stock | 3.385 | 3.4032 | 3.3804 | 3.3861 | 1428392.0 |
| 2008-12-04 09:00:00 | AAPL | Stock | 3.3854 | 3.3871 | 3.3661 | 3.3714 | 2957500.0 |
| 2008-12-04 09:30:00 | AAPL | Stock | 3.3714 | 3.4004 | 3.3125 | 3.3714 | 164663016.0 |
| 2008-12-04 10:00:00 | AAPL | Stock | 3.3711 | 3.3911 | 3.3036 | 3.315 | 107497516.0 |
| 2008-12-04 10:30:00 | AAPL | Stock | 3.3161 | 3.3818 | 3.3039 | 3.3793 | 101928288.0 |
| 2008-12-04 11:00:00 | AAPL | Stock | 3.3793 | 3.3871 | 3.3411 | 3.3579 | 69903512.0 |
| 2008-12-04 11:30:00 | AAPL | Stock | 3.3582 | 3.3582 | 3.3129 | 3.3257 | 56899192.0 |
| 2008-12-04 12:00:00 | AAPL | Stock | 3.3257 | 3.3296 | 3.2954 | 3.3086 | 45519236.0 |
| 2008-12-04 12:30:00 | AAPL | Stock | 3.3089 | 3.3525 | 3.3036 | 3.3379 | 45412556.0 |
| 2008-12-04 13:00:00 | AAPL | Stock | 3.3386 | 3.3386 | 3.2925 | 3.2929 | 43132796.0 |
| 2008-12-04 13:30:00 | AAPL | Stock | 3.2925 | 3.3314 | 3.2889 | 3.3146 | 41856836.0 |
| 2008-12-04 14:00:00 | AAPL | Stock | 3.3146 | 3.3336 | 3.2936 | 3.2979 | 54040056.0 |
| 2008-12-04 14:30:00 | AAPL | Stock | 3.2975 | 3.3229 | 3.2768 | 3.2807 | 57285508.0 |
| 2008-12-04 15:00:00 | AAPL | Stock | 3.2807 | 3.2882 | 3.1964 | 3.2004 | 116838596.0 |
| 2008-12-04 15:30:00 | AAPL | Stock | 3.1993 | 3.2675 | 3.1807 | 3.2675 | 150638264.0 |
| 2008-12-04 16:00:00 | AAPL | Stock | 3.2579 | 3.3331 | 3.2262 | 3.2643 | 20764716.0 |
| 2008-12-04 16:30:00 | AAPL | Stock | 3.2621 | 3.2646 | 3.2579 | 3.2582 | 3304308.0 |
| 2008-12-04 17:00:00 | AAPL | Stock | 3.2582 | 3.2607 | 3.2536 | 3.2536 | 73220.0 |
| 2008-12-04 17:30:00 | AAPL | Stock | 3.2518 | 3.2586 | 3.2518 | 3.2536 | 43960.0 |
| 2008-12-04 18:00:00 | AAPL | Stock | 3.2536 | 3.2568 | 3.2521 | 3.2521 | 40600.0 |
| 2008-12-04 18:30:00 | AAPL | Stock | 3.2586 | 3.2596 | 3.2514 | 3.2521 | 111776.0 |
| 2008-12-04 19:00:00 | AAPL | Stock | 3.2554 | 3.2557 | 3.2457 | 3.2457 | 105868.0 |
| 2008-12-04 19:30:00 | AAPL | Stock | 3.2496 | 3.2589 | 3.2446 | 3.2536 | 84532.0 |
| 2008-12-04 08:00:00 | MSFT | Stock | 19.65 | 19.65 | 19.5 | 19.5 | 9900.0 |
| 2008-12-04 08:30:00 | MSFT | Stock | 19.45 | 19.56 | 19.45 | 19.5 | 2402.0 |
| 2008-12-04 09:00:00 | MSFT | Stock | 19.53 | 19.53 | 19.32 | 19.4 | 73442.0 |
| 2008-12-04 09:30:00 | MSFT | Stock | 19.4 | 19.92 | 19.36 | 19.6 | 6781746.0 |
| 2008-12-04 10:00:00 | MSFT | Stock | 19.61 | 19.77 | 19.52 | 19.59 | 5978893.0 |
| 2008-12-04 10:30:00 | MSFT | Stock | 19.59 | 19.88 | 19.58 | 19.86 | 5175828.0 |
| 2008-12-04 11:00:00 | MSFT | Stock | 19.85 | 19.87 | 19.64 | 19.84 | 3677707.0 |
| 2008-12-04 11:30:00 | MSFT | Stock | 19.83 | 19.84 | 19.55 | 19.58 | 3676172.0 |
| 2008-12-04 12:00:00 | MSFT | Stock | 19.58 | 19.6 | 19.4 | 19.48 | 3130871.0 |
| 2008-12-04 12:30:00 | MSFT | Stock | 19.48 | 19.59 | 19.45 | 19.53 | 2429458.0 |
| 2008-12-04 13:00:00 | MSFT | Stock | 19.53 | 19.56 | 19.39 | 19.39 | 2390845.0 |
| 2008-12-04 13:30:00 | MSFT | Stock | 19.39 | 19.59 | 19.37 | 19.5 | 3166955.0 |
| 2008-12-04 14:00:00 | MSFT | Stock | 19.5 | 19.56 | 19.42 | 19.455 | 3075053.0 |
| 2008-12-04 14:30:00 | MSFT | Stock | 19.46 | 19.64 | 19.36 | 19.36 | 3902206.0 |
| 2008-12-04 15:00:00 | MSFT | Stock | 19.36 | 19.4 | 18.79 | 18.83 | 9490515.0 |
| 2008-12-04 15:30:00 | MSFT | Stock | 18.82 | 19.19 | 18.79 | 19.11 | 16208137.0 |
| 2008-12-04 16:00:00 | MSFT | Stock | 19.11 | 19.79 | 19.027 | 19.13 | 6819484.0 |
| 2008-12-04 16:30:00 | MSFT | Stock | 19.766 | 19.766 | 19.11 | 19.16 | 1303374.0 |
| 2008-12-04 17:00:00 | MSFT | Stock | 19.16 | 19.382 | 19.08 | 19.09 | 28636.0 |
| 2008-12-04 17:30:00 | MSFT | Stock | 19.06 | 19.07 | 19.0 | 19.02 | 10820.0 |
| 2008-12-04 18:00:00 | MSFT | Stock | 19.07 | 19.07 | 19.0 | 19.07 | 7200.0 |
> showing 50 of 67,947 rows — these rows as CSV