PREVIEW / futures_1hour / 2016-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-05.parquet
  size:    45 KB
  rows:    1,316

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
2016-08-05 00:00:00	ES	Futures	2346.3	2346.3	2344.95	2345.22	1877.0
2016-08-05 01:00:00	ES	Futures	2345.49	2345.49	2344.68	2345.49	3614.0
2016-08-05 02:00:00	ES	Futures	2345.22	2346.03	2344.14	2345.49	5290.0
2016-08-05 03:00:00	ES	Futures	2345.49	2348.75	2344.95	2346.85	26370.0
2016-08-05 04:00:00	ES	Futures	2347.12	2347.66	2344.68	2345.76	13556.0
2016-08-05 05:00:00	ES	Futures	2345.76	2348.47	2345.49	2347.66	12277.0
2016-08-05 06:00:00	ES	Futures	2347.39	2348.47	2346.58	2348.2	10228.0
2016-08-05 07:00:00	ES	Futures	2348.2	2348.47	2345.76	2345.76	16147.0
2016-08-05 08:00:00	ES	Futures	2346.03	2352.0	2343.59	2351.19	94192.0
2016-08-05 09:00:00	ES	Futures	2350.92	2359.05	2349.56	2359.05	269524.0
2016-08-05 10:00:00	ES	Futures	2358.78	2360.14	2356.88	2359.86	224309.0
2016-08-05 11:00:00	ES	Futures	2359.59	2362.03	2359.32	2360.41	118440.0
2016-08-05 12:00:00	ES	Futures	2360.41	2362.58	2360.41	2361.22	83451.0
2016-08-05 13:00:00	ES	Futures	2361.22	2362.03	2360.14	2361.76	59978.0
2016-08-05 14:00:00	ES	Futures	2361.76	2362.03	2359.32	2360.14	71079.0
2016-08-05 15:00:00	ES	Futures	2360.14	2363.12	2360.14	2362.3	255440.0
2016-08-05 16:00:00	ES	Futures	2362.3	2362.58	2360.95	2362.03	77815.0
2016-08-05 00:00:00	NQ	Futures	5665.66	5665.96	5662.68	5664.77	366.0
2016-08-05 01:00:00	NQ	Futures	5664.77	5665.66	5663.28	5664.47	386.0
2016-08-05 02:00:00	NQ	Futures	5664.47	5665.66	5661.49	5664.47	760.0
2016-08-05 03:00:00	NQ	Futures	5664.47	5674.31	5663.28	5670.13	2658.0
2016-08-05 04:00:00	NQ	Futures	5670.43	5671.33	5662.98	5665.96	1401.0
2016-08-05 05:00:00	NQ	Futures	5665.36	5671.33	5665.07	5668.64	987.0
2016-08-05 06:00:00	NQ	Futures	5668.64	5669.54	5666.85	5669.24	1230.0
2016-08-05 07:00:00	NQ	Futures	5668.94	5669.24	5664.77	5665.07	1465.0
2016-08-05 08:00:00	NQ	Futures	5664.77	5682.05	5660.0	5679.97	15613.0
2016-08-05 09:00:00	NQ	Futures	5679.67	5707.99	5674.6	5707.99	42300.0
2016-08-05 10:00:00	NQ	Futures	5707.99	5718.72	5707.69	5716.93	31603.0
2016-08-05 11:00:00	NQ	Futures	5716.93	5719.91	5711.86	5713.65	17410.0
2016-08-05 12:00:00	NQ	Futures	5713.65	5719.01	5712.46	5714.84	11451.0
2016-08-05 13:00:00	NQ	Futures	5714.84	5717.52	5710.67	5716.63	9029.0
2016-08-05 14:00:00	NQ	Futures	5716.93	5717.52	5705.6	5707.99	9635.0
2016-08-05 15:00:00	NQ	Futures	5707.99	5712.16	5703.51	5706.5	21612.0
2016-08-05 16:00:00	NQ	Futures	5706.5	5707.39	5701.43	5703.22	6901.0
2016-08-05 00:00:00	YM	Futures	19698.9	19698.9	19691.3	19693.5	225.0
2016-08-05 01:00:00	YM	Futures	19693.5	19696.7	19689.2	19693.5	440.0
2016-08-05 02:00:00	YM	Futures	19692.4	19694.6	19683.8	19691.3	716.0
2016-08-05 03:00:00	YM	Futures	19691.3	19724.7	19688.1	19711.8	2877.0
2016-08-05 04:00:00	YM	Futures	19711.8	19713.9	19684.9	19694.6	1813.0
2016-08-05 05:00:00	YM	Futures	19694.6	19711.8	19693.5	19705.3	1173.0
2016-08-05 06:00:00	YM	Futures	19704.2	19710.7	19697.8	19708.5	1042.0
2016-08-05 07:00:00	YM	Futures	19708.5	19709.6	19684.9	19684.9	1847.0
2016-08-05 08:00:00	YM	Futures	19684.9	19790.3	19684.9	19786.0	15397.0
2016-08-05 09:00:00	YM	Futures	19786.0	19836.6	19773.1	19834.5	24580.0
2016-08-05 10:00:00	YM	Futures	19835.5	19845.2	19818.3	19836.6	16874.0
2016-08-05 11:00:00	YM	Futures	19835.5	19850.6	19833.4	19838.8	11309.0
2016-08-05 12:00:00	YM	Futures	19839.8	19856.0	19837.7	19844.1	6602.0
2016-08-05 13:00:00	YM	Futures	19844.1	19852.8	19839.8	19851.7	4591.0
2016-08-05 14:00:00	YM	Futures	19852.8	19859.2	19840.9	19847.4	6214.0
2016-08-05 15:00:00	YM	Futures	19848.4	19871.0	19848.4	19870.0	15433.0

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

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