PREVIEW / futures_1hour / 2019-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-04.parquet
  size:    50 KB
  rows:    1,431

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
2019-01-04 00:00:00	ES	Futures	2672.94	2678.1	2671.31	2676.19	8650.0
2019-01-04 01:00:00	ES	Futures	2676.19	2685.43	2675.65	2683.8	12371.0
2019-01-04 02:00:00	ES	Futures	2684.07	2688.14	2680.54	2686.24	16535.0
2019-01-04 03:00:00	ES	Futures	2686.24	2691.13	2680.54	2686.79	33101.0
2019-01-04 04:00:00	ES	Futures	2686.51	2697.92	2682.98	2691.95	27024.0
2019-01-04 05:00:00	ES	Futures	2691.95	2698.19	2690.05	2697.11	16191.0
2019-01-04 06:00:00	ES	Futures	2697.11	2701.45	2693.3	2697.38	18595.0
2019-01-04 07:00:00	ES	Futures	2697.11	2698.74	2690.86	2693.03	21842.0
2019-01-04 08:00:00	ES	Futures	2693.3	2698.46	2683.53	2693.03	108031.0
2019-01-04 09:00:00	ES	Futures	2692.76	2714.76	2689.23	2714.22	296874.0
2019-01-04 10:00:00	ES	Futures	2714.22	2738.93	2702.54	2735.67	437821.0
2019-01-04 11:00:00	ES	Futures	2735.4	2744.63	2726.71	2737.03	280407.0
2019-01-04 12:00:00	ES	Futures	2737.03	2754.14	2730.78	2750.88	170476.0
2019-01-04 13:00:00	ES	Futures	2751.15	2758.48	2743.55	2748.16	160522.0
2019-01-04 14:00:00	ES	Futures	2748.16	2754.95	2740.83	2742.73	158614.0
2019-01-04 15:00:00	ES	Futures	2742.73	2753.6	2740.29	2751.42	297332.0
2019-01-04 16:00:00	ES	Futures	2751.15	2753.32	2745.72	2747.89	104807.0
2019-01-04 00:00:00	NQ	Futures	7250.97	7266.16	7244.25	7260.03	4848.0
2019-01-04 01:00:00	NQ	Futures	7260.61	7294.21	7257.69	7288.66	5866.0
2019-01-04 02:00:00	NQ	Futures	7288.96	7303.56	7281.94	7299.18	8964.0
2019-01-04 03:00:00	NQ	Futures	7298.6	7317.3	7281.94	7298.6	13263.0
2019-01-04 04:00:00	NQ	Futures	7296.55	7336.29	7286.33	7315.25	11747.0
2019-01-04 05:00:00	NQ	Futures	7314.67	7338.63	7308.53	7335.41	6569.0
2019-01-04 06:00:00	NQ	Futures	7335.12	7347.1	7319.05	7333.08	7976.0
2019-01-04 07:00:00	NQ	Futures	7332.2	7335.71	7302.98	7307.07	9157.0
2019-01-04 08:00:00	NQ	Futures	7307.66	7323.43	7276.1	7304.15	29264.0
2019-01-04 09:00:00	NQ	Futures	7303.56	7376.32	7294.51	7371.64	83103.0
2019-01-04 10:00:00	NQ	Futures	7372.23	7463.68	7340.38	7463.1	119635.0
2019-01-04 11:00:00	NQ	Futures	7462.81	7499.62	7453.17	7485.6	95428.0
2019-01-04 12:00:00	NQ	Futures	7485.01	7527.67	7472.45	7517.45	50495.0
2019-01-04 13:00:00	NQ	Futures	7517.74	7552.51	7513.36	7525.34	60950.0
2019-01-04 14:00:00	NQ	Futures	7525.63	7543.74	7497.87	7499.33	46351.0
2019-01-04 15:00:00	NQ	Futures	7499.33	7525.92	7488.81	7521.54	70956.0
2019-01-04 16:00:00	NQ	Futures	7522.71	7530.01	7508.39	7517.15	17534.0
2019-01-04 00:00:00	YM	Futures	24721.5	24763.9	24700.9	24738.9	3340.0
2019-01-04 01:00:00	YM	Futures	24738.9	24830.1	24734.6	24811.7	3697.0
2019-01-04 02:00:00	YM	Futures	24813.8	24852.9	24775.8	24827.9	5592.0
2019-01-04 03:00:00	YM	Futures	24825.8	24875.7	24782.3	24837.7	7384.0
2019-01-04 04:00:00	YM	Futures	24834.5	24931.1	24809.5	24880.1	6900.0
2019-01-04 05:00:00	YM	Futures	24880.1	24931.1	24861.6	24921.3	4093.0
2019-01-04 06:00:00	YM	Futures	24920.2	24959.3	24888.7	24932.2	5324.0
2019-01-04 07:00:00	YM	Futures	24931.1	24945.2	24885.5	24903.9	4303.0
2019-01-04 08:00:00	YM	Futures	24906.1	24949.5	24819.3	24905.0	17138.0
2019-01-04 09:00:00	YM	Futures	24903.9	25114.6	24869.2	25109.1	44084.0
2019-01-04 10:00:00	YM	Futures	25110.2	25318.7	24991.9	25290.5	50592.0
2019-01-04 11:00:00	YM	Futures	25288.3	25363.2	25202.5	25298.1	35901.0
2019-01-04 12:00:00	YM	Futures	25300.2	25477.2	25242.7	25446.8	23963.0
2019-01-04 13:00:00	YM	Futures	25446.8	25518.5	25380.6	25415.3	23639.0
2019-01-04 14:00:00	YM	Futures	25415.3	25472.9	25348.0	25367.5	20490.0
2019-01-04 15:00:00	YM	Futures	25367.5	25451.1	25342.6	25420.7	30034.0

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

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