PREVIEW / futures_1hour / 2021-01-05
file: by_date/futures_1hour/2021/2021-01-05.parquet size: 65 KB rows: 1,968
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-01-05 00:00:00 | ES | Futures | 4143.48 | 4149.09 | 4140.95 | 4146.85 | 7655.0 |
| 2021-01-05 01:00:00 | ES | Futures | 4146.85 | 4154.99 | 4145.72 | 4154.14 | 8137.0 |
| 2021-01-05 02:00:00 | ES | Futures | 4154.42 | 4154.99 | 4128.88 | 4130.85 | 16215.0 |
| 2021-01-05 03:00:00 | ES | Futures | 4130.57 | 4157.79 | 4130.57 | 4150.21 | 31837.0 |
| 2021-01-05 04:00:00 | ES | Futures | 4149.93 | 4157.23 | 4146.85 | 4151.9 | 14524.0 |
| 2021-01-05 05:00:00 | ES | Futures | 4151.9 | 4155.83 | 4150.21 | 4151.9 | 6495.0 |
| 2021-01-05 06:00:00 | ES | Futures | 4152.18 | 4158.35 | 4144.04 | 4147.13 | 13393.0 |
| 2021-01-05 07:00:00 | ES | Futures | 4146.85 | 4148.81 | 4132.53 | 4142.36 | 25091.0 |
| 2021-01-05 08:00:00 | ES | Futures | 4142.07 | 4144.88 | 4124.67 | 4125.23 | 40784.0 |
| 2021-01-05 09:00:00 | ES | Futures | 4125.52 | 4167.9 | 4123.83 | 4160.88 | 200364.0 |
| 2021-01-05 10:00:00 | ES | Futures | 4160.88 | 4169.58 | 4140.95 | 4145.16 | 221295.0 |
| 2021-01-05 11:00:00 | ES | Futures | 4145.44 | 4159.76 | 4139.27 | 4155.83 | 135032.0 |
| 2021-01-05 12:00:00 | ES | Futures | 4155.83 | 4164.81 | 4154.42 | 4164.25 | 97863.0 |
| 2021-01-05 13:00:00 | ES | Futures | 4164.25 | 4169.02 | 4162.56 | 4168.74 | 70391.0 |
| 2021-01-05 14:00:00 | ES | Futures | 4169.02 | 4187.54 | 4168.74 | 4175.19 | 136455.0 |
| 2021-01-05 15:00:00 | ES | Futures | 4175.47 | 4182.77 | 4168.74 | 4173.51 | 217391.0 |
| 2021-01-05 16:00:00 | ES | Futures | 4173.51 | 4176.88 | 4170.14 | 4173.51 | 52672.0 |
| 2021-01-05 18:00:00 | ES | Futures | 4173.51 | 4176.6 | 4166.21 | 4169.58 | 8285.0 |
| 2021-01-05 19:00:00 | ES | Futures | 4169.58 | 4192.88 | 4168.18 | 4175.19 | 32893.0 |
| 2021-01-05 20:00:00 | ES | Futures | 4175.47 | 4179.4 | 4148.25 | 4162.0 | 51059.0 |
| 2021-01-05 21:00:00 | ES | Futures | 4162.0 | 4168.74 | 4144.6 | 4149.93 | 37646.0 |
| 2021-01-05 22:00:00 | ES | Futures | 4149.93 | 4156.11 | 4140.67 | 4146.57 | 23885.0 |
| 2021-01-05 23:00:00 | ES | Futures | 4146.57 | 4158.91 | 4138.43 | 4146.85 | 27398.0 |
| 2021-01-05 00:00:00 | NQ | Futures | 14676.03 | 14698.6 | 14673.13 | 14694.26 | 3572.0 |
| 2021-01-05 01:00:00 | NQ | Futures | 14693.97 | 14716.55 | 14693.1 | 14713.36 | 5230.0 |
| 2021-01-05 02:00:00 | NQ | Futures | 14712.79 | 14715.1 | 14634.93 | 14645.93 | 10056.0 |
| 2021-01-05 03:00:00 | NQ | Futures | 14645.93 | 14721.47 | 14643.61 | 14696.87 | 11472.0 |
| 2021-01-05 04:00:00 | NQ | Futures | 14696.58 | 14723.49 | 14688.47 | 14706.42 | 6012.0 |
| 2021-01-05 05:00:00 | NQ | Futures | 14706.71 | 14720.02 | 14701.79 | 14709.02 | 3586.0 |
| 2021-01-05 06:00:00 | NQ | Futures | 14708.73 | 14733.05 | 14677.18 | 14692.24 | 7680.0 |
| 2021-01-05 07:00:00 | NQ | Futures | 14692.24 | 14697.16 | 14649.11 | 14682.11 | 12054.0 |
| 2021-01-05 08:00:00 | NQ | Futures | 14681.82 | 14685.29 | 14602.51 | 14603.09 | 16461.0 |
| 2021-01-05 09:00:00 | NQ | Futures | 14603.38 | 14782.83 | 14601.35 | 14760.83 | 77668.0 |
| 2021-01-05 10:00:00 | NQ | Futures | 14761.99 | 14800.48 | 14717.71 | 14719.73 | 86197.0 |
| 2021-01-05 11:00:00 | NQ | Futures | 14720.02 | 14755.91 | 14689.34 | 14737.39 | 53168.0 |
| 2021-01-05 12:00:00 | NQ | Futures | 14737.97 | 14751.57 | 14705.55 | 14735.36 | 36247.0 |
| 2021-01-05 13:00:00 | NQ | Futures | 14735.94 | 14769.51 | 14729.86 | 14763.15 | 24594.0 |
| 2021-01-05 14:00:00 | NQ | Futures | 14763.44 | 14821.32 | 14762.57 | 14789.2 | 35054.0 |
| 2021-01-05 15:00:00 | NQ | Futures | 14788.91 | 14819.59 | 14765.17 | 14809.17 | 52978.0 |
| 2021-01-05 16:00:00 | NQ | Futures | 14809.46 | 14829.43 | 14804.25 | 14823.06 | 10688.0 |
| 2021-01-05 18:00:00 | NQ | Futures | 14819.3 | 14830.01 | 14797.01 | 14813.22 | 3689.0 |
| 2021-01-05 19:00:00 | NQ | Futures | 14813.51 | 14870.24 | 14775.88 | 14794.41 | 15862.0 |
| 2021-01-05 20:00:00 | NQ | Futures | 14793.83 | 14810.03 | 14665.03 | 14725.52 | 27333.0 |
| 2021-01-05 21:00:00 | NQ | Futures | 14726.39 | 14747.52 | 14618.43 | 14639.56 | 17417.0 |
| 2021-01-05 22:00:00 | NQ | Futures | 14639.27 | 14655.48 | 14590.93 | 14613.51 | 14601.0 |
| 2021-01-05 23:00:00 | NQ | Futures | 14613.22 | 14643.9 | 14560.83 | 14602.51 | 13795.0 |
| 2021-01-05 00:00:00 | YM | Futures | 33349.1 | 33394.5 | 33334.6 | 33389.0 | 1876.0 |
| 2021-01-05 01:00:00 | YM | Futures | 33387.9 | 33453.3 | 33373.5 | 33450.0 | 2043.0 |
| 2021-01-05 02:00:00 | YM | Futures | 33448.9 | 33460.0 | 33247.0 | 33259.2 | 5323.0 |
| 2021-01-05 03:00:00 | YM | Futures | 33258.1 | 33503.2 | 33257.0 | 33430.0 | 9155.0 |
> showing 50 of 1,968 rows — these rows as CSV