PREVIEW / futures_1hour / 2018-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-05.parquet
  size:    49 KB
  rows:    1,506

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
2018-12-05 00:00:00	ES	Futures	2951.18	2952.54	2947.64	2950.91	5726.0
2018-12-05 01:00:00	ES	Futures	2950.91	2951.45	2946.56	2950.91	4657.0
2018-12-05 02:00:00	ES	Futures	2950.91	2953.63	2948.46	2952.54	11527.0
2018-12-05 03:00:00	ES	Futures	2952.54	2955.8	2945.47	2954.17	24047.0
2018-12-05 04:00:00	ES	Futures	2954.44	2956.89	2951.18	2953.9	14064.0
2018-12-05 05:00:00	ES	Futures	2953.9	2957.71	2953.08	2957.44	13859.0
2018-12-05 06:00:00	ES	Futures	2957.44	2957.98	2951.72	2954.72	11515.0
2018-12-05 07:00:00	ES	Futures	2954.72	2956.35	2951.72	2955.8	10376.0
2018-12-05 08:00:00	ES	Futures	2955.8	2960.16	2954.99	2957.16	16263.0
2018-12-05 09:00:00	ES	Futures	2956.89	2958.25	2954.44	2957.16	10781.0
2018-12-05 18:00:00	ES	Futures	2952.0	2952.81	2882.91	2920.17	61116.0
2018-12-05 19:00:00	ES	Futures	2920.44	2923.44	2915.82	2916.91	17121.0
2018-12-05 20:00:00	ES	Futures	2917.18	2917.45	2895.97	2909.02	35589.0
2018-12-05 21:00:00	ES	Futures	2908.75	2910.38	2904.94	2905.48	13802.0
2018-12-05 22:00:00	ES	Futures	2905.48	2905.76	2895.15	2903.85	24564.0
2018-12-05 23:00:00	ES	Futures	2903.85	2907.39	2896.51	2902.76	18882.0
2018-12-05 00:00:00	NQ	Futures	8021.26	8025.66	8011.0	8024.78	3232.0
2018-12-05 01:00:00	NQ	Futures	8024.49	8025.37	8012.17	8023.61	1800.0
2018-12-05 02:00:00	NQ	Futures	8023.61	8035.05	8018.04	8033.58	4887.0
2018-12-05 03:00:00	NQ	Futures	8032.99	8042.67	8010.12	8038.86	8850.0
2018-12-05 04:00:00	NQ	Futures	8039.15	8043.85	8020.97	8027.71	4557.0
2018-12-05 05:00:00	NQ	Futures	8028.01	8039.74	8027.42	8039.45	3775.0
2018-12-05 06:00:00	NQ	Futures	8039.74	8040.62	8019.5	8030.35	3657.0
2018-12-05 07:00:00	NQ	Futures	8030.65	8036.22	8020.38	8032.7	2820.0
2018-12-05 08:00:00	NQ	Futures	8032.11	8050.59	8029.77	8039.74	6252.0
2018-12-05 09:00:00	NQ	Futures	8039.45	8040.33	8034.17	8034.75	2937.0
2018-12-05 18:00:00	NQ	Futures	8018.62	8022.73	7791.6	7915.08	15967.0
2018-12-05 19:00:00	NQ	Futures	7915.08	7926.52	7905.99	7908.04	12287.0
2018-12-05 20:00:00	NQ	Futures	7908.34	7908.34	7838.82	7878.71	17284.0
2018-12-05 21:00:00	NQ	Futures	7878.42	7882.52	7861.99	7864.63	6047.0
2018-12-05 22:00:00	NQ	Futures	7864.34	7864.34	7824.45	7853.49	11057.0
2018-12-05 23:00:00	NQ	Futures	7853.19	7867.86	7839.41	7854.66	15103.0
2018-12-05 00:00:00	YM	Futures	27281.2	27304.1	27254.1	27283.4	1962.0
2018-12-05 01:00:00	YM	Futures	27282.3	27288.8	27246.5	27283.4	1692.0
2018-12-05 02:00:00	YM	Futures	27284.5	27317.1	27255.2	27297.5	4861.0
2018-12-05 03:00:00	YM	Futures	27296.5	27323.6	27234.5	27310.6	5355.0
2018-12-05 04:00:00	YM	Futures	27311.7	27338.8	27283.4	27314.9	4449.0
2018-12-05 05:00:00	YM	Futures	27312.7	27351.9	27293.2	27336.7	3390.0
2018-12-05 06:00:00	YM	Futures	27337.7	27338.8	27289.9	27309.5	1802.0
2018-12-05 07:00:00	YM	Futures	27310.6	27322.5	27285.6	27320.4	1445.0
2018-12-05 08:00:00	YM	Futures	27321.4	27369.2	27316.0	27321.4	3331.0
2018-12-05 09:00:00	YM	Futures	27323.6	27348.6	27317.1	27332.3	1202.0
2018-12-05 18:00:00	YM	Futures	27307.3	27316.0	26686.9	27005.3	9057.0
2018-12-05 19:00:00	YM	Futures	27004.2	27034.6	26958.5	26972.7	4988.0
2018-12-05 20:00:00	YM	Futures	26973.8	26973.8	26780.4	26895.5	8516.0
2018-12-05 21:00:00	YM	Futures	26892.3	26907.5	26864.0	26880.3	3754.0
2018-12-05 22:00:00	YM	Futures	26879.2	26880.3	26786.9	26858.6	5827.0
2018-12-05 23:00:00	YM	Futures	26857.5	26886.8	26793.4	26851.0	4377.0
2018-12-05 00:00:00	CL	Futures	47.97	48.09	47.95	48.08	6516.0
2018-12-05 01:00:00	CL	Futures	48.08	48.23	48.0	48.11	11496.0

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

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