PREVIEW / futures_1hour / 2019-10-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	3300.59	3301.67	3300.59	3301.13	2102.0
2019-10-29 01:00:00	ES	Futures	3301.4	3301.4	3299.5	3301.13	4503.0
2019-10-29 02:00:00	ES	Futures	3301.13	3301.67	3299.77	3300.32	2746.0
2019-10-29 03:00:00	ES	Futures	3300.32	3301.4	3299.77	3300.86	4751.0
2019-10-29 04:00:00	ES	Futures	3300.86	3301.13	3295.7	3297.6	19393.0
2019-10-29 05:00:00	ES	Futures	3297.6	3298.41	3294.07	3294.07	15967.0
2019-10-29 06:00:00	ES	Futures	3294.07	3297.33	3293.8	3297.06	10380.0
2019-10-29 07:00:00	ES	Futures	3297.33	3297.6	3292.44	3295.97	16506.0
2019-10-29 08:00:00	ES	Futures	3295.43	3297.87	3291.62	3297.6	20520.0
2019-10-29 09:00:00	ES	Futures	3297.6	3302.76	3294.61	3299.77	120649.0
2019-10-29 10:00:00	ES	Futures	3300.04	3309.82	3297.6	3307.11	157360.0
2019-10-29 11:00:00	ES	Futures	3306.84	3309.01	3296.79	3298.96	144728.0
2019-10-29 12:00:00	ES	Futures	3299.23	3307.38	3295.97	3304.93	131568.0
2019-10-29 13:00:00	ES	Futures	3304.93	3307.11	3304.12	3305.21	45047.0
2019-10-29 14:00:00	ES	Futures	3305.21	3305.21	3297.33	3297.6	70257.0
2019-10-29 15:00:00	ES	Futures	3297.6	3300.59	3295.43	3298.41	150353.0
2019-10-29 16:00:00	ES	Futures	3298.41	3299.77	3296.51	3298.96	53256.0
2019-10-29 18:00:00	ES	Futures	3299.23	3300.32	3298.14	3298.14	3544.0
2019-10-29 19:00:00	ES	Futures	3298.14	3298.96	3296.51	3298.41	3661.0
2019-10-29 20:00:00	ES	Futures	3298.69	3299.5	3295.97	3297.06	7322.0
2019-10-29 21:00:00	ES	Futures	3297.33	3297.6	3294.34	3295.16	7672.0
2019-10-29 22:00:00	ES	Futures	3295.16	3297.33	3294.34	3296.51	4229.0
2019-10-29 23:00:00	ES	Futures	3296.24	3297.06	3295.43	3295.97	2343.0
2019-10-29 00:00:00	NQ	Futures	9422.7	9426.48	9422.12	9424.44	1056.0
2019-10-29 01:00:00	NQ	Futures	9424.15	9424.44	9418.63	9423.28	1480.0
2019-10-29 02:00:00	NQ	Futures	9423.28	9425.02	9420.38	9422.12	1119.0
2019-10-29 03:00:00	NQ	Futures	9421.83	9427.06	9420.67	9424.15	2001.0
2019-10-29 04:00:00	NQ	Futures	9424.15	9425.02	9406.14	9414.27	6272.0
2019-10-29 05:00:00	NQ	Futures	9414.27	9418.34	9402.07	9403.24	5779.0
2019-10-29 06:00:00	NQ	Futures	9403.53	9412.53	9402.36	9412.24	3458.0
2019-10-29 07:00:00	NQ	Futures	9412.24	9413.11	9393.65	9402.36	7395.0
2019-10-29 08:00:00	NQ	Futures	9402.65	9418.34	9388.13	9417.18	9840.0
2019-10-29 09:00:00	NQ	Futures	9417.18	9428.22	9395.97	9400.33	48446.0
2019-10-29 10:00:00	NQ	Futures	9400.33	9416.31	9380.29	9397.72	61651.0
2019-10-29 11:00:00	NQ	Futures	9397.43	9407.3	9357.05	9365.47	51714.0
2019-10-29 12:00:00	NQ	Futures	9365.76	9397.14	9355.89	9385.52	38370.0
2019-10-29 13:00:00	NQ	Futures	9385.52	9396.85	9378.83	9384.06	20207.0
2019-10-29 14:00:00	NQ	Futures	9384.06	9384.35	9363.73	9364.02	24150.0
2019-10-29 15:00:00	NQ	Futures	9364.02	9379.71	9355.89	9359.08	41512.0
2019-10-29 16:00:00	NQ	Futures	9359.37	9365.47	9354.72	9360.82	9138.0
2019-10-29 18:00:00	NQ	Futures	9362.28	9368.09	9361.7	9362.57	1377.0
2019-10-29 19:00:00	NQ	Futures	9361.7	9365.18	9356.76	9364.02	1260.0
2019-10-29 20:00:00	NQ	Futures	9364.02	9367.21	9355.89	9359.08	2967.0
2019-10-29 21:00:00	NQ	Futures	9359.37	9360.53	9349.49	9352.98	3779.0
2019-10-29 22:00:00	NQ	Futures	9352.98	9364.89	9350.95	9359.95	2592.0
2019-10-29 23:00:00	NQ	Futures	9359.66	9362.28	9355.3	9357.63	1382.0
2019-10-29 00:00:00	YM	Futures	29438.8	29446.5	29437.8	29443.2	607.0
2019-10-29 01:00:00	YM	Futures	29443.2	29443.2	29430.1	29442.1	657.0
2019-10-29 02:00:00	YM	Futures	29442.1	29446.5	29429.0	29435.6	555.0
2019-10-29 03:00:00	YM	Futures	29435.6	29443.2	29432.3	29437.8	1002.0

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

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