PREVIEW / futures_1hour / 2020-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-16.parquet
  size:    61 KB
  rows:    1,834

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-16 00:00:00	ES	Futures	3029.53	3038.32	3028.99	3036.39	6442.0
2020-04-16 01:00:00	ES	Futures	3036.39	3056.15	3028.71	3055.88	14018.0
2020-04-16 02:00:00	ES	Futures	3055.6	3080.3	3047.65	3073.17	32259.0
2020-04-16 03:00:00	ES	Futures	3073.17	3078.11	3058.62	3070.15	37883.0
2020-04-16 04:00:00	ES	Futures	3069.87	3074.26	3062.46	3063.84	22333.0
2020-04-16 05:00:00	ES	Futures	3063.84	3065.76	3054.23	3062.46	23324.0
2020-04-16 06:00:00	ES	Futures	3062.74	3067.68	3050.94	3061.64	20662.0
2020-04-16 07:00:00	ES	Futures	3061.64	3062.46	3046.82	3051.21	33449.0
2020-04-16 08:00:00	ES	Futures	3051.76	3073.44	3044.63	3060.82	83738.0
2020-04-16 09:00:00	ES	Futures	3060.82	3067.95	3033.92	3035.57	168559.0
2020-04-16 10:00:00	ES	Futures	3035.57	3055.33	3023.77	3053.96	225325.0
2020-04-16 11:00:00	ES	Futures	3053.96	3070.97	3050.39	3067.4	174266.0
2020-04-16 12:00:00	ES	Futures	3067.4	3070.42	3024.32	3039.69	202487.0
2020-04-16 13:00:00	ES	Futures	3039.96	3050.39	3036.67	3042.16	120086.0
2020-04-16 14:00:00	ES	Futures	3042.43	3059.17	3034.75	3051.76	128852.0
2020-04-16 15:00:00	ES	Futures	3051.76	3069.87	3042.98	3061.09	228295.0
2020-04-16 16:00:00	ES	Futures	3061.09	3108.02	3057.52	3106.1	87132.0
2020-04-16 18:00:00	ES	Futures	3142.59	3162.08	3130.24	3157.14	77438.0
2020-04-16 19:00:00	ES	Futures	3157.14	3166.74	3139.3	3149.73	50945.0
2020-04-16 20:00:00	ES	Futures	3150.0	3155.49	3139.57	3151.65	29820.0
2020-04-16 21:00:00	ES	Futures	3151.92	3163.72	3150.0	3159.06	21488.0
2020-04-16 22:00:00	ES	Futures	3159.33	3163.72	3153.57	3157.96	14443.0
2020-04-16 23:00:00	ES	Futures	3158.51	3160.16	3147.81	3156.59	11530.0
2020-04-16 00:00:00	NQ	Futures	9757.2	9788.62	9757.2	9784.62	2813.0
2020-04-16 01:00:00	NQ	Futures	9784.62	9846.03	9760.63	9844.03	6085.0
2020-04-16 02:00:00	NQ	Futures	9841.75	9935.15	9821.75	9913.73	10409.0
2020-04-16 03:00:00	NQ	Futures	9914.87	9928.01	9873.45	9912.87	10573.0
2020-04-16 04:00:00	NQ	Futures	9912.02	9927.73	9895.45	9900.02	7263.0
2020-04-16 05:00:00	NQ	Futures	9900.02	9910.59	9872.88	9900.3	6807.0
2020-04-16 06:00:00	NQ	Futures	9901.16	9917.44	9866.88	9905.45	5832.0
2020-04-16 07:00:00	NQ	Futures	9904.02	9904.3	9853.17	9872.88	9157.0
2020-04-16 08:00:00	NQ	Futures	9872.03	9938.58	9848.89	9915.44	18983.0
2020-04-16 09:00:00	NQ	Futures	9915.44	9938.01	9871.17	9874.88	51914.0
2020-04-16 10:00:00	NQ	Futures	9875.17	9956.29	9816.61	9947.44	72734.0
2020-04-16 11:00:00	NQ	Futures	9946.86	10034.84	9932.01	10024.27	62545.0
2020-04-16 12:00:00	NQ	Futures	10024.27	10037.98	9832.04	9896.31	73196.0
2020-04-16 13:00:00	NQ	Futures	9896.31	9934.3	9876.03	9898.31	40724.0
2020-04-16 14:00:00	NQ	Futures	9899.45	9966.57	9872.31	9941.44	40743.0
2020-04-16 15:00:00	NQ	Futures	9941.15	10015.7	9902.02	9989.71	61395.0
2020-04-16 16:00:00	NQ	Futures	9990.57	10103.11	9975.71	10098.54	17217.0
2020-04-16 18:00:00	NQ	Futures	10179.95	10211.08	10141.39	10193.66	12919.0
2020-04-16 19:00:00	NQ	Futures	10194.23	10245.07	10176.8	10207.08	12084.0
2020-04-16 20:00:00	NQ	Futures	10207.37	10207.37	10147.38	10175.09	8291.0
2020-04-16 21:00:00	NQ	Futures	10175.95	10207.65	10173.66	10195.66	6058.0
2020-04-16 22:00:00	NQ	Futures	10195.94	10224.22	10178.8	10199.08	5213.0
2020-04-16 23:00:00	NQ	Futures	10199.08	10199.08	10159.09	10186.8	4626.0
2020-04-16 00:00:00	YM	Futures	25482.6	25552.7	25477.1	25536.2	1426.0
2020-04-16 01:00:00	YM	Futures	25538.4	25712.6	25474.9	25710.4	3719.0
2020-04-16 02:00:00	YM	Futures	25704.9	25915.2	25632.6	25849.5	7317.0
2020-04-16 03:00:00	YM	Futures	25849.5	25890.0	25719.2	25802.4	7508.0

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

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