PREVIEW / futures_30min / 2012-11-25
file: by_date/futures_30min/2012/2012-11-25.parquet size: 19 KB rows: 495
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-11-25 18:00:00 | ES | Futures | 1433.92 | 1434.17 | 1431.36 | 1432.64 | 10796.0 |
| 2012-11-25 18:30:00 | ES | Futures | 1432.64 | 1433.66 | 1432.13 | 1432.64 | 3680.0 |
| 2012-11-25 19:00:00 | ES | Futures | 1432.39 | 1432.64 | 1431.62 | 1431.87 | 3507.0 |
| 2012-11-25 19:30:00 | ES | Futures | 1431.87 | 1432.39 | 1431.36 | 1431.62 | 2962.0 |
| 2012-11-25 20:00:00 | ES | Futures | 1431.62 | 1431.87 | 1430.6 | 1431.11 | 3992.0 |
| 2012-11-25 20:30:00 | ES | Futures | 1431.11 | 1432.39 | 1430.6 | 1430.6 | 4279.0 |
| 2012-11-25 21:00:00 | ES | Futures | 1430.85 | 1432.13 | 1430.6 | 1431.36 | 3369.0 |
| 2012-11-25 21:30:00 | ES | Futures | 1431.62 | 1432.13 | 1431.36 | 1431.87 | 2166.0 |
| 2012-11-25 22:00:00 | ES | Futures | 1431.87 | 1431.87 | 1431.11 | 1431.62 | 2365.0 |
| 2012-11-25 22:30:00 | ES | Futures | 1431.36 | 1431.87 | 1430.6 | 1431.36 | 1886.0 |
| 2012-11-25 23:00:00 | ES | Futures | 1431.36 | 1431.62 | 1431.11 | 1431.36 | 723.0 |
| 2012-11-25 23:30:00 | ES | Futures | 1431.36 | 1431.62 | 1431.11 | 1431.36 | 787.0 |
| 2012-11-25 18:00:00 | NQ | Futures | 3060.35 | 3061.22 | 3054.54 | 3054.83 | 1007.0 |
| 2012-11-25 18:30:00 | NQ | Futures | 3054.83 | 3055.41 | 3052.8 | 3053.38 | 581.0 |
| 2012-11-25 19:00:00 | NQ | Futures | 3053.67 | 3053.96 | 3052.5 | 3053.09 | 333.0 |
| 2012-11-25 19:30:00 | NQ | Futures | 3053.38 | 3053.96 | 3052.5 | 3053.09 | 239.0 |
| 2012-11-25 20:00:00 | NQ | Futures | 3053.38 | 3053.67 | 3051.63 | 3051.92 | 307.0 |
| 2012-11-25 20:30:00 | NQ | Futures | 3052.21 | 3054.25 | 3051.63 | 3051.63 | 480.0 |
| 2012-11-25 21:00:00 | NQ | Futures | 3051.63 | 3054.25 | 3050.76 | 3052.8 | 436.0 |
| 2012-11-25 21:30:00 | NQ | Futures | 3053.09 | 3054.54 | 3053.09 | 3053.67 | 161.0 |
| 2012-11-25 22:00:00 | NQ | Futures | 3053.38 | 3054.25 | 3052.8 | 3053.09 | 193.0 |
| 2012-11-25 22:30:00 | NQ | Futures | 3052.8 | 3054.54 | 3052.21 | 3053.67 | 284.0 |
| 2012-11-25 23:00:00 | NQ | Futures | 3053.67 | 3054.25 | 3053.09 | 3053.38 | 33.0 |
| 2012-11-25 23:30:00 | NQ | Futures | 3053.09 | 3053.96 | 3052.8 | 3053.96 | 110.0 |
| 2012-11-25 18:00:00 | YM | Futures | 12955.7 | 12955.7 | 12934.7 | 12943.7 | 593.0 |
| 2012-11-25 18:30:00 | YM | Futures | 12943.7 | 12949.7 | 12938.7 | 12941.7 | 172.0 |
| 2012-11-25 19:00:00 | YM | Futures | 12942.7 | 12944.7 | 12936.7 | 12940.7 | 230.0 |
| 2012-11-25 19:30:00 | YM | Futures | 12938.7 | 12941.7 | 12934.7 | 12937.7 | 261.0 |
| 2012-11-25 20:00:00 | YM | Futures | 12938.7 | 12938.7 | 12933.7 | 12935.7 | 385.0 |
| 2012-11-25 20:30:00 | YM | Futures | 12935.7 | 12942.7 | 12927.7 | 12928.7 | 453.0 |
| 2012-11-25 21:00:00 | YM | Futures | 12928.7 | 12939.7 | 12927.7 | 12933.7 | 420.0 |
| 2012-11-25 21:30:00 | YM | Futures | 12934.7 | 12939.7 | 12933.7 | 12935.7 | 274.0 |
| 2012-11-25 22:00:00 | YM | Futures | 12935.7 | 12938.7 | 12933.7 | 12936.7 | 181.0 |
| 2012-11-25 22:30:00 | YM | Futures | 12933.7 | 12936.7 | 12931.7 | 12935.7 | 181.0 |
| 2012-11-25 23:00:00 | YM | Futures | 12934.7 | 12935.7 | 12931.7 | 12933.7 | 96.0 |
| 2012-11-25 23:30:00 | YM | Futures | 12932.7 | 12936.7 | 12932.7 | 12935.7 | 110.0 |
| 2012-11-25 18:00:00 | CL | Futures | 142.5 | 142.63 | 142.34 | 142.35 | 532.0 |
| 2012-11-25 18:30:00 | CL | Futures | 142.35 | 142.4 | 142.34 | 142.39 | 140.0 |
| 2012-11-25 19:00:00 | CL | Futures | 142.4 | 142.4 | 142.11 | 142.21 | 609.0 |
| 2012-11-25 19:30:00 | CL | Futures | 142.19 | 142.27 | 142.08 | 142.16 | 315.0 |
| 2012-11-25 20:00:00 | CL | Futures | 142.18 | 142.19 | 142.03 | 142.08 | 331.0 |
| 2012-11-25 20:30:00 | CL | Futures | 142.06 | 142.14 | 142.03 | 142.03 | 187.0 |
| 2012-11-25 21:00:00 | CL | Futures | 142.03 | 142.14 | 141.98 | 142.06 | 357.0 |
| 2012-11-25 21:30:00 | CL | Futures | 142.08 | 142.29 | 142.08 | 142.26 | 412.0 |
| 2012-11-25 22:00:00 | CL | Futures | 142.26 | 142.26 | 142.05 | 142.13 | 364.0 |
| 2012-11-25 22:30:00 | CL | Futures | 142.13 | 142.19 | 142.1 | 142.14 | 148.0 |
| 2012-11-25 23:00:00 | CL | Futures | 142.14 | 142.16 | 142.05 | 142.05 | 140.0 |
| 2012-11-25 23:30:00 | CL | Futures | 142.06 | 142.08 | 141.85 | 141.95 | 522.0 |
| 2012-11-25 18:00:00 | GC | Futures | 2416.7 | 2416.7 | 2413.9 | 2414.6 | 224.0 |
| 2012-11-25 18:30:00 | GC | Futures | 2414.5 | 2415.0 | 2413.1 | 2413.9 | 98.0 |
> showing 50 of 495 rows — these rows as CSV