PREVIEW / futures_30min / 2015-03-15
file: by_date/futures_30min/2015/2015-03-15.parquet size: 20 KB rows: 503
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-15 18:00:00 | ES | Futures | 2158.63 | 2159.43 | 2157.58 | 2158.11 | 2360.0 |
| 2015-03-15 18:30:00 | ES | Futures | 2158.11 | 2158.37 | 2154.94 | 2155.73 | 1744.0 |
| 2015-03-15 19:00:00 | ES | Futures | 2155.73 | 2156.26 | 2154.94 | 2155.47 | 1693.0 |
| 2015-03-15 19:30:00 | ES | Futures | 2155.47 | 2155.73 | 2153.88 | 2154.14 | 1770.0 |
| 2015-03-15 20:00:00 | ES | Futures | 2154.14 | 2154.41 | 2152.3 | 2152.82 | 4471.0 |
| 2015-03-15 20:30:00 | ES | Futures | 2153.09 | 2154.94 | 2153.09 | 2154.41 | 1207.0 |
| 2015-03-15 21:00:00 | ES | Futures | 2154.41 | 2156.52 | 2154.41 | 2156.26 | 3017.0 |
| 2015-03-15 21:30:00 | ES | Futures | 2156.52 | 2157.31 | 2155.99 | 2156.26 | 2266.0 |
| 2015-03-15 22:00:00 | ES | Futures | 2156.26 | 2157.31 | 2156.26 | 2156.79 | 947.0 |
| 2015-03-15 22:30:00 | ES | Futures | 2156.79 | 2158.63 | 2156.26 | 2158.11 | 1575.0 |
| 2015-03-15 23:00:00 | ES | Futures | 2158.11 | 2158.37 | 2157.84 | 2158.37 | 616.0 |
| 2015-03-15 23:30:00 | ES | Futures | 2158.37 | 2160.22 | 2158.11 | 2159.96 | 1393.0 |
| 2015-03-15 18:00:00 | NQ | Futures | 5064.95 | 5067.6 | 5060.83 | 5061.13 | 509.0 |
| 2015-03-15 18:30:00 | NQ | Futures | 5061.42 | 5062.3 | 5054.95 | 5055.25 | 234.0 |
| 2015-03-15 19:00:00 | NQ | Futures | 5056.42 | 5056.42 | 5054.36 | 5054.66 | 215.0 |
| 2015-03-15 19:30:00 | NQ | Futures | 5054.66 | 5054.95 | 5052.31 | 5053.19 | 311.0 |
| 2015-03-15 20:00:00 | NQ | Futures | 5053.48 | 5053.78 | 5049.36 | 5050.84 | 681.0 |
| 2015-03-15 20:30:00 | NQ | Futures | 5051.42 | 5055.54 | 5051.13 | 5054.36 | 286.0 |
| 2015-03-15 21:00:00 | NQ | Futures | 5054.66 | 5059.66 | 5054.07 | 5058.48 | 365.0 |
| 2015-03-15 21:30:00 | NQ | Futures | 5058.19 | 5060.25 | 5057.01 | 5057.3 | 375.0 |
| 2015-03-15 22:00:00 | NQ | Futures | 5057.01 | 5059.66 | 5056.42 | 5058.48 | 150.0 |
| 2015-03-15 22:30:00 | NQ | Futures | 5058.19 | 5062.01 | 5057.6 | 5061.72 | 215.0 |
| 2015-03-15 23:00:00 | NQ | Futures | 5062.01 | 5062.89 | 5061.42 | 5062.6 | 131.0 |
| 2015-03-15 23:30:00 | NQ | Futures | 5062.6 | 5066.42 | 5062.01 | 5066.13 | 170.0 |
| 2015-03-15 18:00:00 | YM | Futures | 18513.2 | 18532.0 | 18512.1 | 18514.2 | 759.0 |
| 2015-03-15 18:30:00 | YM | Futures | 18513.2 | 18516.3 | 18491.1 | 18492.2 | 499.0 |
| 2015-03-15 19:00:00 | YM | Futures | 18492.2 | 18498.5 | 18489.0 | 18492.2 | 170.0 |
| 2015-03-15 19:30:00 | YM | Futures | 18492.2 | 18492.2 | 18481.7 | 18482.7 | 225.0 |
| 2015-03-15 20:00:00 | YM | Futures | 18483.8 | 18483.8 | 18468.1 | 18475.4 | 434.0 |
| 2015-03-15 20:30:00 | YM | Futures | 18476.5 | 18492.2 | 18476.5 | 18489.0 | 313.0 |
| 2015-03-15 21:00:00 | YM | Futures | 18490.1 | 18505.8 | 18489.0 | 18504.8 | 437.0 |
| 2015-03-15 21:30:00 | YM | Futures | 18502.7 | 18511.1 | 18500.6 | 18503.7 | 383.0 |
| 2015-03-15 22:00:00 | YM | Futures | 18501.6 | 18511.1 | 18501.6 | 18503.7 | 156.0 |
| 2015-03-15 22:30:00 | YM | Futures | 18505.8 | 18519.5 | 18503.7 | 18517.4 | 286.0 |
| 2015-03-15 23:00:00 | YM | Futures | 18517.4 | 18518.4 | 18514.2 | 18515.3 | 79.0 |
| 2015-03-15 23:30:00 | YM | Futures | 18517.4 | 18528.9 | 18514.2 | 18528.9 | 362.0 |
| 2015-03-15 18:00:00 | CL | Futures | 74.33 | 74.6 | 72.98 | 73.24 | 1247.0 |
| 2015-03-15 18:30:00 | CL | Futures | 73.28 | 73.32 | 72.38 | 72.76 | 1217.0 |
| 2015-03-15 19:00:00 | CL | Futures | 72.79 | 72.99 | 72.68 | 72.69 | 424.0 |
| 2015-03-15 19:30:00 | CL | Futures | 72.71 | 72.85 | 72.52 | 72.82 | 554.0 |
| 2015-03-15 20:00:00 | CL | Futures | 72.82 | 73.4 | 72.82 | 73.39 | 1332.0 |
| 2015-03-15 20:30:00 | CL | Futures | 73.4 | 73.42 | 73.21 | 73.29 | 383.0 |
| 2015-03-15 21:00:00 | CL | Futures | 73.32 | 73.5 | 73.31 | 73.45 | 288.0 |
| 2015-03-15 21:30:00 | CL | Futures | 73.45 | 73.83 | 73.45 | 73.78 | 659.0 |
| 2015-03-15 22:00:00 | CL | Futures | 73.78 | 73.99 | 73.77 | 73.8 | 695.0 |
| 2015-03-15 22:30:00 | CL | Futures | 73.8 | 73.86 | 73.75 | 73.8 | 289.0 |
| 2015-03-15 23:00:00 | CL | Futures | 73.83 | 73.84 | 73.75 | 73.84 | 104.0 |
| 2015-03-15 23:30:00 | CL | Futures | 73.84 | 73.84 | 73.75 | 73.77 | 254.0 |
| 2015-03-15 18:00:00 | GC | Futures | 1582.5 | 1583.0 | 1578.9 | 1580.0 | 782.0 |
| 2015-03-15 18:30:00 | GC | Futures | 1580.3 | 1580.7 | 1578.4 | 1578.6 | 354.0 |
> showing 50 of 503 rows — these rows as CSV