PREVIEW / futures_1hour / 2017-06-20

all futures 1-hour files

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

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-06-20 00:00:00	ES	Futures	2678.72	2679.0	2678.45	2678.72	1203.0
2017-06-20 01:00:00	ES	Futures	2678.45	2678.72	2677.63	2677.9	2987.0
2017-06-20 02:00:00	ES	Futures	2677.9	2678.72	2676.26	2677.36	11067.0
2017-06-20 03:00:00	ES	Futures	2677.36	2678.45	2676.26	2677.36	15808.0
2017-06-20 04:00:00	ES	Futures	2677.36	2677.9	2676.26	2677.08	8131.0
2017-06-20 05:00:00	ES	Futures	2676.81	2677.08	2676.26	2676.26	5367.0
2017-06-20 06:00:00	ES	Futures	2676.54	2677.36	2675.99	2676.54	8829.0
2017-06-20 07:00:00	ES	Futures	2676.54	2677.08	2675.44	2675.99	14731.0
2017-06-20 08:00:00	ES	Futures	2675.99	2676.26	2672.98	2673.8	34657.0
2017-06-20 09:00:00	ES	Futures	2673.53	2675.44	2669.98	2670.52	165135.0
2017-06-20 10:00:00	ES	Futures	2670.52	2673.8	2669.16	2672.98	185331.0
2017-06-20 11:00:00	ES	Futures	2672.98	2672.98	2668.88	2669.16	142246.0
2017-06-20 12:00:00	ES	Futures	2669.43	2670.52	2664.78	2669.7	151432.0
2017-06-20 13:00:00	ES	Futures	2669.43	2670.8	2668.06	2669.16	70149.0
2017-06-20 14:00:00	ES	Futures	2668.88	2670.25	2665.33	2666.7	97686.0
2017-06-20 15:00:00	ES	Futures	2666.97	2669.16	2661.23	2662.05	274997.0
2017-06-20 16:00:00	ES	Futures	2661.78	2665.6	2661.78	2663.96	106355.0
2017-06-20 18:00:00	ES	Futures	2663.14	2664.51	2662.87	2663.42	4597.0
2017-06-20 19:00:00	ES	Futures	2663.42	2664.51	2663.42	2663.69	2035.0
2017-06-20 20:00:00	ES	Futures	2663.96	2664.78	2659.59	2661.5	16327.0
2017-06-20 21:00:00	ES	Futures	2661.78	2662.05	2660.14	2661.78	6625.0
2017-06-20 22:00:00	ES	Futures	2661.5	2663.42	2660.68	2660.68	6468.0
2017-06-20 23:00:00	ES	Futures	2660.68	2661.23	2659.59	2660.68	5392.0
2017-06-20 00:00:00	NQ	Futures	6883.71	6885.8	6882.82	6884.9	384.0
2017-06-20 01:00:00	NQ	Futures	6885.2	6885.8	6881.33	6882.52	732.0
2017-06-20 02:00:00	NQ	Futures	6882.22	6884.31	6872.1	6879.84	2097.0
2017-06-20 03:00:00	NQ	Futures	6879.54	6888.77	6876.56	6883.71	2804.0
2017-06-20 04:00:00	NQ	Futures	6884.01	6885.2	6878.35	6881.03	1123.0
2017-06-20 05:00:00	NQ	Futures	6881.33	6881.92	6876.86	6877.76	665.0
2017-06-20 06:00:00	NQ	Futures	6877.46	6883.12	6876.56	6881.92	1154.0
2017-06-20 07:00:00	NQ	Futures	6881.63	6886.39	6879.24	6885.2	4354.0
2017-06-20 08:00:00	NQ	Futures	6884.9	6885.2	6863.17	6864.95	7668.0
2017-06-20 09:00:00	NQ	Futures	6864.65	6877.16	6857.21	6861.08	43171.0
2017-06-20 10:00:00	NQ	Futures	6861.38	6881.92	6850.66	6876.86	45592.0
2017-06-20 11:00:00	NQ	Futures	6877.16	6878.65	6844.41	6853.34	38248.0
2017-06-20 12:00:00	NQ	Futures	6853.64	6861.38	6834.58	6848.87	30472.0
2017-06-20 13:00:00	NQ	Futures	6848.87	6857.51	6846.49	6852.45	17055.0
2017-06-20 14:00:00	NQ	Futures	6853.04	6857.51	6835.18	6848.28	22757.0
2017-06-20 15:00:00	NQ	Futures	6848.58	6857.51	6823.27	6825.35	55541.0
2017-06-20 16:00:00	NQ	Futures	6825.35	6831.31	6823.57	6826.84	8054.0
2017-06-20 18:00:00	NQ	Futures	6822.37	6830.12	6820.59	6825.65	1283.0
2017-06-20 19:00:00	NQ	Futures	6825.65	6829.22	6822.67	6826.54	701.0
2017-06-20 20:00:00	NQ	Futures	6826.54	6828.92	6805.4	6814.93	3441.0
2017-06-20 21:00:00	NQ	Futures	6815.23	6816.42	6806.0	6813.14	3797.0
2017-06-20 22:00:00	NQ	Futures	6813.14	6821.48	6807.78	6808.98	3462.0
2017-06-20 23:00:00	NQ	Futures	6808.68	6812.55	6806.89	6811.66	1204.0
2017-06-20 00:00:00	YM	Futures	23386.0	23389.3	23386.0	23387.1	390.0
2017-06-20 01:00:00	YM	Futures	23386.0	23388.2	23381.7	23382.8	592.0
2017-06-20 02:00:00	YM	Futures	23381.7	23387.1	23366.4	23377.3	2013.0
2017-06-20 03:00:00	YM	Futures	23377.3	23388.2	23370.8	23382.8	2170.0

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

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