PREVIEW / futures_1hour / 2014-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-29.parquet
  size:    47 KB
  rows:    1,531

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
2014-07-29 00:00:00	ES	Futures	2055.2	2056.5	2054.94	2056.24	1926.0
2014-07-29 01:00:00	ES	Futures	2055.98	2056.77	2055.98	2056.5	3097.0
2014-07-29 02:00:00	ES	Futures	2056.5	2056.77	2054.94	2056.24	5362.0
2014-07-29 03:00:00	ES	Futures	2055.98	2057.81	2054.42	2054.42	25237.0
2014-07-29 04:00:00	ES	Futures	2054.68	2054.68	2051.29	2054.16	27951.0
2014-07-29 05:00:00	ES	Futures	2054.16	2055.46	2052.86	2054.68	11701.0
2014-07-29 06:00:00	ES	Futures	2054.68	2058.07	2054.16	2058.07	17849.0
2014-07-29 07:00:00	ES	Futures	2058.07	2060.67	2058.07	2059.11	29302.0
2014-07-29 08:00:00	ES	Futures	2059.11	2061.72	2058.33	2059.37	30287.0
2014-07-29 09:00:00	ES	Futures	2059.63	2062.5	2057.03	2060.94	162313.0
2014-07-29 10:00:00	ES	Futures	2060.94	2063.54	2059.11	2059.63	186178.0
2014-07-29 11:00:00	ES	Futures	2059.63	2060.15	2050.77	2055.2	305684.0
2014-07-29 12:00:00	ES	Futures	2054.94	2059.37	2054.42	2059.37	108823.0
2014-07-29 13:00:00	ES	Futures	2059.37	2059.89	2057.03	2058.33	73708.0
2014-07-29 14:00:00	ES	Futures	2058.33	2059.11	2052.07	2053.38	139457.0
2014-07-29 15:00:00	ES	Futures	2053.38	2054.16	2047.64	2047.9	236312.0
2014-07-29 16:00:00	ES	Futures	2048.17	2048.43	2045.3	2048.17	115566.0
2014-07-29 17:00:00	ES	Futures	2048.17	2048.17	2047.38	2047.9	1784.0
2014-07-29 18:00:00	ES	Futures	2047.64	2048.95	2047.64	2047.64	3944.0
2014-07-29 19:00:00	ES	Futures	2047.9	2048.43	2047.38	2047.9	2278.0
2014-07-29 20:00:00	ES	Futures	2048.17	2048.43	2047.38	2048.17	5315.0
2014-07-29 21:00:00	ES	Futures	2048.17	2049.21	2047.9	2048.69	3104.0
2014-07-29 22:00:00	ES	Futures	2048.69	2049.47	2048.43	2048.69	3240.0
2014-07-29 23:00:00	ES	Futures	2048.95	2048.95	2047.9	2048.43	1346.0
2014-07-29 00:00:00	NQ	Futures	4619.67	4622.59	4619.38	4621.72	307.0
2014-07-29 01:00:00	NQ	Futures	4621.72	4626.1	4621.72	4625.51	969.0
2014-07-29 02:00:00	NQ	Futures	4625.51	4626.68	4621.72	4625.22	834.0
2014-07-29 03:00:00	NQ	Futures	4624.93	4629.6	4621.42	4621.72	3417.0
2014-07-29 04:00:00	NQ	Futures	4621.72	4622.01	4614.12	4621.13	4312.0
2014-07-29 05:00:00	NQ	Futures	4621.42	4624.93	4618.8	4623.47	2049.0
2014-07-29 06:00:00	NQ	Futures	4623.18	4630.77	4622.3	4630.18	3302.0
2014-07-29 07:00:00	NQ	Futures	4630.18	4635.73	4630.18	4632.81	3756.0
2014-07-29 08:00:00	NQ	Futures	4632.81	4638.07	4630.48	4632.52	4724.0
2014-07-29 09:00:00	NQ	Futures	4632.81	4642.74	4627.85	4637.49	28807.0
2014-07-29 10:00:00	NQ	Futures	4637.78	4645.95	4634.27	4636.32	31452.0
2014-07-29 11:00:00	NQ	Futures	4636.32	4638.36	4613.25	4627.56	42479.0
2014-07-29 12:00:00	NQ	Futures	4627.56	4635.73	4625.8	4633.11	18355.0
2014-07-29 13:00:00	NQ	Futures	4633.4	4638.07	4630.18	4635.73	10531.0
2014-07-29 14:00:00	NQ	Futures	4635.44	4640.7	4622.01	4628.14	19700.0
2014-07-29 15:00:00	NQ	Futures	4628.14	4630.48	4615.88	4617.63	31551.0
2014-07-29 16:00:00	NQ	Futures	4617.92	4623.47	4612.08	4623.47	10369.0
2014-07-29 17:00:00	NQ	Futures	4623.18	4623.47	4621.42	4621.72	250.0
2014-07-29 18:00:00	NQ	Futures	4622.3	4623.76	4621.13	4621.42	570.0
2014-07-29 19:00:00	NQ	Futures	4621.72	4623.18	4620.84	4622.01	184.0
2014-07-29 20:00:00	NQ	Futures	4622.59	4623.47	4620.84	4622.59	472.0
2014-07-29 21:00:00	NQ	Futures	4622.88	4625.51	4622.59	4625.22	436.0
2014-07-29 22:00:00	NQ	Futures	4624.93	4626.97	4624.93	4625.8	732.0
2014-07-29 23:00:00	NQ	Futures	4625.51	4626.1	4623.47	4624.93	216.0
2014-07-29 00:00:00	YM	Futures	17493.5	17503.8	17491.4	17502.8	343.0
2014-07-29 01:00:00	YM	Futures	17501.8	17505.9	17499.7	17502.8	545.0

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

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