PREVIEW / futures_1hour / 2020-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-22.parquet
  size:    61 KB
  rows:    1,853

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
2020-06-22 00:00:00	ES	Futures	3439.72	3442.79	3430.79	3432.46	8331.0
2020-06-22 01:00:00	ES	Futures	3432.18	3435.25	3424.36	3427.71	13798.0
2020-06-22 02:00:00	ES	Futures	3427.71	3437.49	3420.45	3435.53	20920.0
2020-06-22 03:00:00	ES	Futures	3435.53	3449.77	3426.04	3445.31	38372.0
2020-06-22 04:00:00	ES	Futures	3445.03	3454.24	3440.0	3452.29	21307.0
2020-06-22 05:00:00	ES	Futures	3452.29	3458.99	3448.66	3449.77	25250.0
2020-06-22 06:00:00	ES	Futures	3449.77	3450.33	3441.12	3443.63	15880.0
2020-06-22 07:00:00	ES	Futures	3443.35	3444.47	3433.3	3443.91	33287.0
2020-06-22 08:00:00	ES	Futures	3443.91	3448.66	3438.6	3441.96	36777.0
2020-06-22 09:00:00	ES	Futures	3441.96	3446.42	3424.92	3444.75	177824.0
2020-06-22 10:00:00	ES	Futures	3444.47	3457.31	3440.56	3440.84	176351.0
2020-06-22 11:00:00	ES	Futures	3440.84	3455.36	3437.21	3451.17	116772.0
2020-06-22 12:00:00	ES	Futures	3450.89	3470.44	3450.89	3467.09	112057.0
2020-06-22 13:00:00	ES	Futures	3467.09	3470.44	3461.22	3466.53	62394.0
2020-06-22 14:00:00	ES	Futures	3466.53	3473.23	3458.15	3472.39	92675.0
2020-06-22 15:00:00	ES	Futures	3472.11	3473.23	3453.4	3469.32	218989.0
2020-06-22 16:00:00	ES	Futures	3469.32	3478.54	3467.65	3473.79	57757.0
2020-06-22 18:00:00	ES	Futures	3475.74	3484.4	3471.56	3483.28	14400.0
2020-06-22 19:00:00	ES	Futures	3483.28	3490.82	3482.45	3487.47	11851.0
2020-06-22 20:00:00	ES	Futures	3487.47	3487.75	3481.33	3485.24	12914.0
2020-06-22 21:00:00	ES	Futures	3484.96	3486.36	3417.94	3474.07	135792.0
2020-06-22 22:00:00	ES	Futures	3474.35	3485.8	3461.5	3476.02	60607.0
2020-06-22 23:00:00	ES	Futures	3476.02	3480.49	3469.6	3474.07	12302.0
2020-06-22 00:00:00	NQ	Futures	11555.0	11564.54	11529.26	11532.73	3897.0
2020-06-22 01:00:00	NQ	Futures	11531.57	11543.72	11511.62	11526.08	5053.0
2020-06-22 02:00:00	NQ	Futures	11526.66	11556.15	11503.81	11547.77	6059.0
2020-06-22 03:00:00	NQ	Futures	11547.77	11584.49	11528.1	11570.61	9651.0
2020-06-22 04:00:00	NQ	Futures	11571.77	11589.7	11557.6	11584.78	5961.0
2020-06-22 05:00:00	NQ	Futures	11584.78	11611.39	11582.18	11587.09	6721.0
2020-06-22 06:00:00	NQ	Futures	11586.23	11589.12	11558.76	11567.72	4891.0
2020-06-22 07:00:00	NQ	Futures	11567.43	11585.94	11548.06	11584.78	6772.0
2020-06-22 08:00:00	NQ	Futures	11585.36	11592.88	11560.49	11563.67	9636.0
2020-06-22 09:00:00	NQ	Futures	11563.67	11591.72	11539.09	11591.72	47909.0
2020-06-22 10:00:00	NQ	Futures	11591.72	11633.36	11590.56	11592.88	48366.0
2020-06-22 11:00:00	NQ	Futures	11592.3	11646.67	11581.89	11633.36	32880.0
2020-06-22 12:00:00	NQ	Futures	11633.36	11688.31	11633.07	11675.87	32937.0
2020-06-22 13:00:00	NQ	Futures	11675.87	11684.55	11658.52	11677.61	17359.0
2020-06-22 14:00:00	NQ	Futures	11677.32	11702.48	11655.34	11698.72	26793.0
2020-06-22 15:00:00	NQ	Futures	11698.14	11705.95	11643.48	11699.87	40976.0
2020-06-22 16:00:00	NQ	Futures	11700.16	11722.72	11692.07	11707.68	9962.0
2020-06-22 18:00:00	NQ	Futures	11707.68	11736.89	11700.16	11730.53	3939.0
2020-06-22 19:00:00	NQ	Futures	11731.39	11750.19	11727.64	11740.94	3544.0
2020-06-22 20:00:00	NQ	Futures	11740.07	11741.23	11719.25	11731.68	3920.0
2020-06-22 21:00:00	NQ	Futures	11731.11	11736.02	11535.04	11669.51	27262.0
2020-06-22 22:00:00	NQ	Futures	11670.96	11723.3	11655.92	11697.85	11437.0
2020-06-22 23:00:00	NQ	Futures	11698.14	11710.0	11680.5	11687.73	3668.0
2020-06-22 00:00:00	YM	Futures	28298.2	28325.7	28209.0	28229.9	2784.0
2020-06-22 01:00:00	YM	Futures	28225.5	28240.9	28137.4	28166.1	3516.0
2020-06-22 02:00:00	YM	Futures	28168.3	28277.3	28094.5	28248.6	4871.0
2020-06-22 03:00:00	YM	Futures	28249.7	28384.1	28167.2	28338.9	7320.0

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

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