PREVIEW / futures_1hour / 2017-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-06.parquet
  size:    53 KB
  rows:    1,637

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
2017-12-06 00:00:00	ES	Futures	2871.27	2871.54	2869.08	2871.27	9860.0
2017-12-06 01:00:00	ES	Futures	2871.27	2873.19	2870.45	2872.37	5679.0
2017-12-06 02:00:00	ES	Futures	2872.64	2872.91	2866.89	2870.18	20905.0
2017-12-06 03:00:00	ES	Futures	2869.9	2872.91	2869.08	2872.64	25214.0
2017-12-06 04:00:00	ES	Futures	2872.64	2874.01	2869.9	2870.45	14978.0
2017-12-06 05:00:00	ES	Futures	2870.45	2872.37	2869.08	2871.27	19264.0
2017-12-06 06:00:00	ES	Futures	2871.27	2873.19	2870.45	2872.91	16037.0
2017-12-06 07:00:00	ES	Futures	2872.91	2874.55	2871.54	2873.73	15546.0
2017-12-06 08:00:00	ES	Futures	2874.01	2875.37	2871.27	2874.83	33652.0
2017-12-06 09:00:00	ES	Futures	2875.1	2879.2	2872.37	2877.29	162629.0
2017-12-06 10:00:00	ES	Futures	2877.29	2881.39	2871.27	2881.12	179189.0
2017-12-06 11:00:00	ES	Futures	2881.12	2881.94	2875.92	2877.29	103526.0
2017-12-06 12:00:00	ES	Futures	2877.29	2877.84	2873.46	2876.74	73277.0
2017-12-06 13:00:00	ES	Futures	2876.74	2880.3	2875.37	2880.02	56240.0
2017-12-06 14:00:00	ES	Futures	2879.75	2882.76	2878.66	2880.3	72359.0
2017-12-06 15:00:00	ES	Futures	2880.3	2881.67	2875.37	2877.02	122452.0
2017-12-06 16:00:00	ES	Futures	2877.02	2879.75	2875.92	2879.48	50219.0
2017-12-06 18:00:00	ES	Futures	2878.38	2880.85	2877.56	2880.02	7277.0
2017-12-06 19:00:00	ES	Futures	2879.75	2884.68	2879.75	2883.58	13610.0
2017-12-06 20:00:00	ES	Futures	2883.31	2885.5	2882.76	2884.4	11046.0
2017-12-06 21:00:00	ES	Futures	2884.68	2884.68	2882.76	2883.03	5379.0
2017-12-06 22:00:00	ES	Futures	2883.31	2884.13	2882.49	2883.03	3013.0
2017-12-06 23:00:00	ES	Futures	2883.03	2883.85	2882.49	2883.31	2838.0
2017-12-06 00:00:00	NQ	Futures	7430.35	7430.35	7420.24	7423.22	3888.0
2017-12-06 01:00:00	NQ	Futures	7423.51	7436.01	7422.03	7431.84	2180.0
2017-12-06 02:00:00	NQ	Futures	7432.44	7436.6	7422.03	7428.57	4343.0
2017-12-06 03:00:00	NQ	Futures	7428.87	7432.44	7414.59	7432.14	6862.0
2017-12-06 04:00:00	NQ	Futures	7431.84	7441.66	7427.38	7428.87	4847.0
2017-12-06 05:00:00	NQ	Futures	7428.87	7434.82	7417.57	7421.43	4842.0
2017-12-06 06:00:00	NQ	Futures	7421.73	7433.33	7418.16	7430.95	3381.0
2017-12-06 07:00:00	NQ	Futures	7431.25	7442.25	7424.41	7438.68	6575.0
2017-12-06 08:00:00	NQ	Futures	7439.28	7445.52	7433.92	7442.85	9169.0
2017-12-06 09:00:00	NQ	Futures	7442.85	7476.75	7420.84	7467.23	67631.0
2017-12-06 10:00:00	NQ	Futures	7467.23	7485.67	7448.79	7480.62	68769.0
2017-12-06 11:00:00	NQ	Futures	7480.92	7492.52	7466.34	7477.05	38008.0
2017-12-06 12:00:00	NQ	Futures	7476.75	7482.11	7459.2	7470.21	29733.0
2017-12-06 13:00:00	NQ	Futures	7470.21	7488.95	7461.88	7486.57	17426.0
2017-12-06 14:00:00	NQ	Futures	7486.57	7501.44	7485.08	7494.3	34484.0
2017-12-06 15:00:00	NQ	Futures	7494.3	7503.22	7480.02	7489.84	32317.0
2017-12-06 16:00:00	NQ	Futures	7489.84	7496.38	7483.3	7496.08	6579.0
2017-12-06 18:00:00	NQ	Futures	7492.52	7501.73	7489.84	7498.46	1707.0
2017-12-06 19:00:00	NQ	Futures	7498.76	7517.8	7498.46	7515.71	2975.0
2017-12-06 20:00:00	NQ	Futures	7515.42	7524.04	7511.55	7521.36	4096.0
2017-12-06 21:00:00	NQ	Futures	7521.36	7521.36	7510.95	7513.04	1760.0
2017-12-06 22:00:00	NQ	Futures	7513.04	7517.2	7510.95	7514.52	1058.0
2017-12-06 23:00:00	NQ	Futures	7514.52	7516.9	7513.33	7516.01	646.0
2017-12-06 00:00:00	YM	Futures	26228.4	26244.7	26212.1	26236.0	2017.0
2017-12-06 01:00:00	YM	Futures	26237.1	26253.4	26228.4	26244.7	964.0
2017-12-06 02:00:00	YM	Futures	26244.7	26248.0	26194.7	26216.5	2928.0
2017-12-06 03:00:00	YM	Futures	26217.5	26241.5	26207.8	26240.4	3184.0

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

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