PREVIEW / futures_1hour / 2019-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-17.parquet
  size:    56 KB
  rows:    1,840

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
2019-12-17 00:00:00	ES	Futures	3466.5	3469.8	3466.5	3469.5	4850.0
2019-12-17 01:00:00	ES	Futures	3469.5	3469.8	3468.1	3468.4	3936.0
2019-12-17 02:00:00	ES	Futures	3468.4	3471.1	3468.1	3469.5	9469.0
2019-12-17 03:00:00	ES	Futures	3469.8	3470.3	3463.5	3466.0	16205.0
2019-12-17 04:00:00	ES	Futures	3466.0	3466.5	3463.3	3465.4	9135.0
2019-12-17 05:00:00	ES	Futures	3465.4	3466.2	3460.0	3462.7	12735.0
2019-12-17 06:00:00	ES	Futures	3463.0	3464.9	3460.3	3464.9	9619.0
2019-12-17 07:00:00	ES	Futures	3464.6	3467.9	3464.3	3466.2	11609.0
2019-12-17 08:00:00	ES	Futures	3466.2	3472.5	3464.3	3470.0	27830.0
2019-12-17 09:00:00	ES	Futures	3469.8	3472.5	3464.3	3464.9	167868.0
2019-12-17 10:00:00	ES	Futures	3465.2	3470.8	3464.3	3466.2	137439.0
2019-12-17 11:00:00	ES	Futures	3466.2	3468.7	3464.6	3467.9	90632.0
2019-12-17 12:00:00	ES	Futures	3467.9	3470.0	3467.9	3469.2	54569.0
2019-12-17 13:00:00	ES	Futures	3469.5	3469.5	3465.4	3467.9	48043.0
2019-12-17 14:00:00	ES	Futures	3467.9	3468.9	3465.4	3467.3	71906.0
2019-12-17 15:00:00	ES	Futures	3467.0	3468.4	3462.7	3463.8	163721.0
2019-12-17 16:00:00	ES	Futures	3463.8	3464.6	3460.8	3461.6	51642.0
2019-12-17 18:00:00	ES	Futures	3460.5	3463.5	3460.5	3462.7	4366.0
2019-12-17 19:00:00	ES	Futures	3462.7	3463.5	3461.9	3462.2	3867.0
2019-12-17 20:00:00	ES	Futures	3462.4	3464.9	3461.6	3463.5	5781.0
2019-12-17 21:00:00	ES	Futures	3463.8	3464.6	3461.9	3462.2	4852.0
2019-12-17 22:00:00	ES	Futures	3462.2	3463.5	3462.2	3463.3	3052.0
2019-12-17 23:00:00	ES	Futures	3463.3	3464.3	3462.7	3463.0	2962.0
2019-12-17 00:00:00	NQ	Futures	9960.57	9973.3	9959.99	9971.27	2871.0
2019-12-17 01:00:00	NQ	Futures	9971.56	9972.14	9965.49	9966.36	1960.0
2019-12-17 02:00:00	NQ	Futures	9966.36	9978.21	9965.78	9972.14	3498.0
2019-12-17 03:00:00	NQ	Futures	9972.14	9974.74	9952.77	9959.42	7500.0
2019-12-17 04:00:00	NQ	Futures	9959.71	9961.15	9949.87	9956.81	4133.0
2019-12-17 05:00:00	NQ	Futures	9957.1	9960.57	9942.64	9950.16	4610.0
2019-12-17 06:00:00	NQ	Futures	9950.16	9952.77	9942.07	9951.9	5025.0
2019-12-17 07:00:00	NQ	Futures	9951.61	9961.15	9951.32	9954.21	5011.0
2019-12-17 08:00:00	NQ	Futures	9954.5	9974.74	9947.85	9967.22	9006.0
2019-12-17 09:00:00	NQ	Futures	9967.22	9976.77	9943.22	9944.96	51370.0
2019-12-17 10:00:00	NQ	Futures	9944.96	9963.47	9943.22	9949.58	36674.0
2019-12-17 11:00:00	NQ	Futures	9949.58	9957.68	9946.98	9953.34	22368.0
2019-12-17 12:00:00	NQ	Futures	9953.34	9961.44	9952.19	9959.13	13734.0
2019-12-17 13:00:00	NQ	Futures	9959.13	9960.57	9950.45	9959.13	12673.0
2019-12-17 14:00:00	NQ	Futures	9959.13	9962.31	9948.72	9956.81	17272.0
2019-12-17 15:00:00	NQ	Futures	9956.52	9960.57	9950.45	9953.92	26119.0
2019-12-17 16:00:00	NQ	Futures	9953.63	9956.52	9945.54	9950.16	7204.0
2019-12-17 18:00:00	NQ	Futures	9944.96	9953.63	9943.8	9951.32	1805.0
2019-12-17 19:00:00	NQ	Futures	9951.61	9954.5	9948.14	9950.74	2158.0
2019-12-17 20:00:00	NQ	Futures	9950.74	9957.68	9949.01	9955.66	2865.0
2019-12-17 21:00:00	NQ	Futures	9955.95	9958.55	9949.3	9950.45	1810.0
2019-12-17 22:00:00	NQ	Futures	9950.74	9952.77	9949.87	9951.32	1270.0
2019-12-17 23:00:00	NQ	Futures	9951.32	9954.21	9950.16	9950.74	989.0
2019-12-17 00:00:00	YM	Futures	30759.2	30785.3	30754.8	30782.0	1037.0
2019-12-17 01:00:00	YM	Futures	30782.0	30784.2	30765.7	30766.8	833.0
2019-12-17 02:00:00	YM	Futures	30765.7	30792.9	30763.5	30774.4	1637.0
2019-12-17 03:00:00	YM	Futures	30775.5	30779.8	30716.7	30740.6	4657.0

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

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