PREVIEW / futures_1hour / 2010-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-05.parquet
  size:    37 KB
  rows:    1,101

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-05 00:00:00	ES	Futures	1152.71	1152.96	1151.49	1151.74	1463.0
2010-04-05 01:00:00	ES	Futures	1151.49	1152.71	1151.49	1152.47	894.0
2010-04-05 02:00:00	ES	Futures	1152.71	1152.96	1151.74	1152.47	930.0
2010-04-05 03:00:00	ES	Futures	1152.23	1152.71	1150.03	1151.25	4016.0
2010-04-05 04:00:00	ES	Futures	1151.0	1151.49	1150.27	1151.0	1213.0
2010-04-05 05:00:00	ES	Futures	1151.0	1151.25	1150.03	1150.27	1419.0
2010-04-05 06:00:00	ES	Futures	1150.51	1151.49	1149.78	1150.27	1279.0
2010-04-05 07:00:00	ES	Futures	1150.27	1152.71	1150.27	1152.23	7839.0
2010-04-05 08:00:00	ES	Futures	1151.98	1152.47	1150.51	1151.0	15805.0
2010-04-05 09:00:00	ES	Futures	1151.0	1153.69	1148.31	1153.45	168682.0
2010-04-05 10:00:00	ES	Futures	1153.2	1157.36	1151.98	1156.63	227831.0
2010-04-05 11:00:00	ES	Futures	1156.63	1157.11	1155.4	1156.87	113709.0
2010-04-05 12:00:00	ES	Futures	1156.87	1157.11	1155.89	1156.14	47690.0
2010-04-05 13:00:00	ES	Futures	1156.14	1157.11	1154.67	1155.4	74163.0
2010-04-05 14:00:00	ES	Futures	1155.65	1157.36	1154.91	1155.89	87197.0
2010-04-05 15:00:00	ES	Futures	1155.65	1156.87	1154.67	1156.63	152373.0
2010-04-05 16:00:00	ES	Futures	1156.63	1157.36	1155.89	1157.36	107893.0
2010-04-05 17:00:00	ES	Futures	1157.11	1157.36	1156.87	1157.36	841.0
2010-04-05 18:00:00	ES	Futures	1157.11	1157.36	1156.63	1156.87	1234.0
2010-04-05 19:00:00	ES	Futures	1156.87	1157.36	1156.38	1156.38	2078.0
2010-04-05 20:00:00	ES	Futures	1156.63	1156.87	1154.18	1154.18	8099.0
2010-04-05 21:00:00	ES	Futures	1154.43	1154.67	1153.69	1154.67	4994.0
2010-04-05 22:00:00	ES	Futures	1154.67	1154.91	1153.94	1154.67	2366.0
2010-04-05 23:00:00	ES	Futures	1154.67	1155.65	1154.43	1154.91	3158.0
2010-04-05 00:00:00	NQ	Futures	2249.74	2250.32	2248.02	2248.31	162.0
2010-04-05 01:00:00	NQ	Futures	2248.02	2249.46	2248.02	2248.88	70.0
2010-04-05 02:00:00	NQ	Futures	2248.88	2248.88	2247.74	2247.74	137.0
2010-04-05 03:00:00	NQ	Futures	2248.31	2248.31	2245.45	2246.31	415.0
2010-04-05 04:00:00	NQ	Futures	2246.31	2246.59	2245.45	2246.02	191.0
2010-04-05 05:00:00	NQ	Futures	2245.73	2246.31	2244.87	2245.16	156.0
2010-04-05 06:00:00	NQ	Futures	2244.59	2246.02	2244.59	2244.87	220.0
2010-04-05 07:00:00	NQ	Futures	2244.87	2248.6	2244.3	2247.74	917.0
2010-04-05 08:00:00	NQ	Futures	2247.74	2248.88	2242.01	2246.02	4533.0
2010-04-05 09:00:00	NQ	Futures	2246.02	2258.33	2239.72	2254.61	42412.0
2010-04-05 10:00:00	NQ	Futures	2254.61	2266.64	2252.32	2264.06	50040.0
2010-04-05 11:00:00	NQ	Futures	2264.06	2264.92	2260.63	2262.34	21905.0
2010-04-05 12:00:00	NQ	Futures	2262.34	2264.06	2260.63	2262.34	14316.0
2010-04-05 13:00:00	NQ	Futures	2262.34	2263.78	2258.91	2259.77	12051.0
2010-04-05 14:00:00	NQ	Futures	2259.77	2264.06	2258.62	2261.2	14508.0
2010-04-05 15:00:00	NQ	Futures	2261.2	2262.63	2258.62	2261.77	27311.0
2010-04-05 16:00:00	NQ	Futures	2261.48	2261.77	2259.19	2261.48	9897.0
2010-04-05 17:00:00	NQ	Futures	2261.48	2262.63	2261.2	2261.48	68.0
2010-04-05 18:00:00	NQ	Futures	2261.48	2261.77	2260.34	2261.2	188.0
2010-04-05 19:00:00	NQ	Futures	2261.48	2262.34	2260.63	2260.91	209.0
2010-04-05 20:00:00	NQ	Futures	2260.91	2260.91	2256.9	2258.05	473.0
2010-04-05 21:00:00	NQ	Futures	2258.05	2258.33	2256.9	2257.19	231.0
2010-04-05 22:00:00	NQ	Futures	2257.19	2257.48	2256.04	2257.19	285.0
2010-04-05 23:00:00	NQ	Futures	2257.19	2258.05	2256.9	2257.48	328.0
2010-04-05 00:00:00	YM	Futures	10260.4	10261.4	10252.9	10254.8	73.0
2010-04-05 01:00:00	YM	Futures	10254.8	10262.3	10253.9	10260.4	173.0

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

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