PREVIEW / futures_30min / 2010-06-13
file: by_date/futures_30min/2010/2010-06-13.parquet size: 17 KB rows: 437
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-06-13 18:00:00 | ES | Futures | 1066.19 | 1069.36 | 1065.45 | 1067.9 | 1829.0 |
| 2010-06-13 18:30:00 | ES | Futures | 1067.65 | 1069.36 | 1067.41 | 1069.36 | 922.0 |
| 2010-06-13 19:00:00 | ES | Futures | 1069.12 | 1071.08 | 1068.88 | 1069.61 | 1722.0 |
| 2010-06-13 19:30:00 | ES | Futures | 1069.85 | 1070.83 | 1069.12 | 1070.83 | 1045.0 |
| 2010-06-13 20:00:00 | ES | Futures | 1070.34 | 1070.83 | 1069.36 | 1070.59 | 622.0 |
| 2010-06-13 20:30:00 | ES | Futures | 1070.59 | 1070.83 | 1069.85 | 1070.34 | 571.0 |
| 2010-06-13 21:00:00 | ES | Futures | 1070.34 | 1070.59 | 1069.12 | 1069.36 | 578.0 |
| 2010-06-13 21:30:00 | ES | Futures | 1069.12 | 1070.59 | 1068.88 | 1069.12 | 717.0 |
| 2010-06-13 22:00:00 | ES | Futures | 1068.88 | 1069.61 | 1068.88 | 1069.12 | 597.0 |
| 2010-06-13 22:30:00 | ES | Futures | 1069.12 | 1069.61 | 1068.39 | 1069.61 | 813.0 |
| 2010-06-13 23:00:00 | ES | Futures | 1069.36 | 1070.34 | 1069.36 | 1070.1 | 433.0 |
| 2010-06-13 23:30:00 | ES | Futures | 1070.1 | 1070.83 | 1069.12 | 1069.61 | 702.0 |
| 2010-06-13 18:00:00 | NQ | Futures | 2116.87 | 2150.94 | 2113.72 | 2118.87 | 178.0 |
| 2010-06-13 18:30:00 | NQ | Futures | 2120.3 | 2121.73 | 2120.3 | 2121.73 | 26.0 |
| 2010-06-13 19:00:00 | NQ | Futures | 2122.02 | 2125.46 | 2122.02 | 2122.88 | 50.0 |
| 2010-06-13 19:30:00 | NQ | Futures | 2123.74 | 2124.6 | 2121.45 | 2124.6 | 22.0 |
| 2010-06-13 20:00:00 | NQ | Futures | 2124.03 | 2124.31 | 2122.02 | 2123.74 | 20.0 |
| 2010-06-13 20:30:00 | NQ | Futures | 2123.74 | 2123.74 | 2122.31 | 2122.88 | 14.0 |
| 2010-06-13 21:00:00 | NQ | Futures | 2122.59 | 2122.88 | 2120.59 | 2120.88 | 18.0 |
| 2010-06-13 21:30:00 | NQ | Futures | 2120.59 | 2123.45 | 2120.3 | 2121.45 | 17.0 |
| 2010-06-13 22:00:00 | NQ | Futures | 2121.16 | 2121.73 | 2120.59 | 2120.59 | 75.0 |
| 2010-06-13 22:30:00 | NQ | Futures | 2121.73 | 2122.02 | 2121.73 | 2122.02 | 11.0 |
| 2010-06-13 23:00:00 | NQ | Futures | 2122.59 | 2123.45 | 2122.59 | 2123.17 | 31.0 |
| 2010-06-13 23:30:00 | NQ | Futures | 2123.74 | 2124.03 | 2121.16 | 2121.16 | 12.0 |
| 2010-06-13 18:00:00 | YM | Futures | 9609.0 | 9655.4 | 9602.4 | 9621.3 | 321.0 |
| 2010-06-13 18:30:00 | YM | Futures | 9619.4 | 9633.6 | 9616.6 | 9629.8 | 204.0 |
| 2010-06-13 19:00:00 | YM | Futures | 9629.8 | 9645.9 | 9629.8 | 9634.6 | 427.0 |
| 2010-06-13 19:30:00 | YM | Futures | 9636.5 | 9644.0 | 9631.7 | 9644.0 | 205.0 |
| 2010-06-13 20:00:00 | YM | Futures | 9641.2 | 9643.1 | 9633.6 | 9640.2 | 267.0 |
| 2010-06-13 20:30:00 | YM | Futures | 9640.2 | 9643.1 | 9636.5 | 9641.2 | 133.0 |
| 2010-06-13 21:00:00 | YM | Futures | 9637.4 | 9641.2 | 9629.8 | 9629.8 | 96.0 |
| 2010-06-13 21:30:00 | YM | Futures | 9629.8 | 9641.2 | 9628.9 | 9630.8 | 156.0 |
| 2010-06-13 22:00:00 | YM | Futures | 9629.8 | 9633.6 | 9627.0 | 9628.9 | 124.0 |
| 2010-06-13 22:30:00 | YM | Futures | 9628.9 | 9631.7 | 9622.3 | 9631.7 | 157.0 |
| 2010-06-13 23:00:00 | YM | Futures | 9631.7 | 9638.3 | 9631.7 | 9637.4 | 137.0 |
| 2010-06-13 23:30:00 | YM | Futures | 9637.4 | 9641.2 | 9627.9 | 9632.7 | 144.0 |
| 2010-06-13 18:00:00 | CL | Futures | 145.93 | 146.43 | 145.89 | 146.22 | 57.0 |
| 2010-06-13 18:30:00 | CL | Futures | 146.33 | 146.37 | 146.25 | 146.33 | 73.0 |
| 2010-06-13 19:00:00 | CL | Futures | 146.31 | 146.79 | 146.31 | 146.54 | 208.0 |
| 2010-06-13 19:30:00 | CL | Futures | 146.49 | 146.93 | 146.45 | 146.93 | 62.0 |
| 2010-06-13 20:00:00 | CL | Futures | 146.93 | 146.95 | 146.56 | 146.7 | 156.0 |
| 2010-06-13 20:30:00 | CL | Futures | 146.72 | 146.78 | 146.62 | 146.72 | 69.0 |
| 2010-06-13 21:00:00 | CL | Futures | 146.72 | 146.78 | 146.49 | 146.56 | 44.0 |
| 2010-06-13 21:30:00 | CL | Futures | 146.74 | 146.91 | 146.68 | 146.72 | 115.0 |
| 2010-06-13 22:00:00 | CL | Futures | 146.74 | 146.87 | 146.64 | 146.81 | 81.0 |
| 2010-06-13 22:30:00 | CL | Futures | 146.76 | 146.81 | 146.7 | 146.79 | 12.0 |
| 2010-06-13 23:00:00 | CL | Futures | 146.79 | 146.95 | 146.79 | 146.95 | 61.0 |
| 2010-06-13 23:30:00 | CL | Futures | 146.95 | 146.97 | 146.78 | 146.83 | 15.0 |
| 2010-06-13 18:00:00 | GC | Futures | 1725.3 | 1731.2 | 1724.5 | 1730.8 | 556.0 |
| 2010-06-13 18:30:00 | GC | Futures | 1730.5 | 1730.7 | 1727.3 | 1729.2 | 220.0 |
> showing 50 of 437 rows — these rows as CSV