PREVIEW / futures_1hour / 2018-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-19.parquet
  size:    58 KB
  rows:    1,757

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-12-19 00:00:00	ES	Futures	2774.78	2775.59	2772.34	2773.96	6130.0
2018-12-19 01:00:00	ES	Futures	2773.96	2775.05	2771.52	2772.06	3630.0
2018-12-19 02:00:00	ES	Futures	2772.06	2776.95	2771.79	2772.88	8860.0
2018-12-19 03:00:00	ES	Futures	2772.61	2776.95	2770.71	2773.69	22505.0
2018-12-19 04:00:00	ES	Futures	2773.42	2777.77	2773.42	2777.5	12090.0
2018-12-19 05:00:00	ES	Futures	2777.5	2782.66	2776.95	2779.4	19395.0
2018-12-19 06:00:00	ES	Futures	2779.12	2780.48	2777.22	2779.67	9349.0
2018-12-19 07:00:00	ES	Futures	2779.4	2784.01	2779.12	2780.48	15539.0
2018-12-19 08:00:00	ES	Futures	2780.48	2780.75	2772.34	2773.15	23160.0
2018-12-19 09:00:00	ES	Futures	2773.15	2792.98	2766.63	2787.27	203616.0
2018-12-19 10:00:00	ES	Futures	2787.27	2796.51	2787.0	2795.15	239256.0
2018-12-19 11:00:00	ES	Futures	2795.15	2795.96	2783.2	2794.88	170311.0
2018-12-19 12:00:00	ES	Futures	2794.88	2803.57	2794.06	2795.42	123784.0
2018-12-19 13:00:00	ES	Futures	2795.15	2813.34	2785.64	2809.27	145984.0
2018-12-19 14:00:00	ES	Futures	2809.81	2815.79	2728.34	2735.94	614941.0
2018-12-19 15:00:00	ES	Futures	2736.21	2736.49	2704.44	2722.64	635175.0
2018-12-19 16:00:00	ES	Futures	2722.64	2728.61	2710.96	2719.38	107408.0
2018-12-19 18:00:00	ES	Futures	2721.28	2730.51	2712.59	2727.25	17698.0
2018-12-19 19:00:00	ES	Futures	2727.52	2731.33	2722.91	2729.42	11915.0
2018-12-19 20:00:00	ES	Futures	2729.42	2734.58	2729.15	2730.51	16258.0
2018-12-19 21:00:00	ES	Futures	2730.24	2731.05	2721.55	2725.35	13375.0
2018-12-19 22:00:00	ES	Futures	2725.35	2726.44	2712.86	2715.03	22878.0
2018-12-19 23:00:00	ES	Futures	2715.3	2716.66	2690.05	2695.21	35755.0
2018-12-19 00:00:00	NQ	Futures	7621.47	7624.1	7612.41	7617.08	2680.0
2018-12-19 01:00:00	NQ	Futures	7617.67	7622.05	7612.41	7615.33	1789.0
2018-12-19 02:00:00	NQ	Futures	7615.91	7627.89	7611.24	7615.62	4018.0
2018-12-19 03:00:00	NQ	Futures	7615.04	7632.57	7608.03	7616.5	7747.0
2018-12-19 04:00:00	NQ	Futures	7616.5	7631.99	7615.62	7631.4	4215.0
2018-12-19 05:00:00	NQ	Futures	7630.82	7651.85	7629.65	7643.09	6115.0
2018-12-19 06:00:00	NQ	Futures	7643.38	7643.97	7635.78	7643.38	3073.0
2018-12-19 07:00:00	NQ	Futures	7643.67	7654.19	7637.24	7640.46	4721.0
2018-12-19 08:00:00	NQ	Futures	7640.46	7640.75	7611.53	7615.62	7979.0
2018-12-19 09:00:00	NQ	Futures	7615.91	7698.6	7588.74	7683.12	60148.0
2018-12-19 10:00:00	NQ	Futures	7683.12	7708.25	7675.81	7693.64	65884.0
2018-12-19 11:00:00	NQ	Futures	7692.76	7695.39	7648.93	7689.55	44711.0
2018-12-19 12:00:00	NQ	Futures	7689.25	7704.45	7667.34	7668.22	35151.0
2018-12-19 13:00:00	NQ	Futures	7668.22	7705.62	7639.0	7703.28	37069.0
2018-12-19 14:00:00	NQ	Futures	7705.91	7725.49	7449.37	7477.13	171662.0
2018-12-19 15:00:00	NQ	Futures	7477.13	7478.59	7364.63	7425.12	158301.0
2018-12-19 16:00:00	NQ	Futures	7424.82	7445.86	7395.9	7420.44	23056.0
2018-12-19 18:00:00	NQ	Futures	7421.61	7454.92	7398.82	7449.37	8427.0
2018-12-19 19:00:00	NQ	Futures	7449.37	7460.47	7432.71	7453.46	6086.0
2018-12-19 20:00:00	NQ	Futures	7453.75	7468.94	7453.75	7457.55	5176.0
2018-12-19 21:00:00	NQ	Futures	7456.96	7459.59	7429.79	7442.06	5311.0
2018-12-19 22:00:00	NQ	Futures	7441.48	7444.69	7407.88	7414.3	7959.0
2018-12-19 23:00:00	NQ	Futures	7414.3	7420.44	7347.98	7357.91	12744.0
2018-12-19 00:00:00	YM	Futures	25785.5	25791.0	25758.4	25776.9	1114.0
2018-12-19 01:00:00	YM	Futures	25774.7	25784.5	25753.0	25758.4	724.0
2018-12-19 02:00:00	YM	Futures	25758.4	25808.3	25747.5	25766.0	2030.0
2018-12-19 03:00:00	YM	Futures	25763.8	25805.1	25739.9	25769.3	3966.0

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

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