PREVIEW / futures_1hour / 2020-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-28.parquet
  size:    52 KB
  rows:    1,516

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
2020-08-28 00:00:00	ES	Futures	3916.67	3917.23	3912.2	3917.23	5434.0
2020-08-28 01:00:00	ES	Futures	3916.95	3917.51	3906.06	3912.48	27785.0
2020-08-28 02:00:00	ES	Futures	3912.48	3916.67	3911.64	3913.6	12231.0
2020-08-28 03:00:00	ES	Futures	3913.32	3913.6	3892.93	3901.31	36482.0
2020-08-28 04:00:00	ES	Futures	3901.03	3909.41	3898.8	3905.22	20661.0
2020-08-28 05:00:00	ES	Futures	3905.5	3909.97	3902.99	3907.18	14276.0
2020-08-28 06:00:00	ES	Futures	3907.18	3908.01	3896.84	3900.75	15228.0
2020-08-28 07:00:00	ES	Futures	3901.03	3908.85	3901.03	3907.73	15440.0
2020-08-28 08:00:00	ES	Futures	3907.73	3908.01	3900.47	3901.31	21979.0
2020-08-28 09:00:00	ES	Futures	3901.31	3905.22	3892.93	3900.75	147096.0
2020-08-28 10:00:00	ES	Futures	3900.75	3901.59	3887.91	3890.98	178321.0
2020-08-28 11:00:00	ES	Futures	3890.7	3902.71	3889.3	3900.75	114213.0
2020-08-28 12:00:00	ES	Futures	3901.03	3905.78	3898.24	3905.22	78681.0
2020-08-28 13:00:00	ES	Futures	3905.22	3905.5	3894.33	3900.47	98819.0
2020-08-28 14:00:00	ES	Futures	3900.47	3907.73	3897.4	3906.06	98981.0
2020-08-28 15:00:00	ES	Futures	3906.34	3916.95	3904.94	3914.99	180042.0
2020-08-28 16:00:00	ES	Futures	3914.99	3917.23	3912.76	3916.95	60644.0
2020-08-28 00:00:00	NQ	Futures	13889.25	13890.4	13864.38	13884.91	3169.0
2020-08-28 01:00:00	NQ	Futures	13884.33	13886.35	13836.04	13867.85	9237.0
2020-08-28 02:00:00	NQ	Futures	13867.56	13880.57	13854.54	13860.33	4061.0
2020-08-28 03:00:00	NQ	Futures	13859.75	13862.35	13790.35	13826.2	10632.0
2020-08-28 04:00:00	NQ	Futures	13825.63	13841.24	13811.46	13812.32	6464.0
2020-08-28 05:00:00	NQ	Futures	13813.19	13834.59	13804.8	13823.02	3325.0
2020-08-28 06:00:00	NQ	Futures	13823.02	13825.63	13788.61	13806.54	4229.0
2020-08-28 07:00:00	NQ	Futures	13807.12	13856.57	13807.12	13851.36	6946.0
2020-08-28 08:00:00	NQ	Futures	13851.07	13851.36	13818.11	13838.06	11726.0
2020-08-28 09:00:00	NQ	Futures	13837.48	13887.22	13820.13	13887.22	73677.0
2020-08-28 10:00:00	NQ	Futures	13887.51	13901.68	13820.71	13831.41	81502.0
2020-08-28 11:00:00	NQ	Futures	13831.7	13885.77	13819.55	13873.34	52014.0
2020-08-28 12:00:00	NQ	Futures	13873.34	13885.49	13835.75	13860.33	36587.0
2020-08-28 13:00:00	NQ	Futures	13860.04	13861.19	13794.39	13840.95	52584.0
2020-08-28 14:00:00	NQ	Futures	13840.95	13864.38	13826.78	13838.64	41332.0
2020-08-28 15:00:00	NQ	Futures	13839.22	13895.61	13833.43	13870.45	56062.0
2020-08-28 16:00:00	NQ	Futures	13870.45	13886.64	13866.69	13882.88	9186.0
2020-08-28 00:00:00	YM	Futures	31582.9	31584.0	31544.4	31581.8	1290.0
2020-08-28 01:00:00	YM	Futures	31580.7	31586.2	31476.1	31525.6	5149.0
2020-08-28 02:00:00	YM	Futures	31525.6	31568.6	31517.9	31541.1	2121.0
2020-08-28 03:00:00	YM	Futures	31537.8	31540.0	31348.4	31434.2	7274.0
2020-08-28 04:00:00	YM	Futures	31435.3	31521.2	31411.1	31495.9	4463.0
2020-08-28 05:00:00	YM	Futures	31495.9	31537.8	31468.4	31510.2	2301.0
2020-08-28 06:00:00	YM	Futures	31510.2	31519.0	31417.7	31460.7	2799.0
2020-08-28 07:00:00	YM	Futures	31461.8	31517.9	31460.7	31515.7	2863.0
2020-08-28 08:00:00	YM	Futures	31514.6	31528.9	31459.6	31464.0	3691.0
2020-08-28 09:00:00	YM	Futures	31462.9	31492.6	31329.6	31428.7	18144.0
2020-08-28 10:00:00	YM	Futures	31428.7	31435.3	31318.6	31353.9	19205.0
2020-08-28 11:00:00	YM	Futures	31355.0	31447.5	31340.6	31430.9	12221.0
2020-08-28 12:00:00	YM	Futures	31429.8	31487.1	31416.6	31480.5	8641.0
2020-08-28 13:00:00	YM	Futures	31481.6	31482.7	31402.3	31427.6	10433.0
2020-08-28 14:00:00	YM	Futures	31428.7	31508.0	31402.3	31504.7	10806.0
2020-08-28 15:00:00	YM	Futures	31505.8	31593.9	31497.0	31516.8	19113.0

> showing 50 of 1,516 rows — these rows as CSV

> unlock the full archive -- $79 one-time