PREVIEW / futures_1hour / 2018-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-31.parquet
  size:    38 KB
  rows:    1,089

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-12-31 00:00:00	ES	Futures	2718.02	2720.73	2717.2	2719.92	1775.0
2018-12-31 01:00:00	ES	Futures	2719.92	2723.99	2719.65	2722.64	2787.0
2018-12-31 02:00:00	ES	Futures	2722.64	2726.44	2721.82	2724.81	6595.0
2018-12-31 03:00:00	ES	Futures	2725.08	2725.35	2721.01	2721.55	8753.0
2018-12-31 04:00:00	ES	Futures	2721.28	2723.45	2718.56	2722.91	7356.0
2018-12-31 05:00:00	ES	Futures	2723.18	2724.26	2720.19	2722.36	7249.0
2018-12-31 06:00:00	ES	Futures	2722.36	2724.54	2720.73	2722.91	5329.0
2018-12-31 07:00:00	ES	Futures	2723.18	2729.42	2722.64	2727.8	12471.0
2018-12-31 08:00:00	ES	Futures	2727.8	2727.8	2718.02	2718.83	20225.0
2018-12-31 09:00:00	ES	Futures	2718.56	2726.71	2715.3	2718.29	124301.0
2018-12-31 10:00:00	ES	Futures	2718.29	2723.99	2704.17	2707.15	162080.0
2018-12-31 11:00:00	ES	Futures	2707.43	2711.77	2697.11	2710.96	149669.0
2018-12-31 12:00:00	ES	Futures	2710.96	2718.83	2705.53	2717.75	105478.0
2018-12-31 13:00:00	ES	Futures	2717.75	2726.17	2712.59	2713.13	86778.0
2018-12-31 14:00:00	ES	Futures	2713.13	2718.02	2701.45	2710.41	136661.0
2018-12-31 15:00:00	ES	Futures	2710.14	2726.71	2703.08	2726.17	338326.0
2018-12-31 16:00:00	ES	Futures	2726.17	2729.97	2718.02	2725.35	126489.0
2018-12-31 00:00:00	NQ	Futures	7416.64	7423.65	7414.6	7421.61	1168.0
2018-12-31 01:00:00	NQ	Futures	7421.9	7432.13	7420.44	7428.91	1824.0
2018-12-31 02:00:00	NQ	Futures	7429.79	7439.14	7428.04	7435.63	3265.0
2018-12-31 03:00:00	NQ	Futures	7435.63	7436.51	7415.77	7416.06	4231.0
2018-12-31 04:00:00	NQ	Futures	7416.35	7423.36	7405.25	7422.19	3509.0
2018-12-31 05:00:00	NQ	Futures	7422.49	7425.99	7414.6	7421.61	2640.0
2018-12-31 06:00:00	NQ	Futures	7421.61	7430.96	7417.52	7424.82	2547.0
2018-12-31 07:00:00	NQ	Futures	7425.12	7448.2	7424.24	7444.11	5104.0
2018-12-31 08:00:00	NQ	Futures	7443.82	7444.69	7417.52	7419.86	7392.0
2018-12-31 09:00:00	NQ	Futures	7419.56	7452.87	7397.94	7416.93	39252.0
2018-12-31 10:00:00	NQ	Futures	7416.64	7434.17	7359.66	7369.89	58130.0
2018-12-31 11:00:00	NQ	Futures	7370.18	7395.9	7343.3	7393.27	53682.0
2018-12-31 12:00:00	NQ	Futures	7392.97	7419.86	7377.49	7410.8	33178.0
2018-12-31 13:00:00	NQ	Futures	7410.8	7436.22	7389.76	7393.56	22229.0
2018-12-31 14:00:00	NQ	Futures	7393.27	7407.88	7360.25	7386.25	33198.0
2018-12-31 15:00:00	NQ	Futures	7385.96	7417.23	7357.04	7416.64	55508.0
2018-12-31 16:00:00	NQ	Futures	7416.06	7433.3	7401.74	7424.24	21380.0
2018-12-31 00:00:00	YM	Futures	25199.3	25218.8	25189.5	25206.9	753.0
2018-12-31 01:00:00	YM	Futures	25207.9	25252.5	25203.6	25234.0	1259.0
2018-12-31 02:00:00	YM	Futures	25234.0	25272.0	25223.1	25249.2	2301.0
2018-12-31 03:00:00	YM	Futures	25249.2	25254.6	25211.2	25215.5	3062.0
2018-12-31 04:00:00	YM	Futures	25213.4	25244.9	25198.2	25241.6	1895.0
2018-12-31 05:00:00	YM	Futures	25241.6	25253.5	25214.5	25231.8	1933.0
2018-12-31 06:00:00	YM	Futures	25232.9	25249.2	25224.2	25238.3	1218.0
2018-12-31 07:00:00	YM	Futures	25237.3	25299.1	25237.3	25292.6	3042.0
2018-12-31 08:00:00	YM	Futures	25292.6	25292.6	25201.4	25209.0	5342.0
2018-12-31 09:00:00	YM	Futures	25209.0	25302.4	25191.7	25235.1	18526.0
2018-12-31 10:00:00	YM	Futures	25236.2	25292.6	25139.5	25172.1	21149.0
2018-12-31 11:00:00	YM	Futures	25173.2	25199.3	25069.0	25178.6	19388.0
2018-12-31 12:00:00	YM	Futures	25179.7	25251.4	25141.7	25243.8	11985.0
2018-12-31 13:00:00	YM	Futures	25244.9	25305.7	25185.1	25197.1	11132.0
2018-12-31 14:00:00	YM	Futures	25199.3	25263.3	25115.7	25200.3	16304.0
2018-12-31 15:00:00	YM	Futures	25199.3	25311.1	25099.4	25306.7	28362.0

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

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