PREVIEW / futures_1hour / 2019-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-03.parquet
  size:    54 KB
  rows:    1,724

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-03 00:00:00	ES	Futures	3222.2	3222.47	3220.31	3222.2	4747.0
2019-07-03 01:00:00	ES	Futures	3222.2	3224.91	3221.93	3224.37	8317.0
2019-07-03 02:00:00	ES	Futures	3224.64	3225.18	3222.47	3224.1	7007.0
2019-07-03 03:00:00	ES	Futures	3223.83	3230.86	3223.29	3230.05	23242.0
2019-07-03 04:00:00	ES	Futures	3229.78	3233.84	3229.24	3233.3	22649.0
2019-07-03 05:00:00	ES	Futures	3233.3	3235.47	3233.3	3234.38	16042.0
2019-07-03 06:00:00	ES	Futures	3234.38	3235.74	3233.3	3234.93	10310.0
2019-07-03 07:00:00	ES	Futures	3234.93	3235.2	3232.49	3232.49	12890.0
2019-07-03 08:00:00	ES	Futures	3232.49	3234.11	3231.41	3233.03	18658.0
2019-07-03 09:00:00	ES	Futures	3233.03	3233.57	3228.43	3231.95	126723.0
2019-07-03 10:00:00	ES	Futures	3231.68	3239.26	3230.32	3237.9	153776.0
2019-07-03 11:00:00	ES	Futures	3238.17	3243.05	3235.2	3243.05	116847.0
2019-07-03 12:00:00	ES	Futures	3243.05	3248.19	3242.23	3247.38	138931.0
2019-07-03 13:00:00	ES	Futures	3247.38	3250.09	3246.3	3249.54	54684.0
2019-07-03 18:00:00	ES	Futures	3249.27	3254.96	3248.73	3249.27	5626.0
2019-07-03 19:00:00	ES	Futures	3249.27	3249.27	3247.11	3248.19	2880.0
2019-07-03 20:00:00	ES	Futures	3248.19	3249.27	3247.11	3247.65	4647.0
2019-07-03 21:00:00	ES	Futures	3247.65	3248.73	3246.57	3248.19	3966.0
2019-07-03 22:00:00	ES	Futures	3248.46	3248.73	3246.3	3246.57	3800.0
2019-07-03 23:00:00	ES	Futures	3246.3	3247.65	3246.02	3247.38	2190.0
2019-07-03 00:00:00	NQ	Futures	9088.13	9088.13	9081.75	9086.39	1228.0
2019-07-03 01:00:00	NQ	Futures	9086.1	9092.19	9084.94	9091.03	1912.0
2019-07-03 02:00:00	NQ	Futures	9090.74	9095.68	9087.26	9095.09	2829.0
2019-07-03 03:00:00	NQ	Futures	9095.39	9120.92	9092.19	9116.28	8298.0
2019-07-03 04:00:00	NQ	Futures	9116.28	9129.91	9113.95	9126.72	6058.0
2019-07-03 05:00:00	NQ	Futures	9127.01	9136.01	9125.56	9129.91	4455.0
2019-07-03 06:00:00	NQ	Futures	9129.91	9134.84	9125.85	9131.65	3450.0
2019-07-03 07:00:00	NQ	Futures	9131.65	9132.23	9115.11	9115.4	4564.0
2019-07-03 08:00:00	NQ	Futures	9115.7	9124.4	9109.89	9114.24	6438.0
2019-07-03 09:00:00	NQ	Futures	9114.53	9116.57	9093.06	9106.99	39734.0
2019-07-03 10:00:00	NQ	Futures	9106.7	9133.1	9101.48	9129.33	43283.0
2019-07-03 11:00:00	NQ	Futures	9129.33	9136.59	9116.86	9132.81	32730.0
2019-07-03 12:00:00	NQ	Futures	9132.81	9149.06	9127.59	9148.77	27726.0
2019-07-03 13:00:00	NQ	Futures	9148.48	9160.09	9147.61	9154.86	9285.0
2019-07-03 18:00:00	NQ	Futures	9154.28	9169.66	9152.83	9161.83	1867.0
2019-07-03 19:00:00	NQ	Futures	9161.83	9163.28	9154.86	9156.9	1133.0
2019-07-03 20:00:00	NQ	Futures	9156.9	9159.51	9151.67	9153.99	1741.0
2019-07-03 21:00:00	NQ	Futures	9153.41	9158.06	9150.22	9156.32	1757.0
2019-07-03 22:00:00	NQ	Futures	9156.32	9157.19	9147.03	9148.19	1749.0
2019-07-03 23:00:00	NQ	Futures	9147.9	9153.41	9146.74	9152.25	1314.0
2019-07-03 00:00:00	YM	Futures	29105.9	29108.0	29090.6	29105.9	930.0
2019-07-03 01:00:00	YM	Futures	29105.9	29125.4	29101.5	29122.2	1524.0
2019-07-03 02:00:00	YM	Futures	29121.1	29128.7	29103.7	29117.8	1827.0
2019-07-03 03:00:00	YM	Futures	29117.8	29182.0	29112.4	29166.8	5211.0
2019-07-03 04:00:00	YM	Futures	29166.8	29199.4	29161.3	29197.2	6068.0
2019-07-03 05:00:00	YM	Futures	29197.2	29215.7	29193.9	29205.9	4659.0
2019-07-03 06:00:00	YM	Futures	29207.0	29219.0	29197.2	29207.0	3489.0
2019-07-03 07:00:00	YM	Futures	29207.0	29212.4	29188.5	29188.5	3707.0
2019-07-03 08:00:00	YM	Futures	29189.6	29204.8	29184.2	29199.4	3087.0
2019-07-03 09:00:00	YM	Futures	29198.3	29210.3	29171.1	29191.8	19458.0

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

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