PREVIEW / futures_1hour / 2019-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-23.parquet
  size:    54 KB
  rows:    1,783

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-23 00:00:00	ES	Futures	3499.0	3499.3	3498.5	3499.0	2991.0
2019-12-23 01:00:00	ES	Futures	3499.0	3499.0	3497.1	3497.1	3105.0
2019-12-23 02:00:00	ES	Futures	3497.4	3498.5	3497.1	3497.7	5390.0
2019-12-23 03:00:00	ES	Futures	3497.9	3499.6	3497.4	3498.8	10726.0
2019-12-23 04:00:00	ES	Futures	3498.5	3499.8	3498.2	3499.3	7520.0
2019-12-23 05:00:00	ES	Futures	3499.0	3500.7	3498.8	3499.6	5847.0
2019-12-23 06:00:00	ES	Futures	3499.8	3502.0	3499.6	3501.7	7155.0
2019-12-23 07:00:00	ES	Futures	3501.5	3505.8	3501.5	3503.4	12553.0
2019-12-23 08:00:00	ES	Futures	3503.4	3505.3	3501.5	3502.3	13412.0
2019-12-23 09:00:00	ES	Futures	3502.5	3502.8	3497.4	3498.5	111568.0
2019-12-23 10:00:00	ES	Futures	3498.8	3500.9	3497.7	3500.9	74880.0
2019-12-23 11:00:00	ES	Futures	3500.7	3501.7	3499.3	3500.1	53224.0
2019-12-23 12:00:00	ES	Futures	3500.4	3500.4	3497.7	3498.8	47266.0
2019-12-23 13:00:00	ES	Futures	3498.8	3500.4	3497.9	3498.8	27204.0
2019-12-23 14:00:00	ES	Futures	3499.0	3500.1	3498.2	3499.6	38684.0
2019-12-23 15:00:00	ES	Futures	3499.3	3499.6	3495.0	3497.1	113601.0
2019-12-23 16:00:00	ES	Futures	3496.9	3499.0	3496.6	3499.0	40466.0
2019-12-23 18:00:00	ES	Futures	3499.3	3500.4	3497.7	3499.6	3653.0
2019-12-23 19:00:00	ES	Futures	3499.6	3499.8	3497.7	3497.9	3560.0
2019-12-23 20:00:00	ES	Futures	3497.9	3498.5	3496.9	3497.7	3198.0
2019-12-23 21:00:00	ES	Futures	3497.7	3498.5	3496.9	3498.2	2340.0
2019-12-23 22:00:00	ES	Futures	3498.2	3499.0	3497.7	3498.2	2076.0
2019-12-23 23:00:00	ES	Futures	3498.5	3498.8	3498.2	3498.8	1105.0
2019-12-23 00:00:00	NQ	Futures	10085.5	10085.79	10083.47	10084.63	985.0
2019-12-23 01:00:00	NQ	Futures	10084.63	10084.92	10077.69	10079.13	1374.0
2019-12-23 02:00:00	NQ	Futures	10079.42	10081.16	10077.98	10080.29	1882.0
2019-12-23 03:00:00	NQ	Futures	10080.58	10084.92	10078.56	10082.03	5049.0
2019-12-23 04:00:00	NQ	Futures	10081.74	10086.65	10079.71	10085.21	2581.0
2019-12-23 05:00:00	NQ	Futures	10084.92	10089.83	10084.05	10085.79	2351.0
2019-12-23 06:00:00	NQ	Futures	10086.07	10097.35	10085.79	10095.62	4020.0
2019-12-23 07:00:00	NQ	Futures	10095.33	10112.39	10094.17	10102.27	6410.0
2019-12-23 08:00:00	NQ	Futures	10102.56	10113.26	10101.4	10106.32	6433.0
2019-12-23 09:00:00	NQ	Futures	10106.32	10107.47	10089.54	10093.59	38504.0
2019-12-23 10:00:00	NQ	Futures	10093.88	10101.11	10086.94	10100.24	25987.0
2019-12-23 11:00:00	NQ	Futures	10099.95	10105.45	10096.2	10104.29	17728.0
2019-12-23 12:00:00	NQ	Futures	10104.58	10105.74	10094.75	10096.2	13187.0
2019-12-23 13:00:00	NQ	Futures	10095.91	10100.24	10094.17	10094.75	7712.0
2019-12-23 14:00:00	NQ	Futures	10095.04	10100.82	10094.46	10097.35	10905.0
2019-12-23 15:00:00	NQ	Futures	10097.35	10098.22	10082.32	10088.39	24161.0
2019-12-23 16:00:00	NQ	Futures	10088.39	10097.35	10087.81	10096.48	6706.0
2019-12-23 18:00:00	NQ	Futures	10095.91	10099.38	10093.59	10096.77	1514.0
2019-12-23 19:00:00	NQ	Futures	10096.48	10097.06	10087.81	10089.54	1645.0
2019-12-23 20:00:00	NQ	Futures	10089.54	10090.99	10084.34	10086.07	2028.0
2019-12-23 21:00:00	NQ	Futures	10086.36	10090.41	10084.05	10088.97	1264.0
2019-12-23 22:00:00	NQ	Futures	10088.97	10091.28	10086.36	10088.1	865.0
2019-12-23 23:00:00	NQ	Futures	10088.39	10090.99	10088.1	10089.54	773.0
2019-12-23 00:00:00	YM	Futures	31021.5	31024.8	31015.0	31017.2	1095.0
2019-12-23 01:00:00	YM	Futures	31017.2	31018.3	31001.9	31004.1	679.0
2019-12-23 02:00:00	YM	Futures	31005.2	31013.9	31004.1	31010.7	1417.0
2019-12-23 03:00:00	YM	Futures	31011.7	31028.1	31007.4	31022.6	3359.0

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

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