PREVIEW / futures_1hour / 2010-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-08.parquet
  size:    38 KB
  rows:    1,107

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-08 00:00:00	ES	Futures	1107.07	1107.8	1106.58	1107.07	1482.0
2010-01-08 01:00:00	ES	Futures	1106.83	1108.04	1106.83	1107.8	2294.0
2010-01-08 02:00:00	ES	Futures	1107.8	1108.77	1107.31	1107.56	6666.0
2010-01-08 03:00:00	ES	Futures	1107.31	1108.53	1106.83	1107.8	11958.0
2010-01-08 04:00:00	ES	Futures	1107.56	1107.8	1106.58	1107.07	11214.0
2010-01-08 05:00:00	ES	Futures	1106.83	1108.04	1106.58	1107.56	7814.0
2010-01-08 06:00:00	ES	Futures	1107.56	1108.04	1107.31	1107.8	5644.0
2010-01-08 07:00:00	ES	Futures	1107.8	1107.8	1105.85	1106.34	20264.0
2010-01-08 08:00:00	ES	Futures	1106.58	1108.77	1100.5	1103.67	173684.0
2010-01-08 09:00:00	ES	Futures	1103.42	1105.85	1101.48	1105.61	272980.0
2010-01-08 10:00:00	ES	Futures	1105.37	1106.83	1104.15	1106.1	240412.0
2010-01-08 11:00:00	ES	Futures	1106.1	1107.07	1104.39	1106.1	143383.0
2010-01-08 12:00:00	ES	Futures	1105.85	1106.83	1105.37	1105.61	79022.0
2010-01-08 13:00:00	ES	Futures	1105.37	1107.8	1105.37	1105.61	103168.0
2010-01-08 14:00:00	ES	Futures	1105.61	1106.58	1105.12	1105.85	93297.0
2010-01-08 15:00:00	ES	Futures	1105.85	1110.96	1105.37	1110.48	235372.0
2010-01-08 16:00:00	ES	Futures	1110.48	1110.96	1109.99	1110.72	87151.0
2010-01-08 00:00:00	NQ	Futures	2145.93	2147.36	2145.36	2145.36	120.0
2010-01-08 01:00:00	NQ	Futures	2145.36	2148.79	2145.36	2147.93	318.0
2010-01-08 02:00:00	NQ	Futures	2147.65	2149.07	2146.5	2146.5	687.0
2010-01-08 03:00:00	NQ	Futures	2146.5	2148.22	2145.36	2145.93	2477.0
2010-01-08 04:00:00	NQ	Futures	2145.93	2146.22	2144.22	2145.36	1564.0
2010-01-08 05:00:00	NQ	Futures	2145.36	2147.65	2144.79	2147.07	750.0
2010-01-08 06:00:00	NQ	Futures	2147.36	2147.93	2145.93	2147.93	508.0
2010-01-08 07:00:00	NQ	Futures	2147.65	2147.65	2145.07	2146.22	1834.0
2010-01-08 08:00:00	NQ	Futures	2145.93	2150.22	2130.79	2137.08	20788.0
2010-01-08 09:00:00	NQ	Futures	2137.36	2143.93	2132.51	2142.5	40521.0
2010-01-08 10:00:00	NQ	Futures	2142.22	2154.21	2142.22	2150.22	62284.0
2010-01-08 11:00:00	NQ	Futures	2149.93	2155.36	2147.07	2153.93	29457.0
2010-01-08 12:00:00	NQ	Futures	2153.64	2155.36	2151.36	2153.64	15071.0
2010-01-08 13:00:00	NQ	Futures	2153.93	2159.93	2153.07	2156.21	24498.0
2010-01-08 14:00:00	NQ	Futures	2156.21	2157.64	2154.79	2156.5	14441.0
2010-01-08 15:00:00	NQ	Futures	2156.21	2161.07	2154.79	2160.5	32186.0
2010-01-08 16:00:00	NQ	Futures	2160.5	2162.21	2157.93	2159.36	17888.0
2010-01-08 00:00:00	YM	Futures	9870.9	9875.6	9867.2	9868.1	81.0
2010-01-08 01:00:00	YM	Futures	9867.2	9878.4	9867.2	9876.6	170.0
2010-01-08 02:00:00	YM	Futures	9876.6	9885.9	9873.7	9874.7	588.0
2010-01-08 03:00:00	YM	Futures	9873.7	9883.1	9869.1	9879.4	993.0
2010-01-08 04:00:00	YM	Futures	9878.4	9879.4	9871.9	9876.6	814.0
2010-01-08 05:00:00	YM	Futures	9876.6	9883.1	9873.7	9881.2	911.0
2010-01-08 06:00:00	YM	Futures	9881.2	9882.2	9876.6	9880.3	327.0
2010-01-08 07:00:00	YM	Futures	9879.4	9881.2	9865.3	9868.1	1039.0
2010-01-08 08:00:00	YM	Futures	9869.1	9900.0	9822.3	9852.2	7760.0
2010-01-08 09:00:00	YM	Futures	9850.4	9862.5	9827.0	9853.2	15278.0
2010-01-08 10:00:00	YM	Futures	9854.1	9862.5	9839.1	9854.1	13221.0
2010-01-08 11:00:00	YM	Futures	9853.2	9861.6	9845.7	9857.8	8175.0
2010-01-08 12:00:00	YM	Futures	9856.9	9862.5	9850.4	9851.3	4695.0
2010-01-08 13:00:00	YM	Futures	9850.4	9864.4	9843.8	9846.6	5321.0
2010-01-08 14:00:00	YM	Futures	9846.6	9853.2	9842.9	9847.5	5172.0
2010-01-08 15:00:00	YM	Futures	9847.5	9887.8	9844.7	9886.9	11180.0

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

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