PREVIEW / futures_1hour / 2019-12-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-03.parquet
  size:    61 KB
  rows:    1,877

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-12-03 00:00:00	ES	Futures	3390.23	3391.86	3389.14	3390.77	7530.0
2019-12-03 01:00:00	ES	Futures	3391.04	3391.31	3388.05	3389.68	5280.0
2019-12-03 02:00:00	ES	Futures	3389.41	3390.77	3386.42	3386.7	10605.0
2019-12-03 03:00:00	ES	Futures	3386.7	3390.5	3386.42	3389.41	23822.0
2019-12-03 04:00:00	ES	Futures	3389.14	3391.31	3384.79	3388.32	19414.0
2019-12-03 05:00:00	ES	Futures	3388.32	3389.95	3369.85	3371.76	80392.0
2019-12-03 06:00:00	ES	Futures	3371.76	3376.37	3370.4	3375.83	27877.0
2019-12-03 07:00:00	ES	Futures	3375.83	3376.1	3364.15	3365.24	42408.0
2019-12-03 08:00:00	ES	Futures	3365.24	3366.87	3353.83	3355.19	92412.0
2019-12-03 09:00:00	ES	Futures	3355.19	3355.73	3335.09	3346.22	466916.0
2019-12-03 10:00:00	ES	Futures	3346.22	3350.84	3337.8	3344.32	381749.0
2019-12-03 11:00:00	ES	Futures	3344.32	3349.21	3339.97	3347.04	195843.0
2019-12-03 12:00:00	ES	Futures	3346.77	3350.3	3343.78	3349.48	107734.0
2019-12-03 13:00:00	ES	Futures	3349.21	3356.82	3348.94	3353.01	112655.0
2019-12-03 14:00:00	ES	Futures	3353.28	3355.19	3348.12	3351.93	102266.0
2019-12-03 15:00:00	ES	Futures	3352.2	3362.52	3350.02	3360.89	248547.0
2019-12-03 16:00:00	ES	Futures	3360.89	3361.7	3356.82	3359.26	62813.0
2019-12-03 18:00:00	ES	Futures	3359.26	3362.52	3358.45	3362.25	9353.0
2019-12-03 19:00:00	ES	Futures	3362.52	3364.15	3355.73	3358.17	22022.0
2019-12-03 20:00:00	ES	Futures	3357.9	3361.7	3355.19	3358.45	22110.0
2019-12-03 21:00:00	ES	Futures	3358.17	3360.08	3357.36	3358.99	10072.0
2019-12-03 22:00:00	ES	Futures	3358.72	3361.98	3357.63	3360.89	16446.0
2019-12-03 23:00:00	ES	Futures	3360.89	3362.25	3359.8	3361.7	13379.0
2019-12-03 00:00:00	NQ	Futures	9679.2	9687.92	9675.14	9682.69	5462.0
2019-12-03 01:00:00	NQ	Futures	9682.98	9684.43	9671.36	9676.88	3321.0
2019-12-03 02:00:00	NQ	Futures	9676.88	9682.11	9668.16	9669.62	5241.0
2019-12-03 03:00:00	NQ	Futures	9669.33	9681.82	9668.16	9677.75	7905.0
2019-12-03 04:00:00	NQ	Futures	9677.75	9686.76	9665.55	9676.3	7528.0
2019-12-03 05:00:00	NQ	Futures	9676.3	9682.4	9610.36	9616.46	23183.0
2019-12-03 06:00:00	NQ	Futures	9616.46	9636.79	9612.39	9635.05	9221.0
2019-12-03 07:00:00	NQ	Futures	9635.05	9635.05	9587.99	9592.93	14496.0
2019-12-03 08:00:00	NQ	Futures	9592.64	9599.32	9552.84	9554.58	34468.0
2019-12-03 09:00:00	NQ	Futures	9554.29	9556.33	9491.26	9530.76	126802.0
2019-12-03 10:00:00	NQ	Futures	9530.76	9552.26	9509.56	9520.3	102104.0
2019-12-03 11:00:00	NQ	Futures	9520.3	9540.64	9509.27	9533.38	63666.0
2019-12-03 12:00:00	NQ	Futures	9533.09	9548.48	9522.63	9546.45	32934.0
2019-12-03 13:00:00	NQ	Futures	9546.45	9574.05	9544.71	9559.52	32588.0
2019-12-03 14:00:00	NQ	Futures	9559.81	9567.65	9545.29	9562.14	31335.0
2019-12-03 15:00:00	NQ	Futures	9562.72	9599.32	9553.42	9595.54	54608.0
2019-12-03 16:00:00	NQ	Futures	9595.25	9596.7	9581.6	9592.64	10510.0
2019-12-03 18:00:00	NQ	Futures	9596.41	9600.48	9587.7	9599.9	3736.0
2019-12-03 19:00:00	NQ	Futures	9599.9	9606.29	9577.53	9586.54	8781.0
2019-12-03 20:00:00	NQ	Futures	9586.25	9599.03	9576.37	9586.83	8077.0
2019-12-03 21:00:00	NQ	Futures	9586.54	9594.38	9585.37	9590.02	3780.0
2019-12-03 22:00:00	NQ	Futures	9590.02	9600.48	9583.92	9596.12	10796.0
2019-12-03 23:00:00	NQ	Futures	9596.7	9604.84	9594.09	9601.93	9416.0
2019-12-03 00:00:00	YM	Futures	30292.1	30303.0	30280.1	30295.4	1261.0
2019-12-03 01:00:00	YM	Futures	30295.4	30298.6	30271.4	30284.5	985.0
2019-12-03 02:00:00	YM	Futures	30285.6	30298.6	30258.4	30259.5	1949.0
2019-12-03 03:00:00	YM	Futures	30259.5	30293.2	30254.0	30281.2	4294.0

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

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