PREVIEW / futures_1hour / 2018-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-27.parquet
  size:    55 KB
  rows:    1,699

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-09-27 00:00:00	ES	Futures	3169.6	3170.14	3168.51	3169.6	2623.0
2018-09-27 01:00:00	ES	Futures	3169.87	3170.68	3166.06	3166.33	8115.0
2018-09-27 02:00:00	ES	Futures	3166.33	3168.24	3164.97	3167.42	8801.0
2018-09-27 03:00:00	ES	Futures	3167.42	3169.87	3163.34	3164.16	22327.0
2018-09-27 04:00:00	ES	Futures	3164.16	3167.69	3164.16	3165.24	12568.0
2018-09-27 05:00:00	ES	Futures	3165.52	3169.05	3164.43	3167.96	15968.0
2018-09-27 06:00:00	ES	Futures	3167.96	3172.86	3167.96	3171.5	21170.0
2018-09-27 07:00:00	ES	Futures	3171.5	3171.5	3169.32	3169.6	14125.0
2018-09-27 08:00:00	ES	Futures	3169.6	3173.4	3169.05	3172.59	23761.0
2018-09-27 09:00:00	ES	Futures	3172.59	3177.76	3170.41	3176.12	159584.0
2018-09-27 10:00:00	ES	Futures	3176.12	3185.64	3175.85	3184.83	189662.0
2018-09-27 11:00:00	ES	Futures	3184.56	3187.82	3182.65	3187.82	103569.0
2018-09-27 12:00:00	ES	Futures	3187.55	3190.0	3186.46	3188.64	86670.0
2018-09-27 13:00:00	ES	Futures	3188.36	3188.64	3184.01	3185.1	62627.0
2018-09-27 14:00:00	ES	Futures	3185.1	3185.1	3179.12	3179.39	119998.0
2018-09-27 15:00:00	ES	Futures	3179.39	3181.29	3173.68	3176.67	221420.0
2018-09-27 16:00:00	ES	Futures	3176.67	3179.39	3174.76	3179.12	64698.0
2018-09-27 18:00:00	ES	Futures	3179.39	3180.48	3178.57	3178.84	3435.0
2018-09-27 19:00:00	ES	Futures	3179.12	3180.2	3178.3	3178.57	1887.0
2018-09-27 20:00:00	ES	Futures	3178.57	3179.39	3176.67	3178.3	5642.0
2018-09-27 21:00:00	ES	Futures	3178.57	3181.02	3178.3	3179.39	5898.0
2018-09-27 22:00:00	ES	Futures	3179.39	3181.29	3179.12	3180.48	4582.0
2018-09-27 23:00:00	ES	Futures	3180.2	3181.56	3179.66	3180.2	3879.0
2018-09-27 00:00:00	NQ	Futures	8917.34	8922.91	8914.11	8921.44	1281.0
2018-09-27 01:00:00	NQ	Futures	8921.44	8924.67	8906.78	8909.42	3079.0
2018-09-27 02:00:00	NQ	Futures	8909.12	8917.92	8903.55	8913.23	3428.0
2018-09-27 03:00:00	NQ	Futures	8913.52	8922.91	8900.32	8903.84	6532.0
2018-09-27 04:00:00	NQ	Futures	8903.84	8916.46	8903.84	8909.12	5544.0
2018-09-27 05:00:00	NQ	Futures	8909.42	8921.15	8906.78	8918.8	6051.0
2018-09-27 06:00:00	NQ	Futures	8918.51	8934.35	8918.22	8929.07	8624.0
2018-09-27 07:00:00	NQ	Futures	8929.07	8934.06	8924.08	8928.19	5937.0
2018-09-27 08:00:00	NQ	Futures	8928.48	8940.22	8924.08	8938.75	10146.0
2018-09-27 09:00:00	NQ	Futures	8938.75	8983.63	8936.11	8976.0	64200.0
2018-09-27 10:00:00	NQ	Futures	8976.29	9007.97	8976.0	9006.8	68914.0
2018-09-27 11:00:00	NQ	Futures	9007.09	9015.6	8991.25	9007.68	39906.0
2018-09-27 12:00:00	NQ	Futures	9008.26	9017.94	9001.52	9013.84	27678.0
2018-09-27 13:00:00	NQ	Futures	9013.54	9014.72	9006.21	9010.61	17330.0
2018-09-27 14:00:00	NQ	Futures	9010.61	9011.2	8990.37	8993.6	27485.0
2018-09-27 15:00:00	NQ	Futures	8993.6	8999.17	8977.76	8986.56	45805.0
2018-09-27 16:00:00	NQ	Futures	8986.27	8993.01	8976.59	8993.01	11843.0
2018-09-27 18:00:00	NQ	Futures	8991.25	8994.48	8986.27	8988.61	1469.0
2018-09-27 19:00:00	NQ	Futures	8988.61	8995.06	8987.73	8989.2	1443.0
2018-09-27 20:00:00	NQ	Futures	8988.91	8992.13	8980.99	8990.08	2101.0
2018-09-27 21:00:00	NQ	Futures	8989.79	9004.16	8989.79	8994.77	3794.0
2018-09-27 22:00:00	NQ	Futures	8994.77	9003.28	8993.89	8997.7	2770.0
2018-09-27 23:00:00	NQ	Futures	8997.41	9002.98	8995.65	8996.82	1678.0
2018-09-27 00:00:00	YM	Futures	28710.0	28714.3	28700.2	28708.9	483.0
2018-09-27 01:00:00	YM	Futures	28710.0	28717.6	28664.4	28670.9	1786.0
2018-09-27 02:00:00	YM	Futures	28669.8	28689.4	28651.3	28682.8	2667.0
2018-09-27 03:00:00	YM	Futures	28683.9	28705.7	28637.2	28644.8	4667.0

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

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