PREVIEW / futures_1hour / 2020-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-03.parquet
  size:    34 KB
  rows:    1,012

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-07-03 00:00:00	ES	Futures	3491.1	3491.66	3486.63	3488.31	4056.0
2020-07-03 01:00:00	ES	Futures	3488.31	3493.62	3485.24	3493.06	5541.0
2020-07-03 02:00:00	ES	Futures	3493.06	3505.9	3493.06	3501.99	11734.0
2020-07-03 03:00:00	ES	Futures	3502.27	3504.23	3494.17	3496.69	15138.0
2020-07-03 04:00:00	ES	Futures	3496.69	3499.2	3491.1	3496.41	12487.0
2020-07-03 05:00:00	ES	Futures	3496.41	3497.53	3486.08	3486.36	14656.0
2020-07-03 06:00:00	ES	Futures	3486.36	3489.71	3483.0	3489.15	12773.0
2020-07-03 07:00:00	ES	Futures	3488.87	3490.26	3481.05	3483.0	10624.0
2020-07-03 08:00:00	ES	Futures	3482.73	3485.52	3479.09	3481.33	10192.0
2020-07-03 09:00:00	ES	Futures	3481.33	3486.36	3479.65	3484.68	11983.0
2020-07-03 10:00:00	ES	Futures	3484.96	3486.36	3469.04	3475.46	26081.0
2020-07-03 11:00:00	ES	Futures	3475.74	3481.05	3472.11	3479.09	15680.0
2020-07-03 12:00:00	ES	Futures	3478.82	3483.56	3477.98	3479.93	6473.0
2020-07-03 00:00:00	NQ	Futures	11976.62	11977.2	11964.47	11972.28	946.0
2020-07-03 01:00:00	NQ	Futures	11971.41	11990.5	11964.18	11988.76	1806.0
2020-07-03 02:00:00	NQ	Futures	11989.34	12017.97	11989.34	12005.25	4841.0
2020-07-03 03:00:00	NQ	Futures	12004.96	12014.21	11996.28	12003.51	5536.0
2020-07-03 04:00:00	NQ	Futures	12002.93	12008.14	11987.61	12002.93	3824.0
2020-07-03 05:00:00	NQ	Futures	12002.64	12008.72	11984.43	11985.29	3701.0
2020-07-03 06:00:00	NQ	Futures	11984.72	11990.21	11977.77	11986.45	3261.0
2020-07-03 07:00:00	NQ	Futures	11986.16	11986.45	11967.08	11972.28	2653.0
2020-07-03 08:00:00	NQ	Futures	11972.28	11976.62	11961.87	11964.47	3951.0
2020-07-03 09:00:00	NQ	Futures	11964.47	11980.96	11962.16	11975.75	6049.0
2020-07-03 10:00:00	NQ	Futures	11975.75	11976.91	11924.28	11948.28	9718.0
2020-07-03 11:00:00	NQ	Futures	11947.99	11963.32	11941.63	11952.04	5651.0
2020-07-03 12:00:00	NQ	Futures	11951.46	11975.46	11944.23	11944.23	3556.0
2020-07-03 00:00:00	YM	Futures	28336.7	28343.3	28291.6	28318.0	1342.0
2020-07-03 01:00:00	YM	Futures	28315.8	28358.8	28269.6	28358.8	2391.0
2020-07-03 02:00:00	YM	Futures	28356.6	28494.2	28355.5	28456.8	5521.0
2020-07-03 03:00:00	YM	Futures	28456.8	28476.6	28365.4	28401.7	10720.0
2020-07-03 04:00:00	YM	Futures	28402.8	28419.3	28336.7	28373.1	4018.0
2020-07-03 05:00:00	YM	Futures	28375.3	28384.1	28266.3	28275.1	4295.0
2020-07-03 06:00:00	YM	Futures	28275.1	28326.8	28246.4	28323.5	5099.0
2020-07-03 07:00:00	YM	Futures	28322.4	28330.1	28246.4	28268.5	2784.0
2020-07-03 08:00:00	YM	Futures	28266.3	28293.8	28217.8	28237.6	3249.0
2020-07-03 09:00:00	YM	Futures	28238.7	28294.9	28229.9	28279.5	4081.0
2020-07-03 10:00:00	YM	Futures	28280.6	28312.5	28010.8	28165.0	10447.0
2020-07-03 11:00:00	YM	Futures	28165.0	28192.5	28119.8	28187.0	3836.0
2020-07-03 12:00:00	YM	Futures	28187.0	28247.5	28185.9	28214.5	2148.0
2020-07-03 00:00:00	CL	Futures	28.29	28.3	28.17	28.2	1873.0
2020-07-03 01:00:00	CL	Futures	28.19	28.24	28.12	28.18	2723.0
2020-07-03 02:00:00	CL	Futures	28.18	28.32	28.17	28.27	3278.0
2020-07-03 03:00:00	CL	Futures	28.28	28.33	28.1	28.18	6592.0
2020-07-03 04:00:00	CL	Futures	28.19	28.21	28.07	28.14	6316.0
2020-07-03 05:00:00	CL	Futures	28.14	28.17	27.99	28.05	5394.0
2020-07-03 06:00:00	CL	Futures	28.04	28.2	27.97	28.17	6226.0
2020-07-03 07:00:00	CL	Futures	28.17	28.19	28.05	28.18	3801.0
2020-07-03 08:00:00	CL	Futures	28.18	28.23	28.1	28.14	4418.0
2020-07-03 09:00:00	CL	Futures	28.13	28.21	28.07	28.1	4860.0
2020-07-03 10:00:00	CL	Futures	28.1	28.16	27.95	28.14	6844.0

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

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