PREVIEW / futures_1hour / 2020-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-23.parquet
  size:    59 KB
  rows:    1,858

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-23 00:00:00	ES	Futures	3474.07	3480.21	3471.83	3475.19	7235.0
2020-06-23 01:00:00	ES	Futures	3475.19	3479.09	3465.69	3466.53	9254.0
2020-06-23 02:00:00	ES	Futures	3466.25	3482.73	3463.46	3480.77	18557.0
2020-06-23 03:00:00	ES	Futures	3481.05	3500.04	3474.63	3499.76	35074.0
2020-06-23 04:00:00	ES	Futures	3499.76	3501.71	3491.94	3492.78	28166.0
2020-06-23 05:00:00	ES	Futures	3492.78	3501.43	3490.82	3498.08	17101.0
2020-06-23 06:00:00	ES	Futures	3498.08	3506.18	3496.41	3501.99	24349.0
2020-06-23 07:00:00	ES	Futures	3501.99	3505.62	3497.25	3504.23	18617.0
2020-06-23 08:00:00	ES	Futures	3503.95	3513.72	3502.83	3508.97	36389.0
2020-06-23 09:00:00	ES	Futures	3509.25	3510.65	3491.1	3495.29	154585.0
2020-06-23 10:00:00	ES	Futures	3495.29	3502.55	3485.24	3493.06	204826.0
2020-06-23 11:00:00	ES	Futures	3492.78	3508.69	3488.31	3504.51	130752.0
2020-06-23 12:00:00	ES	Futures	3504.79	3507.02	3499.76	3502.83	83090.0
2020-06-23 13:00:00	ES	Futures	3502.55	3512.88	3502.55	3508.97	91539.0
2020-06-23 14:00:00	ES	Futures	3508.69	3508.97	3496.97	3499.2	94728.0
2020-06-23 15:00:00	ES	Futures	3499.48	3501.99	3479.93	3484.68	251061.0
2020-06-23 16:00:00	ES	Futures	3484.96	3490.54	3475.19	3476.86	57942.0
2020-06-23 18:00:00	ES	Futures	3477.42	3483.84	3471.0	3472.67	12291.0
2020-06-23 19:00:00	ES	Futures	3472.67	3481.05	3470.16	3475.46	10714.0
2020-06-23 20:00:00	ES	Futures	3475.19	3490.54	3474.35	3487.19	15522.0
2020-06-23 21:00:00	ES	Futures	3487.47	3490.54	3476.86	3477.98	17939.0
2020-06-23 22:00:00	ES	Futures	3477.7	3484.4	3472.39	3479.93	14508.0
2020-06-23 23:00:00	ES	Futures	3480.21	3487.47	3479.65	3484.12	10290.0
2020-06-23 00:00:00	NQ	Futures	11686.28	11705.95	11681.95	11694.67	2533.0
2020-06-23 01:00:00	NQ	Futures	11696.4	11706.81	11669.8	11676.45	4009.0
2020-06-23 02:00:00	NQ	Futures	11676.16	11735.73	11670.09	11726.19	7256.0
2020-06-23 03:00:00	NQ	Futures	11725.9	11792.7	11714.91	11791.83	11968.0
2020-06-23 04:00:00	NQ	Futures	11791.54	11795.59	11764.07	11767.83	7536.0
2020-06-23 05:00:00	NQ	Futures	11767.25	11789.81	11762.05	11783.16	4875.0
2020-06-23 06:00:00	NQ	Futures	11782.87	11803.69	11775.35	11786.05	6406.0
2020-06-23 07:00:00	NQ	Futures	11786.63	11802.24	11773.04	11789.52	6376.0
2020-06-23 08:00:00	NQ	Futures	11789.23	11799.93	11782.29	11790.68	10468.0
2020-06-23 09:00:00	NQ	Futures	11790.39	11799.35	11750.77	11780.27	47620.0
2020-06-23 10:00:00	NQ	Futures	11779.98	11834.63	11756.84	11814.1	59426.0
2020-06-23 11:00:00	NQ	Futures	11813.52	11868.75	11798.48	11868.18	35981.0
2020-06-23 12:00:00	NQ	Futures	11868.75	11877.72	11854.01	11870.2	25926.0
2020-06-23 13:00:00	NQ	Futures	11870.78	11909.82	11869.04	11895.36	27188.0
2020-06-23 14:00:00	NQ	Futures	11895.65	11895.94	11848.8	11850.54	27451.0
2020-06-23 15:00:00	NQ	Futures	11850.54	11858.34	11770.43	11795.59	54946.0
2020-06-23 16:00:00	NQ	Futures	11795.01	11814.68	11769.86	11771.88	10753.0
2020-06-23 18:00:00	NQ	Futures	11778.82	11803.69	11766.1	11772.17	4766.0
2020-06-23 19:00:00	NQ	Futures	11772.17	11794.15	11758.29	11776.22	5279.0
2020-06-23 20:00:00	NQ	Futures	11775.64	11825.38	11775.35	11816.7	6550.0
2020-06-23 21:00:00	NQ	Futures	11816.41	11830.58	11793.86	11798.48	7347.0
2020-06-23 22:00:00	NQ	Futures	11797.33	11806.58	11774.77	11795.01	6304.0
2020-06-23 23:00:00	NQ	Futures	11795.01	11819.88	11793.57	11814.97	4388.0
2020-06-23 00:00:00	YM	Futures	28569.1	28650.6	28550.4	28586.7	2883.0
2020-06-23 01:00:00	YM	Futures	28584.5	28630.7	28486.5	28492.0	3213.0
2020-06-23 02:00:00	YM	Futures	28493.1	28628.5	28445.7	28607.6	6769.0
2020-06-23 03:00:00	YM	Futures	28608.7	28812.4	28549.3	28800.3	10062.0

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

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