PREVIEW / futures_1hour / 2016-12-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	2460.95	2461.23	2459.05	2459.32	1654.0
2016-12-12 01:00:00	ES	Futures	2459.05	2460.41	2459.05	2459.05	2136.0
2016-12-12 02:00:00	ES	Futures	2459.05	2459.32	2455.79	2457.15	5079.0
2016-12-12 03:00:00	ES	Futures	2457.42	2461.23	2457.15	2458.23	8694.0
2016-12-12 04:00:00	ES	Futures	2458.23	2458.51	2454.7	2456.6	8008.0
2016-12-12 05:00:00	ES	Futures	2456.6	2458.51	2455.24	2457.42	5850.0
2016-12-12 06:00:00	ES	Futures	2457.42	2459.59	2456.87	2459.59	4503.0
2016-12-12 07:00:00	ES	Futures	2459.59	2460.68	2458.23	2458.23	3394.0
2016-12-12 08:00:00	ES	Futures	2458.51	2460.41	2458.23	2459.59	6911.0
2016-12-12 09:00:00	ES	Futures	2459.59	2462.86	2456.33	2462.86	42105.0
2016-12-12 10:00:00	ES	Futures	2462.86	2464.22	2455.79	2457.42	41167.0
2016-12-12 11:00:00	ES	Futures	2457.69	2459.32	2454.42	2455.51	38057.0
2016-12-12 12:00:00	ES	Futures	2455.51	2455.51	2451.16	2453.61	37616.0
2016-12-12 13:00:00	ES	Futures	2453.61	2456.06	2452.52	2453.34	24992.0
2016-12-12 14:00:00	ES	Futures	2453.06	2456.6	2452.25	2453.34	28023.0
2016-12-12 15:00:00	ES	Futures	2453.34	2457.15	2453.06	2456.33	45641.0
2016-12-12 16:00:00	ES	Futures	2456.33	2457.96	2454.42	2455.24	17588.0
2016-12-12 18:00:00	ES	Futures	2455.24	2455.24	2452.25	2453.34	3842.0
2016-12-12 19:00:00	ES	Futures	2453.61	2456.6	2453.34	2455.79	1698.0
2016-12-12 20:00:00	ES	Futures	2455.79	2457.69	2454.7	2456.87	2008.0
2016-12-12 21:00:00	ES	Futures	2456.6	2457.15	2456.06	2456.33	1381.0
2016-12-12 22:00:00	ES	Futures	2456.33	2456.87	2455.79	2456.6	543.0
2016-12-12 23:00:00	ES	Futures	2456.87	2456.87	2454.15	2454.42	973.0
2016-12-12 00:00:00	NQ	Futures	5823.8	5823.8	5818.43	5819.32	238.0
2016-12-12 01:00:00	NQ	Futures	5819.92	5823.8	5819.92	5820.51	126.0
2016-12-12 02:00:00	NQ	Futures	5820.81	5820.81	5812.16	5815.44	711.0
2016-12-12 03:00:00	NQ	Futures	5815.44	5822.9	5808.88	5814.25	984.0
2016-12-12 04:00:00	NQ	Futures	5814.25	5814.25	5802.91	5806.79	912.0
2016-12-12 05:00:00	NQ	Futures	5806.49	5816.34	5805.3	5812.16	849.0
2016-12-12 06:00:00	NQ	Futures	5812.76	5816.64	5811.86	5816.34	342.0
2016-12-12 07:00:00	NQ	Futures	5816.64	5822.3	5815.14	5817.23	586.0
2016-12-12 08:00:00	NQ	Futures	5816.93	5820.81	5816.93	5820.22	717.0
2016-12-12 09:00:00	NQ	Futures	5820.51	5822.6	5804.11	5822.01	9226.0
2016-12-12 10:00:00	NQ	Futures	5822.01	5827.08	5799.33	5810.07	9588.0
2016-12-12 11:00:00	NQ	Futures	5809.77	5814.55	5800.53	5801.12	5295.0
2016-12-12 12:00:00	NQ	Futures	5800.82	5801.72	5790.68	5799.93	5003.0
2016-12-12 13:00:00	NQ	Futures	5800.23	5807.98	5796.05	5799.03	4112.0
2016-12-12 14:00:00	NQ	Futures	5798.74	5807.98	5797.84	5805.9	4106.0
2016-12-12 15:00:00	NQ	Futures	5805.3	5816.93	5804.11	5815.14	5758.0
2016-12-12 16:00:00	NQ	Futures	5815.14	5816.93	5807.09	5807.98	1609.0
2016-12-12 18:00:00	NQ	Futures	5807.98	5807.98	5801.42	5806.19	211.0
2016-12-12 19:00:00	NQ	Futures	5804.7	5812.76	5804.4	5812.46	100.0
2016-12-12 20:00:00	NQ	Futures	5811.56	5816.04	5809.77	5813.95	158.0
2016-12-12 21:00:00	NQ	Futures	5813.95	5816.34	5813.35	5815.44	260.0
2016-12-12 22:00:00	NQ	Futures	5815.44	5815.74	5811.56	5814.25	130.0
2016-12-12 23:00:00	NQ	Futures	5813.65	5813.65	5809.48	5811.56	65.0
2016-12-12 00:00:00	YM	Futures	21412.2	21415.4	21390.5	21391.6	1311.0
2016-12-12 01:00:00	YM	Futures	21391.6	21400.3	21388.3	21390.5	1004.0
2016-12-12 02:00:00	YM	Futures	21391.6	21398.1	21371.0	21388.3	2870.0
2016-12-12 03:00:00	YM	Futures	21387.2	21413.3	21381.8	21385.1	3824.0

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

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