PREVIEW / futures_1hour / 2016-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-10-03.parquet
  size:    52 KB
  rows:    1,583

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-10-03 00:00:00	ES	Futures	2352.67	2352.94	2351.31	2351.58	1977.0
2016-10-03 01:00:00	ES	Futures	2351.85	2352.67	2351.31	2352.12	2426.0
2016-10-03 02:00:00	ES	Futures	2351.85	2352.67	2349.95	2350.76	4327.0
2016-10-03 03:00:00	ES	Futures	2350.49	2352.12	2348.31	2352.12	13651.0
2016-10-03 04:00:00	ES	Futures	2352.12	2353.76	2351.31	2351.85	8313.0
2016-10-03 05:00:00	ES	Futures	2351.85	2353.76	2351.31	2352.4	5652.0
2016-10-03 06:00:00	ES	Futures	2352.67	2353.48	2350.49	2350.76	7236.0
2016-10-03 07:00:00	ES	Futures	2350.76	2351.31	2349.13	2349.4	10417.0
2016-10-03 08:00:00	ES	Futures	2349.67	2349.67	2342.6	2343.42	43539.0
2016-10-03 09:00:00	ES	Futures	2343.42	2345.32	2338.79	2340.7	193200.0
2016-10-03 10:00:00	ES	Futures	2340.7	2347.23	2339.34	2344.23	281494.0
2016-10-03 11:00:00	ES	Futures	2344.5	2344.78	2337.16	2339.61	141961.0
2016-10-03 12:00:00	ES	Futures	2339.34	2341.78	2336.34	2341.24	144110.0
2016-10-03 13:00:00	ES	Futures	2340.97	2342.33	2337.7	2341.78	97340.0
2016-10-03 14:00:00	ES	Futures	2341.78	2343.96	2338.25	2341.24	129430.0
2016-10-03 15:00:00	ES	Futures	2340.97	2346.14	2339.61	2343.69	204114.0
2016-10-03 16:00:00	ES	Futures	2343.42	2345.59	2342.87	2344.5	77928.0
2016-10-03 18:00:00	ES	Futures	2343.96	2346.14	2343.96	2345.32	3891.0
2016-10-03 19:00:00	ES	Futures	2345.32	2345.87	2344.78	2345.32	1526.0
2016-10-03 20:00:00	ES	Futures	2345.05	2346.95	2344.5	2346.14	5519.0
2016-10-03 21:00:00	ES	Futures	2346.14	2346.95	2345.32	2345.59	4104.0
2016-10-03 22:00:00	ES	Futures	2345.59	2346.14	2344.78	2344.78	2083.0
2016-10-03 23:00:00	ES	Futures	2344.78	2345.59	2344.78	2345.05	2256.0
2016-10-03 00:00:00	NQ	Futures	5817.53	5817.53	5812.76	5813.95	336.0
2016-10-03 01:00:00	NQ	Futures	5813.95	5816.04	5813.06	5813.06	278.0
2016-10-03 02:00:00	NQ	Futures	5813.35	5815.44	5807.69	5810.37	845.0
2016-10-03 03:00:00	NQ	Futures	5810.07	5814.55	5804.7	5813.35	2062.0
2016-10-03 04:00:00	NQ	Futures	5813.65	5817.23	5812.16	5813.06	1038.0
2016-10-03 05:00:00	NQ	Futures	5812.76	5816.93	5811.56	5815.14	862.0
2016-10-03 06:00:00	NQ	Futures	5815.14	5816.04	5810.67	5810.97	881.0
2016-10-03 07:00:00	NQ	Futures	5810.97	5813.06	5808.88	5810.67	1124.0
2016-10-03 08:00:00	NQ	Futures	5810.37	5810.67	5795.16	5795.75	5183.0
2016-10-03 09:00:00	NQ	Futures	5795.75	5804.7	5785.31	5787.1	26626.0
2016-10-03 10:00:00	NQ	Futures	5787.4	5810.07	5785.31	5802.61	33898.0
2016-10-03 11:00:00	NQ	Futures	5802.91	5803.21	5779.94	5786.5	21466.0
2016-10-03 12:00:00	NQ	Futures	5786.5	5791.28	5779.05	5789.79	18309.0
2016-10-03 13:00:00	NQ	Futures	5789.49	5793.07	5782.03	5791.87	12986.0
2016-10-03 14:00:00	NQ	Futures	5791.87	5799.33	5786.8	5791.87	16230.0
2016-10-03 15:00:00	NQ	Futures	5791.87	5806.79	5789.49	5803.21	21218.0
2016-10-03 16:00:00	NQ	Futures	5803.21	5810.07	5802.91	5809.48	6469.0
2016-10-03 18:00:00	NQ	Futures	5807.69	5812.76	5807.39	5810.67	834.0
2016-10-03 19:00:00	NQ	Futures	5810.97	5811.27	5809.18	5809.77	339.0
2016-10-03 20:00:00	NQ	Futures	5809.77	5815.44	5808.58	5813.65	966.0
2016-10-03 21:00:00	NQ	Futures	5813.65	5814.85	5811.86	5811.86	640.0
2016-10-03 22:00:00	NQ	Futures	5812.46	5813.06	5809.48	5810.37	341.0
2016-10-03 23:00:00	NQ	Futures	5810.07	5812.76	5809.77	5810.67	258.0
2016-10-03 00:00:00	YM	Futures	19707.7	19707.7	19694.7	19699.1	312.0
2016-10-03 01:00:00	YM	Futures	19698.0	19707.7	19695.8	19698.0	484.0
2016-10-03 02:00:00	YM	Futures	19696.9	19704.5	19681.8	19690.4	918.0
2016-10-03 03:00:00	YM	Futures	19690.4	19703.4	19671.0	19701.2	2203.0

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

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