PREVIEW / futures_30min / 2008-09-19
file: by_date/futures_30min/2008/2008-09-19.parquet size: 63 KB rows: 1,888
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-19 00:00:00 | ES | Futures | 1167.87 | 1170.0 | 1167.63 | 1169.76 | 3598.0 |
| 2008-09-19 00:30:00 | ES | Futures | 1169.76 | 1170.47 | 1168.81 | 1170.23 | 3590.0 |
| 2008-09-19 01:00:00 | ES | Futures | 1170.0 | 1171.18 | 1168.81 | 1170.47 | 4273.0 |
| 2008-09-19 01:30:00 | ES | Futures | 1170.47 | 1171.18 | 1169.05 | 1169.29 | 6004.0 |
| 2008-09-19 02:00:00 | ES | Futures | 1169.29 | 1169.52 | 1165.26 | 1168.81 | 13487.0 |
| 2008-09-19 02:30:00 | ES | Futures | 1168.58 | 1175.68 | 1165.26 | 1174.97 | 32671.0 |
| 2008-09-19 03:00:00 | ES | Futures | 1175.2 | 1176.39 | 1167.16 | 1167.16 | 51024.0 |
| 2008-09-19 03:30:00 | ES | Futures | 1167.16 | 1170.94 | 1166.21 | 1170.47 | 28573.0 |
| 2008-09-19 04:00:00 | ES | Futures | 1170.23 | 1171.65 | 1166.45 | 1169.05 | 20699.0 |
| 2008-09-19 04:30:00 | ES | Futures | 1169.05 | 1176.15 | 1168.58 | 1175.91 | 19956.0 |
| 2008-09-19 05:00:00 | ES | Futures | 1175.91 | 1178.28 | 1173.07 | 1177.33 | 25010.0 |
| 2008-09-19 05:30:00 | ES | Futures | 1177.33 | 1180.41 | 1176.39 | 1177.57 | 27692.0 |
| 2008-09-19 06:00:00 | ES | Futures | 1177.57 | 1181.59 | 1176.62 | 1180.41 | 20756.0 |
| 2008-09-19 06:30:00 | ES | Futures | 1180.17 | 1184.43 | 1178.52 | 1178.75 | 37848.0 |
| 2008-09-19 07:00:00 | ES | Futures | 1178.75 | 1180.65 | 1175.2 | 1176.62 | 29838.0 |
| 2008-09-19 07:30:00 | ES | Futures | 1176.62 | 1190.58 | 1176.39 | 1182.54 | 70863.0 |
| 2008-09-19 08:00:00 | ES | Futures | 1182.54 | 1188.45 | 1181.12 | 1186.32 | 43848.0 |
| 2008-09-19 08:30:00 | ES | Futures | 1186.32 | 1200.29 | 1186.32 | 1200.29 | 125887.0 |
| 2008-09-19 09:00:00 | ES | Futures | 1200.05 | 1200.29 | 1199.81 | 1200.29 | 27476.0 |
| 2008-09-19 09:30:00 | ES | Futures | 1200.29 | 1222.3 | 1183.96 | 1184.9 | 611552.0 |
| 2008-09-19 10:00:00 | ES | Futures | 1184.67 | 1187.74 | 1174.26 | 1177.1 | 395848.0 |
| 2008-09-19 10:30:00 | ES | Futures | 1177.1 | 1181.35 | 1171.42 | 1175.2 | 222016.0 |
| 2008-09-19 11:00:00 | ES | Futures | 1175.2 | 1187.74 | 1175.2 | 1181.83 | 228598.0 |
| 2008-09-19 11:30:00 | ES | Futures | 1181.83 | 1191.29 | 1178.99 | 1190.58 | 155086.0 |
| 2008-09-19 12:00:00 | ES | Futures | 1190.58 | 1197.45 | 1189.16 | 1197.21 | 133035.0 |
| 2008-09-19 12:30:00 | ES | Futures | 1197.21 | 1200.05 | 1191.06 | 1193.19 | 124690.0 |
| 2008-09-19 13:00:00 | ES | Futures | 1193.19 | 1193.9 | 1187.98 | 1191.77 | 94413.0 |
| 2008-09-19 13:30:00 | ES | Futures | 1191.77 | 1192.24 | 1184.43 | 1184.43 | 111716.0 |
| 2008-09-19 14:00:00 | ES | Futures | 1184.43 | 1185.61 | 1181.35 | 1184.9 | 142631.0 |
| 2008-09-19 14:30:00 | ES | Futures | 1184.9 | 1188.45 | 1181.83 | 1184.67 | 119552.0 |
| 2008-09-19 15:00:00 | ES | Futures | 1184.67 | 1187.27 | 1171.89 | 1180.17 | 243350.0 |
| 2008-09-19 15:30:00 | ES | Futures | 1179.94 | 1189.16 | 1174.49 | 1186.56 | 349324.0 |
| 2008-09-19 16:00:00 | ES | Futures | 1186.56 | 1186.8 | 1176.86 | 1180.17 | 179162.0 |
| 2008-09-19 00:00:00 | NQ | Futures | 1979.05 | 1979.33 | 1975.93 | 1978.76 | 224.0 |
| 2008-09-19 00:30:00 | NQ | Futures | 1979.05 | 1979.33 | 1977.07 | 1977.91 | 108.0 |
| 2008-09-19 01:00:00 | NQ | Futures | 1977.63 | 1978.48 | 1974.52 | 1977.35 | 147.0 |
| 2008-09-19 01:30:00 | NQ | Futures | 1976.22 | 1976.22 | 1970.27 | 1970.84 | 891.0 |
| 2008-09-19 02:00:00 | NQ | Futures | 1970.27 | 1972.82 | 1968.01 | 1972.82 | 692.0 |
| 2008-09-19 02:30:00 | NQ | Futures | 1972.82 | 1979.33 | 1968.58 | 1979.05 | 1017.0 |
| 2008-09-19 03:00:00 | NQ | Futures | 1979.33 | 1979.61 | 1965.18 | 1965.18 | 1916.0 |
| 2008-09-19 03:30:00 | NQ | Futures | 1964.9 | 1973.39 | 1964.05 | 1973.1 | 1581.0 |
| 2008-09-19 04:00:00 | NQ | Futures | 1973.39 | 1975.93 | 1966.03 | 1970.56 | 978.0 |
| 2008-09-19 04:30:00 | NQ | Futures | 1970.84 | 1979.61 | 1968.01 | 1979.05 | 1222.0 |
| 2008-09-19 05:00:00 | NQ | Futures | 1978.76 | 1983.01 | 1973.39 | 1980.18 | 1684.0 |
| 2008-09-19 05:30:00 | NQ | Futures | 1979.89 | 1982.72 | 1975.65 | 1977.91 | 1920.0 |
| 2008-09-19 06:00:00 | NQ | Futures | 1977.35 | 1981.88 | 1977.35 | 1979.89 | 839.0 |
| 2008-09-19 06:30:00 | NQ | Futures | 1980.18 | 1984.14 | 1975.93 | 1976.78 | 1067.0 |
| 2008-09-19 07:00:00 | NQ | Futures | 1977.07 | 1985.55 | 1970.27 | 1970.27 | 2323.0 |
| 2008-09-19 07:30:00 | NQ | Futures | 1969.99 | 1990.65 | 1969.43 | 1986.97 | 5112.0 |
| 2008-09-19 08:00:00 | NQ | Futures | 1986.4 | 2014.42 | 1986.4 | 2009.61 | 9663.0 |
> showing 50 of 1,888 rows — these rows as CSV