PREVIEW / futures_1hour / 2018-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-05.parquet
  size:    45 KB
  rows:    1,374

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-01-05 00:00:00	ES	Futures	2980.64	2980.92	2980.37	2980.64	2688.0
2018-01-05 01:00:00	ES	Futures	2980.64	2981.19	2980.1	2980.1	2211.0
2018-01-05 02:00:00	ES	Futures	2980.37	2981.46	2980.1	2981.46	5144.0
2018-01-05 03:00:00	ES	Futures	2981.46	2982.83	2981.19	2982.56	12284.0
2018-01-05 04:00:00	ES	Futures	2982.56	2985.02	2982.01	2983.92	16201.0
2018-01-05 05:00:00	ES	Futures	2983.92	2986.93	2983.92	2986.38	14345.0
2018-01-05 06:00:00	ES	Futures	2986.38	2986.93	2985.29	2986.66	10201.0
2018-01-05 07:00:00	ES	Futures	2986.93	2987.75	2985.56	2986.93	13737.0
2018-01-05 08:00:00	ES	Futures	2986.66	2989.94	2984.47	2987.75	41514.0
2018-01-05 09:00:00	ES	Futures	2987.75	2988.3	2980.92	2985.02	172298.0
2018-01-05 10:00:00	ES	Futures	2985.02	2987.48	2983.1	2986.38	136999.0
2018-01-05 11:00:00	ES	Futures	2986.38	2989.94	2985.29	2988.57	109436.0
2018-01-05 12:00:00	ES	Futures	2988.57	2989.39	2985.84	2986.93	65831.0
2018-01-05 13:00:00	ES	Futures	2987.2	2989.94	2986.93	2989.39	41975.0
2018-01-05 14:00:00	ES	Futures	2989.39	2992.94	2988.57	2991.3	83210.0
2018-01-05 15:00:00	ES	Futures	2991.03	2998.96	2991.03	2997.04	237072.0
2018-01-05 16:00:00	ES	Futures	2997.04	2999.23	2994.86	2998.41	100054.0
2018-01-05 00:00:00	NQ	Futures	7842.84	7844.92	7841.36	7842.55	646.0
2018-01-05 01:00:00	NQ	Futures	7842.84	7843.14	7840.17	7841.36	690.0
2018-01-05 02:00:00	NQ	Futures	7841.36	7846.7	7841.06	7845.51	1126.0
2018-01-05 03:00:00	NQ	Futures	7845.51	7852.04	7845.21	7850.55	2383.0
2018-01-05 04:00:00	NQ	Futures	7850.55	7853.82	7846.7	7851.74	2235.0
2018-01-05 05:00:00	NQ	Futures	7851.74	7867.16	7851.74	7862.71	3371.0
2018-01-05 06:00:00	NQ	Futures	7862.42	7866.87	7860.04	7863.9	1945.0
2018-01-05 07:00:00	NQ	Futures	7863.9	7866.27	7859.45	7863.6	2595.0
2018-01-05 08:00:00	NQ	Futures	7863.31	7876.65	7858.86	7865.68	8625.0
2018-01-05 09:00:00	NQ	Futures	7865.98	7867.76	7846.99	7858.26	42399.0
2018-01-05 10:00:00	NQ	Futures	7859.15	7884.07	7852.93	7880.81	36839.0
2018-01-05 11:00:00	NQ	Futures	7880.81	7893.56	7876.95	7893.56	23118.0
2018-01-05 12:00:00	NQ	Futures	7893.56	7894.75	7886.14	7890.0	13271.0
2018-01-05 13:00:00	NQ	Futures	7890.0	7897.42	7887.33	7894.15	9476.0
2018-01-05 14:00:00	NQ	Futures	7894.15	7895.64	7887.92	7889.7	12212.0
2018-01-05 15:00:00	NQ	Futures	7889.7	7909.58	7887.33	7902.16	30927.0
2018-01-05 16:00:00	NQ	Futures	7902.16	7914.32	7899.49	7908.09	11485.0
2018-01-05 00:00:00	YM	Futures	27274.2	27276.3	27264.4	27266.6	888.0
2018-01-05 01:00:00	YM	Futures	27266.6	27272.0	27257.9	27260.0	967.0
2018-01-05 02:00:00	YM	Futures	27259.0	27275.3	27257.9	27273.1	954.0
2018-01-05 03:00:00	YM	Futures	27274.2	27287.2	27270.9	27275.3	1759.0
2018-01-05 04:00:00	YM	Futures	27276.3	27299.2	27272.0	27293.7	2200.0
2018-01-05 05:00:00	YM	Futures	27294.8	27317.6	27293.7	27313.3	1760.0
2018-01-05 06:00:00	YM	Futures	27313.3	27326.3	27306.8	27325.3	1249.0
2018-01-05 07:00:00	YM	Futures	27325.3	27328.5	27315.5	27326.3	1517.0
2018-01-05 08:00:00	YM	Futures	27325.3	27345.9	27305.7	27325.3	5048.0
2018-01-05 09:00:00	YM	Futures	27324.2	27328.5	27261.1	27287.2	21379.0
2018-01-05 10:00:00	YM	Futures	27286.1	27305.7	27263.3	27287.2	11898.0
2018-01-05 11:00:00	YM	Futures	27287.2	27335.0	27278.5	27316.6	11181.0
2018-01-05 12:00:00	YM	Futures	27316.6	27337.2	27304.6	27315.5	6931.0
2018-01-05 13:00:00	YM	Futures	27316.6	27341.6	27313.3	27336.1	4559.0
2018-01-05 14:00:00	YM	Futures	27337.2	27389.4	27326.3	27373.1	8729.0
2018-01-05 15:00:00	YM	Futures	27372.0	27465.5	27369.8	27451.3	15804.0

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

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