PREVIEW / futures_1hour / 2020-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-24.parquet
  size:    60 KB
  rows:    1,886

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-09-24 00:00:00	ES	Futures	3617.98	3622.74	3598.37	3600.05	17112.0
2020-09-24 01:00:00	ES	Futures	3599.77	3613.5	3596.41	3613.5	17603.0
2020-09-24 02:00:00	ES	Futures	3613.78	3617.7	3596.69	3599.77	21737.0
2020-09-24 03:00:00	ES	Futures	3599.49	3622.18	3599.21	3618.82	33339.0
2020-09-24 04:00:00	ES	Futures	3618.82	3621.34	3606.22	3612.1	27980.0
2020-09-24 05:00:00	ES	Futures	3612.1	3616.3	3604.82	3613.78	24759.0
2020-09-24 06:00:00	ES	Futures	3613.78	3626.1	3613.5	3622.18	21298.0
2020-09-24 07:00:00	ES	Futures	3621.9	3623.02	3605.66	3607.62	24914.0
2020-09-24 08:00:00	ES	Futures	3607.62	3610.7	3586.89	3592.77	73771.0
2020-09-24 09:00:00	ES	Futures	3593.05	3617.14	3582.97	3609.58	280150.0
2020-09-24 10:00:00	ES	Futures	3609.3	3637.31	3599.21	3620.78	366035.0
2020-09-24 11:00:00	ES	Futures	3620.5	3636.19	3605.94	3635.91	228532.0
2020-09-24 12:00:00	ES	Futures	3636.19	3644.87	3624.7	3642.35	218858.0
2020-09-24 13:00:00	ES	Futures	3642.35	3661.68	3641.23	3650.47	204967.0
2020-09-24 14:00:00	ES	Futures	3650.19	3653.55	3617.14	3618.54	192980.0
2020-09-24 15:00:00	ES	Futures	3618.82	3633.67	3606.22	3624.7	334017.0
2020-09-24 16:00:00	ES	Futures	3624.7	3634.23	3622.46	3630.87	52398.0
2020-09-24 18:00:00	ES	Futures	3633.95	3642.35	3633.11	3637.59	7331.0
2020-09-24 19:00:00	ES	Futures	3637.59	3647.11	3636.75	3645.15	6535.0
2020-09-24 20:00:00	ES	Futures	3644.87	3648.79	3638.71	3645.43	11889.0
2020-09-24 21:00:00	ES	Futures	3645.71	3651.03	3644.59	3645.43	9631.0
2020-09-24 22:00:00	ES	Futures	3645.43	3648.79	3642.35	3644.03	6825.0
2020-09-24 23:00:00	ES	Futures	3644.03	3649.63	3640.39	3643.47	6610.0
2020-09-24 00:00:00	NQ	Futures	12513.73	12542.68	12427.47	12434.13	8967.0
2020-09-24 01:00:00	NQ	Futures	12435.58	12491.15	12406.34	12487.68	9096.0
2020-09-24 02:00:00	NQ	Futures	12486.81	12501.86	12412.13	12428.92	8402.0
2020-09-24 03:00:00	NQ	Futures	12430.65	12539.21	12429.21	12524.44	11090.0
2020-09-24 04:00:00	NQ	Futures	12524.15	12530.81	12454.68	12472.92	9620.0
2020-09-24 05:00:00	NQ	Futures	12475.52	12484.21	12443.39	12470.02	6697.0
2020-09-24 06:00:00	NQ	Futures	12470.02	12533.99	12468.29	12519.23	8461.0
2020-09-24 07:00:00	NQ	Futures	12518.94	12521.55	12450.05	12456.13	9922.0
2020-09-24 08:00:00	NQ	Futures	12455.55	12463.36	12347.0	12373.63	33010.0
2020-09-24 09:00:00	NQ	Futures	12373.63	12589.57	12343.23	12545.28	114184.0
2020-09-24 10:00:00	NQ	Futures	12545.57	12663.68	12474.94	12611.28	133320.0
2020-09-24 11:00:00	NQ	Futures	12610.99	12692.91	12531.1	12683.07	80344.0
2020-09-24 12:00:00	NQ	Futures	12683.36	12716.07	12606.65	12680.18	65990.0
2020-09-24 13:00:00	NQ	Futures	12679.89	12750.23	12670.04	12692.91	56077.0
2020-09-24 14:00:00	NQ	Futures	12692.91	12704.2	12570.76	12575.1	71002.0
2020-09-24 15:00:00	NQ	Futures	12575.68	12641.39	12512.86	12595.94	93170.0
2020-09-24 16:00:00	NQ	Futures	12595.36	12644.86	12587.84	12630.68	10029.0
2020-09-24 18:00:00	NQ	Futures	12637.34	12673.52	12637.34	12653.55	3108.0
2020-09-24 19:00:00	NQ	Futures	12654.7	12689.73	12649.78	12680.47	3218.0
2020-09-24 20:00:00	NQ	Futures	12678.73	12697.54	12655.57	12684.52	4787.0
2020-09-24 21:00:00	NQ	Futures	12685.1	12709.41	12682.2	12683.94	5604.0
2020-09-24 22:00:00	NQ	Futures	12684.23	12699.28	12659.91	12668.31	4337.0
2020-09-24 23:00:00	NQ	Futures	12668.31	12690.89	12645.44	12660.49	3552.0
2020-09-24 00:00:00	YM	Futures	29486.9	29522.2	29334.3	29345.4	3271.0
2020-09-24 01:00:00	YM	Futures	29345.4	29458.1	29316.6	29455.9	3164.0
2020-09-24 02:00:00	YM	Futures	29457.0	29496.8	29326.6	29353.1	4277.0
2020-09-24 03:00:00	YM	Futures	29352.0	29512.3	29349.8	29492.4	6851.0

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

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