PREVIEW / futures_30min / 2008-03-16
file: by_date/futures_30min/2008/2008-03-16.parquet size: 21 KB rows: 464
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-16 18:00:00 | ES | Futures | 1201.01 | 1202.87 | 1196.82 | 1200.54 | 18997.0 |
| 2008-03-16 18:30:00 | ES | Futures | 1200.77 | 1207.06 | 1199.84 | 1205.66 | 18906.0 |
| 2008-03-16 19:00:00 | ES | Futures | 1205.43 | 1223.83 | 1197.05 | 1214.75 | 42912.0 |
| 2008-03-16 19:30:00 | ES | Futures | 1214.28 | 1216.38 | 1190.76 | 1191.23 | 31294.0 |
| 2008-03-16 20:00:00 | ES | Futures | 1191.23 | 1193.09 | 1183.08 | 1184.71 | 29725.0 |
| 2008-03-16 20:30:00 | ES | Futures | 1184.48 | 1190.76 | 1178.42 | 1184.71 | 24063.0 |
| 2008-03-16 21:00:00 | ES | Futures | 1184.24 | 1184.24 | 1178.19 | 1179.59 | 11215.0 |
| 2008-03-16 21:30:00 | ES | Futures | 1179.59 | 1180.28 | 1173.3 | 1174.93 | 18835.0 |
| 2008-03-16 22:00:00 | ES | Futures | 1175.16 | 1175.4 | 1167.48 | 1169.57 | 22853.0 |
| 2008-03-16 22:30:00 | ES | Futures | 1169.57 | 1173.07 | 1167.01 | 1170.51 | 10410.0 |
| 2008-03-16 23:00:00 | ES | Futures | 1170.74 | 1176.79 | 1168.64 | 1175.63 | 8723.0 |
| 2008-03-16 23:30:00 | ES | Futures | 1175.63 | 1177.96 | 1172.14 | 1176.56 | 7472.0 |
| 2008-03-16 18:00:00 | NQ | Futures | 1946.99 | 1947.84 | 1937.94 | 1944.73 | 899.0 |
| 2008-03-16 18:30:00 | NQ | Futures | 1945.3 | 1956.04 | 1943.03 | 1951.8 | 937.0 |
| 2008-03-16 19:00:00 | NQ | Futures | 1952.37 | 1985.46 | 1941.34 | 1967.92 | 2243.0 |
| 2008-03-16 19:30:00 | NQ | Futures | 1967.92 | 1969.9 | 1929.17 | 1930.02 | 1382.0 |
| 2008-03-16 20:00:00 | NQ | Futures | 1929.74 | 1932.0 | 1911.36 | 1917.01 | 1406.0 |
| 2008-03-16 20:30:00 | NQ | Futures | 1916.45 | 1925.21 | 1905.13 | 1916.73 | 853.0 |
| 2008-03-16 21:00:00 | NQ | Futures | 1913.62 | 1914.47 | 1909.09 | 1910.79 | 324.0 |
| 2008-03-16 21:30:00 | NQ | Futures | 1911.64 | 1911.64 | 1902.87 | 1907.68 | 537.0 |
| 2008-03-16 22:00:00 | NQ | Futures | 1907.68 | 1910.22 | 1898.06 | 1899.76 | 898.0 |
| 2008-03-16 22:30:00 | NQ | Futures | 1901.46 | 1906.83 | 1899.19 | 1903.72 | 524.0 |
| 2008-03-16 23:00:00 | NQ | Futures | 1902.31 | 1904.0 | 1894.39 | 1900.89 | 1235.0 |
| 2008-03-16 23:30:00 | NQ | Futures | 1900.89 | 1904.0 | 1894.95 | 1900.61 | 448.0 |
| 2008-03-16 18:00:00 | YM | Futures | 10882.0 | 10882.9 | 10826.6 | 10861.1 | 305.0 |
| 2008-03-16 18:30:00 | YM | Futures | 10859.3 | 10892.9 | 10841.1 | 10882.0 | 534.0 |
| 2008-03-16 19:00:00 | YM | Futures | 10882.0 | 11031.0 | 10841.1 | 10968.3 | 1385.0 |
| 2008-03-16 19:30:00 | YM | Futures | 10973.8 | 10973.8 | 10794.8 | 10803.9 | 979.0 |
| 2008-03-16 20:00:00 | YM | Futures | 10798.4 | 10809.3 | 10735.7 | 10742.1 | 912.0 |
| 2008-03-16 20:30:00 | YM | Futures | 10743.9 | 10782.1 | 10699.4 | 10748.4 | 1703.0 |
| 2008-03-16 21:00:00 | YM | Futures | 10736.6 | 10740.3 | 10700.3 | 10715.7 | 627.0 |
| 2008-03-16 21:30:00 | YM | Futures | 10713.9 | 10714.8 | 10667.6 | 10674.8 | 843.0 |
| 2008-03-16 22:00:00 | YM | Futures | 10678.5 | 10684.8 | 10604.9 | 10639.4 | 941.0 |
| 2008-03-16 22:30:00 | YM | Futures | 10633.0 | 10666.7 | 10623.0 | 10645.8 | 653.0 |
| 2008-03-16 23:00:00 | YM | Futures | 10648.5 | 10691.2 | 10635.8 | 10685.7 | 533.0 |
| 2008-03-16 23:30:00 | YM | Futures | 10685.7 | 10693.9 | 10660.3 | 10685.7 | 354.0 |
| 2008-03-16 18:00:00 | CL | Futures | 410.56 | 410.78 | 409.65 | 409.88 | 246.0 |
| 2008-03-16 18:30:00 | CL | Futures | 410.03 | 410.03 | 409.2 | 409.84 | 52.0 |
| 2008-03-16 19:00:00 | CL | Futures | 409.92 | 410.29 | 409.88 | 410.22 | 50.0 |
| 2008-03-16 19:30:00 | CL | Futures | 410.33 | 410.6 | 410.29 | 410.29 | 26.0 |
| 2008-03-16 20:00:00 | CL | Futures | 410.14 | 411.16 | 409.65 | 411.01 | 43.0 |
| 2008-03-16 20:30:00 | CL | Futures | 411.09 | 412.26 | 410.56 | 411.27 | 188.0 |
| 2008-03-16 21:00:00 | CL | Futures | 410.71 | 412.45 | 409.95 | 412.41 | 198.0 |
| 2008-03-16 21:30:00 | CL | Futures | 412.41 | 415.13 | 411.99 | 413.96 | 857.0 |
| 2008-03-16 22:00:00 | CL | Futures | 414.03 | 414.18 | 413.28 | 413.99 | 270.0 |
| 2008-03-16 22:30:00 | CL | Futures | 413.99 | 414.18 | 413.39 | 413.84 | 37.0 |
| 2008-03-16 23:00:00 | CL | Futures | 414.03 | 414.11 | 413.39 | 414.11 | 104.0 |
| 2008-03-16 23:30:00 | CL | Futures | 413.88 | 414.18 | 413.69 | 413.88 | 95.0 |
| 2008-03-16 18:00:00 | GC | Futures | 1462.3 | 1466.8 | 1458.7 | 1464.3 | 1001.0 |
| 2008-03-16 18:30:00 | GC | Futures | 1464.5 | 1465.9 | 1463.0 | 1463.9 | 242.0 |
> showing 50 of 464 rows — these rows as CSV