PREVIEW / futures_1hour / 2017-04-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	2585.3	2585.84	2584.75	2585.3	4436.0
2017-04-24 01:00:00	ES	Futures	2585.3	2588.03	2585.03	2588.03	11059.0
2017-04-24 02:00:00	ES	Futures	2587.76	2592.4	2587.76	2590.76	31000.0
2017-04-24 03:00:00	ES	Futures	2590.76	2591.58	2588.03	2591.31	33413.0
2017-04-24 04:00:00	ES	Futures	2591.03	2593.22	2590.21	2593.22	19932.0
2017-04-24 05:00:00	ES	Futures	2592.95	2594.59	2591.58	2592.95	20336.0
2017-04-24 06:00:00	ES	Futures	2592.95	2596.77	2592.95	2594.86	22121.0
2017-04-24 07:00:00	ES	Futures	2594.86	2594.86	2591.85	2594.04	22524.0
2017-04-24 08:00:00	ES	Futures	2594.04	2595.13	2591.85	2592.4	35960.0
2017-04-24 09:00:00	ES	Futures	2592.4	2592.95	2586.39	2588.85	215313.0
2017-04-24 10:00:00	ES	Futures	2589.12	2591.58	2586.94	2588.58	201057.0
2017-04-24 11:00:00	ES	Futures	2588.58	2589.94	2584.75	2585.3	173566.0
2017-04-24 12:00:00	ES	Futures	2585.57	2588.85	2585.3	2587.76	79388.0
2017-04-24 13:00:00	ES	Futures	2587.76	2590.49	2587.48	2589.94	89259.0
2017-04-24 14:00:00	ES	Futures	2589.94	2592.67	2588.58	2591.03	135719.0
2017-04-24 15:00:00	ES	Futures	2591.03	2593.77	2589.4	2590.21	217380.0
2017-04-24 16:00:00	ES	Futures	2590.21	2591.03	2587.48	2589.4	105175.0
2017-04-24 18:00:00	ES	Futures	2589.4	2589.67	2587.48	2589.12	4264.0
2017-04-24 19:00:00	ES	Futures	2588.85	2589.4	2587.48	2588.03	3501.0
2017-04-24 20:00:00	ES	Futures	2587.76	2589.12	2587.76	2589.12	4341.0
2017-04-24 21:00:00	ES	Futures	2589.12	2591.31	2588.03	2590.49	5518.0
2017-04-24 22:00:00	ES	Futures	2590.49	2592.67	2590.49	2591.85	7016.0
2017-04-24 23:00:00	ES	Futures	2591.85	2592.67	2591.03	2592.13	4532.0
2017-04-24 00:00:00	NQ	Futures	6544.77	6545.07	6541.49	6543.88	656.0
2017-04-24 01:00:00	NQ	Futures	6544.18	6551.63	6543.28	6550.74	1588.0
2017-04-24 02:00:00	NQ	Futures	6550.74	6556.7	6549.54	6553.12	5462.0
2017-04-24 03:00:00	NQ	Futures	6552.53	6555.8	6550.44	6555.21	5251.0
2017-04-24 04:00:00	NQ	Futures	6554.61	6560.87	6553.42	6559.68	2836.0
2017-04-24 05:00:00	NQ	Futures	6559.98	6561.17	6555.51	6557.0	2536.0
2017-04-24 06:00:00	NQ	Futures	6556.7	6562.66	6556.1	6558.79	2627.0
2017-04-24 07:00:00	NQ	Futures	6559.08	6559.98	6555.21	6558.19	3273.0
2017-04-24 08:00:00	NQ	Futures	6558.19	6567.13	6556.1	6562.66	6650.0
2017-04-24 09:00:00	NQ	Futures	6562.66	6565.94	6549.84	6564.15	37166.0
2017-04-24 10:00:00	NQ	Futures	6563.85	6570.12	6557.3	6562.66	30912.0
2017-04-24 11:00:00	NQ	Futures	6562.96	6564.15	6551.93	6554.02	22109.0
2017-04-24 12:00:00	NQ	Futures	6554.31	6562.07	6554.02	6558.79	12075.0
2017-04-24 13:00:00	NQ	Futures	6558.79	6563.85	6558.49	6563.85	11179.0
2017-04-24 14:00:00	NQ	Futures	6563.85	6568.03	6559.98	6567.43	15433.0
2017-04-24 15:00:00	NQ	Futures	6567.43	6574.29	6565.35	6567.13	26435.0
2017-04-24 16:00:00	NQ	Futures	6567.43	6568.33	6561.47	6563.26	6385.0
2017-04-24 18:00:00	NQ	Futures	6561.47	6562.96	6557.89	6562.07	1057.0
2017-04-24 19:00:00	NQ	Futures	6561.77	6562.36	6558.79	6559.68	635.0
2017-04-24 20:00:00	NQ	Futures	6559.38	6563.26	6559.08	6562.66	1007.0
2017-04-24 21:00:00	NQ	Futures	6562.66	6570.41	6560.58	6568.62	1668.0
2017-04-24 22:00:00	NQ	Futures	6568.62	6574.59	6568.62	6571.01	1688.0
2017-04-24 23:00:00	NQ	Futures	6571.01	6573.69	6571.01	6571.9	1037.0
2017-04-24 00:00:00	YM	Futures	22436.8	22439.0	22429.2	22433.5	704.0
2017-04-24 01:00:00	YM	Futures	22433.5	22459.6	22432.5	22456.4	1539.0
2017-04-24 02:00:00	YM	Futures	22456.4	22485.7	22456.4	22470.5	5580.0
2017-04-24 03:00:00	YM	Futures	22469.4	22485.7	22457.5	22471.6	6275.0

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

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