PREVIEW / futures_1hour / 2018-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-24.parquet
  size:    53 KB
  rows:    1,675

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
2018-07-24 00:00:00	ES	Futures	3071.51	3071.79	3070.42	3071.24	1821.0
2018-07-24 01:00:00	ES	Futures	3070.97	3071.79	3069.88	3070.42	2734.0
2018-07-24 02:00:00	ES	Futures	3070.42	3070.7	3068.52	3068.52	5601.0
2018-07-24 03:00:00	ES	Futures	3068.52	3068.79	3063.61	3066.61	18067.0
2018-07-24 04:00:00	ES	Futures	3066.61	3070.7	3066.06	3069.88	12619.0
2018-07-24 05:00:00	ES	Futures	3069.88	3072.6	3069.88	3072.06	10890.0
2018-07-24 06:00:00	ES	Futures	3072.06	3072.6	3069.88	3071.51	10898.0
2018-07-24 07:00:00	ES	Futures	3071.51	3072.33	3070.15	3072.06	14029.0
2018-07-24 08:00:00	ES	Futures	3071.79	3078.32	3071.79	3075.87	42173.0
2018-07-24 09:00:00	ES	Futures	3075.87	3082.96	3075.33	3080.23	167279.0
2018-07-24 10:00:00	ES	Futures	3080.23	3085.68	3079.41	3082.41	196514.0
2018-07-24 11:00:00	ES	Futures	3082.14	3083.5	3073.96	3078.05	199656.0
2018-07-24 12:00:00	ES	Futures	3078.05	3081.05	3073.42	3074.51	102663.0
2018-07-24 13:00:00	ES	Futures	3074.51	3076.96	3066.06	3069.88	165839.0
2018-07-24 14:00:00	ES	Futures	3070.15	3070.97	3064.7	3069.88	126082.0
2018-07-24 15:00:00	ES	Futures	3070.15	3075.33	3068.24	3074.51	141050.0
2018-07-24 16:00:00	ES	Futures	3074.51	3075.6	3071.79	3072.33	57349.0
2018-07-24 18:00:00	ES	Futures	3072.6	3072.87	3070.15	3071.24	5023.0
2018-07-24 19:00:00	ES	Futures	3071.24	3072.6	3070.42	3072.33	2142.0
2018-07-24 20:00:00	ES	Futures	3072.06	3073.42	3067.43	3069.06	9285.0
2018-07-24 21:00:00	ES	Futures	3069.06	3070.97	3067.43	3069.88	9745.0
2018-07-24 22:00:00	ES	Futures	3069.88	3070.7	3068.24	3070.7	3327.0
2018-07-24 23:00:00	ES	Futures	3070.42	3071.24	3068.79	3068.79	2295.0
2018-07-24 00:00:00	NQ	Futures	8766.59	8768.36	8763.36	8764.83	967.0
2018-07-24 01:00:00	NQ	Futures	8764.53	8766.3	8757.76	8758.94	1463.0
2018-07-24 02:00:00	NQ	Futures	8759.23	8760.12	8753.35	8754.52	1496.0
2018-07-24 03:00:00	NQ	Futures	8754.23	8754.52	8741.57	8748.05	4828.0
2018-07-24 04:00:00	NQ	Futures	8748.05	8759.53	8746.87	8756.88	4616.0
2018-07-24 05:00:00	NQ	Futures	8757.47	8769.54	8757.17	8767.77	3560.0
2018-07-24 06:00:00	NQ	Futures	8768.07	8768.95	8758.65	8765.71	3119.0
2018-07-24 07:00:00	NQ	Futures	8765.42	8769.54	8758.35	8767.18	3318.0
2018-07-24 08:00:00	NQ	Futures	8767.48	8789.27	8767.18	8781.02	9992.0
2018-07-24 09:00:00	NQ	Futures	8781.02	8817.53	8780.14	8794.86	55254.0
2018-07-24 10:00:00	NQ	Futures	8795.15	8820.47	8790.74	8791.33	56391.0
2018-07-24 11:00:00	NQ	Futures	8791.33	8796.33	8740.98	8755.41	70916.0
2018-07-24 12:00:00	NQ	Futures	8755.41	8764.83	8716.54	8724.49	44471.0
2018-07-24 13:00:00	NQ	Futures	8724.79	8734.8	8699.17	8721.25	48083.0
2018-07-24 14:00:00	NQ	Futures	8721.84	8730.97	8702.12	8728.32	37707.0
2018-07-24 15:00:00	NQ	Futures	8728.32	8737.74	8713.89	8735.68	36008.0
2018-07-24 16:00:00	NQ	Futures	8735.39	8738.33	8725.08	8728.61	6383.0
2018-07-24 18:00:00	NQ	Futures	8727.14	8731.56	8722.73	8725.67	919.0
2018-07-24 19:00:00	NQ	Futures	8725.97	8731.56	8723.02	8730.68	1052.0
2018-07-24 20:00:00	NQ	Futures	8730.38	8732.44	8711.24	8716.84	2996.0
2018-07-24 21:00:00	NQ	Futures	8716.84	8727.44	8713.6	8723.02	3726.0
2018-07-24 22:00:00	NQ	Futures	8723.02	8726.85	8716.54	8726.26	1478.0
2018-07-24 23:00:00	NQ	Futures	8725.38	8730.97	8722.43	8723.02	1115.0
2018-07-24 00:00:00	YM	Futures	27304.6	27305.7	27290.5	27297.0	729.0
2018-07-24 01:00:00	YM	Futures	27295.9	27304.6	27285.0	27294.8	876.0
2018-07-24 02:00:00	YM	Futures	27293.7	27299.2	27266.5	27268.7	2550.0
2018-07-24 03:00:00	YM	Futures	27268.7	27269.8	27220.9	27250.2	3533.0

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

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