PREVIEW / futures_1hour / 2020-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-24.parquet
  size:    52 KB
  rows:    1,503

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-24 00:00:00	ES	Futures	3036.12	3040.78	3032.83	3033.92	4130.0
2020-04-24 01:00:00	ES	Futures	3034.2	3038.86	3024.32	3034.2	9123.0
2020-04-24 02:00:00	ES	Futures	3034.47	3049.02	3028.71	3049.02	18312.0
2020-04-24 03:00:00	ES	Futures	3049.02	3051.21	3039.96	3048.74	26657.0
2020-04-24 04:00:00	ES	Futures	3049.02	3049.29	3038.32	3046.27	14893.0
2020-04-24 05:00:00	ES	Futures	3046.55	3070.15	3046.27	3064.93	30154.0
2020-04-24 06:00:00	ES	Futures	3065.21	3080.3	3061.64	3079.48	25236.0
2020-04-24 07:00:00	ES	Futures	3079.48	3081.12	3068.5	3069.87	30790.0
2020-04-24 08:00:00	ES	Futures	3069.87	3086.34	3066.31	3078.38	46563.0
2020-04-24 09:00:00	ES	Futures	3078.38	3085.24	3056.98	3058.35	131741.0
2020-04-24 10:00:00	ES	Futures	3058.35	3074.81	3057.25	3066.03	151936.0
2020-04-24 11:00:00	ES	Futures	3066.03	3067.68	3053.96	3063.84	124730.0
2020-04-24 12:00:00	ES	Futures	3063.56	3076.73	3059.99	3073.17	65903.0
2020-04-24 13:00:00	ES	Futures	3073.17	3088.26	3068.23	3087.44	80604.0
2020-04-24 14:00:00	ES	Futures	3087.44	3098.69	3084.14	3095.39	124842.0
2020-04-24 15:00:00	ES	Futures	3095.12	3111.86	3090.73	3104.17	234442.0
2020-04-24 16:00:00	ES	Futures	3103.9	3108.02	3101.16	3104.17	60733.0
2020-04-24 00:00:00	NQ	Futures	9753.77	9772.91	9747.77	9754.06	1906.0
2020-04-24 01:00:00	NQ	Futures	9753.49	9761.48	9717.49	9751.2	3604.0
2020-04-24 02:00:00	NQ	Futures	9751.2	9790.05	9725.49	9786.91	6140.0
2020-04-24 03:00:00	NQ	Futures	9786.91	9807.47	9766.34	9787.48	8285.0
2020-04-24 04:00:00	NQ	Futures	9788.33	9790.05	9760.06	9783.48	5793.0
2020-04-24 05:00:00	NQ	Futures	9783.19	9867.74	9783.19	9850.32	9877.0
2020-04-24 06:00:00	NQ	Futures	9850.32	9898.02	9838.89	9897.73	7441.0
2020-04-24 07:00:00	NQ	Futures	9898.02	9901.45	9858.89	9864.89	7832.0
2020-04-24 08:00:00	NQ	Futures	9865.46	9910.3	9851.17	9889.74	12564.0
2020-04-24 09:00:00	NQ	Futures	9888.59	9902.59	9806.61	9812.04	48923.0
2020-04-24 10:00:00	NQ	Futures	9812.9	9906.02	9812.33	9870.31	54527.0
2020-04-24 11:00:00	NQ	Futures	9870.03	9891.45	9837.18	9880.31	37988.0
2020-04-24 12:00:00	NQ	Futures	9881.45	9932.58	9866.31	9921.73	25597.0
2020-04-24 13:00:00	NQ	Futures	9921.16	9963.72	9901.73	9961.15	26745.0
2020-04-24 14:00:00	NQ	Futures	9961.15	9992.0	9954.58	9980.28	33654.0
2020-04-24 15:00:00	NQ	Futures	9980.0	10031.98	9964.0	10021.13	48983.0
2020-04-24 16:00:00	NQ	Futures	10020.84	10029.7	10010.28	10013.13	11219.0
2020-04-24 00:00:00	YM	Futures	25461.8	25509.9	25444.2	25456.3	1528.0
2020-04-24 01:00:00	YM	Futures	25455.2	25480.4	25374.1	25442.0	2510.0
2020-04-24 02:00:00	YM	Futures	25440.9	25574.6	25393.8	25570.2	4460.0
2020-04-24 03:00:00	YM	Futures	25570.2	25588.8	25494.6	25548.3	5916.0
2020-04-24 04:00:00	YM	Futures	25552.7	25555.9	25459.6	25519.8	3623.0
2020-04-24 05:00:00	YM	Futures	25519.8	25696.1	25517.6	25646.9	6693.0
2020-04-24 06:00:00	YM	Futures	25648.0	25783.8	25626.0	25779.4	5307.0
2020-04-24 07:00:00	YM	Futures	25780.5	25801.3	25717.0	25727.9	5363.0
2020-04-24 08:00:00	YM	Futures	25730.1	25823.2	25686.3	25760.8	6575.0
2020-04-24 09:00:00	YM	Futures	25758.6	25853.9	25614.0	25621.7	19030.0
2020-04-24 10:00:00	YM	Futures	25620.6	25700.5	25593.2	25629.3	20238.0
2020-04-24 11:00:00	YM	Futures	25626.0	25635.9	25522.0	25598.7	14998.0
2020-04-24 12:00:00	YM	Futures	25596.5	25695.1	25581.1	25666.6	8849.0
2020-04-24 13:00:00	YM	Futures	25665.5	25777.2	25614.0	25773.9	8699.0
2020-04-24 14:00:00	YM	Futures	25772.8	25867.0	25747.6	25841.8	13761.0
2020-04-24 15:00:00	YM	Futures	25840.7	25991.9	25804.6	25915.2	20478.0

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

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