PREVIEW / futures_1hour / 2011-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-18.parquet
  size:    49 KB
  rows:    1,491

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
2011-01-18 00:00:00	ES	Futures	1273.51	1274.74	1272.76	1273.01	3895.0
2011-01-18 01:00:00	ES	Futures	1272.76	1273.26	1271.53	1273.26	5016.0
2011-01-18 02:00:00	ES	Futures	1273.26	1274.5	1272.02	1274.5	8012.0
2011-01-18 03:00:00	ES	Futures	1274.5	1276.72	1274.0	1276.48	31974.0
2011-01-18 04:00:00	ES	Futures	1276.72	1278.46	1276.48	1278.21	23655.0
2011-01-18 05:00:00	ES	Futures	1278.46	1278.7	1277.22	1278.46	15868.0
2011-01-18 06:00:00	ES	Futures	1278.46	1279.69	1278.21	1279.2	10253.0
2011-01-18 07:00:00	ES	Futures	1279.2	1279.45	1276.48	1277.22	28593.0
2011-01-18 08:00:00	ES	Futures	1277.22	1277.47	1274.0	1274.5	61218.0
2011-01-18 09:00:00	ES	Futures	1274.74	1277.22	1273.26	1274.5	244588.0
2011-01-18 10:00:00	ES	Futures	1274.5	1277.71	1273.26	1274.74	284140.0
2011-01-18 11:00:00	ES	Futures	1274.99	1277.47	1274.74	1276.48	159186.0
2011-01-18 12:00:00	ES	Futures	1276.23	1276.72	1275.49	1276.23	99517.0
2011-01-18 13:00:00	ES	Futures	1276.23	1277.96	1276.23	1277.22	108847.0
2011-01-18 14:00:00	ES	Futures	1277.22	1278.46	1276.48	1277.96	112445.0
2011-01-18 15:00:00	ES	Futures	1277.96	1279.2	1276.23	1278.46	168170.0
2011-01-18 16:00:00	ES	Futures	1278.21	1282.91	1278.21	1280.19	132433.0
2011-01-18 17:00:00	ES	Futures	1280.19	1280.68	1279.69	1280.44	7363.0
2011-01-18 18:00:00	ES	Futures	1280.19	1280.44	1279.2	1279.69	4886.0
2011-01-18 19:00:00	ES	Futures	1279.94	1280.93	1279.2	1280.68	4117.0
2011-01-18 20:00:00	ES	Futures	1280.68	1280.93	1279.94	1279.94	3232.0
2011-01-18 21:00:00	ES	Futures	1279.94	1280.68	1279.69	1280.68	1945.0
2011-01-18 22:00:00	ES	Futures	1280.68	1281.67	1280.68	1281.18	3738.0
2011-01-18 23:00:00	ES	Futures	1281.18	1281.42	1280.68	1280.93	948.0
2011-01-18 00:00:00	NQ	Futures	2639.26	2639.84	2637.25	2637.83	373.0
2011-01-18 01:00:00	NQ	Futures	2637.83	2638.69	2636.39	2638.4	419.0
2011-01-18 02:00:00	NQ	Futures	2638.4	2644.14	2636.39	2640.7	1836.0
2011-01-18 03:00:00	NQ	Futures	2640.41	2645.0	2639.26	2642.99	3808.0
2011-01-18 04:00:00	NQ	Futures	2642.71	2647.59	2642.71	2646.44	2156.0
2011-01-18 05:00:00	NQ	Futures	2646.44	2651.89	2646.15	2648.74	2821.0
2011-01-18 06:00:00	NQ	Futures	2649.02	2652.75	2648.16	2652.47	1449.0
2011-01-18 07:00:00	NQ	Futures	2652.18	2652.75	2644.72	2648.16	5116.0
2011-01-18 08:00:00	NQ	Futures	2648.45	2648.45	2641.85	2643.28	6657.0
2011-01-18 09:00:00	NQ	Futures	2643.28	2662.51	2640.7	2653.9	66697.0
2011-01-18 10:00:00	NQ	Futures	2653.9	2661.36	2651.03	2655.05	34797.0
2011-01-18 11:00:00	NQ	Futures	2655.05	2665.1	2654.48	2663.09	22122.0
2011-01-18 12:00:00	NQ	Futures	2663.09	2666.82	2659.93	2665.1	14975.0
2011-01-18 13:00:00	NQ	Futures	2665.1	2671.7	2665.1	2667.68	19738.0
2011-01-18 14:00:00	NQ	Futures	2667.68	2671.12	2665.67	2671.12	12825.0
2011-01-18 15:00:00	NQ	Futures	2671.12	2675.43	2667.39	2672.27	25189.0
2011-01-18 16:00:00	NQ	Futures	2672.56	2694.09	2671.99	2681.74	25874.0
2011-01-18 17:00:00	NQ	Futures	2681.74	2685.19	2676.29	2679.16	5283.0
2011-01-18 18:00:00	NQ	Futures	2676.86	2678.87	2676.0	2676.58	761.0
2011-01-18 19:00:00	NQ	Futures	2676.58	2680.02	2676.29	2680.02	449.0
2011-01-18 20:00:00	NQ	Futures	2680.02	2681.17	2679.45	2679.45	400.0
2011-01-18 21:00:00	NQ	Futures	2679.16	2679.45	2677.15	2678.87	479.0
2011-01-18 22:00:00	NQ	Futures	2678.87	2679.73	2678.59	2679.45	317.0
2011-01-18 23:00:00	NQ	Futures	2679.45	2680.88	2679.16	2680.31	213.0
2011-01-18 00:00:00	YM	Futures	11230.0	11234.8	11221.4	11223.3	147.0
2011-01-18 01:00:00	YM	Futures	11222.3	11226.2	11212.8	11226.2	225.0

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

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