PREVIEW / futures_1hour / 2019-06-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-05.parquet
  size:    60 KB
  rows:    1,845

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-06-05 00:00:00	ES	Futures	3049.9	3049.9	3048.27	3049.09	3481.0
2019-06-05 01:00:00	ES	Futures	3049.36	3049.9	3044.48	3045.56	10069.0
2019-06-05 02:00:00	ES	Futures	3045.56	3046.65	3042.85	3045.83	18682.0
2019-06-05 03:00:00	ES	Futures	3046.11	3053.97	3043.12	3052.88	34920.0
2019-06-05 04:00:00	ES	Futures	3052.88	3053.97	3050.17	3050.98	28632.0
2019-06-05 05:00:00	ES	Futures	3051.26	3061.29	3049.9	3060.47	41321.0
2019-06-05 06:00:00	ES	Futures	3060.47	3063.18	3059.39	3062.37	28335.0
2019-06-05 07:00:00	ES	Futures	3062.64	3063.18	3056.14	3058.58	36840.0
2019-06-05 08:00:00	ES	Futures	3058.58	3059.93	3047.73	3050.44	68671.0
2019-06-05 09:00:00	ES	Futures	3050.71	3059.93	3045.83	3053.7	243466.0
2019-06-05 10:00:00	ES	Futures	3053.7	3056.68	3037.43	3043.12	314434.0
2019-06-05 11:00:00	ES	Futures	3043.12	3055.05	3041.23	3054.24	182890.0
2019-06-05 12:00:00	ES	Futures	3054.51	3058.58	3049.09	3055.86	141534.0
2019-06-05 13:00:00	ES	Futures	3055.86	3062.91	3055.59	3061.02	97919.0
2019-06-05 14:00:00	ES	Futures	3061.02	3064.0	3056.95	3058.58	86438.0
2019-06-05 15:00:00	ES	Futures	3058.58	3066.71	3053.15	3065.9	216617.0
2019-06-05 16:00:00	ES	Futures	3065.62	3068.34	3064.81	3066.98	55895.0
2019-06-05 18:00:00	ES	Futures	3058.58	3060.47	3050.17	3057.22	27229.0
2019-06-05 19:00:00	ES	Futures	3057.22	3061.56	3055.05	3060.74	9375.0
2019-06-05 20:00:00	ES	Futures	3060.74	3067.25	3060.47	3064.54	14254.0
2019-06-05 21:00:00	ES	Futures	3064.54	3066.17	3062.64	3064.54	9259.0
2019-06-05 22:00:00	ES	Futures	3064.54	3068.34	3063.73	3066.98	8827.0
2019-06-05 23:00:00	ES	Futures	3066.71	3067.25	3064.81	3065.35	4675.0
2019-06-05 00:00:00	NQ	Futures	8394.61	8395.48	8387.91	8391.7	1754.0
2019-06-05 01:00:00	NQ	Futures	8391.7	8395.78	8374.52	8378.02	3684.0
2019-06-05 02:00:00	NQ	Futures	8378.02	8380.05	8364.91	8373.94	7169.0
2019-06-05 03:00:00	NQ	Futures	8374.23	8405.68	8362.0	8401.6	11854.0
2019-06-05 04:00:00	NQ	Futures	8401.6	8406.55	8391.12	8395.19	7987.0
2019-06-05 05:00:00	NQ	Futures	8395.19	8430.42	8388.79	8427.22	11926.0
2019-06-05 06:00:00	NQ	Futures	8427.51	8437.99	8423.73	8431.88	9281.0
2019-06-05 07:00:00	NQ	Futures	8432.17	8435.08	8409.75	8420.82	9426.0
2019-06-05 08:00:00	NQ	Futures	8421.4	8428.39	8392.86	8406.26	21462.0
2019-06-05 09:00:00	NQ	Futures	8406.55	8434.5	8370.74	8396.65	86408.0
2019-06-05 10:00:00	NQ	Futures	8398.11	8412.37	8327.35	8347.15	112131.0
2019-06-05 11:00:00	NQ	Futures	8347.44	8399.85	8339.29	8397.52	68745.0
2019-06-05 12:00:00	NQ	Futures	8396.94	8404.51	8366.95	8379.47	43038.0
2019-06-05 13:00:00	NQ	Futures	8379.76	8407.71	8379.47	8397.52	27095.0
2019-06-05 14:00:00	NQ	Futures	8397.52	8408.0	8383.84	8391.99	24979.0
2019-06-05 15:00:00	NQ	Futures	8392.28	8419.94	8378.6	8415.57	44951.0
2019-06-05 16:00:00	NQ	Futures	8415.87	8426.06	8411.21	8420.52	9139.0
2019-06-05 18:00:00	NQ	Futures	8401.31	8401.6	8363.17	8387.33	7305.0
2019-06-05 19:00:00	NQ	Futures	8387.33	8405.38	8381.22	8400.43	4165.0
2019-06-05 20:00:00	NQ	Futures	8400.43	8424.31	8399.85	8413.54	5016.0
2019-06-05 21:00:00	NQ	Futures	8412.95	8422.27	8409.17	8414.7	3650.0
2019-06-05 22:00:00	NQ	Futures	8414.99	8430.13	8412.37	8425.18	3574.0
2019-06-05 23:00:00	NQ	Futures	8425.18	8427.8	8419.07	8421.69	1684.0
2019-06-05 00:00:00	YM	Futures	27628.9	27630.0	27615.9	27623.5	795.0
2019-06-05 01:00:00	YM	Futures	27623.5	27631.1	27586.5	27594.1	1888.0
2019-06-05 02:00:00	YM	Futures	27594.1	27599.6	27565.8	27594.1	3855.0
2019-06-05 03:00:00	YM	Futures	27595.2	27671.3	27565.8	27657.2	6489.0

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

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