PREVIEW / futures_1hour / 2015-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-06.parquet
  size:    49 KB
  rows:    1,534

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-06 00:00:00	ES	Futures	2227.97	2228.76	2227.43	2227.97	1496.0
2015-08-06 01:00:00	ES	Futures	2227.7	2228.76	2226.9	2227.7	2806.0
2015-08-06 02:00:00	ES	Futures	2227.97	2229.56	2227.43	2229.3	4696.0
2015-08-06 03:00:00	ES	Futures	2229.56	2232.23	2227.7	2230.36	14144.0
2015-08-06 04:00:00	ES	Futures	2230.1	2232.49	2229.83	2230.89	10343.0
2015-08-06 05:00:00	ES	Futures	2230.63	2231.43	2227.97	2229.03	7147.0
2015-08-06 06:00:00	ES	Futures	2229.3	2231.16	2228.5	2230.63	8295.0
2015-08-06 07:00:00	ES	Futures	2230.63	2235.69	2229.3	2234.09	23442.0
2015-08-06 08:00:00	ES	Futures	2234.09	2234.36	2230.63	2231.69	23760.0
2015-08-06 09:00:00	ES	Futures	2231.43	2234.36	2221.58	2222.64	193507.0
2015-08-06 10:00:00	ES	Futures	2222.91	2225.57	2218.65	2220.51	235872.0
2015-08-06 11:00:00	ES	Futures	2220.78	2221.04	2208.0	2208.53	299710.0
2015-08-06 12:00:00	ES	Futures	2208.26	2210.66	2204.54	2207.46	192014.0
2015-08-06 13:00:00	ES	Futures	2207.2	2213.59	2206.4	2210.39	154596.0
2015-08-06 14:00:00	ES	Futures	2210.39	2214.92	2209.06	2212.52	128240.0
2015-08-06 15:00:00	ES	Futures	2212.79	2215.98	2209.33	2213.06	210637.0
2015-08-06 16:00:00	ES	Futures	2213.32	2215.45	2211.19	2214.92	83277.0
2015-08-06 17:00:00	ES	Futures	2215.19	2215.19	2214.39	2214.92	1876.0
2015-08-06 18:00:00	ES	Futures	2215.19	2215.72	2214.65	2214.92	2275.0
2015-08-06 19:00:00	ES	Futures	2215.19	2215.19	2213.85	2214.12	1559.0
2015-08-06 20:00:00	ES	Futures	2214.12	2215.19	2213.59	2214.65	2592.0
2015-08-06 21:00:00	ES	Futures	2214.39	2215.72	2214.39	2215.45	2433.0
2015-08-06 22:00:00	ES	Futures	2215.19	2216.25	2215.19	2215.98	2422.0
2015-08-06 23:00:00	ES	Futures	2215.98	2217.85	2215.72	2217.32	3874.0
2015-08-06 00:00:00	NQ	Futures	5431.58	5433.06	5428.62	5429.51	305.0
2015-08-06 01:00:00	NQ	Futures	5429.51	5431.88	5427.74	5429.21	553.0
2015-08-06 02:00:00	NQ	Futures	5429.51	5434.83	5429.51	5433.95	894.0
2015-08-06 03:00:00	NQ	Futures	5434.24	5440.16	5426.85	5433.65	2766.0
2015-08-06 04:00:00	NQ	Futures	5433.65	5444.0	5432.76	5440.16	1983.0
2015-08-06 05:00:00	NQ	Futures	5439.86	5441.05	5431.29	5435.72	1144.0
2015-08-06 06:00:00	NQ	Futures	5435.72	5442.23	5434.54	5439.57	1462.0
2015-08-06 07:00:00	NQ	Futures	5439.57	5452.88	5437.5	5447.55	3010.0
2015-08-06 08:00:00	NQ	Futures	5447.55	5448.74	5438.68	5440.45	3294.0
2015-08-06 09:00:00	NQ	Futures	5440.45	5451.99	5402.0	5407.33	38784.0
2015-08-06 10:00:00	NQ	Futures	5407.33	5417.38	5378.63	5378.63	42843.0
2015-08-06 11:00:00	NQ	Futures	5378.63	5381.59	5334.56	5335.75	51936.0
2015-08-06 12:00:00	NQ	Futures	5335.45	5344.03	5327.46	5339.0	26115.0
2015-08-06 13:00:00	NQ	Futures	5338.7	5358.23	5334.56	5346.1	22770.0
2015-08-06 14:00:00	NQ	Futures	5346.39	5359.7	5341.96	5350.53	22542.0
2015-08-06 15:00:00	NQ	Futures	5350.83	5359.7	5337.82	5352.9	35296.0
2015-08-06 16:00:00	NQ	Futures	5352.9	5357.04	5346.39	5356.45	8701.0
2015-08-06 17:00:00	NQ	Futures	5356.45	5357.63	5355.86	5357.04	244.0
2015-08-06 18:00:00	NQ	Futures	5356.45	5359.11	5355.56	5355.86	424.0
2015-08-06 19:00:00	NQ	Futures	5356.15	5356.15	5352.31	5353.2	303.0
2015-08-06 20:00:00	NQ	Futures	5353.2	5356.15	5352.01	5353.79	393.0
2015-08-06 21:00:00	NQ	Futures	5353.79	5356.45	5353.2	5355.56	543.0
2015-08-06 22:00:00	NQ	Futures	5355.27	5357.63	5354.38	5357.34	638.0
2015-08-06 23:00:00	NQ	Futures	5357.34	5363.85	5356.75	5362.66	919.0
2015-08-06 00:00:00	YM	Futures	18392.4	18395.5	18389.2	18391.3	161.0
2015-08-06 01:00:00	YM	Futures	18391.3	18395.5	18383.9	18387.1	490.0

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

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