PREVIEW / futures_1hour / 2017-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-06.parquet
  size:    55 KB
  rows:    1,656

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-06 00:00:00	ES	Futures	2499.93	2500.2	2499.65	2499.65	2555.0
2017-02-06 01:00:00	ES	Futures	2499.93	2500.2	2499.38	2500.2	1495.0
2017-02-06 02:00:00	ES	Futures	2500.2	2501.84	2499.93	2500.75	6110.0
2017-02-06 03:00:00	ES	Futures	2501.02	2501.02	2497.75	2499.38	17591.0
2017-02-06 04:00:00	ES	Futures	2499.38	2502.66	2499.11	2501.84	16690.0
2017-02-06 05:00:00	ES	Futures	2501.84	2503.2	2501.56	2502.11	7437.0
2017-02-06 06:00:00	ES	Futures	2502.11	2502.66	2498.84	2499.38	15525.0
2017-02-06 07:00:00	ES	Futures	2499.65	2499.65	2496.11	2496.11	15674.0
2017-02-06 08:00:00	ES	Futures	2496.38	2496.65	2492.02	2495.02	57244.0
2017-02-06 09:00:00	ES	Futures	2495.02	2499.38	2494.47	2498.29	161264.0
2017-02-06 10:00:00	ES	Futures	2498.29	2500.2	2495.56	2495.56	158415.0
2017-02-06 11:00:00	ES	Futures	2495.56	2499.65	2495.29	2496.65	121837.0
2017-02-06 12:00:00	ES	Futures	2496.65	2497.2	2493.65	2493.93	88647.0
2017-02-06 13:00:00	ES	Futures	2493.65	2495.02	2491.47	2494.2	147698.0
2017-02-06 14:00:00	ES	Futures	2494.47	2495.02	2492.84	2493.93	96217.0
2017-02-06 15:00:00	ES	Futures	2493.93	2496.38	2493.93	2496.38	147542.0
2017-02-06 16:00:00	ES	Futures	2496.11	2496.65	2493.93	2494.74	66583.0
2017-02-06 18:00:00	ES	Futures	2494.47	2495.84	2493.93	2495.29	3200.0
2017-02-06 19:00:00	ES	Futures	2495.29	2495.29	2492.29	2493.38	5445.0
2017-02-06 20:00:00	ES	Futures	2493.65	2494.74	2492.84	2494.2	3989.0
2017-02-06 21:00:00	ES	Futures	2494.47	2494.47	2493.11	2493.93	2275.0
2017-02-06 22:00:00	ES	Futures	2493.93	2494.2	2492.02	2494.2	4722.0
2017-02-06 23:00:00	ES	Futures	2494.2	2494.74	2493.93	2494.47	2356.0
2017-02-06 00:00:00	NQ	Futures	6148.97	6149.56	6147.48	6147.77	462.0
2017-02-06 01:00:00	NQ	Futures	6147.48	6149.56	6146.88	6149.56	234.0
2017-02-06 02:00:00	NQ	Futures	6149.27	6152.85	6149.27	6150.76	1114.0
2017-02-06 03:00:00	NQ	Futures	6151.06	6151.06	6143.3	6147.77	2390.0
2017-02-06 04:00:00	NQ	Futures	6147.48	6154.93	6147.48	6154.04	2046.0
2017-02-06 05:00:00	NQ	Futures	6153.74	6156.72	6153.44	6155.53	1066.0
2017-02-06 06:00:00	NQ	Futures	6155.53	6156.72	6147.48	6149.56	2412.0
2017-02-06 07:00:00	NQ	Futures	6149.86	6150.46	6142.41	6142.41	1823.0
2017-02-06 08:00:00	NQ	Futures	6142.41	6142.7	6133.75	6140.32	6250.0
2017-02-06 09:00:00	NQ	Futures	6140.32	6149.27	6136.74	6146.28	28269.0
2017-02-06 10:00:00	NQ	Futures	6146.58	6152.85	6141.81	6146.28	19393.0
2017-02-06 11:00:00	NQ	Futures	6146.28	6161.5	6145.69	6155.83	17722.0
2017-02-06 12:00:00	NQ	Futures	6155.23	6156.72	6149.56	6151.35	10442.0
2017-02-06 13:00:00	NQ	Futures	6151.06	6152.85	6143.9	6151.35	15572.0
2017-02-06 14:00:00	NQ	Futures	6151.06	6153.44	6148.67	6151.95	8294.0
2017-02-06 15:00:00	NQ	Futures	6151.65	6160.3	6151.65	6160.01	13944.0
2017-02-06 16:00:00	NQ	Futures	6160.3	6160.6	6152.55	6157.32	5439.0
2017-02-06 18:00:00	NQ	Futures	6153.74	6156.43	6152.85	6156.13	1082.0
2017-02-06 19:00:00	NQ	Futures	6156.13	6157.02	6150.46	6152.25	1545.0
2017-02-06 20:00:00	NQ	Futures	6152.55	6154.93	6151.35	6154.93	1040.0
2017-02-06 21:00:00	NQ	Futures	6154.93	6156.13	6152.55	6154.34	451.0
2017-02-06 22:00:00	NQ	Futures	6154.34	6155.23	6150.76	6155.23	1007.0
2017-02-06 23:00:00	NQ	Futures	6155.23	6156.72	6154.04	6156.13	410.0
2017-02-06 00:00:00	YM	Futures	21685.6	21686.6	21681.2	21683.4	466.0
2017-02-06 01:00:00	YM	Futures	21683.4	21691.0	21679.0	21688.8	428.0
2017-02-06 02:00:00	YM	Futures	21688.8	21699.7	21687.7	21695.3	1206.0
2017-02-06 03:00:00	YM	Futures	21695.3	21695.3	21670.4	21684.5	3291.0

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

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