PREVIEW / futures_1hour / 2020-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-17.parquet
  size:    60 KB
  rows:    1,842

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-17 00:00:00	ES	Futures	3472.67	3485.8	3471.28	3481.05	11252.0
2020-06-17 01:00:00	ES	Futures	3481.05	3484.4	3469.6	3477.14	13656.0
2020-06-17 02:00:00	ES	Futures	3477.14	3496.69	3474.07	3483.0	24318.0
2020-06-17 03:00:00	ES	Futures	3483.0	3509.25	3480.21	3502.55	39594.0
2020-06-17 04:00:00	ES	Futures	3502.83	3515.12	3499.48	3508.69	26418.0
2020-06-17 05:00:00	ES	Futures	3508.69	3509.81	3481.89	3488.31	39567.0
2020-06-17 06:00:00	ES	Futures	3488.59	3502.83	3486.36	3502.55	36639.0
2020-06-17 07:00:00	ES	Futures	3502.55	3506.74	3493.06	3497.53	42309.0
2020-06-17 08:00:00	ES	Futures	3497.25	3504.79	3490.54	3493.34	43266.0
2020-06-17 09:00:00	ES	Futures	3493.34	3497.53	3469.88	3476.86	174798.0
2020-06-17 10:00:00	ES	Futures	3476.86	3486.36	3460.66	3478.82	259690.0
2020-06-17 11:00:00	ES	Futures	3478.82	3482.73	3468.48	3481.89	127061.0
2020-06-17 12:00:00	ES	Futures	3481.89	3489.99	3474.63	3487.19	70826.0
2020-06-17 13:00:00	ES	Futures	3487.19	3496.41	3486.63	3488.59	72378.0
2020-06-17 14:00:00	ES	Futures	3488.59	3493.89	3480.77	3481.33	95501.0
2020-06-17 15:00:00	ES	Futures	3481.61	3481.61	3456.48	3464.85	248733.0
2020-06-17 16:00:00	ES	Futures	3464.57	3474.91	3463.74	3469.88	62292.0
2020-06-17 18:00:00	ES	Futures	3467.09	3473.23	3459.55	3465.97	13331.0
2020-06-17 19:00:00	ES	Futures	3466.25	3470.72	3450.89	3452.29	16463.0
2020-06-17 20:00:00	ES	Futures	3452.57	3456.76	3439.16	3446.98	25505.0
2020-06-17 21:00:00	ES	Futures	3446.7	3452.29	3422.97	3433.58	32831.0
2020-06-17 22:00:00	ES	Futures	3433.3	3435.53	3423.53	3432.74	19516.0
2020-06-17 23:00:00	ES	Futures	3432.74	3450.33	3431.34	3447.26	18599.0
2020-06-17 00:00:00	NQ	Futures	11508.15	11540.83	11505.26	11524.34	2505.0
2020-06-17 01:00:00	NQ	Futures	11524.05	11537.36	11496.87	11521.16	3865.0
2020-06-17 02:00:00	NQ	Futures	11520.58	11565.98	11510.46	11540.25	6849.0
2020-06-17 03:00:00	NQ	Futures	11539.96	11598.37	11531.28	11582.18	9591.0
2020-06-17 04:00:00	NQ	Futures	11581.89	11611.96	11573.79	11603.29	6705.0
2020-06-17 05:00:00	NQ	Futures	11603.29	11606.18	11534.75	11551.53	7948.0
2020-06-17 06:00:00	NQ	Futures	11550.95	11595.19	11546.61	11589.99	6788.0
2020-06-17 07:00:00	NQ	Futures	11589.7	11594.9	11567.72	11583.05	9246.0
2020-06-17 08:00:00	NQ	Futures	11583.05	11590.28	11562.23	11570.61	11615.0
2020-06-17 09:00:00	NQ	Futures	11570.03	11589.41	11524.34	11546.03	53234.0
2020-06-17 10:00:00	NQ	Futures	11546.32	11573.79	11493.4	11561.94	63050.0
2020-06-17 11:00:00	NQ	Futures	11561.65	11577.55	11536.49	11572.64	39340.0
2020-06-17 12:00:00	NQ	Futures	11573.21	11604.73	11552.39	11601.26	25403.0
2020-06-17 13:00:00	NQ	Futures	11601.55	11622.09	11596.93	11596.93	21134.0
2020-06-17 14:00:00	NQ	Futures	11596.93	11618.9	11579.29	11582.47	22644.0
2020-06-17 15:00:00	NQ	Futures	11582.18	11582.18	11502.37	11531.28	51418.0
2020-06-17 16:00:00	NQ	Futures	11530.99	11558.76	11526.08	11551.24	8791.0
2020-06-17 18:00:00	NQ	Futures	11546.61	11564.25	11526.08	11547.77	3016.0
2020-06-17 19:00:00	NQ	Futures	11548.34	11561.36	11506.12	11508.73	3597.0
2020-06-17 20:00:00	NQ	Futures	11509.31	11517.98	11473.45	11492.82	7385.0
2020-06-17 21:00:00	NQ	Futures	11491.09	11507.86	11412.72	11443.37	9480.0
2020-06-17 22:00:00	NQ	Futures	11443.95	11454.36	11415.03	11441.93	6003.0
2020-06-17 23:00:00	NQ	Futures	11441.64	11503.52	11436.72	11493.11	5974.0
2020-06-17 00:00:00	YM	Futures	28680.3	28815.7	28671.5	28766.2	2091.0
2020-06-17 01:00:00	YM	Futures	28760.7	28792.6	28649.5	28723.2	2529.0
2020-06-17 02:00:00	YM	Futures	28722.1	28911.5	28696.8	28793.7	5700.0
2020-06-17 03:00:00	YM	Futures	28790.4	29074.5	28765.1	28998.5	10545.0

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

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