PREVIEW / futures_1hour / 2020-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-09.parquet
  size:    66 KB
  rows:    1,901

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-09 00:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	305.0
2020-03-09 01:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	324.0
2020-03-09 02:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	273.0
2020-03-09 03:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	2130.0
2020-03-09 04:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	1487.0
2020-03-09 05:00:00	ES	Futures	3055.7	3060.3	3055.7	3055.7	14910.0
2020-03-09 06:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	363.0
2020-03-09 07:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	227.0
2020-03-09 08:00:00	ES	Futures	3055.7	3055.7	3055.69	3055.69	710.0
2020-03-09 09:00:00	ES	Futures	3055.69	3055.69	2942.95	3027.5	158436.0
2020-03-09 10:00:00	ES	Futures	3027.23	3056.77	3011.51	3014.5	361186.0
2020-03-09 11:00:00	ES	Futures	3014.5	3074.11	3007.18	3058.67	268421.0
2020-03-09 12:00:00	ES	Futures	3058.4	3074.93	3018.02	3026.15	233120.0
2020-03-09 13:00:00	ES	Futures	3026.15	3037.26	2978.45	2983.33	201573.0
2020-03-09 14:00:00	ES	Futures	2983.6	3003.93	2957.32	2991.73	277166.0
2020-03-09 15:00:00	ES	Futures	2991.73	3020.46	2965.18	2965.45	465901.0
2020-03-09 16:00:00	ES	Futures	2965.72	2984.14	2949.19	2963.01	190845.0
2020-03-09 18:00:00	ES	Futures	2962.47	3000.4	2921.55	2996.07	63106.0
2020-03-09 19:00:00	ES	Futures	2996.61	3045.39	2994.98	3030.48	56715.0
2020-03-09 20:00:00	ES	Futures	3031.03	3051.35	2999.32	3050.54	51220.0
2020-03-09 21:00:00	ES	Futures	3050.54	3067.61	3040.51	3044.3	45155.0
2020-03-09 22:00:00	ES	Futures	3044.03	3052.71	3032.65	3049.18	21100.0
2020-03-09 23:00:00	ES	Futures	3049.18	3055.96	3044.03	3055.14	20222.0
2020-03-09 00:00:00	NQ	Futures	9361.41	9361.98	9361.41	9361.41	250.0
2020-03-09 01:00:00	NQ	Futures	9361.41	9363.43	9361.41	9361.41	359.0
2020-03-09 02:00:00	NQ	Futures	9361.41	9362.56	9361.41	9361.41	228.0
2020-03-09 03:00:00	NQ	Futures	9361.41	9361.41	9361.41	9361.41	165.0
2020-03-09 04:00:00	NQ	Futures	9361.41	9361.41	9361.41	9361.41	277.0
2020-03-09 05:00:00	NQ	Futures	9361.41	9405.36	9361.41	9361.41	6160.0
2020-03-09 06:00:00	NQ	Futures	9361.41	9361.41	9361.41	9361.41	310.0
2020-03-09 07:00:00	NQ	Futures	9361.41	9361.41	9361.41	9361.41	179.0
2020-03-09 08:00:00	NQ	Futures	9361.41	9361.41	9361.41	9361.41	39.0
2020-03-09 09:00:00	NQ	Futures	9361.41	9361.41	9045.34	9335.09	20242.0
2020-03-09 10:00:00	NQ	Futures	9335.38	9458.57	9286.8	9324.39	79221.0
2020-03-09 11:00:00	NQ	Futures	9325.84	9509.17	9300.97	9476.79	67759.0
2020-03-09 12:00:00	NQ	Futures	9476.5	9531.44	9366.9	9391.19	49867.0
2020-03-09 13:00:00	NQ	Futures	9391.19	9432.25	9250.94	9267.14	47410.0
2020-03-09 14:00:00	NQ	Futures	9267.43	9332.2	9192.24	9285.64	70010.0
2020-03-09 15:00:00	NQ	Futures	9285.93	9362.27	9174.6	9176.34	88436.0
2020-03-09 16:00:00	NQ	Futures	9174.89	9209.01	9115.03	9155.23	33026.0
2020-03-09 18:00:00	NQ	Futures	9130.65	9285.35	9038.69	9269.74	15822.0
2020-03-09 19:00:00	NQ	Futures	9272.63	9414.33	9266.56	9379.91	15229.0
2020-03-09 20:00:00	NQ	Futures	9381.07	9438.9	9293.16	9436.3	15084.0
2020-03-09 21:00:00	NQ	Futures	9437.17	9485.75	9403.63	9411.14	12464.0
2020-03-09 22:00:00	NQ	Futures	9411.14	9440.64	9375.29	9434.57	8553.0
2020-03-09 23:00:00	NQ	Futures	9433.41	9471.87	9421.27	9466.67	6310.0
2020-03-09 00:00:00	YM	Futures	26772.2	26820.1	26745.0	26755.8	1443.0
2020-03-09 01:00:00	YM	Futures	26753.7	26783.1	26721.0	26755.8	1289.0
2020-03-09 02:00:00	YM	Futures	26760.2	26777.6	26711.2	26711.2	1467.0
2020-03-09 03:00:00	YM	Futures	26711.2	26711.2	26711.2	26711.2	168.0

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

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