PREVIEW / futures_1hour / 2019-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-21.parquet
  size:    58 KB
  rows:    1,877

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
2019-11-21 00:00:00	ES	Futures	3369.58	3374.2	3368.5	3372.57	9635.0
2019-11-21 01:00:00	ES	Futures	3372.57	3374.2	3371.76	3372.03	5623.0
2019-11-21 02:00:00	ES	Futures	3372.3	3376.92	3368.5	3370.67	25885.0
2019-11-21 03:00:00	ES	Futures	3370.67	3372.84	3366.32	3372.3	31910.0
2019-11-21 04:00:00	ES	Futures	3372.03	3374.47	3371.21	3372.57	16829.0
2019-11-21 05:00:00	ES	Futures	3372.57	3381.53	3372.3	3376.37	46817.0
2019-11-21 06:00:00	ES	Futures	3376.37	3378.55	3374.47	3377.46	16360.0
2019-11-21 07:00:00	ES	Futures	3377.19	3378.0	3373.93	3377.19	18801.0
2019-11-21 08:00:00	ES	Futures	3376.92	3383.98	3375.83	3378.55	59547.0
2019-11-21 09:00:00	ES	Futures	3378.82	3380.18	3368.5	3371.21	165609.0
2019-11-21 10:00:00	ES	Futures	3370.94	3373.93	3361.16	3368.77	259459.0
2019-11-21 11:00:00	ES	Futures	3368.5	3372.3	3364.96	3365.78	133612.0
2019-11-21 12:00:00	ES	Futures	3365.78	3374.74	3365.24	3373.39	84529.0
2019-11-21 13:00:00	ES	Futures	3373.39	3374.74	3371.21	3372.03	49962.0
2019-11-21 14:00:00	ES	Futures	3372.03	3376.92	3369.31	3375.29	74797.0
2019-11-21 15:00:00	ES	Futures	3375.56	3376.1	3366.59	3371.21	167624.0
2019-11-21 16:00:00	ES	Futures	3371.21	3374.2	3369.31	3372.3	43574.0
2019-11-21 18:00:00	ES	Futures	3372.57	3373.39	3369.58	3369.58	6274.0
2019-11-21 19:00:00	ES	Futures	3369.85	3375.56	3368.77	3373.66	10038.0
2019-11-21 20:00:00	ES	Futures	3373.93	3378.55	3373.66	3378.27	13026.0
2019-11-21 21:00:00	ES	Futures	3378.27	3378.27	3376.1	3376.64	5496.0
2019-11-21 22:00:00	ES	Futures	3376.64	3377.73	3375.29	3376.64	4722.0
2019-11-21 23:00:00	ES	Futures	3376.64	3376.92	3375.29	3376.92	2787.0
2019-11-21 00:00:00	NQ	Futures	9606.58	9621.98	9602.8	9616.17	3093.0
2019-11-21 01:00:00	NQ	Futures	9616.46	9622.85	9613.84	9616.75	2378.0
2019-11-21 02:00:00	NQ	Futures	9616.46	9631.56	9599.32	9608.32	8257.0
2019-11-21 03:00:00	NQ	Futures	9608.03	9615.59	9594.38	9611.81	10393.0
2019-11-21 04:00:00	NQ	Futures	9612.1	9619.07	9607.74	9612.97	6282.0
2019-11-21 05:00:00	NQ	Futures	9613.26	9643.47	9612.39	9626.33	13526.0
2019-11-21 06:00:00	NQ	Futures	9626.92	9633.6	9617.62	9630.11	5320.0
2019-11-21 07:00:00	NQ	Futures	9629.53	9630.98	9616.75	9626.33	5292.0
2019-11-21 08:00:00	NQ	Futures	9626.04	9653.64	9620.81	9633.02	16762.0
2019-11-21 09:00:00	NQ	Futures	9633.31	9637.95	9599.03	9612.97	56395.0
2019-11-21 10:00:00	NQ	Futures	9613.26	9629.82	9583.92	9605.13	72009.0
2019-11-21 11:00:00	NQ	Futures	9604.84	9619.65	9584.79	9586.25	43130.0
2019-11-21 12:00:00	NQ	Futures	9585.96	9611.52	9582.47	9609.49	27019.0
2019-11-21 13:00:00	NQ	Futures	9610.07	9615.88	9605.13	9608.32	17342.0
2019-11-21 14:00:00	NQ	Futures	9608.9	9631.56	9597.28	9625.17	25347.0
2019-11-21 15:00:00	NQ	Futures	9625.46	9626.92	9595.54	9612.39	36069.0
2019-11-21 16:00:00	NQ	Futures	9612.39	9619.65	9603.97	9619.36	7902.0
2019-11-21 18:00:00	NQ	Futures	9621.4	9622.85	9608.61	9609.78	2474.0
2019-11-21 19:00:00	NQ	Futures	9609.78	9628.66	9604.84	9624.88	4823.0
2019-11-21 20:00:00	NQ	Futures	9625.17	9643.76	9625.17	9642.6	8090.0
2019-11-21 21:00:00	NQ	Futures	9642.89	9644.34	9636.79	9638.53	3353.0
2019-11-21 22:00:00	NQ	Futures	9638.53	9639.99	9634.18	9636.79	2773.0
2019-11-21 23:00:00	NQ	Futures	9636.79	9637.37	9633.89	9636.21	1295.0
2019-11-21 00:00:00	YM	Futures	30184.4	30225.7	30178.9	30209.4	1520.0
2019-11-21 01:00:00	YM	Futures	30210.5	30224.6	30201.8	30210.5	1091.0
2019-11-21 02:00:00	YM	Futures	30211.6	30251.8	30180.0	30193.1	5118.0
2019-11-21 03:00:00	YM	Futures	30194.2	30209.4	30155.0	30205.0	5384.0

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

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