PREVIEW / futures_1hour / 2017-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-03.parquet
  size:    54 KB
  rows:    1,653

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-04-03 00:00:00	ES	Futures	2577.38	2577.65	2576.56	2577.65	2577.0
2017-04-03 01:00:00	ES	Futures	2577.65	2579.02	2577.38	2578.47	5966.0
2017-04-03 02:00:00	ES	Futures	2578.74	2582.02	2578.47	2581.47	9354.0
2017-04-03 03:00:00	ES	Futures	2581.75	2581.75	2578.74	2579.29	11229.0
2017-04-03 04:00:00	ES	Futures	2579.29	2579.29	2577.92	2579.02	10701.0
2017-04-03 05:00:00	ES	Futures	2579.02	2581.2	2578.47	2580.93	8688.0
2017-04-03 06:00:00	ES	Futures	2581.2	2581.2	2577.38	2577.65	12417.0
2017-04-03 07:00:00	ES	Futures	2577.65	2577.92	2576.56	2576.83	10259.0
2017-04-03 08:00:00	ES	Futures	2577.1	2579.02	2576.28	2578.47	14929.0
2017-04-03 09:00:00	ES	Futures	2578.47	2580.38	2576.28	2577.1	146362.0
2017-04-03 10:00:00	ES	Futures	2577.1	2578.74	2564.81	2565.36	299783.0
2017-04-03 11:00:00	ES	Futures	2565.09	2567.0	2559.35	2561.26	253683.0
2017-04-03 12:00:00	ES	Futures	2561.26	2567.0	2556.62	2567.0	186170.0
2017-04-03 13:00:00	ES	Futures	2566.72	2568.36	2562.63	2565.91	138158.0
2017-04-03 14:00:00	ES	Futures	2566.18	2571.64	2562.9	2570.28	164505.0
2017-04-03 15:00:00	ES	Futures	2570.28	2574.65	2569.46	2572.73	288677.0
2017-04-03 16:00:00	ES	Futures	2573.01	2575.74	2572.19	2572.46	97620.0
2017-04-03 18:00:00	ES	Futures	2572.19	2573.55	2571.64	2572.46	4298.0
2017-04-03 19:00:00	ES	Futures	2572.73	2573.28	2572.19	2572.46	1990.0
2017-04-03 20:00:00	ES	Futures	2572.19	2572.46	2568.36	2570.82	10234.0
2017-04-03 21:00:00	ES	Futures	2570.55	2571.64	2569.73	2571.09	4197.0
2017-04-03 22:00:00	ES	Futures	2571.09	2571.64	2570.28	2570.28	3038.0
2017-04-03 23:00:00	ES	Futures	2570.28	2570.55	2568.64	2570.28	4332.0
2017-04-03 00:00:00	NQ	Futures	6488.43	6489.62	6487.23	6489.32	562.0
2017-04-03 01:00:00	NQ	Futures	6489.62	6492.3	6489.62	6492.0	1006.0
2017-04-03 02:00:00	NQ	Futures	6492.0	6500.35	6492.0	6498.86	1927.0
2017-04-03 03:00:00	NQ	Futures	6498.86	6499.16	6490.21	6492.3	1931.0
2017-04-03 04:00:00	NQ	Futures	6492.6	6492.9	6489.02	6492.3	1267.0
2017-04-03 05:00:00	NQ	Futures	6492.6	6497.37	6490.21	6497.37	1254.0
2017-04-03 06:00:00	NQ	Futures	6497.37	6497.67	6489.92	6490.81	1541.0
2017-04-03 07:00:00	NQ	Futures	6490.51	6491.7	6488.72	6489.32	1331.0
2017-04-03 08:00:00	NQ	Futures	6489.62	6494.69	6488.13	6492.3	2373.0
2017-04-03 09:00:00	NQ	Futures	6492.0	6505.42	6486.64	6495.28	28181.0
2017-04-03 10:00:00	NQ	Futures	6494.98	6501.54	6468.75	6469.64	56095.0
2017-04-03 11:00:00	NQ	Futures	6469.64	6474.11	6453.84	6458.31	50493.0
2017-04-03 12:00:00	NQ	Futures	6458.31	6470.24	6443.7	6469.94	29581.0
2017-04-03 13:00:00	NQ	Futures	6469.94	6474.41	6458.01	6466.96	19895.0
2017-04-03 14:00:00	NQ	Futures	6467.26	6482.76	6461.0	6477.99	21197.0
2017-04-03 15:00:00	NQ	Futures	6477.99	6488.43	6476.8	6479.18	29807.0
2017-04-03 16:00:00	NQ	Futures	6479.18	6487.23	6477.1	6479.48	5887.0
2017-04-03 18:00:00	NQ	Futures	6478.88	6481.27	6476.8	6478.88	680.0
2017-04-03 19:00:00	NQ	Futures	6479.48	6480.97	6478.59	6478.88	364.0
2017-04-03 20:00:00	NQ	Futures	6478.59	6478.59	6469.64	6476.5	1983.0
2017-04-03 21:00:00	NQ	Futures	6476.5	6477.69	6472.92	6475.9	846.0
2017-04-03 22:00:00	NQ	Futures	6475.9	6477.1	6473.82	6474.41	589.0
2017-04-03 23:00:00	NQ	Futures	6474.41	6475.31	6471.43	6474.11	1012.0
2017-04-03 00:00:00	YM	Futures	22395.5	22400.9	22393.3	22398.8	358.0
2017-04-03 01:00:00	YM	Futures	22398.8	22407.5	22398.8	22403.1	1007.0
2017-04-03 02:00:00	YM	Futures	22404.2	22440.1	22404.2	22435.7	2439.0
2017-04-03 03:00:00	YM	Futures	22436.8	22436.8	22407.5	22412.9	2542.0

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

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