PREVIEW / futures_1hour / 2019-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-12.parquet
  size:    52 KB
  rows:    1,673

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-06-12 00:00:00	ES	Futures	3129.6	3129.6	3128.25	3128.79	3117.0
2019-06-12 01:00:00	ES	Futures	3129.06	3129.6	3122.83	3124.18	10110.0
2019-06-12 02:00:00	ES	Futures	3124.18	3124.45	3120.39	3120.66	17162.0
2019-06-12 03:00:00	ES	Futures	3120.93	3126.35	3120.93	3123.64	25106.0
2019-06-12 04:00:00	ES	Futures	3123.64	3127.98	3121.2	3121.74	22679.0
2019-06-12 05:00:00	ES	Futures	3121.74	3123.91	3119.03	3119.84	21326.0
2019-06-12 06:00:00	ES	Futures	3119.84	3125.0	3117.95	3125.0	22768.0
2019-06-12 07:00:00	ES	Futures	3125.0	3126.08	3120.93	3120.93	20538.0
2019-06-12 08:00:00	ES	Futures	3120.93	3127.16	3120.93	3123.37	34218.0
2019-06-12 09:00:00	ES	Futures	3123.64	3133.67	3123.37	3129.06	185594.0
2019-06-12 10:00:00	ES	Futures	3129.33	3130.69	3120.39	3123.37	186266.0
2019-06-12 11:00:00	ES	Futures	3123.64	3125.81	3118.22	3118.22	130420.0
2019-06-12 12:00:00	ES	Futures	3118.22	3126.35	3117.95	3124.45	93850.0
2019-06-12 13:00:00	ES	Futures	3124.72	3126.08	3121.47	3124.18	52575.0
2019-06-12 14:00:00	ES	Futures	3124.18	3126.08	3120.12	3124.45	58879.0
2019-06-12 15:00:00	ES	Futures	3124.45	3125.27	3120.39	3123.91	126141.0
2019-06-12 16:00:00	ES	Futures	3123.91	3125.81	3122.56	3124.72	39160.0
2019-06-12 18:00:00	ES	Futures	3125.27	3128.79	3124.45	3127.71	4886.0
2019-06-12 19:00:00	ES	Futures	3127.71	3130.15	3127.16	3129.06	4605.0
2019-06-12 20:00:00	ES	Futures	3129.06	3132.32	3127.98	3130.42	13614.0
2019-06-12 21:00:00	ES	Futures	3130.42	3131.5	3121.74	3123.1	18408.0
2019-06-12 22:00:00	ES	Futures	3122.83	3123.1	3109.27	3115.78	39744.0
2019-06-12 23:00:00	ES	Futures	3116.05	3123.64	3115.24	3119.84	14344.0
2019-06-12 00:00:00	NQ	Futures	8744.0	8744.87	8739.34	8741.67	1310.0
2019-06-12 01:00:00	NQ	Futures	8741.96	8744.87	8720.41	8723.62	4049.0
2019-06-12 02:00:00	NQ	Futures	8723.62	8723.62	8707.02	8707.02	7625.0
2019-06-12 03:00:00	NQ	Futures	8707.31	8730.61	8706.15	8718.09	9473.0
2019-06-12 04:00:00	NQ	Futures	8717.79	8732.64	8712.84	8714.88	8334.0
2019-06-12 05:00:00	NQ	Futures	8715.47	8721.87	8704.11	8707.9	8228.0
2019-06-12 06:00:00	NQ	Futures	8708.19	8724.49	8702.95	8723.91	7553.0
2019-06-12 07:00:00	NQ	Futures	8723.91	8729.44	8712.26	8713.14	5455.0
2019-06-12 08:00:00	NQ	Futures	8713.43	8734.68	8712.84	8721.0	10984.0
2019-06-12 09:00:00	NQ	Futures	8721.0	8749.24	8711.1	8736.43	68112.0
2019-06-12 10:00:00	NQ	Futures	8736.43	8741.96	8692.17	8708.19	73288.0
2019-06-12 11:00:00	NQ	Futures	8708.48	8722.16	8694.21	8695.08	46165.0
2019-06-12 12:00:00	NQ	Futures	8695.38	8718.96	8689.26	8713.14	32877.0
2019-06-12 13:00:00	NQ	Futures	8713.14	8720.41	8700.03	8708.77	18356.0
2019-06-12 14:00:00	NQ	Futures	8708.77	8717.79	8695.08	8709.93	18238.0
2019-06-12 15:00:00	NQ	Futures	8710.22	8711.68	8695.96	8705.86	27866.0
2019-06-12 16:00:00	NQ	Futures	8706.15	8709.64	8700.91	8707.9	6658.0
2019-06-12 18:00:00	NQ	Futures	8706.73	8719.25	8704.98	8715.76	1882.0
2019-06-12 19:00:00	NQ	Futures	8715.47	8726.53	8715.17	8723.04	2057.0
2019-06-12 20:00:00	NQ	Futures	8723.33	8734.1	8719.54	8727.11	5269.0
2019-06-12 21:00:00	NQ	Futures	8727.11	8731.48	8692.17	8695.08	7536.0
2019-06-12 22:00:00	NQ	Futures	8695.08	8695.67	8642.68	8668.88	14199.0
2019-06-12 23:00:00	NQ	Futures	8669.17	8699.74	8666.26	8685.77	7212.0
2019-06-12 00:00:00	YM	Futures	28332.6	28333.7	28320.7	28321.8	60.0
2019-06-12 01:00:00	YM	Futures	28320.7	28328.3	28271.7	28282.6	120.0
2019-06-12 02:00:00	YM	Futures	28282.6	28285.9	28253.3	28264.1	170.0
2019-06-12 03:00:00	YM	Futures	28266.3	28302.2	28263.0	28279.4	127.0

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

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