PREVIEW / futures_1hour / 2020-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-26.parquet
  size:    64 KB
  rows:    1,880

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
2020-03-26 00:00:00	ES	Futures	2693.93	2700.24	2677.19	2688.16	18711.0
2020-03-26 01:00:00	ES	Futures	2688.99	2697.77	2671.7	2685.69	16239.0
2020-03-26 02:00:00	ES	Futures	2685.97	2687.34	2669.23	2670.05	14238.0
2020-03-26 03:00:00	ES	Futures	2670.33	2678.28	2647.55	2655.78	23451.0
2020-03-26 04:00:00	ES	Futures	2655.78	2674.99	2647.55	2663.19	44931.0
2020-03-26 05:00:00	ES	Futures	2663.47	2674.72	2652.49	2668.95	26907.0
2020-03-26 06:00:00	ES	Futures	2668.95	2691.18	2662.92	2680.2	27986.0
2020-03-26 07:00:00	ES	Futures	2680.2	2684.87	2654.96	2656.88	35729.0
2020-03-26 08:00:00	ES	Futures	2656.88	2705.45	2636.85	2698.59	120496.0
2020-03-26 09:00:00	ES	Futures	2698.59	2786.4	2690.08	2781.19	261529.0
2020-03-26 10:00:00	ES	Futures	2781.46	2824.27	2771.86	2802.04	278871.0
2020-03-26 11:00:00	ES	Futures	2801.77	2839.64	2788.05	2833.33	202655.0
2020-03-26 12:00:00	ES	Futures	2833.6	2841.56	2813.02	2836.35	159816.0
2020-03-26 13:00:00	ES	Futures	2836.62	2844.03	2793.26	2815.22	183197.0
2020-03-26 14:00:00	ES	Futures	2814.94	2842.11	2801.22	2836.35	163194.0
2020-03-26 15:00:00	ES	Futures	2836.07	2882.17	2813.84	2863.79	472057.0
2020-03-26 16:00:00	ES	Futures	2863.79	2875.59	2856.1	2875.04	126405.0
2020-03-26 18:00:00	ES	Futures	2884.37	2885.74	2857.2	2858.3	27324.0
2020-03-26 19:00:00	ES	Futures	2858.85	2891.78	2853.91	2886.02	20602.0
2020-03-26 20:00:00	ES	Futures	2886.02	2889.86	2844.03	2847.05	24592.0
2020-03-26 21:00:00	ES	Futures	2846.77	2849.24	2818.78	2834.7	37980.0
2020-03-26 22:00:00	ES	Futures	2834.97	2835.25	2812.2	2816.31	22871.0
2020-03-26 23:00:00	ES	Futures	2816.86	2834.97	2811.92	2829.21	21441.0
2020-03-26 00:00:00	NQ	Futures	8508.38	8521.23	8451.25	8485.24	4366.0
2020-03-26 01:00:00	NQ	Futures	8490.1	8510.38	8430.4	8471.53	4461.0
2020-03-26 02:00:00	NQ	Futures	8472.67	8476.67	8420.69	8428.97	4545.0
2020-03-26 03:00:00	NQ	Futures	8430.97	8450.68	8364.99	8392.12	6571.0
2020-03-26 04:00:00	NQ	Futures	8392.69	8450.11	8368.13	8412.12	8491.0
2020-03-26 05:00:00	NQ	Futures	8413.26	8440.4	8375.55	8422.11	6879.0
2020-03-26 06:00:00	NQ	Futures	8422.11	8490.67	8406.98	8460.68	8206.0
2020-03-26 07:00:00	NQ	Futures	8460.39	8493.24	8396.12	8399.83	10710.0
2020-03-26 08:00:00	NQ	Futures	8398.41	8540.66	8352.42	8524.09	24788.0
2020-03-26 09:00:00	NQ	Futures	8524.94	8732.61	8496.1	8715.18	61187.0
2020-03-26 10:00:00	NQ	Futures	8715.18	8817.16	8692.04	8766.88	78295.0
2020-03-26 11:00:00	NQ	Futures	8767.17	8853.43	8729.18	8836.58	55331.0
2020-03-26 12:00:00	NQ	Futures	8837.44	8876.57	8785.16	8861.72	43734.0
2020-03-26 13:00:00	NQ	Futures	8862.86	8881.71	8737.18	8802.3	52961.0
2020-03-26 14:00:00	NQ	Futures	8802.02	8887.99	8781.16	8868.57	46235.0
2020-03-26 15:00:00	NQ	Futures	8867.43	9018.82	8807.16	8989.68	84377.0
2020-03-26 16:00:00	NQ	Futures	8988.83	8999.68	8946.55	8982.26	15397.0
2020-03-26 18:00:00	NQ	Futures	9006.54	9014.82	8930.27	8934.27	4590.0
2020-03-26 19:00:00	NQ	Futures	8933.41	9016.25	8921.99	9001.11	4368.0
2020-03-26 20:00:00	NQ	Futures	9001.96	9018.53	8895.14	8903.7	5983.0
2020-03-26 21:00:00	NQ	Futures	8901.42	8916.27	8835.72	8876.28	7041.0
2020-03-26 22:00:00	NQ	Futures	8876.85	8879.71	8807.16	8834.01	5102.0
2020-03-26 23:00:00	NQ	Futures	8832.01	8894.56	8815.16	8875.14	3945.0
2020-03-26 00:00:00	YM	Futures	22999.5	23060.8	22868.0	22953.5	2344.0
2020-03-26 01:00:00	YM	Futures	22951.3	23041.1	22806.7	22919.5	1999.0
2020-03-26 02:00:00	YM	Futures	22918.4	22932.7	22772.7	22783.7	1795.0
2020-03-26 03:00:00	YM	Futures	22783.7	22837.4	22581.1	22658.8	3386.0

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

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