PREVIEW / futures_1hour / 2020-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-19.parquet
  size:    67 KB
  rows:    1,885

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-19 00:00:00	ES	Futures	2508.15	2538.06	2497.17	2516.65	21984.0
2020-03-19 01:00:00	ES	Futures	2516.93	2557.27	2516.93	2546.56	17258.0
2020-03-19 02:00:00	ES	Futures	2546.56	2612.42	2546.56	2593.22	22658.0
2020-03-19 03:00:00	ES	Futures	2593.49	2632.18	2574.83	2588.55	32961.0
2020-03-19 04:00:00	ES	Futures	2588.82	2650.84	2582.79	2639.04	52509.0
2020-03-19 05:00:00	ES	Futures	2639.04	2647.27	2598.7	2607.76	34346.0
2020-03-19 06:00:00	ES	Futures	2607.76	2607.76	2580.04	2592.94	35514.0
2020-03-19 07:00:00	ES	Futures	2592.67	2611.88	2559.74	2566.6	45001.0
2020-03-19 08:00:00	ES	Futures	2566.87	2601.72	2553.97	2597.06	56242.0
2020-03-19 09:00:00	ES	Futures	2597.33	2610.5	2531.47	2593.49	232791.0
2020-03-19 10:00:00	ES	Futures	2593.76	2659.35	2577.3	2608.03	338024.0
2020-03-19 11:00:00	ES	Futures	2608.03	2686.24	2601.17	2646.45	303569.0
2020-03-19 12:00:00	ES	Futures	2646.45	2659.62	2603.37	2640.96	263020.0
2020-03-19 13:00:00	ES	Futures	2640.69	2684.32	2627.24	2665.11	192194.0
2020-03-19 14:00:00	ES	Futures	2665.11	2697.22	2641.51	2664.29	207523.0
2020-03-19 15:00:00	ES	Futures	2664.29	2677.73	2621.21	2632.46	473072.0
2020-03-19 16:00:00	ES	Futures	2632.46	2634.38	2576.2	2584.98	132720.0
2020-03-19 18:00:00	ES	Futures	2580.59	2597.61	2560.29	2565.22	32249.0
2020-03-19 19:00:00	ES	Futures	2564.95	2588.82	2557.82	2586.08	23526.0
2020-03-19 20:00:00	ES	Futures	2586.08	2595.96	2564.4	2570.16	23708.0
2020-03-19 21:00:00	ES	Futures	2570.99	2622.3	2570.16	2587.45	35729.0
2020-03-19 22:00:00	ES	Futures	2587.18	2613.8	2576.75	2603.09	25924.0
2020-03-19 23:00:00	ES	Futures	2603.37	2609.95	2589.1	2603.64	15353.0
2020-03-19 00:00:00	NQ	Futures	7896.82	7983.08	7854.26	7914.82	4281.0
2020-03-19 01:00:00	NQ	Futures	7917.96	8057.64	7916.24	8027.64	3440.0
2020-03-19 02:00:00	NQ	Futures	8027.07	8191.6	8025.65	8130.76	5150.0
2020-03-19 03:00:00	NQ	Futures	8126.76	8283.58	8112.77	8142.47	6495.0
2020-03-19 04:00:00	NQ	Futures	8149.33	8369.84	8129.9	8327.85	9935.0
2020-03-19 05:00:00	NQ	Futures	8329.57	8354.99	8190.75	8209.31	6913.0
2020-03-19 06:00:00	NQ	Futures	8208.74	8215.6	8131.62	8175.04	7121.0
2020-03-19 07:00:00	NQ	Futures	8171.32	8235.31	8073.35	8097.06	8668.0
2020-03-19 08:00:00	NQ	Futures	8094.2	8188.46	8043.07	8181.03	9988.0
2020-03-19 09:00:00	NQ	Futures	8179.61	8264.73	8009.36	8255.59	46877.0
2020-03-19 10:00:00	NQ	Futures	8255.87	8444.11	8207.03	8271.3	75289.0
2020-03-19 11:00:00	NQ	Futures	8272.72	8512.09	8249.59	8366.41	59532.0
2020-03-19 12:00:00	NQ	Futures	8365.84	8452.11	8267.58	8387.84	37835.0
2020-03-19 13:00:00	NQ	Futures	8390.69	8522.66	8357.56	8468.39	30615.0
2020-03-19 14:00:00	NQ	Futures	8470.67	8572.08	8403.83	8483.24	31016.0
2020-03-19 15:00:00	NQ	Futures	8485.24	8525.23	8290.43	8304.72	62954.0
2020-03-19 16:00:00	NQ	Futures	8305.57	8316.43	8176.75	8209.03	20468.0
2020-03-19 18:00:00	NQ	Futures	8200.17	8250.44	8145.9	8164.47	7967.0
2020-03-19 19:00:00	NQ	Futures	8162.18	8229.88	8142.19	8221.31	5752.0
2020-03-19 20:00:00	NQ	Futures	8221.02	8270.15	8182.75	8247.87	7804.0
2020-03-19 21:00:00	NQ	Futures	8248.73	8390.69	8219.02	8271.87	12121.0
2020-03-19 22:00:00	NQ	Futures	8271.3	8362.99	8244.73	8336.14	8274.0
2020-03-19 23:00:00	NQ	Futures	8338.42	8341.28	8290.43	8327.0	4267.0
2020-03-19 00:00:00	YM	Futures	20699.3	20967.7	20629.2	20785.8	2979.0
2020-03-19 01:00:00	YM	Futures	20802.3	21130.9	20786.9	21040.0	2691.0
2020-03-19 02:00:00	YM	Futures	21053.1	21596.4	21034.5	21420.0	4050.0
2020-03-19 03:00:00	YM	Futures	21422.2	21719.1	21224.0	21352.1	4637.0

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

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