PREVIEW / futures_1hour / 2010-04-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1149.54	1150.27	1149.05	1150.27	3397.0
2010-04-08 01:00:00	ES	Futures	1150.27	1151.0	1149.78	1150.27	1720.0
2010-04-08 02:00:00	ES	Futures	1150.51	1150.51	1148.8	1149.54	6590.0
2010-04-08 03:00:00	ES	Futures	1149.78	1150.51	1147.83	1147.83	26868.0
2010-04-08 04:00:00	ES	Futures	1147.83	1148.31	1146.36	1148.07	25304.0
2010-04-08 05:00:00	ES	Futures	1148.07	1148.8	1146.36	1147.58	19750.0
2010-04-08 06:00:00	ES	Futures	1147.58	1149.54	1147.09	1149.05	14295.0
2010-04-08 07:00:00	ES	Futures	1149.05	1149.29	1146.36	1146.6	29374.0
2010-04-08 08:00:00	ES	Futures	1146.85	1149.29	1145.87	1149.05	80828.0
2010-04-08 09:00:00	ES	Futures	1148.8	1149.29	1144.89	1146.36	265922.0
2010-04-08 10:00:00	ES	Futures	1146.11	1150.27	1145.38	1149.05	283118.0
2010-04-08 11:00:00	ES	Futures	1149.05	1152.47	1148.8	1152.23	203757.0
2010-04-08 12:00:00	ES	Futures	1152.23	1155.4	1151.74	1155.4	237496.0
2010-04-08 13:00:00	ES	Futures	1155.16	1157.11	1154.91	1155.4	208230.0
2010-04-08 14:00:00	ES	Futures	1155.65	1158.58	1155.16	1157.6	160462.0
2010-04-08 15:00:00	ES	Futures	1157.6	1158.58	1156.14	1156.63	223823.0
2010-04-08 16:00:00	ES	Futures	1156.38	1157.85	1156.14	1157.6	88245.0
2010-04-08 17:00:00	ES	Futures	1157.6	1157.85	1157.36	1157.6	678.0
2010-04-08 18:00:00	ES	Futures	1157.36	1158.09	1156.87	1157.6	5020.0
2010-04-08 19:00:00	ES	Futures	1157.6	1158.09	1157.36	1157.6	2778.0
2010-04-08 20:00:00	ES	Futures	1157.6	1158.09	1157.11	1157.11	3304.0
2010-04-08 21:00:00	ES	Futures	1157.11	1157.6	1156.63	1157.11	3959.0
2010-04-08 22:00:00	ES	Futures	1157.36	1157.36	1156.63	1156.63	1557.0
2010-04-08 23:00:00	ES	Futures	1156.87	1157.6	1156.63	1157.36	2158.0
2010-04-08 00:00:00	NQ	Futures	2258.62	2258.91	2258.05	2258.91	211.0
2010-04-08 01:00:00	NQ	Futures	2258.91	2261.2	2258.62	2260.34	252.0
2010-04-08 02:00:00	NQ	Futures	2260.34	2260.63	2257.48	2258.05	524.0
2010-04-08 03:00:00	NQ	Futures	2258.62	2260.05	2254.9	2255.18	1639.0
2010-04-08 04:00:00	NQ	Futures	2254.9	2256.33	2253.18	2256.04	1119.0
2010-04-08 05:00:00	NQ	Futures	2255.76	2256.62	2253.47	2254.61	1028.0
2010-04-08 06:00:00	NQ	Futures	2254.9	2257.76	2254.04	2257.19	764.0
2010-04-08 07:00:00	NQ	Futures	2257.19	2257.76	2253.75	2254.61	1969.0
2010-04-08 08:00:00	NQ	Futures	2254.9	2258.91	2253.18	2256.9	6734.0
2010-04-08 09:00:00	NQ	Futures	2256.9	2257.76	2244.3	2246.59	39903.0
2010-04-08 10:00:00	NQ	Futures	2246.59	2256.62	2245.16	2252.61	38454.0
2010-04-08 11:00:00	NQ	Futures	2252.89	2259.48	2252.03	2258.62	22570.0
2010-04-08 12:00:00	NQ	Futures	2258.33	2268.93	2257.19	2268.93	35690.0
2010-04-08 13:00:00	NQ	Futures	2268.93	2270.93	2264.35	2265.78	29186.0
2010-04-08 14:00:00	NQ	Futures	2265.78	2270.93	2264.35	2268.64	16365.0
2010-04-08 15:00:00	NQ	Futures	2268.64	2270.08	2264.63	2266.35	26331.0
2010-04-08 16:00:00	NQ	Futures	2266.35	2268.36	2266.07	2267.21	7980.0
2010-04-08 17:00:00	NQ	Futures	2266.93	2268.07	2266.64	2267.21	137.0
2010-04-08 18:00:00	NQ	Futures	2267.21	2268.36	2266.35	2267.78	240.0
2010-04-08 19:00:00	NQ	Futures	2267.78	2268.93	2267.78	2267.78	76.0
2010-04-08 20:00:00	NQ	Futures	2268.07	2268.36	2266.93	2266.93	173.0
2010-04-08 21:00:00	NQ	Futures	2266.93	2267.21	2266.07	2266.64	151.0
2010-04-08 22:00:00	NQ	Futures	2266.93	2266.93	2265.49	2266.07	306.0
2010-04-08 23:00:00	NQ	Futures	2266.35	2267.5	2266.35	2267.21	250.0
2010-04-08 00:00:00	YM	Futures	10185.2	10187.0	10173.9	10185.2	739.0
2010-04-08 01:00:00	YM	Futures	10185.2	10193.6	10184.2	10191.8	133.0

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

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