PREVIEW / futures_1hour / 2018-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-27.parquet
  size:    54 KB
  rows:    1,702

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-11-27 00:00:00	ES	Futures	2903.58	2904.4	2897.87	2899.77	6160.0
2018-11-27 01:00:00	ES	Futures	2899.77	2901.13	2897.6	2899.77	4224.0
2018-11-27 02:00:00	ES	Futures	2899.77	2920.44	2895.42	2902.49	49986.0
2018-11-27 03:00:00	ES	Futures	2902.49	2905.48	2894.33	2901.68	22210.0
2018-11-27 04:00:00	ES	Futures	2901.4	2909.56	2900.32	2902.22	18253.0
2018-11-27 05:00:00	ES	Futures	2902.22	2904.4	2897.87	2899.23	14051.0
2018-11-27 06:00:00	ES	Futures	2899.23	2899.5	2893.52	2898.96	22061.0
2018-11-27 07:00:00	ES	Futures	2899.23	2899.23	2891.07	2891.89	18492.0
2018-11-27 08:00:00	ES	Futures	2891.89	2895.69	2888.89	2893.52	31949.0
2018-11-27 09:00:00	ES	Futures	2893.79	2903.04	2888.89	2899.5	211677.0
2018-11-27 10:00:00	ES	Futures	2899.23	2913.1	2894.33	2908.75	246876.0
2018-11-27 11:00:00	ES	Futures	2908.75	2915.0	2903.85	2910.92	150810.0
2018-11-27 12:00:00	ES	Futures	2910.65	2911.74	2898.41	2901.95	125236.0
2018-11-27 13:00:00	ES	Futures	2902.22	2912.01	2898.68	2912.01	148516.0
2018-11-27 14:00:00	ES	Futures	2912.01	2916.91	2910.38	2912.56	106494.0
2018-11-27 15:00:00	ES	Futures	2912.83	2919.08	2909.84	2918.54	162361.0
2018-11-27 16:00:00	ES	Futures	2918.54	2923.16	2916.64	2922.35	55354.0
2018-11-27 18:00:00	ES	Futures	2922.62	2925.34	2920.99	2922.08	5526.0
2018-11-27 19:00:00	ES	Futures	2921.8	2924.52	2920.99	2922.08	7595.0
2018-11-27 20:00:00	ES	Futures	2921.8	2922.35	2917.18	2917.72	10261.0
2018-11-27 21:00:00	ES	Futures	2918.0	2922.35	2916.91	2922.08	7285.0
2018-11-27 22:00:00	ES	Futures	2922.08	2922.35	2920.17	2920.99	4439.0
2018-11-27 23:00:00	ES	Futures	2921.26	2924.52	2920.99	2922.35	4322.0
2018-11-27 00:00:00	NQ	Futures	7821.22	7821.22	7796.0	7803.62	3279.0
2018-11-27 01:00:00	NQ	Futures	7803.62	7807.44	7791.01	7802.45	2734.0
2018-11-27 02:00:00	NQ	Futures	7802.45	7875.48	7788.66	7810.66	17091.0
2018-11-27 03:00:00	NQ	Futures	7811.25	7821.81	7781.62	7811.54	13309.0
2018-11-27 04:00:00	NQ	Futures	7812.13	7833.54	7805.09	7811.25	8844.0
2018-11-27 05:00:00	NQ	Futures	7810.96	7818.0	7793.36	7799.52	7412.0
2018-11-27 06:00:00	NQ	Futures	7799.52	7800.69	7780.45	7799.52	8576.0
2018-11-27 07:00:00	NQ	Futures	7799.52	7799.52	7769.6	7775.76	9428.0
2018-11-27 08:00:00	NQ	Futures	7775.46	7798.64	7770.48	7790.13	14495.0
2018-11-27 09:00:00	NQ	Futures	7790.13	7826.21	7759.04	7821.81	80504.0
2018-11-27 10:00:00	NQ	Futures	7821.52	7874.9	7802.45	7863.46	110036.0
2018-11-27 11:00:00	NQ	Futures	7863.46	7887.8	7842.05	7869.03	63773.0
2018-11-27 12:00:00	NQ	Futures	7869.03	7872.26	7822.39	7829.43	51855.0
2018-11-27 13:00:00	NQ	Futures	7829.14	7867.27	7815.65	7865.51	52275.0
2018-11-27 14:00:00	NQ	Futures	7865.81	7884.58	7855.54	7856.13	45873.0
2018-11-27 15:00:00	NQ	Futures	7856.42	7870.21	7840.58	7868.74	46159.0
2018-11-27 16:00:00	NQ	Futures	7869.03	7886.63	7863.75	7881.35	10422.0
2018-11-27 18:00:00	NQ	Futures	7886.92	7902.18	7882.23	7886.63	2997.0
2018-11-27 19:00:00	NQ	Futures	7886.04	7895.43	7882.82	7888.1	2939.0
2018-11-27 20:00:00	NQ	Futures	7887.8	7892.2	7875.19	7875.48	4557.0
2018-11-27 21:00:00	NQ	Futures	7875.78	7890.74	7871.67	7889.86	3579.0
2018-11-27 22:00:00	NQ	Futures	7889.56	7892.2	7883.4	7888.39	2250.0
2018-11-27 23:00:00	NQ	Futures	7887.8	7899.24	7887.51	7892.79	2306.0
2018-11-27 00:00:00	YM	Futures	26717.3	26721.7	26667.4	26679.3	2051.0
2018-11-27 01:00:00	YM	Futures	26679.3	26685.8	26656.5	26677.1	1972.0
2018-11-27 02:00:00	YM	Futures	26676.1	26893.4	26631.5	26716.3	16159.0
2018-11-27 03:00:00	YM	Futures	26717.3	26744.5	26650.0	26713.0	7389.0

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

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