PREVIEW / futures_1hour / 2019-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-02.parquet
  size:    60 KB
  rows:    1,867

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-07-02 00:00:00	ES	Futures	3216.79	3217.87	3215.98	3217.06	4339.0
2019-07-02 01:00:00	ES	Futures	3217.06	3217.6	3213.81	3215.16	5826.0
2019-07-02 02:00:00	ES	Futures	3215.16	3218.14	3214.89	3217.06	7450.0
2019-07-02 03:00:00	ES	Futures	3217.06	3217.6	3210.56	3210.83	21469.0
2019-07-02 04:00:00	ES	Futures	3210.83	3211.1	3206.5	3208.4	18434.0
2019-07-02 05:00:00	ES	Futures	3208.4	3210.56	3207.31	3208.67	15693.0
2019-07-02 06:00:00	ES	Futures	3208.67	3212.73	3208.13	3211.1	11617.0
2019-07-02 07:00:00	ES	Futures	3211.1	3212.73	3208.67	3210.83	11270.0
2019-07-02 08:00:00	ES	Futures	3210.56	3213.0	3209.75	3211.1	17358.0
2019-07-02 09:00:00	ES	Futures	3210.83	3214.62	3208.4	3210.02	134780.0
2019-07-02 10:00:00	ES	Futures	3210.02	3219.5	3209.48	3216.79	154125.0
2019-07-02 11:00:00	ES	Futures	3216.52	3217.6	3207.04	3211.92	143689.0
2019-07-02 12:00:00	ES	Futures	3211.92	3213.0	3203.52	3208.13	129028.0
2019-07-02 13:00:00	ES	Futures	3208.13	3214.35	3205.96	3213.0	74836.0
2019-07-02 14:00:00	ES	Futures	3213.27	3216.79	3211.64	3212.73	67634.0
2019-07-02 15:00:00	ES	Futures	3212.46	3223.56	3211.64	3223.29	161680.0
2019-07-02 16:00:00	ES	Futures	3223.29	3226.8	3220.31	3225.72	58613.0
2019-07-02 18:00:00	ES	Futures	3225.72	3226.53	3223.01	3224.37	5441.0
2019-07-02 19:00:00	ES	Futures	3224.37	3225.72	3223.29	3224.64	4118.0
2019-07-02 20:00:00	ES	Futures	3224.64	3225.18	3222.47	3223.01	9305.0
2019-07-02 21:00:00	ES	Futures	3223.01	3223.29	3220.04	3221.39	11579.0
2019-07-02 22:00:00	ES	Futures	3221.66	3223.83	3220.85	3221.39	7072.0
2019-07-02 23:00:00	ES	Futures	3221.66	3222.74	3221.12	3222.47	3572.0
2019-07-02 00:00:00	NQ	Futures	9046.35	9051.57	9044.61	9048.38	1912.0
2019-07-02 01:00:00	NQ	Futures	9048.09	9050.41	9037.07	9039.68	2022.0
2019-07-02 02:00:00	NQ	Futures	9039.97	9051.57	9039.68	9046.64	2485.0
2019-07-02 03:00:00	NQ	Futures	9046.93	9048.96	9026.33	9026.33	5811.0
2019-07-02 04:00:00	NQ	Futures	9026.33	9028.07	9009.5	9015.89	6294.0
2019-07-02 05:00:00	NQ	Futures	9015.89	9025.75	9012.69	9015.31	4468.0
2019-07-02 06:00:00	NQ	Futures	9015.31	9031.55	9012.11	9026.04	3703.0
2019-07-02 07:00:00	NQ	Futures	9026.04	9030.97	9017.34	9026.04	3702.0
2019-07-02 08:00:00	NQ	Futures	9025.75	9039.39	9024.88	9033.0	5482.0
2019-07-02 09:00:00	NQ	Futures	9032.71	9049.25	9025.75	9037.07	42134.0
2019-07-02 10:00:00	NQ	Futures	9036.49	9062.89	9030.97	9053.6	47040.0
2019-07-02 11:00:00	NQ	Futures	9053.31	9059.12	9025.75	9035.91	35023.0
2019-07-02 12:00:00	NQ	Futures	9035.91	9045.19	9016.76	9027.49	31502.0
2019-07-02 13:00:00	NQ	Futures	9027.2	9048.38	9020.53	9043.74	20422.0
2019-07-02 14:00:00	NQ	Futures	9044.03	9055.64	9040.55	9049.54	17192.0
2019-07-02 15:00:00	NQ	Futures	9049.25	9082.62	9045.77	9081.75	35770.0
2019-07-02 16:00:00	NQ	Futures	9081.75	9102.64	9074.79	9099.16	10296.0
2019-07-02 18:00:00	NQ	Futures	9099.16	9100.03	9090.74	9093.64	2149.0
2019-07-02 19:00:00	NQ	Futures	9093.64	9097.71	9089.0	9093.35	1484.0
2019-07-02 20:00:00	NQ	Futures	9093.35	9097.42	9086.39	9091.32	3157.0
2019-07-02 21:00:00	NQ	Futures	9091.61	9093.93	9080.88	9087.26	4075.0
2019-07-02 22:00:00	NQ	Futures	9086.39	9093.35	9084.07	9085.23	2220.0
2019-07-02 23:00:00	NQ	Futures	9085.52	9090.16	9084.07	9088.13	1103.0
2019-07-02 00:00:00	YM	Futures	29064.5	29075.4	29060.2	29071.1	1295.0
2019-07-02 01:00:00	YM	Futures	29070.0	29075.4	29041.7	29050.4	1599.0
2019-07-02 02:00:00	YM	Futures	29051.5	29075.4	29050.4	29064.5	1686.0
2019-07-02 03:00:00	YM	Futures	29066.7	29072.1	29008.0	29009.1	4877.0

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

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