PREVIEW / futures_1hour / 2018-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-13.parquet
  size:    50 KB
  rows:    1,585

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
2018-09-13 00:00:00	ES	Futures	3146.71	3146.99	3145.08	3145.08	1941.0
2018-09-13 01:00:00	ES	Futures	3145.08	3145.62	3144.26	3144.26	3960.0
2018-09-13 02:00:00	ES	Futures	3144.53	3147.53	3143.99	3147.26	6452.0
2018-09-13 03:00:00	ES	Futures	3147.26	3151.89	3146.99	3151.62	17180.0
2018-09-13 04:00:00	ES	Futures	3151.62	3151.89	3150.26	3151.07	9897.0
2018-09-13 05:00:00	ES	Futures	3151.35	3152.71	3148.62	3150.26	10413.0
2018-09-13 06:00:00	ES	Futures	3149.98	3154.89	3149.71	3152.71	14567.0
2018-09-13 07:00:00	ES	Futures	3152.71	3156.79	3152.71	3156.25	20204.0
2018-09-13 08:00:00	ES	Futures	3156.25	3160.88	3154.89	3158.16	56440.0
2018-09-13 09:00:00	ES	Futures	3158.16	3167.15	3157.88	3164.42	189492.0
2018-09-13 10:00:00	ES	Futures	3164.7	3168.24	3156.79	3159.79	303596.0
2018-09-13 11:00:00	ES	Futures	3159.79	3165.79	3157.34	3165.79	126653.0
2018-09-13 12:00:00	ES	Futures	3165.79	3167.97	3163.88	3165.24	78122.0
2018-09-13 13:00:00	ES	Futures	3165.24	3165.79	3162.79	3163.61	63492.0
2018-09-13 14:00:00	ES	Futures	3163.33	3166.88	3161.15	3166.6	70554.0
2018-09-13 15:00:00	ES	Futures	3166.88	3167.15	3161.43	3166.33	116918.0
2018-09-13 16:00:00	ES	Futures	3166.33	3167.69	3165.24	3166.06	47241.0
2018-09-13 18:00:00	ES	Futures	3165.79	3166.6	3164.42	3166.06	2320.0
2018-09-13 19:00:00	ES	Futures	3166.06	3167.15	3165.24	3166.06	1611.0
2018-09-13 20:00:00	ES	Futures	3166.33	3168.51	3165.51	3167.42	6398.0
2018-09-13 21:00:00	ES	Futures	3167.15	3167.97	3163.33	3164.7	5778.0
2018-09-13 22:00:00	ES	Futures	3164.97	3167.97	3164.42	3167.15	3468.0
2018-09-13 23:00:00	ES	Futures	3167.15	3167.69	3166.6	3166.6	2233.0
2018-09-13 00:00:00	NQ	Futures	8809.58	8811.05	8799.57	8800.16	2195.0
2018-09-13 01:00:00	NQ	Futures	8800.16	8805.16	8797.21	8799.86	2698.0
2018-09-13 02:00:00	NQ	Futures	8800.16	8812.82	8799.28	8811.94	2893.0
2018-09-13 03:00:00	NQ	Futures	8811.94	8826.07	8810.76	8825.18	6493.0
2018-09-13 04:00:00	NQ	Futures	8825.48	8830.48	8824.3	8829.31	4794.0
2018-09-13 05:00:00	NQ	Futures	8829.6	8836.67	8821.36	8827.25	6122.0
2018-09-13 06:00:00	NQ	Futures	8827.25	8846.97	8825.18	8841.08	6156.0
2018-09-13 07:00:00	NQ	Futures	8840.79	8852.86	8840.79	8850.8	7661.0
2018-09-13 08:00:00	NQ	Futures	8850.8	8871.7	8847.56	8859.63	18284.0
2018-09-13 09:00:00	NQ	Futures	8859.63	8926.46	8859.63	8898.79	80913.0
2018-09-13 10:00:00	NQ	Futures	8899.38	8921.75	8871.11	8891.72	101293.0
2018-09-13 11:00:00	NQ	Futures	8891.72	8923.81	8882.6	8921.16	47526.0
2018-09-13 12:00:00	NQ	Futures	8921.16	8930.59	8910.27	8914.39	37782.0
2018-09-13 13:00:00	NQ	Futures	8914.39	8916.45	8898.2	8905.27	22010.0
2018-09-13 14:00:00	NQ	Futures	8904.97	8917.34	8888.19	8909.68	28296.0
2018-09-13 15:00:00	NQ	Futures	8909.98	8910.86	8890.54	8907.62	31274.0
2018-09-13 16:00:00	NQ	Futures	8907.92	8914.1	8904.97	8909.68	8472.0
2018-09-13 18:00:00	NQ	Futures	8907.33	8915.57	8902.62	8911.15	963.0
2018-09-13 19:00:00	NQ	Futures	8911.15	8919.1	8909.39	8915.57	1369.0
2018-09-13 20:00:00	NQ	Futures	8916.16	8924.7	8916.16	8920.87	2222.0
2018-09-13 21:00:00	NQ	Futures	8920.58	8925.29	8909.09	8913.22	2034.0
2018-09-13 22:00:00	NQ	Futures	8913.22	8923.23	8912.63	8921.46	1305.0
2018-09-13 23:00:00	NQ	Futures	8921.46	8923.23	8917.04	8917.34	1900.0
2018-09-13 00:00:00	YM	Futures	28287.3	28290.6	28274.3	28274.3	18.0
2018-09-13 01:00:00	YM	Futures	28268.9	28272.1	28252.6	28259.1	118.0
2018-09-13 02:00:00	YM	Futures	28260.2	28284.1	28251.5	28279.7	82.0
2018-09-13 03:00:00	YM	Futures	28284.1	28336.2	28283.0	28336.2	377.0

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

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