PREVIEW / futures_1hour / 2020-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-18.parquet
  size:    51 KB
  rows:    1,492

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-09-18 00:00:00	ES	Futures	3746.26	3752.71	3743.74	3749.63	6284.0
2020-09-18 01:00:00	ES	Futures	3749.63	3756.07	3745.42	3755.79	10142.0
2020-09-18 02:00:00	ES	Futures	3755.79	3760.27	3752.43	3756.07	15508.0
2020-09-18 03:00:00	ES	Futures	3755.79	3758.31	3744.58	3749.06	22430.0
2020-09-18 04:00:00	ES	Futures	3749.06	3757.19	3746.54	3752.71	15318.0
2020-09-18 05:00:00	ES	Futures	3752.71	3761.39	3750.47	3753.55	28627.0
2020-09-18 06:00:00	ES	Futures	3753.83	3757.75	3751.31	3755.23	16924.0
2020-09-18 07:00:00	ES	Futures	3755.23	3764.19	3753.83	3755.79	31139.0
2020-09-18 08:00:00	ES	Futures	3755.51	3764.75	3752.71	3764.47	30098.0
2020-09-18 09:00:00	ES	Futures	3764.47	3767.83	3733.38	3742.9	240285.0
2020-09-18 10:00:00	ES	Futures	3742.9	3755.23	3727.22	3730.3	392773.0
2020-09-18 11:00:00	ES	Futures	3730.3	3736.74	3719.65	3732.54	255832.0
2020-09-18 12:00:00	ES	Futures	3732.54	3736.74	3705.09	3709.01	380622.0
2020-09-18 13:00:00	ES	Futures	3708.73	3711.53	3675.68	3698.09	253550.0
2020-09-18 14:00:00	ES	Futures	3698.09	3704.53	3688.28	3704.25	148364.0
2020-09-18 15:00:00	ES	Futures	3704.25	3716.01	3702.01	3705.93	274836.0
2020-09-18 16:00:00	ES	Futures	3705.93	3717.41	3703.13	3716.57	88024.0
2020-09-18 00:00:00	NQ	Futures	12824.91	12871.52	12811.31	12851.54	5372.0
2020-09-18 01:00:00	NQ	Futures	12851.83	12882.52	12820.28	12879.04	8210.0
2020-09-18 02:00:00	NQ	Futures	12879.04	12909.73	12867.75	12874.7	9271.0
2020-09-18 03:00:00	NQ	Futures	12873.54	12885.99	12812.75	12837.07	13208.0
2020-09-18 04:00:00	NQ	Futures	12839.96	12878.46	12821.44	12856.75	8741.0
2020-09-18 05:00:00	NQ	Futures	12856.75	12904.51	12849.52	12866.02	8571.0
2020-09-18 06:00:00	NQ	Futures	12866.59	12888.01	12853.57	12864.86	5769.0
2020-09-18 07:00:00	NQ	Futures	12865.73	12915.8	12860.52	12887.73	11405.0
2020-09-18 08:00:00	NQ	Futures	12887.44	12899.3	12864.57	12896.7	14200.0
2020-09-18 09:00:00	NQ	Futures	12896.7	12925.36	12757.75	12803.78	90541.0
2020-09-18 10:00:00	NQ	Futures	12803.78	12859.07	12672.36	12689.15	124475.0
2020-09-18 11:00:00	NQ	Futures	12688.86	12709.7	12611.86	12681.91	94555.0
2020-09-18 12:00:00	NQ	Futures	12681.62	12708.54	12529.65	12561.2	103952.0
2020-09-18 13:00:00	NQ	Futures	12560.92	12582.63	12437.89	12557.15	90487.0
2020-09-18 14:00:00	NQ	Futures	12556.86	12614.76	12524.44	12611.28	54225.0
2020-09-18 15:00:00	NQ	Futures	12611.28	12670.62	12599.41	12641.68	62962.0
2020-09-18 16:00:00	NQ	Futures	12639.94	12665.41	12623.15	12665.41	15963.0
2020-09-18 00:00:00	YM	Futures	30669.9	30706.4	30647.8	30689.8	1440.0
2020-09-18 01:00:00	YM	Futures	30693.1	30730.7	30657.7	30728.5	2043.0
2020-09-18 02:00:00	YM	Futures	30728.5	30758.3	30704.2	30730.7	2216.0
2020-09-18 03:00:00	YM	Futures	30727.4	30745.1	30644.5	30677.6	3869.0
2020-09-18 04:00:00	YM	Futures	30675.4	30739.5	30658.8	30701.9	2568.0
2020-09-18 05:00:00	YM	Futures	30700.8	30752.8	30675.4	30693.1	3202.0
2020-09-18 06:00:00	YM	Futures	30694.2	30727.4	30675.4	30713.0	1989.0
2020-09-18 07:00:00	YM	Futures	30714.1	30755.0	30678.7	30697.5	3901.0
2020-09-18 08:00:00	YM	Futures	30695.3	30765.0	30678.7	30763.9	5251.0
2020-09-18 09:00:00	YM	Futures	30762.8	30800.3	30537.2	30601.3	29868.0
2020-09-18 10:00:00	YM	Futures	30605.8	30771.6	30595.8	30646.7	31913.0
2020-09-18 11:00:00	YM	Futures	30645.6	30729.6	30598.0	30695.3	23190.0
2020-09-18 12:00:00	YM	Futures	30693.1	30719.6	30510.7	30529.5	21404.0
2020-09-18 13:00:00	YM	Futures	30530.6	30540.5	30259.7	30386.8	24999.0
2020-09-18 14:00:00	YM	Futures	30385.7	30443.2	30326.0	30438.8	16820.0
2020-09-18 15:00:00	YM	Futures	30438.8	30562.6	30430.0	30448.8	22293.0

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

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