PREVIEW / futures_30min / 2011-10-21
file: by_date/futures_30min/2011/2011-10-21.parquet size: 67 KB rows: 2,207
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-21 00:00:00 | ES | Futures | 1215.42 | 1216.68 | 1214.92 | 1215.93 | 3327.0 |
| 2011-10-21 00:30:00 | ES | Futures | 1216.18 | 1216.43 | 1215.42 | 1215.93 | 1670.0 |
| 2011-10-21 01:00:00 | ES | Futures | 1215.93 | 1218.18 | 1215.42 | 1217.93 | 3377.0 |
| 2011-10-21 01:30:00 | ES | Futures | 1217.93 | 1219.19 | 1217.43 | 1218.18 | 2877.0 |
| 2011-10-21 02:00:00 | ES | Futures | 1218.18 | 1218.68 | 1216.68 | 1217.18 | 4323.0 |
| 2011-10-21 02:30:00 | ES | Futures | 1217.43 | 1217.68 | 1215.42 | 1216.43 | 4262.0 |
| 2011-10-21 03:00:00 | ES | Futures | 1216.43 | 1217.18 | 1213.17 | 1217.18 | 19948.0 |
| 2011-10-21 03:30:00 | ES | Futures | 1217.18 | 1217.43 | 1214.92 | 1216.68 | 12671.0 |
| 2011-10-21 04:00:00 | ES | Futures | 1216.93 | 1217.68 | 1214.42 | 1215.42 | 14307.0 |
| 2011-10-21 04:30:00 | ES | Futures | 1215.68 | 1217.68 | 1214.67 | 1216.68 | 8791.0 |
| 2011-10-21 05:00:00 | ES | Futures | 1216.43 | 1219.44 | 1215.17 | 1218.18 | 13951.0 |
| 2011-10-21 05:30:00 | ES | Futures | 1218.18 | 1219.19 | 1216.18 | 1217.18 | 15790.0 |
| 2011-10-21 06:00:00 | ES | Futures | 1217.18 | 1218.93 | 1216.68 | 1217.43 | 17677.0 |
| 2011-10-21 06:30:00 | ES | Futures | 1217.68 | 1219.44 | 1216.68 | 1218.93 | 14622.0 |
| 2011-10-21 07:00:00 | ES | Futures | 1218.93 | 1226.46 | 1218.68 | 1226.21 | 47587.0 |
| 2011-10-21 07:30:00 | ES | Futures | 1226.46 | 1227.46 | 1223.7 | 1225.2 | 32137.0 |
| 2011-10-21 08:00:00 | ES | Futures | 1225.2 | 1227.96 | 1224.45 | 1225.96 | 31851.0 |
| 2011-10-21 08:30:00 | ES | Futures | 1225.71 | 1226.71 | 1223.7 | 1225.96 | 26662.0 |
| 2011-10-21 09:00:00 | ES | Futures | 1226.21 | 1230.97 | 1225.96 | 1228.97 | 84989.0 |
| 2011-10-21 09:30:00 | ES | Futures | 1229.22 | 1233.48 | 1227.46 | 1231.97 | 235065.0 |
| 2011-10-21 10:00:00 | ES | Futures | 1231.97 | 1238.49 | 1229.97 | 1237.99 | 233137.0 |
| 2011-10-21 10:30:00 | ES | Futures | 1237.99 | 1239.5 | 1234.23 | 1235.99 | 196313.0 |
| 2011-10-21 11:00:00 | ES | Futures | 1235.99 | 1236.49 | 1232.23 | 1234.73 | 121320.0 |
| 2011-10-21 11:30:00 | ES | Futures | 1234.73 | 1236.99 | 1233.73 | 1235.48 | 74817.0 |
| 2011-10-21 12:00:00 | ES | Futures | 1235.23 | 1235.74 | 1232.48 | 1233.98 | 60702.0 |
| 2011-10-21 12:30:00 | ES | Futures | 1233.73 | 1233.98 | 1231.22 | 1231.47 | 66269.0 |
| 2011-10-21 13:00:00 | ES | Futures | 1231.22 | 1231.47 | 1226.46 | 1226.96 | 124658.0 |
| 2011-10-21 13:30:00 | ES | Futures | 1226.71 | 1228.46 | 1225.45 | 1226.21 | 88110.0 |
| 2011-10-21 14:00:00 | ES | Futures | 1226.21 | 1231.72 | 1225.45 | 1230.47 | 90135.0 |
| 2011-10-21 14:30:00 | ES | Futures | 1230.47 | 1233.48 | 1228.21 | 1233.48 | 78198.0 |
| 2011-10-21 15:00:00 | ES | Futures | 1233.23 | 1235.23 | 1232.23 | 1232.73 | 79248.0 |
| 2011-10-21 15:30:00 | ES | Futures | 1232.98 | 1237.99 | 1230.72 | 1237.74 | 165186.0 |
| 2011-10-21 16:00:00 | ES | Futures | 1237.74 | 1239.5 | 1236.49 | 1238.49 | 92840.0 |
| 2011-10-21 00:00:00 | NQ | Futures | 2656.89 | 2660.06 | 2656.31 | 2658.91 | 112.0 |
| 2011-10-21 00:30:00 | NQ | Futures | 2658.91 | 2659.49 | 2657.18 | 2658.62 | 90.0 |
| 2011-10-21 01:00:00 | NQ | Futures | 2658.91 | 2662.66 | 2657.76 | 2662.37 | 180.0 |
| 2011-10-21 01:30:00 | NQ | Futures | 2662.95 | 2664.1 | 2660.93 | 2662.95 | 196.0 |
| 2011-10-21 02:00:00 | NQ | Futures | 2663.23 | 2663.52 | 2659.2 | 2660.64 | 282.0 |
| 2011-10-21 02:30:00 | NQ | Futures | 2660.64 | 2661.22 | 2656.6 | 2658.91 | 332.0 |
| 2011-10-21 03:00:00 | NQ | Futures | 2658.62 | 2660.64 | 2651.99 | 2660.35 | 1616.0 |
| 2011-10-21 03:30:00 | NQ | Futures | 2660.64 | 2661.22 | 2656.31 | 2660.06 | 762.0 |
| 2011-10-21 04:00:00 | NQ | Futures | 2660.06 | 2661.79 | 2654.01 | 2656.89 | 1062.0 |
| 2011-10-21 04:30:00 | NQ | Futures | 2656.89 | 2661.5 | 2654.01 | 2659.49 | 1246.0 |
| 2011-10-21 05:00:00 | NQ | Futures | 2659.49 | 2669.87 | 2656.6 | 2666.41 | 2087.0 |
| 2011-10-21 05:30:00 | NQ | Futures | 2666.69 | 2668.14 | 2661.22 | 2663.52 | 1094.0 |
| 2011-10-21 06:00:00 | NQ | Futures | 2663.81 | 2666.12 | 2661.22 | 2663.81 | 1485.0 |
| 2011-10-21 06:30:00 | NQ | Futures | 2663.23 | 2667.85 | 2661.79 | 2666.41 | 859.0 |
| 2011-10-21 07:00:00 | NQ | Futures | 2666.41 | 2680.25 | 2665.54 | 2680.25 | 2775.0 |
| 2011-10-21 07:30:00 | NQ | Futures | 2680.25 | 2682.55 | 2675.06 | 2678.52 | 2820.0 |
| 2011-10-21 08:00:00 | NQ | Futures | 2678.52 | 2682.55 | 2677.36 | 2678.52 | 3082.0 |
> showing 50 of 2,207 rows — these rows as CSV