PREVIEW / futures_30min / 2013-04-14
file: by_date/futures_30min/2013/2013-04-14.parquet size: 22 KB rows: 539
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-04-14 18:00:00 | ES | Futures | 1630.25 | 1631.02 | 1628.19 | 1628.45 | 5598.0 |
| 2013-04-14 18:30:00 | ES | Futures | 1628.45 | 1628.96 | 1627.68 | 1627.68 | 2494.0 |
| 2013-04-14 19:00:00 | ES | Futures | 1627.93 | 1628.45 | 1626.65 | 1628.45 | 3492.0 |
| 2013-04-14 19:30:00 | ES | Futures | 1628.45 | 1628.96 | 1628.19 | 1628.45 | 1334.0 |
| 2013-04-14 20:00:00 | ES | Futures | 1628.45 | 1628.96 | 1628.19 | 1628.96 | 2878.0 |
| 2013-04-14 20:30:00 | ES | Futures | 1628.96 | 1629.99 | 1628.71 | 1629.48 | 3595.0 |
| 2013-04-14 21:00:00 | ES | Futures | 1629.48 | 1630.25 | 1628.96 | 1629.99 | 5572.0 |
| 2013-04-14 21:30:00 | ES | Futures | 1629.74 | 1631.02 | 1629.22 | 1629.99 | 6920.0 |
| 2013-04-14 22:00:00 | ES | Futures | 1629.74 | 1629.74 | 1624.58 | 1627.68 | 17840.0 |
| 2013-04-14 22:30:00 | ES | Futures | 1627.42 | 1627.68 | 1623.81 | 1625.36 | 8949.0 |
| 2013-04-14 23:00:00 | ES | Futures | 1625.36 | 1626.39 | 1624.07 | 1624.58 | 3059.0 |
| 2013-04-14 23:30:00 | ES | Futures | 1624.58 | 1624.84 | 1623.04 | 1623.55 | 6590.0 |
| 2013-04-14 18:00:00 | NQ | Futures | 3320.93 | 3322.68 | 3317.14 | 3317.43 | 508.0 |
| 2013-04-14 18:30:00 | NQ | Futures | 3317.43 | 3317.72 | 3315.97 | 3315.97 | 219.0 |
| 2013-04-14 19:00:00 | NQ | Futures | 3315.97 | 3317.43 | 3314.22 | 3317.43 | 151.0 |
| 2013-04-14 19:30:00 | NQ | Futures | 3317.43 | 3318.6 | 3316.85 | 3317.43 | 121.0 |
| 2013-04-14 20:00:00 | NQ | Futures | 3317.14 | 3320.06 | 3316.85 | 3320.06 | 197.0 |
| 2013-04-14 20:30:00 | NQ | Futures | 3320.06 | 3323.56 | 3319.77 | 3321.81 | 347.0 |
| 2013-04-14 21:00:00 | NQ | Futures | 3321.81 | 3323.85 | 3320.93 | 3322.97 | 251.0 |
| 2013-04-14 21:30:00 | NQ | Futures | 3323.27 | 3326.18 | 3322.68 | 3323.85 | 610.0 |
| 2013-04-14 22:00:00 | NQ | Futures | 3323.56 | 3323.56 | 3312.47 | 3318.02 | 1380.0 |
| 2013-04-14 22:30:00 | NQ | Futures | 3318.02 | 3318.02 | 3311.31 | 3313.64 | 955.0 |
| 2013-04-14 23:00:00 | NQ | Futures | 3313.35 | 3314.81 | 3311.89 | 3313.06 | 331.0 |
| 2013-04-14 23:30:00 | NQ | Futures | 3312.47 | 3312.47 | 3308.68 | 3309.27 | 382.0 |
| 2013-04-14 18:00:00 | YM | Futures | 14948.8 | 14953.9 | 14937.7 | 14937.7 | 294.0 |
| 2013-04-14 18:30:00 | YM | Futures | 14938.7 | 14940.8 | 14933.7 | 14933.7 | 134.0 |
| 2013-04-14 19:00:00 | YM | Futures | 14932.7 | 14937.7 | 14924.6 | 14937.7 | 366.0 |
| 2013-04-14 19:30:00 | YM | Futures | 14936.7 | 14943.8 | 14936.7 | 14939.7 | 326.0 |
| 2013-04-14 20:00:00 | YM | Futures | 14938.7 | 14947.8 | 14938.7 | 14946.8 | 503.0 |
| 2013-04-14 20:30:00 | YM | Futures | 14945.8 | 14950.9 | 14943.8 | 14947.8 | 281.0 |
| 2013-04-14 21:00:00 | YM | Futures | 14946.8 | 14952.9 | 14943.8 | 14949.9 | 431.0 |
| 2013-04-14 21:30:00 | YM | Futures | 14950.9 | 14959.0 | 14947.8 | 14951.9 | 788.0 |
| 2013-04-14 22:00:00 | YM | Futures | 14950.9 | 14950.9 | 14912.5 | 14934.7 | 2625.0 |
| 2013-04-14 22:30:00 | YM | Futures | 14934.7 | 14935.7 | 14906.4 | 14917.5 | 1242.0 |
| 2013-04-14 23:00:00 | YM | Futures | 14917.5 | 14924.6 | 14908.4 | 14911.4 | 483.0 |
| 2013-04-14 23:30:00 | YM | Futures | 14911.4 | 14911.4 | 14898.3 | 14901.3 | 712.0 |
| 2013-04-14 18:00:00 | CL | Futures | 143.47 | 143.47 | 142.79 | 142.98 | 294.0 |
| 2013-04-14 18:30:00 | CL | Futures | 142.98 | 143.04 | 142.61 | 142.64 | 159.0 |
| 2013-04-14 19:00:00 | CL | Futures | 142.64 | 142.92 | 142.61 | 142.9 | 92.0 |
| 2013-04-14 19:30:00 | CL | Futures | 142.87 | 143.0 | 142.65 | 142.71 | 92.0 |
| 2013-04-14 20:00:00 | CL | Futures | 142.71 | 142.89 | 142.7 | 142.84 | 131.0 |
| 2013-04-14 20:30:00 | CL | Futures | 142.81 | 142.87 | 142.75 | 142.75 | 64.0 |
| 2013-04-14 21:00:00 | CL | Futures | 142.76 | 142.79 | 142.67 | 142.71 | 68.0 |
| 2013-04-14 21:30:00 | CL | Futures | 142.75 | 142.75 | 142.35 | 142.37 | 330.0 |
| 2013-04-14 22:00:00 | CL | Futures | 142.35 | 142.35 | 140.97 | 141.9 | 2056.0 |
| 2013-04-14 22:30:00 | CL | Futures | 141.85 | 141.95 | 141.1 | 141.1 | 833.0 |
| 2013-04-14 23:00:00 | CL | Futures | 141.14 | 141.32 | 140.99 | 140.99 | 314.0 |
| 2013-04-14 23:30:00 | CL | Futures | 140.97 | 140.97 | 139.9 | 140.11 | 1249.0 |
| 2013-04-14 18:00:00 | GC | Futures | 2034.1 | 2038.6 | 2028.6 | 2034.1 | 6502.0 |
| 2013-04-14 18:30:00 | GC | Futures | 2034.4 | 2038.8 | 2033.6 | 2036.7 | 1946.0 |
> showing 50 of 539 rows — these rows as CSV