PREVIEW / futures_1hour / 2017-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-09.parquet
  size:    48 KB
  rows:    1,575

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-09 00:00:00	ES	Futures	2788.11	2788.38	2787.56	2787.56	1776.0
2017-10-09 01:00:00	ES	Futures	2787.56	2787.84	2787.29	2787.84	2075.0
2017-10-09 02:00:00	ES	Futures	2787.84	2788.11	2786.74	2787.02	6223.0
2017-10-09 03:00:00	ES	Futures	2787.02	2789.2	2787.02	2788.11	12107.0
2017-10-09 04:00:00	ES	Futures	2788.38	2788.66	2787.02	2788.11	11462.0
2017-10-09 05:00:00	ES	Futures	2787.84	2788.66	2787.29	2788.38	8010.0
2017-10-09 06:00:00	ES	Futures	2788.38	2789.75	2788.38	2789.2	9388.0
2017-10-09 07:00:00	ES	Futures	2789.2	2790.84	2788.93	2790.3	16003.0
2017-10-09 08:00:00	ES	Futures	2790.57	2790.84	2788.66	2789.48	14501.0
2017-10-09 09:00:00	ES	Futures	2789.48	2790.3	2783.73	2785.37	125116.0
2017-10-09 10:00:00	ES	Futures	2785.1	2786.19	2783.19	2784.83	85867.0
2017-10-09 11:00:00	ES	Futures	2785.1	2787.02	2784.55	2786.74	49440.0
2017-10-09 12:00:00	ES	Futures	2786.74	2787.02	2784.55	2784.83	38759.0
2017-10-09 13:00:00	ES	Futures	2785.1	2785.92	2784.83	2785.65	32460.0
2017-10-09 14:00:00	ES	Futures	2785.37	2785.92	2782.09	2782.09	58860.0
2017-10-09 15:00:00	ES	Futures	2782.36	2782.64	2778.53	2782.09	167594.0
2017-10-09 16:00:00	ES	Futures	2782.09	2784.01	2782.09	2782.91	51048.0
2017-10-09 18:00:00	ES	Futures	2782.91	2783.73	2782.64	2783.19	1963.0
2017-10-09 19:00:00	ES	Futures	2783.19	2783.73	2782.91	2783.46	1612.0
2017-10-09 20:00:00	ES	Futures	2783.73	2785.92	2782.64	2785.37	10042.0
2017-10-09 21:00:00	ES	Futures	2785.37	2786.47	2784.55	2784.55	6477.0
2017-10-09 22:00:00	ES	Futures	2784.55	2785.1	2784.01	2784.28	3993.0
2017-10-09 23:00:00	ES	Futures	2784.55	2785.37	2784.28	2784.55	2187.0
2017-10-09 00:00:00	NQ	Futures	7227.81	7228.41	7226.33	7226.62	330.0
2017-10-09 01:00:00	NQ	Futures	7226.62	7227.22	7224.25	7226.62	724.0
2017-10-09 02:00:00	NQ	Futures	7226.62	7227.22	7221.57	7222.76	980.0
2017-10-09 03:00:00	NQ	Futures	7223.06	7230.19	7222.46	7226.03	2241.0
2017-10-09 04:00:00	NQ	Futures	7225.73	7228.71	7223.06	7225.73	1168.0
2017-10-09 05:00:00	NQ	Futures	7226.03	7228.41	7223.95	7226.62	970.0
2017-10-09 06:00:00	NQ	Futures	7226.92	7230.49	7226.33	7228.71	1104.0
2017-10-09 07:00:00	NQ	Futures	7228.41	7232.87	7227.81	7231.38	1995.0
2017-10-09 08:00:00	NQ	Futures	7231.68	7236.14	7230.79	7233.17	3076.0
2017-10-09 09:00:00	NQ	Futures	7233.17	7235.25	7219.49	7229.9	31391.0
2017-10-09 10:00:00	NQ	Futures	7229.9	7237.93	7216.51	7222.16	26504.0
2017-10-09 11:00:00	NQ	Futures	7222.46	7230.79	7221.87	7229.0	12210.0
2017-10-09 12:00:00	NQ	Futures	7229.3	7230.49	7221.87	7223.35	8456.0
2017-10-09 13:00:00	NQ	Futures	7223.35	7226.92	7219.19	7221.57	9665.0
2017-10-09 14:00:00	NQ	Futures	7221.87	7225.73	7214.73	7214.73	13826.0
2017-10-09 15:00:00	NQ	Futures	7214.73	7215.62	7203.13	7212.05	28412.0
2017-10-09 16:00:00	NQ	Futures	7212.05	7216.51	7210.56	7211.75	5220.0
2017-10-09 18:00:00	NQ	Futures	7212.05	7214.73	7210.86	7213.54	672.0
2017-10-09 19:00:00	NQ	Futures	7213.54	7215.32	7212.35	7214.13	339.0
2017-10-09 20:00:00	NQ	Futures	7214.13	7223.06	7212.05	7221.27	1996.0
2017-10-09 21:00:00	NQ	Futures	7220.97	7224.25	7217.7	7218.59	1407.0
2017-10-09 22:00:00	NQ	Futures	7218.59	7219.49	7216.81	7218.3	818.0
2017-10-09 23:00:00	NQ	Futures	7218.0	7220.38	7218.0	7218.89	387.0
2017-10-09 00:00:00	YM	Futures	24712.2	24714.4	24707.8	24710.0	870.0
2017-10-09 01:00:00	YM	Futures	24710.0	24711.1	24702.4	24705.7	1264.0
2017-10-09 02:00:00	YM	Futures	24706.7	24708.9	24700.2	24701.3	827.0
2017-10-09 03:00:00	YM	Futures	24701.3	24717.6	24701.3	24715.4	1526.0

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

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