PREVIEW / futures_1hour / 2010-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-18.parquet
  size:    32 KB
  rows:    946

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
2010-01-18 00:00:00	ES	Futures	1103.18	1103.91	1102.69	1103.67	1332.0
2010-01-18 01:00:00	ES	Futures	1103.42	1103.91	1102.94	1103.42	1176.0
2010-01-18 02:00:00	ES	Futures	1103.67	1104.88	1102.94	1104.15	6226.0
2010-01-18 03:00:00	ES	Futures	1104.39	1104.64	1101.23	1101.96	17242.0
2010-01-18 04:00:00	ES	Futures	1102.21	1104.64	1101.72	1104.15	11290.0
2010-01-18 05:00:00	ES	Futures	1104.15	1104.64	1103.42	1103.91	10060.0
2010-01-18 06:00:00	ES	Futures	1103.91	1104.64	1102.69	1104.39	8073.0
2010-01-18 07:00:00	ES	Futures	1104.15	1104.64	1103.67	1104.64	3733.0
2010-01-18 08:00:00	ES	Futures	1104.64	1105.37	1103.91	1104.39	8864.0
2010-01-18 09:00:00	ES	Futures	1104.39	1105.85	1103.91	1105.12	9014.0
2010-01-18 10:00:00	ES	Futures	1104.88	1105.85	1104.88	1105.85	8877.0
2010-01-18 11:00:00	ES	Futures	1105.85	1106.34	1105.61	1106.1	7942.0
2010-01-18 18:00:00	ES	Futures	1105.85	1107.07	1105.61	1106.34	5542.0
2010-01-18 19:00:00	ES	Futures	1106.58	1106.58	1105.12	1105.85	4205.0
2010-01-18 20:00:00	ES	Futures	1105.85	1106.1	1105.37	1105.37	3287.0
2010-01-18 21:00:00	ES	Futures	1105.37	1105.85	1104.15	1104.64	7192.0
2010-01-18 22:00:00	ES	Futures	1104.39	1105.85	1104.39	1105.12	3180.0
2010-01-18 23:00:00	ES	Futures	1105.12	1105.37	1104.39	1104.39	1927.0
2010-01-18 00:00:00	NQ	Futures	2129.08	2130.22	2128.79	2129.65	454.0
2010-01-18 01:00:00	NQ	Futures	2129.37	2130.22	2128.51	2129.08	285.0
2010-01-18 02:00:00	NQ	Futures	2129.37	2132.22	2128.51	2131.08	746.0
2010-01-18 03:00:00	NQ	Futures	2130.79	2134.22	2127.37	2129.08	2571.0
2010-01-18 04:00:00	NQ	Futures	2129.08	2133.08	2128.51	2131.94	1564.0
2010-01-18 05:00:00	NQ	Futures	2131.94	2132.79	2129.65	2130.79	773.0
2010-01-18 06:00:00	NQ	Futures	2130.79	2131.94	2128.79	2131.65	1171.0
2010-01-18 07:00:00	NQ	Futures	2131.08	2131.65	2130.22	2130.79	688.0
2010-01-18 08:00:00	NQ	Futures	2131.08	2132.22	2130.22	2130.51	758.0
2010-01-18 09:00:00	NQ	Futures	2130.79	2135.36	2130.51	2133.94	2324.0
2010-01-18 10:00:00	NQ	Futures	2133.65	2139.93	2133.65	2139.65	3826.0
2010-01-18 11:00:00	NQ	Futures	2139.36	2142.22	2138.79	2141.36	1992.0
2010-01-18 18:00:00	NQ	Futures	2140.5	2141.93	2139.36	2141.36	358.0
2010-01-18 19:00:00	NQ	Futures	2140.79	2140.79	2138.51	2140.5	299.0
2010-01-18 20:00:00	NQ	Futures	2140.5	2140.5	2139.36	2139.36	165.0
2010-01-18 21:00:00	NQ	Futures	2139.08	2140.22	2137.65	2138.51	674.0
2010-01-18 22:00:00	NQ	Futures	2138.51	2140.79	2137.93	2139.93	270.0
2010-01-18 23:00:00	NQ	Futures	2139.65	2139.93	2137.93	2137.93	164.0
2010-01-18 00:00:00	YM	Futures	9894.3	9900.0	9892.5	9899.0	175.0
2010-01-18 01:00:00	YM	Futures	9899.0	9900.0	9893.4	9896.2	78.0
2010-01-18 02:00:00	YM	Futures	9898.1	9908.4	9894.3	9902.8	591.0
2010-01-18 03:00:00	YM	Futures	9901.8	9905.6	9878.4	9885.0	1492.0
2010-01-18 04:00:00	YM	Futures	9884.0	9904.6	9883.1	9899.0	707.0
2010-01-18 05:00:00	YM	Futures	9900.9	9905.6	9895.3	9899.0	325.0
2010-01-18 06:00:00	YM	Futures	9900.9	9905.6	9891.5	9900.9	493.0
2010-01-18 07:00:00	YM	Futures	9900.9	9906.5	9898.1	9903.7	254.0
2010-01-18 08:00:00	YM	Futures	9903.7	9913.1	9902.8	9907.4	1455.0
2010-01-18 09:00:00	YM	Futures	9910.2	9918.7	9904.6	9914.0	895.0
2010-01-18 10:00:00	YM	Futures	9913.1	9919.6	9911.2	9917.7	660.0
2010-01-18 11:00:00	YM	Futures	9916.8	9924.3	9914.9	9922.4	415.0
2010-01-18 18:00:00	YM	Futures	9920.5	9925.2	9914.0	9921.5	213.0
2010-01-18 19:00:00	YM	Futures	9921.5	9921.5	9912.1	9918.7	148.0

> showing 50 of 946 rows — these rows as CSV

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