PREVIEW / futures_1hour / 2019-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-22.parquet
  size:    56 KB
  rows:    1,816

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-22 00:00:00	ES	Futures	3222.74	3224.1	3222.74	3224.1	2629.0
2019-07-22 01:00:00	ES	Futures	3224.1	3230.86	3222.74	3225.72	11921.0
2019-07-22 02:00:00	ES	Futures	3225.72	3229.78	3225.45	3228.43	13574.0
2019-07-22 03:00:00	ES	Futures	3228.43	3230.32	3225.72	3225.99	25075.0
2019-07-22 04:00:00	ES	Futures	3225.99	3233.03	3225.99	3232.76	19449.0
2019-07-22 05:00:00	ES	Futures	3232.49	3233.03	3230.05	3230.86	12353.0
2019-07-22 06:00:00	ES	Futures	3231.14	3235.2	3229.51	3233.03	12743.0
2019-07-22 07:00:00	ES	Futures	3233.03	3233.57	3231.68	3231.95	12928.0
2019-07-22 08:00:00	ES	Futures	3231.95	3235.74	3228.43	3232.49	43109.0
2019-07-22 09:00:00	ES	Futures	3232.49	3237.09	3228.43	3236.55	155619.0
2019-07-22 10:00:00	ES	Futures	3236.55	3237.09	3225.18	3227.89	159902.0
2019-07-22 11:00:00	ES	Futures	3227.89	3233.03	3225.45	3231.95	118291.0
2019-07-22 12:00:00	ES	Futures	3231.68	3236.82	3228.43	3236.01	75401.0
2019-07-22 13:00:00	ES	Futures	3235.74	3237.09	3233.3	3236.28	47042.0
2019-07-22 14:00:00	ES	Futures	3236.55	3237.36	3233.03	3235.74	59277.0
2019-07-22 15:00:00	ES	Futures	3235.47	3241.42	3231.95	3235.2	178962.0
2019-07-22 16:00:00	ES	Futures	3235.2	3238.44	3233.3	3236.55	44943.0
2019-07-22 18:00:00	ES	Futures	3236.28	3238.44	3235.47	3236.55	3663.0
2019-07-22 19:00:00	ES	Futures	3236.55	3237.9	3235.47	3237.09	1949.0
2019-07-22 20:00:00	ES	Futures	3236.82	3241.15	3234.93	3239.53	13845.0
2019-07-22 21:00:00	ES	Futures	3239.53	3243.05	3238.72	3241.96	10315.0
2019-07-22 22:00:00	ES	Futures	3242.23	3242.23	3239.53	3240.07	4447.0
2019-07-22 23:00:00	ES	Futures	3239.8	3240.88	3238.99	3239.26	4370.0
2019-07-22 00:00:00	NQ	Futures	9098.0	9104.09	9097.13	9103.51	1105.0
2019-07-22 01:00:00	NQ	Futures	9103.22	9132.23	9099.16	9113.66	4687.0
2019-07-22 02:00:00	NQ	Futures	9113.08	9130.78	9112.79	9123.24	4749.0
2019-07-22 03:00:00	NQ	Futures	9123.53	9129.62	9112.5	9115.4	6380.0
2019-07-22 04:00:00	NQ	Futures	9115.11	9138.04	9114.53	9135.71	5196.0
2019-07-22 05:00:00	NQ	Futures	9135.71	9140.07	9129.33	9133.68	4028.0
2019-07-22 06:00:00	NQ	Futures	9133.97	9149.64	9129.33	9145.58	4659.0
2019-07-22 07:00:00	NQ	Futures	9145.87	9147.9	9136.88	9137.75	3485.0
2019-07-22 08:00:00	NQ	Futures	9137.75	9155.15	9125.56	9140.94	12734.0
2019-07-22 09:00:00	NQ	Futures	9140.65	9187.36	9131.94	9185.04	58698.0
2019-07-22 10:00:00	NQ	Futures	9185.04	9191.42	9155.73	9164.73	65572.0
2019-07-22 11:00:00	NQ	Futures	9164.73	9180.69	9154.28	9175.17	40915.0
2019-07-22 12:00:00	NQ	Futures	9175.46	9186.78	9161.54	9185.04	26030.0
2019-07-22 13:00:00	NQ	Futures	9185.04	9189.39	9173.72	9188.52	20351.0
2019-07-22 14:00:00	NQ	Futures	9188.52	9194.03	9178.08	9191.71	18369.0
2019-07-22 15:00:00	NQ	Futures	9191.42	9210.86	9181.85	9193.16	43832.0
2019-07-22 16:00:00	NQ	Futures	9193.16	9205.64	9187.94	9198.97	9544.0
2019-07-22 18:00:00	NQ	Futures	9199.26	9206.22	9197.52	9199.84	2119.0
2019-07-22 19:00:00	NQ	Futures	9200.13	9204.77	9197.52	9202.16	1015.0
2019-07-22 20:00:00	NQ	Futures	9201.87	9214.05	9193.16	9207.96	6575.0
2019-07-22 21:00:00	NQ	Futures	9207.67	9218.99	9204.77	9214.92	3905.0
2019-07-22 22:00:00	NQ	Futures	9215.5	9216.08	9204.77	9206.51	2585.0
2019-07-22 23:00:00	NQ	Futures	9206.22	9210.57	9201.29	9202.45	1928.0
2019-07-22 00:00:00	YM	Futures	29511.5	29515.8	29507.1	29513.7	454.0
2019-07-22 01:00:00	YM	Futures	29514.8	29568.0	29502.8	29527.8	2045.0
2019-07-22 02:00:00	YM	Futures	29527.8	29558.3	29526.7	29545.2	2373.0
2019-07-22 03:00:00	YM	Futures	29546.3	29563.7	29526.7	29532.2	3949.0

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

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