PREVIEW / futures_1hour / 2010-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-09.parquet
  size:    38 KB
  rows:    1,120

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-04-09 00:00:00	ES	Futures	1157.36	1157.6	1156.87	1156.87	1117.0
2010-04-09 01:00:00	ES	Futures	1157.11	1157.6	1156.87	1157.11	889.0
2010-04-09 02:00:00	ES	Futures	1157.36	1158.09	1156.87	1157.85	5729.0
2010-04-09 03:00:00	ES	Futures	1158.09	1160.78	1158.09	1160.05	25826.0
2010-04-09 04:00:00	ES	Futures	1159.8	1160.54	1159.8	1159.8	8341.0
2010-04-09 05:00:00	ES	Futures	1159.8	1160.05	1158.58	1159.07	8430.0
2010-04-09 06:00:00	ES	Futures	1159.07	1160.05	1158.82	1160.05	7525.0
2010-04-09 07:00:00	ES	Futures	1160.05	1160.78	1159.56	1159.8	17882.0
2010-04-09 08:00:00	ES	Futures	1159.8	1160.29	1159.31	1159.31	23575.0
2010-04-09 09:00:00	ES	Futures	1159.31	1160.29	1156.87	1160.05	241992.0
2010-04-09 10:00:00	ES	Futures	1160.29	1161.76	1156.63	1158.58	317554.0
2010-04-09 11:00:00	ES	Futures	1158.82	1162.25	1158.34	1161.27	181922.0
2010-04-09 12:00:00	ES	Futures	1161.51	1162.25	1160.29	1160.78	60684.0
2010-04-09 13:00:00	ES	Futures	1160.54	1161.27	1158.82	1159.56	94486.0
2010-04-09 14:00:00	ES	Futures	1159.56	1161.51	1158.58	1160.78	90034.0
2010-04-09 15:00:00	ES	Futures	1161.02	1164.69	1160.05	1164.2	223055.0
2010-04-09 16:00:00	ES	Futures	1164.2	1166.4	1163.96	1166.4	114997.0
2010-04-09 00:00:00	NQ	Futures	2267.21	2267.21	2266.64	2266.93	50.0
2010-04-09 01:00:00	NQ	Futures	2266.93	2267.78	2266.64	2267.21	143.0
2010-04-09 02:00:00	NQ	Futures	2266.93	2268.36	2266.35	2267.78	308.0
2010-04-09 03:00:00	NQ	Futures	2268.07	2274.66	2267.78	2273.51	2309.0
2010-04-09 04:00:00	NQ	Futures	2273.23	2274.37	2273.23	2273.51	525.0
2010-04-09 05:00:00	NQ	Futures	2273.23	2273.23	2270.65	2271.51	419.0
2010-04-09 06:00:00	NQ	Futures	2271.79	2272.65	2271.22	2272.65	360.0
2010-04-09 07:00:00	NQ	Futures	2272.65	2273.51	2272.08	2272.08	775.0
2010-04-09 08:00:00	NQ	Futures	2272.37	2272.94	2271.22	2271.79	1041.0
2010-04-09 09:00:00	NQ	Futures	2271.51	2271.51	2262.34	2268.64	31885.0
2010-04-09 10:00:00	NQ	Futures	2268.64	2272.37	2264.92	2268.93	41245.0
2010-04-09 11:00:00	NQ	Futures	2268.93	2274.66	2268.64	2272.94	24768.0
2010-04-09 12:00:00	NQ	Futures	2272.94	2274.66	2272.08	2272.94	11069.0
2010-04-09 13:00:00	NQ	Futures	2272.94	2274.94	2270.36	2271.22	18799.0
2010-04-09 14:00:00	NQ	Futures	2271.22	2275.8	2269.5	2274.94	16157.0
2010-04-09 15:00:00	NQ	Futures	2274.66	2281.53	2273.23	2280.67	29844.0
2010-04-09 16:00:00	NQ	Futures	2280.67	2282.68	2279.81	2282.39	8919.0
2010-04-09 00:00:00	YM	Futures	10242.6	10243.5	10234.1	10237.9	335.0
2010-04-09 01:00:00	YM	Futures	10237.9	10242.6	10237.9	10241.6	101.0
2010-04-09 02:00:00	YM	Futures	10241.6	10247.3	10238.8	10245.4	222.0
2010-04-09 03:00:00	YM	Futures	10246.3	10274.6	10246.3	10265.1	2000.0
2010-04-09 04:00:00	YM	Futures	10264.2	10268.9	10263.3	10263.3	334.0
2010-04-09 05:00:00	YM	Futures	10263.3	10264.2	10252.0	10253.9	487.0
2010-04-09 06:00:00	YM	Futures	10253.9	10263.3	10252.9	10262.3	381.0
2010-04-09 07:00:00	YM	Futures	10264.2	10268.0	10261.4	10262.3	690.0
2010-04-09 08:00:00	YM	Futures	10262.3	10263.3	10258.6	10258.6	734.0
2010-04-09 09:00:00	YM	Futures	10257.6	10263.3	10238.8	10262.3	14268.0
2010-04-09 10:00:00	YM	Futures	10263.3	10279.3	10237.9	10257.6	23053.0
2010-04-09 11:00:00	YM	Futures	10256.7	10288.7	10255.7	10277.4	14291.0
2010-04-09 12:00:00	YM	Futures	10277.4	10284.9	10268.0	10270.8	4720.0
2010-04-09 13:00:00	YM	Futures	10270.8	10273.6	10254.8	10258.6	6731.0
2010-04-09 14:00:00	YM	Futures	10258.6	10275.5	10249.2	10268.0	6670.0
2010-04-09 15:00:00	YM	Futures	10268.0	10300.9	10259.5	10298.1	11893.0

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

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