PREVIEW / futures_1hour / 2019-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-05.parquet
  size:    50 KB
  rows:    1,423

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-05 00:00:00	ES	Futures	3251.44	3252.79	3251.17	3252.25	3250.0
2019-07-05 01:00:00	ES	Futures	3252.25	3252.79	3251.71	3252.25	3002.0
2019-07-05 02:00:00	ES	Futures	3252.25	3252.52	3249.81	3250.63	5039.0
2019-07-05 03:00:00	ES	Futures	3250.63	3250.63	3245.48	3247.11	18265.0
2019-07-05 04:00:00	ES	Futures	3247.38	3247.65	3241.69	3241.96	16511.0
2019-07-05 05:00:00	ES	Futures	3242.23	3244.13	3241.15	3241.69	11954.0
2019-07-05 06:00:00	ES	Futures	3241.96	3244.4	3241.69	3243.32	10984.0
2019-07-05 07:00:00	ES	Futures	3243.32	3244.94	3241.96	3242.51	11223.0
2019-07-05 08:00:00	ES	Futures	3242.23	3245.48	3231.14	3235.47	93471.0
2019-07-05 09:00:00	ES	Futures	3235.2	3235.2	3224.37	3224.91	182000.0
2019-07-05 10:00:00	ES	Futures	3224.64	3228.97	3217.33	3223.56	200168.0
2019-07-05 11:00:00	ES	Futures	3223.83	3229.78	3221.12	3229.78	123016.0
2019-07-05 12:00:00	ES	Futures	3229.51	3237.09	3226.8	3235.74	90389.0
2019-07-05 13:00:00	ES	Futures	3235.47	3241.15	3233.57	3239.26	73037.0
2019-07-05 14:00:00	ES	Futures	3238.99	3246.02	3237.9	3245.75	59981.0
2019-07-05 15:00:00	ES	Futures	3245.48	3246.02	3235.74	3243.05	186775.0
2019-07-05 16:00:00	ES	Futures	3243.05	3243.86	3237.36	3239.53	66241.0
2019-07-05 00:00:00	NQ	Futures	9171.4	9174.59	9170.82	9173.72	828.0
2019-07-05 01:00:00	NQ	Futures	9173.72	9178.08	9172.85	9177.5	1427.0
2019-07-05 02:00:00	NQ	Futures	9177.5	9178.08	9168.21	9169.66	2183.0
2019-07-05 03:00:00	NQ	Futures	9169.66	9169.66	9153.99	9158.06	5237.0
2019-07-05 04:00:00	NQ	Futures	9158.06	9159.22	9136.3	9137.46	6183.0
2019-07-05 05:00:00	NQ	Futures	9137.46	9143.84	9129.91	9131.36	4260.0
2019-07-05 06:00:00	NQ	Futures	9131.36	9140.65	9130.49	9139.2	3071.0
2019-07-05 07:00:00	NQ	Futures	9139.2	9143.55	9131.07	9132.81	3369.0
2019-07-05 08:00:00	NQ	Futures	9132.52	9143.84	9084.36	9099.16	30153.0
2019-07-05 09:00:00	NQ	Futures	9099.16	9100.32	9060.86	9062.6	51431.0
2019-07-05 10:00:00	NQ	Futures	9062.6	9082.33	9049.25	9063.47	55951.0
2019-07-05 11:00:00	NQ	Futures	9063.76	9087.84	9056.22	9084.36	34905.0
2019-07-05 12:00:00	NQ	Futures	9084.65	9109.89	9074.49	9103.8	27096.0
2019-07-05 13:00:00	NQ	Futures	9103.8	9129.33	9098.87	9123.24	24941.0
2019-07-05 14:00:00	NQ	Futures	9122.95	9145.87	9117.15	9144.13	21544.0
2019-07-05 15:00:00	NQ	Futures	9144.42	9145.29	9111.92	9131.94	41158.0
2019-07-05 16:00:00	NQ	Futures	9131.36	9132.81	9111.05	9116.28	8843.0
2019-07-05 00:00:00	YM	Futures	29354.9	29361.4	29353.8	29358.2	582.0
2019-07-05 01:00:00	YM	Futures	29358.2	29366.9	29354.9	29358.2	744.0
2019-07-05 02:00:00	YM	Futures	29357.1	29360.3	29336.4	29344.0	1786.0
2019-07-05 03:00:00	YM	Futures	29345.1	29345.1	29301.6	29313.6	4065.0
2019-07-05 04:00:00	YM	Futures	29313.6	29316.8	29274.4	29277.7	3697.0
2019-07-05 05:00:00	YM	Futures	29277.7	29301.6	29274.4	29284.2	2753.0
2019-07-05 06:00:00	YM	Futures	29283.1	29300.5	29282.0	29292.9	1455.0
2019-07-05 07:00:00	YM	Futures	29292.9	29299.4	29275.5	29283.1	1934.0
2019-07-05 08:00:00	YM	Futures	29282.0	29308.1	29196.1	29234.2	14831.0
2019-07-05 09:00:00	YM	Futures	29233.1	29233.1	29149.4	29157.0	26738.0
2019-07-05 10:00:00	YM	Futures	29157.0	29193.9	29066.7	29134.1	27953.0
2019-07-05 11:00:00	YM	Futures	29134.1	29210.3	29111.3	29210.3	18968.0
2019-07-05 12:00:00	YM	Futures	29209.2	29273.3	29190.7	29258.1	16406.0
2019-07-05 13:00:00	YM	Futures	29257.0	29288.6	29240.7	29265.7	12024.0
2019-07-05 14:00:00	YM	Futures	29264.6	29304.9	29251.6	29304.9	9965.0
2019-07-05 15:00:00	YM	Futures	29304.9	29306.0	29223.3	29283.1	20720.0

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

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