PREVIEW / futures_1hour / 2017-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-05.parquet
  size:    54 KB
  rows:    1,657

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-05 00:00:00	ES	Futures	2571.37	2572.46	2570.55	2572.19	3480.0
2017-04-05 01:00:00	ES	Futures	2572.19	2573.01	2570.82	2573.01	4871.0
2017-04-05 02:00:00	ES	Futures	2572.73	2573.55	2570.82	2571.91	7657.0
2017-04-05 03:00:00	ES	Futures	2571.91	2573.28	2570.28	2571.09	14150.0
2017-04-05 04:00:00	ES	Futures	2571.37	2572.73	2570.28	2571.91	10891.0
2017-04-05 05:00:00	ES	Futures	2572.19	2575.47	2571.91	2573.28	10089.0
2017-04-05 06:00:00	ES	Futures	2573.28	2574.37	2572.73	2573.28	5280.0
2017-04-05 07:00:00	ES	Futures	2573.55	2575.74	2571.09	2574.92	16180.0
2017-04-05 08:00:00	ES	Futures	2574.92	2581.47	2574.1	2580.38	48665.0
2017-04-05 09:00:00	ES	Futures	2580.65	2589.67	2579.56	2589.12	193258.0
2017-04-05 10:00:00	ES	Futures	2588.85	2594.86	2587.21	2591.85	276980.0
2017-04-05 11:00:00	ES	Futures	2591.58	2592.67	2583.93	2588.03	216455.0
2017-04-05 12:00:00	ES	Futures	2588.03	2592.67	2587.21	2591.31	113513.0
2017-04-05 13:00:00	ES	Futures	2591.58	2594.59	2591.31	2593.22	89966.0
2017-04-05 14:00:00	ES	Futures	2593.22	2593.22	2579.56	2580.65	253593.0
2017-04-05 15:00:00	ES	Futures	2580.65	2583.11	2563.45	2565.63	503749.0
2017-04-05 16:00:00	ES	Futures	2565.91	2567.27	2560.72	2562.63	127010.0
2017-04-05 18:00:00	ES	Futures	2562.63	2564.81	2560.72	2563.99	8227.0
2017-04-05 19:00:00	ES	Futures	2564.27	2565.09	2560.99	2561.26	7257.0
2017-04-05 20:00:00	ES	Futures	2561.26	2561.53	2557.16	2559.62	18520.0
2017-04-05 21:00:00	ES	Futures	2559.35	2560.17	2557.44	2559.35	7540.0
2017-04-05 22:00:00	ES	Futures	2559.35	2559.62	2554.43	2556.89	15083.0
2017-04-05 23:00:00	ES	Futures	2556.89	2559.62	2556.07	2559.08	7271.0
2017-04-05 00:00:00	NQ	Futures	6484.25	6488.13	6482.46	6487.83	736.0
2017-04-05 01:00:00	NQ	Futures	6487.83	6489.92	6483.65	6489.62	752.0
2017-04-05 02:00:00	NQ	Futures	6489.62	6489.62	6483.36	6485.44	1391.0
2017-04-05 03:00:00	NQ	Futures	6485.15	6489.92	6482.16	6483.95	2690.0
2017-04-05 04:00:00	NQ	Futures	6483.95	6487.53	6482.46	6485.44	1651.0
2017-04-05 05:00:00	NQ	Futures	6485.44	6493.2	6484.85	6487.83	1854.0
2017-04-05 06:00:00	NQ	Futures	6487.83	6490.81	6486.93	6488.13	938.0
2017-04-05 07:00:00	NQ	Futures	6488.13	6493.2	6482.46	6490.51	2670.0
2017-04-05 08:00:00	NQ	Futures	6490.21	6497.07	6487.83	6492.9	7464.0
2017-04-05 09:00:00	NQ	Futures	6493.2	6514.66	6491.7	6511.38	29918.0
2017-04-05 10:00:00	NQ	Futures	6510.49	6528.67	6505.72	6526.89	38220.0
2017-04-05 11:00:00	NQ	Futures	6526.89	6532.25	6513.17	6522.71	32152.0
2017-04-05 12:00:00	NQ	Futures	6522.71	6534.93	6521.22	6531.95	16276.0
2017-04-05 13:00:00	NQ	Futures	6531.95	6536.72	6530.76	6533.44	12245.0
2017-04-05 14:00:00	NQ	Futures	6533.44	6533.74	6501.25	6502.44	43009.0
2017-04-05 15:00:00	NQ	Futures	6502.44	6509.59	6450.56	6463.08	88380.0
2017-04-05 16:00:00	NQ	Futures	6462.49	6464.87	6452.65	6455.93	9558.0
2017-04-05 18:00:00	NQ	Futures	6456.52	6461.29	6452.65	6460.1	1759.0
2017-04-05 19:00:00	NQ	Futures	6460.1	6462.79	6451.75	6453.54	1821.0
2017-04-05 20:00:00	NQ	Futures	6453.24	6454.14	6441.62	6447.28	4773.0
2017-04-05 21:00:00	NQ	Futures	6447.28	6448.47	6441.62	6446.39	2479.0
2017-04-05 22:00:00	NQ	Futures	6446.09	6446.39	6427.9	6436.85	4244.0
2017-04-05 23:00:00	NQ	Futures	6436.85	6443.41	6434.76	6442.81	2355.0
2017-04-05 00:00:00	YM	Futures	22404.2	22416.2	22397.7	22415.1	893.0
2017-04-05 01:00:00	YM	Futures	22414.0	22421.6	22404.2	22420.5	1453.0
2017-04-05 02:00:00	YM	Futures	22420.5	22424.8	22406.4	22412.9	1461.0
2017-04-05 03:00:00	YM	Futures	22412.9	22427.0	22404.2	22408.5	2182.0

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

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