PREVIEW / futures_1hour / 2019-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-03.parquet
  size:    48 KB
  rows:    1,418

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-05-03 00:00:00	ES	Futures	3169.46	3170.27	3168.91	3170.0	2281.0
2019-05-03 01:00:00	ES	Futures	3170.27	3171.35	3170.0	3170.27	3454.0
2019-05-03 02:00:00	ES	Futures	3170.27	3170.54	3168.37	3168.91	4425.0
2019-05-03 03:00:00	ES	Futures	3168.91	3172.98	3168.64	3172.71	12034.0
2019-05-03 04:00:00	ES	Futures	3172.44	3175.69	3172.44	3174.34	12410.0
2019-05-03 05:00:00	ES	Futures	3174.34	3175.69	3171.9	3171.9	8859.0
2019-05-03 06:00:00	ES	Futures	3172.17	3173.52	3171.35	3171.9	8830.0
2019-05-03 07:00:00	ES	Futures	3171.9	3174.88	3171.63	3174.88	12485.0
2019-05-03 08:00:00	ES	Futures	3174.88	3181.66	3169.73	3180.57	90634.0
2019-05-03 09:00:00	ES	Futures	3180.57	3185.18	3177.86	3183.83	201891.0
2019-05-03 10:00:00	ES	Futures	3183.83	3187.62	3178.95	3187.35	213252.0
2019-05-03 11:00:00	ES	Futures	3187.62	3191.14	3185.45	3189.52	133867.0
2019-05-03 12:00:00	ES	Futures	3189.79	3194.67	3189.25	3193.31	103474.0
2019-05-03 13:00:00	ES	Futures	3193.31	3197.92	3192.23	3196.3	96125.0
2019-05-03 14:00:00	ES	Futures	3196.3	3196.57	3193.31	3194.13	63360.0
2019-05-03 15:00:00	ES	Futures	3194.13	3196.57	3191.69	3194.4	169528.0
2019-05-03 16:00:00	ES	Futures	3194.4	3198.46	3193.58	3198.19	64072.0
2019-05-03 00:00:00	NQ	Futures	9039.23	9044.18	9038.36	9043.6	1427.0
2019-05-03 01:00:00	NQ	Futures	9043.6	9048.55	9042.72	9043.89	1878.0
2019-05-03 02:00:00	NQ	Futures	9043.89	9044.47	9035.74	9037.77	2605.0
2019-05-03 03:00:00	NQ	Futures	9037.77	9051.75	9036.9	9051.17	3713.0
2019-05-03 04:00:00	NQ	Futures	9050.88	9059.61	9050.88	9053.5	4554.0
2019-05-03 05:00:00	NQ	Futures	9053.21	9058.74	9048.55	9048.84	3395.0
2019-05-03 06:00:00	NQ	Futures	9048.84	9058.74	9046.8	9052.33	3559.0
2019-05-03 07:00:00	NQ	Futures	9052.33	9064.56	9050.59	9063.69	5538.0
2019-05-03 08:00:00	NQ	Futures	9063.98	9081.74	9041.56	9079.41	28271.0
2019-05-03 09:00:00	NQ	Futures	9078.83	9094.84	9063.69	9092.22	68840.0
2019-05-03 10:00:00	NQ	Futures	9091.64	9124.25	9082.32	9122.79	80701.0
2019-05-03 11:00:00	NQ	Futures	9123.08	9135.89	9111.44	9119.88	59724.0
2019-05-03 12:00:00	NQ	Futures	9119.59	9139.1	9114.06	9131.53	36749.0
2019-05-03 13:00:00	NQ	Futures	9131.53	9158.31	9128.62	9149.87	38132.0
2019-05-03 14:00:00	NQ	Futures	9149.87	9151.62	9137.93	9140.26	27184.0
2019-05-03 15:00:00	NQ	Futures	9139.97	9156.57	9130.94	9150.45	49040.0
2019-05-03 16:00:00	NQ	Futures	9150.16	9168.5	9148.71	9168.5	15679.0
2019-05-03 00:00:00	YM	Futures	28604.6	28607.8	28591.5	28602.4	635.0
2019-05-03 01:00:00	YM	Futures	28602.4	28614.3	28600.2	28607.8	822.0
2019-05-03 02:00:00	YM	Futures	28607.8	28611.1	28587.2	28590.4	1287.0
2019-05-03 03:00:00	YM	Futures	28590.4	28632.8	28588.2	28631.8	2103.0
2019-05-03 04:00:00	YM	Futures	28631.8	28658.9	28631.8	28650.2	2868.0
2019-05-03 05:00:00	YM	Futures	28650.2	28657.9	28625.2	28625.2	2076.0
2019-05-03 06:00:00	YM	Futures	28625.2	28641.5	28616.5	28627.4	2003.0
2019-05-03 07:00:00	YM	Futures	28628.5	28655.7	28627.4	28653.5	1940.0
2019-05-03 08:00:00	YM	Futures	28654.6	28731.8	28624.1	28719.9	13368.0
2019-05-03 09:00:00	YM	Futures	28718.8	28767.7	28694.8	28727.5	24371.0
2019-05-03 10:00:00	YM	Futures	28725.3	28741.6	28647.0	28719.9	27790.0
2019-05-03 11:00:00	YM	Futures	28719.9	28766.6	28684.0	28760.1	22126.0
2019-05-03 12:00:00	YM	Futures	28760.1	28824.3	28756.8	28796.0	19538.0
2019-05-03 13:00:00	YM	Futures	28796.0	28834.1	28785.1	28817.7	11410.0
2019-05-03 14:00:00	YM	Futures	28816.7	28821.0	28791.6	28812.3	8403.0
2019-05-03 15:00:00	YM	Futures	28812.3	28817.7	28787.3	28797.1	15625.0

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

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