PREVIEW / futures_1hour / 2016-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-24.parquet
  size:    38 KB
  rows:    1,125

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-24 00:00:00	ES	Futures	2394.02	2394.57	2393.48	2393.75	1376.0
2016-11-24 01:00:00	ES	Futures	2393.75	2394.57	2393.21	2394.57	1188.0
2016-11-24 02:00:00	ES	Futures	2394.84	2396.2	2394.3	2395.11	4622.0
2016-11-24 03:00:00	ES	Futures	2395.38	2396.74	2393.21	2394.57	14321.0
2016-11-24 04:00:00	ES	Futures	2394.57	2396.2	2394.3	2395.93	6002.0
2016-11-24 05:00:00	ES	Futures	2395.66	2396.2	2395.11	2395.66	5340.0
2016-11-24 06:00:00	ES	Futures	2395.93	2396.74	2394.84	2395.38	9365.0
2016-11-24 07:00:00	ES	Futures	2395.38	2397.02	2395.38	2395.93	3454.0
2016-11-24 08:00:00	ES	Futures	2395.93	2396.74	2395.38	2396.74	5711.0
2016-11-24 09:00:00	ES	Futures	2396.74	2399.74	2396.74	2399.46	13049.0
2016-11-24 10:00:00	ES	Futures	2399.46	2400.28	2399.19	2400.28	7784.0
2016-11-24 11:00:00	ES	Futures	2400.28	2401.91	2399.46	2401.64	9656.0
2016-11-24 12:00:00	ES	Futures	2401.64	2401.91	2400.28	2400.83	4659.0
2016-11-24 18:00:00	ES	Futures	2401.1	2401.64	2399.74	2400.01	1666.0
2016-11-24 19:00:00	ES	Futures	2400.28	2400.55	2399.46	2400.28	2133.0
2016-11-24 20:00:00	ES	Futures	2400.28	2402.19	2399.74	2401.64	4595.0
2016-11-24 21:00:00	ES	Futures	2401.64	2401.91	2399.74	2399.74	2852.0
2016-11-24 22:00:00	ES	Futures	2399.74	2400.01	2398.1	2398.1	2763.0
2016-11-24 23:00:00	ES	Futures	2398.38	2399.19	2397.56	2398.1	2180.0
2016-11-24 00:00:00	NQ	Futures	5785.01	5786.21	5782.33	5785.01	291.0
2016-11-24 01:00:00	NQ	Futures	5784.42	5785.91	5783.52	5785.61	129.0
2016-11-24 02:00:00	NQ	Futures	5785.91	5789.79	5785.61	5786.21	612.0
2016-11-24 03:00:00	NQ	Futures	5786.8	5791.58	5779.34	5782.92	1833.0
2016-11-24 04:00:00	NQ	Futures	5782.92	5789.79	5781.73	5788.59	737.0
2016-11-24 05:00:00	NQ	Futures	5789.19	5790.38	5785.61	5787.7	392.0
2016-11-24 06:00:00	NQ	Futures	5787.1	5788.59	5783.22	5784.42	668.0
2016-11-24 07:00:00	NQ	Futures	5784.42	5788.59	5783.82	5784.42	619.0
2016-11-24 08:00:00	NQ	Futures	5784.42	5786.8	5783.22	5786.5	521.0
2016-11-24 09:00:00	NQ	Futures	5786.8	5790.68	5786.5	5788.89	1663.0
2016-11-24 10:00:00	NQ	Futures	5789.19	5793.66	5787.7	5793.37	1480.0
2016-11-24 11:00:00	NQ	Futures	5793.66	5801.42	5791.58	5801.42	1831.0
2016-11-24 12:00:00	NQ	Futures	5801.42	5803.81	5799.63	5803.21	839.0
2016-11-24 18:00:00	NQ	Futures	5799.33	5803.21	5796.65	5797.54	288.0
2016-11-24 19:00:00	NQ	Futures	5798.14	5801.72	5796.05	5801.42	456.0
2016-11-24 20:00:00	NQ	Futures	5801.12	5807.69	5800.53	5805.6	884.0
2016-11-24 21:00:00	NQ	Futures	5805.9	5806.79	5802.02	5802.61	429.0
2016-11-24 22:00:00	NQ	Futures	5802.32	5803.51	5797.54	5797.54	331.0
2016-11-24 23:00:00	NQ	Futures	5797.84	5800.23	5794.86	5795.16	377.0
2016-11-24 00:00:00	YM	Futures	20589.6	20591.8	20585.3	20585.3	316.0
2016-11-24 01:00:00	YM	Futures	20586.4	20591.8	20585.3	20590.7	337.0
2016-11-24 02:00:00	YM	Futures	20591.8	20603.7	20588.5	20596.1	1108.0
2016-11-24 03:00:00	YM	Futures	20597.2	20612.3	20583.1	20598.3	3278.0
2016-11-24 04:00:00	YM	Futures	20597.2	20608.0	20595.0	20605.8	1241.0
2016-11-24 05:00:00	YM	Futures	20608.0	20610.1	20600.4	20606.9	829.0
2016-11-24 06:00:00	YM	Futures	20605.8	20613.4	20599.3	20603.7	1546.0
2016-11-24 07:00:00	YM	Futures	20603.7	20614.5	20601.5	20604.7	998.0
2016-11-24 08:00:00	YM	Futures	20603.7	20611.2	20601.5	20611.2	866.0
2016-11-24 09:00:00	YM	Futures	20611.2	20645.8	20611.2	20637.2	3790.0
2016-11-24 10:00:00	YM	Futures	20637.2	20653.4	20637.2	20644.7	2731.0
2016-11-24 11:00:00	YM	Futures	20644.7	20663.1	20638.2	20659.9	1666.0

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

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