PREVIEW / futures_1hour / 2015-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-30.parquet
  size:    52 KB
  rows:    1,573

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-09-30 00:00:00	ES	Futures	2019.94	2022.61	2018.6	2022.34	6958.0
2015-09-30 01:00:00	ES	Futures	2022.34	2024.75	2021.27	2023.41	12348.0
2015-09-30 02:00:00	ES	Futures	2023.41	2026.36	2022.08	2025.82	18742.0
2015-09-30 03:00:00	ES	Futures	2025.82	2026.89	2020.74	2022.08	27034.0
2015-09-30 04:00:00	ES	Futures	2021.81	2029.3	2020.2	2027.43	25528.0
2015-09-30 05:00:00	ES	Futures	2027.7	2030.91	2027.16	2029.84	28308.0
2015-09-30 06:00:00	ES	Futures	2030.1	2032.51	2028.77	2030.91	23106.0
2015-09-30 07:00:00	ES	Futures	2030.91	2033.85	2029.03	2029.57	36252.0
2015-09-30 08:00:00	ES	Futures	2029.57	2032.51	2027.16	2029.03	54170.0
2015-09-30 09:00:00	ES	Futures	2029.3	2038.4	2026.89	2031.17	257114.0
2015-09-30 10:00:00	ES	Futures	2031.44	2041.07	2030.37	2035.99	288448.0
2015-09-30 11:00:00	ES	Futures	2035.72	2037.86	2027.7	2030.37	222291.0
2015-09-30 12:00:00	ES	Futures	2030.37	2031.44	2019.13	2022.61	197686.0
2015-09-30 13:00:00	ES	Futures	2022.61	2035.72	2022.08	2034.39	158370.0
2015-09-30 14:00:00	ES	Futures	2034.39	2037.86	2029.57	2036.79	170252.0
2015-09-30 15:00:00	ES	Futures	2037.06	2044.82	2032.51	2043.22	457136.0
2015-09-30 16:00:00	ES	Futures	2042.95	2043.75	2034.92	2036.26	170808.0
2015-09-30 18:00:00	ES	Futures	2036.26	2038.67	2034.92	2037.86	8391.0
2015-09-30 19:00:00	ES	Futures	2037.6	2038.67	2037.6	2037.6	2878.0
2015-09-30 20:00:00	ES	Futures	2037.6	2040.0	2036.26	2039.74	9351.0
2015-09-30 21:00:00	ES	Futures	2039.74	2048.03	2038.13	2046.69	16782.0
2015-09-30 22:00:00	ES	Futures	2046.96	2059.0	2045.89	2056.59	28597.0
2015-09-30 23:00:00	ES	Futures	2056.59	2063.02	2055.52	2059.0	21306.0
2015-09-30 00:00:00	NQ	Futures	4866.6	4872.83	4863.34	4872.53	895.0
2015-09-30 01:00:00	NQ	Futures	4872.53	4878.46	4867.49	4873.42	2282.0
2015-09-30 02:00:00	NQ	Futures	4874.02	4880.84	4868.68	4878.17	2391.0
2015-09-30 03:00:00	NQ	Futures	4878.46	4883.21	4866.31	4871.05	4162.0
2015-09-30 04:00:00	NQ	Futures	4870.16	4893.58	4866.01	4888.84	5255.0
2015-09-30 05:00:00	NQ	Futures	4888.54	4895.96	4888.25	4892.69	2784.0
2015-09-30 06:00:00	NQ	Futures	4893.29	4901.0	4890.62	4896.55	3264.0
2015-09-30 07:00:00	NQ	Futures	4896.25	4908.41	4895.07	4896.85	5867.0
2015-09-30 08:00:00	NQ	Futures	4896.85	4906.33	4892.99	4898.03	7636.0
2015-09-30 09:00:00	NQ	Futures	4898.03	4924.72	4890.92	4901.89	51186.0
2015-09-30 10:00:00	NQ	Futures	4902.18	4944.28	4899.81	4925.9	50583.0
2015-09-30 11:00:00	NQ	Futures	4925.9	4930.65	4901.89	4911.08	31372.0
2015-09-30 12:00:00	NQ	Futures	4911.37	4915.23	4877.57	4888.25	32165.0
2015-09-30 13:00:00	NQ	Futures	4888.25	4932.42	4887.36	4927.98	25285.0
2015-09-30 14:00:00	NQ	Futures	4928.27	4930.94	4904.55	4928.57	29261.0
2015-09-30 15:00:00	NQ	Futures	4928.27	4943.39	4911.37	4938.35	64957.0
2015-09-30 16:00:00	NQ	Futures	4938.65	4940.73	4922.34	4926.49	15743.0
2015-09-30 18:00:00	NQ	Futures	4926.49	4931.24	4922.05	4928.57	1037.0
2015-09-30 19:00:00	NQ	Futures	4928.87	4930.94	4928.27	4928.57	306.0
2015-09-30 20:00:00	NQ	Futures	4929.76	4934.8	4925.61	4933.61	1622.0
2015-09-30 21:00:00	NQ	Futures	4933.61	4955.55	4930.35	4951.7	3034.0
2015-09-30 22:00:00	NQ	Futures	4952.29	4981.35	4948.44	4978.38	5138.0
2015-09-30 23:00:00	NQ	Futures	4978.68	4995.58	4977.19	4989.65	5018.0
2015-09-30 00:00:00	YM	Futures	16997.8	17022.2	16991.5	17022.2	866.0
2015-09-30 01:00:00	YM	Futures	17022.2	17041.3	17011.6	17027.5	2306.0
2015-09-30 02:00:00	YM	Futures	17028.6	17054.0	17019.0	17050.8	2502.0
2015-09-30 03:00:00	YM	Futures	17052.9	17067.8	17012.7	17023.3	4312.0

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

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