PREVIEW / futures_30min / 2010-01-10
file: by_date/futures_30min/2010/2010-01-10.parquet size: 18 KB rows: 446
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-01-10 18:00:00 | ES | Futures | 1110.96 | 1112.91 | 1109.99 | 1112.67 | 10417.0 |
| 2010-01-10 18:30:00 | ES | Futures | 1112.67 | 1115.34 | 1111.94 | 1114.61 | 7848.0 |
| 2010-01-10 19:00:00 | ES | Futures | 1114.86 | 1115.1 | 1114.37 | 1114.86 | 1639.0 |
| 2010-01-10 19:30:00 | ES | Futures | 1114.86 | 1115.58 | 1114.37 | 1114.61 | 2787.0 |
| 2010-01-10 20:00:00 | ES | Futures | 1114.86 | 1115.34 | 1114.13 | 1115.34 | 3231.0 |
| 2010-01-10 20:30:00 | ES | Futures | 1115.34 | 1115.58 | 1114.61 | 1115.1 | 3131.0 |
| 2010-01-10 21:00:00 | ES | Futures | 1115.34 | 1115.58 | 1115.1 | 1115.1 | 1361.0 |
| 2010-01-10 21:30:00 | ES | Futures | 1115.1 | 1115.83 | 1115.1 | 1115.83 | 1066.0 |
| 2010-01-10 22:00:00 | ES | Futures | 1115.58 | 1116.56 | 1115.58 | 1115.83 | 4829.0 |
| 2010-01-10 22:30:00 | ES | Futures | 1116.07 | 1116.31 | 1115.58 | 1116.31 | 2233.0 |
| 2010-01-10 23:00:00 | ES | Futures | 1115.83 | 1116.56 | 1115.83 | 1116.31 | 687.0 |
| 2010-01-10 23:30:00 | ES | Futures | 1116.07 | 1116.31 | 1115.83 | 1116.07 | 336.0 |
| 2010-01-10 18:00:00 | NQ | Futures | 2161.93 | 2164.21 | 2158.79 | 2163.64 | 686.0 |
| 2010-01-10 18:30:00 | NQ | Futures | 2163.64 | 2168.5 | 2162.5 | 2167.64 | 725.0 |
| 2010-01-10 19:00:00 | NQ | Futures | 2167.64 | 2169.07 | 2167.35 | 2168.21 | 483.0 |
| 2010-01-10 19:30:00 | NQ | Futures | 2167.93 | 2169.35 | 2167.35 | 2168.21 | 149.0 |
| 2010-01-10 20:00:00 | NQ | Futures | 2167.93 | 2168.78 | 2166.78 | 2168.78 | 224.0 |
| 2010-01-10 20:30:00 | NQ | Futures | 2168.78 | 2169.07 | 2167.35 | 2168.21 | 186.0 |
| 2010-01-10 21:00:00 | NQ | Futures | 2168.5 | 2169.07 | 2167.93 | 2168.21 | 88.0 |
| 2010-01-10 21:30:00 | NQ | Futures | 2168.21 | 2169.35 | 2167.93 | 2169.07 | 107.0 |
| 2010-01-10 22:00:00 | NQ | Futures | 2169.07 | 2170.78 | 2169.07 | 2169.35 | 184.0 |
| 2010-01-10 22:30:00 | NQ | Futures | 2169.35 | 2170.21 | 2168.78 | 2169.64 | 139.0 |
| 2010-01-10 23:00:00 | NQ | Futures | 2169.64 | 2170.21 | 2169.64 | 2169.64 | 31.0 |
| 2010-01-10 23:30:00 | NQ | Futures | 2169.64 | 2169.92 | 2169.07 | 2169.92 | 48.0 |
| 2010-01-10 18:00:00 | YM | Futures | 9894.3 | 9902.8 | 9885.0 | 9900.9 | 354.0 |
| 2010-01-10 18:30:00 | YM | Futures | 9900.9 | 9923.3 | 9897.1 | 9918.7 | 364.0 |
| 2010-01-10 19:00:00 | YM | Futures | 9916.8 | 9921.5 | 9914.9 | 9919.6 | 105.0 |
| 2010-01-10 19:30:00 | YM | Futures | 9917.7 | 9924.3 | 9917.7 | 9918.7 | 118.0 |
| 2010-01-10 20:00:00 | YM | Futures | 9918.7 | 9922.4 | 9914.9 | 9920.5 | 168.0 |
| 2010-01-10 20:30:00 | YM | Futures | 9921.5 | 9924.3 | 9916.8 | 9924.3 | 113.0 |
| 2010-01-10 21:00:00 | YM | Futures | 9922.4 | 9924.3 | 9918.7 | 9921.5 | 38.0 |
| 2010-01-10 21:30:00 | YM | Futures | 9921.5 | 9927.1 | 9920.5 | 9925.2 | 166.0 |
| 2010-01-10 22:00:00 | YM | Futures | 9925.2 | 9931.8 | 9924.3 | 9927.1 | 113.0 |
| 2010-01-10 22:30:00 | YM | Futures | 9927.1 | 9930.8 | 9925.2 | 9928.0 | 100.0 |
| 2010-01-10 23:00:00 | YM | Futures | 9927.1 | 9930.8 | 9927.1 | 9929.0 | 20.0 |
| 2010-01-10 23:30:00 | YM | Futures | 9928.0 | 9929.0 | 9926.2 | 9926.2 | 30.0 |
| 2010-01-10 18:00:00 | CL | Futures | 177.98 | 178.88 | 177.98 | 178.77 | 855.0 |
| 2010-01-10 18:30:00 | CL | Futures | 178.77 | 179.22 | 178.66 | 179.03 | 1078.0 |
| 2010-01-10 19:00:00 | CL | Futures | 179.03 | 179.22 | 178.96 | 179.05 | 352.0 |
| 2010-01-10 19:30:00 | CL | Futures | 179.05 | 179.35 | 178.94 | 179.26 | 1146.0 |
| 2010-01-10 20:00:00 | CL | Futures | 179.22 | 179.67 | 179.22 | 179.39 | 947.0 |
| 2010-01-10 20:30:00 | CL | Futures | 179.37 | 179.44 | 179.05 | 179.07 | 706.0 |
| 2010-01-10 21:00:00 | CL | Futures | 179.07 | 179.11 | 178.88 | 178.92 | 361.0 |
| 2010-01-10 21:30:00 | CL | Futures | 178.94 | 179.09 | 178.88 | 179.07 | 325.0 |
| 2010-01-10 22:00:00 | CL | Futures | 179.09 | 179.09 | 179.05 | 179.07 | 247.0 |
| 2010-01-10 22:30:00 | CL | Futures | 179.03 | 179.2 | 179.03 | 179.09 | 498.0 |
| 2010-01-10 23:00:00 | CL | Futures | 179.09 | 179.33 | 179.05 | 179.33 | 410.0 |
| 2010-01-10 23:30:00 | CL | Futures | 179.31 | 179.39 | 179.13 | 179.24 | 343.0 |
| 2010-01-10 18:00:00 | GC | Futures | 1605.2 | 1639.0 | 1605.2 | 1624.8 | 5808.0 |
| 2010-01-10 18:30:00 | GC | Futures | 1624.8 | 1631.9 | 1622.1 | 1627.0 | 3184.0 |
> showing 50 of 446 rows — these rows as CSV