PREVIEW / futures_1hour / 2012-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-04.parquet
  size:    32 KB
  rows:    954

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
2012-07-04 00:00:00	ES	Futures	1391.95	1392.71	1391.69	1392.46	935.0
2012-07-04 01:00:00	ES	Futures	1392.2	1393.47	1391.44	1392.2	2743.0
2012-07-04 02:00:00	ES	Futures	1392.2	1392.2	1390.68	1390.68	4000.0
2012-07-04 03:00:00	ES	Futures	1390.68	1391.44	1387.62	1388.13	19890.0
2012-07-04 04:00:00	ES	Futures	1388.39	1390.42	1387.12	1389.4	10980.0
2012-07-04 05:00:00	ES	Futures	1389.66	1390.42	1388.64	1389.91	7457.0
2012-07-04 06:00:00	ES	Futures	1390.17	1390.42	1388.64	1389.66	10078.0
2012-07-04 07:00:00	ES	Futures	1389.66	1390.17	1388.13	1389.66	9739.0
2012-07-04 08:00:00	ES	Futures	1389.66	1389.91	1388.39	1388.9	5726.0
2012-07-04 09:00:00	ES	Futures	1389.15	1390.42	1388.13	1390.42	9258.0
2012-07-04 10:00:00	ES	Futures	1390.42	1390.93	1389.4	1389.91	8049.0
2012-07-04 11:00:00	ES	Futures	1389.91	1391.95	1389.66	1391.44	6747.0
2012-07-04 18:00:00	ES	Futures	1389.4	1389.91	1387.12	1387.88	5460.0
2012-07-04 19:00:00	ES	Futures	1387.62	1389.15	1387.62	1388.64	1596.0
2012-07-04 20:00:00	ES	Futures	1388.39	1388.9	1387.88	1388.39	2077.0
2012-07-04 21:00:00	ES	Futures	1388.64	1388.9	1386.35	1386.61	4027.0
2012-07-04 22:00:00	ES	Futures	1386.61	1387.12	1385.34	1385.84	6007.0
2012-07-04 23:00:00	ES	Futures	1385.59	1386.35	1385.34	1385.59	2930.0
2012-07-04 00:00:00	NQ	Futures	3063.79	3064.37	3062.92	3063.5	283.0
2012-07-04 01:00:00	NQ	Futures	3063.5	3065.53	3062.92	3063.5	209.0
2012-07-04 02:00:00	NQ	Futures	3063.5	3063.79	3060.9	3061.76	494.0
2012-07-04 03:00:00	NQ	Futures	3062.05	3063.21	3054.81	3055.97	2516.0
2012-07-04 04:00:00	NQ	Futures	3055.97	3058.29	3052.78	3056.26	1697.0
2012-07-04 05:00:00	NQ	Futures	3056.55	3059.74	3054.52	3058.87	1229.0
2012-07-04 06:00:00	NQ	Futures	3059.16	3059.45	3054.52	3055.97	1445.0
2012-07-04 07:00:00	NQ	Futures	3055.68	3056.26	3052.78	3055.1	1130.0
2012-07-04 08:00:00	NQ	Futures	3054.81	3056.84	3052.78	3056.26	674.0
2012-07-04 09:00:00	NQ	Futures	3055.97	3060.61	3053.94	3060.61	985.0
2012-07-04 10:00:00	NQ	Futures	3060.32	3063.21	3060.32	3061.48	1073.0
2012-07-04 11:00:00	NQ	Futures	3061.76	3064.08	3061.19	3063.5	790.0
2012-07-04 18:00:00	NQ	Futures	3061.76	3061.76	3055.39	3056.84	483.0
2012-07-04 19:00:00	NQ	Futures	3056.84	3058.0	3055.97	3057.71	143.0
2012-07-04 20:00:00	NQ	Futures	3058.29	3059.74	3057.13	3058.58	255.0
2012-07-04 21:00:00	NQ	Futures	3058.0	3058.87	3054.23	3054.23	612.0
2012-07-04 22:00:00	NQ	Futures	3054.52	3055.39	3052.49	3052.78	650.0
2012-07-04 23:00:00	NQ	Futures	3052.78	3053.94	3051.62	3051.62	398.0
2012-07-04 00:00:00	YM	Futures	12791.0	12797.0	12791.0	12796.0	136.0
2012-07-04 01:00:00	YM	Futures	12794.0	12801.9	12790.0	12794.0	329.0
2012-07-04 02:00:00	YM	Futures	12794.0	12794.0	12784.0	12786.0	234.0
2012-07-04 03:00:00	YM	Futures	12786.0	12789.0	12768.1	12770.1	1326.0
2012-07-04 04:00:00	YM	Futures	12770.1	12780.1	12763.2	12774.1	1045.0
2012-07-04 05:00:00	YM	Futures	12774.1	12779.1	12770.1	12777.1	693.0
2012-07-04 06:00:00	YM	Futures	12776.1	12782.1	12767.1	12773.1	744.0
2012-07-04 07:00:00	YM	Futures	12772.1	12774.1	12765.1	12772.1	673.0
2012-07-04 08:00:00	YM	Futures	12772.1	12773.1	12766.1	12769.1	433.0
2012-07-04 09:00:00	YM	Futures	12769.1	12783.0	12764.2	12783.0	732.0
2012-07-04 10:00:00	YM	Futures	12783.0	12790.0	12778.1	12782.1	595.0
2012-07-04 11:00:00	YM	Futures	12782.1	12793.0	12781.1	12791.0	290.0
2012-07-04 18:00:00	YM	Futures	12783.0	12783.0	12763.2	12768.1	287.0
2012-07-04 19:00:00	YM	Futures	12768.1	12774.1	12765.1	12771.1	216.0

> showing 50 of 954 rows — these rows as CSV

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