PREVIEW / futures_1hour / 2020-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-18.parquet
  size:    65 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-18 00:00:00	ES	Futures	2638.77	2647.55	2632.46	2636.3	14623.0
2020-03-18 01:00:00	ES	Futures	2636.57	2637.67	2627.24	2627.24	4301.0
2020-03-18 02:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	116.0
2020-03-18 03:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	1104.0
2020-03-18 04:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	415.0
2020-03-18 05:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	253.0
2020-03-18 06:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	229.0
2020-03-18 07:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	153.0
2020-03-18 08:00:00	ES	Futures	2627.24	2627.24	2627.24	2627.24	200.0
2020-03-18 09:00:00	ES	Futures	2627.24	2661.54	2572.09	2641.79	284556.0
2020-03-18 10:00:00	ES	Futures	2641.79	2680.48	2616.27	2617.64	273804.0
2020-03-18 11:00:00	ES	Futures	2617.36	2631.63	2582.51	2626.97	255286.0
2020-03-18 12:00:00	ES	Futures	2627.24	2628.89	2571.26	2574.56	258327.0
2020-03-18 13:00:00	ES	Futures	2553.7	2580.87	2505.68	2526.53	286623.0
2020-03-18 14:00:00	ES	Futures	2527.36	2560.01	2482.9	2558.91	299755.0
2020-03-18 15:00:00	ES	Futures	2559.19	2636.02	2513.64	2626.42	598139.0
2020-03-18 16:00:00	ES	Futures	2626.69	2649.2	2585.26	2640.69	208223.0
2020-03-18 18:00:00	ES	Futures	2637.12	2699.41	2594.59	2677.19	66796.0
2020-03-18 19:00:00	ES	Futures	2676.91	2700.24	2645.35	2681.85	50157.0
2020-03-18 20:00:00	ES	Futures	2682.67	2698.04	2636.85	2644.81	32102.0
2020-03-18 21:00:00	ES	Futures	2644.26	2665.93	2619.01	2620.66	35444.0
2020-03-18 22:00:00	ES	Futures	2620.38	2621.21	2515.28	2516.93	52770.0
2020-03-18 23:00:00	ES	Futures	2516.65	2561.38	2502.66	2508.15	44637.0
2020-03-18 00:00:00	NQ	Futures	8156.47	8179.89	8127.05	8146.47	3218.0
2020-03-18 01:00:00	NQ	Futures	8146.47	8150.18	8071.35	8071.35	1940.0
2020-03-18 02:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	68.0
2020-03-18 03:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	82.0
2020-03-18 04:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	267.0
2020-03-18 05:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	51.0
2020-03-18 06:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	17.0
2020-03-18 07:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	9.0
2020-03-18 08:00:00	NQ	Futures	8071.35	8071.35	8071.35	8071.35	8.0
2020-03-18 09:00:00	NQ	Futures	8071.35	8290.43	7953.95	8246.73	52696.0
2020-03-18 10:00:00	NQ	Futures	8246.16	8368.7	8180.75	8201.6	59416.0
2020-03-18 11:00:00	NQ	Futures	8199.89	8227.59	8073.06	8204.74	55595.0
2020-03-18 12:00:00	NQ	Futures	8204.17	8220.74	7977.66	8002.22	46085.0
2020-03-18 13:00:00	NQ	Futures	7968.23	8053.64	7815.41	7875.97	49867.0
2020-03-18 14:00:00	NQ	Futures	7876.54	8036.21	7780.85	8033.07	48980.0
2020-03-18 15:00:00	NQ	Futures	8034.79	8243.59	7863.69	8234.16	81057.0
2020-03-18 16:00:00	NQ	Futures	8236.45	8299.0	8130.48	8273.87	26128.0
2020-03-18 18:00:00	NQ	Futures	8265.58	8428.68	8118.19	8369.84	11174.0
2020-03-18 19:00:00	NQ	Futures	8366.13	8482.38	8293.0	8413.26	11296.0
2020-03-18 20:00:00	NQ	Futures	8416.12	8457.25	8267.3	8292.15	8146.0
2020-03-18 21:00:00	NQ	Futures	8293.29	8376.98	8215.02	8227.88	9322.0
2020-03-18 22:00:00	NQ	Futures	8227.88	8229.31	7938.81	7940.81	12314.0
2020-03-18 23:00:00	NQ	Futures	7937.1	8073.63	7886.25	7896.82	8176.0
2020-03-18 00:00:00	YM	Futures	22174.7	22239.3	22109.0	22148.4	1923.0
2020-03-18 01:00:00	YM	Futures	22148.4	22163.7	21949.1	21949.1	1441.0
2020-03-18 02:00:00	YM	Futures	21949.1	21949.1	21949.1	21949.1	5.0
2020-03-18 03:00:00	YM	Futures	21949.1	21949.1	21949.1	21949.1	17.0

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

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