PREVIEW / futures_30min / 2013-03-17
file: by_date/futures_30min/2013/2013-03-17.parquet size: 21 KB rows: 553
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-03-17 18:00:00 | ES | Futures | 1590.84 | 1590.84 | 1582.86 | 1586.46 | 57363.0 |
| 2013-03-17 18:30:00 | ES | Futures | 1586.46 | 1587.23 | 1583.63 | 1583.89 | 10655.0 |
| 2013-03-17 19:00:00 | ES | Futures | 1583.89 | 1586.2 | 1583.63 | 1585.17 | 8179.0 |
| 2013-03-17 19:30:00 | ES | Futures | 1585.17 | 1585.69 | 1582.6 | 1583.11 | 15978.0 |
| 2013-03-17 20:00:00 | ES | Futures | 1583.11 | 1584.4 | 1582.6 | 1583.89 | 12158.0 |
| 2013-03-17 20:30:00 | ES | Futures | 1583.89 | 1584.14 | 1583.11 | 1583.63 | 5531.0 |
| 2013-03-17 21:00:00 | ES | Futures | 1583.63 | 1583.63 | 1580.54 | 1580.8 | 15941.0 |
| 2013-03-17 21:30:00 | ES | Futures | 1580.8 | 1581.05 | 1579.51 | 1580.28 | 12502.0 |
| 2013-03-17 22:00:00 | ES | Futures | 1580.02 | 1582.08 | 1580.02 | 1581.83 | 5342.0 |
| 2013-03-17 22:30:00 | ES | Futures | 1582.08 | 1583.11 | 1581.31 | 1581.83 | 5129.0 |
| 2013-03-17 23:00:00 | ES | Futures | 1581.83 | 1582.86 | 1580.8 | 1581.05 | 4540.0 |
| 2013-03-17 23:30:00 | ES | Futures | 1581.05 | 1581.05 | 1579.51 | 1580.02 | 5712.0 |
| 2013-03-17 18:00:00 | NQ | Futures | 3236.35 | 3236.35 | 3210.68 | 3228.18 | 3135.0 |
| 2013-03-17 18:30:00 | NQ | Futures | 3228.18 | 3228.47 | 3223.22 | 3223.51 | 365.0 |
| 2013-03-17 19:00:00 | NQ | Futures | 3223.51 | 3227.89 | 3223.51 | 3226.14 | 206.0 |
| 2013-03-17 19:30:00 | NQ | Futures | 3226.14 | 3226.43 | 3221.47 | 3221.76 | 462.0 |
| 2013-03-17 20:00:00 | NQ | Futures | 3221.76 | 3223.81 | 3221.18 | 3223.22 | 291.0 |
| 2013-03-17 20:30:00 | NQ | Futures | 3223.51 | 3223.51 | 3221.18 | 3222.35 | 406.0 |
| 2013-03-17 21:00:00 | NQ | Futures | 3222.64 | 3222.64 | 3214.76 | 3215.06 | 742.0 |
| 2013-03-17 21:30:00 | NQ | Futures | 3214.76 | 3215.64 | 3213.6 | 3215.06 | 699.0 |
| 2013-03-17 22:00:00 | NQ | Futures | 3215.35 | 3217.39 | 3214.76 | 3217.39 | 349.0 |
| 2013-03-17 22:30:00 | NQ | Futures | 3217.1 | 3220.31 | 3217.1 | 3218.26 | 403.0 |
| 2013-03-17 23:00:00 | NQ | Futures | 3218.26 | 3219.72 | 3217.39 | 3217.39 | 186.0 |
| 2013-03-17 23:30:00 | NQ | Futures | 3217.39 | 3217.39 | 3214.76 | 3216.51 | 381.0 |
| 2013-03-17 18:00:00 | YM | Futures | 14525.3 | 14525.3 | 14460.6 | 14481.8 | 2298.0 |
| 2013-03-17 18:30:00 | YM | Futures | 14482.8 | 14491.9 | 14464.6 | 14468.6 | 664.0 |
| 2013-03-17 19:00:00 | YM | Futures | 14468.6 | 14486.8 | 14468.6 | 14482.8 | 656.0 |
| 2013-03-17 19:30:00 | YM | Futures | 14481.8 | 14486.8 | 14466.6 | 14468.6 | 923.0 |
| 2013-03-17 20:00:00 | YM | Futures | 14469.7 | 14482.8 | 14467.6 | 14479.8 | 1008.0 |
| 2013-03-17 20:30:00 | YM | Futures | 14480.8 | 14482.8 | 14471.7 | 14474.7 | 838.0 |
| 2013-03-17 21:00:00 | YM | Futures | 14473.7 | 14475.7 | 14450.4 | 14453.5 | 1311.0 |
| 2013-03-17 21:30:00 | YM | Futures | 14453.5 | 14455.5 | 14444.4 | 14452.5 | 1152.0 |
| 2013-03-17 22:00:00 | YM | Futures | 14452.5 | 14466.6 | 14451.5 | 14462.6 | 787.0 |
| 2013-03-17 22:30:00 | YM | Futures | 14464.6 | 14472.7 | 14463.6 | 14463.6 | 813.0 |
| 2013-03-17 23:00:00 | YM | Futures | 14465.6 | 14469.7 | 14456.5 | 14457.5 | 365.0 |
| 2013-03-17 23:30:00 | YM | Futures | 14457.5 | 14457.5 | 14448.4 | 14456.5 | 1359.0 |
| 2013-03-17 18:00:00 | CL | Futures | 148.15 | 148.18 | 147.08 | 147.31 | 1743.0 |
| 2013-03-17 18:30:00 | CL | Futures | 147.36 | 147.58 | 147.28 | 147.39 | 423.0 |
| 2013-03-17 19:00:00 | CL | Futures | 147.38 | 147.42 | 147.28 | 147.39 | 276.0 |
| 2013-03-17 19:30:00 | CL | Futures | 147.36 | 147.36 | 146.84 | 146.95 | 822.0 |
| 2013-03-17 20:00:00 | CL | Futures | 146.9 | 146.93 | 146.7 | 146.93 | 643.0 |
| 2013-03-17 20:30:00 | CL | Futures | 146.93 | 146.98 | 146.87 | 146.89 | 256.0 |
| 2013-03-17 21:00:00 | CL | Futures | 146.9 | 146.9 | 146.43 | 146.54 | 1137.0 |
| 2013-03-17 21:30:00 | CL | Futures | 146.51 | 146.65 | 146.41 | 146.57 | 400.0 |
| 2013-03-17 22:00:00 | CL | Futures | 146.55 | 146.68 | 146.46 | 146.48 | 300.0 |
| 2013-03-17 22:30:00 | CL | Futures | 146.46 | 146.67 | 146.43 | 146.54 | 254.0 |
| 2013-03-17 23:00:00 | CL | Futures | 146.54 | 146.57 | 146.48 | 146.54 | 151.0 |
| 2013-03-17 23:30:00 | CL | Futures | 146.55 | 146.76 | 146.55 | 146.73 | 319.0 |
| 2013-03-17 18:00:00 | GC | Futures | 2196.2 | 2210.7 | 2194.4 | 2207.3 | 6662.0 |
| 2013-03-17 18:30:00 | GC | Futures | 2207.2 | 2207.9 | 2202.6 | 2204.0 | 1289.0 |
> showing 50 of 553 rows — these rows as CSV