PREVIEW / futures_1hour / 2019-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-24.parquet
  size:    57 KB
  rows:    1,849

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-07-24 00:00:00	ES	Futures	3256.58	3257.12	3255.23	3255.5	3354.0
2019-07-24 01:00:00	ES	Futures	3255.5	3255.77	3253.6	3254.96	5794.0
2019-07-24 02:00:00	ES	Futures	3254.96	3255.5	3253.06	3253.6	7298.0
2019-07-24 03:00:00	ES	Futures	3253.87	3254.15	3246.84	3249.54	27186.0
2019-07-24 04:00:00	ES	Futures	3249.54	3250.9	3244.67	3245.75	20742.0
2019-07-24 05:00:00	ES	Futures	3245.75	3247.92	3244.13	3245.75	16617.0
2019-07-24 06:00:00	ES	Futures	3246.02	3250.09	3245.21	3250.09	17846.0
2019-07-24 07:00:00	ES	Futures	3249.81	3250.36	3247.92	3249.0	27303.0
2019-07-24 08:00:00	ES	Futures	3248.73	3251.17	3246.84	3247.65	25109.0
2019-07-24 09:00:00	ES	Futures	3247.92	3260.64	3247.11	3256.31	138539.0
2019-07-24 10:00:00	ES	Futures	3256.04	3262.27	3255.5	3258.48	146454.0
2019-07-24 11:00:00	ES	Futures	3258.48	3258.75	3253.6	3255.23	98654.0
2019-07-24 12:00:00	ES	Futures	3255.5	3262.27	3255.23	3261.73	78694.0
2019-07-24 13:00:00	ES	Futures	3261.73	3262.27	3259.29	3261.45	56749.0
2019-07-24 14:00:00	ES	Futures	3261.45	3267.14	3260.91	3266.87	91506.0
2019-07-24 15:00:00	ES	Futures	3266.87	3272.28	3265.52	3271.74	159256.0
2019-07-24 16:00:00	ES	Futures	3272.01	3272.28	3267.14	3267.68	63096.0
2019-07-24 18:00:00	ES	Futures	3267.95	3270.66	3267.68	3269.31	4834.0
2019-07-24 19:00:00	ES	Futures	3269.03	3271.74	3269.03	3271.2	2465.0
2019-07-24 20:00:00	ES	Futures	3271.2	3271.74	3269.03	3270.93	7444.0
2019-07-24 21:00:00	ES	Futures	3270.93	3271.74	3269.31	3269.58	6511.0
2019-07-24 22:00:00	ES	Futures	3269.85	3272.55	3269.31	3272.28	4587.0
2019-07-24 23:00:00	ES	Futures	3272.01	3273.09	3271.2	3272.55	4340.0
2019-07-24 00:00:00	NQ	Futures	9247.71	9251.48	9243.94	9244.52	1630.0
2019-07-24 01:00:00	NQ	Futures	9244.23	9245.1	9235.23	9239.3	3160.0
2019-07-24 02:00:00	NQ	Futures	9239.3	9240.17	9230.01	9232.91	3061.0
2019-07-24 03:00:00	NQ	Futures	9232.91	9234.07	9208.25	9219.57	8204.0
2019-07-24 04:00:00	NQ	Futures	9219.28	9225.08	9201.0	9205.35	7068.0
2019-07-24 05:00:00	NQ	Futures	9205.35	9212.02	9197.81	9207.09	4999.0
2019-07-24 06:00:00	NQ	Futures	9207.09	9227.4	9204.48	9226.82	5766.0
2019-07-24 07:00:00	NQ	Futures	9226.82	9232.33	9217.54	9229.14	7377.0
2019-07-24 08:00:00	NQ	Futures	9229.43	9235.81	9215.21	9216.95	12089.0
2019-07-24 09:00:00	NQ	Futures	9217.24	9262.22	9213.47	9248.87	49213.0
2019-07-24 10:00:00	NQ	Futures	9248.87	9278.76	9242.78	9261.06	54241.0
2019-07-24 11:00:00	NQ	Futures	9261.06	9272.66	9249.16	9259.9	38324.0
2019-07-24 12:00:00	NQ	Futures	9260.48	9278.47	9259.03	9275.27	24828.0
2019-07-24 13:00:00	NQ	Futures	9274.98	9276.72	9263.38	9272.95	19868.0
2019-07-24 14:00:00	NQ	Futures	9272.95	9296.74	9268.6	9296.74	31198.0
2019-07-24 15:00:00	NQ	Futures	9296.74	9315.31	9293.26	9314.44	42438.0
2019-07-24 16:00:00	NQ	Futures	9314.44	9344.62	9285.43	9286.88	21559.0
2019-07-24 18:00:00	NQ	Futures	9289.78	9302.26	9288.62	9297.32	2704.0
2019-07-24 19:00:00	NQ	Futures	9297.32	9305.74	9297.03	9304.29	940.0
2019-07-24 20:00:00	NQ	Futures	9304.58	9305.74	9295.29	9298.19	2567.0
2019-07-24 21:00:00	NQ	Futures	9298.48	9302.55	9292.39	9295.58	2973.0
2019-07-24 22:00:00	NQ	Futures	9295.29	9302.55	9292.97	9302.26	1891.0
2019-07-24 23:00:00	NQ	Futures	9301.97	9306.61	9299.36	9304.29	1626.0
2019-07-24 00:00:00	YM	Futures	29727.9	29731.2	29719.2	29722.5	591.0
2019-07-24 01:00:00	YM	Futures	29722.5	29723.6	29705.1	29713.8	1077.0
2019-07-24 02:00:00	YM	Futures	29713.8	29715.9	29698.5	29701.8	1629.0
2019-07-24 03:00:00	YM	Futures	29702.9	29708.3	29646.3	29669.2	4575.0

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

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