PREVIEW / futures_1hour / 2019-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-11.parquet
  size:    51 KB
  rows:    1,631

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-06-11 00:00:00	ES	Futures	3138.82	3140.72	3138.01	3139.91	3275.0
2019-06-11 01:00:00	ES	Futures	3139.91	3141.26	3138.82	3141.26	6625.0
2019-06-11 02:00:00	ES	Futures	3141.26	3142.08	3138.82	3139.36	17907.0
2019-06-11 03:00:00	ES	Futures	3139.09	3142.08	3137.2	3140.45	35193.0
2019-06-11 04:00:00	ES	Futures	3140.45	3144.79	3140.18	3144.24	23093.0
2019-06-11 05:00:00	ES	Futures	3144.24	3148.85	3142.89	3147.77	17926.0
2019-06-11 06:00:00	ES	Futures	3147.77	3149.4	3146.41	3146.41	13699.0
2019-06-11 07:00:00	ES	Futures	3146.68	3148.04	3145.06	3147.5	14376.0
2019-06-11 08:00:00	ES	Futures	3147.5	3153.46	3147.23	3151.29	39470.0
2019-06-11 09:00:00	ES	Futures	3151.29	3157.26	3145.33	3147.77	209561.0
2019-06-11 10:00:00	ES	Futures	3147.77	3150.75	3135.03	3139.09	243373.0
2019-06-11 11:00:00	ES	Futures	3138.82	3141.8	3131.77	3133.13	152708.0
2019-06-11 12:00:00	ES	Futures	3133.13	3133.67	3122.28	3122.83	127530.0
2019-06-11 13:00:00	ES	Futures	3122.83	3133.13	3122.28	3132.59	87520.0
2019-06-11 14:00:00	ES	Futures	3132.59	3136.11	3125.54	3127.98	87667.0
2019-06-11 15:00:00	ES	Futures	3127.98	3132.32	3124.18	3129.88	149840.0
2019-06-11 16:00:00	ES	Futures	3129.88	3131.77	3128.52	3131.23	41550.0
2019-06-11 18:00:00	ES	Futures	3130.96	3131.23	3127.98	3129.88	5001.0
2019-06-11 19:00:00	ES	Futures	3129.88	3132.59	3128.25	3129.06	5669.0
2019-06-11 20:00:00	ES	Futures	3129.06	3135.03	3127.98	3132.04	10867.0
2019-06-11 21:00:00	ES	Futures	3132.04	3132.59	3126.08	3130.42	17337.0
2019-06-11 22:00:00	ES	Futures	3130.42	3130.96	3127.71	3128.52	11222.0
2019-06-11 23:00:00	ES	Futures	3128.52	3130.69	3128.25	3129.33	5403.0
2019-06-11 00:00:00	NQ	Futures	8779.81	8787.96	8776.03	8783.6	1441.0
2019-06-11 01:00:00	NQ	Futures	8783.3	8787.67	8778.35	8787.67	2141.0
2019-06-11 02:00:00	NQ	Futures	8787.67	8790.58	8778.94	8780.1	4307.0
2019-06-11 03:00:00	NQ	Futures	8779.81	8790.29	8772.24	8785.63	7479.0
2019-06-11 04:00:00	NQ	Futures	8785.34	8805.43	8785.34	8802.23	8753.0
2019-06-11 05:00:00	NQ	Futures	8801.65	8817.66	8796.99	8813.29	7768.0
2019-06-11 06:00:00	NQ	Futures	8813.0	8815.33	8806.89	8808.34	4615.0
2019-06-11 07:00:00	NQ	Futures	8808.34	8813.0	8800.48	8810.96	5373.0
2019-06-11 08:00:00	NQ	Futures	8810.96	8838.33	8810.38	8829.02	13256.0
2019-06-11 09:00:00	NQ	Futures	8829.02	8852.02	8797.57	8812.71	81861.0
2019-06-11 10:00:00	NQ	Futures	8812.71	8836.0	8772.82	8787.38	77556.0
2019-06-11 11:00:00	NQ	Futures	8787.38	8793.79	8748.95	8759.72	58500.0
2019-06-11 12:00:00	NQ	Futures	8759.14	8762.05	8726.82	8729.44	47685.0
2019-06-11 13:00:00	NQ	Futures	8729.15	8765.54	8726.24	8763.21	32427.0
2019-06-11 14:00:00	NQ	Futures	8763.21	8775.15	8741.67	8750.7	31061.0
2019-06-11 15:00:00	NQ	Futures	8749.82	8769.91	8737.88	8755.06	40508.0
2019-06-11 16:00:00	NQ	Futures	8754.77	8760.01	8748.95	8756.23	7379.0
2019-06-11 18:00:00	NQ	Futures	8755.35	8758.27	8746.91	8752.15	2393.0
2019-06-11 19:00:00	NQ	Futures	8751.86	8761.47	8747.2	8750.4	2681.0
2019-06-11 20:00:00	NQ	Futures	8750.99	8770.78	8747.49	8761.76	4336.0
2019-06-11 21:00:00	NQ	Futures	8762.05	8764.09	8737.3	8747.78	7507.0
2019-06-11 22:00:00	NQ	Futures	8747.78	8749.82	8737.88	8740.5	3094.0
2019-06-11 23:00:00	NQ	Futures	8739.92	8750.4	8739.34	8743.42	1913.0
2019-06-11 00:00:00	YM	Futures	28415.3	28427.3	28415.3	28425.1	26.0
2019-06-11 01:00:00	YM	Futures	28424.0	28432.7	28415.3	28432.7	22.0
2019-06-11 02:00:00	YM	Futures	28438.1	28452.3	28421.8	28422.9	235.0
2019-06-11 03:00:00	YM	Futures	28420.7	28458.8	28419.6	28445.7	37.0

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

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