PREVIEW / futures_1hour / 2020-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-23.parquet
  size:    65 KB
  rows:    1,851

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-23 00:00:00	ES	Futures	2412.93	2428.57	2406.06	2425.82	13489.0
2020-03-23 01:00:00	ES	Futures	2425.82	2428.29	2386.86	2416.49	18785.0
2020-03-23 02:00:00	ES	Futures	2416.22	2435.15	2406.61	2426.37	17731.0
2020-03-23 03:00:00	ES	Futures	2425.82	2447.78	2404.14	2423.9	33662.0
2020-03-23 04:00:00	ES	Futures	2423.35	2433.51	2406.06	2420.06	39715.0
2020-03-23 05:00:00	ES	Futures	2420.06	2450.52	2418.41	2436.25	36425.0
2020-03-23 06:00:00	ES	Futures	2436.52	2458.2	2430.49	2452.44	28455.0
2020-03-23 07:00:00	ES	Futures	2452.72	2454.91	2418.96	2431.59	35498.0
2020-03-23 08:00:00	ES	Futures	2431.59	2619.01	2430.21	2571.81	259594.0
2020-03-23 09:00:00	ES	Futures	2571.26	2584.98	2434.88	2495.52	355542.0
2020-03-23 10:00:00	ES	Futures	2495.8	2510.34	2449.15	2451.07	262003.0
2020-03-23 11:00:00	ES	Futures	2451.07	2468.91	2392.34	2416.22	287877.0
2020-03-23 12:00:00	ES	Futures	2416.22	2500.46	2402.5	2491.68	304102.0
2020-03-23 13:00:00	ES	Futures	2491.41	2514.46	2428.57	2442.84	252401.0
2020-03-23 14:00:00	ES	Futures	2443.11	2466.98	2417.86	2433.51	243160.0
2020-03-23 15:00:00	ES	Futures	2433.51	2463.69	2397.83	2433.23	448343.0
2020-03-23 16:00:00	ES	Futures	2433.51	2448.87	2414.85	2433.78	136669.0
2020-03-23 18:00:00	ES	Futures	2451.34	2488.11	2448.32	2476.31	37550.0
2020-03-23 19:00:00	ES	Futures	2476.31	2507.05	2471.92	2472.75	30459.0
2020-03-23 20:00:00	ES	Futures	2472.2	2492.23	2460.12	2485.1	22463.0
2020-03-23 21:00:00	ES	Futures	2485.92	2531.75	2483.45	2529.28	35366.0
2020-03-23 22:00:00	ES	Futures	2529.28	2544.37	2516.38	2536.96	32035.0
2020-03-23 23:00:00	ES	Futures	2537.23	2539.7	2491.68	2504.03	23116.0
2020-03-23 00:00:00	NQ	Futures	7693.44	7752.57	7674.02	7741.43	2957.0
2020-03-23 01:00:00	NQ	Futures	7744.86	7750.0	7616.32	7709.73	4764.0
2020-03-23 02:00:00	NQ	Futures	7706.87	7766.28	7675.74	7740.86	4156.0
2020-03-23 03:00:00	NQ	Futures	7740.86	7815.98	7680.88	7743.43	9022.0
2020-03-23 04:00:00	NQ	Futures	7743.43	7768.0	7678.88	7712.58	7859.0
2020-03-23 05:00:00	NQ	Futures	7714.87	7801.99	7708.58	7755.71	7225.0
2020-03-23 06:00:00	NQ	Futures	7756.0	7833.41	7734.58	7815.41	6634.0
2020-03-23 07:00:00	NQ	Futures	7817.13	7822.84	7729.44	7748.57	11665.0
2020-03-23 08:00:00	NQ	Futures	7748.57	8359.27	7747.43	8183.32	57598.0
2020-03-23 09:00:00	NQ	Futures	8187.03	8235.59	7808.84	8032.79	76857.0
2020-03-23 10:00:00	NQ	Futures	8031.36	8089.34	7898.53	7907.68	65069.0
2020-03-23 11:00:00	NQ	Futures	7908.53	7959.95	7723.72	7826.27	65658.0
2020-03-23 12:00:00	NQ	Futures	7825.13	8121.05	7783.99	8090.2	67755.0
2020-03-23 13:00:00	NQ	Futures	8089.63	8160.47	7900.25	7945.09	51966.0
2020-03-23 14:00:00	NQ	Futures	7946.81	8028.22	7868.26	7919.67	52961.0
2020-03-23 15:00:00	NQ	Futures	7919.96	8044.78	7821.41	7988.8	77473.0
2020-03-23 16:00:00	NQ	Futures	7988.8	8034.21	7920.81	7972.8	17864.0
2020-03-23 18:00:00	NQ	Futures	8004.51	8138.76	8004.51	8096.77	7315.0
2020-03-23 19:00:00	NQ	Futures	8096.2	8185.32	8087.91	8092.2	6144.0
2020-03-23 20:00:00	NQ	Futures	8091.06	8135.9	8037.93	8116.48	5714.0
2020-03-23 21:00:00	NQ	Futures	8115.05	8281.86	8109.34	8273.87	8259.0
2020-03-23 22:00:00	NQ	Futures	8274.44	8297.0	8231.02	8276.72	4738.0
2020-03-23 23:00:00	NQ	Futures	8279.29	8283.86	8131.9	8176.46	5581.0
2020-03-23 00:00:00	YM	Futures	19967.6	20115.5	19921.6	20088.1	1886.0
2020-03-23 01:00:00	YM	Futures	20098.0	20112.2	19812.1	20042.1	3481.0
2020-03-23 02:00:00	YM	Futures	20045.4	20193.3	19957.8	20118.8	2737.0
2020-03-23 03:00:00	YM	Futures	20121.0	20275.4	19905.2	20059.6	5521.0

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

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