PREVIEW / stock_30min / 2013-02-06
file: by_date/stock_30min/2013/2013-02-06.parquet size: 1.4 MB rows: 75,382 symbols: 3,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 |
|---|---|---|---|---|---|---|---|
| 2013-02-06 04:30:00 | AAPL | Stock | 16.3754 | 16.3754 | 16.375 | 16.375 | 5600.0 |
| 2013-02-06 05:00:00 | AAPL | Stock | 16.3307 | 16.3311 | 16.2643 | 16.2643 | 112420.0 |
| 2013-02-06 05:30:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 2800.0 |
| 2013-02-06 06:00:00 | AAPL | Stock | 16.2964 | 16.3536 | 16.2964 | 16.3536 | 47040.0 |
| 2013-02-06 06:30:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3214 | 16.325 | 26656.0 |
| 2013-02-06 07:00:00 | AAPL | Stock | 16.3214 | 16.3461 | 16.2818 | 16.2857 | 267904.0 |
| 2013-02-06 07:30:00 | AAPL | Stock | 16.2896 | 16.3207 | 16.2782 | 16.3021 | 215488.0 |
| 2013-02-06 08:00:00 | AAPL | Stock | 16.2871 | 16.3393 | 16.2039 | 16.2661 | 1935556.0 |
| 2013-02-06 08:30:00 | AAPL | Stock | 16.2625 | 16.3057 | 16.2343 | 16.3057 | 1244236.0 |
| 2013-02-06 09:00:00 | AAPL | Stock | 16.3054 | 16.3189 | 16.2611 | 16.3182 | 1650824.0 |
| 2013-02-06 09:30:00 | AAPL | Stock | 16.3182 | 16.4193 | 16.2375 | 16.2636 | 73060428.0 |
| 2013-02-06 10:00:00 | AAPL | Stock | 16.2627 | 16.2929 | 16.1979 | 16.2343 | 42045136.0 |
| 2013-02-06 10:30:00 | AAPL | Stock | 16.2336 | 16.5679 | 16.1636 | 16.5057 | 104658148.0 |
| 2013-02-06 11:00:00 | AAPL | Stock | 16.5111 | 16.6607 | 16.5057 | 16.5936 | 90009752.0 |
| 2013-02-06 11:30:00 | AAPL | Stock | 16.5893 | 16.6143 | 16.48 | 16.5525 | 42234668.0 |
| 2013-02-06 12:00:00 | AAPL | Stock | 16.5571 | 16.5614 | 16.4554 | 16.5332 | 31921904.0 |
| 2013-02-06 12:30:00 | AAPL | Stock | 16.53 | 16.5518 | 16.38 | 16.4089 | 28611016.0 |
| 2013-02-06 13:00:00 | AAPL | Stock | 16.4029 | 16.408 | 16.3154 | 16.3261 | 34449324.0 |
| 2013-02-06 13:30:00 | AAPL | Stock | 16.3224 | 16.3779 | 16.3039 | 16.3375 | 20682984.0 |
| 2013-02-06 14:00:00 | AAPL | Stock | 16.3361 | 16.4029 | 16.3161 | 16.3614 | 18069772.0 |
| 2013-02-06 14:30:00 | AAPL | Stock | 16.3554 | 16.3986 | 16.3261 | 16.3725 | 16863896.0 |
| 2013-02-06 15:00:00 | AAPL | Stock | 16.3746 | 16.4164 | 16.3261 | 16.3589 | 21117432.0 |
| 2013-02-06 15:30:00 | AAPL | Stock | 16.36 | 16.3611 | 16.3114 | 16.3316 | 33113556.0 |
| 2013-02-06 16:00:00 | AAPL | Stock | 16.3299 | 16.4646 | 16.3221 | 16.3275 | 14376992.0 |
| 2013-02-06 16:30:00 | AAPL | Stock | 16.3275 | 16.4734 | 16.3236 | 16.3389 | 316288.0 |
| 2013-02-06 17:00:00 | AAPL | Stock | 16.3339 | 16.3339 | 16.2925 | 16.2968 | 879480.0 |
| 2013-02-06 17:30:00 | AAPL | Stock | 16.2961 | 16.3068 | 16.2929 | 16.2964 | 427364.0 |
| 2013-02-06 18:00:00 | AAPL | Stock | 16.2946 | 16.3125 | 16.275 | 16.2804 | 411768.0 |
| 2013-02-06 18:30:00 | AAPL | Stock | 16.2857 | 16.2968 | 16.2786 | 16.2857 | 175448.0 |
| 2013-02-06 19:00:00 | AAPL | Stock | 16.2868 | 16.3339 | 16.2861 | 16.3025 | 299796.0 |
| 2013-02-06 19:30:00 | AAPL | Stock | 16.3025 | 16.3118 | 16.2929 | 16.3036 | 274456.0 |
| 2013-02-06 07:00:00 | MSFT | Stock | 27.56 | 27.56 | 27.5 | 27.5 | 400.0 |
| 2013-02-06 08:00:00 | MSFT | Stock | 27.4 | 27.5 | 27.4 | 27.4 | 2040.0 |
| 2013-02-06 08:30:00 | MSFT | Stock | 27.4 | 27.59 | 27.33 | 27.45 | 30056.0 |
| 2013-02-06 09:00:00 | MSFT | Stock | 27.42 | 27.43 | 27.4 | 27.41 | 44478.0 |
| 2013-02-06 09:30:00 | MSFT | Stock | 27.36 | 27.49 | 27.345 | 27.46 | 4487364.0 |
| 2013-02-06 10:00:00 | MSFT | Stock | 27.455 | 27.48 | 27.42 | 27.46 | 3232298.0 |
| 2013-02-06 10:30:00 | MSFT | Stock | 27.46 | 27.48 | 27.4 | 27.45 | 2863524.0 |
| 2013-02-06 11:00:00 | MSFT | Stock | 27.45 | 27.51 | 27.44 | 27.505 | 2431535.0 |
| 2013-02-06 11:30:00 | MSFT | Stock | 27.5 | 27.535 | 27.48 | 27.496 | 1823956.0 |
| 2013-02-06 12:00:00 | MSFT | Stock | 27.5 | 27.53 | 27.48 | 27.5 | 1580384.0 |
| 2013-02-06 12:30:00 | MSFT | Stock | 27.495 | 27.54 | 27.49 | 27.49 | 2277550.0 |
| 2013-02-06 13:00:00 | MSFT | Stock | 27.495 | 27.5 | 27.32 | 27.34 | 3116644.0 |
| 2013-02-06 13:30:00 | MSFT | Stock | 27.34 | 27.36 | 27.29 | 27.295 | 3387259.0 |
| 2013-02-06 14:00:00 | MSFT | Stock | 27.295 | 27.32 | 27.27 | 27.28 | 2496237.0 |
| 2013-02-06 14:30:00 | MSFT | Stock | 27.275 | 27.32 | 27.26 | 27.315 | 2432497.0 |
| 2013-02-06 15:00:00 | MSFT | Stock | 27.31 | 27.348 | 27.25 | 27.315 | 2285762.0 |
| 2013-02-06 15:30:00 | MSFT | Stock | 27.315 | 27.34 | 27.26 | 27.34 | 4960285.0 |
| 2013-02-06 16:00:00 | MSFT | Stock | 27.34 | 27.532 | 27.3 | 27.33 | 3733225.0 |
| 2013-02-06 16:30:00 | MSFT | Stock | 27.34 | 27.34 | 27.31 | 27.34 | 70730.0 |
> showing 50 of 75,382 rows — these rows as CSV