PREVIEW / futures_30min / 2013-01-27
file: by_date/futures_30min/2013/2013-01-27.parquet size: 20 KB rows: 528
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-01-27 18:00:00 | ES | Futures | 1535.18 | 1535.44 | 1533.9 | 1534.67 | 3602.0 |
| 2013-01-27 18:30:00 | ES | Futures | 1534.67 | 1534.93 | 1534.41 | 1534.67 | 562.0 |
| 2013-01-27 19:00:00 | ES | Futures | 1534.67 | 1534.93 | 1533.39 | 1534.67 | 3167.0 |
| 2013-01-27 19:30:00 | ES | Futures | 1534.93 | 1536.72 | 1534.67 | 1536.72 | 3164.0 |
| 2013-01-27 20:00:00 | ES | Futures | 1536.47 | 1536.98 | 1535.44 | 1536.47 | 2948.0 |
| 2013-01-27 20:30:00 | ES | Futures | 1536.72 | 1536.98 | 1535.7 | 1535.95 | 3693.0 |
| 2013-01-27 21:00:00 | ES | Futures | 1535.7 | 1536.47 | 1535.44 | 1536.21 | 1651.0 |
| 2013-01-27 21:30:00 | ES | Futures | 1536.21 | 1536.47 | 1536.21 | 1536.21 | 333.0 |
| 2013-01-27 22:00:00 | ES | Futures | 1536.21 | 1536.72 | 1536.21 | 1536.47 | 365.0 |
| 2013-01-27 22:30:00 | ES | Futures | 1536.47 | 1536.47 | 1535.95 | 1535.95 | 383.0 |
| 2013-01-27 23:00:00 | ES | Futures | 1536.21 | 1536.72 | 1535.7 | 1536.21 | 786.0 |
| 2013-01-27 23:30:00 | ES | Futures | 1536.21 | 1536.47 | 1535.95 | 1536.21 | 343.0 |
| 2013-01-27 18:00:00 | NQ | Futures | 3177.89 | 3177.89 | 3174.69 | 3176.15 | 303.0 |
| 2013-01-27 18:30:00 | NQ | Futures | 3176.44 | 3176.73 | 3175.56 | 3176.44 | 94.0 |
| 2013-01-27 19:00:00 | NQ | Futures | 3176.44 | 3176.44 | 3174.11 | 3176.44 | 176.0 |
| 2013-01-27 19:30:00 | NQ | Futures | 3176.15 | 3179.93 | 3176.15 | 3179.93 | 263.0 |
| 2013-01-27 20:00:00 | NQ | Futures | 3179.93 | 3180.51 | 3177.89 | 3179.93 | 159.0 |
| 2013-01-27 20:30:00 | NQ | Futures | 3179.64 | 3180.51 | 3178.18 | 3178.47 | 164.0 |
| 2013-01-27 21:00:00 | NQ | Futures | 3179.06 | 3180.22 | 3178.18 | 3180.22 | 194.0 |
| 2013-01-27 21:30:00 | NQ | Futures | 3179.93 | 3181.09 | 3179.93 | 3180.8 | 172.0 |
| 2013-01-27 22:00:00 | NQ | Futures | 3180.8 | 3181.09 | 3180.22 | 3180.51 | 40.0 |
| 2013-01-27 22:30:00 | NQ | Futures | 3180.8 | 3180.8 | 3179.35 | 3179.64 | 44.0 |
| 2013-01-27 23:00:00 | NQ | Futures | 3179.64 | 3180.8 | 3179.35 | 3180.22 | 58.0 |
| 2013-01-27 23:30:00 | NQ | Futures | 3179.93 | 3181.09 | 3179.93 | 3180.8 | 39.0 |
| 2013-01-27 18:00:00 | YM | Futures | 13899.2 | 13910.3 | 13886.2 | 13901.3 | 549.0 |
| 2013-01-27 18:30:00 | YM | Futures | 13898.2 | 13903.3 | 13896.2 | 13900.2 | 144.0 |
| 2013-01-27 19:00:00 | YM | Futures | 13900.2 | 13900.2 | 13891.2 | 13898.2 | 194.0 |
| 2013-01-27 19:30:00 | YM | Futures | 13899.2 | 13916.3 | 13899.2 | 13916.3 | 214.0 |
| 2013-01-27 20:00:00 | YM | Futures | 13915.3 | 13917.3 | 13905.3 | 13913.3 | 425.0 |
| 2013-01-27 20:30:00 | YM | Futures | 13913.3 | 13916.3 | 13908.3 | 13908.3 | 290.0 |
| 2013-01-27 21:00:00 | YM | Futures | 13910.3 | 13915.3 | 13907.3 | 13913.3 | 284.0 |
| 2013-01-27 21:30:00 | YM | Futures | 13913.3 | 13914.3 | 13913.3 | 13913.3 | 15.0 |
| 2013-01-27 22:00:00 | YM | Futures | 13914.3 | 13914.3 | 13911.3 | 13912.3 | 90.0 |
| 2013-01-27 22:30:00 | YM | Futures | 13913.3 | 13914.3 | 13911.3 | 13911.3 | 30.0 |
| 2013-01-27 23:00:00 | YM | Futures | 13911.3 | 13915.3 | 13909.3 | 13913.3 | 83.0 |
| 2013-01-27 23:30:00 | YM | Futures | 13912.3 | 13913.3 | 13911.3 | 13912.3 | 26.0 |
| 2013-01-27 18:00:00 | CL | Futures | 153.49 | 153.57 | 153.25 | 153.31 | 621.0 |
| 2013-01-27 18:30:00 | CL | Futures | 153.33 | 153.34 | 153.26 | 153.33 | 89.0 |
| 2013-01-27 19:00:00 | CL | Futures | 153.31 | 153.33 | 153.25 | 153.31 | 308.0 |
| 2013-01-27 19:30:00 | CL | Futures | 153.31 | 153.42 | 153.28 | 153.41 | 295.0 |
| 2013-01-27 20:00:00 | CL | Futures | 153.37 | 153.5 | 153.36 | 153.41 | 432.0 |
| 2013-01-27 20:30:00 | CL | Futures | 153.42 | 153.45 | 153.34 | 153.41 | 270.0 |
| 2013-01-27 21:00:00 | CL | Futures | 153.37 | 153.41 | 153.29 | 153.36 | 168.0 |
| 2013-01-27 21:30:00 | CL | Futures | 153.36 | 153.41 | 153.34 | 153.36 | 101.0 |
| 2013-01-27 22:00:00 | CL | Futures | 153.36 | 153.37 | 153.29 | 153.34 | 187.0 |
| 2013-01-27 22:30:00 | CL | Futures | 153.36 | 153.37 | 153.29 | 153.29 | 70.0 |
| 2013-01-27 23:00:00 | CL | Futures | 153.29 | 153.34 | 153.28 | 153.34 | 82.0 |
| 2013-01-27 23:30:00 | CL | Futures | 153.34 | 153.49 | 153.33 | 153.37 | 251.0 |
| 2013-01-27 18:00:00 | GC | Futures | 2284.0 | 2285.6 | 2282.0 | 2283.9 | 402.0 |
| 2013-01-27 18:30:00 | GC | Futures | 2283.6 | 2284.3 | 2282.8 | 2284.2 | 97.0 |
> showing 50 of 528 rows — these rows as CSV