PREVIEW / futures_30min / 2008-03-07
file: by_date/futures_30min/2008/2008-03-07.parquet size: 57 KB rows: 1,859
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-03-07 00:00:00 | ES | Futures | 1220.81 | 1221.04 | 1218.94 | 1219.64 | 950.0 |
| 2008-03-07 00:30:00 | ES | Futures | 1219.41 | 1220.34 | 1218.94 | 1219.64 | 993.0 |
| 2008-03-07 01:00:00 | ES | Futures | 1219.87 | 1220.11 | 1219.17 | 1219.87 | 458.0 |
| 2008-03-07 01:30:00 | ES | Futures | 1220.11 | 1220.11 | 1218.47 | 1218.47 | 875.0 |
| 2008-03-07 02:00:00 | ES | Futures | 1218.71 | 1218.94 | 1217.08 | 1217.54 | 4776.0 |
| 2008-03-07 02:30:00 | ES | Futures | 1217.54 | 1219.41 | 1217.08 | 1218.71 | 4766.0 |
| 2008-03-07 03:00:00 | ES | Futures | 1218.71 | 1219.87 | 1216.38 | 1218.01 | 14862.0 |
| 2008-03-07 03:30:00 | ES | Futures | 1218.01 | 1218.24 | 1211.71 | 1212.88 | 20781.0 |
| 2008-03-07 04:00:00 | ES | Futures | 1212.88 | 1215.21 | 1211.48 | 1214.51 | 13733.0 |
| 2008-03-07 04:30:00 | ES | Futures | 1214.28 | 1215.21 | 1213.58 | 1213.81 | 8831.0 |
| 2008-03-07 05:00:00 | ES | Futures | 1213.58 | 1217.08 | 1213.34 | 1216.61 | 9611.0 |
| 2008-03-07 05:30:00 | ES | Futures | 1216.61 | 1216.61 | 1215.21 | 1215.91 | 7826.0 |
| 2008-03-07 06:00:00 | ES | Futures | 1215.91 | 1217.08 | 1214.51 | 1215.68 | 9177.0 |
| 2008-03-07 06:30:00 | ES | Futures | 1215.91 | 1216.14 | 1214.51 | 1215.68 | 10176.0 |
| 2008-03-07 07:00:00 | ES | Futures | 1215.68 | 1222.44 | 1215.68 | 1221.74 | 32713.0 |
| 2008-03-07 07:30:00 | ES | Futures | 1221.74 | 1222.9 | 1220.81 | 1222.2 | 21448.0 |
| 2008-03-07 08:00:00 | ES | Futures | 1221.97 | 1229.67 | 1209.85 | 1216.14 | 123300.0 |
| 2008-03-07 08:30:00 | ES | Futures | 1217.08 | 1217.08 | 1201.22 | 1208.91 | 176074.0 |
| 2008-03-07 09:00:00 | ES | Futures | 1208.91 | 1209.15 | 1204.25 | 1207.05 | 50068.0 |
| 2008-03-07 09:30:00 | ES | Futures | 1206.82 | 1221.27 | 1204.25 | 1219.64 | 368401.0 |
| 2008-03-07 10:00:00 | ES | Futures | 1219.64 | 1222.9 | 1214.28 | 1218.71 | 272689.0 |
| 2008-03-07 10:30:00 | ES | Futures | 1218.71 | 1225.94 | 1217.54 | 1218.47 | 210807.0 |
| 2008-03-07 11:00:00 | ES | Futures | 1218.47 | 1218.94 | 1211.71 | 1211.95 | 179636.0 |
| 2008-03-07 11:30:00 | ES | Futures | 1211.95 | 1215.68 | 1208.91 | 1210.78 | 165846.0 |
| 2008-03-07 12:00:00 | ES | Futures | 1210.78 | 1211.48 | 1206.82 | 1208.91 | 112619.0 |
| 2008-03-07 12:30:00 | ES | Futures | 1208.91 | 1211.71 | 1206.35 | 1210.78 | 80134.0 |
| 2008-03-07 13:00:00 | ES | Futures | 1210.78 | 1210.78 | 1205.42 | 1208.22 | 73952.0 |
| 2008-03-07 13:30:00 | ES | Futures | 1207.98 | 1208.45 | 1200.75 | 1201.69 | 135093.0 |
| 2008-03-07 14:00:00 | ES | Futures | 1201.92 | 1204.02 | 1196.79 | 1199.36 | 214395.0 |
| 2008-03-07 14:30:00 | ES | Futures | 1199.36 | 1206.82 | 1196.09 | 1206.82 | 60047.0 |
| 2008-03-07 15:00:00 | ES | Futures | 1206.12 | 1214.98 | 1201.69 | 1209.15 | 204895.0 |
| 2008-03-07 15:30:00 | ES | Futures | 1209.38 | 1211.95 | 1203.79 | 1206.82 | 222015.0 |
| 2008-03-07 16:00:00 | ES | Futures | 1206.82 | 1207.75 | 1204.95 | 1205.65 | 72239.0 |
| 2008-03-07 00:00:00 | NQ | Futures | 1949.44 | 1949.44 | 1946.32 | 1947.45 | 34.0 |
| 2008-03-07 00:30:00 | NQ | Futures | 1948.3 | 1949.72 | 1947.17 | 1947.45 | 52.0 |
| 2008-03-07 01:00:00 | NQ | Futures | 1949.15 | 1951.14 | 1949.15 | 1949.72 | 21.0 |
| 2008-03-07 01:30:00 | NQ | Futures | 1949.15 | 1949.44 | 1947.74 | 1947.74 | 12.0 |
| 2008-03-07 02:00:00 | NQ | Futures | 1947.74 | 1948.3 | 1943.76 | 1945.46 | 110.0 |
| 2008-03-07 02:30:00 | NQ | Futures | 1944.33 | 1947.45 | 1944.05 | 1946.03 | 80.0 |
| 2008-03-07 03:00:00 | NQ | Futures | 1947.17 | 1949.15 | 1942.34 | 1945.46 | 703.0 |
| 2008-03-07 03:30:00 | NQ | Futures | 1945.75 | 1946.32 | 1935.81 | 1937.23 | 907.0 |
| 2008-03-07 04:00:00 | NQ | Futures | 1937.23 | 1940.92 | 1935.53 | 1938.37 | 1201.0 |
| 2008-03-07 04:30:00 | NQ | Futures | 1938.37 | 1940.36 | 1936.1 | 1937.52 | 647.0 |
| 2008-03-07 05:00:00 | NQ | Futures | 1936.95 | 1944.33 | 1936.38 | 1942.06 | 504.0 |
| 2008-03-07 05:30:00 | NQ | Futures | 1942.06 | 1942.34 | 1938.94 | 1940.36 | 543.0 |
| 2008-03-07 06:00:00 | NQ | Futures | 1940.36 | 1943.19 | 1939.79 | 1942.34 | 528.0 |
| 2008-03-07 06:30:00 | NQ | Futures | 1941.77 | 1943.19 | 1940.64 | 1943.19 | 378.0 |
| 2008-03-07 07:00:00 | NQ | Futures | 1943.48 | 1953.7 | 1943.48 | 1951.99 | 1832.0 |
| 2008-03-07 07:30:00 | NQ | Futures | 1951.99 | 1953.41 | 1950.86 | 1952.28 | 1354.0 |
| 2008-03-07 08:00:00 | NQ | Futures | 1952.28 | 1965.9 | 1937.8 | 1948.3 | 12445.0 |
> showing 50 of 1,859 rows — these rows as CSV