PREVIEW / futures_1hour / 2019-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-31.parquet
  size:    60 KB
  rows:    1,838

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-31 00:00:00	ES	Futures	3268.76	3269.85	3268.49	3269.31	3584.0
2019-07-31 01:00:00	ES	Futures	3269.58	3270.39	3267.95	3269.03	6315.0
2019-07-31 02:00:00	ES	Futures	3268.76	3270.93	3264.16	3264.16	23447.0
2019-07-31 03:00:00	ES	Futures	3264.16	3268.49	3263.62	3266.6	22847.0
2019-07-31 04:00:00	ES	Futures	3266.87	3270.66	3266.6	3267.68	19730.0
2019-07-31 05:00:00	ES	Futures	3267.95	3269.58	3267.14	3268.76	14418.0
2019-07-31 06:00:00	ES	Futures	3269.03	3269.31	3264.97	3266.33	14261.0
2019-07-31 07:00:00	ES	Futures	3266.6	3269.31	3266.06	3267.95	15185.0
2019-07-31 08:00:00	ES	Futures	3268.22	3269.58	3267.14	3267.95	19969.0
2019-07-31 09:00:00	ES	Futures	3267.95	3268.22	3263.35	3265.24	119905.0
2019-07-31 10:00:00	ES	Futures	3264.97	3265.79	3258.48	3262.54	117109.0
2019-07-31 11:00:00	ES	Futures	3262.54	3268.49	3262.0	3267.95	101817.0
2019-07-31 12:00:00	ES	Futures	3268.22	3268.49	3264.16	3265.79	54944.0
2019-07-31 13:00:00	ES	Futures	3265.52	3267.14	3261.73	3265.79	64148.0
2019-07-31 14:00:00	ES	Futures	3265.79	3265.79	3202.98	3228.97	548661.0
2019-07-31 15:00:00	ES	Futures	3228.97	3247.11	3223.01	3226.26	555887.0
2019-07-31 16:00:00	ES	Futures	3226.26	3229.24	3218.95	3219.77	136159.0
2019-07-31 18:00:00	ES	Futures	3216.25	3220.31	3211.92	3219.5	19907.0
2019-07-31 19:00:00	ES	Futures	3219.77	3223.01	3218.68	3219.5	11258.0
2019-07-31 20:00:00	ES	Futures	3219.5	3222.74	3217.06	3222.2	22163.0
2019-07-31 21:00:00	ES	Futures	3222.47	3231.68	3221.39	3230.86	24021.0
2019-07-31 22:00:00	ES	Futures	3230.86	3231.68	3227.35	3228.16	12336.0
2019-07-31 23:00:00	ES	Futures	3228.16	3232.22	3227.08	3232.22	8770.0
2019-07-31 00:00:00	NQ	Futures	9277.59	9281.37	9275.85	9278.47	1470.0
2019-07-31 01:00:00	NQ	Futures	9278.47	9282.24	9273.24	9278.76	2805.0
2019-07-31 02:00:00	NQ	Futures	9278.47	9282.24	9259.9	9261.64	8032.0
2019-07-31 03:00:00	NQ	Futures	9261.64	9276.72	9259.9	9268.6	6402.0
2019-07-31 04:00:00	NQ	Futures	9268.31	9286.01	9268.31	9276.72	8492.0
2019-07-31 05:00:00	NQ	Futures	9277.01	9282.53	9274.98	9280.5	3471.0
2019-07-31 06:00:00	NQ	Futures	9280.79	9283.11	9264.83	9270.92	5457.0
2019-07-31 07:00:00	NQ	Futures	9270.92	9281.66	9269.47	9277.3	5453.0
2019-07-31 08:00:00	NQ	Futures	9277.3	9281.95	9275.27	9278.47	7164.0
2019-07-31 09:00:00	NQ	Futures	9278.76	9279.34	9247.13	9261.35	55431.0
2019-07-31 10:00:00	NQ	Futures	9261.06	9276.43	9245.39	9261.35	49826.0
2019-07-31 11:00:00	NQ	Futures	9261.06	9274.11	9255.25	9269.47	35119.0
2019-07-31 12:00:00	NQ	Futures	9269.18	9270.63	9251.19	9257.57	17705.0
2019-07-31 13:00:00	NQ	Futures	9257.86	9263.09	9241.62	9253.8	20930.0
2019-07-31 14:00:00	NQ	Futures	9253.8	9262.51	9031.84	9130.2	155905.0
2019-07-31 15:00:00	NQ	Futures	9129.91	9191.13	9108.44	9121.21	122695.0
2019-07-31 16:00:00	NQ	Futures	9121.79	9131.65	9093.35	9098.87	25239.0
2019-07-31 18:00:00	NQ	Futures	9091.9	9100.32	9075.08	9098.87	8720.0
2019-07-31 19:00:00	NQ	Futures	9098.58	9108.15	9093.93	9096.26	4203.0
2019-07-31 20:00:00	NQ	Futures	9096.55	9110.76	9087.55	9106.99	7770.0
2019-07-31 21:00:00	NQ	Futures	9106.99	9139.78	9103.8	9138.04	8329.0
2019-07-31 22:00:00	NQ	Futures	9138.04	9140.36	9126.43	9128.17	4499.0
2019-07-31 23:00:00	NQ	Futures	9128.17	9141.81	9124.98	9139.78	3390.0
2019-07-31 00:00:00	YM	Futures	29622.4	29630.0	29620.2	29625.7	958.0
2019-07-31 01:00:00	YM	Futures	29625.7	29636.6	29615.9	29623.5	1333.0
2019-07-31 02:00:00	YM	Futures	29622.4	29643.1	29592.0	29595.2	4530.0
2019-07-31 03:00:00	YM	Futures	29594.1	29621.3	29587.6	29605.0	3138.0

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

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