PREVIEW / futures_1hour / 2013-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-24.parquet
  size:    29 KB
  rows:    803

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-24 00:00:00	ES	Futures	1885.84	1886.36	1884.55	1884.81	2278.0
2013-12-24 01:00:00	ES	Futures	1884.81	1885.84	1884.81	1885.84	1609.0
2013-12-24 02:00:00	ES	Futures	1885.58	1886.1	1884.81	1885.58	2649.0
2013-12-24 03:00:00	ES	Futures	1885.58	1887.39	1885.58	1886.88	5022.0
2013-12-24 04:00:00	ES	Futures	1887.13	1887.65	1886.62	1886.88	3029.0
2013-12-24 05:00:00	ES	Futures	1886.88	1887.65	1886.62	1886.88	3115.0
2013-12-24 06:00:00	ES	Futures	1886.88	1887.39	1885.84	1886.1	2906.0
2013-12-24 07:00:00	ES	Futures	1886.1	1886.1	1884.55	1885.58	7500.0
2013-12-24 08:00:00	ES	Futures	1885.32	1886.88	1885.07	1886.62	7018.0
2013-12-24 09:00:00	ES	Futures	1886.62	1887.91	1885.84	1887.39	51120.0
2013-12-24 10:00:00	ES	Futures	1887.13	1890.24	1887.13	1889.98	63891.0
2013-12-24 11:00:00	ES	Futures	1889.98	1891.27	1889.2	1891.01	45962.0
2013-12-24 12:00:00	ES	Futures	1890.76	1891.53	1889.98	1890.76	74693.0
2013-12-24 13:00:00	ES	Futures	1891.01	1892.82	1890.5	1892.57	30505.0
2013-12-24 00:00:00	NQ	Futures	4149.23	4149.23	4144.0	4145.46	671.0
2013-12-24 01:00:00	NQ	Futures	4145.16	4145.75	4143.42	4145.46	250.0
2013-12-24 02:00:00	NQ	Futures	4145.16	4146.04	4143.42	4145.16	214.0
2013-12-24 03:00:00	NQ	Futures	4145.46	4148.65	4144.87	4146.91	330.0
2013-12-24 04:00:00	NQ	Futures	4146.91	4148.36	4144.0	4144.29	312.0
2013-12-24 05:00:00	NQ	Futures	4144.29	4146.33	4144.29	4144.87	198.0
2013-12-24 06:00:00	NQ	Futures	4144.87	4145.75	4143.42	4144.0	133.0
2013-12-24 07:00:00	NQ	Futures	4144.29	4145.75	4142.84	4145.46	305.0
2013-12-24 08:00:00	NQ	Futures	4145.16	4147.49	4144.58	4147.49	806.0
2013-12-24 09:00:00	NQ	Futures	4147.2	4151.85	4143.42	4148.07	11343.0
2013-12-24 10:00:00	NQ	Futures	4147.78	4149.23	4140.51	4144.58	11027.0
2013-12-24 11:00:00	NQ	Futures	4144.29	4147.78	4143.13	4145.46	6549.0
2013-12-24 12:00:00	NQ	Futures	4145.46	4151.27	4145.16	4150.4	10996.0
2013-12-24 13:00:00	NQ	Futures	4150.4	4154.18	4149.82	4152.14	2047.0
2013-12-24 00:00:00	YM	Futures	16654.6	16660.7	16644.3	16648.4	347.0
2013-12-24 01:00:00	YM	Futures	16648.4	16655.6	16648.4	16654.6	111.0
2013-12-24 02:00:00	YM	Futures	16652.5	16655.6	16645.4	16651.5	273.0
2013-12-24 03:00:00	YM	Futures	16651.5	16660.7	16651.5	16656.6	430.0
2013-12-24 04:00:00	YM	Futures	16657.7	16667.9	16655.6	16666.9	332.0
2013-12-24 05:00:00	YM	Futures	16666.9	16669.0	16661.8	16664.8	176.0
2013-12-24 06:00:00	YM	Futures	16664.8	16665.9	16656.6	16656.6	162.0
2013-12-24 07:00:00	YM	Futures	16657.7	16657.7	16651.5	16655.6	333.0
2013-12-24 08:00:00	YM	Futures	16656.6	16666.9	16652.5	16661.8	300.0
2013-12-24 09:00:00	YM	Futures	16660.7	16683.3	16654.6	16674.1	4083.0
2013-12-24 10:00:00	YM	Futures	16673.1	16690.5	16673.1	16684.3	3715.0
2013-12-24 11:00:00	YM	Futures	16684.3	16703.8	16684.3	16698.7	2775.0
2013-12-24 12:00:00	YM	Futures	16699.7	16715.1	16695.6	16707.9	3946.0
2013-12-24 13:00:00	YM	Futures	16707.9	16719.2	16701.8	16718.2	1272.0
2013-12-24 00:00:00	CL	Futures	155.38	155.46	155.38	155.41	171.0
2013-12-24 01:00:00	CL	Futures	155.41	155.46	155.34	155.38	142.0
2013-12-24 02:00:00	CL	Futures	155.41	155.57	155.38	155.55	266.0
2013-12-24 03:00:00	CL	Futures	155.55	155.69	155.49	155.69	401.0
2013-12-24 04:00:00	CL	Futures	155.69	155.82	155.58	155.71	858.0
2013-12-24 05:00:00	CL	Futures	155.72	156.1	155.69	156.02	1040.0
2013-12-24 06:00:00	CL	Futures	156.02	156.23	155.97	156.16	1669.0
2013-12-24 07:00:00	CL	Futures	156.18	156.2	155.91	155.97	1589.0

> showing 50 of 803 rows — these rows as CSV

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