PREVIEW / futures_1hour / 2018-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-05.parquet
  size:    48 KB
  rows:    1,413

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
2018-10-05 00:00:00	ES	Futures	3166.88	3168.78	3166.6	3167.42	3590.0
2018-10-05 01:00:00	ES	Futures	3167.42	3168.24	3164.7	3165.52	4362.0
2018-10-05 02:00:00	ES	Futures	3165.24	3167.42	3164.97	3166.33	6731.0
2018-10-05 03:00:00	ES	Futures	3166.33	3166.33	3159.53	3160.08	26455.0
2018-10-05 04:00:00	ES	Futures	3160.08	3160.35	3156.0	3158.44	24253.0
2018-10-05 05:00:00	ES	Futures	3158.44	3161.71	3158.17	3161.71	16655.0
2018-10-05 06:00:00	ES	Futures	3161.44	3163.61	3161.16	3162.25	15250.0
2018-10-05 07:00:00	ES	Futures	3162.52	3166.33	3162.25	3163.61	16572.0
2018-10-05 08:00:00	ES	Futures	3163.34	3171.5	3153.28	3161.98	130718.0
2018-10-05 09:00:00	ES	Futures	3162.25	3170.41	3160.89	3161.44	227159.0
2018-10-05 10:00:00	ES	Futures	3161.44	3166.06	3154.91	3157.08	269658.0
2018-10-05 11:00:00	ES	Futures	3157.08	3157.36	3134.78	3134.78	363317.0
2018-10-05 12:00:00	ES	Futures	3135.05	3141.04	3130.43	3133.96	231477.0
2018-10-05 13:00:00	ES	Futures	3134.24	3138.86	3126.08	3136.96	197359.0
2018-10-05 14:00:00	ES	Futures	3137.23	3145.93	3134.24	3144.84	207972.0
2018-10-05 15:00:00	ES	Futures	3144.84	3149.47	3139.13	3144.84	362526.0
2018-10-05 16:00:00	ES	Futures	3144.84	3150.01	3143.21	3149.74	87046.0
2018-10-05 00:00:00	NQ	Futures	8821.72	8829.93	8820.25	8825.24	2439.0
2018-10-05 01:00:00	NQ	Futures	8825.24	8831.4	8815.56	8819.66	2096.0
2018-10-05 02:00:00	NQ	Futures	8819.66	8827.88	8817.32	8818.49	2969.0
2018-10-05 03:00:00	NQ	Futures	8818.49	8819.08	8790.33	8792.97	10553.0
2018-10-05 04:00:00	NQ	Futures	8792.97	8794.73	8775.37	8787.11	9375.0
2018-10-05 05:00:00	NQ	Futures	8787.11	8801.48	8785.35	8800.6	5640.0
2018-10-05 06:00:00	NQ	Futures	8800.89	8807.05	8795.61	8801.48	4434.0
2018-10-05 07:00:00	NQ	Futures	8801.77	8817.9	8800.01	8802.94	5966.0
2018-10-05 08:00:00	NQ	Futures	8802.94	8830.52	8763.93	8799.72	43916.0
2018-10-05 09:00:00	NQ	Futures	8800.01	8840.2	8767.45	8774.79	96338.0
2018-10-05 10:00:00	NQ	Futures	8774.49	8806.46	8747.51	8763.05	95129.0
2018-10-05 11:00:00	NQ	Futures	8763.05	8764.52	8664.21	8670.95	113273.0
2018-10-05 12:00:00	NQ	Futures	8670.95	8692.07	8637.51	8652.77	80877.0
2018-10-05 13:00:00	NQ	Futures	8652.47	8678.58	8619.92	8673.89	70467.0
2018-10-05 14:00:00	NQ	Futures	8673.59	8731.38	8665.38	8719.64	68435.0
2018-10-05 15:00:00	NQ	Futures	8719.94	8737.54	8696.18	8706.44	76253.0
2018-10-05 16:00:00	NQ	Futures	8706.44	8727.27	8702.63	8726.98	12474.0
2018-10-05 00:00:00	YM	Futures	28995.8	29008.8	28987.1	28992.5	1067.0
2018-10-05 01:00:00	YM	Futures	28993.6	28999.0	28967.5	28976.2	1363.0
2018-10-05 02:00:00	YM	Futures	28975.1	28993.6	28972.9	28984.9	1647.0
2018-10-05 03:00:00	YM	Futures	28983.8	28984.9	28923.0	28928.4	4926.0
2018-10-05 04:00:00	YM	Futures	28927.3	28932.7	28895.8	28921.9	4214.0
2018-10-05 05:00:00	YM	Futures	28921.9	28947.9	28918.6	28945.8	2827.0
2018-10-05 06:00:00	YM	Futures	28944.7	28971.9	28940.3	28962.1	2579.0
2018-10-05 07:00:00	YM	Futures	28963.2	28993.6	28962.1	28971.9	2690.0
2018-10-05 08:00:00	YM	Futures	28971.9	29045.7	28873.0	28947.9	18689.0
2018-10-05 09:00:00	YM	Futures	28946.9	29000.1	28909.9	28916.4	27904.0
2018-10-05 10:00:00	YM	Futures	28916.4	28955.6	28818.7	28836.0	38309.0
2018-10-05 11:00:00	YM	Futures	28836.0	28837.1	28642.6	28650.2	41187.0
2018-10-05 12:00:00	YM	Futures	28651.3	28711.1	28619.8	28656.8	29205.0
2018-10-05 13:00:00	YM	Futures	28656.8	28701.3	28587.2	28679.6	25419.0
2018-10-05 14:00:00	YM	Futures	28678.5	28751.3	28647.0	28736.1	22786.0
2018-10-05 15:00:00	YM	Futures	28737.2	28790.4	28689.4	28749.1	30209.0

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

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