PREVIEW / futures_1hour / 2017-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-13.parquet
  size:    52 KB
  rows:    1,639

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-02-13 00:00:00	ES	Futures	2527.48	2527.48	2525.57	2526.11	2886.0
2017-02-13 01:00:00	ES	Futures	2526.11	2526.11	2524.2	2524.48	4400.0
2017-02-13 02:00:00	ES	Futures	2524.48	2526.66	2524.2	2525.84	5915.0
2017-02-13 03:00:00	ES	Futures	2525.84	2527.2	2525.02	2525.57	13920.0
2017-02-13 04:00:00	ES	Futures	2525.57	2526.93	2525.57	2525.84	8315.0
2017-02-13 05:00:00	ES	Futures	2525.57	2526.66	2525.02	2525.57	6905.0
2017-02-13 06:00:00	ES	Futures	2525.29	2526.93	2525.02	2526.93	6441.0
2017-02-13 07:00:00	ES	Futures	2526.93	2528.84	2526.66	2528.3	20240.0
2017-02-13 08:00:00	ES	Futures	2528.02	2529.93	2527.75	2529.39	29147.0
2017-02-13 09:00:00	ES	Futures	2529.11	2534.02	2528.3	2532.39	169468.0
2017-02-13 10:00:00	ES	Futures	2532.39	2534.84	2532.11	2534.57	163822.0
2017-02-13 11:00:00	ES	Futures	2534.3	2536.21	2532.39	2533.48	151055.0
2017-02-13 12:00:00	ES	Futures	2533.48	2537.3	2533.21	2537.02	104668.0
2017-02-13 13:00:00	ES	Futures	2537.3	2541.12	2536.21	2539.21	137794.0
2017-02-13 14:00:00	ES	Futures	2539.48	2540.3	2537.3	2537.57	92091.0
2017-02-13 15:00:00	ES	Futures	2537.57	2538.66	2536.21	2537.3	165740.0
2017-02-13 16:00:00	ES	Futures	2537.3	2538.93	2536.75	2538.66	73024.0
2017-02-13 18:00:00	ES	Futures	2538.39	2539.48	2538.11	2538.93	4146.0
2017-02-13 19:00:00	ES	Futures	2538.66	2538.93	2537.57	2538.11	3078.0
2017-02-13 20:00:00	ES	Futures	2537.84	2538.39	2536.75	2537.57	3934.0
2017-02-13 21:00:00	ES	Futures	2537.57	2538.93	2537.3	2537.84	2750.0
2017-02-13 22:00:00	ES	Futures	2538.11	2538.39	2536.75	2536.75	3004.0
2017-02-13 23:00:00	ES	Futures	2537.02	2537.02	2536.21	2536.48	3009.0
2017-02-13 00:00:00	NQ	Futures	6246.52	6247.12	6243.54	6244.43	837.0
2017-02-13 01:00:00	NQ	Futures	6244.13	6244.43	6240.25	6240.55	777.0
2017-02-13 02:00:00	NQ	Futures	6240.25	6245.92	6240.25	6243.24	1135.0
2017-02-13 03:00:00	NQ	Futures	6243.54	6246.22	6240.25	6242.64	2190.0
2017-02-13 04:00:00	NQ	Futures	6242.64	6243.83	6240.25	6240.25	1441.0
2017-02-13 05:00:00	NQ	Futures	6240.25	6242.34	6238.17	6239.36	1130.0
2017-02-13 06:00:00	NQ	Futures	6239.06	6242.34	6239.06	6242.34	1094.0
2017-02-13 07:00:00	NQ	Futures	6242.34	6247.41	6242.34	6246.22	2250.0
2017-02-13 08:00:00	NQ	Futures	6245.92	6249.5	6245.33	6248.61	3494.0
2017-02-13 09:00:00	NQ	Futures	6248.91	6260.84	6247.41	6258.15	24268.0
2017-02-13 10:00:00	NQ	Futures	6258.75	6265.61	6256.96	6263.22	18605.0
2017-02-13 11:00:00	NQ	Futures	6263.22	6267.7	6257.86	6263.52	18020.0
2017-02-13 12:00:00	NQ	Futures	6263.22	6271.88	6262.93	6270.38	11589.0
2017-02-13 13:00:00	NQ	Futures	6270.38	6275.46	6267.7	6274.26	12770.0
2017-02-13 14:00:00	NQ	Futures	6273.96	6278.44	6271.58	6272.77	11573.0
2017-02-13 15:00:00	NQ	Futures	6272.77	6276.65	6267.7	6270.09	16011.0
2017-02-13 16:00:00	NQ	Futures	6270.09	6277.84	6268.89	6277.54	4801.0
2017-02-13 18:00:00	NQ	Futures	6275.75	6277.84	6274.56	6275.16	599.0
2017-02-13 19:00:00	NQ	Futures	6274.86	6276.35	6273.07	6274.86	775.0
2017-02-13 20:00:00	NQ	Futures	6274.56	6275.16	6270.98	6271.88	1115.0
2017-02-13 21:00:00	NQ	Futures	6272.17	6275.75	6271.58	6274.26	634.0
2017-02-13 22:00:00	NQ	Futures	6274.26	6275.16	6270.68	6270.98	699.0
2017-02-13 23:00:00	NQ	Futures	6271.28	6272.77	6270.38	6271.88	724.0
2017-02-13 00:00:00	YM	Futures	21982.8	21983.9	21968.7	21969.8	814.0
2017-02-13 01:00:00	YM	Futures	21970.8	21973.0	21958.9	21961.1	1023.0
2017-02-13 02:00:00	YM	Futures	21960.0	21981.7	21955.7	21973.0	1802.0
2017-02-13 03:00:00	YM	Futures	21975.2	21985.0	21966.5	21974.1	2665.0

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

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