PREVIEW / futures_1hour / 2018-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-03.parquet
  size:    47 KB
  rows:    1,395

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-08-03 00:00:00	ES	Futures	3080.78	3082.14	3080.78	3082.14	1771.0
2018-08-03 01:00:00	ES	Futures	3082.14	3082.68	3081.05	3081.59	3208.0
2018-08-03 02:00:00	ES	Futures	3081.59	3083.23	3080.78	3081.59	8682.0
2018-08-03 03:00:00	ES	Futures	3081.59	3081.87	3078.87	3080.5	17823.0
2018-08-03 04:00:00	ES	Futures	3080.78	3081.59	3078.6	3080.78	13578.0
2018-08-03 05:00:00	ES	Futures	3080.78	3082.96	3079.96	3082.96	7686.0
2018-08-03 06:00:00	ES	Futures	3083.23	3084.86	3082.68	3084.05	7817.0
2018-08-03 07:00:00	ES	Futures	3084.05	3090.86	3084.05	3087.32	30056.0
2018-08-03 08:00:00	ES	Futures	3087.59	3088.68	3079.96	3082.14	53755.0
2018-08-03 09:00:00	ES	Futures	3082.41	3085.68	3081.05	3083.23	124061.0
2018-08-03 10:00:00	ES	Futures	3083.23	3090.31	3082.14	3085.68	129527.0
2018-08-03 11:00:00	ES	Futures	3085.68	3088.41	3082.96	3082.96	80163.0
2018-08-03 12:00:00	ES	Futures	3082.96	3089.22	3082.68	3088.13	52424.0
2018-08-03 13:00:00	ES	Futures	3088.13	3092.22	3088.13	3091.68	50761.0
2018-08-03 14:00:00	ES	Futures	3091.68	3092.22	3090.04	3091.95	54706.0
2018-08-03 15:00:00	ES	Futures	3092.22	3095.76	3091.68	3095.76	148472.0
2018-08-03 16:00:00	ES	Futures	3095.49	3096.85	3093.85	3096.58	58709.0
2018-08-03 00:00:00	NQ	Futures	8697.41	8701.23	8695.64	8698.88	845.0
2018-08-03 01:00:00	NQ	Futures	8698.88	8700.06	8694.46	8700.06	1304.0
2018-08-03 02:00:00	NQ	Futures	8700.06	8703.88	8696.52	8697.41	2346.0
2018-08-03 03:00:00	NQ	Futures	8698.0	8699.76	8690.34	8696.82	4233.0
2018-08-03 04:00:00	NQ	Futures	8697.11	8699.76	8691.22	8697.11	2575.0
2018-08-03 05:00:00	NQ	Futures	8697.11	8706.24	8695.35	8705.65	2491.0
2018-08-03 06:00:00	NQ	Futures	8705.65	8713.6	8702.41	8705.94	3476.0
2018-08-03 07:00:00	NQ	Futures	8705.94	8732.44	8705.06	8724.2	8008.0
2018-08-03 08:00:00	NQ	Futures	8724.49	8728.03	8693.87	8696.52	15876.0
2018-08-03 09:00:00	NQ	Futures	8696.52	8715.66	8670.32	8686.81	60269.0
2018-08-03 10:00:00	NQ	Futures	8686.81	8718.9	8682.98	8690.63	64665.0
2018-08-03 11:00:00	NQ	Futures	8690.63	8705.65	8677.98	8678.27	35715.0
2018-08-03 12:00:00	NQ	Futures	8678.27	8703.88	8677.98	8697.41	18341.0
2018-08-03 13:00:00	NQ	Futures	8697.41	8711.54	8691.81	8709.48	15715.0
2018-08-03 14:00:00	NQ	Futures	8709.18	8711.54	8699.17	8705.94	13501.0
2018-08-03 15:00:00	NQ	Futures	8705.94	8718.02	8703.88	8718.02	27245.0
2018-08-03 16:00:00	NQ	Futures	8717.72	8723.02	8714.19	8721.84	7809.0
2018-08-03 00:00:00	YM	Futures	27493.8	27506.8	27493.8	27501.4	468.0
2018-08-03 01:00:00	YM	Futures	27500.3	27509.0	27491.6	27499.2	694.0
2018-08-03 02:00:00	YM	Futures	27499.2	27507.9	27486.1	27494.8	1639.0
2018-08-03 03:00:00	YM	Futures	27493.8	27498.1	27461.1	27480.7	2771.0
2018-08-03 04:00:00	YM	Futures	27481.8	27494.8	27465.5	27487.2	2064.0
2018-08-03 05:00:00	YM	Futures	27487.2	27513.3	27482.9	27510.1	1304.0
2018-08-03 06:00:00	YM	Futures	27511.1	27532.9	27506.8	27523.1	1741.0
2018-08-03 07:00:00	YM	Futures	27523.1	27594.9	27520.9	27561.2	4611.0
2018-08-03 08:00:00	YM	Futures	27562.2	27567.7	27478.5	27486.1	8884.0
2018-08-03 09:00:00	YM	Futures	27488.3	27551.4	27481.8	27539.4	19203.0
2018-08-03 10:00:00	YM	Futures	27540.5	27598.1	27518.8	27552.5	18494.0
2018-08-03 11:00:00	YM	Futures	27552.5	27591.6	27536.2	27551.4	12072.0
2018-08-03 12:00:00	YM	Futures	27551.4	27606.8	27548.1	27598.1	8548.0
2018-08-03 13:00:00	YM	Futures	27598.1	27614.4	27594.9	27607.9	6435.0
2018-08-03 14:00:00	YM	Futures	27607.9	27610.1	27591.6	27604.6	5264.0
2018-08-03 15:00:00	YM	Futures	27604.6	27653.6	27600.3	27641.6	12172.0

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

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