PREVIEW / futures_1hour / 2010-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-06.parquet
  size:    45 KB
  rows:    1,394

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-06 00:00:00	ES	Futures	1155.16	1155.16	1154.18	1154.43	2498.0
2010-04-06 01:00:00	ES	Futures	1154.43	1155.16	1153.45	1155.16	5390.0
2010-04-06 02:00:00	ES	Futures	1154.91	1155.4	1152.23	1153.94	16288.0
2010-04-06 03:00:00	ES	Futures	1153.69	1153.94	1151.98	1153.69	15362.0
2010-04-06 04:00:00	ES	Futures	1153.45	1155.4	1153.45	1154.43	9501.0
2010-04-06 05:00:00	ES	Futures	1154.18	1154.67	1153.45	1153.69	6086.0
2010-04-06 06:00:00	ES	Futures	1153.69	1154.91	1153.45	1154.43	6653.0
2010-04-06 07:00:00	ES	Futures	1154.43	1154.91	1153.69	1154.43	12225.0
2010-04-06 08:00:00	ES	Futures	1154.18	1154.43	1151.25	1151.49	56214.0
2010-04-06 09:00:00	ES	Futures	1151.49	1154.91	1151.0	1154.43	189771.0
2010-04-06 10:00:00	ES	Futures	1154.43	1156.38	1153.2	1155.89	204814.0
2010-04-06 11:00:00	ES	Futures	1156.14	1158.09	1155.4	1156.87	198530.0
2010-04-06 12:00:00	ES	Futures	1156.63	1157.6	1155.89	1157.11	73503.0
2010-04-06 13:00:00	ES	Futures	1157.11	1158.09	1156.38	1157.11	72137.0
2010-04-06 14:00:00	ES	Futures	1157.11	1161.51	1156.87	1160.29	226293.0
2010-04-06 15:00:00	ES	Futures	1160.54	1160.78	1158.09	1158.82	192700.0
2010-04-06 16:00:00	ES	Futures	1159.07	1159.8	1158.58	1158.58	84116.0
2010-04-06 17:00:00	ES	Futures	1158.58	1159.07	1158.09	1158.58	3985.0
2010-04-06 18:00:00	ES	Futures	1158.58	1158.82	1158.09	1158.58	2274.0
2010-04-06 19:00:00	ES	Futures	1158.58	1158.58	1157.36	1157.85	5309.0
2010-04-06 20:00:00	ES	Futures	1157.85	1157.85	1157.11	1157.36	2951.0
2010-04-06 21:00:00	ES	Futures	1157.36	1157.85	1156.87	1157.36	2830.0
2010-04-06 22:00:00	ES	Futures	1157.36	1158.58	1157.36	1158.34	3171.0
2010-04-06 23:00:00	ES	Futures	1158.34	1158.34	1157.11	1157.36	2556.0
2010-04-06 00:00:00	NQ	Futures	2257.48	2257.76	2256.62	2257.19	102.0
2010-04-06 01:00:00	NQ	Futures	2257.19	2257.76	2256.04	2257.48	207.0
2010-04-06 02:00:00	NQ	Futures	2257.76	2258.05	2253.18	2255.76	1081.0
2010-04-06 03:00:00	NQ	Futures	2255.76	2256.04	2252.32	2255.18	1528.0
2010-04-06 04:00:00	NQ	Futures	2255.47	2258.62	2255.18	2256.9	830.0
2010-04-06 05:00:00	NQ	Futures	2256.62	2257.19	2254.9	2256.33	740.0
2010-04-06 06:00:00	NQ	Futures	2256.33	2257.19	2255.47	2256.62	363.0
2010-04-06 07:00:00	NQ	Futures	2256.9	2257.19	2255.76	2256.04	863.0
2010-04-06 08:00:00	NQ	Futures	2255.76	2256.04	2251.46	2253.18	3462.0
2010-04-06 09:00:00	NQ	Futures	2253.18	2258.05	2251.17	2255.76	31531.0
2010-04-06 10:00:00	NQ	Futures	2255.76	2259.77	2253.18	2257.19	26497.0
2010-04-06 11:00:00	NQ	Futures	2256.9	2262.34	2255.47	2261.77	24406.0
2010-04-06 12:00:00	NQ	Futures	2261.77	2263.2	2260.05	2262.63	14193.0
2010-04-06 13:00:00	NQ	Futures	2262.63	2264.92	2261.77	2263.2	13298.0
2010-04-06 14:00:00	NQ	Futures	2263.49	2274.66	2262.92	2271.79	39393.0
2010-04-06 15:00:00	NQ	Futures	2271.79	2272.37	2266.07	2267.21	21811.0
2010-04-06 16:00:00	NQ	Futures	2267.5	2269.79	2265.49	2265.78	8432.0
2010-04-06 17:00:00	NQ	Futures	2265.78	2266.07	2264.06	2265.21	294.0
2010-04-06 18:00:00	NQ	Futures	2265.21	2266.07	2264.06	2264.63	206.0
2010-04-06 19:00:00	NQ	Futures	2264.35	2264.92	2262.63	2264.06	352.0
2010-04-06 20:00:00	NQ	Futures	2263.78	2264.06	2262.63	2262.92	118.0
2010-04-06 21:00:00	NQ	Futures	2262.92	2263.78	2262.34	2263.78	142.0
2010-04-06 22:00:00	NQ	Futures	2263.78	2265.21	2263.49	2264.92	95.0
2010-04-06 23:00:00	NQ	Futures	2264.35	2264.35	2263.2	2263.78	129.0
2010-04-06 00:00:00	YM	Futures	10253.9	10256.7	10250.1	10252.9	212.0
2010-04-06 01:00:00	YM	Futures	10252.0	10256.7	10247.3	10256.7	368.0

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

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