PREVIEW / futures_1hour / 2019-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-21.parquet
  size:    57 KB
  rows:    1,828

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-21 00:00:00	ES	Futures	3146.68	3146.95	3144.51	3146.13	2875.0
2019-08-21 01:00:00	ES	Futures	3146.13	3149.38	3145.59	3148.57	5690.0
2019-08-21 02:00:00	ES	Futures	3148.57	3149.38	3146.68	3148.03	8896.0
2019-08-21 03:00:00	ES	Futures	3148.3	3157.23	3148.03	3155.88	29803.0
2019-08-21 04:00:00	ES	Futures	3155.88	3162.11	3154.53	3160.75	29023.0
2019-08-21 05:00:00	ES	Futures	3160.75	3162.65	3159.13	3159.94	26331.0
2019-08-21 06:00:00	ES	Futures	3160.21	3162.11	3158.32	3159.94	18042.0
2019-08-21 07:00:00	ES	Futures	3159.94	3161.56	3158.32	3160.21	24801.0
2019-08-21 08:00:00	ES	Futures	3160.21	3166.44	3158.59	3166.44	45723.0
2019-08-21 09:00:00	ES	Futures	3166.44	3172.12	3163.73	3168.6	178934.0
2019-08-21 10:00:00	ES	Futures	3168.33	3169.41	3162.38	3165.9	150690.0
2019-08-21 11:00:00	ES	Futures	3166.17	3171.85	3163.19	3170.77	113987.0
2019-08-21 12:00:00	ES	Futures	3170.77	3171.58	3166.71	3169.41	60890.0
2019-08-21 13:00:00	ES	Futures	3169.14	3170.5	3166.17	3166.17	43005.0
2019-08-21 14:00:00	ES	Futures	3166.17	3170.23	3159.67	3162.65	141122.0
2019-08-21 15:00:00	ES	Futures	3162.65	3168.33	3161.02	3166.98	148124.0
2019-08-21 16:00:00	ES	Futures	3166.98	3175.37	3166.17	3175.1	59218.0
2019-08-21 18:00:00	ES	Futures	3174.02	3182.41	3173.48	3178.89	11499.0
2019-08-21 19:00:00	ES	Futures	3178.89	3180.78	3177.27	3178.08	5236.0
2019-08-21 20:00:00	ES	Futures	3178.08	3179.43	3173.2	3175.91	12726.0
2019-08-21 21:00:00	ES	Futures	3175.64	3177.54	3169.14	3170.23	15366.0
2019-08-21 22:00:00	ES	Futures	3170.5	3172.12	3168.33	3168.6	10256.0
2019-08-21 23:00:00	ES	Futures	3168.6	3170.23	3167.25	3168.6	7175.0
2019-08-21 00:00:00	NQ	Futures	8930.87	8931.45	8924.49	8928.84	1939.0
2019-08-21 01:00:00	NQ	Futures	8929.13	8941.61	8928.26	8936.39	3615.0
2019-08-21 02:00:00	NQ	Futures	8936.39	8938.13	8930.58	8935.81	2878.0
2019-08-21 03:00:00	NQ	Futures	8935.81	8966.56	8935.81	8962.21	11514.0
2019-08-21 04:00:00	NQ	Futures	8961.92	8981.36	8955.83	8977.3	12045.0
2019-08-21 05:00:00	NQ	Futures	8977.59	8984.26	8971.49	8974.69	8917.0
2019-08-21 06:00:00	NQ	Futures	8974.98	8979.91	8966.85	8971.49	8090.0
2019-08-21 07:00:00	NQ	Futures	8970.91	8974.11	8961.92	8967.14	9051.0
2019-08-21 08:00:00	NQ	Futures	8967.14	8981.65	8959.6	8981.36	15808.0
2019-08-21 09:00:00	NQ	Futures	8981.36	9012.69	8972.36	9002.83	60975.0
2019-08-21 10:00:00	NQ	Futures	9002.83	9008.34	8980.49	8990.64	43187.0
2019-08-21 11:00:00	NQ	Futures	8990.64	9006.89	8980.78	9000.51	28875.0
2019-08-21 12:00:00	NQ	Futures	9000.51	9002.25	8985.42	8992.09	17422.0
2019-08-21 13:00:00	NQ	Futures	8992.09	8995.87	8973.53	8973.82	13331.0
2019-08-21 14:00:00	NQ	Futures	8974.11	8992.96	8952.64	8968.88	41605.0
2019-08-21 15:00:00	NQ	Futures	8968.59	8987.45	8961.92	8983.68	33277.0
2019-08-21 16:00:00	NQ	Futures	8983.97	9004.86	8982.23	9003.7	9543.0
2019-08-21 18:00:00	NQ	Futures	9001.38	9031.84	8998.48	9019.66	5490.0
2019-08-21 19:00:00	NQ	Futures	9019.95	9025.75	9015.89	9017.63	2517.0
2019-08-21 20:00:00	NQ	Futures	9017.92	9022.27	9000.22	9008.05	5762.0
2019-08-21 21:00:00	NQ	Futures	9008.05	9013.27	8984.84	8985.71	7882.0
2019-08-21 22:00:00	NQ	Futures	8985.42	8989.77	8977.3	8977.59	6897.0
2019-08-21 23:00:00	NQ	Futures	8977.3	8983.39	8972.36	8976.43	4074.0
2019-08-21 00:00:00	YM	Futures	28255.4	28255.4	28236.9	28244.6	664.0
2019-08-21 01:00:00	YM	Futures	28245.6	28283.7	28242.4	28277.2	1327.0
2019-08-21 02:00:00	YM	Futures	28277.2	28281.5	28254.3	28267.4	1426.0
2019-08-21 03:00:00	YM	Futures	28269.6	28343.5	28268.5	28339.2	6288.0

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

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