PREVIEW / futures_1hour / 2017-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-14.parquet
  size:    54 KB
  rows:    1,658

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-11-14 00:00:00	ES	Futures	2822.3	2823.12	2820.12	2820.66	6780.0
2017-11-14 01:00:00	ES	Futures	2820.66	2822.3	2820.39	2821.76	5365.0
2017-11-14 02:00:00	ES	Futures	2821.76	2823.67	2821.48	2822.85	11541.0
2017-11-14 03:00:00	ES	Futures	2822.85	2825.59	2821.21	2824.22	23487.0
2017-11-14 04:00:00	ES	Futures	2824.22	2824.22	2821.48	2823.12	18995.0
2017-11-14 05:00:00	ES	Futures	2822.85	2823.12	2820.94	2822.03	14376.0
2017-11-14 06:00:00	ES	Futures	2821.76	2823.95	2821.21	2822.85	18150.0
2017-11-14 07:00:00	ES	Futures	2822.58	2822.85	2817.93	2820.12	32281.0
2017-11-14 08:00:00	ES	Futures	2820.12	2821.21	2817.11	2817.11	27308.0
2017-11-14 09:00:00	ES	Futures	2817.11	2818.75	2813.28	2814.1	268996.0
2017-11-14 10:00:00	ES	Futures	2814.1	2821.21	2805.89	2819.29	435484.0
2017-11-14 11:00:00	ES	Futures	2819.57	2820.39	2816.83	2819.84	124284.0
2017-11-14 12:00:00	ES	Futures	2819.57	2820.94	2813.0	2815.19	112069.0
2017-11-14 13:00:00	ES	Futures	2814.92	2818.75	2812.46	2817.38	109285.0
2017-11-14 14:00:00	ES	Futures	2817.11	2819.57	2816.56	2818.75	78834.0
2017-11-14 15:00:00	ES	Futures	2818.75	2820.66	2816.56	2819.84	175096.0
2017-11-14 16:00:00	ES	Futures	2819.84	2821.21	2819.57	2820.39	73560.0
2017-11-14 18:00:00	ES	Futures	2819.57	2819.84	2816.56	2817.65	6886.0
2017-11-14 19:00:00	ES	Futures	2817.65	2817.93	2810.81	2814.1	20627.0
2017-11-14 20:00:00	ES	Futures	2814.1	2814.92	2809.99	2813.55	12401.0
2017-11-14 21:00:00	ES	Futures	2813.28	2813.55	2811.09	2813.28	6081.0
2017-11-14 22:00:00	ES	Futures	2813.28	2813.82	2810.81	2812.46	7880.0
2017-11-14 23:00:00	ES	Futures	2812.46	2814.92	2812.46	2813.0	7862.0
2017-11-14 00:00:00	NQ	Futures	7506.49	7509.47	7501.44	7503.52	1248.0
2017-11-14 01:00:00	NQ	Futures	7503.22	7507.39	7502.92	7504.11	755.0
2017-11-14 02:00:00	NQ	Futures	7504.41	7510.06	7504.11	7508.87	1975.0
2017-11-14 03:00:00	NQ	Futures	7508.87	7516.61	7503.22	7512.74	2926.0
2017-11-14 04:00:00	NQ	Futures	7512.74	7512.74	7503.52	7509.17	2315.0
2017-11-14 05:00:00	NQ	Futures	7509.17	7511.55	7506.2	7508.87	2212.0
2017-11-14 06:00:00	NQ	Futures	7508.87	7515.71	7508.87	7511.85	2494.0
2017-11-14 07:00:00	NQ	Futures	7511.55	7512.14	7495.19	7503.22	4594.0
2017-11-14 08:00:00	NQ	Futures	7503.52	7508.58	7493.11	7493.7	7719.0
2017-11-14 09:00:00	NQ	Futures	7493.7	7497.27	7468.72	7473.18	58953.0
2017-11-14 10:00:00	NQ	Futures	7472.89	7495.79	7450.58	7486.86	97982.0
2017-11-14 11:00:00	NQ	Futures	7487.46	7494.89	7483.0	7493.11	34533.0
2017-11-14 12:00:00	NQ	Futures	7493.11	7496.68	7459.8	7466.34	29751.0
2017-11-14 13:00:00	NQ	Futures	7465.75	7480.02	7452.96	7477.64	32236.0
2017-11-14 14:00:00	NQ	Futures	7477.35	7484.48	7474.08	7482.7	17892.0
2017-11-14 15:00:00	NQ	Futures	7482.4	7490.73	7478.24	7488.05	28833.0
2017-11-14 16:00:00	NQ	Futures	7488.35	7490.43	7484.48	7487.76	6039.0
2017-11-14 18:00:00	NQ	Futures	7487.16	7488.65	7479.73	7482.7	1360.0
2017-11-14 19:00:00	NQ	Futures	7482.4	7483.0	7463.67	7475.56	3764.0
2017-11-14 20:00:00	NQ	Futures	7475.56	7478.83	7462.48	7472.29	3706.0
2017-11-14 21:00:00	NQ	Futures	7471.99	7472.59	7462.48	7469.32	2014.0
2017-11-14 22:00:00	NQ	Futures	7469.61	7469.91	7459.5	7464.26	2007.0
2017-11-14 23:00:00	NQ	Futures	7464.56	7470.51	7463.67	7464.56	1594.0
2017-11-14 00:00:00	YM	Futures	25440.9	25452.9	25426.8	25433.3	1283.0
2017-11-14 01:00:00	YM	Futures	25433.3	25442.0	25430.1	25438.8	783.0
2017-11-14 02:00:00	YM	Futures	25438.8	25458.3	25438.8	25452.9	2700.0
2017-11-14 03:00:00	YM	Futures	25454.0	25477.9	25440.9	25462.7	3128.0

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

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