PREVIEW / futures_1hour / 2015-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-21.parquet
  size:    51 KB
  rows:    1,568

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
2015-12-21 00:00:00	ES	Futures	2149.13	2152.09	2148.87	2151.02	5498.0
2015-12-21 01:00:00	ES	Futures	2151.02	2151.28	2148.87	2149.4	3885.0
2015-12-21 02:00:00	ES	Futures	2149.67	2153.17	2149.4	2149.67	9827.0
2015-12-21 03:00:00	ES	Futures	2149.94	2162.57	2149.4	2161.76	34536.0
2015-12-21 04:00:00	ES	Futures	2161.76	2163.11	2159.08	2160.15	12682.0
2015-12-21 05:00:00	ES	Futures	2160.15	2164.45	2159.88	2161.23	14587.0
2015-12-21 06:00:00	ES	Futures	2161.5	2162.3	2159.08	2159.61	17029.0
2015-12-21 07:00:00	ES	Futures	2159.88	2160.42	2156.39	2158.0	14839.0
2015-12-21 08:00:00	ES	Futures	2158.0	2160.15	2156.93	2159.08	20761.0
2015-12-21 09:00:00	ES	Futures	2159.08	2165.26	2155.85	2157.46	204090.0
2015-12-21 10:00:00	ES	Futures	2157.46	2164.18	2155.85	2158.0	180007.0
2015-12-21 11:00:00	ES	Futures	2158.0	2159.35	2145.1	2150.21	188786.0
2015-12-21 12:00:00	ES	Futures	2150.21	2154.51	2146.99	2153.17	107166.0
2015-12-21 13:00:00	ES	Futures	2153.17	2158.81	2153.17	2155.58	70008.0
2015-12-21 14:00:00	ES	Futures	2155.58	2156.93	2149.94	2151.82	88633.0
2015-12-21 15:00:00	ES	Futures	2151.55	2163.11	2146.99	2162.84	183275.0
2015-12-21 16:00:00	ES	Futures	2162.57	2170.63	2160.42	2169.02	72932.0
2015-12-21 18:00:00	ES	Futures	2167.94	2169.29	2167.41	2168.75	4224.0
2015-12-21 19:00:00	ES	Futures	2168.75	2172.78	2166.6	2169.56	9976.0
2015-12-21 20:00:00	ES	Futures	2169.56	2170.09	2167.14	2167.14	3989.0
2015-12-21 21:00:00	ES	Futures	2167.14	2168.21	2166.06	2166.6	3645.0
2015-12-21 22:00:00	ES	Futures	2166.87	2167.41	2165.26	2167.41	2966.0
2015-12-21 23:00:00	ES	Futures	2167.41	2168.75	2167.41	2168.48	2073.0
2015-12-21 00:00:00	NQ	Futures	5372.97	5380.1	5372.97	5377.72	944.0
2015-12-21 01:00:00	NQ	Futures	5377.43	5377.43	5370.89	5370.89	617.0
2015-12-21 02:00:00	NQ	Futures	5371.19	5380.4	5371.19	5371.19	1783.0
2015-12-21 03:00:00	NQ	Futures	5371.49	5406.53	5370.3	5404.15	5355.0
2015-12-21 04:00:00	NQ	Futures	5403.85	5408.6	5399.99	5401.48	2190.0
2015-12-21 05:00:00	NQ	Futures	5401.48	5409.79	5400.29	5402.37	1573.0
2015-12-21 06:00:00	NQ	Futures	5402.37	5403.85	5397.02	5398.21	2350.0
2015-12-21 07:00:00	NQ	Futures	5398.51	5399.4	5389.3	5393.76	2749.0
2015-12-21 08:00:00	NQ	Futures	5394.05	5397.32	5389.6	5395.54	3923.0
2015-12-21 09:00:00	NQ	Futures	5395.84	5406.53	5380.4	5382.47	30774.0
2015-12-21 10:00:00	NQ	Futures	5382.47	5404.45	5382.47	5389.01	26642.0
2015-12-21 11:00:00	NQ	Futures	5389.01	5391.98	5358.72	5374.16	21421.0
2015-12-21 12:00:00	NQ	Futures	5374.16	5390.79	5372.68	5387.82	12640.0
2015-12-21 13:00:00	NQ	Futures	5388.12	5399.1	5387.23	5392.57	9823.0
2015-12-21 14:00:00	NQ	Futures	5392.27	5396.43	5372.38	5376.54	11313.0
2015-12-21 15:00:00	NQ	Futures	5376.24	5408.31	5365.85	5407.12	25820.0
2015-12-21 16:00:00	NQ	Futures	5407.42	5429.98	5405.64	5429.98	9308.0
2015-12-21 18:00:00	NQ	Futures	5426.72	5429.98	5425.23	5429.39	694.0
2015-12-21 19:00:00	NQ	Futures	5429.39	5435.63	5424.34	5431.47	2305.0
2015-12-21 20:00:00	NQ	Futures	5431.77	5432.06	5422.86	5423.75	784.0
2015-12-21 21:00:00	NQ	Futures	5423.45	5425.23	5419.89	5421.67	825.0
2015-12-21 22:00:00	NQ	Futures	5421.37	5423.15	5415.43	5423.15	935.0
2015-12-21 23:00:00	NQ	Futures	5423.45	5427.31	5422.86	5423.75	413.0
2015-12-21 00:00:00	YM	Futures	18178.1	18198.3	18177.0	18190.9	1070.0
2015-12-21 01:00:00	YM	Futures	18189.8	18189.8	18174.9	18176.0	587.0
2015-12-21 02:00:00	YM	Futures	18180.2	18201.5	18171.7	18171.7	1729.0
2015-12-21 03:00:00	YM	Futures	18171.7	18277.1	18164.3	18270.7	5191.0

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

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