PREVIEW / futures_1hour / 2013-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-23.parquet
  size:    46 KB
  rows:    1,465

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
2013-12-23 00:00:00	ES	Futures	1882.74	1883.77	1882.48	1883.25	1697.0
2013-12-23 01:00:00	ES	Futures	1883.25	1883.51	1882.48	1883.0	1337.0
2013-12-23 02:00:00	ES	Futures	1883.0	1884.03	1882.74	1883.51	2471.0
2013-12-23 03:00:00	ES	Futures	1883.51	1884.81	1883.25	1884.29	8540.0
2013-12-23 04:00:00	ES	Futures	1884.29	1885.58	1884.03	1885.32	4203.0
2013-12-23 05:00:00	ES	Futures	1885.07	1885.84	1885.07	1885.32	4890.0
2013-12-23 06:00:00	ES	Futures	1885.32	1886.1	1883.77	1884.55	7955.0
2013-12-23 07:00:00	ES	Futures	1884.55	1885.84	1884.29	1885.84	6901.0
2013-12-23 08:00:00	ES	Futures	1885.84	1886.88	1885.07	1886.62	16788.0
2013-12-23 09:00:00	ES	Futures	1886.36	1886.88	1882.48	1882.48	116992.0
2013-12-23 10:00:00	ES	Futures	1882.74	1885.32	1881.19	1884.81	114794.0
2013-12-23 11:00:00	ES	Futures	1884.81	1886.62	1884.55	1885.84	58194.0
2013-12-23 12:00:00	ES	Futures	1886.1	1887.65	1885.32	1885.58	50564.0
2013-12-23 13:00:00	ES	Futures	1885.84	1886.62	1882.22	1884.03	73498.0
2013-12-23 14:00:00	ES	Futures	1884.03	1885.58	1883.25	1884.29	73674.0
2013-12-23 15:00:00	ES	Futures	1884.29	1886.36	1884.03	1885.58	111087.0
2013-12-23 16:00:00	ES	Futures	1885.84	1886.62	1885.07	1886.36	59089.0
2013-12-23 17:00:00	ES	Futures	1886.62	1886.62	1885.32	1886.36	2178.0
2013-12-23 18:00:00	ES	Futures	1885.84	1886.62	1885.32	1885.84	2535.0
2013-12-23 19:00:00	ES	Futures	1885.84	1885.84	1883.51	1883.77	3953.0
2013-12-23 20:00:00	ES	Futures	1884.03	1884.81	1883.51	1884.29	2168.0
2013-12-23 21:00:00	ES	Futures	1884.29	1884.55	1884.29	1884.29	789.0
2013-12-23 22:00:00	ES	Futures	1884.29	1884.81	1884.03	1884.29	1417.0
2013-12-23 23:00:00	ES	Futures	1884.29	1886.1	1884.29	1886.1	2160.0
2013-12-23 00:00:00	NQ	Futures	4124.53	4127.43	4124.53	4126.85	361.0
2013-12-23 01:00:00	NQ	Futures	4126.56	4127.43	4125.69	4126.85	354.0
2013-12-23 02:00:00	NQ	Futures	4127.14	4131.79	4126.56	4131.5	554.0
2013-12-23 03:00:00	NQ	Futures	4131.5	4134.7	4130.05	4133.83	1375.0
2013-12-23 04:00:00	NQ	Futures	4133.83	4137.32	4133.25	4136.15	806.0
2013-12-23 05:00:00	NQ	Futures	4135.86	4137.32	4134.7	4135.86	651.0
2013-12-23 06:00:00	NQ	Futures	4135.86	4138.77	4131.21	4131.79	1586.0
2013-12-23 07:00:00	NQ	Futures	4132.08	4137.61	4132.08	4137.61	980.0
2013-12-23 08:00:00	NQ	Futures	4137.32	4141.39	4136.44	4140.22	2540.0
2013-12-23 09:00:00	NQ	Futures	4140.22	4140.8	4128.89	4129.18	21962.0
2013-12-23 10:00:00	NQ	Futures	4129.47	4136.73	4125.11	4136.44	20449.0
2013-12-23 11:00:00	NQ	Futures	4136.15	4141.39	4135.28	4139.64	12871.0
2013-12-23 12:00:00	NQ	Futures	4139.93	4144.29	4138.19	4139.64	10341.0
2013-12-23 13:00:00	NQ	Futures	4139.35	4141.97	4132.37	4135.57	11696.0
2013-12-23 14:00:00	NQ	Futures	4135.57	4141.09	4133.25	4137.61	15245.0
2013-12-23 15:00:00	NQ	Futures	4137.9	4147.2	4137.9	4146.33	21668.0
2013-12-23 16:00:00	NQ	Futures	4146.62	4148.07	4143.71	4146.62	3740.0
2013-12-23 17:00:00	NQ	Futures	4146.33	4147.2	4145.16	4147.2	127.0
2013-12-23 18:00:00	NQ	Futures	4145.46	4146.33	4143.71	4144.58	267.0
2013-12-23 19:00:00	NQ	Futures	4144.0	4144.0	4141.97	4142.84	770.0
2013-12-23 20:00:00	NQ	Futures	4142.55	4144.0	4141.68	4143.13	342.0
2013-12-23 21:00:00	NQ	Futures	4143.13	4145.75	4142.84	4145.46	131.0
2013-12-23 22:00:00	NQ	Futures	4145.75	4146.91	4144.87	4145.75	385.0
2013-12-23 23:00:00	NQ	Futures	4145.75	4150.11	4145.75	4149.82	391.0
2013-12-23 00:00:00	YM	Futures	16631.0	16637.2	16631.0	16636.1	341.0
2013-12-23 01:00:00	YM	Futures	16635.1	16635.1	16629.0	16633.1	203.0

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

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