PREVIEW / futures_1hour / 2017-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-27.parquet
  size:    53 KB
  rows:    1,612

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-03-27 00:00:00	ES	Futures	2543.23	2543.78	2541.6	2543.51	2441.0
2017-03-27 01:00:00	ES	Futures	2543.51	2544.6	2541.6	2542.41	7861.0
2017-03-27 02:00:00	ES	Futures	2542.41	2542.69	2532.31	2535.86	30880.0
2017-03-27 03:00:00	ES	Futures	2535.86	2539.41	2535.31	2536.41	27877.0
2017-03-27 04:00:00	ES	Futures	2536.41	2541.05	2534.77	2539.68	21603.0
2017-03-27 05:00:00	ES	Futures	2539.96	2542.96	2539.41	2539.96	11701.0
2017-03-27 06:00:00	ES	Futures	2539.68	2541.87	2538.86	2541.87	8757.0
2017-03-27 07:00:00	ES	Futures	2541.6	2542.96	2540.23	2540.23	17764.0
2017-03-27 08:00:00	ES	Futures	2540.5	2541.32	2537.77	2538.86	35904.0
2017-03-27 09:00:00	ES	Futures	2538.59	2543.78	2532.58	2542.14	277397.0
2017-03-27 10:00:00	ES	Futures	2542.14	2547.06	2538.59	2546.51	248039.0
2017-03-27 11:00:00	ES	Futures	2546.51	2552.25	2543.51	2550.34	188152.0
2017-03-27 12:00:00	ES	Futures	2550.61	2555.25	2549.24	2553.89	112523.0
2017-03-27 13:00:00	ES	Futures	2553.61	2557.16	2550.34	2551.43	119334.0
2017-03-27 14:00:00	ES	Futures	2551.16	2554.98	2548.42	2554.43	113926.0
2017-03-27 15:00:00	ES	Futures	2554.43	2558.26	2553.34	2554.16	208725.0
2017-03-27 16:00:00	ES	Futures	2554.16	2556.89	2553.34	2556.62	76945.0
2017-03-27 18:00:00	ES	Futures	2557.16	2557.44	2555.8	2556.62	5879.0
2017-03-27 19:00:00	ES	Futures	2556.62	2559.35	2556.62	2557.71	6712.0
2017-03-27 20:00:00	ES	Futures	2557.71	2558.53	2556.62	2557.16	4955.0
2017-03-27 21:00:00	ES	Futures	2557.44	2557.71	2556.35	2557.16	3852.0
2017-03-27 22:00:00	ES	Futures	2556.89	2559.35	2556.89	2559.35	6178.0
2017-03-27 23:00:00	ES	Futures	2559.08	2560.17	2558.8	2559.62	4404.0
2017-03-27 00:00:00	NQ	Futures	6366.49	6369.17	6363.5	6368.57	472.0
2017-03-27 01:00:00	NQ	Futures	6368.27	6370.96	6364.7	6366.78	1533.0
2017-03-27 02:00:00	NQ	Futures	6366.78	6367.08	6342.04	6348.9	5360.0
2017-03-27 03:00:00	NQ	Futures	6348.9	6359.03	6348.0	6350.98	4888.0
2017-03-27 04:00:00	NQ	Futures	6350.98	6363.21	6347.11	6360.22	4049.0
2017-03-27 05:00:00	NQ	Futures	6360.22	6368.27	6359.63	6362.31	2682.0
2017-03-27 06:00:00	NQ	Futures	6362.01	6370.06	6360.22	6369.77	2238.0
2017-03-27 07:00:00	NQ	Futures	6369.47	6370.96	6364.7	6364.7	3772.0
2017-03-27 08:00:00	NQ	Futures	6365.29	6369.47	6361.12	6367.98	5874.0
2017-03-27 09:00:00	NQ	Futures	6367.98	6369.77	6341.14	6366.78	53702.0
2017-03-27 10:00:00	NQ	Futures	6366.49	6390.04	6361.42	6386.76	44083.0
2017-03-27 11:00:00	NQ	Futures	6386.76	6403.46	6379.01	6399.58	31655.0
2017-03-27 12:00:00	NQ	Futures	6399.88	6416.87	6396.0	6413.29	22532.0
2017-03-27 13:00:00	NQ	Futures	6413.29	6422.24	6406.44	6408.52	21865.0
2017-03-27 14:00:00	NQ	Futures	6408.52	6419.26	6403.16	6417.47	18503.0
2017-03-27 15:00:00	NQ	Futures	6417.77	6422.83	6409.12	6410.91	31114.0
2017-03-27 16:00:00	NQ	Futures	6410.91	6419.55	6410.01	6419.26	6295.0
2017-03-27 18:00:00	NQ	Futures	6418.96	6423.13	6418.36	6421.64	1639.0
2017-03-27 19:00:00	NQ	Futures	6421.64	6427.6	6421.34	6425.22	1737.0
2017-03-27 20:00:00	NQ	Futures	6424.92	6426.71	6422.24	6424.32	1083.0
2017-03-27 21:00:00	NQ	Futures	6424.32	6425.52	6421.05	6423.43	874.0
2017-03-27 22:00:00	NQ	Futures	6423.43	6429.1	6423.13	6427.31	936.0
2017-03-27 23:00:00	NQ	Futures	6427.31	6429.99	6426.71	6428.2	915.0
2017-03-27 00:00:00	YM	Futures	22237.9	22243.4	22224.9	22242.3	872.0
2017-03-27 01:00:00	YM	Futures	22241.2	22248.8	22228.1	22234.7	1520.0
2017-03-27 02:00:00	YM	Futures	22233.6	22235.7	22155.3	22173.8	5770.0
2017-03-27 03:00:00	YM	Futures	22173.8	22204.2	22168.4	22180.3	5043.0

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

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