PREVIEW / futures_1hour / 2019-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-10.parquet
  size:    53 KB
  rows:    1,659

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-09-10 00:00:00	ES	Futures	3223.29	3224.1	3221.39	3221.66	4255.0
2019-09-10 01:00:00	ES	Futures	3221.93	3221.93	3219.5	3221.39	6715.0
2019-09-10 02:00:00	ES	Futures	3221.66	3221.93	3218.14	3221.39	10609.0
2019-09-10 03:00:00	ES	Futures	3221.39	3224.1	3213.27	3215.71	33788.0
2019-09-10 04:00:00	ES	Futures	3215.71	3216.25	3211.1	3214.62	25725.0
2019-09-10 05:00:00	ES	Futures	3214.35	3220.31	3214.08	3218.95	25559.0
2019-09-10 06:00:00	ES	Futures	3218.95	3221.66	3217.87	3218.41	16861.0
2019-09-10 07:00:00	ES	Futures	3218.14	3225.18	3217.33	3219.22	29302.0
2019-09-10 08:00:00	ES	Futures	3219.22	3221.39	3217.33	3217.87	24751.0
2019-09-10 09:00:00	ES	Futures	3217.6	3218.95	3202.98	3205.96	249282.0
2019-09-10 10:00:00	ES	Futures	3205.96	3211.64	3202.17	3205.15	215388.0
2019-09-10 11:00:00	ES	Futures	3205.42	3216.52	3203.25	3212.46	181538.0
2019-09-10 12:00:00	ES	Futures	3212.19	3221.93	3207.04	3220.04	121824.0
2019-09-10 13:00:00	ES	Futures	3219.77	3220.58	3212.73	3215.16	82569.0
2019-09-10 14:00:00	ES	Futures	3215.16	3216.52	3208.13	3211.37	93498.0
2019-09-10 15:00:00	ES	Futures	3211.1	3226.53	3209.75	3226.26	166293.0
2019-09-10 16:00:00	ES	Futures	3226.26	3227.62	3223.29	3226.26	71865.0
2019-09-10 18:00:00	ES	Futures	3225.72	3226.26	3222.47	3222.47	5673.0
2019-09-10 19:00:00	ES	Futures	3222.47	3225.45	3222.2	3223.83	4017.0
2019-09-10 20:00:00	ES	Futures	3224.1	3224.1	3220.58	3221.93	10073.0
2019-09-10 21:00:00	ES	Futures	3221.66	3222.74	3218.41	3218.41	11105.0
2019-09-10 22:00:00	ES	Futures	3218.41	3223.29	3218.14	3222.74	7069.0
2019-09-10 23:00:00	ES	Futures	3222.47	3227.35	3222.47	3225.45	9045.0
2019-09-10 00:00:00	NQ	Futures	9083.49	9085.81	9076.82	9077.98	1827.0
2019-09-10 01:00:00	NQ	Futures	9078.56	9079.72	9066.66	9073.91	3685.0
2019-09-10 02:00:00	NQ	Futures	9073.91	9076.82	9059.7	9073.91	4356.0
2019-09-10 03:00:00	NQ	Futures	9073.91	9084.94	9041.13	9049.54	12876.0
2019-09-10 04:00:00	NQ	Futures	9049.83	9052.44	9031.26	9045.48	10340.0
2019-09-10 05:00:00	NQ	Futures	9046.35	9068.4	9044.9	9061.15	7178.0
2019-09-10 06:00:00	NQ	Futures	9061.15	9073.33	9057.67	9059.7	5332.0
2019-09-10 07:00:00	NQ	Futures	9059.7	9085.23	9050.99	9060.57	11236.0
2019-09-10 08:00:00	NQ	Futures	9060.28	9069.27	9054.18	9055.64	8163.0
2019-09-10 09:00:00	NQ	Futures	9055.64	9059.7	8987.74	9008.63	76696.0
2019-09-10 10:00:00	NQ	Futures	9008.63	9037.65	8994.42	9009.21	68135.0
2019-09-10 11:00:00	NQ	Futures	9009.21	9044.9	8996.16	9031.84	52848.0
2019-09-10 12:00:00	NQ	Futures	9031.55	9066.95	9016.18	9057.38	40771.0
2019-09-10 13:00:00	NQ	Futures	9057.38	9059.12	9026.62	9031.84	30256.0
2019-09-10 14:00:00	NQ	Futures	9031.55	9038.23	9006.6	9020.82	32628.0
2019-09-10 15:00:00	NQ	Futures	9020.53	9074.79	9014.15	9074.2	37569.0
2019-09-10 16:00:00	NQ	Futures	9073.91	9076.53	9065.21	9075.08	11526.0
2019-09-10 18:00:00	NQ	Futures	9073.91	9075.08	9059.7	9059.7	2055.0
2019-09-10 19:00:00	NQ	Futures	9059.99	9068.98	9057.67	9064.63	1846.0
2019-09-10 20:00:00	NQ	Futures	9064.34	9065.5	9048.09	9053.6	4064.0
2019-09-10 21:00:00	NQ	Futures	9053.6	9058.54	9036.78	9037.36	4420.0
2019-09-10 22:00:00	NQ	Futures	9037.36	9057.96	9037.07	9053.89	3465.0
2019-09-10 23:00:00	NQ	Futures	9053.89	9073.62	9052.44	9066.95	4231.0
2019-09-10 00:00:00	YM	Futures	29174.4	29178.7	29160.2	29165.7	14.0
2019-09-10 01:00:00	YM	Futures	29164.6	29164.6	29145.0	29157.0	11.0
2019-09-10 02:00:00	YM	Futures	29167.8	29167.8	29143.9	29163.5	8.0
2019-09-10 03:00:00	YM	Futures	29163.5	29183.1	29096.0	29113.4	188.0

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

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