PREVIEW / futures_1hour / 2019-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-06.parquet
  size:    49 KB
  rows:    1,476

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-06 00:00:00	ES	Futures	3225.18	3226.8	3223.01	3223.83	5938.0
2019-09-06 01:00:00	ES	Futures	3223.83	3224.1	3221.93	3223.29	5949.0
2019-09-06 02:00:00	ES	Futures	3223.56	3227.08	3220.58	3227.08	14303.0
2019-09-06 03:00:00	ES	Futures	3227.08	3230.86	3224.37	3226.53	18676.0
2019-09-06 04:00:00	ES	Futures	3226.26	3226.26	3224.1	3225.72	12302.0
2019-09-06 05:00:00	ES	Futures	3225.45	3233.03	3224.91	3225.18	33700.0
2019-09-06 06:00:00	ES	Futures	3225.18	3228.16	3223.56	3227.35	14555.0
2019-09-06 07:00:00	ES	Futures	3227.35	3231.95	3226.8	3231.41	23743.0
2019-09-06 08:00:00	ES	Futures	3231.14	3235.74	3223.83	3228.16	74480.0
2019-09-06 09:00:00	ES	Futures	3228.16	3230.86	3218.41	3224.37	191592.0
2019-09-06 10:00:00	ES	Futures	3224.37	3231.41	3221.93	3229.24	155331.0
2019-09-06 11:00:00	ES	Futures	3229.24	3230.32	3225.99	3227.35	84386.0
2019-09-06 12:00:00	ES	Futures	3227.08	3229.51	3222.2	3227.08	79717.0
2019-09-06 13:00:00	ES	Futures	3226.8	3233.03	3226.53	3231.41	69160.0
2019-09-06 14:00:00	ES	Futures	3231.68	3231.95	3228.16	3228.97	52420.0
2019-09-06 15:00:00	ES	Futures	3228.97	3232.49	3223.29	3225.45	167777.0
2019-09-06 16:00:00	ES	Futures	3225.72	3230.32	3224.64	3230.05	49551.0
2019-09-06 00:00:00	NQ	Futures	9134.55	9139.78	9123.53	9125.27	4406.0
2019-09-06 01:00:00	NQ	Futures	9124.98	9126.72	9118.31	9124.4	2762.0
2019-09-06 02:00:00	NQ	Futures	9124.69	9137.46	9114.82	9136.59	5831.0
2019-09-06 03:00:00	NQ	Futures	9136.59	9148.77	9125.56	9135.42	8359.0
2019-09-06 04:00:00	NQ	Futures	9135.13	9137.75	9128.75	9134.55	4412.0
2019-09-06 05:00:00	NQ	Futures	9134.26	9159.8	9126.14	9126.14	11684.0
2019-09-06 06:00:00	NQ	Futures	9126.14	9136.88	9121.21	9135.13	5876.0
2019-09-06 07:00:00	NQ	Futures	9134.26	9149.35	9133.39	9146.45	7795.0
2019-09-06 08:00:00	NQ	Futures	9146.16	9162.7	9122.08	9133.39	22760.0
2019-09-06 09:00:00	NQ	Futures	9133.97	9145.87	9099.45	9111.05	59156.0
2019-09-06 10:00:00	NQ	Futures	9111.05	9141.52	9102.93	9133.39	46739.0
2019-09-06 11:00:00	NQ	Futures	9133.39	9138.91	9118.02	9120.63	27910.0
2019-09-06 12:00:00	NQ	Futures	9120.63	9126.72	9096.84	9120.05	25840.0
2019-09-06 13:00:00	NQ	Futures	9119.76	9142.39	9117.44	9139.2	25830.0
2019-09-06 14:00:00	NQ	Futures	9139.2	9140.65	9131.94	9135.42	18271.0
2019-09-06 15:00:00	NQ	Futures	9135.13	9144.42	9111.05	9117.44	38126.0
2019-09-06 16:00:00	NQ	Futures	9117.73	9129.33	9115.4	9127.88	6802.0
2019-09-06 00:00:00	YM	Futures	29116.7	29125.4	29096.1	29098.2	1221.0
2019-09-06 01:00:00	YM	Futures	29098.2	29098.2	29078.7	29091.7	1409.0
2019-09-06 02:00:00	YM	Futures	29092.8	29128.7	29066.7	29125.4	2920.0
2019-09-06 03:00:00	YM	Futures	29126.5	29158.1	29102.6	29111.3	4552.0
2019-09-06 04:00:00	YM	Futures	29112.4	29114.6	29090.6	29104.8	2999.0
2019-09-06 05:00:00	YM	Futures	29104.8	29171.1	29098.2	29110.2	5637.0
2019-09-06 06:00:00	YM	Futures	29109.1	29137.4	29092.8	29126.5	2618.0
2019-09-06 07:00:00	YM	Futures	29126.5	29165.7	29124.3	29159.1	2941.0
2019-09-06 08:00:00	YM	Futures	29159.1	29191.8	29098.2	29124.3	11484.0
2019-09-06 09:00:00	YM	Futures	29126.5	29146.1	29050.4	29108.0	21580.0
2019-09-06 10:00:00	YM	Futures	29108.0	29163.5	29083.0	29155.9	19525.0
2019-09-06 11:00:00	YM	Futures	29155.9	29171.1	29142.8	29157.0	10337.0
2019-09-06 12:00:00	YM	Futures	29157.0	29183.1	29118.9	29157.0	8964.0
2019-09-06 13:00:00	YM	Futures	29158.1	29220.0	29154.8	29200.5	11922.0
2019-09-06 14:00:00	YM	Futures	29201.6	29203.7	29160.2	29167.8	6541.0
2019-09-06 15:00:00	YM	Futures	29167.8	29196.1	29120.0	29143.9	13503.0

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

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