PREVIEW / futures_1hour / 2019-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-16.parquet
  size:    51 KB
  rows:    1,500

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-08-16 00:00:00	ES	Futures	3104.45	3104.72	3098.76	3099.84	10892.0
2019-08-16 01:00:00	ES	Futures	3099.84	3107.15	3098.49	3106.34	13619.0
2019-08-16 02:00:00	ES	Futures	3106.34	3106.61	3099.84	3099.84	16253.0
2019-08-16 03:00:00	ES	Futures	3099.84	3107.69	3098.49	3104.18	45116.0
2019-08-16 04:00:00	ES	Futures	3104.18	3115.82	3103.9	3113.92	40018.0
2019-08-16 05:00:00	ES	Futures	3113.92	3116.9	3109.59	3113.38	36254.0
2019-08-16 06:00:00	ES	Futures	3113.38	3116.63	3111.21	3115.0	24784.0
2019-08-16 07:00:00	ES	Futures	3115.0	3116.9	3109.86	3110.94	31980.0
2019-08-16 08:00:00	ES	Futures	3110.67	3114.19	3109.05	3110.94	41310.0
2019-08-16 09:00:00	ES	Futures	3110.94	3113.11	3099.57	3108.24	206122.0
2019-08-16 10:00:00	ES	Futures	3107.96	3130.97	3106.61	3130.7	299821.0
2019-08-16 11:00:00	ES	Futures	3130.7	3131.79	3122.04	3126.91	184018.0
2019-08-16 12:00:00	ES	Futures	3127.18	3129.08	3121.77	3127.46	92275.0
2019-08-16 13:00:00	ES	Futures	3127.46	3132.33	3127.18	3129.35	72658.0
2019-08-16 14:00:00	ES	Futures	3129.62	3129.89	3123.67	3127.18	60171.0
2019-08-16 15:00:00	ES	Futures	3127.18	3134.49	3124.21	3129.35	208178.0
2019-08-16 16:00:00	ES	Futures	3129.08	3133.41	3126.64	3130.97	76489.0
2019-08-16 00:00:00	NQ	Futures	8766.36	8766.65	8748.08	8750.99	4171.0
2019-08-16 01:00:00	NQ	Futures	8750.41	8779.42	8747.21	8776.23	5090.0
2019-08-16 02:00:00	NQ	Futures	8775.94	8778.84	8755.92	8756.5	7005.0
2019-08-16 03:00:00	NQ	Futures	8756.5	8785.22	8751.28	8775.36	10843.0
2019-08-16 04:00:00	NQ	Futures	8775.07	8816.56	8772.17	8809.88	13303.0
2019-08-16 05:00:00	NQ	Futures	8809.59	8821.2	8791.61	8805.24	13511.0
2019-08-16 06:00:00	NQ	Futures	8805.53	8819.17	8799.44	8814.24	8105.0
2019-08-16 07:00:00	NQ	Futures	8813.95	8817.43	8784.93	8787.83	8796.0
2019-08-16 08:00:00	NQ	Futures	8787.54	8802.34	8780.87	8791.32	14258.0
2019-08-16 09:00:00	NQ	Futures	8791.61	8800.02	8757.08	8786.09	61903.0
2019-08-16 10:00:00	NQ	Futures	8785.51	8853.7	8777.1	8852.25	85342.0
2019-08-16 11:00:00	NQ	Futures	8852.25	8858.05	8814.53	8829.03	57560.0
2019-08-16 12:00:00	NQ	Futures	8829.03	8841.8	8812.5	8833.97	27168.0
2019-08-16 13:00:00	NQ	Futures	8833.97	8850.21	8833.1	8844.12	21295.0
2019-08-16 14:00:00	NQ	Futures	8844.41	8844.99	8824.1	8834.26	18773.0
2019-08-16 15:00:00	NQ	Futures	8834.26	8851.67	8827.29	8834.84	46196.0
2019-08-16 16:00:00	NQ	Futures	8834.55	8841.8	8822.65	8832.52	12215.0
2019-08-16 00:00:00	YM	Futures	27983.6	27985.7	27939.0	27947.7	2821.0
2019-08-16 01:00:00	YM	Futures	27946.6	28012.9	27937.9	28005.3	3280.0
2019-08-16 02:00:00	YM	Futures	28005.3	28006.4	27943.3	27943.3	3405.0
2019-08-16 03:00:00	YM	Futures	27942.2	28007.5	27929.2	27978.1	5554.0
2019-08-16 04:00:00	YM	Futures	27977.0	28086.9	27972.7	28074.9	6383.0
2019-08-16 05:00:00	YM	Futures	28073.8	28101.0	28041.2	28072.7	5826.0
2019-08-16 06:00:00	YM	Futures	28071.6	28093.4	28049.9	28084.7	4529.0
2019-08-16 07:00:00	YM	Futures	28083.6	28096.7	28043.4	28053.2	4318.0
2019-08-16 08:00:00	YM	Futures	28053.2	28083.6	28028.1	28045.5	5954.0
2019-08-16 09:00:00	YM	Futures	28046.6	28056.4	27930.3	27959.6	23662.0
2019-08-16 10:00:00	YM	Futures	27958.5	28173.9	27935.7	28170.6	35782.0
2019-08-16 11:00:00	YM	Futures	28170.6	28180.4	28076.0	28122.8	19861.0
2019-08-16 12:00:00	YM	Futures	28122.8	28135.8	28061.9	28113.0	11872.0
2019-08-16 13:00:00	YM	Futures	28111.9	28158.6	28109.7	28133.6	9066.0
2019-08-16 14:00:00	YM	Futures	28133.6	28136.9	28069.5	28097.7	9313.0
2019-08-16 15:00:00	YM	Futures	28096.7	28195.6	28080.3	28148.9	20688.0

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

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