PREVIEW / futures_1hour / 2017-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-05.parquet
  size:    51 KB
  rows:    1,543

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-07-05 00:00:00	ES	Futures	2651.39	2651.94	2651.39	2651.94	1460.0
2017-07-05 01:00:00	ES	Futures	2651.94	2653.58	2651.94	2653.3	4286.0
2017-07-05 02:00:00	ES	Futures	2653.3	2653.58	2651.39	2653.03	8445.0
2017-07-05 03:00:00	ES	Futures	2652.76	2655.49	2650.84	2654.12	27315.0
2017-07-05 04:00:00	ES	Futures	2654.12	2654.4	2648.66	2651.39	23814.0
2017-07-05 05:00:00	ES	Futures	2651.12	2652.48	2650.57	2650.84	15473.0
2017-07-05 06:00:00	ES	Futures	2651.12	2653.58	2650.57	2653.58	8473.0
2017-07-05 07:00:00	ES	Futures	2653.58	2654.67	2651.66	2654.12	15063.0
2017-07-05 08:00:00	ES	Futures	2654.4	2656.58	2653.58	2655.22	24725.0
2017-07-05 09:00:00	ES	Futures	2655.22	2656.58	2648.66	2650.57	161712.0
2017-07-05 10:00:00	ES	Futures	2650.57	2653.85	2645.1	2653.3	225785.0
2017-07-05 11:00:00	ES	Futures	2653.58	2656.31	2652.76	2653.03	117763.0
2017-07-05 12:00:00	ES	Futures	2653.03	2656.31	2652.48	2655.76	66760.0
2017-07-05 13:00:00	ES	Futures	2656.04	2658.22	2655.22	2655.49	63102.0
2017-07-05 14:00:00	ES	Futures	2655.22	2659.32	2653.03	2655.22	116512.0
2017-07-05 15:00:00	ES	Futures	2655.22	2658.77	2653.03	2656.31	163656.0
2017-07-05 16:00:00	ES	Futures	2656.31	2656.86	2653.85	2655.22	66226.0
2017-07-05 18:00:00	ES	Futures	2654.67	2657.4	2654.12	2656.86	4038.0
2017-07-05 19:00:00	ES	Futures	2656.86	2657.13	2656.31	2656.58	715.0
2017-07-05 20:00:00	ES	Futures	2656.31	2656.86	2654.12	2654.4	5543.0
2017-07-05 21:00:00	ES	Futures	2654.4	2654.94	2652.48	2653.03	8083.0
2017-07-05 22:00:00	ES	Futures	2653.03	2654.67	2652.48	2654.12	5269.0
2017-07-05 23:00:00	ES	Futures	2654.4	2654.67	2653.3	2653.58	3145.0
2017-07-05 00:00:00	NQ	Futures	6647.0	6650.27	6646.11	6647.59	537.0
2017-07-05 01:00:00	NQ	Futures	6647.89	6657.42	6647.89	6655.34	1248.0
2017-07-05 02:00:00	NQ	Futures	6655.63	6655.63	6644.62	6649.38	1731.0
2017-07-05 03:00:00	NQ	Futures	6649.38	6659.21	6638.96	6651.17	4751.0
2017-07-05 04:00:00	NQ	Futures	6650.87	6652.06	6632.71	6640.15	3954.0
2017-07-05 05:00:00	NQ	Futures	6640.45	6643.43	6635.09	6640.75	2495.0
2017-07-05 06:00:00	NQ	Futures	6640.15	6642.83	6637.17	6641.34	1535.0
2017-07-05 07:00:00	NQ	Futures	6641.34	6670.52	6637.47	6669.33	5294.0
2017-07-05 08:00:00	NQ	Futures	6669.63	6685.41	6669.33	6682.13	10860.0
2017-07-05 09:00:00	NQ	Futures	6681.54	6707.74	6674.69	6684.81	66767.0
2017-07-05 10:00:00	NQ	Futures	6685.41	6713.7	6663.97	6708.63	68601.0
2017-07-05 11:00:00	NQ	Futures	6708.63	6724.12	6704.76	6713.99	31975.0
2017-07-05 12:00:00	NQ	Futures	6713.99	6727.99	6712.21	6725.9	19165.0
2017-07-05 13:00:00	NQ	Futures	6726.2	6741.98	6725.9	6727.99	22490.0
2017-07-05 14:00:00	NQ	Futures	6727.99	6750.32	6719.65	6730.07	39354.0
2017-07-05 15:00:00	NQ	Futures	6730.37	6738.71	6720.25	6731.56	37135.0
2017-07-05 16:00:00	NQ	Futures	6731.56	6737.81	6729.48	6730.37	6366.0
2017-07-05 18:00:00	NQ	Futures	6729.77	6732.45	6724.41	6730.07	812.0
2017-07-05 19:00:00	NQ	Futures	6730.07	6730.96	6727.39	6729.18	362.0
2017-07-05 20:00:00	NQ	Futures	6728.88	6729.77	6717.86	6718.16	1568.0
2017-07-05 21:00:00	NQ	Futures	6718.16	6719.95	6711.61	6713.4	2228.0
2017-07-05 22:00:00	NQ	Futures	6713.1	6719.95	6711.91	6717.86	1081.0
2017-07-05 23:00:00	NQ	Futures	6717.57	6720.84	6713.4	6714.59	856.0
2017-07-05 00:00:00	YM	Futures	23332.7	23340.3	23329.4	23336.0	1595.0
2017-07-05 01:00:00	YM	Futures	23336.0	23347.9	23336.0	23345.8	903.0
2017-07-05 02:00:00	YM	Futures	23345.8	23345.8	23321.8	23332.7	1526.0
2017-07-05 03:00:00	YM	Futures	23331.6	23357.7	23318.5	23343.6	3902.0

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

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