PREVIEW / futures_1hour / 2010-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-13.parquet
  size:    46 KB
  rows:    1,366

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-13 00:00:00	ES	Futures	1143.43	1145.63	1143.18	1143.43	8860.0
2010-05-13 01:00:00	ES	Futures	1143.67	1145.38	1142.2	1145.38	6301.0
2010-05-13 02:00:00	ES	Futures	1145.14	1148.56	1144.89	1147.58	16713.0
2010-05-13 03:00:00	ES	Futures	1147.83	1148.07	1144.16	1146.11	32424.0
2010-05-13 04:00:00	ES	Futures	1145.87	1147.34	1140.25	1140.49	29264.0
2010-05-13 05:00:00	ES	Futures	1140.49	1142.45	1139.27	1140.74	22705.0
2010-05-13 06:00:00	ES	Futures	1140.98	1143.43	1140.25	1143.18	16005.0
2010-05-13 07:00:00	ES	Futures	1143.18	1146.11	1142.45	1144.65	20099.0
2010-05-13 08:00:00	ES	Futures	1144.4	1146.85	1141.23	1141.23	60595.0
2010-05-13 09:00:00	ES	Futures	1141.23	1142.94	1135.85	1140.0	280256.0
2010-05-13 10:00:00	ES	Futures	1139.76	1145.87	1138.54	1142.2	269595.0
2010-05-13 11:00:00	ES	Futures	1141.96	1143.43	1137.56	1138.29	208685.0
2010-05-13 12:00:00	ES	Futures	1138.05	1141.47	1137.56	1139.76	119705.0
2010-05-13 13:00:00	ES	Futures	1139.76	1143.67	1138.78	1141.47	136286.0
2010-05-13 14:00:00	ES	Futures	1141.72	1143.67	1136.83	1137.56	135382.0
2010-05-13 15:00:00	ES	Futures	1137.8	1139.03	1128.03	1129.25	474569.0
2010-05-13 16:00:00	ES	Futures	1129.0	1131.45	1129.0	1129.49	101089.0
2010-05-13 17:00:00	ES	Futures	1129.74	1130.47	1129.25	1129.74	4512.0
2010-05-13 18:00:00	ES	Futures	1129.74	1130.96	1129.25	1129.74	8077.0
2010-05-13 19:00:00	ES	Futures	1129.74	1129.74	1129.0	1129.49	4321.0
2010-05-13 20:00:00	ES	Futures	1129.49	1129.74	1128.27	1128.76	5664.0
2010-05-13 21:00:00	ES	Futures	1128.76	1130.47	1128.27	1129.98	3542.0
2010-05-13 22:00:00	ES	Futures	1129.98	1131.94	1129.49	1129.98	4034.0
2010-05-13 23:00:00	ES	Futures	1129.98	1131.45	1129.98	1130.96	1516.0
2010-05-13 00:00:00	NQ	Futures	2255.76	2260.34	2255.18	2256.9	432.0
2010-05-13 01:00:00	NQ	Futures	2256.33	2259.48	2254.33	2259.48	286.0
2010-05-13 02:00:00	NQ	Futures	2259.77	2266.07	2259.77	2265.49	1656.0
2010-05-13 03:00:00	NQ	Futures	2265.49	2266.93	2258.91	2261.77	2380.0
2010-05-13 04:00:00	NQ	Futures	2262.06	2264.06	2251.75	2252.03	2484.0
2010-05-13 05:00:00	NQ	Futures	2252.03	2255.47	2250.03	2253.18	1762.0
2010-05-13 06:00:00	NQ	Futures	2253.18	2258.05	2252.03	2256.04	1058.0
2010-05-13 07:00:00	NQ	Futures	2256.04	2263.49	2254.9	2260.34	1889.0
2010-05-13 08:00:00	NQ	Futures	2260.05	2264.35	2252.61	2253.18	7321.0
2010-05-13 09:00:00	NQ	Futures	2253.47	2266.35	2247.74	2261.77	51641.0
2010-05-13 10:00:00	NQ	Futures	2261.77	2269.79	2257.48	2261.2	45260.0
2010-05-13 11:00:00	NQ	Futures	2261.2	2263.78	2246.31	2247.45	35646.0
2010-05-13 12:00:00	NQ	Futures	2247.45	2251.75	2245.16	2248.6	28509.0
2010-05-13 13:00:00	NQ	Futures	2248.88	2257.19	2246.59	2250.32	27422.0
2010-05-13 14:00:00	NQ	Futures	2250.03	2255.47	2242.3	2244.3	23826.0
2010-05-13 15:00:00	NQ	Futures	2244.3	2247.45	2220.53	2225.12	79831.0
2010-05-13 16:00:00	NQ	Futures	2225.12	2230.56	2225.12	2227.41	14585.0
2010-05-13 17:00:00	NQ	Futures	2226.55	2227.41	2225.97	2225.97	117.0
2010-05-13 18:00:00	NQ	Futures	2227.12	2227.98	2224.83	2226.26	476.0
2010-05-13 19:00:00	NQ	Futures	2226.55	2226.55	2224.54	2226.26	111.0
2010-05-13 20:00:00	NQ	Futures	2225.97	2225.97	2223.68	2225.69	372.0
2010-05-13 21:00:00	NQ	Futures	2225.69	2229.12	2225.12	2228.55	245.0
2010-05-13 22:00:00	NQ	Futures	2227.98	2231.13	2227.69	2228.55	279.0
2010-05-13 23:00:00	NQ	Futures	2228.27	2231.13	2228.27	2229.7	139.0
2010-05-13 00:00:00	YM	Futures	10232.2	10247.3	10229.4	10236.0	543.0
2010-05-13 01:00:00	YM	Futures	10234.1	10247.3	10225.6	10246.3	382.0

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

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