PREVIEW / futures_1hour / 2019-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-14.parquet
  size:    60 KB
  rows:    1,875

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
2019-11-14 00:00:00	ES	Futures	3359.8	3362.25	3359.53	3360.62	8347.0
2019-11-14 01:00:00	ES	Futures	3360.35	3360.35	3357.36	3357.63	6559.0
2019-11-14 02:00:00	ES	Futures	3357.9	3360.89	3354.64	3359.53	18406.0
2019-11-14 03:00:00	ES	Futures	3359.53	3361.16	3355.73	3357.36	19945.0
2019-11-14 04:00:00	ES	Futures	3357.36	3359.26	3354.64	3357.9	16250.0
2019-11-14 05:00:00	ES	Futures	3358.17	3364.69	3357.63	3359.26	18881.0
2019-11-14 06:00:00	ES	Futures	3359.26	3360.35	3356.27	3360.35	10704.0
2019-11-14 07:00:00	ES	Futures	3360.35	3361.16	3356.54	3358.17	12552.0
2019-11-14 08:00:00	ES	Futures	3358.45	3358.99	3354.37	3356.27	19837.0
2019-11-14 09:00:00	ES	Futures	3356.54	3360.62	3354.91	3360.62	96161.0
2019-11-14 10:00:00	ES	Futures	3360.35	3363.33	3356.54	3356.82	138664.0
2019-11-14 11:00:00	ES	Futures	3356.82	3362.25	3348.4	3351.93	161895.0
2019-11-14 12:00:00	ES	Futures	3351.65	3359.26	3350.84	3358.72	95950.0
2019-11-14 13:00:00	ES	Futures	3358.45	3360.35	3350.02	3355.46	102347.0
2019-11-14 14:00:00	ES	Futures	3355.46	3361.7	3353.83	3361.43	65943.0
2019-11-14 15:00:00	ES	Futures	3361.43	3365.24	3359.26	3364.15	133905.0
2019-11-14 16:00:00	ES	Futures	3364.15	3366.32	3363.88	3365.51	48521.0
2019-11-14 18:00:00	ES	Futures	3364.96	3367.68	3363.61	3367.14	7337.0
2019-11-14 19:00:00	ES	Futures	3367.14	3377.19	3364.96	3376.37	30318.0
2019-11-14 20:00:00	ES	Futures	3376.37	3378.27	3375.01	3376.1	26790.0
2019-11-14 21:00:00	ES	Futures	3375.83	3380.72	3375.29	3378.55	17809.0
2019-11-14 22:00:00	ES	Futures	3378.82	3378.82	3375.83	3376.64	7950.0
2019-11-14 23:00:00	ES	Futures	3376.64	3376.92	3375.56	3376.37	3494.0
2019-11-14 00:00:00	NQ	Futures	9596.41	9606.87	9596.41	9602.51	3343.0
2019-11-14 01:00:00	NQ	Futures	9601.93	9601.93	9590.6	9591.47	2537.0
2019-11-14 02:00:00	NQ	Futures	9591.18	9601.64	9581.02	9596.99	6788.0
2019-11-14 03:00:00	NQ	Futures	9596.7	9603.39	9583.92	9587.41	7624.0
2019-11-14 04:00:00	NQ	Futures	9587.7	9594.96	9579.86	9591.18	6562.0
2019-11-14 05:00:00	NQ	Futures	9590.89	9613.26	9589.15	9590.89	7046.0
2019-11-14 06:00:00	NQ	Futures	9590.89	9594.38	9582.76	9594.38	3645.0
2019-11-14 07:00:00	NQ	Futures	9594.38	9597.58	9580.44	9585.96	4068.0
2019-11-14 08:00:00	NQ	Futures	9585.96	9587.99	9571.72	9578.11	8437.0
2019-11-14 09:00:00	NQ	Futures	9578.11	9595.54	9572.01	9589.15	44771.0
2019-11-14 10:00:00	NQ	Futures	9588.86	9602.8	9564.75	9565.33	50787.0
2019-11-14 11:00:00	NQ	Futures	9565.33	9588.57	9547.03	9556.03	57613.0
2019-11-14 12:00:00	NQ	Futures	9556.33	9588.28	9552.26	9585.67	37093.0
2019-11-14 13:00:00	NQ	Futures	9585.67	9594.96	9565.91	9582.76	35060.0
2019-11-14 14:00:00	NQ	Futures	9583.05	9598.45	9578.69	9597.58	23345.0
2019-11-14 15:00:00	NQ	Futures	9597.58	9611.81	9595.25	9604.84	41977.0
2019-11-14 16:00:00	NQ	Futures	9605.13	9610.65	9601.93	9608.9	8711.0
2019-11-14 18:00:00	NQ	Futures	9606.58	9613.26	9599.32	9611.23	2781.0
2019-11-14 19:00:00	NQ	Futures	9610.94	9643.76	9603.68	9642.31	11959.0
2019-11-14 20:00:00	NQ	Futures	9642.31	9648.7	9636.21	9640.57	11654.0
2019-11-14 21:00:00	NQ	Futures	9640.57	9654.22	9637.37	9651.03	7479.0
2019-11-14 22:00:00	NQ	Futures	9651.03	9651.9	9639.12	9642.02	6420.0
2019-11-14 23:00:00	NQ	Futures	9642.02	9643.76	9639.41	9641.73	6581.0
2019-11-14 00:00:00	YM	Futures	30193.1	30221.4	30192.0	30201.8	1703.0
2019-11-14 01:00:00	YM	Futures	30201.8	30201.8	30164.8	30169.1	1510.0
2019-11-14 02:00:00	YM	Futures	30169.1	30194.2	30143.0	30183.3	3775.0
2019-11-14 03:00:00	YM	Futures	30184.4	30198.5	30151.7	30162.6	3855.0

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

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