PREVIEW / futures_1hour / 2020-04-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	3151.65	3154.67	3144.79	3147.53	6242.0
2020-04-20 01:00:00	ES	Futures	3147.26	3148.36	3131.62	3133.81	9929.0
2020-04-20 02:00:00	ES	Futures	3133.81	3139.3	3128.6	3138.48	13279.0
2020-04-20 03:00:00	ES	Futures	3138.75	3139.57	3118.72	3134.36	27289.0
2020-04-20 04:00:00	ES	Futures	3134.09	3134.09	3120.09	3126.13	16741.0
2020-04-20 05:00:00	ES	Futures	3126.13	3130.24	3112.13	3113.78	20246.0
2020-04-20 06:00:00	ES	Futures	3113.78	3114.88	3096.49	3100.33	37866.0
2020-04-20 07:00:00	ES	Futures	3100.33	3106.1	3082.22	3086.34	55163.0
2020-04-20 08:00:00	ES	Futures	3086.06	3095.67	3082.77	3090.45	54686.0
2020-04-20 09:00:00	ES	Futures	3090.73	3114.05	3087.16	3106.92	157586.0
2020-04-20 10:00:00	ES	Futures	3106.92	3132.16	3101.43	3126.95	168337.0
2020-04-20 11:00:00	ES	Futures	3126.95	3140.12	3122.01	3136.01	130160.0
2020-04-20 12:00:00	ES	Futures	3135.73	3137.1	3127.23	3130.24	97891.0
2020-04-20 13:00:00	ES	Futures	3130.24	3130.79	3115.7	3123.93	96846.0
2020-04-20 14:00:00	ES	Futures	3123.66	3127.23	3088.81	3089.36	165772.0
2020-04-20 15:00:00	ES	Futures	3089.36	3104.17	3085.24	3087.98	261598.0
2020-04-20 16:00:00	ES	Futures	3088.26	3092.1	3078.11	3086.06	70264.0
2020-04-20 18:00:00	ES	Futures	3081.12	3101.98	3080.58	3098.96	15014.0
2020-04-20 19:00:00	ES	Futures	3098.69	3103.63	3086.06	3092.37	10528.0
2020-04-20 20:00:00	ES	Futures	3092.65	3105.0	3083.59	3097.86	18221.0
2020-04-20 21:00:00	ES	Futures	3097.86	3109.94	3091.0	3093.47	15359.0
2020-04-20 22:00:00	ES	Futures	3093.47	3098.96	3042.98	3065.48	47739.0
2020-04-20 23:00:00	ES	Futures	3065.21	3070.15	3056.15	3061.91	14505.0
2020-04-20 00:00:00	NQ	Futures	10073.97	10088.54	10054.55	10064.26	3681.0
2020-04-20 01:00:00	NQ	Futures	10063.12	10067.12	10021.7	10028.56	5163.0
2020-04-20 02:00:00	NQ	Futures	10027.99	10043.41	10009.7	10041.7	5638.0
2020-04-20 03:00:00	NQ	Futures	10043.7	10045.12	9984.28	10030.84	10667.0
2020-04-20 04:00:00	NQ	Futures	10030.56	10034.27	9989.71	10010.28	8046.0
2020-04-20 05:00:00	NQ	Futures	10011.42	10026.56	9988.57	9992.57	6856.0
2020-04-20 06:00:00	NQ	Futures	9992.85	9995.42	9946.58	9968.57	10909.0
2020-04-20 07:00:00	NQ	Futures	9968.29	9986.85	9936.01	9956.86	14832.0
2020-04-20 08:00:00	NQ	Futures	9957.43	9983.71	9945.72	9964.86	15186.0
2020-04-20 09:00:00	NQ	Futures	9964.86	10037.13	9949.43	9986.57	54603.0
2020-04-20 10:00:00	NQ	Futures	9986.85	10086.26	9976.28	10074.55	53897.0
2020-04-20 11:00:00	NQ	Futures	10074.55	10107.11	10057.41	10092.26	41279.0
2020-04-20 12:00:00	NQ	Futures	10092.83	10096.25	10065.4	10079.12	24928.0
2020-04-20 13:00:00	NQ	Futures	10078.54	10080.54	10031.98	10075.4	27461.0
2020-04-20 14:00:00	NQ	Futures	10074.83	10086.83	9975.71	9979.71	41130.0
2020-04-20 15:00:00	NQ	Futures	9979.14	10012.56	9951.43	9954.01	54126.0
2020-04-20 16:00:00	NQ	Futures	9954.58	9969.72	9925.44	9955.43	12980.0
2020-04-20 18:00:00	NQ	Futures	9934.58	9997.99	9934.58	9988.57	5460.0
2020-04-20 19:00:00	NQ	Futures	9988.85	10000.56	9959.15	9974.86	4160.0
2020-04-20 20:00:00	NQ	Futures	9975.14	10002.56	9940.29	9983.43	7577.0
2020-04-20 21:00:00	NQ	Futures	9984.57	10012.28	9955.43	9961.15	7836.0
2020-04-20 22:00:00	NQ	Futures	9962.0	9975.43	9829.18	9887.17	17254.0
2020-04-20 23:00:00	NQ	Futures	9887.17	9899.73	9863.46	9880.02	6081.0
2020-04-20 00:00:00	YM	Futures	26444.3	26470.5	26404.8	26423.4	2024.0
2020-04-20 01:00:00	YM	Futures	26423.4	26428.9	26307.3	26321.6	3293.0
2020-04-20 02:00:00	YM	Futures	26320.5	26366.5	26266.8	26359.9	3697.0
2020-04-20 03:00:00	YM	Futures	26361.0	26366.5	26180.3	26303.0	7128.0

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

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