PREVIEW / futures_1hour / 2019-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-08.parquet
  size:    57 KB
  rows:    1,785

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-01-08 00:00:00	ES	Futures	2784.01	2784.56	2774.78	2776.14	9781.0
2019-01-08 01:00:00	ES	Futures	2776.14	2779.67	2774.51	2778.85	5780.0
2019-01-08 02:00:00	ES	Futures	2778.85	2782.11	2774.78	2774.78	10768.0
2019-01-08 03:00:00	ES	Futures	2775.05	2786.46	2774.24	2785.64	21262.0
2019-01-08 04:00:00	ES	Futures	2785.64	2790.8	2782.11	2782.66	18963.0
2019-01-08 05:00:00	ES	Futures	2782.93	2788.9	2780.75	2788.09	14338.0
2019-01-08 06:00:00	ES	Futures	2788.36	2794.06	2785.64	2791.89	20907.0
2019-01-08 07:00:00	ES	Futures	2791.89	2794.06	2785.1	2789.45	22796.0
2019-01-08 08:00:00	ES	Futures	2789.17	2797.32	2787.0	2796.51	51938.0
2019-01-08 09:00:00	ES	Futures	2796.51	2804.11	2789.45	2792.16	262703.0
2019-01-08 10:00:00	ES	Futures	2792.16	2797.32	2767.45	2773.15	295983.0
2019-01-08 11:00:00	ES	Futures	2773.15	2782.66	2770.71	2781.57	202850.0
2019-01-08 12:00:00	ES	Futures	2781.84	2789.99	2775.05	2780.75	146784.0
2019-01-08 13:00:00	ES	Futures	2780.75	2794.61	2777.22	2791.35	120899.0
2019-01-08 14:00:00	ES	Futures	2791.35	2795.69	2788.36	2791.89	113503.0
2019-01-08 15:00:00	ES	Futures	2791.89	2799.49	2787.0	2796.78	193820.0
2019-01-08 16:00:00	ES	Futures	2796.78	2798.41	2791.07	2791.62	56400.0
2019-01-08 18:00:00	ES	Futures	2791.35	2800.04	2790.26	2799.77	11104.0
2019-01-08 19:00:00	ES	Futures	2799.77	2802.48	2797.32	2798.41	13339.0
2019-01-08 20:00:00	ES	Futures	2798.41	2807.91	2797.86	2806.55	16237.0
2019-01-08 21:00:00	ES	Futures	2806.83	2810.63	2803.84	2807.1	17489.0
2019-01-08 22:00:00	ES	Futures	2807.1	2808.18	2805.2	2807.91	6365.0
2019-01-08 23:00:00	ES	Futures	2807.91	2808.73	2805.47	2807.1	3861.0
2019-01-08 00:00:00	NQ	Futures	7630.52	7634.32	7603.94	7608.32	4774.0
2019-01-08 01:00:00	NQ	Futures	7608.03	7623.22	7599.55	7617.67	4037.0
2019-01-08 02:00:00	NQ	Futures	7618.25	7628.48	7602.47	7603.35	4078.0
2019-01-08 03:00:00	NQ	Futures	7603.64	7640.75	7601.31	7634.91	7887.0
2019-01-08 04:00:00	NQ	Futures	7634.32	7644.26	7624.68	7625.85	7704.0
2019-01-08 05:00:00	NQ	Futures	7626.73	7643.97	7617.67	7641.63	5977.0
2019-01-08 06:00:00	NQ	Futures	7641.92	7663.54	7633.45	7655.94	7221.0
2019-01-08 07:00:00	NQ	Futures	7656.24	7664.42	7637.54	7649.52	8274.0
2019-01-08 08:00:00	NQ	Futures	7648.93	7667.92	7640.17	7666.76	18125.0
2019-01-08 09:00:00	NQ	Futures	7666.76	7697.73	7639.0	7645.72	83346.0
2019-01-08 10:00:00	NQ	Futures	7646.01	7664.42	7558.65	7578.22	98979.0
2019-01-08 11:00:00	NQ	Futures	7578.22	7622.93	7574.72	7620.3	69557.0
2019-01-08 12:00:00	NQ	Futures	7620.3	7650.39	7608.61	7622.93	50657.0
2019-01-08 13:00:00	NQ	Futures	7622.64	7671.43	7611.53	7662.08	46196.0
2019-01-08 14:00:00	NQ	Futures	7662.37	7677.57	7651.85	7663.83	40903.0
2019-01-08 15:00:00	NQ	Futures	7663.54	7680.78	7647.76	7672.31	40807.0
2019-01-08 16:00:00	NQ	Futures	7672.02	7676.4	7656.53	7657.41	8949.0
2019-01-08 18:00:00	NQ	Futures	7651.56	7679.9	7651.56	7678.44	3291.0
2019-01-08 19:00:00	NQ	Futures	7678.44	7688.96	7674.94	7678.15	5499.0
2019-01-08 20:00:00	NQ	Futures	7678.44	7712.05	7676.11	7707.66	7277.0
2019-01-08 21:00:00	NQ	Futures	7707.95	7724.9	7698.6	7714.97	9173.0
2019-01-08 22:00:00	NQ	Futures	7714.97	7719.06	7706.79	7715.84	3475.0
2019-01-08 23:00:00	NQ	Futures	7716.14	7721.1	7705.03	7710.88	2300.0
2019-01-08 00:00:00	YM	Futures	25657.4	25660.7	25561.9	25571.7	3131.0
2019-01-08 01:00:00	YM	Futures	25571.7	25603.1	25555.4	25597.7	2307.0
2019-01-08 02:00:00	YM	Futures	25597.7	25635.7	25564.1	25566.2	3515.0
2019-01-08 03:00:00	YM	Futures	25567.3	25672.6	25561.9	25665.0	6269.0

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

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