PREVIEW / futures_1hour / 2018-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-03.parquet
  size:    54 KB
  rows:    1,693

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-04-03 00:00:00	ES	Futures	2822.14	2822.69	2821.05	2822.42	2844.0
2018-04-03 01:00:00	ES	Futures	2822.42	2823.23	2815.32	2816.14	11530.0
2018-04-03 02:00:00	ES	Futures	2816.14	2823.51	2816.14	2822.69	15260.0
2018-04-03 03:00:00	ES	Futures	2822.96	2826.51	2821.87	2821.87	21993.0
2018-04-03 04:00:00	ES	Futures	2821.87	2823.78	2820.23	2822.69	17373.0
2018-04-03 05:00:00	ES	Futures	2822.42	2823.78	2819.41	2820.23	10037.0
2018-04-03 06:00:00	ES	Futures	2819.96	2827.33	2819.41	2823.78	17717.0
2018-04-03 07:00:00	ES	Futures	2823.78	2827.33	2821.6	2826.78	17549.0
2018-04-03 08:00:00	ES	Futures	2826.78	2833.88	2825.69	2833.06	41658.0
2018-04-03 09:00:00	ES	Futures	2833.33	2835.51	2822.42	2826.24	230104.0
2018-04-03 10:00:00	ES	Futures	2826.24	2836.88	2809.32	2834.97	353100.0
2018-04-03 11:00:00	ES	Futures	2834.97	2844.79	2823.23	2823.51	275759.0
2018-04-03 12:00:00	ES	Futures	2823.23	2831.42	2820.78	2825.96	167905.0
2018-04-03 13:00:00	ES	Futures	2825.96	2837.7	2822.42	2833.88	143920.0
2018-04-03 14:00:00	ES	Futures	2834.15	2841.25	2815.87	2837.97	246874.0
2018-04-03 15:00:00	ES	Futures	2837.7	2858.71	2835.24	2853.53	422267.0
2018-04-03 16:00:00	ES	Futures	2853.53	2854.62	2848.89	2852.16	79098.0
2018-04-03 18:00:00	ES	Futures	2851.34	2852.16	2848.89	2850.8	5008.0
2018-04-03 19:00:00	ES	Futures	2851.07	2851.07	2846.98	2848.07	3795.0
2018-04-03 20:00:00	ES	Futures	2848.07	2848.89	2842.88	2845.61	11394.0
2018-04-03 21:00:00	ES	Futures	2845.34	2845.89	2840.97	2843.97	13471.0
2018-04-03 22:00:00	ES	Futures	2843.97	2845.89	2842.61	2845.07	4662.0
2018-04-03 23:00:00	ES	Futures	2845.34	2845.89	2842.06	2843.97	4480.0
2018-04-03 00:00:00	NQ	Futures	7584.24	7589.86	7583.35	7586.01	1569.0
2018-04-03 01:00:00	NQ	Futures	7586.61	7588.97	7563.26	7569.76	2895.0
2018-04-03 02:00:00	NQ	Futures	7569.46	7596.95	7568.58	7596.36	3850.0
2018-04-03 03:00:00	NQ	Futures	7596.06	7612.32	7592.52	7598.43	6741.0
2018-04-03 04:00:00	NQ	Futures	7598.43	7598.72	7584.83	7593.4	5233.0
2018-04-03 05:00:00	NQ	Futures	7592.22	7599.9	7584.24	7588.08	3699.0
2018-04-03 06:00:00	NQ	Futures	7586.9	7615.86	7585.72	7599.9	5068.0
2018-04-03 07:00:00	NQ	Futures	7599.9	7608.77	7590.74	7607.29	7104.0
2018-04-03 08:00:00	NQ	Futures	7607.59	7643.64	7604.04	7642.76	14899.0
2018-04-03 09:00:00	NQ	Futures	7642.76	7645.12	7573.31	7582.47	78459.0
2018-04-03 10:00:00	NQ	Futures	7583.06	7620.0	7507.99	7610.84	141096.0
2018-04-03 11:00:00	NQ	Futures	7610.84	7663.44	7555.87	7556.46	96075.0
2018-04-03 12:00:00	NQ	Futures	7557.05	7588.67	7538.73	7565.03	59960.0
2018-04-03 13:00:00	NQ	Futures	7564.74	7608.47	7551.14	7597.84	58027.0
2018-04-03 14:00:00	NQ	Futures	7597.84	7633.3	7531.34	7621.48	71034.0
2018-04-03 15:00:00	NQ	Futures	7621.48	7679.99	7612.02	7647.19	88510.0
2018-04-03 16:00:00	NQ	Futures	7647.19	7654.87	7632.71	7649.85	11427.0
2018-04-03 18:00:00	NQ	Futures	7643.64	7647.78	7637.14	7642.46	1399.0
2018-04-03 19:00:00	NQ	Futures	7642.46	7642.46	7627.09	7630.64	1410.0
2018-04-03 20:00:00	NQ	Futures	7631.53	7632.71	7615.86	7622.66	3235.0
2018-04-03 21:00:00	NQ	Futures	7622.66	7623.25	7601.97	7613.2	6603.0
2018-04-03 22:00:00	NQ	Futures	7613.5	7618.23	7606.11	7618.23	1752.0
2018-04-03 23:00:00	NQ	Futures	7618.82	7620.89	7607.88	7613.79	1481.0
2018-04-03 00:00:00	YM	Futures	25635.6	25642.1	25624.7	25631.2	1157.0
2018-04-03 01:00:00	YM	Futures	25632.3	25638.8	25570.4	25575.8	3836.0
2018-04-03 02:00:00	YM	Futures	25574.8	25642.1	25571.5	25634.5	4706.0
2018-04-03 03:00:00	YM	Futures	25634.5	25679.0	25628.0	25630.1	5479.0

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

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