PREVIEW / futures_1hour / 2020-07-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-30.parquet
  size:    62 KB
  rows:    1,854

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-07-30 00:00:00	ES	Futures	3628.49	3629.33	3625.14	3626.26	3513.0
2020-07-30 01:00:00	ES	Futures	3626.54	3626.54	3621.79	3624.86	7063.0
2020-07-30 02:00:00	ES	Futures	3624.86	3627.09	3618.44	3618.44	12455.0
2020-07-30 03:00:00	ES	Futures	3618.44	3619.28	3600.29	3604.75	50093.0
2020-07-30 04:00:00	ES	Futures	3604.75	3606.99	3592.19	3593.58	30464.0
2020-07-30 05:00:00	ES	Futures	3593.58	3607.55	3591.35	3601.68	43009.0
2020-07-30 06:00:00	ES	Futures	3601.96	3603.92	3586.32	3591.63	26801.0
2020-07-30 07:00:00	ES	Futures	3591.91	3606.43	3591.07	3605.31	30631.0
2020-07-30 08:00:00	ES	Futures	3605.31	3607.27	3588.28	3588.28	59673.0
2020-07-30 09:00:00	ES	Futures	3588.28	3600.57	3572.92	3574.6	195327.0
2020-07-30 10:00:00	ES	Futures	3574.6	3591.35	3568.73	3588.84	260544.0
2020-07-30 11:00:00	ES	Futures	3588.84	3606.71	3585.49	3603.92	181745.0
2020-07-30 12:00:00	ES	Futures	3603.64	3617.6	3599.73	3613.13	158963.0
2020-07-30 13:00:00	ES	Futures	3613.13	3622.63	3608.38	3614.81	162379.0
2020-07-30 14:00:00	ES	Futures	3615.09	3621.79	3608.38	3617.32	291816.0
2020-07-30 15:00:00	ES	Futures	3617.32	3623.18	3611.18	3617.88	336857.0
2020-07-30 16:00:00	ES	Futures	3617.88	3651.39	3613.69	3649.99	85000.0
2020-07-30 18:00:00	ES	Futures	3651.67	3656.69	3642.73	3646.64	14551.0
2020-07-30 19:00:00	ES	Futures	3646.92	3652.51	3645.52	3649.71	12261.0
2020-07-30 20:00:00	ES	Futures	3649.43	3652.78	3638.54	3638.54	23513.0
2020-07-30 21:00:00	ES	Futures	3638.54	3651.95	3636.31	3650.27	19671.0
2020-07-30 22:00:00	ES	Futures	3650.27	3650.55	3638.26	3638.54	15871.0
2020-07-30 23:00:00	ES	Futures	3638.82	3643.29	3637.71	3640.78	9230.0
2020-07-30 00:00:00	NQ	Futures	12347.35	12351.39	12326.52	12334.04	2925.0
2020-07-30 01:00:00	NQ	Futures	12334.91	12337.22	12314.09	12328.26	3491.0
2020-07-30 02:00:00	NQ	Futures	12328.84	12336.93	12293.27	12294.71	5927.0
2020-07-30 03:00:00	NQ	Futures	12294.71	12301.65	12199.0	12220.4	17558.0
2020-07-30 04:00:00	NQ	Futures	12220.68	12232.25	12175.86	12180.49	9089.0
2020-07-30 05:00:00	NQ	Futures	12180.49	12249.31	12168.92	12234.85	11795.0
2020-07-30 06:00:00	NQ	Futures	12235.72	12239.48	12148.68	12177.89	10686.0
2020-07-30 07:00:00	NQ	Futures	12177.89	12258.86	12177.89	12242.95	11895.0
2020-07-30 08:00:00	NQ	Futures	12242.66	12253.94	12187.43	12192.63	18033.0
2020-07-30 09:00:00	NQ	Futures	12192.63	12285.75	12169.21	12195.24	68480.0
2020-07-30 10:00:00	NQ	Futures	12196.1	12260.01	12162.85	12252.21	75959.0
2020-07-30 11:00:00	NQ	Futures	12251.92	12344.45	12236.59	12325.66	58630.0
2020-07-30 12:00:00	NQ	Futures	12325.37	12384.94	12314.96	12362.38	48519.0
2020-07-30 13:00:00	NQ	Futures	12362.09	12398.53	12346.77	12387.54	32302.0
2020-07-30 14:00:00	NQ	Futures	12386.96	12403.45	12347.92	12389.57	36926.0
2020-07-30 15:00:00	NQ	Futures	12389.57	12408.65	12358.04	12382.62	53542.0
2020-07-30 16:00:00	NQ	Futures	12382.62	12605.0	12362.96	12597.77	31341.0
2020-07-30 18:00:00	NQ	Futures	12615.7	12639.42	12583.89	12592.86	7269.0
2020-07-30 19:00:00	NQ	Futures	12593.44	12621.78	12586.21	12614.84	4633.0
2020-07-30 20:00:00	NQ	Futures	12614.26	12627.27	12592.28	12604.42	6700.0
2020-07-30 21:00:00	NQ	Futures	12605.58	12653.3	12597.48	12647.22	6417.0
2020-07-30 22:00:00	NQ	Futures	12647.51	12649.54	12610.79	12611.94	5746.0
2020-07-30 23:00:00	NQ	Futures	12611.94	12624.38	12599.22	12615.41	4413.0
2020-07-30 00:00:00	YM	Futures	29081.1	29094.3	29060.2	29069.0	1112.0
2020-07-30 01:00:00	YM	Futures	29070.1	29073.4	29028.3	29050.3	1368.0
2020-07-30 02:00:00	YM	Futures	29052.5	29067.9	29007.3	29010.6	2509.0
2020-07-30 03:00:00	YM	Futures	29008.4	29012.8	28881.8	28919.2	8851.0

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

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