PREVIEW / futures_30min / 2010-03-28
file: by_date/futures_30min/2010/2010-03-28.parquet size: 17 KB rows: 422
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-03-28 18:00:00 | ES | Futures | 1138.78 | 1140.98 | 1138.54 | 1140.0 | 5705.0 |
| 2010-03-28 18:30:00 | ES | Futures | 1140.0 | 1140.49 | 1139.27 | 1139.52 | 1180.0 |
| 2010-03-28 19:00:00 | ES | Futures | 1139.27 | 1140.0 | 1138.78 | 1139.76 | 1015.0 |
| 2010-03-28 19:30:00 | ES | Futures | 1140.0 | 1140.25 | 1139.27 | 1139.27 | 1000.0 |
| 2010-03-28 20:00:00 | ES | Futures | 1139.27 | 1139.52 | 1138.05 | 1139.27 | 2636.0 |
| 2010-03-28 20:30:00 | ES | Futures | 1139.27 | 1140.0 | 1139.03 | 1139.52 | 971.0 |
| 2010-03-28 21:00:00 | ES | Futures | 1139.27 | 1139.76 | 1139.27 | 1139.76 | 734.0 |
| 2010-03-28 21:30:00 | ES | Futures | 1139.76 | 1140.0 | 1138.78 | 1138.78 | 1675.0 |
| 2010-03-28 22:00:00 | ES | Futures | 1138.78 | 1139.76 | 1138.54 | 1139.52 | 1447.0 |
| 2010-03-28 22:30:00 | ES | Futures | 1139.52 | 1140.49 | 1139.52 | 1140.25 | 2919.0 |
| 2010-03-28 23:00:00 | ES | Futures | 1140.25 | 1140.98 | 1140.0 | 1140.49 | 1642.0 |
| 2010-03-28 23:30:00 | ES | Futures | 1140.74 | 1141.47 | 1140.49 | 1140.98 | 1868.0 |
| 2010-03-28 18:00:00 | NQ | Futures | 2236.0 | 2241.15 | 2236.0 | 2239.43 | 486.0 |
| 2010-03-28 18:30:00 | NQ | Futures | 2239.72 | 2239.72 | 2237.14 | 2238.57 | 131.0 |
| 2010-03-28 19:00:00 | NQ | Futures | 2238.29 | 2238.86 | 2237.14 | 2238.86 | 60.0 |
| 2010-03-28 19:30:00 | NQ | Futures | 2238.86 | 2239.15 | 2237.43 | 2237.43 | 99.0 |
| 2010-03-28 20:00:00 | NQ | Futures | 2237.43 | 2238.86 | 2235.71 | 2238.0 | 414.0 |
| 2010-03-28 20:30:00 | NQ | Futures | 2238.29 | 2238.86 | 2237.72 | 2238.29 | 64.0 |
| 2010-03-28 21:00:00 | NQ | Futures | 2238.57 | 2238.86 | 2238.29 | 2238.29 | 61.0 |
| 2010-03-28 21:30:00 | NQ | Futures | 2238.86 | 2239.15 | 2237.43 | 2237.43 | 81.0 |
| 2010-03-28 22:00:00 | NQ | Futures | 2237.72 | 2238.29 | 2237.14 | 2238.29 | 48.0 |
| 2010-03-28 22:30:00 | NQ | Futures | 2238.0 | 2239.72 | 2238.0 | 2239.72 | 118.0 |
| 2010-03-28 23:00:00 | NQ | Futures | 2239.43 | 2240.29 | 2239.43 | 2240.29 | 71.0 |
| 2010-03-28 23:30:00 | NQ | Futures | 2240.58 | 2241.44 | 2240.29 | 2241.15 | 139.0 |
| 2010-03-28 18:00:00 | YM | Futures | 10167.3 | 10186.1 | 10165.4 | 10177.6 | 160.0 |
| 2010-03-28 18:30:00 | YM | Futures | 10178.6 | 10181.4 | 10172.9 | 10173.9 | 80.0 |
| 2010-03-28 19:00:00 | YM | Futures | 10173.9 | 10176.7 | 10169.2 | 10176.7 | 126.0 |
| 2010-03-28 19:30:00 | YM | Futures | 10177.6 | 10179.5 | 10172.0 | 10172.0 | 129.0 |
| 2010-03-28 20:00:00 | YM | Futures | 10173.9 | 10174.8 | 10162.6 | 10172.0 | 129.0 |
| 2010-03-28 20:30:00 | YM | Futures | 10172.0 | 10175.8 | 10170.1 | 10173.9 | 65.0 |
| 2010-03-28 21:00:00 | YM | Futures | 10173.9 | 10174.8 | 10171.1 | 10172.0 | 42.0 |
| 2010-03-28 21:30:00 | YM | Futures | 10173.9 | 10175.8 | 10169.2 | 10169.2 | 96.0 |
| 2010-03-28 22:00:00 | YM | Futures | 10169.2 | 10173.9 | 10166.3 | 10173.9 | 131.0 |
| 2010-03-28 22:30:00 | YM | Futures | 10174.8 | 10180.5 | 10174.8 | 10178.6 | 190.0 |
| 2010-03-28 23:00:00 | YM | Futures | 10178.6 | 10182.3 | 10177.6 | 10182.3 | 76.0 |
| 2010-03-28 23:30:00 | YM | Futures | 10182.3 | 10190.8 | 10181.4 | 10187.0 | 118.0 |
| 2010-03-28 18:00:00 | CL | Futures | 169.83 | 170.15 | 169.71 | 170.02 | 494.0 |
| 2010-03-28 18:30:00 | CL | Futures | 170.05 | 170.05 | 169.86 | 169.94 | 136.0 |
| 2010-03-28 19:00:00 | CL | Futures | 169.92 | 170.07 | 169.81 | 170.07 | 140.0 |
| 2010-03-28 19:30:00 | CL | Futures | 170.09 | 170.13 | 169.92 | 170.05 | 119.0 |
| 2010-03-28 20:00:00 | CL | Futures | 170.07 | 170.15 | 169.88 | 170.15 | 518.0 |
| 2010-03-28 20:30:00 | CL | Futures | 170.15 | 170.32 | 170.11 | 170.17 | 295.0 |
| 2010-03-28 21:00:00 | CL | Futures | 170.17 | 170.22 | 169.96 | 170.09 | 234.0 |
| 2010-03-28 21:30:00 | CL | Futures | 170.07 | 170.3 | 170.05 | 170.09 | 270.0 |
| 2010-03-28 22:00:00 | CL | Futures | 170.09 | 170.32 | 170.02 | 170.24 | 234.0 |
| 2010-03-28 22:30:00 | CL | Futures | 170.24 | 170.32 | 170.24 | 170.3 | 109.0 |
| 2010-03-28 23:00:00 | CL | Futures | 170.24 | 170.36 | 170.19 | 170.36 | 134.0 |
| 2010-03-28 23:30:00 | CL | Futures | 170.34 | 170.36 | 170.28 | 170.32 | 101.0 |
| 2010-03-28 18:00:00 | GC | Futures | 1562.1 | 1567.8 | 1562.1 | 1562.3 | 627.0 |
| 2010-03-28 18:30:00 | GC | Futures | 1562.7 | 1563.3 | 1561.3 | 1562.4 | 160.0 |
> showing 50 of 422 rows — these rows as CSV