PREVIEW / futures_1hour / 2015-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-14.parquet
  size:    43 KB
  rows:    1,264

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-08-14 00:00:00	ES	Futures	2214.39	2215.72	2214.12	2214.92	1385.0
2015-08-14 01:00:00	ES	Futures	2214.92	2217.05	2214.39	2215.45	3248.0
2015-08-14 02:00:00	ES	Futures	2215.45	2217.58	2214.12	2217.32	7020.0
2015-08-14 03:00:00	ES	Futures	2217.58	2220.78	2214.92	2219.45	27872.0
2015-08-14 04:00:00	ES	Futures	2219.45	2219.71	2213.85	2214.12	15946.0
2015-08-14 05:00:00	ES	Futures	2214.12	2215.45	2209.33	2210.93	20579.0
2015-08-14 06:00:00	ES	Futures	2210.66	2211.99	2208.8	2210.39	16661.0
2015-08-14 07:00:00	ES	Futures	2210.66	2210.93	2208.53	2209.86	25285.0
2015-08-14 08:00:00	ES	Futures	2210.13	2212.26	2208.53	2211.72	23041.0
2015-08-14 09:00:00	ES	Futures	2211.72	2219.71	2210.93	2218.38	164569.0
2015-08-14 10:00:00	ES	Futures	2218.38	2219.98	2214.12	2214.92	160481.0
2015-08-14 11:00:00	ES	Futures	2214.92	2218.38	2210.93	2217.58	142180.0
2015-08-14 12:00:00	ES	Futures	2217.58	2219.18	2214.39	2216.78	82223.0
2015-08-14 13:00:00	ES	Futures	2216.78	2221.31	2215.72	2218.91	103328.0
2015-08-14 14:00:00	ES	Futures	2218.91	2221.31	2217.85	2220.24	65003.0
2015-08-14 15:00:00	ES	Futures	2220.24	2224.24	2219.98	2222.91	130061.0
2015-08-14 16:00:00	ES	Futures	2222.91	2226.37	2222.37	2225.84	57714.0
2015-08-14 17:00:00	ES	Futures	2225.57	2225.84	2225.3	2225.57	1249.0
2015-08-14 00:00:00	NQ	Futures	5339.89	5344.32	5339.59	5341.96	128.0
2015-08-14 01:00:00	NQ	Futures	5341.96	5347.28	5339.89	5343.73	554.0
2015-08-14 02:00:00	NQ	Futures	5342.84	5348.46	5339.29	5347.58	1010.0
2015-08-14 03:00:00	NQ	Futures	5347.28	5357.93	5340.48	5354.97	3079.0
2015-08-14 04:00:00	NQ	Futures	5354.97	5356.15	5338.11	5338.11	2098.0
2015-08-14 05:00:00	NQ	Futures	5338.41	5342.25	5328.35	5332.79	3554.0
2015-08-14 06:00:00	NQ	Futures	5333.38	5336.34	5326.58	5331.9	3460.0
2015-08-14 07:00:00	NQ	Futures	5332.2	5333.08	5327.17	5331.01	4330.0
2015-08-14 08:00:00	NQ	Futures	5331.01	5336.34	5325.69	5335.15	3952.0
2015-08-14 09:00:00	NQ	Futures	5334.86	5352.31	5326.58	5348.76	27629.0
2015-08-14 10:00:00	NQ	Futures	5348.76	5353.79	5330.13	5335.15	27992.0
2015-08-14 11:00:00	NQ	Futures	5334.56	5342.55	5323.03	5339.89	21159.0
2015-08-14 12:00:00	NQ	Futures	5339.59	5343.73	5329.83	5334.56	12350.0
2015-08-14 13:00:00	NQ	Futures	5334.27	5353.2	5331.6	5344.32	15567.0
2015-08-14 14:00:00	NQ	Futures	5344.03	5352.61	5341.96	5349.94	9305.0
2015-08-14 15:00:00	NQ	Futures	5349.94	5362.96	5349.65	5355.86	22514.0
2015-08-14 16:00:00	NQ	Futures	5355.27	5364.44	5354.08	5362.96	4915.0
2015-08-14 17:00:00	NQ	Futures	5363.25	5363.25	5361.77	5363.25	173.0
2015-08-14 00:00:00	YM	Futures	18284.9	18295.4	18282.8	18287.0	138.0
2015-08-14 01:00:00	YM	Futures	18288.1	18303.9	18287.0	18293.3	569.0
2015-08-14 02:00:00	YM	Futures	18293.3	18308.1	18280.7	18307.0	995.0
2015-08-14 03:00:00	YM	Futures	18306.0	18337.6	18289.1	18324.9	2793.0
2015-08-14 04:00:00	YM	Futures	18327.0	18331.3	18290.2	18290.2	1578.0
2015-08-14 05:00:00	YM	Futures	18289.1	18300.7	18257.5	18268.1	2768.0
2015-08-14 06:00:00	YM	Futures	18269.1	18278.6	18252.3	18262.8	2340.0
2015-08-14 07:00:00	YM	Futures	18262.8	18269.1	18250.1	18261.7	2625.0
2015-08-14 08:00:00	YM	Futures	18260.7	18273.3	18247.0	18269.1	2279.0
2015-08-14 09:00:00	YM	Futures	18268.1	18343.9	18267.0	18331.3	16050.0
2015-08-14 10:00:00	YM	Futures	18332.3	18346.0	18297.5	18310.2	15472.0
2015-08-14 11:00:00	YM	Futures	18309.1	18337.6	18276.5	18332.3	11280.0
2015-08-14 12:00:00	YM	Futures	18331.3	18346.0	18304.9	18320.7	6662.0
2015-08-14 13:00:00	YM	Futures	18318.6	18357.6	18313.4	18335.5	8985.0

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

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