PREVIEW / futures_1hour / 2021-12-15
file: by_date/futures_1hour/2021/2021-12-15.parquet size: 65 KB rows: 2,006
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-15 00:00:00 | ES | Futures | 5241.74 | 5246.83 | 5238.06 | 5242.59 | 7592.0 |
| 2021-12-15 01:00:00 | ES | Futures | 5242.87 | 5245.7 | 5232.69 | 5234.38 | 5888.0 |
| 2021-12-15 02:00:00 | ES | Futures | 5234.1 | 5241.17 | 5229.29 | 5237.49 | 9696.0 |
| 2021-12-15 03:00:00 | ES | Futures | 5237.21 | 5245.41 | 5236.08 | 5239.47 | 17032.0 |
| 2021-12-15 04:00:00 | ES | Futures | 5239.47 | 5241.17 | 5226.75 | 5232.4 | 14659.0 |
| 2021-12-15 05:00:00 | ES | Futures | 5232.4 | 5238.63 | 5230.42 | 5238.06 | 9939.0 |
| 2021-12-15 06:00:00 | ES | Futures | 5238.06 | 5238.91 | 5227.31 | 5232.12 | 12664.0 |
| 2021-12-15 07:00:00 | ES | Futures | 5232.12 | 5239.47 | 5232.12 | 5234.1 | 15396.0 |
| 2021-12-15 08:00:00 | ES | Futures | 5234.1 | 5242.59 | 5229.58 | 5234.38 | 31979.0 |
| 2021-12-15 09:00:00 | ES | Futures | 5234.1 | 5239.76 | 5213.17 | 5216.57 | 171463.0 |
| 2021-12-15 10:00:00 | ES | Futures | 5216.28 | 5230.71 | 5210.35 | 5221.38 | 174797.0 |
| 2021-12-15 11:00:00 | ES | Futures | 5221.09 | 5224.2 | 5206.1 | 5212.89 | 128320.0 |
| 2021-12-15 12:00:00 | ES | Futures | 5212.89 | 5223.07 | 5207.8 | 5221.94 | 89325.0 |
| 2021-12-15 13:00:00 | ES | Futures | 5221.94 | 5229.29 | 5217.98 | 5227.31 | 69698.0 |
| 2021-12-15 14:00:00 | ES | Futures | 5226.75 | 5263.8 | 5205.82 | 5251.35 | 449081.0 |
| 2021-12-15 15:00:00 | ES | Futures | 5251.63 | 5320.64 | 5250.79 | 5316.96 | 460159.0 |
| 2021-12-15 16:00:00 | ES | Futures | 5316.96 | 5323.18 | 5313.57 | 5319.51 | 68777.0 |
| 2021-12-15 18:00:00 | ES | Futures | 5319.79 | 5330.25 | 5318.38 | 5325.73 | 15973.0 |
| 2021-12-15 19:00:00 | ES | Futures | 5325.73 | 5325.73 | 5317.53 | 5320.64 | 11340.0 |
| 2021-12-15 20:00:00 | ES | Futures | 5320.64 | 5325.16 | 5313.29 | 5314.98 | 9527.0 |
| 2021-12-15 21:00:00 | ES | Futures | 5314.7 | 5323.18 | 5314.7 | 5320.92 | 7613.0 |
| 2021-12-15 22:00:00 | ES | Futures | 5320.92 | 5324.6 | 5319.79 | 5323.75 | 3323.0 |
| 2021-12-15 23:00:00 | ES | Futures | 5323.75 | 5328.56 | 5323.47 | 5328.56 | 6074.0 |
| 2021-12-15 00:00:00 | NQ | Futures | 18465.41 | 18494.1 | 18451.5 | 18486.86 | 3511.0 |
| 2021-12-15 01:00:00 | NQ | Futures | 18487.15 | 18500.19 | 18445.41 | 18454.98 | 4089.0 |
| 2021-12-15 02:00:00 | NQ | Futures | 18454.69 | 18492.36 | 18435.27 | 18474.39 | 5525.0 |
| 2021-12-15 03:00:00 | NQ | Futures | 18474.1 | 18503.96 | 18453.53 | 18470.05 | 9390.0 |
| 2021-12-15 04:00:00 | NQ | Futures | 18469.76 | 18474.68 | 18372.09 | 18406.58 | 11746.0 |
| 2021-12-15 05:00:00 | NQ | Futures | 18406.0 | 18433.53 | 18391.22 | 18430.92 | 5877.0 |
| 2021-12-15 06:00:00 | NQ | Futures | 18431.21 | 18435.56 | 18381.07 | 18412.37 | 6694.0 |
| 2021-12-15 07:00:00 | NQ | Futures | 18412.37 | 18457.3 | 18412.08 | 18432.95 | 10244.0 |
| 2021-12-15 08:00:00 | NQ | Futures | 18433.53 | 18511.2 | 18419.91 | 18435.27 | 19759.0 |
| 2021-12-15 09:00:00 | NQ | Futures | 18435.27 | 18464.54 | 18344.27 | 18363.39 | 84365.0 |
| 2021-12-15 10:00:00 | NQ | Futures | 18363.68 | 18443.67 | 18324.85 | 18372.67 | 75743.0 |
| 2021-12-15 11:00:00 | NQ | Futures | 18371.8 | 18382.81 | 18274.42 | 18286.88 | 63273.0 |
| 2021-12-15 12:00:00 | NQ | Futures | 18286.59 | 18323.11 | 18247.18 | 18312.97 | 45339.0 |
| 2021-12-15 13:00:00 | NQ | Futures | 18312.97 | 18368.61 | 18300.5 | 18364.84 | 30647.0 |
| 2021-12-15 14:00:00 | NQ | Futures | 18367.45 | 18593.8 | 18258.48 | 18541.34 | 147567.0 |
| 2021-12-15 15:00:00 | NQ | Futures | 18541.92 | 18893.18 | 18534.97 | 18875.21 | 130796.0 |
| 2021-12-15 16:00:00 | NQ | Futures | 18875.21 | 18896.08 | 18858.4 | 18878.98 | 18504.0 |
| 2021-12-15 18:00:00 | NQ | Futures | 18882.17 | 18939.84 | 18878.98 | 18922.16 | 8341.0 |
| 2021-12-15 19:00:00 | NQ | Futures | 18923.03 | 18923.03 | 18895.5 | 18905.06 | 5604.0 |
| 2021-12-15 20:00:00 | NQ | Futures | 18905.35 | 18917.24 | 18869.71 | 18876.08 | 4858.0 |
| 2021-12-15 21:00:00 | NQ | Futures | 18876.66 | 18911.15 | 18876.08 | 18898.69 | 3953.0 |
| 2021-12-15 22:00:00 | NQ | Futures | 18898.4 | 18911.44 | 18892.02 | 18908.54 | 1962.0 |
| 2021-12-15 23:00:00 | NQ | Futures | 18908.83 | 18930.86 | 18907.67 | 18928.25 | 3344.0 |
| 2021-12-15 00:00:00 | YM | Futures | 39897.2 | 39907.3 | 39867.9 | 39890.4 | 1163.0 |
| 2021-12-15 01:00:00 | YM | Futures | 39889.3 | 39914.0 | 39820.7 | 39827.5 | 1272.0 |
| 2021-12-15 02:00:00 | YM | Futures | 39829.7 | 39865.7 | 39788.1 | 39845.5 | 2423.0 |
| 2021-12-15 03:00:00 | YM | Futures | 39845.5 | 39911.8 | 39842.1 | 39873.6 | 4263.0 |
> showing 50 of 2,006 rows — these rows as CSV