PREVIEW / futures_1hour / 2019-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-28.parquet
  size:    57 KB
  rows:    1,863

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-10-28 00:00:00	ES	Futures	3287.01	3288.09	3286.46	3288.09	2552.0
2019-10-28 01:00:00	ES	Futures	3288.09	3288.09	3285.65	3286.73	4018.0
2019-10-28 02:00:00	ES	Futures	3286.73	3287.28	3285.65	3286.73	2799.0
2019-10-28 03:00:00	ES	Futures	3286.73	3289.18	3285.65	3287.28	8339.0
2019-10-28 04:00:00	ES	Futures	3287.55	3291.08	3286.46	3287.28	21390.0
2019-10-28 05:00:00	ES	Futures	3287.01	3287.82	3285.92	3287.01	8008.0
2019-10-28 06:00:00	ES	Futures	3287.01	3289.45	3286.73	3288.64	10605.0
2019-10-28 07:00:00	ES	Futures	3288.36	3291.62	3288.36	3290.81	9776.0
2019-10-28 08:00:00	ES	Futures	3290.81	3296.51	3289.72	3295.7	31774.0
2019-10-28 09:00:00	ES	Futures	3295.97	3303.85	3294.07	3302.22	180826.0
2019-10-28 10:00:00	ES	Futures	3302.49	3306.02	3299.77	3300.59	137239.0
2019-10-28 11:00:00	ES	Futures	3300.32	3301.67	3297.06	3299.77	115515.0
2019-10-28 12:00:00	ES	Futures	3300.04	3302.49	3298.14	3298.69	73660.0
2019-10-28 13:00:00	ES	Futures	3298.96	3302.49	3298.69	3301.67	72847.0
2019-10-28 14:00:00	ES	Futures	3301.4	3303.3	3300.59	3302.22	63773.0
2019-10-28 15:00:00	ES	Futures	3301.95	3304.12	3299.5	3300.59	160283.0
2019-10-28 16:00:00	ES	Futures	3300.86	3302.49	3297.6	3299.77	62220.0
2019-10-28 18:00:00	ES	Futures	3301.13	3301.13	3298.96	3300.04	3654.0
2019-10-28 19:00:00	ES	Futures	3299.77	3302.76	3298.96	3301.67	4485.0
2019-10-28 20:00:00	ES	Futures	3301.67	3303.85	3300.59	3302.76	10734.0
2019-10-28 21:00:00	ES	Futures	3302.76	3303.03	3300.32	3301.13	7336.0
2019-10-28 22:00:00	ES	Futures	3301.4	3301.95	3300.86	3301.67	3035.0
2019-10-28 23:00:00	ES	Futures	3301.4	3301.67	3300.04	3300.86	2698.0
2019-10-28 00:00:00	NQ	Futures	9363.15	9364.89	9361.11	9364.02	1354.0
2019-10-28 01:00:00	NQ	Futures	9364.02	9364.31	9356.76	9358.21	1850.0
2019-10-28 02:00:00	NQ	Futures	9358.5	9360.53	9355.01	9359.95	1422.0
2019-10-28 03:00:00	NQ	Futures	9359.95	9364.02	9353.56	9359.66	2976.0
2019-10-28 04:00:00	NQ	Futures	9359.66	9382.9	9356.76	9366.34	9059.0
2019-10-28 05:00:00	NQ	Futures	9366.34	9366.34	9357.92	9363.15	3482.0
2019-10-28 06:00:00	NQ	Futures	9363.15	9368.09	9360.82	9361.99	3517.0
2019-10-28 07:00:00	NQ	Futures	9361.99	9375.93	9361.7	9370.41	5037.0
2019-10-28 08:00:00	NQ	Futures	9370.12	9386.39	9367.8	9384.93	9388.0
2019-10-28 09:00:00	NQ	Futures	9384.64	9410.21	9379.42	9402.65	54054.0
2019-10-28 10:00:00	NQ	Futures	9402.95	9423.57	9398.59	9412.53	46356.0
2019-10-28 11:00:00	NQ	Futures	9412.82	9431.12	9408.76	9425.02	40815.0
2019-10-28 12:00:00	NQ	Futures	9425.31	9436.93	9417.47	9422.7	21995.0
2019-10-28 13:00:00	NQ	Futures	9422.99	9432.29	9420.38	9425.89	20129.0
2019-10-28 14:00:00	NQ	Futures	9425.89	9439.26	9424.44	9432.87	17702.0
2019-10-28 15:00:00	NQ	Futures	9433.45	9443.9	9428.22	9431.12	31867.0
2019-10-28 16:00:00	NQ	Futures	9431.12	9439.26	9395.1	9424.73	19412.0
2019-10-28 18:00:00	NQ	Futures	9422.7	9424.44	9416.31	9418.05	1821.0
2019-10-28 19:00:00	NQ	Futures	9418.05	9428.8	9416.31	9427.06	1918.0
2019-10-28 20:00:00	NQ	Futures	9426.77	9433.74	9423.86	9429.96	3356.0
2019-10-28 21:00:00	NQ	Futures	9430.25	9431.99	9420.08	9423.28	3302.0
2019-10-28 22:00:00	NQ	Futures	9423.57	9426.18	9421.83	9424.15	1180.0
2019-10-28 23:00:00	NQ	Futures	9423.57	9424.15	9418.92	9422.7	1311.0
2019-10-28 00:00:00	YM	Futures	29337.6	29348.5	29335.4	29346.3	624.0
2019-10-28 01:00:00	YM	Futures	29347.4	29347.4	29330.0	29336.5	730.0
2019-10-28 02:00:00	YM	Futures	29337.6	29339.8	29327.8	29334.4	622.0
2019-10-28 03:00:00	YM	Futures	29335.4	29361.6	29322.4	29348.5	2003.0

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

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