PREVIEW / futures_1hour / 2019-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-20.parquet
  size:    58 KB
  rows:    1,827

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-08-20 00:00:00	ES	Futures	3169.14	3169.96	3166.71	3168.06	3631.0
2019-08-20 01:00:00	ES	Futures	3168.06	3171.85	3167.25	3171.58	6303.0
2019-08-20 02:00:00	ES	Futures	3171.58	3175.1	3166.98	3168.06	16421.0
2019-08-20 03:00:00	ES	Futures	3167.79	3173.75	3166.17	3169.41	27095.0
2019-08-20 04:00:00	ES	Futures	3169.14	3172.12	3167.79	3169.96	24707.0
2019-08-20 05:00:00	ES	Futures	3169.96	3170.23	3164.54	3167.52	24483.0
2019-08-20 06:00:00	ES	Futures	3167.79	3171.04	3164.54	3166.17	17875.0
2019-08-20 07:00:00	ES	Futures	3165.9	3169.14	3162.11	3168.87	25035.0
2019-08-20 08:00:00	ES	Futures	3168.87	3171.85	3164.0	3164.0	35170.0
2019-08-20 09:00:00	ES	Futures	3164.0	3165.63	3144.78	3148.84	274568.0
2019-08-20 10:00:00	ES	Futures	3149.11	3161.56	3146.41	3160.75	211610.0
2019-08-20 11:00:00	ES	Futures	3161.02	3166.71	3155.88	3157.77	152801.0
2019-08-20 12:00:00	ES	Futures	3157.77	3162.65	3156.15	3160.21	72355.0
2019-08-20 13:00:00	ES	Futures	3160.21	3161.29	3149.92	3154.8	91064.0
2019-08-20 14:00:00	ES	Futures	3154.53	3155.07	3144.78	3150.47	121371.0
2019-08-20 15:00:00	ES	Futures	3150.19	3151.82	3140.45	3141.26	190802.0
2019-08-20 16:00:00	ES	Futures	3141.53	3142.34	3133.95	3135.31	71640.0
2019-08-20 18:00:00	ES	Futures	3132.87	3139.91	3132.6	3139.1	7193.0
2019-08-20 19:00:00	ES	Futures	3139.37	3140.99	3136.39	3139.1	5303.0
2019-08-20 20:00:00	ES	Futures	3139.1	3144.51	3139.1	3142.34	10736.0
2019-08-20 21:00:00	ES	Futures	3142.62	3147.22	3141.8	3146.95	10122.0
2019-08-20 22:00:00	ES	Futures	3146.95	3147.76	3143.7	3145.86	7072.0
2019-08-20 23:00:00	ES	Futures	3146.13	3147.76	3145.05	3146.95	4158.0
2019-08-20 00:00:00	NQ	Futures	8979.33	8980.49	8969.46	8974.4	1840.0
2019-08-20 01:00:00	NQ	Futures	8974.4	8985.13	8971.78	8984.55	2282.0
2019-08-20 02:00:00	NQ	Futures	8984.55	8996.74	8970.33	8973.53	6083.0
2019-08-20 03:00:00	NQ	Futures	8972.95	8994.42	8965.69	8980.78	10790.0
2019-08-20 04:00:00	NQ	Futures	8980.78	8992.38	8976.14	8983.68	9383.0
2019-08-20 05:00:00	NQ	Futures	8983.97	8984.84	8967.72	8979.04	8407.0
2019-08-20 06:00:00	NQ	Futures	8979.04	8989.19	8968.59	8971.78	7178.0
2019-08-20 07:00:00	NQ	Futures	8971.49	8980.2	8956.7	8977.88	10953.0
2019-08-20 08:00:00	NQ	Futures	8977.88	8991.22	8963.66	8966.27	13753.0
2019-08-20 09:00:00	NQ	Futures	8965.98	8971.78	8913.76	8931.45	69054.0
2019-08-20 10:00:00	NQ	Futures	8931.74	8968.3	8921.59	8967.14	59843.0
2019-08-20 11:00:00	NQ	Futures	8967.14	8985.13	8954.09	8957.86	46324.0
2019-08-20 12:00:00	NQ	Futures	8958.15	8974.11	8951.76	8964.24	23441.0
2019-08-20 13:00:00	NQ	Futures	8964.24	8964.82	8932.91	8945.38	23497.0
2019-08-20 14:00:00	NQ	Futures	8945.38	8947.41	8910.85	8930.29	33854.0
2019-08-20 15:00:00	NQ	Futures	8930.0	8937.26	8904.47	8906.79	42324.0
2019-08-20 16:00:00	NQ	Futures	8906.5	8908.82	8884.74	8888.22	12819.0
2019-08-20 18:00:00	NQ	Futures	8884.16	8904.18	8880.97	8903.6	2505.0
2019-08-20 19:00:00	NQ	Futures	8903.6	8909.4	8894.61	8903.89	2245.0
2019-08-20 20:00:00	NQ	Futures	8904.18	8920.43	8903.6	8912.89	5041.0
2019-08-20 21:00:00	NQ	Futures	8912.89	8933.78	8910.85	8932.03	5450.0
2019-08-20 22:00:00	NQ	Futures	8932.03	8935.23	8923.33	8927.68	4370.0
2019-08-20 23:00:00	NQ	Futures	8927.97	8933.49	8924.2	8930.29	1810.0
2019-08-20 00:00:00	YM	Futures	28442.5	28446.8	28420.7	28431.6	577.0
2019-08-20 01:00:00	YM	Futures	28432.7	28462.1	28428.3	28458.8	1074.0
2019-08-20 02:00:00	YM	Futures	28458.8	28490.3	28421.8	28428.3	3015.0
2019-08-20 03:00:00	YM	Futures	28425.1	28470.8	28402.2	28434.9	4124.0

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

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