PREVIEW / futures_1hour / 2019-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-17.parquet
  size:    54 KB
  rows:    1,803

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-17 00:00:00	ES	Futures	3142.89	3143.16	3141.53	3142.34	2909.0
2019-06-17 01:00:00	ES	Futures	3142.34	3143.7	3140.99	3141.53	4458.0
2019-06-17 02:00:00	ES	Futures	3141.53	3141.8	3138.83	3139.1	6343.0
2019-06-17 03:00:00	ES	Futures	3139.1	3140.18	3136.12	3137.2	13529.0
2019-06-17 04:00:00	ES	Futures	3137.47	3139.64	3136.66	3138.55	9814.0
2019-06-17 05:00:00	ES	Futures	3138.55	3140.18	3137.2	3138.01	9939.0
2019-06-17 06:00:00	ES	Futures	3138.01	3138.28	3134.76	3135.58	8273.0
2019-06-17 07:00:00	ES	Futures	3135.31	3140.18	3134.76	3139.37	12275.0
2019-06-17 08:00:00	ES	Futures	3139.37	3140.18	3133.41	3133.95	23029.0
2019-06-17 09:00:00	ES	Futures	3133.95	3139.64	3131.52	3138.01	140118.0
2019-06-17 10:00:00	ES	Futures	3138.01	3143.16	3135.85	3140.99	136296.0
2019-06-17 11:00:00	ES	Futures	3140.99	3143.16	3136.66	3138.01	80600.0
2019-06-17 12:00:00	ES	Futures	3138.01	3138.83	3135.31	3138.28	57437.0
2019-06-17 13:00:00	ES	Futures	3138.28	3140.99	3137.2	3140.72	41162.0
2019-06-17 14:00:00	ES	Futures	3140.72	3142.34	3137.47	3138.01	51225.0
2019-06-17 15:00:00	ES	Futures	3137.74	3139.64	3131.79	3134.76	141268.0
2019-06-17 16:00:00	ES	Futures	3134.49	3138.01	3133.95	3137.74	32765.0
2019-06-17 18:00:00	ES	Futures	3138.01	3138.83	3136.93	3136.93	1993.0
2019-06-17 19:00:00	ES	Futures	3137.2	3138.55	3135.58	3136.39	2247.0
2019-06-17 20:00:00	ES	Futures	3136.39	3139.1	3135.85	3138.01	5856.0
2019-06-17 21:00:00	ES	Futures	3138.28	3140.18	3136.12	3136.93	10288.0
2019-06-17 22:00:00	ES	Futures	3136.93	3139.37	3136.66	3138.55	5784.0
2019-06-17 23:00:00	ES	Futures	3138.55	3139.37	3134.76	3135.58	5040.0
2019-06-17 00:00:00	NQ	Futures	8747.79	8748.96	8744.02	8747.5	1455.0
2019-06-17 01:00:00	NQ	Futures	8747.21	8752.44	8744.02	8745.18	1365.0
2019-06-17 02:00:00	NQ	Futures	8744.89	8745.18	8733.87	8734.45	2576.0
2019-06-17 03:00:00	NQ	Futures	8734.16	8739.09	8720.81	8726.03	4029.0
2019-06-17 04:00:00	NQ	Futures	8726.32	8735.03	8723.13	8733.29	2445.0
2019-06-17 05:00:00	NQ	Futures	8733.58	8740.25	8725.74	8728.94	3139.0
2019-06-17 06:00:00	NQ	Futures	8729.23	8730.39	8715.01	8718.49	2364.0
2019-06-17 07:00:00	NQ	Futures	8719.07	8739.67	8715.88	8736.48	3065.0
2019-06-17 08:00:00	NQ	Futures	8737.06	8740.83	8720.81	8722.84	5676.0
2019-06-17 09:00:00	NQ	Futures	8723.42	8790.16	8722.55	8780.0	49213.0
2019-06-17 10:00:00	NQ	Futures	8780.0	8793.35	8766.65	8787.25	40934.0
2019-06-17 11:00:00	NQ	Futures	8787.25	8794.22	8765.2	8768.97	26208.0
2019-06-17 12:00:00	NQ	Futures	8768.68	8778.84	8762.59	8776.23	14137.0
2019-06-17 13:00:00	NQ	Futures	8776.52	8786.38	8774.49	8783.19	10663.0
2019-06-17 14:00:00	NQ	Futures	8783.48	8788.99	8773.04	8774.2	12084.0
2019-06-17 15:00:00	NQ	Futures	8774.2	8784.06	8759.11	8769.27	30906.0
2019-06-17 16:00:00	NQ	Futures	8768.97	8784.35	8766.65	8784.35	5962.0
2019-06-17 18:00:00	NQ	Futures	8786.09	8786.09	8779.13	8779.13	915.0
2019-06-17 19:00:00	NQ	Futures	8779.13	8784.93	8775.65	8777.68	916.0
2019-06-17 20:00:00	NQ	Futures	8778.26	8785.22	8776.52	8782.32	1614.0
2019-06-17 21:00:00	NQ	Futures	8782.9	8791.9	8778.84	8782.61	3802.0
2019-06-17 22:00:00	NQ	Futures	8782.32	8790.74	8780.87	8787.83	1725.0
2019-06-17 23:00:00	NQ	Futures	8788.99	8791.03	8778.55	8781.16	1503.0
2019-06-17 00:00:00	YM	Futures	28488.2	28489.2	28471.8	28482.7	1049.0
2019-06-17 01:00:00	YM	Futures	28482.7	28491.4	28467.5	28470.8	873.0
2019-06-17 02:00:00	YM	Futures	28470.8	28470.8	28445.7	28452.3	1299.0
2019-06-17 03:00:00	YM	Futures	28452.3	28468.6	28427.3	28433.8	2950.0

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

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