PREVIEW / futures_30min / 2010-07-25
file: by_date/futures_30min/2010/2010-07-25.parquet size: 18 KB rows: 440
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-25 18:00:00 | ES | Futures | 1080.9 | 1082.37 | 1078.44 | 1079.67 | 7029.0 |
| 2010-07-25 18:30:00 | ES | Futures | 1079.67 | 1080.16 | 1079.67 | 1079.92 | 777.0 |
| 2010-07-25 19:00:00 | ES | Futures | 1079.92 | 1080.41 | 1079.42 | 1079.92 | 1429.0 |
| 2010-07-25 19:30:00 | ES | Futures | 1080.16 | 1080.65 | 1078.2 | 1079.42 | 2372.0 |
| 2010-07-25 20:00:00 | ES | Futures | 1079.42 | 1081.14 | 1078.69 | 1080.65 | 2986.0 |
| 2010-07-25 20:30:00 | ES | Futures | 1080.9 | 1081.14 | 1079.67 | 1080.41 | 3180.0 |
| 2010-07-25 21:00:00 | ES | Futures | 1080.65 | 1084.09 | 1080.41 | 1083.11 | 6919.0 |
| 2010-07-25 21:30:00 | ES | Futures | 1083.11 | 1083.6 | 1082.37 | 1083.35 | 2977.0 |
| 2010-07-25 22:00:00 | ES | Futures | 1083.11 | 1083.84 | 1082.37 | 1082.86 | 2431.0 |
| 2010-07-25 22:30:00 | ES | Futures | 1082.61 | 1083.35 | 1082.37 | 1082.37 | 1538.0 |
| 2010-07-25 23:00:00 | ES | Futures | 1082.61 | 1082.86 | 1082.12 | 1082.37 | 1641.0 |
| 2010-07-25 23:30:00 | ES | Futures | 1082.12 | 1082.61 | 1081.63 | 1082.61 | 2217.0 |
| 2010-07-25 18:00:00 | NQ | Futures | 2148.39 | 2152.4 | 2146.09 | 2148.39 | 690.0 |
| 2010-07-25 18:30:00 | NQ | Futures | 2148.39 | 2148.96 | 2147.81 | 2148.96 | 34.0 |
| 2010-07-25 19:00:00 | NQ | Futures | 2148.39 | 2149.82 | 2148.1 | 2149.25 | 19.0 |
| 2010-07-25 19:30:00 | NQ | Futures | 2148.96 | 2149.82 | 2146.09 | 2148.39 | 224.0 |
| 2010-07-25 20:00:00 | NQ | Futures | 2148.39 | 2152.11 | 2147.24 | 2151.54 | 360.0 |
| 2010-07-25 20:30:00 | NQ | Futures | 2151.54 | 2151.82 | 2148.96 | 2150.68 | 226.0 |
| 2010-07-25 21:00:00 | NQ | Futures | 2151.25 | 2158.7 | 2150.68 | 2156.7 | 502.0 |
| 2010-07-25 21:30:00 | NQ | Futures | 2156.41 | 2157.56 | 2154.69 | 2156.41 | 184.0 |
| 2010-07-25 22:00:00 | NQ | Futures | 2156.41 | 2158.13 | 2155.26 | 2155.26 | 176.0 |
| 2010-07-25 22:30:00 | NQ | Futures | 2155.55 | 2156.12 | 2154.4 | 2154.98 | 81.0 |
| 2010-07-25 23:00:00 | NQ | Futures | 2154.98 | 2155.55 | 2153.83 | 2154.12 | 70.0 |
| 2010-07-25 23:30:00 | NQ | Futures | 2154.12 | 2154.98 | 2153.26 | 2154.98 | 84.0 |
| 2010-07-25 18:00:00 | YM | Futures | 9835.2 | 9854.2 | 9818.2 | 9831.5 | 441.0 |
| 2010-07-25 18:30:00 | YM | Futures | 9827.7 | 9832.4 | 9823.9 | 9824.8 | 53.0 |
| 2010-07-25 19:00:00 | YM | Futures | 9825.8 | 9834.3 | 9824.8 | 9828.6 | 29.0 |
| 2010-07-25 19:30:00 | YM | Futures | 9828.6 | 9831.5 | 9817.3 | 9823.9 | 138.0 |
| 2010-07-25 20:00:00 | YM | Futures | 9826.7 | 9839.0 | 9822.0 | 9837.1 | 191.0 |
| 2010-07-25 20:30:00 | YM | Futures | 9837.1 | 9839.0 | 9826.7 | 9834.3 | 138.0 |
| 2010-07-25 21:00:00 | YM | Futures | 9837.1 | 9869.3 | 9833.3 | 9856.1 | 429.0 |
| 2010-07-25 21:30:00 | YM | Futures | 9855.1 | 9857.0 | 9846.6 | 9854.2 | 215.0 |
| 2010-07-25 22:00:00 | YM | Futures | 9855.1 | 9858.0 | 9847.5 | 9848.5 | 149.0 |
| 2010-07-25 22:30:00 | YM | Futures | 9849.4 | 9854.2 | 9843.8 | 9845.7 | 154.0 |
| 2010-07-25 23:00:00 | YM | Futures | 9845.7 | 9847.5 | 9842.8 | 9842.8 | 83.0 |
| 2010-07-25 23:30:00 | YM | Futures | 9842.8 | 9846.6 | 9840.0 | 9846.6 | 94.0 |
| 2010-07-25 18:00:00 | CL | Futures | 151.58 | 151.6 | 150.93 | 151.22 | 833.0 |
| 2010-07-25 18:30:00 | CL | Futures | 151.22 | 151.43 | 151.1 | 151.16 | 289.0 |
| 2010-07-25 19:00:00 | CL | Futures | 151.1 | 151.24 | 151.1 | 151.2 | 69.0 |
| 2010-07-25 19:30:00 | CL | Futures | 151.16 | 151.33 | 151.16 | 151.28 | 139.0 |
| 2010-07-25 20:00:00 | CL | Futures | 151.33 | 151.43 | 151.1 | 151.33 | 238.0 |
| 2010-07-25 20:30:00 | CL | Futures | 151.39 | 151.47 | 151.2 | 151.33 | 204.0 |
| 2010-07-25 21:00:00 | CL | Futures | 151.3 | 151.91 | 151.28 | 151.83 | 413.0 |
| 2010-07-25 21:30:00 | CL | Futures | 151.83 | 151.85 | 151.54 | 151.76 | 337.0 |
| 2010-07-25 22:00:00 | CL | Futures | 151.76 | 151.83 | 151.6 | 151.77 | 240.0 |
| 2010-07-25 22:30:00 | CL | Futures | 151.79 | 151.89 | 151.76 | 151.81 | 139.0 |
| 2010-07-25 23:00:00 | CL | Futures | 151.79 | 151.97 | 151.79 | 151.87 | 141.0 |
| 2010-07-25 23:30:00 | CL | Futures | 151.87 | 151.95 | 151.77 | 151.95 | 171.0 |
| 2010-07-25 18:00:00 | GC | Futures | 1667.4 | 1670.4 | 1666.8 | 1668.9 | 515.0 |
| 2010-07-25 18:30:00 | GC | Futures | 1669.2 | 1669.2 | 1667.2 | 1668.8 | 154.0 |
> showing 50 of 440 rows — these rows as CSV