PREVIEW / futures_1hour / 2016-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-04.parquet
  size:    46 KB
  rows:    1,354

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-11-04 00:00:00	ES	Futures	2268.87	2269.41	2268.59	2269.14	1561.0
2016-11-04 01:00:00	ES	Futures	2268.87	2269.68	2268.32	2268.59	2945.0
2016-11-04 02:00:00	ES	Futures	2268.59	2271.04	2267.78	2269.96	5586.0
2016-11-04 03:00:00	ES	Futures	2269.96	2270.5	2268.05	2269.41	10067.0
2016-11-04 04:00:00	ES	Futures	2269.41	2269.68	2265.33	2268.32	27672.0
2016-11-04 05:00:00	ES	Futures	2268.05	2269.41	2264.24	2266.42	27241.0
2016-11-04 06:00:00	ES	Futures	2266.42	2268.05	2265.06	2266.69	18268.0
2016-11-04 07:00:00	ES	Futures	2266.69	2268.05	2265.6	2267.51	21553.0
2016-11-04 08:00:00	ES	Futures	2267.51	2272.68	2265.33	2270.77	81245.0
2016-11-04 09:00:00	ES	Futures	2270.77	2272.13	2262.61	2264.79	405891.0
2016-11-04 10:00:00	ES	Futures	2264.79	2274.04	2264.51	2272.13	351837.0
2016-11-04 11:00:00	ES	Futures	2272.4	2277.03	2271.59	2273.76	265896.0
2016-11-04 12:00:00	ES	Futures	2273.76	2279.21	2273.76	2277.85	146251.0
2016-11-04 13:00:00	ES	Futures	2277.85	2278.93	2275.94	2277.03	101794.0
2016-11-04 14:00:00	ES	Futures	2277.03	2277.57	2270.5	2271.59	147664.0
2016-11-04 15:00:00	ES	Futures	2271.59	2271.86	2262.61	2263.97	307134.0
2016-11-04 16:00:00	ES	Futures	2263.97	2266.15	2262.34	2265.33	98694.0
2016-11-04 00:00:00	NQ	Futures	5580.35	5581.55	5578.86	5580.06	197.0
2016-11-04 01:00:00	NQ	Futures	5579.76	5582.74	5579.46	5580.95	494.0
2016-11-04 02:00:00	NQ	Futures	5580.95	5587.51	5579.46	5584.53	1049.0
2016-11-04 03:00:00	NQ	Futures	5584.23	5585.13	5579.46	5583.64	1569.0
2016-11-04 04:00:00	NQ	Futures	5583.34	5583.64	5572.9	5579.76	4095.0
2016-11-04 05:00:00	NQ	Futures	5579.76	5580.95	5571.11	5572.3	3855.0
2016-11-04 06:00:00	NQ	Futures	5572.6	5575.58	5570.21	5573.49	3016.0
2016-11-04 07:00:00	NQ	Futures	5573.19	5579.46	5572.0	5577.97	3518.0
2016-11-04 08:00:00	NQ	Futures	5577.67	5586.92	5570.51	5581.85	9395.0
2016-11-04 09:00:00	NQ	Futures	5582.14	5589.9	5550.52	5562.16	59478.0
2016-11-04 10:00:00	NQ	Futures	5562.45	5593.78	5562.45	5587.81	48369.0
2016-11-04 11:00:00	NQ	Futures	5588.11	5598.55	5582.14	5589.01	29108.0
2016-11-04 12:00:00	NQ	Futures	5589.01	5601.54	5588.41	5601.24	22162.0
2016-11-04 13:00:00	NQ	Futures	5600.94	5603.33	5591.99	5594.97	13984.0
2016-11-04 14:00:00	NQ	Futures	5594.67	5594.97	5574.09	5575.88	16946.0
2016-11-04 15:00:00	NQ	Futures	5576.18	5576.77	5555.0	5557.98	32911.0
2016-11-04 16:00:00	NQ	Futures	5557.68	5564.84	5555.59	5562.16	7912.0
2016-11-04 00:00:00	YM	Futures	19299.2	19302.4	19297.0	19300.3	291.0
2016-11-04 01:00:00	YM	Futures	19300.3	19305.7	19295.9	19299.2	476.0
2016-11-04 02:00:00	YM	Futures	19298.1	19312.1	19292.7	19305.7	918.0
2016-11-04 03:00:00	YM	Futures	19305.7	19308.9	19285.1	19295.9	2469.0
2016-11-04 04:00:00	YM	Futures	19295.9	19298.1	19265.7	19286.2	4718.0
2016-11-04 05:00:00	YM	Futures	19285.1	19292.7	19257.0	19270.0	5489.0
2016-11-04 06:00:00	YM	Futures	19270.0	19281.9	19261.4	19273.2	3091.0
2016-11-04 07:00:00	YM	Futures	19273.2	19280.8	19266.8	19276.5	2632.0
2016-11-04 08:00:00	YM	Futures	19276.5	19315.4	19265.7	19300.3	11303.0
2016-11-04 09:00:00	YM	Futures	19300.3	19302.4	19237.6	19254.9	37135.0
2016-11-04 10:00:00	YM	Futures	19255.9	19318.6	19254.9	19299.2	29575.0
2016-11-04 11:00:00	YM	Futures	19299.2	19329.4	19293.8	19311.1	21459.0
2016-11-04 12:00:00	YM	Futures	19311.1	19341.3	19310.0	19332.7	14574.0
2016-11-04 13:00:00	YM	Futures	19332.7	19346.7	19328.4	19338.1	10855.0
2016-11-04 14:00:00	YM	Futures	19337.0	19341.3	19289.5	19295.9	15371.0
2016-11-04 15:00:00	YM	Futures	19295.9	19297.0	19237.6	19246.2	24835.0

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

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