PREVIEW / futures_1hour / 2018-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-07.parquet
  size:    56 KB
  rows:    1,723

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-11-07 00:00:00	ES	Futures	3008.57	3014.83	3001.77	3004.22	17318.0
2018-11-07 01:00:00	ES	Futures	3004.22	3008.84	3002.32	3005.31	8162.0
2018-11-07 02:00:00	ES	Futures	3005.31	3008.03	3001.23	3004.49	15402.0
2018-11-07 03:00:00	ES	Futures	3004.49	3025.16	3004.49	3022.44	51924.0
2018-11-07 04:00:00	ES	Futures	3022.72	3031.69	3022.17	3030.88	33170.0
2018-11-07 05:00:00	ES	Futures	3030.88	3032.24	3027.34	3028.7	21078.0
2018-11-07 06:00:00	ES	Futures	3028.7	3029.52	3023.26	3024.89	18206.0
2018-11-07 07:00:00	ES	Futures	3024.89	3029.52	3020.0	3020.27	26651.0
2018-11-07 08:00:00	ES	Futures	3020.27	3025.44	3018.09	3020.54	36141.0
2018-11-07 09:00:00	ES	Futures	3020.27	3033.05	3017.55	3022.17	241070.0
2018-11-07 10:00:00	ES	Futures	3021.9	3038.49	3018.36	3034.68	249075.0
2018-11-07 11:00:00	ES	Futures	3034.68	3044.2	3032.24	3043.66	181395.0
2018-11-07 12:00:00	ES	Futures	3043.66	3046.38	3040.4	3045.29	106892.0
2018-11-07 13:00:00	ES	Futures	3045.29	3047.74	3039.58	3042.3	93860.0
2018-11-07 14:00:00	ES	Futures	3042.3	3054.81	3041.76	3051.55	157935.0
2018-11-07 15:00:00	ES	Futures	3051.55	3062.7	3050.46	3060.8	276735.0
2018-11-07 16:00:00	ES	Futures	3060.52	3065.69	3059.98	3064.33	90046.0
2018-11-07 18:00:00	ES	Futures	3063.52	3065.69	3061.34	3061.88	9467.0
2018-11-07 19:00:00	ES	Futures	3061.88	3064.88	3061.34	3063.52	7895.0
2018-11-07 20:00:00	ES	Futures	3063.52	3065.96	3058.62	3058.62	12108.0
2018-11-07 21:00:00	ES	Futures	3058.89	3062.43	3056.44	3061.34	9157.0
2018-11-07 22:00:00	ES	Futures	3061.07	3063.79	3061.07	3062.43	5058.0
2018-11-07 23:00:00	ES	Futures	3062.43	3064.06	3061.88	3062.97	3702.0
2018-11-07 00:00:00	NQ	Futures	8269.7	8296.68	8237.43	8247.7	7394.0
2018-11-07 01:00:00	NQ	Futures	8247.11	8261.49	8240.37	8254.45	4006.0
2018-11-07 02:00:00	NQ	Futures	8255.33	8265.3	8239.49	8245.94	5011.0
2018-11-07 03:00:00	NQ	Futures	8247.11	8334.52	8247.11	8325.72	21250.0
2018-11-07 04:00:00	NQ	Futures	8325.72	8356.23	8320.74	8348.01	12500.0
2018-11-07 05:00:00	NQ	Futures	8348.01	8352.41	8328.36	8332.17	8652.0
2018-11-07 06:00:00	NQ	Futures	8331.88	8336.87	8315.16	8319.86	6640.0
2018-11-07 07:00:00	NQ	Futures	8319.86	8339.21	8304.9	8306.95	10100.0
2018-11-07 08:00:00	NQ	Futures	8306.66	8317.51	8294.92	8298.15	13188.0
2018-11-07 09:00:00	NQ	Futures	8297.86	8340.39	8279.09	8316.04	81799.0
2018-11-07 10:00:00	NQ	Futures	8316.34	8406.97	8311.06	8387.9	103913.0
2018-11-07 11:00:00	NQ	Futures	8388.49	8427.5	8373.53	8423.98	63781.0
2018-11-07 12:00:00	NQ	Futures	8423.98	8426.33	8398.46	8415.77	38842.0
2018-11-07 13:00:00	NQ	Futures	8416.06	8426.92	8391.72	8404.92	40132.0
2018-11-07 14:00:00	NQ	Futures	8405.21	8438.94	8404.92	8420.17	46025.0
2018-11-07 15:00:00	NQ	Futures	8420.17	8464.75	8416.94	8459.47	61020.0
2018-11-07 16:00:00	NQ	Futures	8459.47	8476.78	8454.49	8470.33	16164.0
2018-11-07 18:00:00	NQ	Futures	8462.41	8472.97	8458.3	8461.23	2980.0
2018-11-07 19:00:00	NQ	Futures	8460.94	8469.15	8457.71	8467.69	2571.0
2018-11-07 20:00:00	NQ	Futures	8467.98	8483.82	8446.57	8448.03	5527.0
2018-11-07 21:00:00	NQ	Futures	8448.03	8458.59	8441.29	8453.9	4716.0
2018-11-07 22:00:00	NQ	Futures	8453.31	8461.82	8453.31	8458.01	2675.0
2018-11-07 23:00:00	NQ	Futures	8457.71	8461.82	8454.19	8459.18	1296.0
2018-11-07 00:00:00	YM	Futures	27936.4	27988.6	27849.5	27868.0	5520.0
2018-11-07 01:00:00	YM	Futures	27866.9	27922.3	27854.9	27877.7	2650.0
2018-11-07 02:00:00	YM	Futures	27879.9	27903.8	27835.4	27875.6	3765.0
2018-11-07 03:00:00	YM	Futures	27875.6	28040.7	27873.4	28013.5	11196.0

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

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