PREVIEW / futures_1hour / 2017-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-13.parquet
  size:    45 KB
  rows:    1,329

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-10-13 00:00:00	ES	Futures	2790.3	2790.84	2790.02	2790.57	3149.0
2017-10-13 01:00:00	ES	Futures	2790.57	2790.84	2789.75	2790.02	3432.0
2017-10-13 02:00:00	ES	Futures	2790.02	2790.57	2788.93	2789.48	4542.0
2017-10-13 03:00:00	ES	Futures	2789.75	2790.3	2788.38	2789.2	16373.0
2017-10-13 04:00:00	ES	Futures	2789.2	2789.48	2788.11	2789.2	9702.0
2017-10-13 05:00:00	ES	Futures	2788.93	2791.12	2788.93	2790.84	8175.0
2017-10-13 06:00:00	ES	Futures	2790.57	2791.67	2790.3	2791.67	6738.0
2017-10-13 07:00:00	ES	Futures	2791.67	2793.85	2791.12	2793.03	22366.0
2017-10-13 08:00:00	ES	Futures	2793.31	2796.32	2792.76	2794.67	41340.0
2017-10-13 09:00:00	ES	Futures	2794.95	2794.95	2790.57	2792.21	155869.0
2017-10-13 10:00:00	ES	Futures	2792.49	2796.32	2792.21	2794.95	109298.0
2017-10-13 11:00:00	ES	Futures	2794.95	2796.04	2792.49	2794.4	71418.0
2017-10-13 12:00:00	ES	Futures	2794.67	2795.5	2793.58	2795.22	52855.0
2017-10-13 13:00:00	ES	Futures	2795.22	2796.32	2794.13	2794.13	34841.0
2017-10-13 14:00:00	ES	Futures	2794.13	2795.22	2792.76	2794.13	58072.0
2017-10-13 15:00:00	ES	Futures	2793.85	2795.22	2790.57	2792.49	190480.0
2017-10-13 16:00:00	ES	Futures	2792.21	2794.13	2791.94	2793.03	92115.0
2017-10-13 00:00:00	NQ	Futures	7232.28	7234.65	7231.09	7234.36	928.0
2017-10-13 01:00:00	NQ	Futures	7234.36	7234.65	7229.6	7229.9	780.0
2017-10-13 02:00:00	NQ	Futures	7229.9	7231.38	7226.33	7229.3	1171.0
2017-10-13 03:00:00	NQ	Futures	7229.3	7230.79	7224.84	7228.41	1875.0
2017-10-13 04:00:00	NQ	Futures	7228.41	7228.71	7224.25	7226.62	1085.0
2017-10-13 05:00:00	NQ	Futures	7226.33	7232.28	7226.33	7231.09	791.0
2017-10-13 06:00:00	NQ	Futures	7231.09	7232.87	7229.3	7232.57	1342.0
2017-10-13 07:00:00	NQ	Futures	7232.87	7238.52	7229.9	7237.63	2739.0
2017-10-13 08:00:00	NQ	Futures	7237.63	7255.18	7236.74	7250.72	12482.0
2017-10-13 09:00:00	NQ	Futures	7250.72	7255.18	7245.06	7248.04	33648.0
2017-10-13 10:00:00	NQ	Futures	7248.04	7260.83	7247.44	7250.72	31871.0
2017-10-13 11:00:00	NQ	Futures	7251.01	7256.96	7247.74	7255.77	15931.0
2017-10-13 12:00:00	NQ	Futures	7255.77	7259.34	7252.5	7257.26	16508.0
2017-10-13 13:00:00	NQ	Futures	7257.26	7261.72	7253.69	7255.18	9636.0
2017-10-13 14:00:00	NQ	Futures	7255.18	7258.15	7252.2	7256.66	11823.0
2017-10-13 15:00:00	NQ	Futures	7256.96	7258.75	7248.04	7252.2	24058.0
2017-10-13 16:00:00	NQ	Futures	7252.2	7258.15	7250.42	7256.37	6359.0
2017-10-13 00:00:00	YM	Futures	24809.0	24813.3	24807.9	24812.3	971.0
2017-10-13 01:00:00	YM	Futures	24813.3	24813.3	24804.6	24805.7	562.0
2017-10-13 02:00:00	YM	Futures	24806.8	24811.2	24799.2	24803.6	851.0
2017-10-13 03:00:00	YM	Futures	24804.6	24809.0	24794.9	24803.6	1357.0
2017-10-13 04:00:00	YM	Futures	24803.6	24803.6	24794.9	24800.3	895.0
2017-10-13 05:00:00	YM	Futures	24800.3	24815.5	24799.2	24811.2	1114.0
2017-10-13 06:00:00	YM	Futures	24811.2	24817.7	24806.8	24817.7	738.0
2017-10-13 07:00:00	YM	Futures	24817.7	24840.5	24816.6	24834.0	2132.0
2017-10-13 08:00:00	YM	Futures	24834.0	24848.1	24822.0	24828.6	4861.0
2017-10-13 09:00:00	YM	Futures	24828.6	24834.0	24811.2	24822.0	14133.0
2017-10-13 10:00:00	YM	Futures	24823.1	24855.8	24801.4	24824.2	13788.0
2017-10-13 11:00:00	YM	Futures	24825.3	24835.1	24806.8	24830.7	6046.0
2017-10-13 12:00:00	YM	Futures	24830.7	24835.1	24821.0	24829.7	3240.0
2017-10-13 13:00:00	YM	Futures	24829.7	24843.8	24828.6	24830.7	3369.0
2017-10-13 14:00:00	YM	Futures	24831.8	24840.5	24822.0	24828.6	3986.0
2017-10-13 15:00:00	YM	Futures	24829.7	24840.5	24814.4	24829.7	8104.0

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

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