PREVIEW / futures_30min / 2010-07-11
file: by_date/futures_30min/2010/2010-07-11.parquet size: 17 KB rows: 406
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-11 18:00:00 | ES | Futures | 1051.7 | 1052.43 | 1050.72 | 1051.7 | 3249.0 |
| 2010-07-11 18:30:00 | ES | Futures | 1051.7 | 1052.19 | 1051.45 | 1051.94 | 596.0 |
| 2010-07-11 19:00:00 | ES | Futures | 1051.94 | 1051.94 | 1050.96 | 1050.96 | 275.0 |
| 2010-07-11 19:30:00 | ES | Futures | 1051.21 | 1051.21 | 1050.22 | 1050.72 | 2550.0 |
| 2010-07-11 20:00:00 | ES | Futures | 1050.72 | 1051.45 | 1050.22 | 1050.96 | 2720.0 |
| 2010-07-11 20:30:00 | ES | Futures | 1050.96 | 1051.45 | 1049.98 | 1051.21 | 2166.0 |
| 2010-07-11 21:00:00 | ES | Futures | 1050.96 | 1052.19 | 1050.47 | 1051.21 | 2506.0 |
| 2010-07-11 21:30:00 | ES | Futures | 1051.21 | 1051.94 | 1049.49 | 1049.73 | 2478.0 |
| 2010-07-11 22:00:00 | ES | Futures | 1049.73 | 1051.7 | 1049.49 | 1051.21 | 2501.0 |
| 2010-07-11 22:30:00 | ES | Futures | 1050.96 | 1050.96 | 1049.98 | 1050.72 | 1189.0 |
| 2010-07-11 23:00:00 | ES | Futures | 1050.47 | 1051.45 | 1049.98 | 1050.47 | 2096.0 |
| 2010-07-11 23:30:00 | ES | Futures | 1050.47 | 1051.21 | 1050.22 | 1050.96 | 587.0 |
| 2010-07-11 18:00:00 | NQ | Futures | 2074.74 | 2075.88 | 2073.31 | 2075.02 | 238.0 |
| 2010-07-11 18:30:00 | NQ | Futures | 2074.74 | 2076.46 | 2074.45 | 2075.6 | 46.0 |
| 2010-07-11 19:00:00 | NQ | Futures | 2075.31 | 2075.6 | 2073.59 | 2074.16 | 42.0 |
| 2010-07-11 19:30:00 | NQ | Futures | 2074.16 | 2074.16 | 2071.87 | 2073.31 | 161.0 |
| 2010-07-11 20:00:00 | NQ | Futures | 2073.02 | 2074.16 | 2072.45 | 2073.59 | 147.0 |
| 2010-07-11 20:30:00 | NQ | Futures | 2073.59 | 2074.16 | 2071.87 | 2073.88 | 113.0 |
| 2010-07-11 21:00:00 | NQ | Futures | 2073.88 | 2075.88 | 2072.73 | 2074.16 | 157.0 |
| 2010-07-11 21:30:00 | NQ | Futures | 2074.16 | 2075.31 | 2071.01 | 2071.3 | 192.0 |
| 2010-07-11 22:00:00 | NQ | Futures | 2071.01 | 2075.6 | 2070.73 | 2073.31 | 276.0 |
| 2010-07-11 22:30:00 | NQ | Futures | 2073.59 | 2073.59 | 2071.87 | 2073.31 | 104.0 |
| 2010-07-11 23:00:00 | NQ | Futures | 2073.31 | 2074.45 | 2071.59 | 2071.87 | 132.0 |
| 2010-07-11 23:30:00 | NQ | Futures | 2072.45 | 2073.31 | 2072.16 | 2073.31 | 30.0 |
| 2010-07-11 18:00:00 | YM | Futures | 9576.8 | 9585.3 | 9576.8 | 9581.6 | 187.0 |
| 2010-07-11 18:30:00 | YM | Futures | 9582.5 | 9587.2 | 9582.5 | 9582.5 | 46.0 |
| 2010-07-11 19:00:00 | YM | Futures | 9582.5 | 9582.5 | 9576.8 | 9577.8 | 43.0 |
| 2010-07-11 19:30:00 | YM | Futures | 9577.8 | 9579.7 | 9572.1 | 9576.8 | 78.0 |
| 2010-07-11 20:00:00 | YM | Futures | 9576.8 | 9580.6 | 9571.1 | 9578.7 | 107.0 |
| 2010-07-11 20:30:00 | YM | Futures | 9577.8 | 9579.7 | 9570.2 | 9574.9 | 81.0 |
| 2010-07-11 21:00:00 | YM | Futures | 9577.8 | 9586.3 | 9573.0 | 9579.7 | 159.0 |
| 2010-07-11 21:30:00 | YM | Futures | 9578.7 | 9583.4 | 9567.4 | 9568.3 | 175.0 |
| 2010-07-11 22:00:00 | YM | Futures | 9567.4 | 9583.4 | 9566.4 | 9579.7 | 210.0 |
| 2010-07-11 22:30:00 | YM | Futures | 9579.7 | 9579.7 | 9573.0 | 9576.8 | 133.0 |
| 2010-07-11 23:00:00 | YM | Futures | 9576.8 | 9581.6 | 9573.0 | 9575.9 | 134.0 |
| 2010-07-11 23:30:00 | YM | Futures | 9575.9 | 9579.7 | 9575.9 | 9579.7 | 45.0 |
| 2010-07-11 18:00:00 | CL | Futures | 147.3 | 147.39 | 146.97 | 147.16 | 540.0 |
| 2010-07-11 18:30:00 | CL | Futures | 147.16 | 147.26 | 147.06 | 147.22 | 107.0 |
| 2010-07-11 19:00:00 | CL | Futures | 147.18 | 147.28 | 147.05 | 147.2 | 83.0 |
| 2010-07-11 19:30:00 | CL | Futures | 147.2 | 147.24 | 147.03 | 147.12 | 92.0 |
| 2010-07-11 20:00:00 | CL | Futures | 147.18 | 147.45 | 147.1 | 147.35 | 198.0 |
| 2010-07-11 20:30:00 | CL | Futures | 147.34 | 147.55 | 147.1 | 147.28 | 223.0 |
| 2010-07-11 21:00:00 | CL | Futures | 147.2 | 147.45 | 147.01 | 147.24 | 239.0 |
| 2010-07-11 21:30:00 | CL | Futures | 147.2 | 147.32 | 146.89 | 146.89 | 256.0 |
| 2010-07-11 22:00:00 | CL | Futures | 146.91 | 147.03 | 146.74 | 146.83 | 398.0 |
| 2010-07-11 22:30:00 | CL | Futures | 146.87 | 146.87 | 146.52 | 146.81 | 211.0 |
| 2010-07-11 23:00:00 | CL | Futures | 146.83 | 147.08 | 146.83 | 146.97 | 132.0 |
| 2010-07-11 23:30:00 | CL | Futures | 147.03 | 147.06 | 146.95 | 147.03 | 54.0 |
| 2010-07-11 18:00:00 | GC | Futures | 1701.5 | 1703.1 | 1700.6 | 1701.5 | 497.0 |
| 2010-07-11 18:30:00 | GC | Futures | 1701.5 | 1701.6 | 1699.6 | 1700.3 | 132.0 |
> showing 50 of 406 rows — these rows as CSV