PREVIEW / futures_1hour / 2017-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-01.parquet
  size:    54 KB
  rows:    1,660

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-11-01 00:00:00	ES	Futures	2819.02	2819.84	2818.75	2819.29	3095.0
2017-11-01 01:00:00	ES	Futures	2819.57	2821.48	2818.75	2820.94	5202.0
2017-11-01 02:00:00	ES	Futures	2820.94	2821.48	2820.39	2820.39	4002.0
2017-11-01 03:00:00	ES	Futures	2820.39	2824.77	2820.39	2823.12	23059.0
2017-11-01 04:00:00	ES	Futures	2822.85	2823.95	2822.3	2823.67	20795.0
2017-11-01 05:00:00	ES	Futures	2823.67	2825.31	2822.85	2825.31	15439.0
2017-11-01 06:00:00	ES	Futures	2825.59	2827.5	2825.31	2826.68	23480.0
2017-11-01 07:00:00	ES	Futures	2826.68	2827.23	2824.77	2825.59	18415.0
2017-11-01 08:00:00	ES	Futures	2825.59	2826.68	2824.77	2825.31	23035.0
2017-11-01 09:00:00	ES	Futures	2825.31	2829.14	2823.12	2827.5	166280.0
2017-11-01 10:00:00	ES	Futures	2827.23	2827.78	2821.76	2823.4	189299.0
2017-11-01 11:00:00	ES	Futures	2823.67	2824.77	2817.65	2819.02	145902.0
2017-11-01 12:00:00	ES	Futures	2819.02	2821.76	2818.47	2819.57	84671.0
2017-11-01 13:00:00	ES	Futures	2819.57	2819.57	2813.82	2817.93	128754.0
2017-11-01 14:00:00	ES	Futures	2817.93	2821.48	2817.11	2820.39	122367.0
2017-11-01 15:00:00	ES	Futures	2820.12	2821.48	2817.65	2818.75	170946.0
2017-11-01 16:00:00	ES	Futures	2818.75	2819.29	2814.64	2815.19	79389.0
2017-11-01 18:00:00	ES	Futures	2813.82	2816.01	2813.82	2815.19	7183.0
2017-11-01 19:00:00	ES	Futures	2815.19	2816.56	2814.64	2816.01	3180.0
2017-11-01 20:00:00	ES	Futures	2816.01	2816.01	2805.07	2810.27	29335.0
2017-11-01 21:00:00	ES	Futures	2809.99	2811.09	2808.08	2809.45	10030.0
2017-11-01 22:00:00	ES	Futures	2809.17	2813.0	2809.17	2811.91	7940.0
2017-11-01 23:00:00	ES	Futures	2811.91	2812.73	2810.81	2812.18	5343.0
2017-11-01 00:00:00	NQ	Futures	7453.55	7456.83	7452.96	7454.74	779.0
2017-11-01 01:00:00	NQ	Futures	7455.04	7460.1	7452.36	7459.2	1381.0
2017-11-01 02:00:00	NQ	Futures	7458.91	7461.29	7456.23	7458.91	1310.0
2017-11-01 03:00:00	NQ	Futures	7458.61	7470.8	7458.31	7467.23	3624.0
2017-11-01 04:00:00	NQ	Futures	7466.94	7467.83	7463.07	7466.34	3267.0
2017-11-01 05:00:00	NQ	Futures	7466.04	7474.08	7464.26	7473.78	2409.0
2017-11-01 06:00:00	NQ	Futures	7474.08	7476.45	7466.04	7466.64	3939.0
2017-11-01 07:00:00	NQ	Futures	7466.64	7471.7	7464.26	7466.94	3322.0
2017-11-01 08:00:00	NQ	Futures	7466.64	7470.51	7463.07	7464.56	4660.0
2017-11-01 09:00:00	NQ	Futures	7464.26	7467.83	7445.52	7452.07	47952.0
2017-11-01 10:00:00	NQ	Futures	7452.07	7455.93	7433.63	7435.71	62612.0
2017-11-01 11:00:00	NQ	Futures	7436.01	7449.98	7425.89	7427.38	43137.0
2017-11-01 12:00:00	NQ	Futures	7427.38	7442.55	7427.08	7432.44	26544.0
2017-11-01 13:00:00	NQ	Futures	7432.14	7432.73	7403.88	7420.54	46118.0
2017-11-01 14:00:00	NQ	Futures	7421.14	7431.84	7417.27	7428.87	36119.0
2017-11-01 15:00:00	NQ	Futures	7429.17	7436.3	7423.22	7432.14	31895.0
2017-11-01 16:00:00	NQ	Futures	7432.14	7442.25	7415.78	7417.86	14845.0
2017-11-01 18:00:00	NQ	Futures	7411.62	7415.48	7407.75	7412.81	2198.0
2017-11-01 19:00:00	NQ	Futures	7412.51	7416.67	7410.13	7414.59	1002.0
2017-11-01 20:00:00	NQ	Futures	7414.59	7416.08	7376.82	7393.48	7400.0
2017-11-01 21:00:00	NQ	Futures	7394.07	7397.64	7386.34	7392.88	4002.0
2017-11-01 22:00:00	NQ	Futures	7393.18	7406.56	7392.29	7402.4	2454.0
2017-11-01 23:00:00	NQ	Futures	7401.8	7406.56	7398.53	7406.56	1751.0
2017-11-01 00:00:00	YM	Futures	25417.0	25429.0	25417.0	25424.6	842.0
2017-11-01 01:00:00	YM	Futures	25424.6	25443.1	25421.4	25436.6	1286.0
2017-11-01 02:00:00	YM	Futures	25436.6	25438.8	25427.9	25430.1	802.0
2017-11-01 03:00:00	YM	Futures	25429.0	25479.0	25429.0	25467.0	5109.0

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

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