PREVIEW / futures_1hour / 2020-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-16.parquet
  size:    51 KB
  rows:    1,513

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-16 00:00:00	ES	Futures	3894.15	3894.99	3888.83	3889.95	7648.0
2020-10-16 01:00:00	ES	Futures	3889.95	3898.92	3889.95	3896.67	7884.0
2020-10-16 02:00:00	ES	Futures	3896.39	3899.76	3890.51	3899.48	11565.0
2020-10-16 03:00:00	ES	Futures	3899.48	3900.88	3887.99	3895.27	30660.0
2020-10-16 04:00:00	ES	Futures	3894.99	3899.76	3892.19	3897.51	14615.0
2020-10-16 05:00:00	ES	Futures	3897.23	3899.76	3888.27	3894.15	20287.0
2020-10-16 06:00:00	ES	Futures	3894.15	3903.96	3891.07	3900.04	24231.0
2020-10-16 07:00:00	ES	Futures	3900.04	3906.48	3896.95	3902.0	24583.0
2020-10-16 08:00:00	ES	Futures	3901.72	3910.96	3900.04	3910.4	38270.0
2020-10-16 09:00:00	ES	Futures	3910.4	3913.2	3902.56	3912.08	174952.0
2020-10-16 10:00:00	ES	Futures	3912.08	3930.85	3911.52	3921.04	202519.0
2020-10-16 11:00:00	ES	Futures	3921.04	3921.32	3905.92	3916.0	148536.0
2020-10-16 12:00:00	ES	Futures	3915.72	3916.56	3903.96	3911.24	105461.0
2020-10-16 13:00:00	ES	Futures	3911.24	3917.4	3909.28	3914.04	71527.0
2020-10-16 14:00:00	ES	Futures	3914.32	3921.32	3910.12	3921.04	87322.0
2020-10-16 15:00:00	ES	Futures	3921.04	3921.04	3889.95	3891.63	225456.0
2020-10-16 16:00:00	ES	Futures	3891.63	3893.59	3877.91	3881.83	87803.0
2020-10-16 00:00:00	NQ	Futures	13729.79	13735.58	13705.19	13713.87	3859.0
2020-10-16 01:00:00	NQ	Futures	13713.58	13763.66	13713.29	13752.66	5370.0
2020-10-16 02:00:00	NQ	Futures	13750.63	13777.26	13730.08	13774.95	4690.0
2020-10-16 03:00:00	NQ	Futures	13774.66	13777.55	13734.71	13773.79	8380.0
2020-10-16 04:00:00	NQ	Futures	13772.34	13812.58	13770.32	13790.0	6372.0
2020-10-16 05:00:00	NQ	Futures	13789.42	13796.08	13745.71	13772.92	5745.0
2020-10-16 06:00:00	NQ	Futures	13773.21	13808.53	13748.32	13770.89	8327.0
2020-10-16 07:00:00	NQ	Futures	13771.76	13831.68	13762.21	13810.55	8980.0
2020-10-16 08:00:00	NQ	Futures	13810.26	13860.34	13805.92	13858.02	19802.0
2020-10-16 09:00:00	NQ	Futures	13857.74	13865.55	13809.68	13850.5	62932.0
2020-10-16 10:00:00	NQ	Futures	13849.92	13919.97	13840.37	13858.31	67939.0
2020-10-16 11:00:00	NQ	Futures	13858.02	13858.02	13750.05	13812.0	74912.0
2020-10-16 12:00:00	NQ	Futures	13812.0	13820.97	13754.39	13801.29	51534.0
2020-10-16 13:00:00	NQ	Futures	13801.29	13834.29	13794.92	13811.71	33350.0
2020-10-16 14:00:00	NQ	Futures	13811.42	13850.5	13793.18	13842.68	35045.0
2020-10-16 15:00:00	NQ	Futures	13842.68	13847.6	13677.4	13694.19	73044.0
2020-10-16 16:00:00	NQ	Futures	13692.74	13702.87	13653.66	13657.42	21436.0
2020-10-16 00:00:00	YM	Futures	31389.6	31394.1	31337.7	31347.6	1517.0
2020-10-16 01:00:00	YM	Futures	31347.6	31406.2	31347.6	31388.5	1987.0
2020-10-16 02:00:00	YM	Futures	31389.6	31408.4	31338.8	31407.3	2392.0
2020-10-16 03:00:00	YM	Futures	31406.2	31421.7	31324.4	31386.3	6275.0
2020-10-16 04:00:00	YM	Futures	31384.1	31409.5	31350.9	31386.3	3262.0
2020-10-16 05:00:00	YM	Futures	31385.2	31404.0	31324.4	31369.7	3710.0
2020-10-16 06:00:00	YM	Futures	31370.8	31465.9	31350.9	31447.1	5719.0
2020-10-16 07:00:00	YM	Futures	31447.1	31485.8	31423.9	31453.8	4484.0
2020-10-16 08:00:00	YM	Futures	31453.8	31544.4	31437.2	31525.6	6525.0
2020-10-16 09:00:00	YM	Futures	31524.5	31615.2	31469.2	31608.6	24946.0
2020-10-16 10:00:00	YM	Futures	31607.4	31766.7	31598.6	31691.5	26258.0
2020-10-16 11:00:00	YM	Futures	31690.4	31700.3	31604.1	31661.6	18628.0
2020-10-16 12:00:00	YM	Futures	31661.6	31662.7	31585.3	31629.6	12977.0
2020-10-16 13:00:00	YM	Futures	31629.6	31664.9	31610.8	31647.3	7021.0
2020-10-16 14:00:00	YM	Futures	31647.3	31697.0	31619.6	31692.6	8693.0
2020-10-16 15:00:00	YM	Futures	31692.6	31693.7	31490.3	31501.3	20648.0

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

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