PREVIEW / futures_30min / 2012-05-20
file: by_date/futures_30min/2012/2012-05-20.parquet size: 20 KB rows: 510
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-05-20 18:00:00 | ES | Futures | 1307.17 | 1308.94 | 1303.63 | 1304.39 | 14457.0 |
| 2012-05-20 18:30:00 | ES | Futures | 1304.39 | 1304.89 | 1302.62 | 1303.63 | 6059.0 |
| 2012-05-20 19:00:00 | ES | Futures | 1303.63 | 1308.69 | 1303.38 | 1308.69 | 5939.0 |
| 2012-05-20 19:30:00 | ES | Futures | 1308.69 | 1310.46 | 1308.44 | 1309.95 | 7696.0 |
| 2012-05-20 20:00:00 | ES | Futures | 1309.95 | 1312.99 | 1309.45 | 1311.72 | 10721.0 |
| 2012-05-20 20:30:00 | ES | Futures | 1311.72 | 1313.24 | 1310.71 | 1310.71 | 5804.0 |
| 2012-05-20 21:00:00 | ES | Futures | 1310.96 | 1312.74 | 1309.7 | 1312.23 | 5006.0 |
| 2012-05-20 21:30:00 | ES | Futures | 1312.23 | 1314.76 | 1311.98 | 1314.51 | 10803.0 |
| 2012-05-20 22:00:00 | ES | Futures | 1314.25 | 1314.76 | 1311.22 | 1311.72 | 4814.0 |
| 2012-05-20 22:30:00 | ES | Futures | 1311.72 | 1312.48 | 1310.21 | 1312.48 | 3520.0 |
| 2012-05-20 23:00:00 | ES | Futures | 1312.23 | 1312.99 | 1311.22 | 1312.48 | 1989.0 |
| 2012-05-20 23:30:00 | ES | Futures | 1312.48 | 1313.24 | 1311.72 | 1312.99 | 1734.0 |
| 2012-05-20 18:00:00 | NQ | Futures | 2860.19 | 2863.37 | 2853.83 | 2854.41 | 1731.0 |
| 2012-05-20 18:30:00 | NQ | Futures | 2854.12 | 2855.86 | 2851.52 | 2854.12 | 542.0 |
| 2012-05-20 19:00:00 | NQ | Futures | 2853.25 | 2863.66 | 2851.81 | 2863.66 | 431.0 |
| 2012-05-20 19:30:00 | NQ | Futures | 2863.95 | 2867.13 | 2862.8 | 2866.56 | 612.0 |
| 2012-05-20 20:00:00 | NQ | Futures | 2866.56 | 2872.92 | 2865.69 | 2869.16 | 851.0 |
| 2012-05-20 20:30:00 | NQ | Futures | 2869.16 | 2874.07 | 2867.71 | 2868.29 | 725.0 |
| 2012-05-20 21:00:00 | NQ | Futures | 2868.58 | 2872.92 | 2865.69 | 2870.03 | 666.0 |
| 2012-05-20 21:30:00 | NQ | Futures | 2870.32 | 2875.81 | 2870.03 | 2875.52 | 950.0 |
| 2012-05-20 22:00:00 | NQ | Futures | 2875.52 | 2875.81 | 2868.58 | 2869.45 | 329.0 |
| 2012-05-20 22:30:00 | NQ | Futures | 2869.45 | 2871.47 | 2865.98 | 2871.47 | 417.0 |
| 2012-05-20 23:00:00 | NQ | Futures | 2871.47 | 2872.92 | 2868.87 | 2871.76 | 143.0 |
| 2012-05-20 23:30:00 | NQ | Futures | 2872.05 | 2874.65 | 2870.03 | 2874.07 | 481.0 |
| 2012-05-20 18:00:00 | YM | Futures | 12289.4 | 12309.3 | 12259.5 | 12274.4 | 767.0 |
| 2012-05-20 18:30:00 | YM | Futures | 12273.4 | 12276.4 | 12262.5 | 12269.4 | 262.0 |
| 2012-05-20 19:00:00 | YM | Futures | 12266.4 | 12308.3 | 12266.4 | 12308.3 | 229.0 |
| 2012-05-20 19:30:00 | YM | Futures | 12307.3 | 12321.2 | 12307.3 | 12319.2 | 400.0 |
| 2012-05-20 20:00:00 | YM | Futures | 12318.2 | 12347.1 | 12317.3 | 12336.2 | 768.0 |
| 2012-05-20 20:30:00 | YM | Futures | 12336.2 | 12349.1 | 12327.2 | 12328.2 | 418.0 |
| 2012-05-20 21:00:00 | YM | Futures | 12329.2 | 12346.1 | 12322.2 | 12339.2 | 414.0 |
| 2012-05-20 21:30:00 | YM | Futures | 12338.2 | 12360.1 | 12337.2 | 12357.1 | 723.0 |
| 2012-05-20 22:00:00 | YM | Futures | 12357.1 | 12358.1 | 12332.2 | 12333.2 | 282.0 |
| 2012-05-20 22:30:00 | YM | Futures | 12332.2 | 12341.2 | 12322.2 | 12341.2 | 245.0 |
| 2012-05-20 23:00:00 | YM | Futures | 12340.2 | 12345.1 | 12334.2 | 12341.2 | 126.0 |
| 2012-05-20 23:30:00 | YM | Futures | 12341.2 | 12349.1 | 12337.2 | 12349.1 | 204.0 |
| 2012-05-20 18:00:00 | CL | Futures | 151.86 | 151.86 | 151.06 | 151.36 | 847.0 |
| 2012-05-20 18:30:00 | CL | Futures | 151.36 | 151.43 | 150.88 | 151.01 | 598.0 |
| 2012-05-20 19:00:00 | CL | Futures | 151.0 | 151.54 | 150.95 | 151.54 | 525.0 |
| 2012-05-20 19:30:00 | CL | Futures | 151.54 | 151.64 | 151.43 | 151.63 | 276.0 |
| 2012-05-20 20:00:00 | CL | Futures | 151.63 | 152.5 | 151.61 | 152.19 | 1412.0 |
| 2012-05-20 20:30:00 | CL | Futures | 152.16 | 152.47 | 151.94 | 152.11 | 758.0 |
| 2012-05-20 21:00:00 | CL | Futures | 152.07 | 152.59 | 151.84 | 152.37 | 947.0 |
| 2012-05-20 21:30:00 | CL | Futures | 152.4 | 152.87 | 152.4 | 152.85 | 757.0 |
| 2012-05-20 22:00:00 | CL | Futures | 152.85 | 152.92 | 152.44 | 152.49 | 500.0 |
| 2012-05-20 22:30:00 | CL | Futures | 152.49 | 152.75 | 152.34 | 152.74 | 422.0 |
| 2012-05-20 23:00:00 | CL | Futures | 152.75 | 152.77 | 152.49 | 152.69 | 291.0 |
| 2012-05-20 23:30:00 | CL | Futures | 152.72 | 152.77 | 152.49 | 152.69 | 238.0 |
| 2012-05-20 18:00:00 | GC | Futures | 2203.8 | 2208.8 | 2203.5 | 2205.5 | 1298.0 |
| 2012-05-20 18:30:00 | GC | Futures | 2205.6 | 2208.1 | 2205.0 | 2205.5 | 275.0 |
> showing 50 of 510 rows — these rows as CSV