PREVIEW / futures_1hour / 2017-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-19.parquet
  size:    54 KB
  rows:    1,638

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
2017-10-19 00:00:00	ES	Futures	2800.15	2800.69	2799.33	2800.69	3953.0
2017-10-19 01:00:00	ES	Futures	2800.42	2800.69	2799.33	2799.33	4896.0
2017-10-19 02:00:00	ES	Futures	2799.33	2800.42	2797.14	2797.68	9257.0
2017-10-19 03:00:00	ES	Futures	2797.96	2798.5	2786.19	2787.84	50231.0
2017-10-19 04:00:00	ES	Futures	2787.84	2791.12	2782.09	2790.3	83721.0
2017-10-19 05:00:00	ES	Futures	2790.3	2791.94	2788.93	2789.75	22628.0
2017-10-19 06:00:00	ES	Futures	2790.02	2791.12	2785.65	2787.84	31791.0
2017-10-19 07:00:00	ES	Futures	2787.56	2789.48	2784.01	2788.11	51796.0
2017-10-19 08:00:00	ES	Futures	2788.11	2790.84	2786.19	2790.84	44863.0
2017-10-19 09:00:00	ES	Futures	2790.57	2795.5	2786.74	2787.84	234929.0
2017-10-19 10:00:00	ES	Futures	2787.84	2794.67	2785.1	2794.4	229366.0
2017-10-19 11:00:00	ES	Futures	2794.67	2795.22	2793.03	2793.31	93695.0
2017-10-19 12:00:00	ES	Futures	2793.31	2795.5	2792.21	2795.22	56492.0
2017-10-19 13:00:00	ES	Futures	2794.95	2798.78	2794.95	2797.41	76841.0
2017-10-19 14:00:00	ES	Futures	2797.41	2799.6	2796.59	2798.5	60936.0
2017-10-19 15:00:00	ES	Futures	2798.78	2801.79	2797.68	2801.79	185405.0
2017-10-19 16:00:00	ES	Futures	2801.51	2802.88	2801.24	2802.33	82168.0
2017-10-19 18:00:00	ES	Futures	2802.33	2802.33	2801.24	2801.24	4250.0
2017-10-19 19:00:00	ES	Futures	2801.51	2802.06	2800.69	2801.79	4584.0
2017-10-19 20:00:00	ES	Futures	2801.79	2802.06	2801.24	2801.79	3390.0
2017-10-19 21:00:00	ES	Futures	2801.79	2813.0	2800.69	2811.64	38373.0
2017-10-19 22:00:00	ES	Futures	2811.91	2814.1	2809.72	2811.64	27381.0
2017-10-19 23:00:00	ES	Futures	2811.64	2811.64	2809.72	2810.54	8040.0
2017-10-19 00:00:00	NQ	Futures	7275.1	7277.78	7271.83	7277.48	996.0
2017-10-19 01:00:00	NQ	Futures	7277.48	7277.78	7275.1	7275.1	698.0
2017-10-19 02:00:00	NQ	Futures	7275.4	7276.0	7264.69	7268.26	2067.0
2017-10-19 03:00:00	NQ	Futures	7268.26	7270.34	7212.35	7220.68	12296.0
2017-10-19 04:00:00	NQ	Futures	7220.38	7237.63	7203.43	7234.06	12971.0
2017-10-19 05:00:00	NQ	Futures	7234.06	7242.98	7229.9	7236.14	4266.0
2017-10-19 06:00:00	NQ	Futures	7236.44	7239.12	7218.59	7226.33	6479.0
2017-10-19 07:00:00	NQ	Futures	7226.03	7233.17	7217.11	7229.3	7295.0
2017-10-19 08:00:00	NQ	Futures	7229.3	7240.9	7223.65	7239.12	9045.0
2017-10-19 09:00:00	NQ	Futures	7239.12	7246.85	7200.45	7210.86	71592.0
2017-10-19 10:00:00	NQ	Futures	7210.86	7234.06	7198.97	7234.06	71786.0
2017-10-19 11:00:00	NQ	Futures	7233.76	7242.09	7223.06	7225.44	29528.0
2017-10-19 12:00:00	NQ	Futures	7225.44	7230.49	7218.89	7226.62	20128.0
2017-10-19 13:00:00	NQ	Futures	7226.33	7240.31	7226.03	7234.06	16304.0
2017-10-19 14:00:00	NQ	Futures	7234.36	7241.5	7228.71	7238.52	16359.0
2017-10-19 15:00:00	NQ	Futures	7238.52	7249.82	7237.33	7249.53	35165.0
2017-10-19 16:00:00	NQ	Futures	7249.53	7256.96	7248.93	7255.77	9070.0
2017-10-19 18:00:00	NQ	Futures	7254.28	7254.28	7248.04	7249.23	1142.0
2017-10-19 19:00:00	NQ	Futures	7249.53	7251.91	7247.15	7251.01	1098.0
2017-10-19 20:00:00	NQ	Futures	7251.01	7251.61	7247.74	7248.93	1070.0
2017-10-19 21:00:00	NQ	Futures	7248.93	7286.11	7245.66	7281.65	7253.0
2017-10-19 22:00:00	NQ	Futures	7281.94	7292.06	7278.38	7282.84	6092.0
2017-10-19 23:00:00	NQ	Futures	7282.84	7283.73	7275.4	7278.67	2301.0
2017-10-19 00:00:00	YM	Futures	25138.6	25140.7	25128.8	25139.6	801.0
2017-10-19 01:00:00	YM	Futures	25140.7	25141.8	25132.0	25134.2	959.0
2017-10-19 02:00:00	YM	Futures	25133.1	25136.4	25108.1	25115.7	2438.0
2017-10-19 03:00:00	YM	Futures	25115.7	25119.0	25027.6	25039.6	7742.0

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

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