PREVIEW / futures_1hour / 2017-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-18.parquet
  size:    57 KB
  rows:    1,695

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-05-18 00:00:00	ES	Futures	2581.47	2581.75	2580.93	2581.47	3394.0
2017-05-18 01:00:00	ES	Futures	2581.75	2582.02	2580.65	2581.2	4709.0
2017-05-18 02:00:00	ES	Futures	2581.47	2586.12	2581.2	2584.48	25533.0
2017-05-18 03:00:00	ES	Futures	2584.48	2585.03	2575.74	2577.65	46818.0
2017-05-18 04:00:00	ES	Futures	2577.38	2579.29	2574.1	2579.02	36476.0
2017-05-18 05:00:00	ES	Futures	2578.74	2579.02	2561.53	2562.63	86725.0
2017-05-18 06:00:00	ES	Futures	2562.63	2568.91	2562.35	2565.09	40625.0
2017-05-18 07:00:00	ES	Futures	2565.09	2572.46	2563.99	2571.09	51941.0
2017-05-18 08:00:00	ES	Futures	2571.37	2572.46	2562.9	2566.18	98245.0
2017-05-18 09:00:00	ES	Futures	2565.91	2577.1	2565.36	2571.91	333542.0
2017-05-18 10:00:00	ES	Futures	2571.91	2586.66	2571.91	2582.57	380650.0
2017-05-18 11:00:00	ES	Futures	2582.57	2585.3	2577.1	2577.38	197541.0
2017-05-18 12:00:00	ES	Futures	2577.38	2582.84	2574.92	2579.56	178033.0
2017-05-18 13:00:00	ES	Futures	2579.56	2585.3	2576.28	2583.39	137845.0
2017-05-18 14:00:00	ES	Futures	2583.39	2594.86	2583.11	2588.85	283702.0
2017-05-18 15:00:00	ES	Futures	2588.58	2590.49	2582.29	2583.66	361356.0
2017-05-18 16:00:00	ES	Futures	2583.39	2584.48	2580.65	2582.57	103862.0
2017-05-18 18:00:00	ES	Futures	2582.84	2584.75	2582.57	2584.21	5151.0
2017-05-18 19:00:00	ES	Futures	2584.48	2584.75	2582.57	2583.93	4276.0
2017-05-18 20:00:00	ES	Futures	2583.93	2584.48	2582.57	2583.11	9062.0
2017-05-18 21:00:00	ES	Futures	2583.11	2583.11	2579.56	2580.11	9351.0
2017-05-18 22:00:00	ES	Futures	2580.38	2581.75	2579.84	2581.47	4076.0
2017-05-18 23:00:00	ES	Futures	2581.47	2583.39	2580.11	2582.84	3634.0
2017-05-18 00:00:00	NQ	Futures	6677.45	6677.45	6674.46	6674.76	970.0
2017-05-18 01:00:00	NQ	Futures	6674.76	6676.55	6673.57	6674.76	1081.0
2017-05-18 02:00:00	NQ	Futures	6674.76	6684.01	6674.76	6678.94	3753.0
2017-05-18 03:00:00	NQ	Futures	6678.94	6680.73	6657.17	6661.64	7668.0
2017-05-18 04:00:00	NQ	Futures	6661.35	6663.43	6650.02	6662.54	6200.0
2017-05-18 05:00:00	NQ	Futures	6662.24	6662.54	6619.31	6621.4	17019.0
2017-05-18 06:00:00	NQ	Futures	6621.69	6639.88	6621.69	6631.23	10778.0
2017-05-18 07:00:00	NQ	Futures	6630.94	6650.61	6627.36	6647.04	11595.0
2017-05-18 08:00:00	NQ	Futures	6647.63	6652.4	6628.85	6645.84	21597.0
2017-05-18 09:00:00	NQ	Futures	6645.54	6688.18	6644.05	6677.74	86601.0
2017-05-18 10:00:00	NQ	Futures	6678.04	6722.76	6677.74	6707.56	95352.0
2017-05-18 11:00:00	NQ	Futures	6707.56	6717.1	6685.79	6687.28	47659.0
2017-05-18 12:00:00	NQ	Futures	6687.28	6706.66	6679.83	6696.23	44156.0
2017-05-18 13:00:00	NQ	Futures	6696.23	6717.4	6688.18	6710.54	36601.0
2017-05-18 14:00:00	NQ	Futures	6710.24	6736.18	6709.65	6717.4	49008.0
2017-05-18 15:00:00	NQ	Futures	6717.4	6728.13	6709.05	6713.22	51880.0
2017-05-18 16:00:00	NQ	Futures	6713.22	6718.29	6711.73	6717.69	9083.0
2017-05-18 18:00:00	NQ	Futures	6715.91	6723.66	6715.91	6723.36	966.0
2017-05-18 19:00:00	NQ	Futures	6723.36	6723.66	6715.61	6717.4	1202.0
2017-05-18 20:00:00	NQ	Futures	6716.8	6718.29	6710.24	6713.52	2417.0
2017-05-18 21:00:00	NQ	Futures	6713.52	6713.52	6705.17	6706.96	2471.0
2017-05-18 22:00:00	NQ	Futures	6707.26	6710.84	6704.58	6709.65	1569.0
2017-05-18 23:00:00	NQ	Futures	6709.35	6717.1	6706.66	6715.01	1178.0
2017-05-18 00:00:00	YM	Futures	22417.2	22423.8	22414.0	22420.5	594.0
2017-05-18 01:00:00	YM	Futures	22421.6	22424.8	22411.8	22420.5	1059.0
2017-05-18 02:00:00	YM	Futures	22420.5	22454.2	22420.5	22434.6	3771.0
2017-05-18 03:00:00	YM	Futures	22434.6	22441.2	22375.9	22392.2	7752.0

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

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