PREVIEW / futures_1hour / 2017-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-10.parquet
  size:    52 KB
  rows:    1,612

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
2017-10-10 00:00:00	ES	Futures	2784.55	2784.83	2784.01	2784.83	1509.0
2017-10-10 01:00:00	ES	Futures	2784.55	2785.92	2784.55	2785.1	2946.0
2017-10-10 02:00:00	ES	Futures	2785.37	2786.74	2785.1	2786.19	5925.0
2017-10-10 03:00:00	ES	Futures	2786.47	2787.29	2785.65	2786.19	16437.0
2017-10-10 04:00:00	ES	Futures	2785.92	2786.47	2783.46	2784.83	13100.0
2017-10-10 05:00:00	ES	Futures	2785.1	2787.29	2784.28	2787.02	10813.0
2017-10-10 06:00:00	ES	Futures	2787.02	2788.38	2786.47	2787.29	10429.0
2017-10-10 07:00:00	ES	Futures	2787.56	2787.84	2786.19	2787.56	8919.0
2017-10-10 08:00:00	ES	Futures	2787.29	2788.93	2787.02	2788.93	14525.0
2017-10-10 09:00:00	ES	Futures	2788.93	2793.85	2788.11	2790.3	196085.0
2017-10-10 10:00:00	ES	Futures	2790.3	2790.57	2782.64	2786.19	226118.0
2017-10-10 11:00:00	ES	Futures	2786.19	2787.02	2783.46	2784.55	106286.0
2017-10-10 12:00:00	ES	Futures	2784.55	2787.02	2782.36	2786.19	112635.0
2017-10-10 13:00:00	ES	Futures	2785.92	2788.66	2785.37	2786.19	87823.0
2017-10-10 14:00:00	ES	Futures	2786.19	2787.56	2785.1	2785.92	54385.0
2017-10-10 15:00:00	ES	Futures	2785.92	2789.48	2785.92	2789.2	177936.0
2017-10-10 16:00:00	ES	Futures	2789.2	2789.75	2788.38	2789.48	68310.0
2017-10-10 18:00:00	ES	Futures	2788.93	2789.2	2788.11	2788.38	3190.0
2017-10-10 19:00:00	ES	Futures	2788.38	2789.48	2788.11	2788.93	1939.0
2017-10-10 20:00:00	ES	Futures	2788.66	2789.2	2787.84	2788.66	5011.0
2017-10-10 21:00:00	ES	Futures	2788.66	2789.75	2788.66	2789.48	5656.0
2017-10-10 22:00:00	ES	Futures	2789.2	2790.02	2788.66	2789.2	4372.0
2017-10-10 23:00:00	ES	Futures	2789.2	2789.48	2788.66	2789.2	2315.0
2017-10-10 00:00:00	NQ	Futures	7218.59	7220.68	7218.0	7220.08	317.0
2017-10-10 01:00:00	NQ	Futures	7219.78	7223.06	7219.49	7221.57	1005.0
2017-10-10 02:00:00	NQ	Futures	7221.87	7226.33	7220.97	7225.44	1425.0
2017-10-10 03:00:00	NQ	Futures	7225.73	7228.11	7223.06	7224.54	1700.0
2017-10-10 04:00:00	NQ	Futures	7224.84	7226.03	7218.59	7223.06	1774.0
2017-10-10 05:00:00	NQ	Futures	7223.06	7227.81	7221.27	7226.92	1183.0
2017-10-10 06:00:00	NQ	Futures	7226.92	7230.49	7225.44	7226.33	1439.0
2017-10-10 07:00:00	NQ	Futures	7226.62	7229.0	7224.25	7228.71	1279.0
2017-10-10 08:00:00	NQ	Futures	7228.71	7233.76	7227.52	7233.47	4396.0
2017-10-10 09:00:00	NQ	Futures	7233.17	7243.28	7221.27	7223.65	40319.0
2017-10-10 10:00:00	NQ	Futures	7223.95	7224.25	7197.78	7214.13	54860.0
2017-10-10 11:00:00	NQ	Futures	7214.43	7215.92	7192.12	7198.07	32109.0
2017-10-10 12:00:00	NQ	Futures	7198.37	7206.7	7184.39	7203.43	30578.0
2017-10-10 13:00:00	NQ	Futures	7203.72	7213.54	7201.94	7202.83	18861.0
2017-10-10 14:00:00	NQ	Futures	7203.43	7209.37	7200.45	7208.18	14946.0
2017-10-10 15:00:00	NQ	Futures	7208.48	7218.0	7208.48	7217.7	20235.0
2017-10-10 16:00:00	NQ	Futures	7217.7	7219.49	7215.03	7215.32	4473.0
2017-10-10 18:00:00	NQ	Futures	7214.73	7216.22	7212.94	7215.03	921.0
2017-10-10 19:00:00	NQ	Futures	7215.03	7218.59	7213.54	7216.81	592.0
2017-10-10 20:00:00	NQ	Futures	7216.81	7218.3	7215.32	7217.7	857.0
2017-10-10 21:00:00	NQ	Futures	7217.4	7220.97	7217.4	7220.08	1347.0
2017-10-10 22:00:00	NQ	Futures	7220.08	7224.25	7219.78	7220.68	1519.0
2017-10-10 23:00:00	NQ	Futures	7220.68	7221.27	7218.3	7220.08	619.0
2017-10-10 00:00:00	YM	Futures	24723.1	24728.5	24722.0	24726.3	383.0
2017-10-10 01:00:00	YM	Futures	24726.3	24737.2	24726.3	24733.9	989.0
2017-10-10 02:00:00	YM	Futures	24733.9	24741.6	24733.9	24737.2	1272.0
2017-10-10 03:00:00	YM	Futures	24738.3	24743.7	24730.7	24735.0	2182.0

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

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