PREVIEW / futures_1hour / 2018-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-12.parquet
  size:    54 KB
  rows:    1,653

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-04-12 00:00:00	ES	Futures	2887.91	2889.55	2886.82	2889.0	2434.0
2018-04-12 01:00:00	ES	Futures	2889.0	2889.82	2885.46	2886.0	2923.0
2018-04-12 02:00:00	ES	Futures	2886.0	2887.09	2884.37	2887.09	5015.0
2018-04-12 03:00:00	ES	Futures	2886.82	2890.1	2884.37	2889.28	10200.0
2018-04-12 04:00:00	ES	Futures	2889.28	2890.1	2883.0	2883.27	8582.0
2018-04-12 05:00:00	ES	Futures	2883.55	2889.28	2881.64	2888.46	9222.0
2018-04-12 06:00:00	ES	Futures	2888.19	2899.65	2887.64	2898.83	24653.0
2018-04-12 07:00:00	ES	Futures	2899.1	2899.92	2895.01	2897.46	19945.0
2018-04-12 08:00:00	ES	Futures	2897.74	2900.47	2896.37	2897.19	19427.0
2018-04-12 09:00:00	ES	Futures	2897.19	2914.93	2897.19	2914.39	179614.0
2018-04-12 10:00:00	ES	Futures	2914.11	2916.3	2905.11	2907.02	182314.0
2018-04-12 11:00:00	ES	Futures	2907.02	2914.66	2904.01	2909.2	129995.0
2018-04-12 12:00:00	ES	Futures	2908.93	2917.66	2907.02	2916.02	92927.0
2018-04-12 13:00:00	ES	Futures	2916.02	2916.84	2899.1	2904.83	188347.0
2018-04-12 14:00:00	ES	Futures	2904.83	2915.2	2903.47	2914.39	102917.0
2018-04-12 15:00:00	ES	Futures	2914.39	2920.12	2907.02	2907.84	182419.0
2018-04-12 16:00:00	ES	Futures	2907.84	2910.29	2906.2	2909.2	55611.0
2018-04-12 18:00:00	ES	Futures	2905.65	2907.29	2895.01	2897.19	14620.0
2018-04-12 19:00:00	ES	Futures	2897.46	2900.74	2896.65	2900.19	8843.0
2018-04-12 20:00:00	ES	Futures	2899.92	2901.83	2895.01	2898.56	12745.0
2018-04-12 21:00:00	ES	Futures	2898.56	2902.1	2897.74	2899.65	5747.0
2018-04-12 22:00:00	ES	Futures	2899.65	2900.74	2897.74	2899.38	3867.0
2018-04-12 23:00:00	ES	Futures	2899.38	2900.47	2897.74	2899.65	2247.0
2018-04-12 00:00:00	NQ	Futures	7817.42	7820.67	7811.21	7817.42	861.0
2018-04-12 01:00:00	NQ	Futures	7818.01	7820.96	7805.59	7807.66	1032.0
2018-04-12 02:00:00	NQ	Futures	7807.37	7812.69	7802.34	7812.69	1577.0
2018-04-12 03:00:00	NQ	Futures	7812.1	7822.74	7802.94	7817.71	2877.0
2018-04-12 04:00:00	NQ	Futures	7818.3	7820.08	7792.89	7796.14	3166.0
2018-04-12 05:00:00	NQ	Futures	7795.55	7814.46	7789.93	7810.32	2784.0
2018-04-12 06:00:00	NQ	Futures	7810.32	7844.01	7808.85	7839.88	6167.0
2018-04-12 07:00:00	NQ	Futures	7839.88	7847.86	7831.9	7839.88	6977.0
2018-04-12 08:00:00	NQ	Futures	7840.47	7846.97	7833.08	7837.22	5879.0
2018-04-12 09:00:00	NQ	Futures	7837.51	7890.12	7834.26	7889.53	54669.0
2018-04-12 10:00:00	NQ	Futures	7889.53	7909.33	7876.23	7882.73	61679.0
2018-04-12 11:00:00	NQ	Futures	7882.43	7903.12	7866.47	7882.73	40966.0
2018-04-12 12:00:00	NQ	Futures	7882.43	7903.71	7872.09	7900.46	24268.0
2018-04-12 13:00:00	NQ	Futures	7900.46	7906.08	7848.45	7862.34	51464.0
2018-04-12 14:00:00	NQ	Futures	7862.04	7894.25	7857.9	7891.3	28570.0
2018-04-12 15:00:00	NQ	Futures	7891.59	7912.87	7879.48	7882.14	40993.0
2018-04-12 16:00:00	NQ	Futures	7882.14	7893.66	7877.11	7888.93	7483.0
2018-04-12 18:00:00	NQ	Futures	7883.32	7883.91	7857.9	7860.27	3358.0
2018-04-12 19:00:00	NQ	Futures	7861.15	7870.61	7859.09	7867.95	2903.0
2018-04-12 20:00:00	NQ	Futures	7867.07	7875.64	7855.84	7862.93	4351.0
2018-04-12 21:00:00	NQ	Futures	7863.22	7875.93	7859.97	7864.7	2439.0
2018-04-12 22:00:00	NQ	Futures	7864.7	7867.36	7858.79	7861.45	1957.0
2018-04-12 23:00:00	NQ	Futures	7861.45	7864.7	7858.2	7861.75	1313.0
2018-04-12 00:00:00	YM	Futures	26299.1	26318.7	26293.7	26310.0	1161.0
2018-04-12 01:00:00	YM	Futures	26312.2	26320.9	26274.2	26277.4	1291.0
2018-04-12 02:00:00	YM	Futures	26278.5	26289.4	26252.4	26277.4	2138.0
2018-04-12 03:00:00	YM	Futures	26276.3	26303.5	26249.2	26289.4	3968.0

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

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