PREVIEW / futures_1hour / 2018-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-27.parquet
  size:    56 KB
  rows:    1,681

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-02-27 00:00:00	ES	Futures	3039.41	3039.95	3037.49	3038.86	4625.0
2018-02-27 01:00:00	ES	Futures	3039.13	3039.68	3034.49	3037.49	6962.0
2018-02-27 02:00:00	ES	Futures	3037.49	3038.31	3035.31	3037.49	10695.0
2018-02-27 03:00:00	ES	Futures	3037.49	3044.05	3036.13	3037.77	21639.0
2018-02-27 04:00:00	ES	Futures	3037.77	3039.41	3034.49	3036.95	11400.0
2018-02-27 05:00:00	ES	Futures	3037.22	3041.59	3035.85	3038.59	13991.0
2018-02-27 06:00:00	ES	Futures	3038.59	3041.05	3033.39	3034.49	23445.0
2018-02-27 07:00:00	ES	Futures	3034.49	3041.87	3034.49	3040.23	18095.0
2018-02-27 08:00:00	ES	Futures	3040.23	3043.23	3034.49	3040.23	39233.0
2018-02-27 09:00:00	ES	Futures	3040.23	3044.6	3035.31	3036.67	148596.0
2018-02-27 10:00:00	ES	Futures	3036.67	3050.07	3024.37	3028.47	271356.0
2018-02-27 11:00:00	ES	Futures	3028.47	3036.4	3020.82	3021.09	214054.0
2018-02-27 12:00:00	ES	Futures	3021.09	3030.66	3013.99	3030.11	165201.0
2018-02-27 13:00:00	ES	Futures	3030.11	3031.75	3019.73	3021.64	100711.0
2018-02-27 14:00:00	ES	Futures	3021.64	3024.37	3013.17	3017.81	159657.0
2018-02-27 15:00:00	ES	Futures	3017.81	3019.73	2999.5	2999.5	312536.0
2018-02-27 16:00:00	ES	Futures	2999.78	3006.06	2997.86	3003.6	109992.0
2018-02-27 18:00:00	ES	Futures	3002.78	3010.16	3002.51	3009.61	15601.0
2018-02-27 19:00:00	ES	Futures	3009.61	3011.53	3008.79	3009.89	7783.0
2018-02-27 20:00:00	ES	Futures	3010.16	3010.98	3003.33	3005.51	9902.0
2018-02-27 21:00:00	ES	Futures	3005.51	3006.06	3003.33	3003.87	3711.0
2018-02-27 22:00:00	ES	Futures	3004.42	3004.42	2994.04	2998.14	14956.0
2018-02-27 23:00:00	ES	Futures	2998.14	3001.14	2995.68	2999.78	3663.0
2018-02-27 00:00:00	NQ	Futures	8299.0	8300.19	8289.51	8293.37	2032.0
2018-02-27 01:00:00	NQ	Futures	8293.67	8294.26	8283.88	8293.07	2239.0
2018-02-27 02:00:00	NQ	Futures	8293.07	8294.85	8284.17	8290.7	3072.0
2018-02-27 03:00:00	NQ	Futures	8290.7	8305.83	8283.58	8288.33	6198.0
2018-02-27 04:00:00	NQ	Futures	8287.73	8291.0	8278.84	8287.14	3815.0
2018-02-27 05:00:00	NQ	Futures	8288.03	8300.78	8285.95	8293.07	2905.0
2018-02-27 06:00:00	NQ	Futures	8293.67	8298.11	8277.65	8280.32	5289.0
2018-02-27 07:00:00	NQ	Futures	8280.61	8296.63	8280.32	8291.0	4156.0
2018-02-27 08:00:00	NQ	Futures	8291.59	8304.34	8281.21	8298.71	14353.0
2018-02-27 09:00:00	NQ	Futures	8299.3	8305.23	8265.49	8270.83	48223.0
2018-02-27 10:00:00	NQ	Futures	8270.83	8314.72	8243.54	8252.44	85307.0
2018-02-27 11:00:00	NQ	Futures	8252.44	8272.01	8226.63	8228.41	78550.0
2018-02-27 12:00:00	NQ	Futures	8228.41	8255.7	8200.53	8253.92	55742.0
2018-02-27 13:00:00	NQ	Futures	8253.62	8260.45	8231.97	8238.5	35816.0
2018-02-27 14:00:00	NQ	Futures	8238.5	8251.25	8220.11	8234.05	47758.0
2018-02-27 15:00:00	NQ	Futures	8233.75	8240.28	8191.93	8191.93	71472.0
2018-02-27 16:00:00	NQ	Futures	8192.23	8209.14	8190.75	8202.31	14271.0
2018-02-27 18:00:00	NQ	Futures	8202.31	8219.81	8202.02	8218.03	3019.0
2018-02-27 19:00:00	NQ	Futures	8218.03	8224.56	8216.25	8219.52	3030.0
2018-02-27 20:00:00	NQ	Futures	8219.81	8222.48	8203.2	8210.32	4535.0
2018-02-27 21:00:00	NQ	Futures	8210.03	8213.88	8203.8	8207.65	2082.0
2018-02-27 22:00:00	NQ	Futures	8207.65	8207.95	8177.99	8189.86	7696.0
2018-02-27 23:00:00	NQ	Futures	8190.15	8197.87	8185.11	8194.31	2071.0
2018-02-27 00:00:00	YM	Futures	27985.0	27986.1	27953.5	27967.6	2105.0
2018-02-27 01:00:00	YM	Futures	27968.7	27980.6	27916.5	27939.3	3153.0
2018-02-27 02:00:00	YM	Futures	27940.4	27961.1	27924.1	27951.3	3712.0
2018-02-27 03:00:00	YM	Futures	27952.4	28013.3	27941.5	27958.9	5921.0

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

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