PREVIEW / futures_1hour / 2017-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-04.parquet
  size:    39 KB
  rows:    1,163

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-07-04 00:00:00	ES	Futures	2651.12	2651.94	2650.02	2650.84	2711.0
2017-07-04 01:00:00	ES	Futures	2651.12	2651.39	2649.2	2649.75	5429.0
2017-07-04 02:00:00	ES	Futures	2649.75	2651.94	2647.29	2649.2	12539.0
2017-07-04 03:00:00	ES	Futures	2649.2	2656.86	2648.38	2655.49	23689.0
2017-07-04 04:00:00	ES	Futures	2655.49	2657.4	2654.12	2655.22	10567.0
2017-07-04 05:00:00	ES	Futures	2655.22	2658.22	2654.67	2657.68	8755.0
2017-07-04 06:00:00	ES	Futures	2657.68	2658.22	2655.76	2655.76	6464.0
2017-07-04 07:00:00	ES	Futures	2655.76	2656.86	2654.94	2656.58	5110.0
2017-07-04 08:00:00	ES	Futures	2656.31	2656.86	2654.4	2654.94	3656.0
2017-07-04 09:00:00	ES	Futures	2654.94	2657.13	2654.4	2656.86	7678.0
2017-07-04 10:00:00	ES	Futures	2656.86	2657.13	2655.76	2656.86	6355.0
2017-07-04 11:00:00	ES	Futures	2656.86	2657.13	2651.12	2651.39	17222.0
2017-07-04 12:00:00	ES	Futures	2651.39	2652.21	2649.75	2651.66	6259.0
2017-07-04 18:00:00	ES	Futures	2651.12	2652.76	2649.2	2651.12	5443.0
2017-07-04 19:00:00	ES	Futures	2651.12	2651.39	2648.93	2650.3	3198.0
2017-07-04 20:00:00	ES	Futures	2650.3	2651.39	2649.2	2651.12	5231.0
2017-07-04 21:00:00	ES	Futures	2650.84	2651.39	2648.38	2648.93	5443.0
2017-07-04 22:00:00	ES	Futures	2648.93	2651.39	2648.93	2651.12	4011.0
2017-07-04 23:00:00	ES	Futures	2651.12	2652.48	2651.12	2651.39	4109.0
2017-07-04 00:00:00	NQ	Futures	6647.3	6648.19	6641.34	6644.32	841.0
2017-07-04 01:00:00	NQ	Futures	6645.21	6646.11	6633.9	6638.66	1953.0
2017-07-04 02:00:00	NQ	Futures	6638.36	6649.08	6635.68	6637.77	1917.0
2017-07-04 03:00:00	NQ	Futures	6638.07	6666.95	6635.98	6660.99	4559.0
2017-07-04 04:00:00	NQ	Futures	6661.29	6669.33	6658.31	6662.48	1581.0
2017-07-04 05:00:00	NQ	Futures	6662.18	6691.66	6660.99	6688.68	4013.0
2017-07-04 06:00:00	NQ	Futures	6688.39	6691.07	6680.64	6681.24	1980.0
2017-07-04 07:00:00	NQ	Futures	6681.24	6684.81	6676.77	6683.32	1523.0
2017-07-04 08:00:00	NQ	Futures	6683.62	6686.6	6672.01	6675.58	1749.0
2017-07-04 09:00:00	NQ	Futures	6675.58	6686.3	6674.39	6684.52	3613.0
2017-07-04 10:00:00	NQ	Futures	6684.52	6686.0	6667.25	6668.14	3852.0
2017-07-04 11:00:00	NQ	Futures	6668.14	6669.03	6629.13	6630.62	9812.0
2017-07-04 12:00:00	NQ	Futures	6630.03	6647.0	6622.29	6646.7	6286.0
2017-07-04 18:00:00	NQ	Futures	6644.62	6653.55	6635.68	6649.08	1896.0
2017-07-04 19:00:00	NQ	Futures	6648.49	6651.47	6639.85	6642.23	905.0
2017-07-04 20:00:00	NQ	Futures	6642.53	6647.3	6636.28	6644.91	1836.0
2017-07-04 21:00:00	NQ	Futures	6644.62	6647.59	6630.32	6631.81	2234.0
2017-07-04 22:00:00	NQ	Futures	6632.11	6644.02	6631.81	6642.83	1738.0
2017-07-04 23:00:00	NQ	Futures	6643.43	6651.76	6642.23	6647.0	1954.0
2017-07-04 00:00:00	YM	Futures	23342.5	23346.8	23329.4	23339.2	735.0
2017-07-04 01:00:00	YM	Futures	23340.3	23342.5	23305.5	23309.8	1896.0
2017-07-04 02:00:00	YM	Futures	23309.8	23319.6	23301.1	23303.3	1870.0
2017-07-04 03:00:00	YM	Futures	23304.4	23352.3	23297.9	23334.9	4251.0
2017-07-04 04:00:00	YM	Futures	23336.0	23362.1	23330.5	23341.4	1912.0
2017-07-04 05:00:00	YM	Futures	23341.4	23373.0	23337.1	23362.1	1904.0
2017-07-04 06:00:00	YM	Futures	23362.1	23366.4	23328.3	23339.2	1414.0
2017-07-04 07:00:00	YM	Futures	23339.2	23349.0	23332.7	23346.8	635.0
2017-07-04 08:00:00	YM	Futures	23345.8	23349.0	23334.9	23339.2	638.0
2017-07-04 09:00:00	YM	Futures	23339.2	23369.7	23338.1	23366.4	1606.0
2017-07-04 10:00:00	YM	Futures	23366.4	23369.7	23338.1	23338.1	1811.0
2017-07-04 11:00:00	YM	Futures	23340.3	23359.9	23317.5	23327.3	4159.0

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

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