PREVIEW / futures_30min / 2009-09-20
file: by_date/futures_30min/2009/2009-09-20.parquet size: 16 KB rows: 377
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-20 18:00:00 | ES | Futures | 1026.29 | 1026.78 | 1024.6 | 1025.32 | 5027.0 |
| 2009-09-20 18:30:00 | ES | Futures | 1025.57 | 1026.54 | 1025.32 | 1026.05 | 1067.0 |
| 2009-09-20 19:00:00 | ES | Futures | 1026.05 | 1027.02 | 1025.81 | 1026.29 | 1006.0 |
| 2009-09-20 19:30:00 | ES | Futures | 1026.29 | 1027.5 | 1026.29 | 1027.02 | 1161.0 |
| 2009-09-20 20:00:00 | ES | Futures | 1026.78 | 1027.75 | 1026.78 | 1027.5 | 908.0 |
| 2009-09-20 20:30:00 | ES | Futures | 1027.5 | 1027.75 | 1026.78 | 1026.78 | 1146.0 |
| 2009-09-20 21:00:00 | ES | Futures | 1026.78 | 1026.78 | 1025.81 | 1026.05 | 1348.0 |
| 2009-09-20 21:30:00 | ES | Futures | 1026.29 | 1026.29 | 1025.32 | 1025.81 | 1232.0 |
| 2009-09-20 22:00:00 | ES | Futures | 1026.05 | 1027.5 | 1026.05 | 1026.05 | 1898.0 |
| 2009-09-20 22:30:00 | ES | Futures | 1026.05 | 1026.29 | 1025.32 | 1026.05 | 1258.0 |
| 2009-09-20 23:00:00 | ES | Futures | 1026.05 | 1026.29 | 1025.08 | 1025.57 | 1325.0 |
| 2009-09-20 23:30:00 | ES | Futures | 1025.57 | 1025.81 | 1024.84 | 1025.08 | 858.0 |
| 2009-09-20 18:00:00 | NQ | Futures | 1959.0 | 1960.42 | 1956.72 | 1958.14 | 627.0 |
| 2009-09-20 18:30:00 | NQ | Futures | 1957.86 | 1961.28 | 1957.57 | 1959.85 | 230.0 |
| 2009-09-20 19:00:00 | NQ | Futures | 1959.85 | 1961.0 | 1959.85 | 1959.85 | 126.0 |
| 2009-09-20 19:30:00 | NQ | Futures | 1960.14 | 1962.42 | 1960.14 | 1960.71 | 203.0 |
| 2009-09-20 20:00:00 | NQ | Futures | 1960.71 | 1962.14 | 1960.42 | 1961.85 | 278.0 |
| 2009-09-20 20:30:00 | NQ | Futures | 1961.85 | 1962.14 | 1960.71 | 1960.71 | 95.0 |
| 2009-09-20 21:00:00 | NQ | Futures | 1960.71 | 1960.71 | 1959.0 | 1959.57 | 105.0 |
| 2009-09-20 21:30:00 | NQ | Futures | 1959.57 | 1959.57 | 1958.14 | 1958.71 | 117.0 |
| 2009-09-20 22:00:00 | NQ | Futures | 1959.0 | 1961.28 | 1959.0 | 1959.0 | 166.0 |
| 2009-09-20 22:30:00 | NQ | Futures | 1959.0 | 1959.57 | 1957.86 | 1959.0 | 79.0 |
| 2009-09-20 23:00:00 | NQ | Futures | 1959.28 | 1959.57 | 1956.72 | 1957.86 | 423.0 |
| 2009-09-20 23:30:00 | NQ | Futures | 1958.14 | 1958.43 | 1956.15 | 1956.43 | 65.0 |
| 2009-09-20 18:00:00 | YM | Futures | 9037.7 | 9047.0 | 9026.5 | 9034.0 | 242.0 |
| 2009-09-20 18:30:00 | YM | Futures | 9036.7 | 9040.5 | 9036.7 | 9037.7 | 37.0 |
| 2009-09-20 19:00:00 | YM | Futures | 9036.7 | 9045.1 | 9036.7 | 9043.3 | 27.0 |
| 2009-09-20 19:30:00 | YM | Futures | 9043.3 | 9052.6 | 9043.3 | 9048.8 | 96.0 |
| 2009-09-20 20:00:00 | YM | Futures | 9047.0 | 9051.6 | 9047.0 | 9051.6 | 67.0 |
| 2009-09-20 20:30:00 | YM | Futures | 9052.6 | 9052.6 | 9044.2 | 9045.1 | 120.0 |
| 2009-09-20 21:00:00 | YM | Futures | 9045.1 | 9045.1 | 9038.6 | 9039.5 | 73.0 |
| 2009-09-20 21:30:00 | YM | Futures | 9039.5 | 9040.5 | 9034.9 | 9037.7 | 68.0 |
| 2009-09-20 22:00:00 | YM | Futures | 9042.3 | 9050.7 | 9040.5 | 9041.4 | 151.0 |
| 2009-09-20 22:30:00 | YM | Futures | 9041.4 | 9044.2 | 9034.9 | 9041.4 | 97.0 |
| 2009-09-20 23:00:00 | YM | Futures | 9041.4 | 9044.2 | 9034.0 | 9038.6 | 108.0 |
| 2009-09-20 23:30:00 | YM | Futures | 9038.6 | 9040.5 | 9032.1 | 9034.0 | 108.0 |
| 2009-09-20 18:00:00 | CL | Futures | 162.41 | 162.61 | 161.93 | 162.58 | 335.0 |
| 2009-09-20 18:30:00 | CL | Futures | 162.54 | 162.56 | 162.18 | 162.5 | 88.0 |
| 2009-09-20 19:00:00 | CL | Futures | 162.5 | 162.67 | 162.32 | 162.58 | 77.0 |
| 2009-09-20 19:30:00 | CL | Futures | 162.63 | 162.92 | 162.58 | 162.76 | 145.0 |
| 2009-09-20 20:00:00 | CL | Futures | 162.81 | 163.35 | 162.76 | 163.08 | 258.0 |
| 2009-09-20 20:30:00 | CL | Futures | 163.12 | 163.39 | 162.88 | 162.94 | 160.0 |
| 2009-09-20 21:00:00 | CL | Futures | 162.92 | 163.01 | 162.88 | 162.9 | 59.0 |
| 2009-09-20 21:30:00 | CL | Futures | 162.9 | 162.92 | 162.38 | 162.63 | 183.0 |
| 2009-09-20 22:00:00 | CL | Futures | 162.65 | 162.79 | 162.41 | 162.41 | 145.0 |
| 2009-09-20 22:30:00 | CL | Futures | 162.41 | 162.54 | 162.05 | 162.14 | 189.0 |
| 2009-09-20 23:00:00 | CL | Futures | 162.14 | 162.36 | 162.05 | 162.34 | 153.0 |
| 2009-09-20 23:30:00 | CL | Futures | 162.45 | 162.61 | 162.11 | 162.16 | 170.0 |
| 2009-09-20 18:00:00 | GC | Futures | 1421.2 | 1421.4 | 1418.2 | 1418.9 | 1196.0 |
| 2009-09-20 18:30:00 | GC | Futures | 1418.9 | 1419.2 | 1418.3 | 1418.5 | 303.0 |
> showing 50 of 377 rows — these rows as CSV