PREVIEW / futures_1hour / 2011-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-18.parquet
  size:    39 KB
  rows:    1,155

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-02-18 00:00:00	ES	Futures	1324.97	1325.47	1324.48	1324.48	1986.0
2011-02-18 01:00:00	ES	Futures	1324.48	1324.97	1323.73	1324.23	3956.0
2011-02-18 02:00:00	ES	Futures	1324.48	1325.47	1323.49	1325.47	8453.0
2011-02-18 03:00:00	ES	Futures	1325.22	1325.47	1323.73	1323.73	16415.0
2011-02-18 04:00:00	ES	Futures	1323.98	1324.23	1322.25	1322.75	12088.0
2011-02-18 05:00:00	ES	Futures	1322.75	1322.75	1321.26	1322.25	20630.0
2011-02-18 06:00:00	ES	Futures	1322.25	1322.99	1322.0	1322.99	6306.0
2011-02-18 07:00:00	ES	Futures	1322.75	1324.23	1322.5	1323.98	16495.0
2011-02-18 08:00:00	ES	Futures	1323.98	1324.97	1323.49	1324.72	24572.0
2011-02-18 09:00:00	ES	Futures	1324.72	1325.96	1323.24	1324.97	227023.0
2011-02-18 10:00:00	ES	Futures	1324.97	1326.46	1323.98	1324.97	202362.0
2011-02-18 11:00:00	ES	Futures	1324.97	1328.44	1324.72	1327.69	203964.0
2011-02-18 12:00:00	ES	Futures	1327.69	1328.93	1327.2	1328.19	113426.0
2011-02-18 13:00:00	ES	Futures	1327.94	1328.19	1324.23	1326.46	174635.0
2011-02-18 14:00:00	ES	Futures	1326.21	1326.46	1322.5	1325.47	143214.0
2011-02-18 15:00:00	ES	Futures	1325.47	1327.69	1323.49	1327.69	202245.0
2011-02-18 16:00:00	ES	Futures	1327.45	1329.18	1326.7	1329.18	109375.0
2011-02-18 00:00:00	NQ	Futures	2750.34	2750.63	2748.91	2749.2	220.0
2011-02-18 01:00:00	NQ	Futures	2749.2	2750.92	2748.05	2748.62	416.0
2011-02-18 02:00:00	NQ	Futures	2748.91	2752.35	2748.34	2751.78	734.0
2011-02-18 03:00:00	NQ	Futures	2752.07	2752.35	2748.91	2750.06	1124.0
2011-02-18 04:00:00	NQ	Futures	2749.77	2751.49	2748.05	2749.2	1184.0
2011-02-18 05:00:00	NQ	Futures	2748.91	2748.91	2744.03	2744.89	2220.0
2011-02-18 06:00:00	NQ	Futures	2744.89	2745.75	2743.74	2745.47	1279.0
2011-02-18 07:00:00	NQ	Futures	2745.18	2749.48	2745.18	2749.2	1349.0
2011-02-18 08:00:00	NQ	Futures	2748.91	2751.49	2748.34	2751.49	2371.0
2011-02-18 09:00:00	NQ	Futures	2751.21	2754.36	2747.19	2751.78	27473.0
2011-02-18 10:00:00	NQ	Futures	2751.49	2752.93	2745.47	2746.61	22892.0
2011-02-18 11:00:00	NQ	Futures	2746.33	2756.09	2745.47	2753.22	24338.0
2011-02-18 12:00:00	NQ	Futures	2753.5	2755.8	2750.63	2752.35	11048.0
2011-02-18 13:00:00	NQ	Futures	2752.35	2752.93	2738.86	2746.33	25376.0
2011-02-18 14:00:00	NQ	Futures	2746.33	2746.61	2734.85	2743.17	21639.0
2011-02-18 15:00:00	NQ	Futures	2743.46	2746.33	2737.43	2746.04	26655.0
2011-02-18 16:00:00	NQ	Futures	2746.33	2750.34	2745.18	2750.34	11397.0
2011-02-18 00:00:00	YM	Futures	11777.8	11780.7	11775.9	11775.9	79.0
2011-02-18 01:00:00	YM	Futures	11775.9	11783.6	11769.2	11776.9	401.0
2011-02-18 02:00:00	YM	Futures	11776.9	11782.6	11769.2	11782.6	555.0
2011-02-18 03:00:00	YM	Futures	11781.7	11784.6	11770.2	11771.1	1034.0
2011-02-18 04:00:00	YM	Futures	11771.1	11773.1	11760.6	11762.5	535.0
2011-02-18 05:00:00	YM	Futures	11761.6	11766.4	11753.9	11761.6	1204.0
2011-02-18 06:00:00	YM	Futures	11761.6	11765.4	11759.7	11763.5	356.0
2011-02-18 07:00:00	YM	Futures	11763.5	11776.9	11763.5	11774.0	855.0
2011-02-18 08:00:00	YM	Futures	11774.0	11778.8	11769.2	11775.9	1442.0
2011-02-18 09:00:00	YM	Futures	11775.9	11797.0	11771.1	11795.1	10442.0
2011-02-18 10:00:00	YM	Futures	11795.1	11805.6	11785.5	11798.0	12539.0
2011-02-18 11:00:00	YM	Futures	11798.0	11821.9	11796.0	11819.0	9961.0
2011-02-18 12:00:00	YM	Futures	11819.0	11833.4	11818.1	11828.6	7511.0
2011-02-18 13:00:00	YM	Futures	11828.6	11831.5	11813.3	11824.8	7471.0
2011-02-18 14:00:00	YM	Futures	11824.8	11831.5	11805.6	11829.6	7923.0
2011-02-18 15:00:00	YM	Futures	11829.6	11849.7	11817.1	11848.7	11530.0

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

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