PREVIEW / futures_1hour / 2010-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-07.parquet
  size:    46 KB
  rows:    1,389

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-07 00:00:00	ES	Futures	1157.36	1157.6	1156.87	1157.6	1796.0
2010-04-07 01:00:00	ES	Futures	1157.36	1157.6	1156.63	1156.87	3323.0
2010-04-07 02:00:00	ES	Futures	1156.87	1157.6	1156.63	1156.87	4954.0
2010-04-07 03:00:00	ES	Futures	1157.11	1157.36	1155.4	1156.38	16769.0
2010-04-07 04:00:00	ES	Futures	1156.38	1156.63	1155.16	1155.65	10753.0
2010-04-07 05:00:00	ES	Futures	1155.89	1157.6	1155.4	1157.11	7906.0
2010-04-07 06:00:00	ES	Futures	1157.11	1157.6	1156.14	1156.38	7239.0
2010-04-07 07:00:00	ES	Futures	1156.38	1156.63	1155.16	1155.4	20371.0
2010-04-07 08:00:00	ES	Futures	1155.4	1155.89	1153.69	1155.89	57290.0
2010-04-07 09:00:00	ES	Futures	1155.89	1158.58	1155.16	1157.11	189223.0
2010-04-07 10:00:00	ES	Futures	1157.11	1158.34	1152.71	1154.18	305783.0
2010-04-07 11:00:00	ES	Futures	1153.94	1157.11	1152.47	1156.38	242198.0
2010-04-07 12:00:00	ES	Futures	1156.14	1156.87	1155.16	1156.87	80243.0
2010-04-07 13:00:00	ES	Futures	1156.87	1159.8	1156.63	1157.85	194542.0
2010-04-07 14:00:00	ES	Futures	1158.09	1158.09	1152.23	1153.2	294256.0
2010-04-07 15:00:00	ES	Futures	1153.2	1153.2	1147.09	1152.96	571299.0
2010-04-07 16:00:00	ES	Futures	1152.96	1153.2	1151.74	1152.47	115238.0
2010-04-07 17:00:00	ES	Futures	1152.47	1152.96	1151.74	1151.74	2006.0
2010-04-07 18:00:00	ES	Futures	1152.23	1152.71	1151.74	1151.74	2021.0
2010-04-07 19:00:00	ES	Futures	1151.74	1151.74	1150.76	1151.0	3629.0
2010-04-07 20:00:00	ES	Futures	1151.0	1151.25	1150.27	1150.76	3617.0
2010-04-07 21:00:00	ES	Futures	1150.51	1151.0	1149.78	1150.03	3660.0
2010-04-07 22:00:00	ES	Futures	1150.03	1151.25	1149.78	1151.0	3730.0
2010-04-07 23:00:00	ES	Futures	1150.76	1151.0	1149.54	1149.54	2406.0
2010-04-07 00:00:00	NQ	Futures	2263.78	2264.06	2262.92	2264.06	81.0
2010-04-07 01:00:00	NQ	Futures	2264.06	2264.06	2262.92	2262.92	206.0
2010-04-07 02:00:00	NQ	Futures	2262.92	2264.35	2262.63	2262.92	398.0
2010-04-07 03:00:00	NQ	Futures	2263.2	2264.06	2260.91	2262.34	1035.0
2010-04-07 04:00:00	NQ	Futures	2262.06	2262.06	2260.63	2260.91	560.0
2010-04-07 05:00:00	NQ	Futures	2260.91	2264.63	2260.63	2264.06	498.0
2010-04-07 06:00:00	NQ	Futures	2264.06	2264.06	2262.34	2262.34	218.0
2010-04-07 07:00:00	NQ	Futures	2262.34	2262.63	2260.63	2261.77	817.0
2010-04-07 08:00:00	NQ	Futures	2261.77	2262.63	2259.19	2262.34	3279.0
2010-04-07 09:00:00	NQ	Futures	2262.63	2268.64	2260.63	2264.92	29144.0
2010-04-07 10:00:00	NQ	Futures	2264.63	2270.65	2260.63	2264.06	40802.0
2010-04-07 11:00:00	NQ	Futures	2264.06	2269.5	2260.91	2268.07	29381.0
2010-04-07 12:00:00	NQ	Futures	2268.36	2269.79	2266.07	2269.5	13753.0
2010-04-07 13:00:00	NQ	Futures	2269.5	2273.23	2267.5	2270.36	25031.0
2010-04-07 14:00:00	NQ	Futures	2270.36	2270.93	2260.63	2262.06	35096.0
2010-04-07 15:00:00	NQ	Futures	2262.06	2262.92	2250.03	2262.63	69052.0
2010-04-07 16:00:00	NQ	Futures	2262.63	2263.78	2261.2	2262.06	8380.0
2010-04-07 17:00:00	NQ	Futures	2262.34	2262.92	2261.48	2262.06	104.0
2010-04-07 18:00:00	NQ	Futures	2262.06	2262.63	2261.48	2261.77	113.0
2010-04-07 19:00:00	NQ	Futures	2261.48	2261.77	2260.05	2260.91	231.0
2010-04-07 20:00:00	NQ	Futures	2260.63	2261.2	2259.48	2260.05	202.0
2010-04-07 21:00:00	NQ	Futures	2260.05	2260.63	2258.91	2259.19	213.0
2010-04-07 22:00:00	NQ	Futures	2259.19	2260.91	2258.91	2260.34	191.0
2010-04-07 23:00:00	NQ	Futures	2260.34	2260.63	2258.33	2258.33	120.0
2010-04-07 00:00:00	YM	Futures	10259.5	10261.4	10256.7	10259.5	196.0
2010-04-07 01:00:00	YM	Futures	10258.6	10259.5	10254.8	10257.6	191.0

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

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