PREVIEW / futures_30min / 2012-01-08
file: by_date/futures_30min/2012/2012-01-08.parquet size: 18 KB rows: 482
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 |
|---|---|---|---|---|---|---|---|
| 2012-01-08 18:00:00 | ES | Futures | 1284.89 | 1284.89 | 1278.59 | 1279.6 | 9152.0 |
| 2012-01-08 18:30:00 | ES | Futures | 1279.6 | 1279.6 | 1277.58 | 1279.6 | 3450.0 |
| 2012-01-08 19:00:00 | ES | Futures | 1279.6 | 1279.85 | 1278.08 | 1278.59 | 4084.0 |
| 2012-01-08 19:30:00 | ES | Futures | 1278.34 | 1279.09 | 1277.58 | 1278.84 | 3179.0 |
| 2012-01-08 20:00:00 | ES | Futures | 1279.09 | 1280.1 | 1278.59 | 1279.6 | 2112.0 |
| 2012-01-08 20:30:00 | ES | Futures | 1279.6 | 1280.1 | 1278.08 | 1278.59 | 3059.0 |
| 2012-01-08 21:00:00 | ES | Futures | 1278.59 | 1278.84 | 1277.33 | 1278.59 | 3775.0 |
| 2012-01-08 21:30:00 | ES | Futures | 1278.59 | 1280.35 | 1278.34 | 1279.6 | 2718.0 |
| 2012-01-08 22:00:00 | ES | Futures | 1279.6 | 1280.6 | 1278.84 | 1280.1 | 2415.0 |
| 2012-01-08 22:30:00 | ES | Futures | 1280.1 | 1280.35 | 1278.08 | 1278.34 | 2258.0 |
| 2012-01-08 23:00:00 | ES | Futures | 1278.59 | 1280.35 | 1278.34 | 1279.09 | 2001.0 |
| 2012-01-08 23:30:00 | ES | Futures | 1279.34 | 1280.1 | 1278.34 | 1278.59 | 1295.0 |
| 2012-01-08 18:00:00 | NQ | Futures | 2718.46 | 2721.06 | 2709.79 | 2710.95 | 644.0 |
| 2012-01-08 18:30:00 | NQ | Futures | 2710.95 | 2711.24 | 2707.48 | 2709.79 | 418.0 |
| 2012-01-08 19:00:00 | NQ | Futures | 2710.08 | 2710.37 | 2706.04 | 2706.91 | 189.0 |
| 2012-01-08 19:30:00 | NQ | Futures | 2706.62 | 2708.35 | 2706.04 | 2707.48 | 130.0 |
| 2012-01-08 20:00:00 | NQ | Futures | 2707.77 | 2710.08 | 2707.2 | 2709.22 | 147.0 |
| 2012-01-08 20:30:00 | NQ | Futures | 2709.22 | 2709.22 | 2706.91 | 2707.2 | 112.0 |
| 2012-01-08 21:00:00 | NQ | Futures | 2707.48 | 2708.06 | 2705.46 | 2707.48 | 198.0 |
| 2012-01-08 21:30:00 | NQ | Futures | 2708.06 | 2711.53 | 2708.06 | 2710.37 | 200.0 |
| 2012-01-08 22:00:00 | NQ | Futures | 2710.66 | 2712.11 | 2708.93 | 2710.95 | 98.0 |
| 2012-01-08 22:30:00 | NQ | Futures | 2710.37 | 2710.95 | 2707.2 | 2707.48 | 65.0 |
| 2012-01-08 23:00:00 | NQ | Futures | 2708.06 | 2711.24 | 2707.48 | 2709.79 | 118.0 |
| 2012-01-08 23:30:00 | NQ | Futures | 2709.22 | 2710.66 | 2708.06 | 2708.35 | 87.0 |
| 2012-01-08 18:00:00 | YM | Futures | 12202.9 | 12207.8 | 12151.3 | 12159.2 | 499.0 |
| 2012-01-08 18:30:00 | YM | Futures | 12161.2 | 12162.2 | 12145.4 | 12160.2 | 240.0 |
| 2012-01-08 19:00:00 | YM | Futures | 12161.2 | 12162.2 | 12149.3 | 12151.3 | 166.0 |
| 2012-01-08 19:30:00 | YM | Futures | 12151.3 | 12159.2 | 12144.4 | 12158.3 | 420.0 |
| 2012-01-08 20:00:00 | YM | Futures | 12158.3 | 12168.2 | 12156.3 | 12164.2 | 208.0 |
| 2012-01-08 20:30:00 | YM | Futures | 12165.2 | 12166.2 | 12147.4 | 12153.3 | 932.0 |
| 2012-01-08 21:00:00 | YM | Futures | 12152.3 | 12160.2 | 12143.4 | 12153.3 | 1178.0 |
| 2012-01-08 21:30:00 | YM | Futures | 12157.3 | 12170.2 | 12156.3 | 12163.2 | 763.0 |
| 2012-01-08 22:00:00 | YM | Futures | 12164.2 | 12176.1 | 12156.3 | 12174.1 | 832.0 |
| 2012-01-08 22:30:00 | YM | Futures | 12173.1 | 12173.1 | 12153.3 | 12154.3 | 416.0 |
| 2012-01-08 23:00:00 | YM | Futures | 12156.3 | 12169.2 | 12155.3 | 12161.2 | 120.0 |
| 2012-01-08 23:30:00 | YM | Futures | 12161.2 | 12169.2 | 12155.3 | 12158.3 | 149.0 |
| 2012-01-08 18:00:00 | CL | Futures | 171.88 | 172.27 | 170.97 | 171.02 | 1499.0 |
| 2012-01-08 18:30:00 | CL | Futures | 171.02 | 171.36 | 170.82 | 171.13 | 618.0 |
| 2012-01-08 19:00:00 | CL | Futures | 171.16 | 171.18 | 170.7 | 170.75 | 314.0 |
| 2012-01-08 19:30:00 | CL | Futures | 170.77 | 170.96 | 170.5 | 170.91 | 509.0 |
| 2012-01-08 20:00:00 | CL | Futures | 170.86 | 171.02 | 170.7 | 170.79 | 395.0 |
| 2012-01-08 20:30:00 | CL | Futures | 170.86 | 170.87 | 170.43 | 170.48 | 337.0 |
| 2012-01-08 21:00:00 | CL | Futures | 170.45 | 170.59 | 170.16 | 170.48 | 739.0 |
| 2012-01-08 21:30:00 | CL | Futures | 170.52 | 170.54 | 170.28 | 170.48 | 492.0 |
| 2012-01-08 22:00:00 | CL | Futures | 170.45 | 170.59 | 170.18 | 170.47 | 464.0 |
| 2012-01-08 22:30:00 | CL | Futures | 170.47 | 170.54 | 170.33 | 170.33 | 293.0 |
| 2012-01-08 23:00:00 | CL | Futures | 170.35 | 170.62 | 170.32 | 170.45 | 253.0 |
| 2012-01-08 23:30:00 | CL | Futures | 170.45 | 170.5 | 170.25 | 170.25 | 408.0 |
| 2012-01-08 18:00:00 | GC | Futures | 2249.3 | 2249.6 | 2239.3 | 2242.8 | 913.0 |
| 2012-01-08 18:30:00 | GC | Futures | 2242.8 | 2247.7 | 2237.4 | 2243.5 | 1092.0 |
> showing 50 of 482 rows — these rows as CSV