PREVIEW / futures_1hour / 2010-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-06.parquet
  size:    30 KB
  rows:    886

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-09-06 00:00:00	ES	Futures	1085.56	1086.05	1084.58	1085.56	1311.0
2010-09-06 01:00:00	ES	Futures	1085.56	1086.3	1084.58	1086.05	3751.0
2010-09-06 02:00:00	ES	Futures	1085.8	1086.54	1084.33	1085.56	5723.0
2010-09-06 03:00:00	ES	Futures	1085.31	1085.8	1083.84	1084.82	15226.0
2010-09-06 04:00:00	ES	Futures	1084.58	1084.82	1082.37	1083.35	13591.0
2010-09-06 05:00:00	ES	Futures	1083.35	1085.07	1083.11	1084.82	11861.0
2010-09-06 06:00:00	ES	Futures	1084.82	1084.82	1083.84	1084.09	4076.0
2010-09-06 07:00:00	ES	Futures	1084.09	1084.58	1083.6	1084.33	4642.0
2010-09-06 08:00:00	ES	Futures	1084.58	1085.07	1084.09	1085.07	6250.0
2010-09-06 09:00:00	ES	Futures	1085.07	1086.05	1084.82	1084.82	8140.0
2010-09-06 10:00:00	ES	Futures	1085.07	1085.31	1084.33	1085.07	5227.0
2010-09-06 11:00:00	ES	Futures	1085.07	1086.05	1083.6	1084.09	9463.0
2010-09-06 18:00:00	ES	Futures	1083.6	1084.33	1083.35	1083.84	1696.0
2010-09-06 19:00:00	ES	Futures	1083.84	1084.82	1081.63	1081.63	5285.0
2010-09-06 20:00:00	ES	Futures	1082.12	1083.35	1081.14	1083.11	6915.0
2010-09-06 21:00:00	ES	Futures	1083.11	1086.79	1082.86	1085.07	10393.0
2010-09-06 22:00:00	ES	Futures	1085.31	1085.8	1084.09	1085.31	4271.0
2010-09-06 23:00:00	ES	Futures	1085.07	1085.56	1084.58	1085.31	3305.0
2010-09-06 00:00:00	NQ	Futures	2147.24	2147.24	2145.81	2145.81	133.0
2010-09-06 01:00:00	NQ	Futures	2146.38	2147.53	2144.66	2146.95	478.0
2010-09-06 02:00:00	NQ	Futures	2146.95	2147.53	2144.37	2146.38	384.0
2010-09-06 03:00:00	NQ	Futures	2146.67	2146.67	2142.94	2144.37	869.0
2010-09-06 04:00:00	NQ	Futures	2144.66	2144.66	2140.36	2142.65	775.0
2010-09-06 05:00:00	NQ	Futures	2142.37	2147.24	2142.08	2146.67	675.0
2010-09-06 06:00:00	NQ	Futures	2146.67	2147.81	2146.38	2147.53	499.0
2010-09-06 07:00:00	NQ	Futures	2147.53	2148.39	2146.95	2148.1	792.0
2010-09-06 08:00:00	NQ	Futures	2148.39	2149.53	2148.1	2148.96	603.0
2010-09-06 09:00:00	NQ	Futures	2148.96	2152.68	2148.39	2149.25	3034.0
2010-09-06 10:00:00	NQ	Futures	2148.96	2149.25	2143.51	2146.09	2636.0
2010-09-06 11:00:00	NQ	Futures	2146.38	2148.1	2142.65	2142.94	1541.0
2010-09-06 18:00:00	NQ	Futures	2142.65	2144.37	2141.51	2143.8	216.0
2010-09-06 19:00:00	NQ	Futures	2143.8	2144.95	2140.08	2140.65	473.0
2010-09-06 20:00:00	NQ	Futures	2140.08	2142.08	2139.22	2142.08	388.0
2010-09-06 21:00:00	NQ	Futures	2142.08	2147.81	2141.79	2145.81	1254.0
2010-09-06 22:00:00	NQ	Futures	2145.81	2146.67	2143.23	2144.95	473.0
2010-09-06 23:00:00	NQ	Futures	2144.95	2144.95	2143.51	2144.66	151.0
2010-09-06 00:00:00	YM	Futures	9895.8	9897.7	9887.3	9895.8	78.0
2010-09-06 01:00:00	YM	Futures	9894.9	9902.5	9890.1	9902.5	190.0
2010-09-06 02:00:00	YM	Futures	9902.5	9908.1	9890.1	9893.9	587.0
2010-09-06 03:00:00	YM	Futures	9893.9	9895.8	9883.5	9888.3	425.0
2010-09-06 04:00:00	YM	Futures	9889.2	9889.2	9873.1	9878.8	666.0
2010-09-06 05:00:00	YM	Futures	9879.7	9894.9	9878.8	9891.1	623.0
2010-09-06 06:00:00	YM	Futures	9891.1	9892.0	9885.4	9889.2	510.0
2010-09-06 07:00:00	YM	Futures	9890.1	9895.8	9886.4	9892.0	480.0
2010-09-06 08:00:00	YM	Futures	9893.9	9894.9	9889.2	9893.9	227.0
2010-09-06 09:00:00	YM	Futures	9893.9	9901.5	9893.9	9894.9	380.0
2010-09-06 10:00:00	YM	Futures	9893.9	9897.7	9891.1	9896.8	257.0
2010-09-06 11:00:00	YM	Futures	9897.7	9903.4	9892.0	9892.0	777.0
2010-09-06 18:00:00	YM	Futures	9891.1	9892.0	9884.5	9890.1	270.0
2010-09-06 19:00:00	YM	Futures	9890.1	9893.9	9870.3	9872.2	239.0

> showing 50 of 886 rows — these rows as CSV

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