PREVIEW / futures_1hour / 2019-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-17.parquet
  size:    50 KB
  rows:    1,496

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
2019-05-17 00:00:00	ES	Futures	3111.44	3114.42	3110.9	3113.61	7361.0
2019-05-17 01:00:00	ES	Futures	3113.34	3113.61	3109.54	3110.36	9734.0
2019-05-17 02:00:00	ES	Futures	3110.09	3114.97	3108.73	3113.88	19504.0
2019-05-17 03:00:00	ES	Futures	3114.15	3115.24	3110.09	3113.34	21537.0
2019-05-17 04:00:00	ES	Futures	3113.34	3113.61	3102.77	3104.66	26053.0
2019-05-17 05:00:00	ES	Futures	3104.93	3113.34	3102.49	3110.36	31717.0
2019-05-17 06:00:00	ES	Futures	3110.36	3110.36	3105.48	3107.37	15789.0
2019-05-17 07:00:00	ES	Futures	3107.65	3108.46	3097.61	3100.05	40016.0
2019-05-17 08:00:00	ES	Futures	3100.33	3103.04	3093.82	3099.51	81455.0
2019-05-17 09:00:00	ES	Futures	3099.24	3109.54	3093.28	3102.22	280434.0
2019-05-17 10:00:00	ES	Futures	3101.95	3129.06	3098.97	3125.54	325029.0
2019-05-17 11:00:00	ES	Futures	3125.54	3131.23	3115.24	3119.84	210575.0
2019-05-17 12:00:00	ES	Futures	3119.57	3120.39	3111.17	3118.49	128624.0
2019-05-17 13:00:00	ES	Futures	3118.22	3123.37	3116.05	3120.93	93320.0
2019-05-17 14:00:00	ES	Futures	3120.93	3122.83	3114.97	3119.03	79015.0
2019-05-17 15:00:00	ES	Futures	3119.3	3119.84	3098.7	3102.22	374499.0
2019-05-17 16:00:00	ES	Futures	3102.22	3105.48	3100.6	3102.77	75425.0
2019-05-17 00:00:00	NQ	Futures	8815.62	8826.1	8813.88	8820.28	3590.0
2019-05-17 01:00:00	NQ	Futures	8820.28	8821.45	8808.05	8812.42	4576.0
2019-05-17 02:00:00	NQ	Futures	8812.42	8828.43	8803.69	8824.94	8204.0
2019-05-17 03:00:00	NQ	Futures	8825.52	8827.85	8810.67	8821.74	8253.0
2019-05-17 04:00:00	NQ	Futures	8822.03	8824.07	8780.98	8787.67	10611.0
2019-05-17 05:00:00	NQ	Futures	8787.96	8821.45	8780.39	8811.84	10956.0
2019-05-17 06:00:00	NQ	Futures	8811.26	8812.71	8791.46	8799.32	7348.0
2019-05-17 07:00:00	NQ	Futures	8799.32	8803.98	8769.91	8776.61	12657.0
2019-05-17 08:00:00	NQ	Futures	8776.9	8778.06	8743.71	8764.96	28670.0
2019-05-17 09:00:00	NQ	Futures	8764.96	8814.75	8747.78	8787.96	89756.0
2019-05-17 10:00:00	NQ	Futures	8787.67	8865.99	8764.09	8857.55	101033.0
2019-05-17 11:00:00	NQ	Futures	8856.97	8874.44	8801.65	8819.12	71922.0
2019-05-17 12:00:00	NQ	Futures	8819.12	8823.19	8789.71	8817.95	50402.0
2019-05-17 13:00:00	NQ	Futures	8817.08	8833.38	8802.52	8821.15	40362.0
2019-05-17 14:00:00	NQ	Futures	8821.15	8830.76	8806.01	8815.91	31981.0
2019-05-17 15:00:00	NQ	Futures	8815.91	8817.95	8744.58	8751.28	98088.0
2019-05-17 16:00:00	NQ	Futures	8751.28	8754.19	8742.25	8748.95	16210.0
2019-05-17 00:00:00	YM	Futures	28057.5	28082.5	28054.2	28076.0	2087.0
2019-05-17 01:00:00	YM	Futures	28076.0	28078.1	28042.2	28045.5	2381.0
2019-05-17 02:00:00	YM	Futures	28046.6	28080.3	28024.8	28068.3	4600.0
2019-05-17 03:00:00	YM	Futures	28070.5	28082.5	28040.1	28070.5	4662.0
2019-05-17 04:00:00	YM	Futures	28070.5	28074.9	27982.4	27999.8	5616.0
2019-05-17 05:00:00	YM	Futures	27998.7	28067.3	27980.2	28041.1	6749.0
2019-05-17 06:00:00	YM	Futures	28040.1	28040.1	27995.5	28016.1	4037.0
2019-05-17 07:00:00	YM	Futures	28017.2	28025.9	27925.9	27941.1	7428.0
2019-05-17 08:00:00	YM	Futures	27941.1	27959.6	27883.4	27929.1	13601.0
2019-05-17 09:00:00	YM	Futures	27928.0	28035.7	27874.7	27994.4	31974.0
2019-05-17 10:00:00	YM	Futures	27993.3	28203.2	27970.4	28174.9	44040.0
2019-05-17 11:00:00	YM	Futures	28173.8	28223.9	28110.8	28159.7	34391.0
2019-05-17 12:00:00	YM	Futures	28159.7	28174.9	28093.4	28159.7	24223.0
2019-05-17 13:00:00	YM	Futures	28158.6	28205.4	28135.8	28176.0	17850.0
2019-05-17 14:00:00	YM	Futures	28176.0	28190.2	28123.8	28156.4	12831.0
2019-05-17 15:00:00	YM	Futures	28157.5	28163.0	27988.9	28019.4	41440.0

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

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