PREVIEW / futures_1hour / 2019-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-20.parquet
  size:    48 KB
  rows:    1,483

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-20 00:00:00	ES	Futures	3480.6	3480.9	3479.8	3480.1	4631.0
2019-12-20 01:00:00	ES	Futures	3480.3	3480.6	3478.7	3478.7	5033.0
2019-12-20 02:00:00	ES	Futures	3478.7	3480.1	3477.9	3479.8	7370.0
2019-12-20 03:00:00	ES	Futures	3480.1	3481.4	3478.7	3480.9	20144.0
2019-12-20 04:00:00	ES	Futures	3480.9	3481.1	3478.4	3478.7	12807.0
2019-12-20 05:00:00	ES	Futures	3479.0	3482.0	3478.7	3481.4	20251.0
2019-12-20 06:00:00	ES	Futures	3481.4	3483.9	3481.1	3481.7	12925.0
2019-12-20 07:00:00	ES	Futures	3481.7	3483.6	3480.1	3483.0	15322.0
2019-12-20 08:00:00	ES	Futures	3483.0	3486.0	3482.8	3485.5	27815.0
2019-12-20 09:00:00	ES	Futures	3485.5	3495.5	3485.2	3492.0	271926.0
2019-12-20 10:00:00	ES	Futures	3491.7	3495.0	3490.4	3494.4	120496.0
2019-12-20 11:00:00	ES	Futures	3494.4	3499.8	3494.1	3497.9	120412.0
2019-12-20 12:00:00	ES	Futures	3497.9	3498.8	3496.0	3497.7	51919.0
2019-12-20 13:00:00	ES	Futures	3497.4	3499.0	3496.9	3497.1	40266.0
2019-12-20 14:00:00	ES	Futures	3497.1	3500.7	3495.8	3499.6	60787.0
2019-12-20 15:00:00	ES	Futures	3499.6	3499.8	3493.3	3494.7	264780.0
2019-12-20 16:00:00	ES	Futures	3494.7	3498.2	3493.3	3495.2	100937.0
2019-12-20 00:00:00	NQ	Futures	10030.55	10031.71	10027.66	10028.82	1638.0
2019-12-20 01:00:00	NQ	Futures	10028.82	10029.97	10025.06	10026.5	1635.0
2019-12-20 02:00:00	NQ	Futures	10026.22	10030.26	10023.61	10028.82	2516.0
2019-12-20 03:00:00	NQ	Futures	10028.82	10033.73	10023.03	10030.84	7588.0
2019-12-20 04:00:00	NQ	Futures	10030.84	10031.13	10025.06	10026.22	5228.0
2019-12-20 05:00:00	NQ	Futures	10026.5	10036.63	10025.93	10034.02	6107.0
2019-12-20 06:00:00	NQ	Futures	10033.73	10045.3	10033.45	10038.65	5808.0
2019-12-20 07:00:00	NQ	Futures	10038.65	10047.61	10034.31	10047.04	5482.0
2019-12-20 08:00:00	NQ	Futures	10046.75	10059.47	10046.17	10056.58	11309.0
2019-12-20 09:00:00	NQ	Futures	10056.29	10091.86	10047.33	10048.19	70198.0
2019-12-20 10:00:00	NQ	Futures	10048.19	10067.28	10048.19	10061.21	38254.0
2019-12-20 11:00:00	NQ	Futures	10060.92	10076.82	10060.34	10069.01	28890.0
2019-12-20 12:00:00	NQ	Futures	10068.72	10077.69	10067.28	10074.8	15474.0
2019-12-20 13:00:00	NQ	Futures	10074.8	10083.18	10074.51	10077.4	15117.0
2019-12-20 14:00:00	NQ	Futures	10077.4	10082.32	10071.04	10080.29	15562.0
2019-12-20 15:00:00	NQ	Futures	10080.29	10080.87	10056.0	10067.86	44145.0
2019-12-20 16:00:00	NQ	Futures	10067.86	10080.58	10063.23	10075.09	13000.0
2019-12-20 00:00:00	YM	Futures	30918.1	30920.3	30910.5	30915.9	995.0
2019-12-20 01:00:00	YM	Futures	30914.8	30917.0	30899.6	30901.8	1015.0
2019-12-20 02:00:00	YM	Futures	30901.8	30917.0	30895.2	30915.9	2046.0
2019-12-20 03:00:00	YM	Futures	30915.9	30932.3	30905.0	30927.9	5916.0
2019-12-20 04:00:00	YM	Futures	30927.9	30927.9	30907.2	30911.6	2755.0
2019-12-20 05:00:00	YM	Futures	30910.5	30943.1	30909.4	30937.7	5103.0
2019-12-20 06:00:00	YM	Futures	30937.7	30960.6	30937.7	30946.4	4457.0
2019-12-20 07:00:00	YM	Futures	30946.4	30956.2	30927.9	30952.9	3396.0
2019-12-20 08:00:00	YM	Futures	30952.9	30974.7	30948.6	30969.3	5217.0
2019-12-20 09:00:00	YM	Futures	30969.3	31057.5	30968.2	31029.2	32462.0
2019-12-20 10:00:00	YM	Futures	31028.1	31042.2	30980.2	31010.7	16269.0
2019-12-20 11:00:00	YM	Futures	31010.7	31045.5	31009.6	31030.2	12065.0
2019-12-20 12:00:00	YM	Futures	31028.1	31049.8	31011.7	31034.6	7751.0
2019-12-20 13:00:00	YM	Futures	31034.6	31043.3	31027.0	31030.2	5060.0
2019-12-20 14:00:00	YM	Futures	31029.2	31056.4	31018.3	31049.8	6751.0
2019-12-20 15:00:00	YM	Futures	31049.8	31049.8	30976.9	30987.8	19801.0

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

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