PREVIEW / futures_1hour / 2019-07-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	3275.53	3276.61	3275.53	3276.34	2957.0
2019-07-30 01:00:00	ES	Futures	3276.34	3276.88	3275.26	3275.53	3208.0
2019-07-30 02:00:00	ES	Futures	3275.53	3275.8	3273.64	3273.91	7143.0
2019-07-30 03:00:00	ES	Futures	3273.91	3274.45	3268.76	3270.12	21105.0
2019-07-30 04:00:00	ES	Futures	3269.85	3270.66	3263.89	3264.16	20897.0
2019-07-30 05:00:00	ES	Futures	3264.43	3266.06	3262.0	3264.97	22325.0
2019-07-30 06:00:00	ES	Futures	3264.97	3265.52	3260.91	3264.97	19778.0
2019-07-30 07:00:00	ES	Futures	3264.97	3264.97	3256.04	3257.12	53075.0
2019-07-30 08:00:00	ES	Futures	3257.12	3260.37	3252.79	3254.69	49227.0
2019-07-30 09:00:00	ES	Futures	3254.69	3261.18	3250.09	3259.83	210631.0
2019-07-30 10:00:00	ES	Futures	3259.83	3263.35	3256.85	3261.45	163188.0
2019-07-30 11:00:00	ES	Futures	3261.73	3265.24	3258.75	3259.56	115662.0
2019-07-30 12:00:00	ES	Futures	3259.29	3263.89	3258.48	3259.56	83613.0
2019-07-30 13:00:00	ES	Futures	3259.56	3263.62	3259.02	3262.54	58835.0
2019-07-30 14:00:00	ES	Futures	3262.54	3268.22	3262.54	3264.16	74341.0
2019-07-30 15:00:00	ES	Futures	3264.43	3265.79	3259.83	3264.43	158701.0
2019-07-30 16:00:00	ES	Futures	3264.43	3265.52	3260.37	3264.97	59241.0
2019-07-30 18:00:00	ES	Futures	3266.06	3266.87	3264.43	3265.79	4414.0
2019-07-30 19:00:00	ES	Futures	3265.52	3266.06	3263.35	3265.79	3274.0
2019-07-30 20:00:00	ES	Futures	3265.79	3268.22	3264.7	3266.6	10332.0
2019-07-30 21:00:00	ES	Futures	3266.6	3267.95	3263.62	3263.89	10854.0
2019-07-30 22:00:00	ES	Futures	3263.89	3267.68	3263.62	3267.41	7482.0
2019-07-30 23:00:00	ES	Futures	3267.41	3269.58	3266.06	3268.76	8856.0
2019-07-30 00:00:00	NQ	Futures	9298.48	9301.97	9297.03	9300.23	1290.0
2019-07-30 01:00:00	NQ	Futures	9300.23	9303.71	9295.0	9297.03	1760.0
2019-07-30 02:00:00	NQ	Futures	9296.74	9297.03	9289.78	9291.23	2139.0
2019-07-30 03:00:00	NQ	Futures	9290.94	9291.81	9268.6	9274.98	8347.0
2019-07-30 04:00:00	NQ	Futures	9274.69	9279.63	9250.61	9252.35	8991.0
2019-07-30 05:00:00	NQ	Futures	9252.06	9256.41	9244.23	9253.51	8156.0
2019-07-30 06:00:00	NQ	Futures	9253.8	9254.96	9239.01	9250.9	6024.0
2019-07-30 07:00:00	NQ	Futures	9251.19	9252.06	9212.02	9221.02	19491.0
2019-07-30 08:00:00	NQ	Futures	9221.02	9231.17	9201.29	9209.7	21585.0
2019-07-30 09:00:00	NQ	Futures	9209.41	9250.61	9205.93	9237.55	73767.0
2019-07-30 10:00:00	NQ	Futures	9237.26	9257.86	9232.33	9243.65	61618.0
2019-07-30 11:00:00	NQ	Futures	9243.65	9258.74	9233.49	9235.81	34970.0
2019-07-30 12:00:00	NQ	Futures	9236.1	9250.32	9232.62	9239.59	23703.0
2019-07-30 13:00:00	NQ	Futures	9239.3	9257.86	9237.26	9255.83	17789.0
2019-07-30 14:00:00	NQ	Futures	9255.83	9281.95	9255.54	9258.16	31809.0
2019-07-30 15:00:00	NQ	Futures	9257.86	9263.09	9232.91	9246.26	41293.0
2019-07-30 16:00:00	NQ	Futures	9246.26	9274.11	9226.53	9271.79	16749.0
2019-07-30 18:00:00	NQ	Futures	9275.85	9279.92	9268.31	9270.34	3222.0
2019-07-30 19:00:00	NQ	Futures	9270.63	9272.66	9263.96	9272.37	2323.0
2019-07-30 20:00:00	NQ	Futures	9272.37	9281.66	9269.18	9272.95	3958.0
2019-07-30 21:00:00	NQ	Futures	9272.95	9277.88	9260.48	9261.06	4431.0
2019-07-30 22:00:00	NQ	Futures	9261.06	9275.56	9259.61	9274.69	3785.0
2019-07-30 23:00:00	NQ	Futures	9274.98	9281.66	9268.89	9277.59	3597.0
2019-07-30 00:00:00	YM	Futures	29614.8	29621.3	29611.5	29619.2	641.0
2019-07-30 01:00:00	YM	Futures	29619.2	29621.3	29603.9	29609.4	1122.0
2019-07-30 02:00:00	YM	Futures	29608.3	29609.4	29589.8	29596.3	1439.0
2019-07-30 03:00:00	YM	Futures	29595.2	29598.5	29551.7	29561.5	3826.0

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

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