PREVIEW / futures_1hour / 2017-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-19.parquet
  size:    52 KB
  rows:    1,610

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-04-19 00:00:00	ES	Futures	2556.07	2557.44	2555.8	2557.44	2268.0
2017-04-19 01:00:00	ES	Futures	2557.16	2558.8	2556.35	2556.62	4569.0
2017-04-19 02:00:00	ES	Futures	2556.62	2558.53	2556.35	2556.89	8025.0
2017-04-19 03:00:00	ES	Futures	2556.89	2558.8	2556.35	2557.44	16906.0
2017-04-19 04:00:00	ES	Futures	2557.16	2560.99	2556.89	2559.9	15811.0
2017-04-19 05:00:00	ES	Futures	2559.9	2562.08	2559.35	2561.53	8927.0
2017-04-19 06:00:00	ES	Futures	2561.53	2561.81	2559.35	2560.44	8698.0
2017-04-19 07:00:00	ES	Futures	2560.17	2562.08	2560.17	2561.81	13484.0
2017-04-19 08:00:00	ES	Futures	2561.81	2563.72	2560.72	2561.53	29628.0
2017-04-19 09:00:00	ES	Futures	2561.81	2566.72	2560.72	2565.63	182488.0
2017-04-19 10:00:00	ES	Futures	2565.91	2566.18	2559.62	2561.26	152118.0
2017-04-19 11:00:00	ES	Futures	2561.26	2564.27	2560.44	2560.72	91379.0
2017-04-19 12:00:00	ES	Futures	2560.72	2561.26	2556.62	2559.35	112367.0
2017-04-19 13:00:00	ES	Futures	2559.08	2559.35	2554.71	2556.89	112926.0
2017-04-19 14:00:00	ES	Futures	2557.16	2557.98	2549.24	2551.16	159885.0
2017-04-19 15:00:00	ES	Futures	2550.88	2553.34	2547.06	2550.61	223206.0
2017-04-19 16:00:00	ES	Futures	2550.34	2551.7	2548.15	2548.42	67346.0
2017-04-19 18:00:00	ES	Futures	2549.24	2552.52	2548.42	2552.25	8535.0
2017-04-19 19:00:00	ES	Futures	2552.25	2552.25	2550.61	2550.88	4350.0
2017-04-19 20:00:00	ES	Futures	2550.88	2551.7	2549.52	2550.88	5960.0
2017-04-19 21:00:00	ES	Futures	2551.16	2553.07	2550.06	2552.52	6462.0
2017-04-19 22:00:00	ES	Futures	2552.52	2552.79	2550.34	2550.61	3316.0
2017-04-19 23:00:00	ES	Futures	2550.61	2551.97	2550.61	2551.16	2662.0
2017-04-19 00:00:00	NQ	Futures	6434.46	6435.95	6432.97	6435.95	490.0
2017-04-19 01:00:00	NQ	Futures	6435.95	6439.23	6434.16	6435.95	1144.0
2017-04-19 02:00:00	NQ	Futures	6435.65	6439.53	6435.06	6436.25	1301.0
2017-04-19 03:00:00	NQ	Futures	6435.95	6440.72	6435.36	6437.14	2874.0
2017-04-19 04:00:00	NQ	Futures	6437.14	6444.3	6436.55	6441.32	2882.0
2017-04-19 05:00:00	NQ	Futures	6441.32	6449.07	6440.72	6448.47	2556.0
2017-04-19 06:00:00	NQ	Futures	6448.47	6450.26	6444.6	6445.79	1881.0
2017-04-19 07:00:00	NQ	Futures	6445.79	6450.56	6444.9	6449.97	2195.0
2017-04-19 08:00:00	NQ	Futures	6449.67	6457.42	6447.88	6454.74	5746.0
2017-04-19 09:00:00	NQ	Futures	6454.74	6474.11	6452.65	6471.73	35391.0
2017-04-19 10:00:00	NQ	Futures	6472.03	6473.22	6461.29	6466.36	25940.0
2017-04-19 11:00:00	NQ	Futures	6466.06	6476.5	6465.77	6468.75	16903.0
2017-04-19 12:00:00	NQ	Futures	6468.75	6470.83	6458.91	6461.89	16512.0
2017-04-19 13:00:00	NQ	Futures	6461.89	6463.08	6447.58	6453.84	22373.0
2017-04-19 14:00:00	NQ	Futures	6453.54	6456.52	6436.25	6439.83	27122.0
2017-04-19 15:00:00	NQ	Futures	6439.83	6446.39	6427.9	6437.14	37302.0
2017-04-19 16:00:00	NQ	Futures	6437.14	6440.13	6432.67	6433.27	5249.0
2017-04-19 18:00:00	NQ	Futures	6437.44	6443.11	6433.27	6441.62	1492.0
2017-04-19 19:00:00	NQ	Futures	6441.92	6442.21	6437.74	6439.23	609.0
2017-04-19 20:00:00	NQ	Futures	6438.93	6441.32	6435.06	6439.23	1295.0
2017-04-19 21:00:00	NQ	Futures	6439.53	6445.49	6437.44	6445.19	1369.0
2017-04-19 22:00:00	NQ	Futures	6445.19	6445.19	6439.23	6441.02	717.0
2017-04-19 23:00:00	NQ	Futures	6441.02	6444.0	6441.02	6442.51	521.0
2017-04-19 00:00:00	YM	Futures	22209.7	22214.0	22204.2	22214.0	545.0
2017-04-19 01:00:00	YM	Futures	22214.0	22226.0	22207.5	22211.8	1063.0
2017-04-19 02:00:00	YM	Futures	22211.8	22230.3	22210.8	22216.2	1896.0
2017-04-19 03:00:00	YM	Futures	22215.1	22228.1	22208.6	22214.0	2193.0

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

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