PREVIEW / futures_1hour / 2018-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-19.parquet
  size:    56 KB
  rows:    1,696

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-06-19 00:00:00	ES	Futures	3002.58	3005.3	3000.67	3004.49	7101.0
2018-06-19 01:00:00	ES	Futures	3004.49	3005.3	2997.67	2998.22	13457.0
2018-06-19 02:00:00	ES	Futures	2998.22	2998.22	2989.23	2991.95	41391.0
2018-06-19 03:00:00	ES	Futures	2991.95	2992.77	2981.6	2990.32	59488.0
2018-06-19 04:00:00	ES	Futures	2990.32	2993.04	2985.14	2991.41	27518.0
2018-06-19 05:00:00	ES	Futures	2991.68	2995.22	2991.41	2994.95	17903.0
2018-06-19 06:00:00	ES	Futures	2994.95	2998.76	2994.13	2995.49	24359.0
2018-06-19 07:00:00	ES	Futures	2995.77	2998.49	2989.77	2998.49	29302.0
2018-06-19 08:00:00	ES	Futures	2998.22	3001.76	2994.95	2999.04	41479.0
2018-06-19 09:00:00	ES	Futures	2999.31	3006.67	2996.86	2999.85	222410.0
2018-06-19 10:00:00	ES	Futures	3000.13	3006.39	2993.04	3003.67	307742.0
2018-06-19 11:00:00	ES	Futures	3003.67	3012.39	3002.58	3010.21	176159.0
2018-06-19 12:00:00	ES	Futures	3009.94	3010.75	3003.12	3006.39	83563.0
2018-06-19 13:00:00	ES	Futures	3006.12	3010.75	3001.76	3009.66	70560.0
2018-06-19 14:00:00	ES	Futures	3009.66	3017.84	3009.66	3016.2	109661.0
2018-06-19 15:00:00	ES	Futures	3016.2	3016.47	3009.39	3014.84	182301.0
2018-06-19 16:00:00	ES	Futures	3014.84	3015.93	3012.11	3014.84	66614.0
2018-06-19 18:00:00	ES	Futures	3013.75	3014.84	3011.03	3012.39	4122.0
2018-06-19 19:00:00	ES	Futures	3012.39	3016.47	3011.84	3016.47	3683.0
2018-06-19 20:00:00	ES	Futures	3016.47	3017.84	3012.93	3013.2	6999.0
2018-06-19 21:00:00	ES	Futures	3012.93	3015.38	3005.03	3013.2	20276.0
2018-06-19 22:00:00	ES	Futures	3012.93	3016.47	3011.3	3011.84	7245.0
2018-06-19 23:00:00	ES	Futures	3011.57	3017.56	3011.3	3017.02	8595.0
2018-06-19 00:00:00	NQ	Futures	8476.89	8492.2	8471.88	8487.78	2639.0
2018-06-19 01:00:00	NQ	Futures	8488.37	8490.14	8466.29	8469.82	3386.0
2018-06-19 02:00:00	NQ	Futures	8469.82	8477.18	8455.98	8461.28	9142.0
2018-06-19 03:00:00	NQ	Futures	8461.58	8463.93	8434.49	8457.46	16175.0
2018-06-19 04:00:00	NQ	Futures	8457.75	8473.35	8445.68	8473.06	8190.0
2018-06-19 05:00:00	NQ	Futures	8473.06	8484.54	8467.47	8476.3	5406.0
2018-06-19 06:00:00	NQ	Futures	8476.0	8487.19	8471.88	8474.83	3980.0
2018-06-19 07:00:00	NQ	Futures	8475.12	8482.78	8442.73	8462.46	11688.0
2018-06-19 08:00:00	NQ	Futures	8462.17	8468.35	8440.67	8460.11	16031.0
2018-06-19 09:00:00	NQ	Futures	8460.4	8506.03	8452.16	8470.7	74400.0
2018-06-19 10:00:00	NQ	Futures	8470.7	8483.66	8429.19	8473.65	92347.0
2018-06-19 11:00:00	NQ	Futures	8473.65	8508.39	8468.64	8500.44	48774.0
2018-06-19 12:00:00	NQ	Futures	8500.15	8503.97	8482.48	8492.79	26105.0
2018-06-19 13:00:00	NQ	Futures	8492.49	8515.16	8483.36	8511.63	22504.0
2018-06-19 14:00:00	NQ	Futures	8511.63	8541.07	8511.33	8537.24	30129.0
2018-06-19 15:00:00	NQ	Futures	8537.24	8543.13	8518.11	8542.25	33680.0
2018-06-19 16:00:00	NQ	Futures	8542.25	8546.96	8532.83	8544.31	8368.0
2018-06-19 18:00:00	NQ	Futures	8542.54	8546.08	8532.24	8535.77	1638.0
2018-06-19 19:00:00	NQ	Futures	8536.07	8552.26	8535.48	8550.79	1702.0
2018-06-19 20:00:00	NQ	Futures	8550.79	8554.61	8540.19	8540.48	2604.0
2018-06-19 21:00:00	NQ	Futures	8540.48	8543.43	8510.75	8531.65	7982.0
2018-06-19 22:00:00	NQ	Futures	8531.06	8541.95	8522.82	8524.29	3021.0
2018-06-19 23:00:00	NQ	Futures	8523.99	8550.49	8523.11	8546.66	4946.0
2018-06-19 00:00:00	YM	Futures	26941.5	26971.9	26916.5	26961.1	2771.0
2018-06-19 01:00:00	YM	Futures	26962.1	26965.4	26865.4	26875.2	4476.0
2018-06-19 02:00:00	YM	Futures	26875.2	26876.3	26775.2	26796.9	9041.0
2018-06-19 03:00:00	YM	Futures	26796.9	26805.6	26709.9	26780.6	13228.0

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

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