PREVIEW / futures_30min / 2017-07-10
file: by_date/futures_30min/2017/2017-07-10.parquet size: 76 KB rows: 3,000
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 |
|---|---|---|---|---|---|---|---|
| 2017-07-10 00:00:00 | ES | Futures | 2655.49 | 2655.76 | 2654.67 | 2654.67 | 1889.0 |
| 2017-07-10 00:30:00 | ES | Futures | 2654.67 | 2654.94 | 2654.12 | 2654.4 | 1446.0 |
| 2017-07-10 01:00:00 | ES | Futures | 2654.12 | 2654.94 | 2652.76 | 2654.4 | 3448.0 |
| 2017-07-10 01:30:00 | ES | Futures | 2654.67 | 2654.67 | 2653.58 | 2653.58 | 1223.0 |
| 2017-07-10 02:00:00 | ES | Futures | 2653.58 | 2654.4 | 2653.3 | 2653.85 | 4320.0 |
| 2017-07-10 02:30:00 | ES | Futures | 2653.58 | 2654.12 | 2652.48 | 2653.03 | 3603.0 |
| 2017-07-10 03:00:00 | ES | Futures | 2653.03 | 2654.12 | 2651.66 | 2652.48 | 11359.0 |
| 2017-07-10 03:30:00 | ES | Futures | 2652.48 | 2653.3 | 2651.66 | 2652.76 | 5359.0 |
| 2017-07-10 04:00:00 | ES | Futures | 2652.76 | 2653.58 | 2651.66 | 2652.48 | 4644.0 |
| 2017-07-10 04:30:00 | ES | Futures | 2652.76 | 2654.12 | 2651.94 | 2652.76 | 5419.0 |
| 2017-07-10 05:00:00 | ES | Futures | 2652.76 | 2652.76 | 2651.12 | 2651.12 | 4785.0 |
| 2017-07-10 05:30:00 | ES | Futures | 2651.12 | 2652.21 | 2650.3 | 2651.94 | 4461.0 |
| 2017-07-10 06:00:00 | ES | Futures | 2651.66 | 2653.3 | 2651.66 | 2652.76 | 4612.0 |
| 2017-07-10 06:30:00 | ES | Futures | 2652.76 | 2653.3 | 2651.66 | 2651.94 | 4502.0 |
| 2017-07-10 07:00:00 | ES | Futures | 2651.94 | 2651.94 | 2649.2 | 2649.75 | 8727.0 |
| 2017-07-10 07:30:00 | ES | Futures | 2649.48 | 2650.3 | 2648.93 | 2649.48 | 6778.0 |
| 2017-07-10 08:00:00 | ES | Futures | 2649.75 | 2650.84 | 2649.48 | 2650.02 | 4542.0 |
| 2017-07-10 08:30:00 | ES | Futures | 2649.75 | 2650.02 | 2648.11 | 2648.66 | 9219.0 |
| 2017-07-10 09:00:00 | ES | Futures | 2648.38 | 2648.66 | 2646.2 | 2647.29 | 22764.0 |
| 2017-07-10 09:30:00 | ES | Futures | 2647.02 | 2650.3 | 2645.1 | 2646.2 | 109433.0 |
| 2017-07-10 10:00:00 | ES | Futures | 2645.92 | 2650.57 | 2645.65 | 2649.75 | 61389.0 |
| 2017-07-10 10:30:00 | ES | Futures | 2649.75 | 2653.03 | 2648.11 | 2653.03 | 57550.0 |
| 2017-07-10 11:00:00 | ES | Futures | 2653.03 | 2654.12 | 2651.94 | 2652.21 | 53407.0 |
| 2017-07-10 11:30:00 | ES | Futures | 2652.21 | 2653.85 | 2651.66 | 2653.85 | 37177.0 |
| 2017-07-10 12:00:00 | ES | Futures | 2653.85 | 2655.49 | 2653.3 | 2654.4 | 51799.0 |
| 2017-07-10 12:30:00 | ES | Futures | 2654.4 | 2655.22 | 2653.58 | 2654.94 | 25784.0 |
| 2017-07-10 13:00:00 | ES | Futures | 2655.22 | 2655.76 | 2654.12 | 2654.94 | 24974.0 |
| 2017-07-10 13:30:00 | ES | Futures | 2654.94 | 2656.04 | 2653.85 | 2655.49 | 23592.0 |
| 2017-07-10 14:00:00 | ES | Futures | 2655.49 | 2656.04 | 2654.12 | 2654.12 | 19908.0 |
| 2017-07-10 14:30:00 | ES | Futures | 2654.12 | 2654.94 | 2653.85 | 2654.12 | 23072.0 |
| 2017-07-10 15:00:00 | ES | Futures | 2654.12 | 2654.94 | 2652.48 | 2653.85 | 31967.0 |
| 2017-07-10 15:30:00 | ES | Futures | 2654.12 | 2656.86 | 2651.66 | 2651.94 | 133719.0 |
| 2017-07-10 16:00:00 | ES | Futures | 2651.66 | 2652.48 | 2650.57 | 2650.84 | 49784.0 |
| 2017-07-10 16:30:00 | ES | Futures | 2650.84 | 2651.12 | 2650.02 | 2650.02 | 5139.0 |
| 2017-07-10 18:00:00 | ES | Futures | 2650.02 | 2650.02 | 2648.66 | 2649.75 | 3051.0 |
| 2017-07-10 18:30:00 | ES | Futures | 2649.75 | 2650.3 | 2649.48 | 2650.3 | 679.0 |
| 2017-07-10 19:00:00 | ES | Futures | 2650.02 | 2650.57 | 2649.75 | 2650.3 | 975.0 |
| 2017-07-10 19:30:00 | ES | Futures | 2650.02 | 2650.84 | 2650.02 | 2650.84 | 968.0 |
| 2017-07-10 20:00:00 | ES | Futures | 2650.57 | 2651.39 | 2650.3 | 2651.39 | 2657.0 |
| 2017-07-10 20:30:00 | ES | Futures | 2651.12 | 2651.39 | 2650.84 | 2651.39 | 841.0 |
| 2017-07-10 21:00:00 | ES | Futures | 2651.39 | 2651.66 | 2650.57 | 2650.84 | 1972.0 |
| 2017-07-10 21:30:00 | ES | Futures | 2650.84 | 2652.21 | 2650.84 | 2651.39 | 2925.0 |
| 2017-07-10 22:00:00 | ES | Futures | 2651.66 | 2652.48 | 2651.39 | 2651.94 | 1165.0 |
| 2017-07-10 22:30:00 | ES | Futures | 2652.21 | 2652.48 | 2651.94 | 2652.21 | 1155.0 |
| 2017-07-10 23:00:00 | ES | Futures | 2652.21 | 2653.3 | 2651.94 | 2652.76 | 1359.0 |
| 2017-07-10 23:30:00 | ES | Futures | 2652.76 | 2653.3 | 2652.48 | 2652.48 | 1090.0 |
| 2017-07-10 00:00:00 | NQ | Futures | 6765.8 | 6767.59 | 6761.34 | 6761.34 | 464.0 |
| 2017-07-10 00:30:00 | NQ | Futures | 6761.63 | 6763.42 | 6761.34 | 6762.23 | 344.0 |
| 2017-07-10 01:00:00 | NQ | Futures | 6761.93 | 6764.61 | 6758.36 | 6763.12 | 579.0 |
| 2017-07-10 01:30:00 | NQ | Futures | 6762.82 | 6764.31 | 6761.93 | 6762.23 | 223.0 |
> showing 50 of 3,000 rows — these rows as CSV