PREVIEW / futures_1hour / 2020-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-13.parquet
  size:    50 KB
  rows:    1,469

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-04-13 00:00:00	ES	Futures	3007.31	3009.78	3002.09	3008.68	6327.0
2020-04-13 01:00:00	ES	Futures	3008.68	3013.07	3001.54	3002.92	7365.0
2020-04-13 02:00:00	ES	Futures	3002.92	3020.48	3001.54	3013.89	9508.0
2020-04-13 03:00:00	ES	Futures	3013.89	3016.09	3008.13	3009.78	5592.0
2020-04-13 04:00:00	ES	Futures	3010.05	3011.7	3004.84	3011.42	5536.0
2020-04-13 05:00:00	ES	Futures	3011.15	3017.73	3010.05	3010.6	6742.0
2020-04-13 06:00:00	ES	Futures	3010.87	3025.97	3008.13	3019.11	8672.0
2020-04-13 07:00:00	ES	Futures	3018.83	3037.77	3018.83	3036.12	16798.0
2020-04-13 08:00:00	ES	Futures	3035.85	3047.65	3030.91	3041.61	41247.0
2020-04-13 09:00:00	ES	Futures	3041.33	3050.66	3004.01	3006.21	177916.0
2020-04-13 10:00:00	ES	Futures	3006.21	3022.4	2983.71	2990.57	219921.0
2020-04-13 11:00:00	ES	Futures	2990.84	3005.11	2975.75	2999.9	172039.0
2020-04-13 12:00:00	ES	Futures	2999.9	3016.36	2992.49	2996.33	149720.0
2020-04-13 13:00:00	ES	Futures	2996.33	3010.87	2986.45	3005.11	149114.0
2020-04-13 14:00:00	ES	Futures	3004.84	3013.34	2992.49	3006.48	120836.0
2020-04-13 15:00:00	ES	Futures	3006.48	3035.02	2995.51	3021.85	242645.0
2020-04-13 16:00:00	ES	Futures	3021.85	3030.91	3021.58	3029.81	57506.0
2020-04-13 18:00:00	ES	Futures	3029.53	3041.61	3028.44	3037.77	20316.0
2020-04-13 19:00:00	ES	Futures	3037.77	3039.41	3033.92	3038.32	4795.0
2020-04-13 20:00:00	ES	Futures	3038.32	3038.59	3021.3	3031.18	12211.0
2020-04-13 21:00:00	ES	Futures	3031.45	3067.95	3029.26	3059.72	19626.0
2020-04-13 22:00:00	ES	Futures	3059.72	3071.79	3055.6	3067.13	21988.0
2020-04-13 23:00:00	ES	Futures	3067.13	3070.97	3062.74	3069.05	9210.0
2020-04-13 00:00:00	NQ	Futures	9265.04	9273.04	9245.9	9267.9	1955.0
2020-04-13 01:00:00	NQ	Futures	9267.61	9282.18	9244.47	9247.9	2515.0
2020-04-13 02:00:00	NQ	Futures	9247.33	9296.17	9244.76	9275.04	3478.0
2020-04-13 03:00:00	NQ	Futures	9275.32	9287.89	9262.18	9269.9	2328.0
2020-04-13 04:00:00	NQ	Futures	9271.61	9290.18	9265.61	9290.18	2607.0
2020-04-13 05:00:00	NQ	Futures	9290.46	9315.03	9286.18	9294.75	3061.0
2020-04-13 06:00:00	NQ	Futures	9295.32	9339.88	9284.18	9315.31	3543.0
2020-04-13 07:00:00	NQ	Futures	9313.88	9373.01	9312.74	9366.16	7351.0
2020-04-13 08:00:00	NQ	Futures	9366.16	9392.15	9348.45	9370.73	10691.0
2020-04-13 09:00:00	NQ	Futures	9370.44	9418.71	9325.31	9334.74	49958.0
2020-04-13 10:00:00	NQ	Futures	9334.45	9402.43	9317.88	9343.88	52760.0
2020-04-13 11:00:00	NQ	Futures	9344.73	9396.15	9301.89	9374.44	44213.0
2020-04-13 12:00:00	NQ	Futures	9374.15	9417.86	9363.3	9375.87	38208.0
2020-04-13 13:00:00	NQ	Futures	9375.58	9430.71	9352.45	9416.14	31538.0
2020-04-13 14:00:00	NQ	Futures	9416.43	9438.42	9386.72	9431.0	30397.0
2020-04-13 15:00:00	NQ	Futures	9430.71	9521.55	9401.0	9502.12	56243.0
2020-04-13 16:00:00	NQ	Futures	9502.12	9527.54	9494.12	9526.69	10719.0
2020-04-13 18:00:00	NQ	Futures	9525.54	9567.25	9519.83	9560.39	4603.0
2020-04-13 19:00:00	NQ	Futures	9559.82	9564.96	9545.82	9558.68	1720.0
2020-04-13 20:00:00	NQ	Futures	9558.39	9558.68	9504.98	9534.4	6307.0
2020-04-13 21:00:00	NQ	Futures	9535.26	9652.08	9527.83	9632.94	7388.0
2020-04-13 22:00:00	NQ	Futures	9632.66	9672.93	9622.38	9657.22	5105.0
2020-04-13 23:00:00	NQ	Futures	9657.8	9662.08	9633.52	9653.23	2555.0
2020-04-13 00:00:00	YM	Futures	25515.4	25531.9	25471.6	25520.9	1059.0
2020-04-13 01:00:00	YM	Futures	25523.1	25557.0	25450.8	25465.0	1500.0
2020-04-13 02:00:00	YM	Futures	25460.7	25616.2	25453.0	25554.9	2295.0
2020-04-13 03:00:00	YM	Futures	25555.9	25578.9	25492.4	25508.8	1523.0

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

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