PREVIEW / futures_1hour / 2019-05-06

all futures 1-hour files

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

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-05-06 00:00:00	ES	Futures	3130.42	3147.77	3129.88	3146.14	18780.0
2019-05-06 01:00:00	ES	Futures	3145.87	3148.85	3140.18	3143.97	26451.0
2019-05-06 02:00:00	ES	Futures	3143.7	3147.5	3135.3	3136.65	35750.0
2019-05-06 03:00:00	ES	Futures	3136.92	3148.58	3135.03	3141.26	59320.0
2019-05-06 04:00:00	ES	Futures	3141.26	3144.24	3135.03	3136.92	22092.0
2019-05-06 05:00:00	ES	Futures	3136.92	3140.99	3135.3	3139.64	18506.0
2019-05-06 06:00:00	ES	Futures	3139.64	3145.33	3138.01	3143.43	19416.0
2019-05-06 07:00:00	ES	Futures	3143.43	3146.96	3140.99	3145.06	31712.0
2019-05-06 08:00:00	ES	Futures	3145.06	3149.94	3144.24	3147.23	51898.0
2019-05-06 09:00:00	ES	Futures	3146.96	3160.78	3138.28	3160.24	284395.0
2019-05-06 10:00:00	ES	Futures	3160.24	3168.1	3155.09	3166.75	246401.0
2019-05-06 11:00:00	ES	Futures	3166.47	3171.35	3163.49	3164.85	187278.0
2019-05-06 12:00:00	ES	Futures	3164.58	3167.02	3162.41	3162.68	113968.0
2019-05-06 13:00:00	ES	Futures	3162.68	3169.19	3160.51	3168.91	104428.0
2019-05-06 14:00:00	ES	Futures	3168.91	3183.55	3167.29	3183.28	160940.0
2019-05-06 15:00:00	ES	Futures	3183.01	3186.27	3179.49	3181.66	212037.0
2019-05-06 16:00:00	ES	Futures	3181.39	3183.55	3154.55	3155.36	83239.0
2019-05-06 18:00:00	ES	Futures	3157.53	3163.76	3156.71	3161.87	32117.0
2019-05-06 19:00:00	ES	Futures	3162.14	3165.39	3160.78	3164.31	12065.0
2019-05-06 20:00:00	ES	Futures	3164.58	3165.39	3155.9	3161.87	26723.0
2019-05-06 21:00:00	ES	Futures	3162.14	3164.03	3159.43	3162.41	15018.0
2019-05-06 22:00:00	ES	Futures	3162.41	3165.66	3162.14	3164.58	13446.0
2019-05-06 23:00:00	ES	Futures	3164.58	3164.58	3156.17	3158.34	20899.0
2019-05-06 00:00:00	NQ	Futures	8944.9	8993.81	8943.15	8990.03	7020.0
2019-05-06 01:00:00	NQ	Futures	8990.03	8995.85	8974.3	8983.62	8697.0
2019-05-06 02:00:00	NQ	Futures	8983.62	8994.39	8949.85	8957.71	11414.0
2019-05-06 03:00:00	NQ	Futures	8958.0	8997.89	8954.21	8969.64	16366.0
2019-05-06 04:00:00	NQ	Futures	8969.94	8976.92	8936.74	8944.02	12008.0
2019-05-06 05:00:00	NQ	Futures	8944.31	8959.16	8937.33	8955.96	7788.0
2019-05-06 06:00:00	NQ	Futures	8955.96	8970.52	8949.26	8966.44	7826.0
2019-05-06 07:00:00	NQ	Futures	8966.15	8982.75	8961.2	8978.09	11213.0
2019-05-06 08:00:00	NQ	Futures	8977.8	8994.98	8971.97	8987.7	16771.0
2019-05-06 09:00:00	NQ	Futures	8987.4	9029.33	8939.66	9027.29	92959.0
2019-05-06 10:00:00	NQ	Futures	9027.0	9059.32	9006.04	9055.24	87191.0
2019-05-06 11:00:00	NQ	Futures	9055.24	9069.51	9040.98	9045.05	67056.0
2019-05-06 12:00:00	NQ	Futures	9045.05	9050.29	9020.89	9023.51	44035.0
2019-05-06 13:00:00	NQ	Futures	9023.22	9052.92	9015.94	9050.88	33594.0
2019-05-06 14:00:00	NQ	Futures	9051.17	9103.29	9043.31	9100.66	46544.0
2019-05-06 15:00:00	NQ	Futures	9100.96	9104.45	9084.36	9093.97	59026.0
2019-05-06 16:00:00	NQ	Futures	9093.68	9097.17	9013.03	9013.03	15858.0
2019-05-06 18:00:00	NQ	Futures	9019.72	9039.52	9016.81	9033.7	7714.0
2019-05-06 19:00:00	NQ	Futures	9033.99	9043.89	9027.88	9040.69	3312.0
2019-05-06 20:00:00	NQ	Futures	9040.98	9043.89	9008.37	9025.26	10711.0
2019-05-06 21:00:00	NQ	Futures	9025.26	9035.45	9020.31	9030.5	5824.0
2019-05-06 22:00:00	NQ	Futures	9030.5	9043.31	9030.2	9040.69	4564.0
2019-05-06 23:00:00	NQ	Futures	9040.4	9040.4	9011.86	9017.98	5131.0
2019-05-06 00:00:00	YM	Futures	28226.1	28354.4	28219.5	28344.6	4514.0
2019-05-06 01:00:00	YM	Futures	28343.5	28364.2	28292.4	28316.3	7469.0
2019-05-06 02:00:00	YM	Futures	28316.3	28345.7	28241.3	28268.5	7771.0
2019-05-06 03:00:00	YM	Futures	28269.6	28356.6	28247.8	28303.3	10783.0

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

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