PREVIEW / futures_30min / 2008-09-28
file: by_date/futures_30min/2008/2008-09-28.parquet size: 18 KB rows: 425
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-28 18:00:00 | ES | Futures | 1154.85 | 1156.03 | 1144.67 | 1148.22 | 28504.0 |
| 2008-09-28 18:30:00 | ES | Futures | 1148.22 | 1154.61 | 1147.75 | 1152.01 | 7805.0 |
| 2008-09-28 19:00:00 | ES | Futures | 1151.77 | 1154.14 | 1150.35 | 1151.3 | 3349.0 |
| 2008-09-28 19:30:00 | ES | Futures | 1151.06 | 1151.54 | 1147.75 | 1147.75 | 4137.0 |
| 2008-09-28 20:00:00 | ES | Futures | 1147.75 | 1153.67 | 1147.28 | 1153.19 | 6888.0 |
| 2008-09-28 20:30:00 | ES | Futures | 1153.19 | 1153.19 | 1151.3 | 1152.25 | 4202.0 |
| 2008-09-28 21:00:00 | ES | Futures | 1152.25 | 1152.72 | 1150.35 | 1150.59 | 2160.0 |
| 2008-09-28 21:30:00 | ES | Futures | 1150.59 | 1151.3 | 1146.33 | 1146.57 | 3774.0 |
| 2008-09-28 22:00:00 | ES | Futures | 1146.33 | 1146.57 | 1140.18 | 1141.6 | 6635.0 |
| 2008-09-28 22:30:00 | ES | Futures | 1141.36 | 1142.54 | 1139.23 | 1141.12 | 3428.0 |
| 2008-09-28 23:00:00 | ES | Futures | 1141.36 | 1142.78 | 1140.89 | 1142.07 | 1356.0 |
| 2008-09-28 23:30:00 | ES | Futures | 1142.07 | 1142.07 | 1140.18 | 1140.41 | 1484.0 |
| 2008-09-28 18:00:00 | NQ | Futures | 1902.36 | 1910.57 | 1891.04 | 1898.4 | 756.0 |
| 2008-09-28 18:30:00 | NQ | Futures | 1896.99 | 1905.48 | 1895.57 | 1904.06 | 331.0 |
| 2008-09-28 19:00:00 | NQ | Futures | 1903.21 | 1905.76 | 1898.97 | 1901.23 | 187.0 |
| 2008-09-28 19:30:00 | NQ | Futures | 1901.23 | 1901.23 | 1892.46 | 1893.59 | 185.0 |
| 2008-09-28 20:00:00 | NQ | Futures | 1893.59 | 1904.34 | 1893.59 | 1902.65 | 218.0 |
| 2008-09-28 20:30:00 | NQ | Futures | 1902.36 | 1902.93 | 1900.66 | 1900.95 | 136.0 |
| 2008-09-28 21:00:00 | NQ | Futures | 1900.95 | 1901.8 | 1898.97 | 1899.25 | 66.0 |
| 2008-09-28 21:30:00 | NQ | Futures | 1897.27 | 1898.12 | 1889.06 | 1890.2 | 235.0 |
| 2008-09-28 22:00:00 | NQ | Futures | 1889.06 | 1889.06 | 1880.57 | 1883.97 | 437.0 |
| 2008-09-28 22:30:00 | NQ | Futures | 1881.99 | 1885.67 | 1880.01 | 1882.27 | 181.0 |
| 2008-09-28 23:00:00 | NQ | Futures | 1882.27 | 1883.97 | 1882.27 | 1883.97 | 60.0 |
| 2008-09-28 23:30:00 | NQ | Futures | 1882.27 | 1882.84 | 1881.42 | 1881.42 | 21.0 |
| 2008-09-28 18:00:00 | YM | Futures | 10169.3 | 10185.7 | 10106.6 | 10132.9 | 1206.0 |
| 2008-09-28 18:30:00 | YM | Futures | 10133.9 | 10174.8 | 10128.4 | 10163.0 | 410.0 |
| 2008-09-28 19:00:00 | YM | Futures | 10162.1 | 10181.2 | 10154.8 | 10154.8 | 228.0 |
| 2008-09-28 19:30:00 | YM | Futures | 10157.5 | 10159.3 | 10129.3 | 10130.2 | 437.0 |
| 2008-09-28 20:00:00 | YM | Futures | 10130.2 | 10168.4 | 10124.8 | 10163.9 | 471.0 |
| 2008-09-28 20:30:00 | YM | Futures | 10165.7 | 10170.2 | 10159.3 | 10168.4 | 231.0 |
| 2008-09-28 21:00:00 | YM | Futures | 10166.6 | 10169.3 | 10153.9 | 10153.9 | 127.0 |
| 2008-09-28 21:30:00 | YM | Futures | 10155.7 | 10162.1 | 10122.0 | 10122.0 | 346.0 |
| 2008-09-28 22:00:00 | YM | Futures | 10122.9 | 10122.9 | 10056.5 | 10081.1 | 1035.0 |
| 2008-09-28 22:30:00 | YM | Futures | 10077.5 | 10090.2 | 10058.4 | 10073.8 | 289.0 |
| 2008-09-28 23:00:00 | YM | Futures | 10071.1 | 10092.0 | 10071.1 | 10085.7 | 142.0 |
| 2008-09-28 23:30:00 | YM | Futures | 10085.7 | 10086.6 | 10069.3 | 10072.0 | 98.0 |
| 2008-09-28 18:00:00 | CL | Futures | 403.15 | 403.22 | 399.41 | 400.47 | 677.0 |
| 2008-09-28 18:30:00 | CL | Futures | 400.39 | 401.79 | 400.36 | 400.43 | 202.0 |
| 2008-09-28 19:00:00 | CL | Futures | 400.43 | 401.45 | 400.39 | 401.07 | 109.0 |
| 2008-09-28 19:30:00 | CL | Futures | 401.22 | 401.38 | 400.43 | 401.38 | 117.0 |
| 2008-09-28 20:00:00 | CL | Futures | 401.38 | 402.24 | 400.77 | 400.77 | 198.0 |
| 2008-09-28 20:30:00 | CL | Futures | 400.81 | 401.04 | 400.17 | 400.32 | 165.0 |
| 2008-09-28 21:00:00 | CL | Futures | 400.21 | 400.85 | 399.79 | 399.9 | 148.0 |
| 2008-09-28 21:30:00 | CL | Futures | 399.98 | 400.58 | 399.9 | 400.21 | 113.0 |
| 2008-09-28 22:00:00 | CL | Futures | 400.06 | 400.21 | 398.36 | 399.23 | 339.0 |
| 2008-09-28 22:30:00 | CL | Futures | 399.04 | 399.38 | 398.77 | 399.15 | 80.0 |
| 2008-09-28 23:00:00 | CL | Futures | 399.23 | 399.53 | 399.04 | 399.34 | 76.0 |
| 2008-09-28 23:30:00 | CL | Futures | 399.34 | 399.41 | 398.81 | 398.81 | 76.0 |
| 2008-09-28 18:00:00 | GC | Futures | 1253.1 | 1263.1 | 1250.4 | 1251.8 | 1497.0 |
| 2008-09-28 18:30:00 | GC | Futures | 1252.5 | 1254.4 | 1250.8 | 1251.8 | 304.0 |
> showing 50 of 425 rows — these rows as CSV