PREVIEW / futures_1hour / 2019-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-19.parquet
  size:    61 KB
  rows:    1,870

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-19 00:00:00	ES	Futures	3169.96	3170.5	3168.87	3169.69	3509.0
2019-06-19 01:00:00	ES	Futures	3169.69	3171.04	3169.14	3169.41	6001.0
2019-06-19 02:00:00	ES	Futures	3169.41	3170.5	3167.79	3167.79	7969.0
2019-06-19 03:00:00	ES	Futures	3167.79	3170.77	3167.52	3168.87	15411.0
2019-06-19 04:00:00	ES	Futures	3169.14	3170.23	3163.73	3165.35	18354.0
2019-06-19 05:00:00	ES	Futures	3165.35	3168.6	3164.81	3168.06	21912.0
2019-06-19 06:00:00	ES	Futures	3168.33	3170.5	3166.71	3169.14	15168.0
2019-06-19 07:00:00	ES	Futures	3169.14	3169.41	3166.71	3169.41	13876.0
2019-06-19 08:00:00	ES	Futures	3169.14	3170.77	3167.79	3169.41	23701.0
2019-06-19 09:00:00	ES	Futures	3169.14	3169.69	3162.38	3168.6	168239.0
2019-06-19 10:00:00	ES	Futures	3168.33	3169.14	3162.38	3164.27	125088.0
2019-06-19 11:00:00	ES	Futures	3164.27	3167.52	3163.73	3165.9	76777.0
2019-06-19 12:00:00	ES	Futures	3166.17	3166.44	3163.46	3163.73	52061.0
2019-06-19 13:00:00	ES	Futures	3163.73	3165.63	3160.75	3164.81	65607.0
2019-06-19 14:00:00	ES	Futures	3164.81	3178.35	3156.69	3171.58	302263.0
2019-06-19 15:00:00	ES	Futures	3171.31	3179.97	3170.5	3173.75	264335.0
2019-06-19 16:00:00	ES	Futures	3173.75	3176.99	3172.66	3174.29	53547.0
2019-06-19 18:00:00	ES	Futures	3173.48	3181.33	3173.2	3180.24	10074.0
2019-06-19 19:00:00	ES	Futures	3180.51	3186.74	3179.97	3184.57	10400.0
2019-06-19 20:00:00	ES	Futures	3184.85	3186.47	3183.49	3184.57	20539.0
2019-06-19 21:00:00	ES	Futures	3184.57	3188.91	3183.76	3187.01	22773.0
2019-06-19 22:00:00	ES	Futures	3186.74	3188.64	3185.66	3186.47	11716.0
2019-06-19 23:00:00	ES	Futures	3186.47	3189.45	3186.47	3188.64	8137.0
2019-06-19 00:00:00	NQ	Futures	8911.14	8911.72	8905.34	8909.98	1428.0
2019-06-19 01:00:00	NQ	Futures	8909.69	8915.21	8907.95	8909.69	1957.0
2019-06-19 02:00:00	NQ	Futures	8909.69	8916.66	8908.24	8908.53	2427.0
2019-06-19 03:00:00	NQ	Futures	8908.24	8916.66	8907.08	8911.43	3443.0
2019-06-19 04:00:00	NQ	Futures	8911.72	8916.08	8898.96	8904.47	5520.0
2019-06-19 05:00:00	NQ	Futures	8904.47	8913.18	8893.45	8908.82	5549.0
2019-06-19 06:00:00	NQ	Futures	8909.4	8914.92	8900.12	8911.14	3567.0
2019-06-19 07:00:00	NQ	Futures	8910.85	8914.34	8900.99	8914.05	3840.0
2019-06-19 08:00:00	NQ	Futures	8914.05	8919.56	8908.53	8916.08	5656.0
2019-06-19 09:00:00	NQ	Futures	8916.08	8918.98	8866.17	8889.67	56831.0
2019-06-19 10:00:00	NQ	Futures	8889.38	8894.32	8872.56	8879.52	37438.0
2019-06-19 11:00:00	NQ	Futures	8879.81	8895.48	8879.23	8891.12	24298.0
2019-06-19 12:00:00	NQ	Futures	8890.83	8893.45	8880.68	8885.03	15461.0
2019-06-19 13:00:00	NQ	Futures	8884.74	8887.93	8869.65	8881.84	18686.0
2019-06-19 14:00:00	NQ	Futures	8881.55	8952.05	8855.15	8905.92	107039.0
2019-06-19 15:00:00	NQ	Futures	8905.34	8949.73	8902.44	8931.16	61629.0
2019-06-19 16:00:00	NQ	Futures	8931.74	8940.16	8929.42	8932.33	7584.0
2019-06-19 18:00:00	NQ	Futures	8932.03	8957.28	8927.97	8952.34	3116.0
2019-06-19 19:00:00	NQ	Futures	8952.93	8973.82	8951.47	8968.01	3871.0
2019-06-19 20:00:00	NQ	Futures	8968.3	8982.23	8964.82	8978.46	6061.0
2019-06-19 21:00:00	NQ	Futures	8978.46	8993.25	8978.46	8992.67	8005.0
2019-06-19 22:00:00	NQ	Futures	8992.96	9005.73	8986.58	8997.61	6399.0
2019-06-19 23:00:00	NQ	Futures	8997.61	9012.98	8997.03	9008.92	3515.0
2019-06-19 00:00:00	YM	Futures	28840.5	28840.5	28827.5	28835.1	860.0
2019-06-19 01:00:00	YM	Futures	28834.0	28849.2	28829.6	28834.0	1273.0
2019-06-19 02:00:00	YM	Futures	28834.0	28837.2	28806.8	28807.9	1743.0
2019-06-19 03:00:00	YM	Futures	28806.8	28841.6	28802.4	28826.4	3195.0

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

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