PREVIEW / futures_1hour / 2020-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-26.parquet
  size:    50 KB
  rows:    1,463

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-06-26 00:00:00	ES	Futures	3431.62	3442.51	3430.79	3435.53	11018.0
2020-06-26 01:00:00	ES	Futures	3435.81	3439.44	3429.67	3431.07	9952.0
2020-06-26 02:00:00	ES	Futures	3431.07	3431.34	3419.34	3422.69	18347.0
2020-06-26 03:00:00	ES	Futures	3422.41	3426.6	3412.36	3419.62	25874.0
2020-06-26 04:00:00	ES	Futures	3419.9	3420.73	3405.37	3417.1	25606.0
2020-06-26 05:00:00	ES	Futures	3417.38	3428.55	3415.71	3427.43	27405.0
2020-06-26 06:00:00	ES	Futures	3427.43	3436.93	3426.88	3434.7	26613.0
2020-06-26 07:00:00	ES	Futures	3434.7	3441.4	3427.16	3427.71	24694.0
2020-06-26 08:00:00	ES	Futures	3427.71	3428.55	3415.15	3418.22	37247.0
2020-06-26 09:00:00	ES	Futures	3418.22	3421.57	3400.35	3408.17	194372.0
2020-06-26 10:00:00	ES	Futures	3408.17	3408.73	3357.07	3366.56	421857.0
2020-06-26 11:00:00	ES	Futures	3366.56	3381.92	3364.88	3378.29	229838.0
2020-06-26 12:00:00	ES	Futures	3378.57	3379.13	3354.27	3369.07	178156.0
2020-06-26 13:00:00	ES	Futures	3369.07	3378.29	3366.0	3369.35	128014.0
2020-06-26 14:00:00	ES	Futures	3369.35	3372.7	3347.29	3354.55	193683.0
2020-06-26 15:00:00	ES	Futures	3354.27	3365.72	3342.54	3350.64	422654.0
2020-06-26 16:00:00	ES	Futures	3350.64	3366.84	3349.25	3354.27	106376.0
2020-06-26 00:00:00	NQ	Futures	11675.58	11696.4	11671.25	11678.48	2920.0
2020-06-26 01:00:00	NQ	Futures	11677.9	11687.73	11669.8	11677.03	2081.0
2020-06-26 02:00:00	NQ	Futures	11675.87	11679.05	11648.4	11656.21	5561.0
2020-06-26 03:00:00	NQ	Futures	11655.63	11667.78	11615.43	11642.91	7587.0
2020-06-26 04:00:00	NQ	Futures	11643.2	11658.23	11605.31	11651.58	7741.0
2020-06-26 05:00:00	NQ	Futures	11651.58	11683.39	11646.38	11676.16	6338.0
2020-06-26 06:00:00	NQ	Futures	11676.45	11700.16	11674.43	11692.36	5924.0
2020-06-26 07:00:00	NQ	Futures	11691.49	11705.95	11669.8	11670.67	6047.0
2020-06-26 08:00:00	NQ	Futures	11670.96	11680.21	11640.01	11652.74	9048.0
2020-06-26 09:00:00	NQ	Futures	11652.45	11662.28	11561.65	11589.41	59288.0
2020-06-26 10:00:00	NQ	Futures	11589.12	11589.12	11394.79	11437.01	110712.0
2020-06-26 11:00:00	NQ	Futures	11437.01	11544.01	11432.96	11531.28	78166.0
2020-06-26 12:00:00	NQ	Futures	11531.57	11533.89	11425.15	11473.74	58924.0
2020-06-26 13:00:00	NQ	Futures	11473.45	11511.62	11461.01	11467.37	43166.0
2020-06-26 14:00:00	NQ	Futures	11467.66	11494.85	11405.2	11427.18	56767.0
2020-06-26 15:00:00	NQ	Futures	11426.31	11462.75	11363.85	11383.51	75946.0
2020-06-26 16:00:00	NQ	Futures	11384.09	11425.73	11381.78	11387.56	17619.0
2020-06-26 00:00:00	YM	Futures	28129.7	28247.5	28124.2	28184.8	3677.0
2020-06-26 01:00:00	YM	Futures	28185.9	28229.9	28138.5	28149.5	2401.0
2020-06-26 02:00:00	YM	Futures	28150.6	28153.9	28025.1	28054.8	5312.0
2020-06-26 03:00:00	YM	Futures	28052.6	28103.3	27978.9	28052.6	5865.0
2020-06-26 04:00:00	YM	Futures	28053.7	28059.2	27897.4	28008.6	6916.0
2020-06-26 05:00:00	YM	Futures	28008.6	28109.9	27989.9	28098.9	6373.0
2020-06-26 06:00:00	YM	Futures	28096.7	28173.8	28092.3	28156.1	6427.0
2020-06-26 07:00:00	YM	Futures	28156.1	28213.4	28076.9	28089.0	5760.0
2020-06-26 08:00:00	YM	Futures	28089.0	28095.6	27945.8	27982.2	8512.0
2020-06-26 09:00:00	YM	Futures	27980.0	28050.4	27840.1	27901.8	24309.0
2020-06-26 10:00:00	YM	Futures	27898.5	27908.4	27502.1	27580.3	41402.0
2020-06-26 11:00:00	YM	Futures	27580.3	27710.2	27545.0	27625.4	26961.0
2020-06-26 12:00:00	YM	Futures	27626.5	27633.1	27438.2	27583.6	23872.0
2020-06-26 13:00:00	YM	Futures	27582.5	27652.9	27554.9	27556.0	14750.0
2020-06-26 14:00:00	YM	Futures	27554.9	27573.6	27371.0	27441.5	20244.0
2020-06-26 15:00:00	YM	Futures	27440.4	27538.4	27349.0	27411.8	33763.0

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

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