PREVIEW / futures_1hour / 2020-03-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	2836.73	2893.09	2836.45	2881.71	35378.0
2020-03-12 01:00:00	ES	Futures	2881.71	2885.78	2852.99	2866.53	22750.0
2020-03-12 02:00:00	ES	Futures	2866.53	2868.97	2843.77	2849.46	31015.0
2020-03-12 03:00:00	ES	Futures	2849.73	2869.52	2832.93	2851.09	49162.0
2020-03-12 04:00:00	ES	Futures	2851.9	2866.53	2821.82	2828.33	75202.0
2020-03-12 05:00:00	ES	Futures	2828.33	2852.44	2819.92	2837.54	61034.0
2020-03-12 06:00:00	ES	Futures	2837.27	2844.04	2819.92	2843.23	49167.0
2020-03-12 07:00:00	ES	Futures	2842.96	2843.77	2821.01	2822.09	43552.0
2020-03-12 08:00:00	ES	Futures	2822.09	2834.83	2819.38	2819.38	33429.0
2020-03-12 09:00:00	ES	Futures	2819.38	2819.38	2701.5	2799.87	224659.0
2020-03-12 10:00:00	ES	Futures	2799.6	2800.14	2739.44	2787.95	388144.0
2020-03-12 11:00:00	ES	Futures	2788.22	2788.76	2714.78	2732.39	317038.0
2020-03-12 12:00:00	ES	Futures	2732.39	2831.31	2705.3	2809.36	390190.0
2020-03-12 13:00:00	ES	Futures	2809.63	2881.98	2735.1	2778.46	487459.0
2020-03-12 14:00:00	ES	Futures	2778.19	2788.49	2720.74	2722.1	264171.0
2020-03-12 15:00:00	ES	Futures	2722.37	2756.24	2671.96	2677.11	559861.0
2020-03-12 16:00:00	ES	Futures	2677.11	2694.46	2647.57	2655.43	211724.0
2020-03-12 18:00:00	ES	Futures	2633.48	2693.64	2622.1	2668.44	48817.0
2020-03-12 19:00:00	ES	Futures	2668.98	2681.72	2634.03	2645.14	19654.0
2020-03-12 20:00:00	ES	Futures	2645.68	2673.32	2645.14	2662.21	22647.0
2020-03-12 21:00:00	ES	Futures	2661.4	2666.27	2608.01	2624.81	40459.0
2020-03-12 22:00:00	ES	Futures	2624.54	2640.26	2602.32	2617.49	24595.0
2020-03-12 23:00:00	ES	Futures	2617.49	2622.64	2594.46	2600.96	19638.0
2020-03-12 00:00:00	NQ	Futures	8831.64	8979.41	8831.35	8940.95	11099.0
2020-03-12 01:00:00	NQ	Futures	8943.55	8953.67	8868.94	8916.95	6884.0
2020-03-12 02:00:00	NQ	Futures	8917.53	8927.65	8859.11	8875.31	8909.0
2020-03-12 03:00:00	NQ	Futures	8877.33	8945.58	8824.99	8888.03	13229.0
2020-03-12 04:00:00	NQ	Futures	8888.32	8928.22	8794.34	8818.05	19586.0
2020-03-12 05:00:00	NQ	Futures	8817.47	8868.08	8792.6	8832.8	14455.0
2020-03-12 06:00:00	NQ	Futures	8832.8	8847.55	8792.6	8844.94	10115.0
2020-03-12 07:00:00	NQ	Futures	8844.65	8846.1	8792.6	8792.6	9567.0
2020-03-12 08:00:00	NQ	Futures	8792.6	8797.52	8792.6	8792.6	2500.0
2020-03-12 09:00:00	NQ	Futures	8792.6	8792.6	8475.38	8750.09	39948.0
2020-03-12 10:00:00	NQ	Futures	8749.23	8808.51	8620.83	8770.34	97062.0
2020-03-12 11:00:00	NQ	Futures	8771.2	8772.94	8519.33	8564.16	83844.0
2020-03-12 12:00:00	NQ	Futures	8563.87	8849.57	8473.36	8784.22	89736.0
2020-03-12 13:00:00	NQ	Futures	8781.61	9037.24	8600.59	8737.37	118610.0
2020-03-12 14:00:00	NQ	Futures	8737.08	8769.76	8537.84	8542.47	69700.0
2020-03-12 15:00:00	NQ	Futures	8541.89	8641.94	8383.42	8398.17	98741.0
2020-03-12 16:00:00	NQ	Futures	8397.59	8445.59	8245.49	8282.5	38519.0
2020-03-12 18:00:00	NQ	Futures	8212.52	8381.69	8166.83	8312.0	12179.0
2020-03-12 19:00:00	NQ	Futures	8312.57	8350.75	8194.01	8231.9	5328.0
2020-03-12 20:00:00	NQ	Futures	8229.87	8307.95	8228.14	8256.19	7437.0
2020-03-12 21:00:00	NQ	Futures	8254.45	8270.36	8076.61	8122.01	11759.0
2020-03-12 22:00:00	NQ	Futures	8118.25	8165.96	8063.31	8103.21	7481.0
2020-03-12 23:00:00	NQ	Futures	8102.64	8115.65	8030.34	8043.93	6412.0
2020-03-12 00:00:00	YM	Futures	24417.9	24907.5	24400.4	24767.3	238.0
2020-03-12 01:00:00	YM	Futures	24779.4	24789.2	24535.1	24605.2	227.0
2020-03-12 02:00:00	YM	Futures	24609.6	24618.4	24443.1	24505.5	181.0
2020-03-12 03:00:00	YM	Futures	24558.1	24652.3	24352.2	24482.5	499.0

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

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