PREVIEW / futures_30min / 2010-03-07
file: by_date/futures_30min/2010/2010-03-07.parquet size: 17 KB rows: 424
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-07 18:00:00 | ES | Futures | 1105.61 | 1106.83 | 1105.12 | 1106.1 | 5201.0 |
| 2010-03-07 18:30:00 | ES | Futures | 1106.1 | 1106.58 | 1105.61 | 1106.58 | 1926.0 |
| 2010-03-07 19:00:00 | ES | Futures | 1106.34 | 1107.07 | 1105.85 | 1106.34 | 3443.0 |
| 2010-03-07 19:30:00 | ES | Futures | 1106.34 | 1106.58 | 1105.37 | 1105.61 | 1965.0 |
| 2010-03-07 20:00:00 | ES | Futures | 1105.61 | 1106.1 | 1105.37 | 1105.85 | 1672.0 |
| 2010-03-07 20:30:00 | ES | Futures | 1105.85 | 1106.83 | 1105.85 | 1106.34 | 1991.0 |
| 2010-03-07 21:00:00 | ES | Futures | 1106.1 | 1107.56 | 1106.1 | 1107.56 | 2288.0 |
| 2010-03-07 21:30:00 | ES | Futures | 1107.31 | 1107.8 | 1106.58 | 1106.83 | 1686.0 |
| 2010-03-07 22:00:00 | ES | Futures | 1106.58 | 1107.56 | 1106.58 | 1107.31 | 1351.0 |
| 2010-03-07 22:30:00 | ES | Futures | 1107.07 | 1107.56 | 1106.58 | 1106.83 | 1126.0 |
| 2010-03-07 23:00:00 | ES | Futures | 1106.83 | 1107.8 | 1106.83 | 1107.56 | 812.0 |
| 2010-03-07 23:30:00 | ES | Futures | 1107.31 | 1107.8 | 1107.07 | 1107.56 | 1411.0 |
| 2010-03-07 18:00:00 | NQ | Futures | 2152.5 | 2157.36 | 2152.5 | 2155.93 | 454.0 |
| 2010-03-07 18:30:00 | NQ | Futures | 2156.21 | 2157.36 | 2155.64 | 2157.07 | 188.0 |
| 2010-03-07 19:00:00 | NQ | Futures | 2157.07 | 2158.21 | 2155.93 | 2156.79 | 310.0 |
| 2010-03-07 19:30:00 | NQ | Futures | 2156.79 | 2156.79 | 2155.07 | 2155.36 | 109.0 |
| 2010-03-07 20:00:00 | NQ | Futures | 2155.07 | 2155.93 | 2154.79 | 2155.93 | 98.0 |
| 2010-03-07 20:30:00 | NQ | Futures | 2155.64 | 2156.79 | 2155.64 | 2156.21 | 100.0 |
| 2010-03-07 21:00:00 | NQ | Futures | 2155.93 | 2157.93 | 2155.93 | 2157.36 | 102.0 |
| 2010-03-07 21:30:00 | NQ | Futures | 2157.64 | 2157.64 | 2156.21 | 2156.5 | 64.0 |
| 2010-03-07 22:00:00 | NQ | Futures | 2156.79 | 2157.64 | 2156.79 | 2157.07 | 59.0 |
| 2010-03-07 22:30:00 | NQ | Futures | 2157.36 | 2157.64 | 2154.79 | 2155.64 | 306.0 |
| 2010-03-07 23:00:00 | NQ | Futures | 2155.64 | 2156.5 | 2154.21 | 2155.93 | 509.0 |
| 2010-03-07 23:30:00 | NQ | Futures | 2155.64 | 2155.93 | 2155.07 | 2155.64 | 144.0 |
| 2010-03-07 18:00:00 | YM | Futures | 9867.2 | 9871.9 | 9859.7 | 9865.3 | 241.0 |
| 2010-03-07 18:30:00 | YM | Futures | 9867.2 | 9870.9 | 9865.3 | 9870.9 | 34.0 |
| 2010-03-07 19:00:00 | YM | Futures | 9870.9 | 9876.6 | 9867.2 | 9870.9 | 214.0 |
| 2010-03-07 19:30:00 | YM | Futures | 9870.9 | 9870.9 | 9863.5 | 9866.3 | 158.0 |
| 2010-03-07 20:00:00 | YM | Futures | 9866.3 | 9868.1 | 9865.3 | 9867.2 | 52.0 |
| 2010-03-07 20:30:00 | YM | Futures | 9867.2 | 9872.8 | 9867.2 | 9870.9 | 111.0 |
| 2010-03-07 21:00:00 | YM | Futures | 9870.0 | 9881.2 | 9870.0 | 9879.4 | 111.0 |
| 2010-03-07 21:30:00 | YM | Futures | 9880.3 | 9882.2 | 9871.9 | 9872.8 | 282.0 |
| 2010-03-07 22:00:00 | YM | Futures | 9873.7 | 9876.6 | 9873.7 | 9874.7 | 115.0 |
| 2010-03-07 22:30:00 | YM | Futures | 9874.7 | 9875.6 | 9871.9 | 9871.9 | 88.0 |
| 2010-03-07 23:00:00 | YM | Futures | 9871.9 | 9880.3 | 9871.9 | 9878.4 | 116.0 |
| 2010-03-07 23:30:00 | YM | Futures | 9877.5 | 9879.4 | 9876.6 | 9877.5 | 82.0 |
| 2010-03-07 18:00:00 | CL | Futures | 174.03 | 174.31 | 173.84 | 174.12 | 789.0 |
| 2010-03-07 18:30:00 | CL | Futures | 174.14 | 174.18 | 173.99 | 174.12 | 357.0 |
| 2010-03-07 19:00:00 | CL | Futures | 174.08 | 174.27 | 174.03 | 174.16 | 265.0 |
| 2010-03-07 19:30:00 | CL | Futures | 174.14 | 174.2 | 174.1 | 174.12 | 126.0 |
| 2010-03-07 20:00:00 | CL | Futures | 174.12 | 174.29 | 173.97 | 174.16 | 463.0 |
| 2010-03-07 20:30:00 | CL | Futures | 174.16 | 174.29 | 174.12 | 174.22 | 249.0 |
| 2010-03-07 21:00:00 | CL | Futures | 174.22 | 174.35 | 174.22 | 174.27 | 176.0 |
| 2010-03-07 21:30:00 | CL | Futures | 174.31 | 174.56 | 174.29 | 174.42 | 587.0 |
| 2010-03-07 22:00:00 | CL | Futures | 174.44 | 174.5 | 174.39 | 174.42 | 171.0 |
| 2010-03-07 22:30:00 | CL | Futures | 174.42 | 174.46 | 174.33 | 174.42 | 148.0 |
| 2010-03-07 23:00:00 | CL | Futures | 174.39 | 174.52 | 174.33 | 174.5 | 139.0 |
| 2010-03-07 23:30:00 | CL | Futures | 174.46 | 174.52 | 174.31 | 174.35 | 157.0 |
| 2010-03-07 18:00:00 | GC | Futures | 1599.3 | 1602.0 | 1599.3 | 1600.7 | 881.0 |
| 2010-03-07 18:30:00 | GC | Futures | 1600.7 | 1601.2 | 1597.9 | 1598.2 | 1177.0 |
> showing 50 of 424 rows — these rows as CSV