PREVIEW / futures_1hour / 2019-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-01.parquet
  size:    51 KB
  rows:    1,527

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-01 00:00:00	ES	Futures	3305.48	3306.84	3304.93	3306.56	3097.0
2019-11-01 01:00:00	ES	Futures	3306.56	3308.19	3305.75	3307.38	8269.0
2019-11-01 02:00:00	ES	Futures	3307.65	3307.92	3305.75	3307.11	7750.0
2019-11-01 03:00:00	ES	Futures	3307.38	3307.65	3303.03	3304.66	8091.0
2019-11-01 04:00:00	ES	Futures	3304.39	3306.84	3302.22	3303.85	18976.0
2019-11-01 05:00:00	ES	Futures	3303.85	3305.75	3303.58	3304.93	8566.0
2019-11-01 06:00:00	ES	Futures	3304.93	3306.29	3304.12	3306.02	7490.0
2019-11-01 07:00:00	ES	Futures	3306.02	3306.29	3301.4	3302.22	16286.0
2019-11-01 08:00:00	ES	Futures	3301.95	3313.63	3300.32	3312.0	66406.0
2019-11-01 09:00:00	ES	Futures	3312.0	3321.23	3311.72	3319.87	180153.0
2019-11-01 10:00:00	ES	Futures	3319.6	3326.94	3314.44	3323.95	214563.0
2019-11-01 11:00:00	ES	Futures	3324.22	3324.76	3320.96	3322.86	94936.0
2019-11-01 12:00:00	ES	Futures	3323.13	3323.41	3317.7	3320.42	109017.0
2019-11-01 13:00:00	ES	Futures	3320.69	3328.29	3319.87	3326.94	84975.0
2019-11-01 14:00:00	ES	Futures	3326.66	3327.21	3323.95	3325.58	69293.0
2019-11-01 15:00:00	ES	Futures	3325.85	3330.2	3322.86	3329.92	205876.0
2019-11-01 16:00:00	ES	Futures	3329.92	3330.2	3327.21	3328.02	71340.0
2019-11-01 00:00:00	NQ	Futures	9431.41	9435.19	9429.96	9434.32	913.0
2019-11-01 01:00:00	NQ	Futures	9434.32	9440.71	9431.41	9438.1	3072.0
2019-11-01 02:00:00	NQ	Futures	9438.68	9440.13	9432.58	9435.19	2971.0
2019-11-01 03:00:00	NQ	Futures	9435.48	9436.06	9421.54	9426.18	2812.0
2019-11-01 04:00:00	NQ	Futures	9426.18	9431.99	9416.89	9422.99	5722.0
2019-11-01 05:00:00	NQ	Futures	9422.7	9428.22	9419.5	9423.57	2205.0
2019-11-01 06:00:00	NQ	Futures	9422.99	9427.64	9420.67	9427.06	2370.0
2019-11-01 07:00:00	NQ	Futures	9426.77	9427.35	9407.3	9409.34	5903.0
2019-11-01 08:00:00	NQ	Futures	9409.34	9446.52	9405.27	9439.26	19448.0
2019-11-01 09:00:00	NQ	Futures	9438.97	9467.43	9432.29	9457.56	56162.0
2019-11-01 10:00:00	NQ	Futures	9457.56	9483.7	9444.78	9468.02	55899.0
2019-11-01 11:00:00	NQ	Futures	9468.31	9469.18	9454.65	9459.3	29309.0
2019-11-01 12:00:00	NQ	Futures	9459.3	9460.46	9428.51	9438.97	38611.0
2019-11-01 13:00:00	NQ	Futures	9438.97	9468.89	9436.64	9464.53	28960.0
2019-11-01 14:00:00	NQ	Futures	9464.82	9468.31	9459.01	9465.69	21201.0
2019-11-01 15:00:00	NQ	Futures	9465.69	9488.06	9458.14	9488.06	43228.0
2019-11-01 16:00:00	NQ	Futures	9487.77	9490.96	9479.93	9485.74	11698.0
2019-11-01 00:00:00	YM	Futures	29425.8	29433.4	29421.4	29431.2	720.0
2019-11-01 01:00:00	YM	Futures	29431.2	29447.5	29424.7	29443.2	1579.0
2019-11-01 02:00:00	YM	Futures	29443.2	29448.6	29430.1	29446.5	1410.0
2019-11-01 03:00:00	YM	Futures	29446.5	29449.7	29397.5	29416.0	2339.0
2019-11-01 04:00:00	YM	Futures	29416.0	29436.7	29398.6	29411.6	3930.0
2019-11-01 05:00:00	YM	Futures	29410.5	29428.0	29407.3	29421.4	1634.0
2019-11-01 06:00:00	YM	Futures	29422.5	29430.1	29413.8	29428.0	1589.0
2019-11-01 07:00:00	YM	Futures	29428.0	29432.3	29389.9	29395.3	3083.0
2019-11-01 08:00:00	YM	Futures	29396.4	29498.7	29384.4	29482.4	9887.0
2019-11-01 09:00:00	YM	Futures	29481.3	29565.1	29480.2	29552.0	22229.0
2019-11-01 10:00:00	YM	Futures	29552.0	29648.9	29508.5	29636.9	28940.0
2019-11-01 11:00:00	YM	Futures	29638.0	29662.0	29616.2	29648.9	15264.0
2019-11-01 12:00:00	YM	Futures	29650.0	29652.2	29605.4	29616.2	13324.0
2019-11-01 13:00:00	YM	Futures	29617.3	29667.4	29610.8	29650.0	11286.0
2019-11-01 14:00:00	YM	Futures	29650.0	29654.3	29621.7	29636.9	8227.0
2019-11-01 15:00:00	YM	Futures	29636.9	29688.1	29621.7	29685.9	17886.0

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

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