PREVIEW / futures_1hour / 2016-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-09.parquet
  size:    45 KB
  rows:    1,315

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-09 00:00:00	ES	Futures	2446.26	2446.81	2445.99	2446.81	1121.0
2016-12-09 01:00:00	ES	Futures	2446.53	2446.81	2444.9	2444.9	2049.0
2016-12-09 02:00:00	ES	Futures	2445.17	2445.45	2443.54	2443.81	4441.0
2016-12-09 03:00:00	ES	Futures	2444.09	2445.99	2443.27	2443.81	9762.0
2016-12-09 04:00:00	ES	Futures	2444.09	2445.72	2443.27	2443.81	6266.0
2016-12-09 05:00:00	ES	Futures	2444.09	2445.99	2443.81	2445.72	4093.0
2016-12-09 06:00:00	ES	Futures	2445.72	2447.35	2445.17	2447.08	4738.0
2016-12-09 07:00:00	ES	Futures	2447.35	2447.62	2446.26	2447.62	8160.0
2016-12-09 08:00:00	ES	Futures	2447.62	2449.26	2445.45	2448.71	17626.0
2016-12-09 09:00:00	ES	Futures	2448.71	2451.7	2446.26	2450.62	69503.0
2016-12-09 10:00:00	ES	Futures	2450.62	2453.61	2447.35	2451.16	62832.0
2016-12-09 11:00:00	ES	Futures	2451.16	2452.52	2448.98	2450.62	53531.0
2016-12-09 12:00:00	ES	Futures	2450.62	2453.06	2449.8	2451.7	31466.0
2016-12-09 13:00:00	ES	Futures	2451.98	2453.34	2450.34	2452.79	26715.0
2016-12-09 14:00:00	ES	Futures	2452.52	2454.42	2451.98	2454.42	33793.0
2016-12-09 15:00:00	ES	Futures	2454.42	2459.32	2453.88	2459.05	88637.0
2016-12-09 16:00:00	ES	Futures	2459.05	2460.95	2458.51	2460.41	44349.0
2016-12-09 17:00:00	ES	Futures	2460.68	2460.68	2460.68	2460.68	5.0
2016-12-09 00:00:00	NQ	Futures	5803.51	5804.4	5802.02	5804.4	106.0
2016-12-09 01:00:00	NQ	Futures	5803.81	5803.81	5799.33	5799.93	148.0
2016-12-09 02:00:00	NQ	Futures	5799.93	5801.42	5793.66	5795.16	601.0
2016-12-09 03:00:00	NQ	Futures	5795.16	5799.03	5790.68	5795.16	1076.0
2016-12-09 04:00:00	NQ	Futures	5794.56	5801.42	5793.07	5797.84	663.0
2016-12-09 05:00:00	NQ	Futures	5797.84	5808.88	5797.54	5807.39	1012.0
2016-12-09 06:00:00	NQ	Futures	5807.39	5811.56	5806.79	5810.97	1213.0
2016-12-09 07:00:00	NQ	Futures	5811.27	5813.65	5809.18	5813.65	1295.0
2016-12-09 08:00:00	NQ	Futures	5813.65	5821.11	5811.27	5820.81	2498.0
2016-12-09 09:00:00	NQ	Futures	5820.81	5839.01	5817.83	5837.22	19504.0
2016-12-09 10:00:00	NQ	Futures	5837.52	5844.38	5822.01	5829.76	14744.0
2016-12-09 11:00:00	NQ	Futures	5829.76	5840.5	5829.17	5836.33	9276.0
2016-12-09 12:00:00	NQ	Futures	5836.33	5838.41	5827.67	5829.17	7683.0
2016-12-09 13:00:00	NQ	Futures	5829.46	5834.24	5821.71	5831.85	6558.0
2016-12-09 14:00:00	NQ	Futures	5831.85	5833.94	5823.5	5832.15	5635.0
2016-12-09 15:00:00	NQ	Futures	5831.85	5841.4	5829.46	5841.4	9447.0
2016-12-09 16:00:00	NQ	Futures	5841.1	5842.29	5836.92	5841.4	2844.0
2016-12-09 00:00:00	YM	Futures	21217.5	21228.3	21216.5	21224.0	299.0
2016-12-09 01:00:00	YM	Futures	21225.1	21226.2	21211.0	21214.3	332.0
2016-12-09 02:00:00	YM	Futures	21214.3	21218.6	21203.5	21207.8	590.0
2016-12-09 03:00:00	YM	Futures	21206.7	21224.0	21204.6	21210.0	763.0
2016-12-09 04:00:00	YM	Futures	21211.0	21221.9	21205.6	21210.0	1002.0
2016-12-09 05:00:00	YM	Futures	21211.0	21224.0	21210.0	21220.8	518.0
2016-12-09 06:00:00	YM	Futures	21222.9	21235.9	21219.7	21234.8	495.0
2016-12-09 07:00:00	YM	Futures	21235.9	21238.1	21221.9	21232.7	826.0
2016-12-09 08:00:00	YM	Futures	21235.9	21237.0	21214.3	21233.7	1837.0
2016-12-09 09:00:00	YM	Futures	21232.7	21240.2	21206.7	21231.6	7364.0
2016-12-09 10:00:00	YM	Futures	21230.5	21259.7	21212.1	21252.1	5043.0
2016-12-09 11:00:00	YM	Futures	21253.2	21272.7	21239.1	21255.4	4170.0
2016-12-09 12:00:00	YM	Futures	21256.4	21284.5	21247.8	21272.7	2873.0
2016-12-09 13:00:00	YM	Futures	21273.7	21285.6	21264.0	21280.2	1634.0
2016-12-09 14:00:00	YM	Futures	21279.1	21299.7	21279.1	21299.7	2121.0

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

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