PREVIEW / futures_1hour / 2019-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-12.parquet
  size:    48 KB
  rows:    1,458

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-12 00:00:00	ES	Futures	3260.37	3261.18	3259.83	3260.37	3481.0
2019-07-12 01:00:00	ES	Futures	3260.37	3261.18	3259.56	3260.91	4703.0
2019-07-12 02:00:00	ES	Futures	3261.18	3261.18	3257.39	3257.66	10174.0
2019-07-12 03:00:00	ES	Futures	3257.66	3259.29	3256.85	3258.48	20854.0
2019-07-12 04:00:00	ES	Futures	3258.48	3261.45	3257.39	3260.1	17827.0
2019-07-12 05:00:00	ES	Futures	3260.37	3261.73	3259.56	3260.37	17462.0
2019-07-12 06:00:00	ES	Futures	3260.64	3262.27	3258.21	3259.56	20665.0
2019-07-12 07:00:00	ES	Futures	3259.83	3260.64	3257.94	3259.83	16017.0
2019-07-12 08:00:00	ES	Futures	3259.83	3261.18	3258.75	3259.56	22581.0
2019-07-12 09:00:00	ES	Futures	3259.56	3259.83	3255.5	3256.85	135625.0
2019-07-12 10:00:00	ES	Futures	3257.12	3259.83	3254.42	3255.77	120492.0
2019-07-12 11:00:00	ES	Futures	3255.77	3260.37	3254.42	3259.29	88051.0
2019-07-12 12:00:00	ES	Futures	3259.29	3260.91	3257.66	3260.64	66831.0
2019-07-12 13:00:00	ES	Futures	3260.91	3261.18	3258.75	3259.56	38267.0
2019-07-12 14:00:00	ES	Futures	3259.56	3263.89	3259.29	3263.62	79790.0
2019-07-12 15:00:00	ES	Futures	3263.35	3267.95	3261.45	3266.87	147909.0
2019-07-12 16:00:00	ES	Futures	3266.87	3267.68	3263.62	3263.89	59674.0
2019-07-12 00:00:00	NQ	Futures	9211.73	9212.6	9205.35	9206.22	1600.0
2019-07-12 01:00:00	NQ	Futures	9206.22	9211.73	9203.61	9210.28	2071.0
2019-07-12 02:00:00	NQ	Futures	9210.57	9212.31	9199.55	9201.0	3891.0
2019-07-12 03:00:00	NQ	Futures	9200.71	9208.83	9197.81	9204.19	4511.0
2019-07-12 04:00:00	NQ	Futures	9203.9	9219.86	9201.0	9216.08	6157.0
2019-07-12 05:00:00	NQ	Futures	9216.37	9219.57	9212.89	9216.08	4061.0
2019-07-12 06:00:00	NQ	Futures	9216.08	9223.92	9207.09	9213.18	5476.0
2019-07-12 07:00:00	NQ	Futures	9213.47	9216.37	9204.19	9209.99	4345.0
2019-07-12 08:00:00	NQ	Futures	9210.28	9217.54	9204.48	9206.51	7298.0
2019-07-12 09:00:00	NQ	Futures	9206.51	9223.63	9196.93	9212.02	44766.0
2019-07-12 10:00:00	NQ	Futures	9211.73	9226.53	9192.29	9202.45	55608.0
2019-07-12 11:00:00	NQ	Futures	9202.45	9226.24	9198.1	9225.37	33055.0
2019-07-12 12:00:00	NQ	Futures	9225.37	9235.23	9221.89	9234.07	25683.0
2019-07-12 13:00:00	NQ	Futures	9234.07	9236.39	9221.6	9225.95	16630.0
2019-07-12 14:00:00	NQ	Futures	9225.66	9234.07	9224.5	9233.78	18476.0
2019-07-12 15:00:00	NQ	Futures	9233.78	9245.97	9225.37	9244.52	34889.0
2019-07-12 16:00:00	NQ	Futures	9244.23	9246.84	9234.94	9236.39	8755.0
2019-07-12 00:00:00	YM	Futures	29540.9	29549.6	29535.4	29544.1	1514.0
2019-07-12 01:00:00	YM	Futures	29544.1	29551.7	29537.6	29548.5	1048.0
2019-07-12 02:00:00	YM	Futures	29548.5	29548.5	29514.8	29516.9	2082.0
2019-07-12 03:00:00	YM	Futures	29516.9	29532.2	29500.6	29519.1	6366.0
2019-07-12 04:00:00	YM	Futures	29520.2	29547.4	29514.8	29531.1	4808.0
2019-07-12 05:00:00	YM	Futures	29531.1	29553.9	29523.5	29545.2	4294.0
2019-07-12 06:00:00	YM	Futures	29544.1	29559.3	29521.3	29535.4	3513.0
2019-07-12 07:00:00	YM	Futures	29535.4	29543.0	29521.3	29536.5	2360.0
2019-07-12 08:00:00	YM	Futures	29537.6	29548.5	29524.5	29530.0	3697.0
2019-07-12 09:00:00	YM	Futures	29528.9	29609.4	29521.3	29593.1	22440.0
2019-07-12 10:00:00	YM	Futures	29594.1	29625.7	29569.1	29580.0	20325.0
2019-07-12 11:00:00	YM	Futures	29578.9	29614.8	29568.0	29603.9	13525.0
2019-07-12 12:00:00	YM	Futures	29603.9	29635.5	29593.1	29624.6	9731.0
2019-07-12 13:00:00	YM	Futures	29625.7	29626.8	29598.5	29614.8	5373.0
2019-07-12 14:00:00	YM	Futures	29615.9	29663.7	29612.6	29657.2	9902.0
2019-07-12 15:00:00	YM	Futures	29657.2	29721.4	29638.7	29713.8	16273.0

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

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