PREVIEW / futures_1hour / 2019-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-26.parquet
  size:    58 KB
  rows:    1,843

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-06-26 00:00:00	ES	Futures	3165.63	3166.17	3162.11	3162.38	4234.0
2019-06-26 01:00:00	ES	Futures	3162.38	3165.08	3162.11	3164.81	5094.0
2019-06-26 02:00:00	ES	Futures	3164.81	3167.52	3164.27	3166.71	8269.0
2019-06-26 03:00:00	ES	Futures	3166.71	3167.79	3164.27	3166.44	20908.0
2019-06-26 04:00:00	ES	Futures	3166.17	3169.69	3165.35	3169.14	16781.0
2019-06-26 05:00:00	ES	Futures	3169.41	3181.6	3168.6	3179.16	62860.0
2019-06-26 06:00:00	ES	Futures	3179.16	3182.41	3176.72	3177.81	26635.0
2019-06-26 07:00:00	ES	Futures	3177.54	3179.16	3175.91	3177.27	19390.0
2019-06-26 08:00:00	ES	Futures	3177.27	3178.62	3169.14	3172.66	55104.0
2019-06-26 09:00:00	ES	Futures	3172.39	3179.97	3169.69	3172.12	188955.0
2019-06-26 10:00:00	ES	Futures	3172.12	3174.29	3166.44	3172.66	173882.0
2019-06-26 11:00:00	ES	Futures	3172.39	3174.83	3167.25	3171.04	107148.0
2019-06-26 12:00:00	ES	Futures	3170.77	3173.48	3167.52	3171.31	73670.0
2019-06-26 13:00:00	ES	Futures	3171.04	3171.85	3162.65	3165.63	78501.0
2019-06-26 14:00:00	ES	Futures	3165.35	3167.52	3158.59	3162.92	98400.0
2019-06-26 15:00:00	ES	Futures	3162.65	3166.71	3159.4	3160.48	157707.0
2019-06-26 16:00:00	ES	Futures	3160.48	3161.29	3155.88	3156.69	57209.0
2019-06-26 18:00:00	ES	Futures	3156.15	3159.4	3156.15	3157.23	4313.0
2019-06-26 19:00:00	ES	Futures	3156.96	3160.75	3156.96	3160.48	3159.0
2019-06-26 20:00:00	ES	Futures	3160.48	3162.92	3159.4	3162.38	9015.0
2019-06-26 21:00:00	ES	Futures	3162.65	3169.14	3162.11	3168.06	17260.0
2019-06-26 22:00:00	ES	Futures	3168.06	3171.31	3167.25	3170.23	13498.0
2019-06-26 23:00:00	ES	Futures	3169.96	3170.23	3168.6	3169.96	4845.0
2019-06-26 00:00:00	NQ	Futures	8866.17	8867.04	8848.76	8848.76	3101.0
2019-06-26 01:00:00	NQ	Futures	8848.47	8857.76	8845.57	8857.47	2745.0
2019-06-26 02:00:00	NQ	Futures	8857.47	8866.75	8854.28	8861.82	3176.0
2019-06-26 03:00:00	NQ	Futures	8861.24	8866.17	8853.7	8863.85	6052.0
2019-06-26 04:00:00	NQ	Futures	8863.85	8877.49	8860.08	8877.2	5575.0
2019-06-26 05:00:00	NQ	Futures	8877.49	8929.42	8875.17	8919.85	18793.0
2019-06-26 06:00:00	NQ	Futures	8920.14	8934.07	8910.56	8914.63	9302.0
2019-06-26 07:00:00	NQ	Futures	8914.34	8920.72	8906.21	8911.72	6183.0
2019-06-26 08:00:00	NQ	Futures	8911.72	8917.53	8871.69	8888.8	20133.0
2019-06-26 09:00:00	NQ	Futures	8888.8	8958.44	8884.16	8943.35	74364.0
2019-06-26 10:00:00	NQ	Futures	8943.06	8945.67	8912.6	8922.75	55141.0
2019-06-26 11:00:00	NQ	Futures	8922.75	8926.81	8901.86	8921.88	33852.0
2019-06-26 12:00:00	NQ	Futures	8921.88	8928.84	8907.08	8914.63	23638.0
2019-06-26 13:00:00	NQ	Futures	8914.34	8916.08	8876.04	8887.93	28428.0
2019-06-26 14:00:00	NQ	Futures	8887.64	8896.64	8871.4	8881.84	24386.0
2019-06-26 15:00:00	NQ	Futures	8881.84	8899.54	8881.55	8884.74	30453.0
2019-06-26 16:00:00	NQ	Futures	8885.03	8887.64	8868.2	8870.52	7131.0
2019-06-26 18:00:00	NQ	Futures	8867.91	8878.07	8867.62	8871.11	1559.0
2019-06-26 19:00:00	NQ	Futures	8870.81	8883.87	8870.52	8882.71	1395.0
2019-06-26 20:00:00	NQ	Futures	8883.0	8892.0	8878.65	8888.22	2606.0
2019-06-26 21:00:00	NQ	Futures	8888.51	8912.6	8888.51	8908.82	5829.0
2019-06-26 22:00:00	NQ	Futures	8909.11	8919.85	8905.05	8917.53	5131.0
2019-06-26 23:00:00	NQ	Futures	8917.82	8918.69	8910.85	8918.69	1936.0
2019-06-26 00:00:00	YM	Futures	28887.3	28891.6	28860.1	28860.1	1086.0
2019-06-26 01:00:00	YM	Futures	28860.1	28879.7	28857.9	28877.5	1461.0
2019-06-26 02:00:00	YM	Futures	28877.5	28898.1	28872.0	28889.4	1857.0
2019-06-26 03:00:00	YM	Futures	28889.4	28898.1	28872.0	28891.6	3974.0

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

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