PREVIEW / futures_1hour / 2019-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-09.parquet
  size:    57 KB
  rows:    1,847

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-09 00:00:00	ES	Futures	3212.19	3214.08	3211.37	3213.81	5183.0
2019-07-09 01:00:00	ES	Futures	3213.81	3215.43	3213.54	3214.89	4857.0
2019-07-09 02:00:00	ES	Futures	3215.16	3216.79	3212.46	3213.54	11111.0
2019-07-09 03:00:00	ES	Futures	3213.27	3215.43	3209.21	3209.75	26992.0
2019-07-09 04:00:00	ES	Futures	3209.75	3211.92	3208.94	3211.1	21984.0
2019-07-09 05:00:00	ES	Futures	3211.1	3212.19	3208.94	3210.29	18589.0
2019-07-09 06:00:00	ES	Futures	3210.29	3214.62	3209.75	3213.27	19502.0
2019-07-09 07:00:00	ES	Futures	3213.27	3215.16	3212.46	3213.54	16915.0
2019-07-09 08:00:00	ES	Futures	3213.81	3215.43	3212.19	3214.35	24083.0
2019-07-09 09:00:00	ES	Futures	3214.08	3219.22	3211.37	3217.6	143862.0
2019-07-09 10:00:00	ES	Futures	3217.6	3224.91	3217.6	3221.93	140390.0
2019-07-09 11:00:00	ES	Futures	3221.93	3226.26	3221.39	3224.1	89751.0
2019-07-09 12:00:00	ES	Futures	3224.1	3226.53	3223.56	3224.64	55568.0
2019-07-09 13:00:00	ES	Futures	3224.37	3225.99	3223.29	3225.45	38519.0
2019-07-09 14:00:00	ES	Futures	3225.45	3227.62	3224.37	3226.26	48776.0
2019-07-09 15:00:00	ES	Futures	3226.26	3233.57	3222.74	3230.59	166283.0
2019-07-09 16:00:00	ES	Futures	3230.59	3230.86	3228.7	3229.24	42457.0
2019-07-09 18:00:00	ES	Futures	3229.24	3230.05	3227.89	3228.97	3004.0
2019-07-09 19:00:00	ES	Futures	3228.7	3229.51	3227.08	3228.97	3964.0
2019-07-09 20:00:00	ES	Futures	3228.97	3234.93	3228.43	3233.57	12056.0
2019-07-09 21:00:00	ES	Futures	3233.84	3234.38	3230.05	3230.05	7789.0
2019-07-09 22:00:00	ES	Futures	3230.05	3231.14	3228.7	3230.59	4857.0
2019-07-09 23:00:00	ES	Futures	3230.32	3230.86	3228.97	3228.97	3499.0
2019-07-09 00:00:00	NQ	Futures	9001.96	9009.5	8999.35	9008.34	1852.0
2019-07-09 01:00:00	NQ	Futures	9008.63	9015.89	9007.18	9015.02	2292.0
2019-07-09 02:00:00	NQ	Futures	9014.44	9021.11	9000.8	9006.02	5260.0
2019-07-09 03:00:00	NQ	Futures	9005.73	9011.53	8987.16	8988.61	9254.0
2019-07-09 04:00:00	NQ	Futures	8988.03	9001.38	8986.29	8997.9	7376.0
2019-07-09 05:00:00	NQ	Futures	8998.19	9001.67	8989.19	8999.06	4982.0
2019-07-09 06:00:00	NQ	Futures	8998.77	9012.98	8996.74	9006.6	5011.0
2019-07-09 07:00:00	NQ	Futures	9006.31	9020.82	9006.02	9020.24	6379.0
2019-07-09 08:00:00	NQ	Futures	9020.24	9026.33	9012.4	9022.27	8335.0
2019-07-09 09:00:00	NQ	Futures	9022.27	9053.6	9012.69	9050.12	58966.0
2019-07-09 10:00:00	NQ	Futures	9049.83	9082.62	9049.25	9073.62	57659.0
2019-07-09 11:00:00	NQ	Futures	9073.62	9092.48	9071.01	9088.42	40085.0
2019-07-09 12:00:00	NQ	Futures	9088.42	9102.64	9086.39	9093.64	24702.0
2019-07-09 13:00:00	NQ	Futures	9093.93	9104.38	9087.26	9103.22	17524.0
2019-07-09 14:00:00	NQ	Futures	9103.22	9107.57	9097.42	9104.96	18259.0
2019-07-09 15:00:00	NQ	Futures	9104.96	9120.63	9089.87	9110.76	44669.0
2019-07-09 16:00:00	NQ	Futures	9110.47	9113.37	9103.51	9106.7	8572.0
2019-07-09 18:00:00	NQ	Futures	9108.15	9112.21	9103.8	9107.57	1407.0
2019-07-09 19:00:00	NQ	Futures	9106.99	9108.44	9100.03	9106.99	1354.0
2019-07-09 20:00:00	NQ	Futures	9106.99	9132.81	9104.38	9128.46	5397.0
2019-07-09 21:00:00	NQ	Futures	9128.75	9131.07	9114.24	9115.7	4693.0
2019-07-09 22:00:00	NQ	Futures	9115.4	9118.89	9108.73	9116.28	3201.0
2019-07-09 23:00:00	NQ	Futures	9115.7	9117.15	9109.89	9110.47	1781.0
2019-07-09 00:00:00	YM	Futures	29025.4	29051.5	29011.2	29045.0	3521.0
2019-07-09 01:00:00	YM	Futures	29046.0	29060.2	29039.5	29058.0	1283.0
2019-07-09 02:00:00	YM	Futures	29056.9	29070.0	29033.0	29040.6	2796.0
2019-07-09 03:00:00	YM	Futures	29040.6	29059.1	29006.9	29011.2	4848.0

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

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