PREVIEW / futures_1hour / 2020-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-30.parquet
  size:    63 KB
  rows:    1,855

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-30 00:00:00	ES	Futures	2759.24	2790.52	2758.41	2785.58	21278.0
2020-03-30 01:00:00	ES	Futures	2785.85	2818.23	2779.82	2811.92	28582.0
2020-03-30 02:00:00	ES	Futures	2811.37	2813.57	2769.39	2780.91	29591.0
2020-03-30 03:00:00	ES	Futures	2780.64	2796.83	2738.65	2741.67	45874.0
2020-03-30 04:00:00	ES	Futures	2741.67	2780.37	2741.12	2767.74	36632.0
2020-03-30 05:00:00	ES	Futures	2767.47	2783.66	2751.28	2761.16	27649.0
2020-03-30 06:00:00	ES	Futures	2760.88	2781.46	2759.78	2777.9	17129.0
2020-03-30 07:00:00	ES	Futures	2777.62	2785.85	2767.74	2780.91	29432.0
2020-03-30 08:00:00	ES	Futures	2781.19	2808.9	2772.96	2808.63	46014.0
2020-03-30 09:00:00	ES	Futures	2808.63	2819.61	2779.54	2799.03	157646.0
2020-03-30 10:00:00	ES	Futures	2799.03	2834.7	2792.71	2818.51	176395.0
2020-03-30 11:00:00	ES	Futures	2818.23	2849.52	2815.49	2841.83	147779.0
2020-03-30 12:00:00	ES	Futures	2841.56	2855.01	2830.03	2854.18	125207.0
2020-03-30 13:00:00	ES	Futures	2854.46	2854.46	2834.7	2841.01	111255.0
2020-03-30 14:00:00	ES	Futures	2841.01	2861.87	2828.39	2854.73	144083.0
2020-03-30 15:00:00	ES	Futures	2854.73	2877.78	2838.82	2869.28	355676.0
2020-03-30 16:00:00	ES	Futures	2869.28	2875.86	2860.22	2868.18	91921.0
2020-03-30 18:00:00	ES	Futures	2868.45	2880.8	2865.16	2872.02	10233.0
2020-03-30 19:00:00	ES	Futures	2872.02	2876.41	2865.16	2872.02	8944.0
2020-03-30 20:00:00	ES	Futures	2872.02	2881.35	2870.1	2872.29	19399.0
2020-03-30 21:00:00	ES	Futures	2872.57	2888.48	2872.29	2879.43	18650.0
2020-03-30 22:00:00	ES	Futures	2879.7	2886.84	2876.96	2880.25	10603.0
2020-03-30 23:00:00	ES	Futures	2879.98	2881.62	2869.82	2872.02	8236.0
2020-03-30 00:00:00	NQ	Futures	8622.92	8692.04	8619.78	8678.91	5992.0
2020-03-30 01:00:00	NQ	Futures	8679.19	8786.31	8669.19	8762.03	8799.0
2020-03-30 02:00:00	NQ	Futures	8761.17	8763.74	8651.77	8680.9	9773.0
2020-03-30 03:00:00	NQ	Futures	8682.62	8732.89	8560.08	8571.79	9700.0
2020-03-30 04:00:00	NQ	Futures	8573.5	8682.05	8571.79	8656.91	9896.0
2020-03-30 05:00:00	NQ	Futures	8656.34	8706.33	8610.92	8633.49	9234.0
2020-03-30 06:00:00	NQ	Futures	8630.35	8694.04	8628.06	8681.48	6572.0
2020-03-30 07:00:00	NQ	Futures	8679.76	8709.18	8655.48	8686.05	8946.0
2020-03-30 08:00:00	NQ	Futures	8686.62	8772.02	8666.05	8771.17	12470.0
2020-03-30 09:00:00	NQ	Futures	8771.17	8812.01	8717.75	8782.31	38245.0
2020-03-30 10:00:00	NQ	Futures	8784.31	8907.99	8769.17	8870.86	48473.0
2020-03-30 11:00:00	NQ	Futures	8870.57	8945.98	8862.86	8919.41	45872.0
2020-03-30 12:00:00	NQ	Futures	8919.13	8967.12	8879.42	8965.97	35189.0
2020-03-30 13:00:00	NQ	Futures	8966.26	8966.26	8911.99	8930.55	31389.0
2020-03-30 14:00:00	NQ	Futures	8929.41	8980.26	8893.42	8954.26	32882.0
2020-03-30 15:00:00	NQ	Futures	8953.98	9007.96	8909.42	8988.25	55723.0
2020-03-30 16:00:00	NQ	Futures	8988.54	8994.82	8945.12	8972.83	10798.0
2020-03-30 18:00:00	NQ	Futures	8976.83	9009.11	8960.26	8993.97	2955.0
2020-03-30 19:00:00	NQ	Futures	8993.68	9006.82	8971.4	8998.54	2255.0
2020-03-30 20:00:00	NQ	Futures	8998.54	9025.1	8991.97	8996.25	3845.0
2020-03-30 21:00:00	NQ	Futures	8997.39	9068.52	8992.54	9034.53	5927.0
2020-03-30 22:00:00	NQ	Futures	9035.38	9055.38	9029.39	9037.38	2164.0
2020-03-30 23:00:00	NQ	Futures	9038.24	9040.81	8993.68	9004.82	2475.0
2020-03-30 00:00:00	YM	Futures	23385.0	23665.4	23379.6	23606.3	3713.0
2020-03-30 01:00:00	YM	Futures	23610.7	23906.4	23574.5	23856.0	4149.0
2020-03-30 02:00:00	YM	Futures	23857.1	23865.9	23496.8	23596.4	4451.0
2020-03-30 03:00:00	YM	Futures	23590.9	23727.9	23169.3	23196.6	7227.0

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

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