PREVIEW / futures_1hour / 2019-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-19.parquet
  size:    57 KB
  rows:    1,822

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-19 00:00:00	ES	Futures	3466.0	3467.0	3465.4	3466.8	3977.0
2019-12-19 01:00:00	ES	Futures	3467.0	3468.1	3466.8	3467.9	4466.0
2019-12-19 02:00:00	ES	Futures	3467.6	3467.9	3466.5	3467.6	5881.0
2019-12-19 03:00:00	ES	Futures	3467.6	3469.8	3464.1	3466.8	19264.0
2019-12-19 04:00:00	ES	Futures	3466.8	3470.3	3466.5	3470.3	12880.0
2019-12-19 05:00:00	ES	Futures	3470.3	3470.6	3468.4	3470.0	11240.0
2019-12-19 06:00:00	ES	Futures	3470.0	3470.6	3467.3	3468.7	7028.0
2019-12-19 07:00:00	ES	Futures	3468.9	3469.2	3464.1	3465.2	15097.0
2019-12-19 08:00:00	ES	Futures	3465.2	3465.7	3462.7	3464.6	22074.0
2019-12-19 09:00:00	ES	Futures	3464.6	3470.3	3464.1	3468.4	108028.0
2019-12-19 10:00:00	ES	Futures	3468.4	3471.7	3466.8	3470.3	111973.0
2019-12-19 11:00:00	ES	Futures	3470.3	3476.5	3470.0	3474.4	113087.0
2019-12-19 12:00:00	ES	Futures	3474.6	3477.6	3474.1	3475.2	61017.0
2019-12-19 13:00:00	ES	Futures	3475.2	3478.4	3474.1	3477.9	57504.0
2019-12-19 14:00:00	ES	Futures	3477.9	3480.1	3477.3	3478.7	50402.0
2019-12-19 15:00:00	ES	Futures	3479.0	3480.6	3474.1	3479.8	165664.0
2019-12-19 16:00:00	ES	Futures	3480.1	3483.6	3478.7	3482.5	59082.0
2019-12-19 18:00:00	ES	Futures	3483.3	3483.6	3481.4	3483.0	7210.0
2019-12-19 19:00:00	ES	Futures	3483.0	3483.3	3480.9	3481.7	8501.0
2019-12-19 20:00:00	ES	Futures	3481.7	3482.0	3479.8	3481.7	9041.0
2019-12-19 21:00:00	ES	Futures	3482.0	3482.0	3480.3	3481.4	4675.0
2019-12-19 22:00:00	ES	Futures	3481.4	3482.0	3480.6	3481.1	5016.0
2019-12-19 23:00:00	ES	Futures	3481.1	3481.4	3480.1	3480.3	3615.0
2019-12-19 00:00:00	NQ	Futures	9965.2	9968.38	9964.04	9968.09	1188.0
2019-12-19 01:00:00	NQ	Futures	9968.09	9973.01	9967.8	9971.56	1926.0
2019-12-19 02:00:00	NQ	Futures	9971.56	9972.43	9967.51	9972.14	2874.0
2019-12-19 03:00:00	NQ	Futures	9972.43	9976.48	9957.68	9965.49	8246.0
2019-12-19 04:00:00	NQ	Futures	9965.49	9976.77	9964.91	9975.9	5006.0
2019-12-19 05:00:00	NQ	Futures	9975.9	9977.06	9968.09	9976.48	4747.0
2019-12-19 06:00:00	NQ	Futures	9976.77	9977.63	9967.51	9972.43	2824.0
2019-12-19 07:00:00	NQ	Futures	9972.43	9973.88	9959.13	9962.89	5097.0
2019-12-19 08:00:00	NQ	Futures	9962.6	9967.22	9957.97	9966.07	7250.0
2019-12-19 09:00:00	NQ	Futures	9966.07	9989.49	9964.91	9983.13	37798.0
2019-12-19 10:00:00	NQ	Futures	9983.13	9993.83	9975.9	9988.04	33928.0
2019-12-19 11:00:00	NQ	Futures	9987.76	10012.91	9987.47	10008.58	29887.0
2019-12-19 12:00:00	NQ	Futures	10008.58	10014.36	10003.08	10006.26	18608.0
2019-12-19 13:00:00	NQ	Futures	10005.97	10013.78	10001.64	10012.34	17484.0
2019-12-19 14:00:00	NQ	Futures	10012.34	10022.17	10010.31	10018.7	17325.0
2019-12-19 15:00:00	NQ	Futures	10018.99	10032.29	10011.47	10029.69	36088.0
2019-12-19 16:00:00	NQ	Futures	10029.69	10042.99	10025.06	10040.67	11175.0
2019-12-19 18:00:00	NQ	Futures	10039.52	10041.54	10035.18	10040.1	2291.0
2019-12-19 19:00:00	NQ	Futures	10040.1	10041.83	10034.02	10036.05	2724.0
2019-12-19 20:00:00	NQ	Futures	10036.05	10037.78	10027.66	10034.89	3901.0
2019-12-19 21:00:00	NQ	Futures	10035.18	10035.76	10031.42	10035.18	1802.0
2019-12-19 22:00:00	NQ	Futures	10035.47	10037.2	10033.16	10034.31	1565.0
2019-12-19 23:00:00	NQ	Futures	10034.31	10034.89	10029.11	10030.26	1616.0
2019-12-19 00:00:00	YM	Futures	30771.1	30779.8	30766.8	30778.7	625.0
2019-12-19 01:00:00	YM	Futures	30778.7	30788.5	30778.7	30784.2	839.0
2019-12-19 02:00:00	YM	Futures	30784.2	30786.4	30777.7	30783.1	1494.0
2019-12-19 03:00:00	YM	Futures	30782.0	30809.2	30764.6	30788.5	9554.0

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

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