PREVIEW / futures_1hour / 2020-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-14.parquet
  size:    60 KB
  rows:    1,873

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
2020-10-14 00:00:00	ES	Futures	3940.37	3944.85	3935.33	3937.85	9370.0
2020-10-14 01:00:00	ES	Futures	3937.85	3938.69	3933.09	3933.93	8215.0
2020-10-14 02:00:00	ES	Futures	3933.93	3942.89	3930.57	3940.93	11471.0
2020-10-14 03:00:00	ES	Futures	3940.93	3942.33	3931.41	3940.65	17546.0
2020-10-14 04:00:00	ES	Futures	3940.65	3948.21	3938.69	3944.01	15371.0
2020-10-14 05:00:00	ES	Futures	3944.01	3947.93	3933.37	3935.61	21403.0
2020-10-14 06:00:00	ES	Futures	3935.61	3938.13	3914.32	3918.8	40073.0
2020-10-14 07:00:00	ES	Futures	3918.8	3927.77	3917.68	3924.12	26377.0
2020-10-14 08:00:00	ES	Futures	3924.12	3935.61	3922.72	3934.21	32828.0
2020-10-14 09:00:00	ES	Futures	3933.93	3944.01	3926.64	3941.77	129474.0
2020-10-14 10:00:00	ES	Futures	3941.77	3942.33	3919.92	3929.73	184979.0
2020-10-14 11:00:00	ES	Futures	3930.01	3932.53	3900.04	3902.0	206266.0
2020-10-14 12:00:00	ES	Futures	3902.0	3911.24	3889.95	3899.76	186673.0
2020-10-14 13:00:00	ES	Futures	3899.48	3905.08	3890.79	3901.16	131800.0
2020-10-14 14:00:00	ES	Futures	3900.88	3908.16	3890.51	3901.16	169592.0
2020-10-14 15:00:00	ES	Futures	3901.44	3914.32	3897.23	3899.48	212552.0
2020-10-14 16:00:00	ES	Futures	3899.76	3902.28	3896.67	3898.36	50973.0
2020-10-14 18:00:00	ES	Futures	3898.08	3906.2	3892.47	3901.44	18576.0
2020-10-14 19:00:00	ES	Futures	3901.16	3906.2	3900.04	3903.4	10087.0
2020-10-14 20:00:00	ES	Futures	3903.4	3905.64	3895.27	3897.51	11543.0
2020-10-14 21:00:00	ES	Futures	3897.51	3902.28	3885.47	3890.51	18792.0
2020-10-14 22:00:00	ES	Futures	3890.23	3891.91	3882.67	3883.23	9617.0
2020-10-14 23:00:00	ES	Futures	3883.23	3886.59	3881.27	3883.79	8810.0
2020-10-14 00:00:00	NQ	Futures	14078.31	14093.94	14049.07	14059.78	3876.0
2020-10-14 01:00:00	NQ	Futures	14059.78	14066.44	14037.78	14044.73	4059.0
2020-10-14 02:00:00	NQ	Futures	14043.86	14100.6	14032.86	14091.63	6665.0
2020-10-14 03:00:00	NQ	Futures	14091.34	14095.68	14038.07	14075.42	7858.0
2020-10-14 04:00:00	NQ	Futures	14074.55	14086.42	14050.81	14058.34	6403.0
2020-10-14 05:00:00	NQ	Futures	14059.21	14071.65	14015.21	14026.21	5934.0
2020-10-14 06:00:00	NQ	Futures	14026.5	14038.36	13969.47	13992.05	12522.0
2020-10-14 07:00:00	NQ	Futures	13993.5	14043.28	13990.02	14033.73	8456.0
2020-10-14 08:00:00	NQ	Futures	14033.73	14049.07	14008.26	14036.92	14735.0
2020-10-14 09:00:00	NQ	Futures	14036.63	14071.65	13977.0	14047.05	61923.0
2020-10-14 10:00:00	NQ	Futures	14047.34	14055.15	13926.05	13998.42	86284.0
2020-10-14 11:00:00	NQ	Futures	13999.0	14015.21	13852.52	13861.21	75303.0
2020-10-14 12:00:00	NQ	Futures	13861.21	13888.71	13780.74	13825.03	78193.0
2020-10-14 13:00:00	NQ	Futures	13825.03	13860.92	13785.95	13856.29	55082.0
2020-10-14 14:00:00	NQ	Futures	13855.71	13897.68	13822.13	13866.71	60258.0
2020-10-14 15:00:00	NQ	Futures	13866.71	13932.42	13850.5	13868.45	64605.0
2020-10-14 16:00:00	NQ	Futures	13868.16	13874.52	13825.6	13829.95	12986.0
2020-10-14 18:00:00	NQ	Futures	13836.6	13875.1	13814.6	13848.18	8167.0
2020-10-14 19:00:00	NQ	Futures	13848.18	13867.58	13840.08	13850.21	4270.0
2020-10-14 20:00:00	NQ	Futures	13849.05	13858.31	13821.55	13833.13	3799.0
2020-10-14 21:00:00	NQ	Futures	13833.13	13852.52	13764.24	13785.08	8832.0
2020-10-14 22:00:00	NQ	Futures	13785.08	13799.84	13746.29	13751.5	4866.0
2020-10-14 23:00:00	NQ	Futures	13750.63	13766.84	13740.5	13753.82	3508.0
2020-10-14 00:00:00	YM	Futures	31690.4	31722.4	31648.4	31666.0	1975.0
2020-10-14 01:00:00	YM	Futures	31667.2	31673.8	31625.1	31629.6	2109.0
2020-10-14 02:00:00	YM	Futures	31630.7	31685.9	31599.7	31663.8	3040.0
2020-10-14 03:00:00	YM	Futures	31662.7	31681.5	31604.1	31679.3	4983.0

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

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