PREVIEW / futures_1hour / 2019-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-20.parquet
  size:    60 KB
  rows:    1,858

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-06-20 00:00:00	ES	Futures	3188.36	3188.91	3187.28	3188.91	3909.0
2019-06-20 01:00:00	ES	Futures	3188.91	3189.99	3187.55	3188.64	8284.0
2019-06-20 02:00:00	ES	Futures	3188.64	3194.59	3187.82	3193.51	19441.0
2019-06-20 03:00:00	ES	Futures	3193.51	3197.57	3193.51	3195.13	35050.0
2019-06-20 04:00:00	ES	Futures	3194.86	3201.63	3194.59	3200.0	28991.0
2019-06-20 05:00:00	ES	Futures	3200.0	3205.15	3199.73	3204.34	22478.0
2019-06-20 06:00:00	ES	Futures	3204.34	3204.61	3200.82	3201.63	15879.0
2019-06-20 07:00:00	ES	Futures	3201.63	3207.04	3201.09	3205.15	27268.0
2019-06-20 08:00:00	ES	Futures	3205.15	3210.02	3204.88	3207.31	46179.0
2019-06-20 09:00:00	ES	Futures	3207.31	3209.21	3200.82	3202.98	214220.0
2019-06-20 10:00:00	ES	Futures	3203.25	3205.96	3193.78	3194.05	252392.0
2019-06-20 11:00:00	ES	Futures	3194.05	3197.03	3189.72	3194.05	166102.0
2019-06-20 12:00:00	ES	Futures	3194.05	3194.32	3178.89	3190.26	219430.0
2019-06-20 13:00:00	ES	Futures	3190.26	3196.76	3189.18	3194.05	96933.0
2019-06-20 14:00:00	ES	Futures	3193.78	3200.0	3192.7	3199.46	89614.0
2019-06-20 15:00:00	ES	Futures	3199.46	3208.67	3196.49	3203.52	222902.0
2019-06-20 16:00:00	ES	Futures	3203.25	3206.5	3201.9	3203.25	77826.0
2019-06-20 18:00:00	ES	Futures	3202.71	3203.25	3200.0	3200.82	8199.0
2019-06-20 19:00:00	ES	Futures	3201.09	3203.52	3199.46	3202.71	4950.0
2019-06-20 20:00:00	ES	Futures	3202.71	3204.88	3200.0	3202.17	12324.0
2019-06-20 21:00:00	ES	Futures	3202.17	3202.98	3199.19	3199.46	14119.0
2019-06-20 22:00:00	ES	Futures	3199.73	3201.63	3196.76	3197.84	15390.0
2019-06-20 23:00:00	ES	Futures	3198.11	3198.65	3194.86	3196.49	12859.0
2019-06-20 00:00:00	NQ	Futures	9008.92	9010.08	9002.54	9009.79	1693.0
2019-06-20 01:00:00	NQ	Futures	9009.79	9009.79	8998.19	8999.93	3541.0
2019-06-20 02:00:00	NQ	Futures	8999.35	9026.04	8996.74	9020.53	8254.0
2019-06-20 03:00:00	NQ	Futures	9021.4	9038.52	9019.95	9026.91	9769.0
2019-06-20 04:00:00	NQ	Futures	9026.62	9044.9	9022.56	9042.0	8376.0
2019-06-20 05:00:00	NQ	Futures	9041.71	9055.06	9040.55	9047.22	6306.0
2019-06-20 06:00:00	NQ	Futures	9047.22	9055.06	9042.29	9043.74	5180.0
2019-06-20 07:00:00	NQ	Futures	9043.74	9061.15	9042.0	9050.41	6878.0
2019-06-20 08:00:00	NQ	Futures	9050.12	9076.82	9049.83	9064.92	13639.0
2019-06-20 09:00:00	NQ	Futures	9065.21	9073.33	9022.85	9041.13	72334.0
2019-06-20 10:00:00	NQ	Futures	9041.13	9050.12	8998.19	9000.22	76160.0
2019-06-20 11:00:00	NQ	Futures	9000.51	9016.18	8980.2	8997.9	51777.0
2019-06-20 12:00:00	NQ	Futures	8997.9	8999.93	8943.93	8978.17	60543.0
2019-06-20 13:00:00	NQ	Futures	8977.88	8997.03	8973.82	8981.94	28727.0
2019-06-20 14:00:00	NQ	Futures	8981.94	8996.45	8976.72	8993.25	22638.0
2019-06-20 15:00:00	NQ	Futures	8993.55	9025.17	8980.78	9009.5	48995.0
2019-06-20 16:00:00	NQ	Futures	9009.5	9026.33	9007.18	9010.95	13945.0
2019-06-20 18:00:00	NQ	Futures	9009.21	9010.66	9001.67	9005.73	2115.0
2019-06-20 19:00:00	NQ	Futures	9005.73	9014.15	8999.35	9010.37	1947.0
2019-06-20 20:00:00	NQ	Futures	9010.66	9018.5	9001.67	9009.21	3657.0
2019-06-20 21:00:00	NQ	Futures	9008.92	9011.24	8996.74	8997.9	6509.0
2019-06-20 22:00:00	NQ	Futures	8997.61	9004.86	8987.45	8991.51	4677.0
2019-06-20 23:00:00	NQ	Futures	8991.51	8994.13	8977.88	8985.71	4040.0
2019-06-20 00:00:00	YM	Futures	28946.0	28951.4	28936.2	28950.3	870.0
2019-06-20 01:00:00	YM	Futures	28949.3	28962.3	28935.1	28947.1	1401.0
2019-06-20 02:00:00	YM	Futures	28946.0	28999.3	28940.6	28988.4	3062.0
2019-06-20 03:00:00	YM	Futures	28989.5	29024.3	28988.4	29001.5	4318.0

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

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