PREVIEW / futures_1hour / 2018-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-20.parquet
  size:    47 KB
  rows:    1,392

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
2018-07-20 00:00:00	ES	Futures	3052.17	3052.98	3051.08	3051.62	3305.0
2018-07-20 01:00:00	ES	Futures	3051.35	3055.98	3051.08	3055.16	9688.0
2018-07-20 02:00:00	ES	Futures	3055.16	3055.71	3052.44	3054.62	8897.0
2018-07-20 03:00:00	ES	Futures	3054.35	3056.53	3053.26	3055.98	9427.0
2018-07-20 04:00:00	ES	Futures	3055.98	3057.07	3055.16	3055.44	7790.0
2018-07-20 05:00:00	ES	Futures	3055.44	3058.16	3054.07	3057.34	11248.0
2018-07-20 06:00:00	ES	Futures	3057.62	3057.89	3043.99	3050.81	50762.0
2018-07-20 07:00:00	ES	Futures	3050.81	3054.62	3050.26	3053.8	15489.0
2018-07-20 08:00:00	ES	Futures	3053.8	3054.89	3047.81	3048.63	38316.0
2018-07-20 09:00:00	ES	Futures	3048.9	3058.16	3047.54	3058.16	184706.0
2018-07-20 10:00:00	ES	Futures	3058.16	3060.89	3055.16	3058.98	111260.0
2018-07-20 11:00:00	ES	Futures	3058.98	3063.07	3056.8	3059.8	76758.0
2018-07-20 12:00:00	ES	Futures	3059.8	3060.89	3057.62	3058.98	47925.0
2018-07-20 13:00:00	ES	Futures	3059.25	3060.07	3055.44	3058.71	46801.0
2018-07-20 14:00:00	ES	Futures	3058.71	3060.34	3052.44	3056.53	82415.0
2018-07-20 15:00:00	ES	Futures	3056.8	3057.07	3053.26	3055.16	145504.0
2018-07-20 16:00:00	ES	Futures	3055.16	3055.98	3051.89	3055.44	52729.0
2018-07-20 00:00:00	NQ	Futures	8687.1	8694.17	8681.21	8684.75	1560.0
2018-07-20 01:00:00	NQ	Futures	8684.45	8707.12	8683.57	8703.59	2995.0
2018-07-20 02:00:00	NQ	Futures	8704.18	8708.3	8694.76	8706.83	2566.0
2018-07-20 03:00:00	NQ	Futures	8706.53	8710.66	8700.35	8708.3	2645.0
2018-07-20 04:00:00	NQ	Futures	8708.89	8712.42	8705.94	8708.01	1993.0
2018-07-20 05:00:00	NQ	Futures	8707.71	8715.37	8702.71	8712.42	3567.0
2018-07-20 06:00:00	NQ	Futures	8712.72	8712.72	8659.13	8688.57	13293.0
2018-07-20 07:00:00	NQ	Futures	8688.87	8702.12	8686.81	8697.11	5747.0
2018-07-20 08:00:00	NQ	Futures	8697.41	8698.29	8675.33	8680.04	9371.0
2018-07-20 09:00:00	NQ	Futures	8680.62	8709.77	8676.21	8703.29	58666.0
2018-07-20 10:00:00	NQ	Futures	8703.29	8730.97	8692.7	8720.96	42867.0
2018-07-20 11:00:00	NQ	Futures	8720.67	8728.61	8703.29	8706.24	26625.0
2018-07-20 12:00:00	NQ	Futures	8705.65	8705.94	8681.8	8694.17	22711.0
2018-07-20 13:00:00	NQ	Futures	8694.17	8700.06	8680.33	8691.22	13875.0
2018-07-20 14:00:00	NQ	Futures	8690.93	8696.23	8663.84	8677.98	21071.0
2018-07-20 15:00:00	NQ	Futures	8677.98	8679.74	8662.96	8672.68	30531.0
2018-07-20 16:00:00	NQ	Futures	8672.68	8675.33	8665.61	8674.74	7463.0
2018-07-20 00:00:00	YM	Futures	27158.9	27165.4	27144.8	27151.3	690.0
2018-07-20 01:00:00	YM	Futures	27151.3	27206.7	27148.0	27195.9	2517.0
2018-07-20 02:00:00	YM	Futures	27197.0	27202.4	27167.6	27186.1	1759.0
2018-07-20 03:00:00	YM	Futures	27185.0	27212.2	27173.0	27205.7	2069.0
2018-07-20 04:00:00	YM	Futures	27205.7	27218.7	27198.1	27199.1	1574.0
2018-07-20 05:00:00	YM	Futures	27198.1	27230.7	27188.3	27228.5	2295.0
2018-07-20 06:00:00	YM	Futures	27228.5	27229.6	27087.2	27141.5	8547.0
2018-07-20 07:00:00	YM	Futures	27142.6	27170.9	27138.3	27164.3	2652.0
2018-07-20 08:00:00	YM	Futures	27165.4	27174.1	27096.9	27104.6	5910.0
2018-07-20 09:00:00	YM	Futures	27104.6	27228.5	27086.1	27228.5	25696.0
2018-07-20 10:00:00	YM	Futures	27228.5	27277.4	27208.9	27249.1	18826.0
2018-07-20 11:00:00	YM	Futures	27250.2	27298.1	27236.1	27268.7	11110.0
2018-07-20 12:00:00	YM	Futures	27268.7	27278.5	27251.3	27261.1	6264.0
2018-07-20 13:00:00	YM	Futures	27261.1	27268.7	27218.7	27250.2	6852.0
2018-07-20 14:00:00	YM	Futures	27250.2	27261.1	27200.2	27240.4	9619.0
2018-07-20 15:00:00	YM	Futures	27242.6	27247.0	27208.9	27227.4	12758.0

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

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