PREVIEW / futures_1hour / 2016-12-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-13.parquet
  size:    51 KB
  rows:    1,577

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
2016-12-13 00:00:00	ES	Futures	2454.7	2458.23	2454.42	2458.23	1507.0
2016-12-13 01:00:00	ES	Futures	2457.96	2459.05	2457.15	2457.15	1228.0
2016-12-13 02:00:00	ES	Futures	2457.15	2458.23	2456.6	2457.15	2394.0
2016-12-13 03:00:00	ES	Futures	2457.42	2461.5	2456.87	2461.23	4800.0
2016-12-13 04:00:00	ES	Futures	2461.23	2462.59	2460.41	2461.5	4073.0
2016-12-13 05:00:00	ES	Futures	2462.04	2462.59	2460.95	2462.31	3335.0
2016-12-13 06:00:00	ES	Futures	2462.59	2463.4	2461.77	2461.77	5297.0
2016-12-13 07:00:00	ES	Futures	2461.77	2465.04	2460.95	2464.49	5333.0
2016-12-13 08:00:00	ES	Futures	2464.49	2464.49	2462.59	2463.95	6089.0
2016-12-13 09:00:00	ES	Futures	2463.95	2474.01	2463.4	2470.75	51208.0
2016-12-13 10:00:00	ES	Futures	2471.02	2471.57	2465.04	2468.57	49200.0
2016-12-13 11:00:00	ES	Futures	2468.84	2472.65	2467.21	2472.11	29717.0
2016-12-13 12:00:00	ES	Futures	2471.84	2475.37	2471.84	2473.47	20210.0
2016-12-13 13:00:00	ES	Futures	2473.47	2479.46	2473.2	2476.46	27434.0
2016-12-13 14:00:00	ES	Futures	2476.19	2476.46	2471.57	2473.47	26657.0
2016-12-13 15:00:00	ES	Futures	2473.2	2476.46	2471.57	2472.38	33490.0
2016-12-13 16:00:00	ES	Futures	2472.38	2474.83	2471.57	2474.29	14289.0
2016-12-13 18:00:00	ES	Futures	2474.01	2474.01	2472.93	2473.2	772.0
2016-12-13 19:00:00	ES	Futures	2473.47	2473.74	2472.11	2472.11	846.0
2016-12-13 20:00:00	ES	Futures	2472.11	2472.93	2471.29	2472.65	693.0
2016-12-13 21:00:00	ES	Futures	2472.65	2473.2	2472.38	2472.38	557.0
2016-12-13 22:00:00	ES	Futures	2472.38	2473.47	2471.57	2473.2	701.0
2016-12-13 23:00:00	ES	Futures	2473.2	2474.01	2473.2	2474.01	730.0
2016-12-13 00:00:00	NQ	Futures	5810.97	5821.71	5809.77	5821.71	355.0
2016-12-13 01:00:00	NQ	Futures	5821.71	5823.8	5819.02	5819.92	135.0
2016-12-13 02:00:00	NQ	Futures	5819.32	5823.2	5818.43	5819.92	165.0
2016-12-13 03:00:00	NQ	Futures	5820.81	5831.25	5818.43	5827.97	792.0
2016-12-13 04:00:00	NQ	Futures	5827.38	5830.66	5824.69	5827.38	326.0
2016-12-13 05:00:00	NQ	Futures	5827.67	5830.36	5825.59	5829.46	180.0
2016-12-13 06:00:00	NQ	Futures	5830.06	5831.55	5826.18	5827.08	199.0
2016-12-13 07:00:00	NQ	Futures	5826.78	5834.54	5824.99	5833.34	297.0
2016-12-13 08:00:00	NQ	Futures	5833.34	5835.13	5830.06	5833.04	629.0
2016-12-13 09:00:00	NQ	Futures	5833.94	5896.59	5829.46	5888.53	14758.0
2016-12-13 10:00:00	NQ	Futures	5888.53	5906.73	5877.2	5901.66	12159.0
2016-12-13 11:00:00	NQ	Futures	5901.96	5919.56	5895.99	5916.58	6750.0
2016-12-13 12:00:00	NQ	Futures	5916.88	5921.35	5903.75	5905.24	5071.0
2016-12-13 13:00:00	NQ	Futures	5904.64	5921.35	5903.15	5914.79	3297.0
2016-12-13 14:00:00	NQ	Futures	5914.79	5915.98	5897.48	5904.35	3273.0
2016-12-13 15:00:00	NQ	Futures	5904.35	5908.52	5884.95	5889.73	5484.0
2016-12-13 16:00:00	NQ	Futures	5889.13	5897.19	5886.74	5894.8	1584.0
2016-12-13 18:00:00	NQ	Futures	5894.5	5896.29	5892.71	5894.5	49.0
2016-12-13 19:00:00	NQ	Futures	5894.8	5895.69	5892.71	5893.01	186.0
2016-12-13 20:00:00	NQ	Futures	5891.52	5895.69	5889.73	5894.5	93.0
2016-12-13 21:00:00	NQ	Futures	5895.99	5897.48	5893.31	5895.69	177.0
2016-12-13 22:00:00	NQ	Futures	5894.8	5896.89	5893.31	5896.89	104.0
2016-12-13 23:00:00	NQ	Futures	5897.48	5899.57	5897.48	5898.08	63.0
2016-12-13 00:00:00	YM	Futures	21405.7	21427.4	21403.5	21427.4	988.0
2016-12-13 01:00:00	YM	Futures	21427.4	21433.9	21422.0	21422.0	565.0
2016-12-13 02:00:00	YM	Futures	21423.0	21433.9	21422.0	21425.2	1265.0
2016-12-13 03:00:00	YM	Futures	21425.2	21465.3	21424.1	21459.9	3151.0

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

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