PREVIEW / futures_1hour / 2018-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-26.parquet
  size:    56 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-03-26 00:00:00	ES	Futures	2851.62	2852.43	2849.16	2850.25	3681.0
2018-03-26 01:00:00	ES	Futures	2850.25	2859.8	2850.25	2855.71	12916.0
2018-03-26 02:00:00	ES	Futures	2855.71	2864.72	2855.16	2864.17	22089.0
2018-03-26 03:00:00	ES	Futures	2863.9	2867.44	2860.35	2865.53	29274.0
2018-03-26 04:00:00	ES	Futures	2865.53	2870.72	2864.72	2865.26	20695.0
2018-03-26 05:00:00	ES	Futures	2864.99	2875.63	2863.08	2873.99	23707.0
2018-03-26 06:00:00	ES	Futures	2873.99	2874.54	2867.44	2871.81	18673.0
2018-03-26 07:00:00	ES	Futures	2871.54	2877.54	2867.72	2870.72	28930.0
2018-03-26 08:00:00	ES	Futures	2870.99	2879.45	2869.9	2870.17	42061.0
2018-03-26 09:00:00	ES	Futures	2870.45	2881.64	2866.63	2875.36	250088.0
2018-03-26 10:00:00	ES	Futures	2875.36	2879.18	2855.98	2858.98	303290.0
2018-03-26 11:00:00	ES	Futures	2858.98	2861.71	2840.43	2857.89	338520.0
2018-03-26 12:00:00	ES	Futures	2857.62	2872.9	2852.98	2862.26	165560.0
2018-03-26 13:00:00	ES	Futures	2862.26	2875.36	2861.71	2868.81	147614.0
2018-03-26 14:00:00	ES	Futures	2868.81	2891.46	2868.26	2886.28	222848.0
2018-03-26 15:00:00	ES	Futures	2886.55	2906.74	2885.46	2903.74	354398.0
2018-03-26 16:00:00	ES	Futures	2903.74	2905.11	2898.83	2903.47	116257.0
2018-03-26 18:00:00	ES	Futures	2903.2	2907.29	2902.65	2904.01	6541.0
2018-03-26 19:00:00	ES	Futures	2904.29	2906.2	2900.19	2906.2	7295.0
2018-03-26 20:00:00	ES	Futures	2906.47	2913.29	2906.47	2911.11	14553.0
2018-03-26 21:00:00	ES	Futures	2910.84	2917.11	2910.56	2913.57	11056.0
2018-03-26 22:00:00	ES	Futures	2913.84	2914.93	2910.56	2913.29	5342.0
2018-03-26 23:00:00	ES	Futures	2913.29	2916.02	2911.93	2915.75	3991.0
2018-03-26 00:00:00	NQ	Futures	7807.07	7809.44	7799.68	7803.53	2169.0
2018-03-26 01:00:00	NQ	Futures	7803.23	7827.76	7802.94	7817.12	4676.0
2018-03-26 02:00:00	NQ	Futures	7817.42	7851.7	7817.12	7846.67	8514.0
2018-03-26 03:00:00	NQ	Futures	7846.38	7855.54	7835.74	7846.97	9771.0
2018-03-26 04:00:00	NQ	Futures	7846.38	7861.15	7841.65	7848.74	6630.0
2018-03-26 05:00:00	NQ	Futures	7848.74	7883.91	7843.72	7878.59	8285.0
2018-03-26 06:00:00	NQ	Futures	7878.3	7879.77	7853.77	7867.07	5980.0
2018-03-26 07:00:00	NQ	Futures	7866.77	7887.75	7862.34	7870.02	9883.0
2018-03-26 08:00:00	NQ	Futures	7870.02	7895.73	7864.7	7865.59	11741.0
2018-03-26 09:00:00	NQ	Futures	7865.88	7896.62	7855.24	7879.18	74578.0
2018-03-26 10:00:00	NQ	Futures	7879.18	7892.78	7810.62	7825.1	94919.0
2018-03-26 11:00:00	NQ	Futures	7824.8	7838.1	7745.6	7820.96	98649.0
2018-03-26 12:00:00	NQ	Futures	7820.67	7865.59	7799.98	7840.76	52947.0
2018-03-26 13:00:00	NQ	Futures	7840.47	7891.89	7838.1	7864.7	48500.0
2018-03-26 14:00:00	NQ	Futures	7865.29	7953.95	7861.45	7932.97	73822.0
2018-03-26 15:00:00	NQ	Futures	7933.26	8013.65	7929.72	8004.49	70975.0
2018-03-26 16:00:00	NQ	Futures	8004.49	8011.88	7995.62	8010.1	14320.0
2018-03-26 18:00:00	NQ	Futures	8009.81	8022.81	8008.63	8016.01	2296.0
2018-03-26 19:00:00	NQ	Futures	8016.31	8022.81	8003.6	8022.22	2312.0
2018-03-26 20:00:00	NQ	Futures	8022.22	8046.45	8022.22	8042.61	5856.0
2018-03-26 21:00:00	NQ	Futures	8042.32	8063.3	8041.73	8047.93	5982.0
2018-03-26 22:00:00	NQ	Futures	8048.23	8051.18	8033.45	8040.84	4462.0
2018-03-26 23:00:00	NQ	Futures	8040.84	8053.84	8040.25	8050.59	2846.0
2018-03-26 00:00:00	YM	Futures	25773.5	25776.8	25747.4	25760.5	2086.0
2018-03-26 01:00:00	YM	Futures	25759.4	25845.2	25755.0	25802.8	3886.0
2018-03-26 02:00:00	YM	Futures	25803.9	25885.4	25793.1	25872.3	6265.0
2018-03-26 03:00:00	YM	Futures	25871.2	25900.6	25826.7	25874.5	7518.0

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

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