PREVIEW / futures_1hour / 2017-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-25.parquet
  size:    55 KB
  rows:    1,659

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-01-25 00:00:00	ES	Futures	2483.56	2484.38	2483.02	2483.83	2175.0
2017-01-25 01:00:00	ES	Futures	2484.11	2485.74	2483.83	2484.65	3429.0
2017-01-25 02:00:00	ES	Futures	2484.93	2486.56	2484.65	2486.02	7687.0
2017-01-25 03:00:00	ES	Futures	2486.02	2490.11	2485.2	2489.83	30012.0
2017-01-25 04:00:00	ES	Futures	2489.83	2490.11	2487.38	2487.38	16014.0
2017-01-25 05:00:00	ES	Futures	2487.38	2489.56	2487.11	2489.02	9207.0
2017-01-25 06:00:00	ES	Futures	2489.02	2489.56	2487.93	2488.2	5981.0
2017-01-25 07:00:00	ES	Futures	2488.47	2491.74	2487.93	2491.47	19822.0
2017-01-25 08:00:00	ES	Futures	2491.47	2493.11	2490.38	2492.02	28296.0
2017-01-25 09:00:00	ES	Futures	2491.74	2496.93	2491.74	2496.93	212781.0
2017-01-25 10:00:00	ES	Futures	2496.93	2499.93	2495.56	2499.11	193852.0
2017-01-25 11:00:00	ES	Futures	2499.11	2501.56	2495.84	2498.02	173396.0
2017-01-25 12:00:00	ES	Futures	2498.02	2499.65	2497.2	2499.38	91219.0
2017-01-25 13:00:00	ES	Futures	2499.65	2502.11	2499.11	2502.11	82832.0
2017-01-25 14:00:00	ES	Futures	2502.11	2503.2	2499.93	2499.93	91631.0
2017-01-25 15:00:00	ES	Futures	2499.93	2504.29	2498.84	2503.47	289894.0
2017-01-25 16:00:00	ES	Futures	2503.47	2504.02	2501.84	2502.66	92639.0
2017-01-25 18:00:00	ES	Futures	2502.66	2502.93	2501.84	2501.84	3849.0
2017-01-25 19:00:00	ES	Futures	2501.84	2502.93	2500.47	2502.11	6759.0
2017-01-25 20:00:00	ES	Futures	2502.11	2503.2	2501.56	2502.38	4063.0
2017-01-25 21:00:00	ES	Futures	2502.38	2507.02	2502.11	2505.93	11865.0
2017-01-25 22:00:00	ES	Futures	2505.93	2507.29	2505.93	2507.02	3837.0
2017-01-25 23:00:00	ES	Futures	2507.02	2508.11	2506.47	2507.02	4853.0
2017-01-25 00:00:00	NQ	Futures	6089.9	6091.39	6089.01	6090.2	775.0
2017-01-25 01:00:00	NQ	Futures	6090.5	6095.87	6090.5	6094.67	1395.0
2017-01-25 02:00:00	NQ	Futures	6094.38	6099.45	6094.08	6096.76	2022.0
2017-01-25 03:00:00	NQ	Futures	6097.36	6106.61	6095.57	6105.12	4577.0
2017-01-25 04:00:00	NQ	Futures	6105.12	6106.61	6101.24	6101.83	2268.0
2017-01-25 05:00:00	NQ	Futures	6101.83	6106.61	6101.24	6106.01	1384.0
2017-01-25 06:00:00	NQ	Futures	6106.01	6107.2	6104.52	6104.82	1225.0
2017-01-25 07:00:00	NQ	Futures	6104.82	6113.77	6104.52	6112.87	3591.0
2017-01-25 08:00:00	NQ	Futures	6112.57	6115.26	6109.29	6112.57	3872.0
2017-01-25 09:00:00	NQ	Futures	6112.87	6122.42	6112.57	6121.82	28070.0
2017-01-25 10:00:00	NQ	Futures	6122.12	6129.88	6118.24	6128.98	20697.0
2017-01-25 11:00:00	NQ	Futures	6129.28	6134.65	6120.33	6125.1	15929.0
2017-01-25 12:00:00	NQ	Futures	6125.1	6130.47	6123.61	6129.88	10190.0
2017-01-25 13:00:00	NQ	Futures	6130.17	6140.91	6129.88	6139.12	10161.0
2017-01-25 14:00:00	NQ	Futures	6139.12	6140.91	6133.16	6134.05	10356.0
2017-01-25 15:00:00	NQ	Futures	6134.05	6143.6	6130.47	6141.81	23440.0
2017-01-25 16:00:00	NQ	Futures	6142.11	6145.39	6137.33	6145.09	7138.0
2017-01-25 18:00:00	NQ	Futures	6143.3	6144.2	6140.91	6141.81	866.0
2017-01-25 19:00:00	NQ	Futures	6141.81	6144.49	6138.53	6143.0	1015.0
2017-01-25 20:00:00	NQ	Futures	6143.0	6146.58	6143.0	6145.09	1288.0
2017-01-25 21:00:00	NQ	Futures	6145.09	6160.6	6145.09	6157.62	3480.0
2017-01-25 22:00:00	NQ	Futures	6157.62	6161.8	6157.62	6160.01	877.0
2017-01-25 23:00:00	NQ	Futures	6159.41	6164.18	6159.41	6161.2	1191.0
2017-01-25 00:00:00	YM	Futures	21543.5	21552.1	21536.9	21548.9	1174.0
2017-01-25 01:00:00	YM	Futures	21548.9	21558.6	21546.7	21555.4	888.0
2017-01-25 02:00:00	YM	Futures	21555.4	21574.9	21552.1	21568.4	1749.0
2017-01-25 03:00:00	YM	Futures	21568.4	21602.0	21559.7	21598.8	4197.0

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

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