PREVIEW / futures_30min / 2008-09-14
file: by_date/futures_30min/2008/2008-09-14.parquet size: 21 KB rows: 491
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-14 18:00:00 | ES | Futures | 1169.05 | 1169.05 | 1150.59 | 1156.74 | 60358.0 |
| 2008-09-14 18:30:00 | ES | Futures | 1156.74 | 1159.35 | 1152.96 | 1153.67 | 27905.0 |
| 2008-09-14 19:00:00 | ES | Futures | 1153.43 | 1167.16 | 1152.48 | 1165.5 | 27945.0 |
| 2008-09-14 19:30:00 | ES | Futures | 1165.26 | 1165.26 | 1160.77 | 1161.24 | 12692.0 |
| 2008-09-14 20:00:00 | ES | Futures | 1161.48 | 1162.66 | 1156.98 | 1157.22 | 8357.0 |
| 2008-09-14 20:30:00 | ES | Futures | 1157.22 | 1165.5 | 1155.32 | 1164.32 | 16556.0 |
| 2008-09-14 21:00:00 | ES | Futures | 1164.55 | 1164.79 | 1154.38 | 1158.87 | 17619.0 |
| 2008-09-14 21:30:00 | ES | Futures | 1158.64 | 1160.06 | 1154.38 | 1155.32 | 10864.0 |
| 2008-09-14 22:00:00 | ES | Futures | 1155.09 | 1158.64 | 1153.43 | 1153.43 | 9172.0 |
| 2008-09-14 22:30:00 | ES | Futures | 1153.67 | 1154.38 | 1150.12 | 1150.83 | 8187.0 |
| 2008-09-14 23:00:00 | ES | Futures | 1151.06 | 1152.48 | 1146.09 | 1149.41 | 11172.0 |
| 2008-09-14 23:30:00 | ES | Futures | 1149.41 | 1149.88 | 1146.33 | 1147.75 | 4413.0 |
| 2008-09-14 18:00:00 | NQ | Futures | 1996.31 | 1996.31 | 1954.15 | 1966.31 | 2377.0 |
| 2008-09-14 18:30:00 | NQ | Futures | 1966.6 | 1968.01 | 1961.79 | 1961.79 | 491.0 |
| 2008-09-14 19:00:00 | NQ | Futures | 1961.79 | 1980.46 | 1961.5 | 1977.63 | 833.0 |
| 2008-09-14 19:30:00 | NQ | Futures | 1975.08 | 1975.37 | 1968.58 | 1968.58 | 972.0 |
| 2008-09-14 20:00:00 | NQ | Futures | 1969.71 | 1971.12 | 1966.03 | 1966.88 | 393.0 |
| 2008-09-14 20:30:00 | NQ | Futures | 1967.44 | 1974.8 | 1963.77 | 1974.52 | 584.0 |
| 2008-09-14 21:00:00 | NQ | Futures | 1972.82 | 1972.82 | 1964.9 | 1969.71 | 680.0 |
| 2008-09-14 21:30:00 | NQ | Futures | 1969.14 | 1970.56 | 1962.63 | 1964.33 | 362.0 |
| 2008-09-14 22:00:00 | NQ | Futures | 1964.33 | 1969.43 | 1962.35 | 1962.35 | 372.0 |
| 2008-09-14 22:30:00 | NQ | Futures | 1962.35 | 1963.2 | 1959.24 | 1959.24 | 437.0 |
| 2008-09-14 23:00:00 | NQ | Futures | 1959.24 | 1961.5 | 1956.69 | 1960.37 | 570.0 |
| 2008-09-14 23:30:00 | NQ | Futures | 1960.65 | 1962.35 | 1954.71 | 1956.97 | 580.0 |
| 2008-09-14 18:00:00 | YM | Futures | 10249.4 | 10263.9 | 10114.8 | 10155.7 | 1463.0 |
| 2008-09-14 18:30:00 | YM | Futures | 10159.3 | 10173.9 | 10129.3 | 10135.7 | 514.0 |
| 2008-09-14 19:00:00 | YM | Futures | 10134.8 | 10239.4 | 10128.4 | 10229.4 | 671.0 |
| 2008-09-14 19:30:00 | YM | Futures | 10223.0 | 10223.0 | 10169.3 | 10175.7 | 664.0 |
| 2008-09-14 20:00:00 | YM | Futures | 10174.8 | 10189.3 | 10155.7 | 10160.2 | 299.0 |
| 2008-09-14 20:30:00 | YM | Futures | 10157.5 | 10209.3 | 10124.8 | 10202.1 | 731.0 |
| 2008-09-14 21:00:00 | YM | Futures | 10203.9 | 10203.9 | 10132.0 | 10167.5 | 781.0 |
| 2008-09-14 21:30:00 | YM | Futures | 10169.3 | 10176.6 | 10141.1 | 10146.6 | 370.0 |
| 2008-09-14 22:00:00 | YM | Futures | 10147.5 | 10172.1 | 10136.6 | 10136.6 | 381.0 |
| 2008-09-14 22:30:00 | YM | Futures | 10136.6 | 10143.0 | 10118.4 | 10120.2 | 482.0 |
| 2008-09-14 23:00:00 | YM | Futures | 10122.0 | 10132.9 | 10090.2 | 10115.7 | 678.0 |
| 2008-09-14 23:30:00 | YM | Futures | 10115.7 | 10120.2 | 10091.1 | 10108.4 | 487.0 |
| 2008-09-14 10:00:00 | CL | Futures | 382.06 | 382.06 | 375.46 | 375.99 | 434.0 |
| 2008-09-14 10:30:00 | CL | Futures | 375.99 | 376.63 | 375.35 | 376.41 | 40.0 |
| 2008-09-14 11:00:00 | CL | Futures | 376.75 | 376.75 | 375.05 | 375.05 | 82.0 |
| 2008-09-14 11:30:00 | CL | Futures | 374.97 | 375.46 | 374.63 | 375.09 | 69.0 |
| 2008-09-14 12:00:00 | CL | Futures | 375.2 | 375.24 | 373.69 | 373.77 | 130.0 |
| 2008-09-14 12:30:00 | CL | Futures | 373.47 | 374.52 | 372.56 | 374.52 | 130.0 |
| 2008-09-14 13:00:00 | CL | Futures | 374.11 | 374.86 | 374.11 | 374.52 | 100.0 |
| 2008-09-14 13:30:00 | CL | Futures | 374.07 | 374.82 | 373.24 | 373.24 | 43.0 |
| 2008-09-14 14:00:00 | CL | Futures | 374.07 | 374.63 | 374.07 | 374.52 | 9.0 |
| 2008-09-14 14:30:00 | CL | Futures | 374.52 | 374.86 | 374.18 | 374.52 | 240.0 |
| 2008-09-14 15:00:00 | CL | Futures | 374.3 | 375.28 | 373.77 | 373.77 | 30.0 |
| 2008-09-14 15:30:00 | CL | Futures | 373.96 | 373.96 | 372.52 | 372.6 | 28.0 |
| 2008-09-14 16:00:00 | CL | Futures | 373.88 | 375.2 | 373.88 | 374.79 | 50.0 |
| 2008-09-14 16:30:00 | CL | Futures | 374.45 | 374.82 | 373.88 | 374.82 | 11.0 |
> showing 50 of 491 rows — these rows as CSV