PREVIEW / futures_1hour / 2021-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-07.parquet
  size:    60 KB
  rows:    1,894

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
2021-06-07 00:00:00	ES	Futures	4745.85	4748.1	4744.17	4746.13	3262.0
2021-06-07 01:00:00	ES	Futures	4746.41	4747.26	4743.32	4743.89	3975.0
2021-06-07 02:00:00	ES	Futures	4744.17	4745.85	4742.48	4745.85	5817.0
2021-06-07 03:00:00	ES	Futures	4745.85	4745.85	4736.02	4744.17	19371.0
2021-06-07 04:00:00	ES	Futures	4743.89	4747.26	4740.23	4746.7	8726.0
2021-06-07 05:00:00	ES	Futures	4746.7	4747.26	4739.11	4742.2	11240.0
2021-06-07 06:00:00	ES	Futures	4742.48	4747.54	4741.36	4745.85	11674.0
2021-06-07 07:00:00	ES	Futures	4745.85	4753.72	4745.57	4752.6	19299.0
2021-06-07 08:00:00	ES	Futures	4752.6	4756.81	4750.35	4755.41	18333.0
2021-06-07 09:00:00	ES	Futures	4755.41	4755.69	4745.01	4748.1	119600.0
2021-06-07 10:00:00	ES	Futures	4747.82	4748.38	4737.7	4742.76	151165.0
2021-06-07 11:00:00	ES	Futures	4742.76	4744.73	4737.14	4740.23	103845.0
2021-06-07 12:00:00	ES	Futures	4740.51	4743.89	4739.67	4742.2	53125.0
2021-06-07 13:00:00	ES	Futures	4742.48	4743.61	4736.58	4737.14	64300.0
2021-06-07 14:00:00	ES	Futures	4737.14	4745.57	4736.86	4743.61	61641.0
2021-06-07 15:00:00	ES	Futures	4743.89	4750.35	4743.32	4748.66	144098.0
2021-06-07 16:00:00	ES	Futures	4748.66	4751.19	4748.38	4750.91	36233.0
2021-06-07 18:00:00	ES	Futures	4751.19	4751.75	4748.38	4748.66	3959.0
2021-06-07 19:00:00	ES	Futures	4748.38	4753.44	4748.38	4749.22	5666.0
2021-06-07 20:00:00	ES	Futures	4749.22	4757.09	4748.38	4756.53	10328.0
2021-06-07 21:00:00	ES	Futures	4756.53	4759.34	4754.0	4755.97	8176.0
2021-06-07 22:00:00	ES	Futures	4755.97	4757.09	4749.22	4749.51	7960.0
2021-06-07 23:00:00	ES	Futures	4749.51	4752.88	4749.22	4750.91	5199.0
2021-06-07 00:00:00	NQ	Futures	15918.48	15923.4	15911.24	15915.58	1607.0
2021-06-07 01:00:00	NQ	Futures	15916.16	15920.21	15899.37	15906.03	2469.0
2021-06-07 02:00:00	NQ	Futures	15906.9	15917.61	15901.98	15912.69	2831.0
2021-06-07 03:00:00	NQ	Futures	15912.4	15918.77	15876.21	15898.21	10368.0
2021-06-07 04:00:00	NQ	Futures	15897.92	15902.84	15871.87	15899.95	5733.0
2021-06-07 05:00:00	NQ	Futures	15899.95	15901.11	15854.5	15872.45	9209.0
2021-06-07 06:00:00	NQ	Futures	15872.45	15890.98	15865.79	15877.66	6275.0
2021-06-07 07:00:00	NQ	Futures	15877.37	15933.53	15877.08	15925.14	11430.0
2021-06-07 08:00:00	NQ	Futures	15924.85	15944.53	15913.27	15932.37	10833.0
2021-06-07 09:00:00	NQ	Futures	15932.08	15939.03	15888.37	15928.03	64445.0
2021-06-07 10:00:00	NQ	Futures	15927.74	15930.64	15878.82	15924.85	65144.0
2021-06-07 11:00:00	NQ	Futures	15924.85	15926.29	15884.03	15911.24	47505.0
2021-06-07 12:00:00	NQ	Futures	15911.24	15938.74	15910.66	15931.5	24841.0
2021-06-07 13:00:00	NQ	Futures	15931.5	15940.77	15902.27	15909.5	25373.0
2021-06-07 14:00:00	NQ	Futures	15909.5	15963.64	15908.06	15954.95	24562.0
2021-06-07 15:00:00	NQ	Futures	15954.95	15989.98	15952.35	15983.03	45044.0
2021-06-07 16:00:00	NQ	Futures	15983.03	16007.93	15981.3	16006.48	7835.0
2021-06-07 18:00:00	NQ	Futures	16006.77	16010.54	15994.04	15996.93	2414.0
2021-06-07 19:00:00	NQ	Futures	15996.35	16020.09	15996.35	16005.9	3610.0
2021-06-07 20:00:00	NQ	Futures	16006.48	16033.7	16003.3	16031.96	5962.0
2021-06-07 21:00:00	NQ	Futures	16032.25	16055.99	16030.8	16041.51	5879.0
2021-06-07 22:00:00	NQ	Futures	16042.67	16047.01	16014.3	16019.51	3935.0
2021-06-07 23:00:00	NQ	Futures	16019.51	16027.62	16010.25	16019.8	3081.0
2021-06-07 00:00:00	YM	Futures	38667.3	38689.6	38657.3	38680.7	478.0
2021-06-07 01:00:00	YM	Futures	38679.6	38690.7	38659.5	38668.4	979.0
2021-06-07 02:00:00	YM	Futures	38667.3	38678.5	38648.4	38677.3	1230.0
2021-06-07 03:00:00	YM	Futures	38676.2	38678.5	38594.9	38665.1	3687.0

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

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