PREVIEW / futures_30min / 2010-10-24
file: by_date/futures_30min/2010/2010-10-24.parquet size: 20 KB rows: 502
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-24 18:00:00 | ES | Futures | 1164.12 | 1166.58 | 1164.12 | 1165.6 | 5507.0 |
| 2010-10-24 18:30:00 | ES | Futures | 1165.6 | 1165.6 | 1163.87 | 1164.12 | 2300.0 |
| 2010-10-24 19:00:00 | ES | Futures | 1164.12 | 1164.86 | 1163.87 | 1164.37 | 586.0 |
| 2010-10-24 19:30:00 | ES | Futures | 1164.61 | 1166.34 | 1164.37 | 1166.09 | 1739.0 |
| 2010-10-24 20:00:00 | ES | Futures | 1166.34 | 1167.57 | 1165.85 | 1166.58 | 4540.0 |
| 2010-10-24 20:30:00 | ES | Futures | 1166.83 | 1168.56 | 1166.58 | 1168.31 | 6177.0 |
| 2010-10-24 21:00:00 | ES | Futures | 1168.56 | 1168.56 | 1167.57 | 1167.57 | 2107.0 |
| 2010-10-24 21:30:00 | ES | Futures | 1167.82 | 1168.06 | 1166.58 | 1167.08 | 2747.0 |
| 2010-10-24 22:00:00 | ES | Futures | 1167.08 | 1168.31 | 1166.58 | 1168.06 | 2943.0 |
| 2010-10-24 22:30:00 | ES | Futures | 1168.31 | 1169.3 | 1168.06 | 1169.05 | 3430.0 |
| 2010-10-24 23:00:00 | ES | Futures | 1169.05 | 1169.79 | 1168.8 | 1169.3 | 5848.0 |
| 2010-10-24 23:30:00 | ES | Futures | 1169.3 | 1172.5 | 1169.05 | 1172.5 | 10428.0 |
| 2010-10-24 18:00:00 | NQ | Futures | 2414.57 | 2419.16 | 2413.42 | 2417.15 | 1162.0 |
| 2010-10-24 18:30:00 | NQ | Futures | 2416.58 | 2416.58 | 2412.56 | 2412.85 | 439.0 |
| 2010-10-24 19:00:00 | NQ | Futures | 2412.56 | 2414.0 | 2412.28 | 2413.14 | 82.0 |
| 2010-10-24 19:30:00 | NQ | Futures | 2413.71 | 2416.87 | 2413.71 | 2416.58 | 161.0 |
| 2010-10-24 20:00:00 | NQ | Futures | 2416.29 | 2419.16 | 2416.01 | 2417.73 | 348.0 |
| 2010-10-24 20:30:00 | NQ | Futures | 2418.01 | 2421.17 | 2417.73 | 2420.88 | 301.0 |
| 2010-10-24 21:00:00 | NQ | Futures | 2420.6 | 2421.46 | 2419.45 | 2419.45 | 143.0 |
| 2010-10-24 21:30:00 | NQ | Futures | 2419.16 | 2420.31 | 2417.44 | 2418.3 | 203.0 |
| 2010-10-24 22:00:00 | NQ | Futures | 2418.59 | 2421.17 | 2418.3 | 2420.88 | 352.0 |
| 2010-10-24 22:30:00 | NQ | Futures | 2421.17 | 2423.18 | 2420.88 | 2422.6 | 261.0 |
| 2010-10-24 23:00:00 | NQ | Futures | 2422.6 | 2424.33 | 2422.03 | 2424.04 | 184.0 |
| 2010-10-24 23:30:00 | NQ | Futures | 2423.47 | 2428.92 | 2423.18 | 2428.34 | 707.0 |
| 2010-10-24 18:00:00 | YM | Futures | 10566.8 | 10581.1 | 10563.9 | 10571.6 | 129.0 |
| 2010-10-24 18:30:00 | YM | Futures | 10577.3 | 10577.3 | 10562.0 | 10563.0 | 69.0 |
| 2010-10-24 19:00:00 | YM | Futures | 10565.8 | 10569.7 | 10560.1 | 10565.8 | 52.0 |
| 2010-10-24 19:30:00 | YM | Futures | 10567.8 | 10579.2 | 10565.8 | 10577.3 | 87.0 |
| 2010-10-24 20:00:00 | YM | Futures | 10579.2 | 10591.6 | 10576.3 | 10584.9 | 158.0 |
| 2010-10-24 20:30:00 | YM | Futures | 10585.9 | 10598.2 | 10583.9 | 10597.3 | 162.0 |
| 2010-10-24 21:00:00 | YM | Futures | 10596.3 | 10599.2 | 10591.6 | 10592.5 | 72.0 |
| 2010-10-24 21:30:00 | YM | Futures | 10591.6 | 10594.4 | 10584.9 | 10586.8 | 52.0 |
| 2010-10-24 22:00:00 | YM | Futures | 10587.8 | 10597.3 | 10586.8 | 10597.3 | 209.0 |
| 2010-10-24 22:30:00 | YM | Futures | 10598.2 | 10604.9 | 10597.3 | 10603.0 | 131.0 |
| 2010-10-24 23:00:00 | YM | Futures | 10603.0 | 10611.6 | 10602.0 | 10609.7 | 128.0 |
| 2010-10-24 23:30:00 | YM | Futures | 10607.8 | 10628.7 | 10605.9 | 10627.8 | 428.0 |
| 2010-10-24 18:00:00 | CL | Futures | 153.93 | 154.22 | 153.54 | 154.14 | 743.0 |
| 2010-10-24 18:30:00 | CL | Futures | 154.14 | 154.14 | 153.45 | 153.54 | 649.0 |
| 2010-10-24 19:00:00 | CL | Futures | 153.52 | 153.63 | 153.41 | 153.52 | 276.0 |
| 2010-10-24 19:30:00 | CL | Futures | 153.54 | 154.05 | 153.54 | 154.03 | 296.0 |
| 2010-10-24 20:00:00 | CL | Futures | 153.99 | 154.23 | 153.99 | 154.12 | 504.0 |
| 2010-10-24 20:30:00 | CL | Futures | 154.16 | 154.48 | 154.1 | 154.44 | 1192.0 |
| 2010-10-24 21:00:00 | CL | Futures | 154.42 | 154.48 | 154.35 | 154.4 | 477.0 |
| 2010-10-24 21:30:00 | CL | Futures | 154.38 | 154.57 | 154.35 | 154.38 | 620.0 |
| 2010-10-24 22:00:00 | CL | Futures | 154.38 | 154.76 | 154.33 | 154.68 | 533.0 |
| 2010-10-24 22:30:00 | CL | Futures | 154.68 | 154.8 | 154.46 | 154.76 | 601.0 |
| 2010-10-24 23:00:00 | CL | Futures | 154.76 | 154.85 | 154.68 | 154.8 | 940.0 |
| 2010-10-24 23:30:00 | CL | Futures | 154.78 | 154.85 | 154.5 | 154.8 | 640.0 |
| 2010-10-24 18:00:00 | GC | Futures | 1859.7 | 1869.5 | 1859.7 | 1867.0 | 2849.0 |
| 2010-10-24 18:30:00 | GC | Futures | 1867.2 | 1867.7 | 1863.8 | 1863.8 | 860.0 |
> showing 50 of 502 rows — these rows as CSV