PREVIEW / futures_1hour / 2010-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-05.parquet
  size:    48 KB
  rows:    1,390

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-05-05 00:00:00	ES	Futures	1144.89	1145.87	1144.4	1145.87	3296.0
2010-05-05 01:00:00	ES	Futures	1145.87	1146.36	1145.38	1145.63	4223.0
2010-05-05 02:00:00	ES	Futures	1145.38	1147.83	1144.4	1147.34	17251.0
2010-05-05 03:00:00	ES	Futures	1147.09	1148.31	1140.49	1141.23	70364.0
2010-05-05 04:00:00	ES	Futures	1141.47	1146.6	1140.74	1146.11	47701.0
2010-05-05 05:00:00	ES	Futures	1146.36	1148.56	1145.63	1148.07	29926.0
2010-05-05 06:00:00	ES	Futures	1148.31	1148.8	1144.65	1144.65	31850.0
2010-05-05 07:00:00	ES	Futures	1144.65	1145.14	1141.47	1142.2	61537.0
2010-05-05 08:00:00	ES	Futures	1142.45	1144.16	1135.36	1135.85	152187.0
2010-05-05 09:00:00	ES	Futures	1136.09	1137.56	1129.0	1137.32	537775.0
2010-05-05 10:00:00	ES	Futures	1137.32	1143.18	1135.36	1141.72	532414.0
2010-05-05 11:00:00	ES	Futures	1141.72	1146.6	1137.32	1145.87	315595.0
2010-05-05 12:00:00	ES	Futures	1145.87	1146.85	1138.78	1141.72	207518.0
2010-05-05 13:00:00	ES	Futures	1141.72	1143.67	1139.03	1140.49	141983.0
2010-05-05 14:00:00	ES	Futures	1140.25	1140.98	1131.45	1135.12	373999.0
2010-05-05 15:00:00	ES	Futures	1135.12	1138.29	1132.67	1137.56	378400.0
2010-05-05 16:00:00	ES	Futures	1137.32	1138.29	1136.34	1137.8	113468.0
2010-05-05 17:00:00	ES	Futures	1137.56	1139.03	1137.07	1138.54	4808.0
2010-05-05 18:00:00	ES	Futures	1138.78	1140.25	1138.54	1140.25	5053.0
2010-05-05 19:00:00	ES	Futures	1140.25	1140.98	1139.03	1140.49	5368.0
2010-05-05 20:00:00	ES	Futures	1140.49	1140.98	1138.54	1140.25	9572.0
2010-05-05 21:00:00	ES	Futures	1140.49	1140.98	1139.76	1140.74	4312.0
2010-05-05 22:00:00	ES	Futures	1140.98	1141.23	1139.52	1140.74	5196.0
2010-05-05 23:00:00	ES	Futures	1140.98	1140.98	1139.52	1139.76	3430.0
2010-05-05 00:00:00	NQ	Futures	2254.33	2255.47	2253.47	2254.9	107.0
2010-05-05 01:00:00	NQ	Futures	2255.18	2256.04	2254.61	2254.9	157.0
2010-05-05 02:00:00	NQ	Futures	2254.33	2257.76	2253.75	2257.19	1213.0
2010-05-05 03:00:00	NQ	Futures	2256.9	2257.76	2246.31	2247.74	3748.0
2010-05-05 04:00:00	NQ	Futures	2248.02	2256.62	2246.88	2256.33	3006.0
2010-05-05 05:00:00	NQ	Futures	2255.47	2258.91	2254.04	2257.48	2522.0
2010-05-05 06:00:00	NQ	Futures	2257.48	2257.48	2249.74	2250.03	1879.0
2010-05-05 07:00:00	NQ	Futures	2249.74	2252.03	2246.31	2248.02	3953.0
2010-05-05 08:00:00	NQ	Futures	2247.74	2251.17	2229.41	2231.99	13924.0
2010-05-05 09:00:00	NQ	Futures	2231.99	2235.14	2215.95	2229.7	90811.0
2010-05-05 10:00:00	NQ	Futures	2229.98	2246.31	2226.55	2244.59	67414.0
2010-05-05 11:00:00	NQ	Futures	2244.87	2255.76	2234.57	2254.33	42130.0
2010-05-05 12:00:00	NQ	Futures	2254.33	2255.47	2237.43	2243.73	34207.0
2010-05-05 13:00:00	NQ	Futures	2243.44	2250.32	2239.43	2243.44	24516.0
2010-05-05 14:00:00	NQ	Futures	2243.44	2245.45	2228.55	2236.0	44155.0
2010-05-05 15:00:00	NQ	Futures	2236.0	2242.58	2231.13	2242.01	55681.0
2010-05-05 16:00:00	NQ	Futures	2242.01	2244.87	2240.29	2242.87	9866.0
2010-05-05 17:00:00	NQ	Futures	2242.58	2244.02	2240.87	2244.02	291.0
2010-05-05 18:00:00	NQ	Futures	2243.73	2246.59	2243.44	2246.59	404.0
2010-05-05 19:00:00	NQ	Futures	2246.31	2247.45	2244.3	2246.59	236.0
2010-05-05 20:00:00	NQ	Futures	2246.59	2248.6	2244.3	2247.45	404.0
2010-05-05 21:00:00	NQ	Futures	2247.17	2248.6	2246.31	2247.45	299.0
2010-05-05 22:00:00	NQ	Futures	2248.02	2248.31	2246.31	2248.02	192.0
2010-05-05 23:00:00	NQ	Futures	2248.02	2248.02	2245.16	2245.16	150.0
2010-05-05 00:00:00	YM	Futures	10244.4	10248.2	10237.9	10247.3	179.0
2010-05-05 01:00:00	YM	Futures	10249.2	10252.9	10244.4	10245.4	201.0

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

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