PREVIEW / futures_1hour / 2016-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-14.parquet
  size:    56 KB
  rows:    1,648

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-11-14 00:00:00	ES	Futures	2364.09	2366.0	2363.82	2364.37	7533.0
2016-11-14 01:00:00	ES	Futures	2364.64	2366.0	2363.01	2364.64	5006.0
2016-11-14 02:00:00	ES	Futures	2364.37	2364.91	2362.73	2363.01	9738.0
2016-11-14 03:00:00	ES	Futures	2362.73	2366.54	2360.56	2360.83	26344.0
2016-11-14 04:00:00	ES	Futures	2361.1	2364.37	2360.83	2361.37	15724.0
2016-11-14 05:00:00	ES	Futures	2361.65	2362.46	2358.11	2358.38	15261.0
2016-11-14 06:00:00	ES	Futures	2358.38	2358.92	2348.59	2351.85	42468.0
2016-11-14 07:00:00	ES	Futures	2352.12	2356.2	2351.03	2353.76	23221.0
2016-11-14 08:00:00	ES	Futures	2353.76	2360.83	2351.58	2358.92	44400.0
2016-11-14 09:00:00	ES	Futures	2358.92	2358.92	2350.76	2352.12	253250.0
2016-11-14 10:00:00	ES	Futures	2351.85	2359.47	2347.23	2348.04	336804.0
2016-11-14 11:00:00	ES	Futures	2347.77	2351.85	2344.5	2348.59	223645.0
2016-11-14 12:00:00	ES	Futures	2348.86	2349.67	2342.33	2346.95	145597.0
2016-11-14 13:00:00	ES	Futures	2346.95	2353.48	2345.05	2349.13	140533.0
2016-11-14 14:00:00	ES	Futures	2349.13	2354.3	2346.68	2354.3	131249.0
2016-11-14 15:00:00	ES	Futures	2354.3	2355.12	2348.31	2351.03	216337.0
2016-11-14 16:00:00	ES	Futures	2351.03	2352.67	2349.95	2351.85	68365.0
2016-11-14 18:00:00	ES	Futures	2351.85	2352.67	2349.13	2351.85	6200.0
2016-11-14 19:00:00	ES	Futures	2351.58	2353.76	2349.95	2353.21	6737.0
2016-11-14 20:00:00	ES	Futures	2352.94	2354.84	2351.31	2353.76	7914.0
2016-11-14 21:00:00	ES	Futures	2353.76	2354.84	2351.58	2354.84	5093.0
2016-11-14 22:00:00	ES	Futures	2354.57	2356.75	2353.48	2356.2	6923.0
2016-11-14 23:00:00	ES	Futures	2356.2	2357.02	2355.12	2356.48	2597.0
2016-11-14 00:00:00	NQ	Futures	5697.3	5704.46	5695.81	5696.41	1142.0
2016-11-14 01:00:00	NQ	Futures	5697.0	5699.39	5693.13	5694.62	1084.0
2016-11-14 02:00:00	NQ	Futures	5694.62	5696.71	5685.67	5685.97	2633.0
2016-11-14 03:00:00	NQ	Futures	5685.67	5698.5	5679.7	5682.68	4173.0
2016-11-14 04:00:00	NQ	Futures	5682.39	5693.13	5682.09	5686.56	1920.0
2016-11-14 05:00:00	NQ	Futures	5686.56	5686.86	5677.91	5679.1	1985.0
2016-11-14 06:00:00	NQ	Futures	5678.81	5679.1	5648.67	5660.01	5689.0
2016-11-14 07:00:00	NQ	Futures	5660.31	5667.77	5657.03	5660.91	2523.0
2016-11-14 08:00:00	NQ	Futures	5660.31	5672.54	5650.17	5667.47	8715.0
2016-11-14 09:00:00	NQ	Futures	5667.17	5669.26	5617.65	5621.52	54939.0
2016-11-14 10:00:00	NQ	Futures	5621.23	5641.51	5591.99	5594.67	60732.0
2016-11-14 11:00:00	NQ	Futures	5594.67	5616.75	5576.18	5604.52	39614.0
2016-11-14 12:00:00	NQ	Futures	5604.52	5609.29	5580.95	5603.03	20355.0
2016-11-14 13:00:00	NQ	Futures	5603.03	5630.77	5598.85	5608.1	21182.0
2016-11-14 14:00:00	NQ	Futures	5607.8	5628.68	5598.25	5627.79	17390.0
2016-11-14 15:00:00	NQ	Futures	5627.79	5630.47	5600.34	5605.41	21229.0
2016-11-14 16:00:00	NQ	Futures	5605.41	5606.01	5598.25	5600.64	6011.0
2016-11-14 18:00:00	NQ	Futures	5600.04	5602.43	5594.38	5602.43	1645.0
2016-11-14 19:00:00	NQ	Futures	5602.13	5605.71	5599.75	5604.22	1720.0
2016-11-14 20:00:00	NQ	Futures	5604.22	5609.29	5602.43	5607.2	2098.0
2016-11-14 21:00:00	NQ	Futures	5606.91	5607.2	5598.25	5605.41	1089.0
2016-11-14 22:00:00	NQ	Futures	5605.12	5611.38	5603.92	5608.1	1753.0
2016-11-14 23:00:00	NQ	Futures	5608.4	5610.49	5605.12	5608.99	696.0
2016-11-14 00:00:00	YM	Futures	20415.6	20445.9	20413.4	20428.6	3166.0
2016-11-14 01:00:00	YM	Futures	20429.7	20432.9	20412.4	20419.9	1589.0
2016-11-14 02:00:00	YM	Futures	20421.0	20434.0	20413.4	20417.8	2343.0
2016-11-14 03:00:00	YM	Futures	20417.8	20444.8	20408.0	20411.3	6150.0

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

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