PREVIEW / futures_1hour / 2011-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-11.parquet
  size:    48 KB
  rows:    1,479

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-11 00:00:00	ES	Futures	1254.46	1254.46	1253.47	1254.46	2547.0
2011-01-11 01:00:00	ES	Futures	1254.46	1255.44	1253.96	1254.46	3876.0
2011-01-11 02:00:00	ES	Futures	1254.46	1254.95	1253.47	1254.21	5576.0
2011-01-11 03:00:00	ES	Futures	1254.21	1255.44	1253.47	1254.7	27880.0
2011-01-11 04:00:00	ES	Futures	1254.46	1254.95	1252.72	1252.72	14209.0
2011-01-11 05:00:00	ES	Futures	1252.97	1254.95	1252.23	1254.95	13490.0
2011-01-11 06:00:00	ES	Futures	1254.95	1257.67	1254.7	1257.42	21391.0
2011-01-11 07:00:00	ES	Futures	1257.42	1259.4	1257.18	1258.17	30708.0
2011-01-11 08:00:00	ES	Futures	1257.92	1258.91	1256.93	1258.41	28077.0
2011-01-11 09:00:00	ES	Futures	1258.41	1259.9	1255.94	1255.94	233529.0
2011-01-11 10:00:00	ES	Futures	1255.94	1258.66	1255.44	1258.66	192206.0
2011-01-11 11:00:00	ES	Futures	1258.66	1260.64	1258.41	1259.4	239165.0
2011-01-11 12:00:00	ES	Futures	1259.16	1260.15	1258.41	1259.9	69245.0
2011-01-11 13:00:00	ES	Futures	1260.15	1260.39	1253.96	1254.7	282949.0
2011-01-11 14:00:00	ES	Futures	1254.7	1256.43	1252.48	1255.94	193498.0
2011-01-11 15:00:00	ES	Futures	1256.19	1258.17	1255.44	1257.67	160148.0
2011-01-11 16:00:00	ES	Futures	1257.42	1258.17	1256.43	1256.43	75358.0
2011-01-11 17:00:00	ES	Futures	1256.43	1256.68	1256.19	1256.68	1212.0
2011-01-11 18:00:00	ES	Futures	1256.43	1257.18	1256.19	1257.18	2782.0
2011-01-11 19:00:00	ES	Futures	1257.18	1257.92	1256.93	1257.67	4739.0
2011-01-11 20:00:00	ES	Futures	1257.92	1258.17	1257.42	1257.92	2095.0
2011-01-11 21:00:00	ES	Futures	1257.92	1258.66	1257.92	1258.41	2836.0
2011-01-11 22:00:00	ES	Futures	1258.17	1258.41	1257.92	1258.17	918.0
2011-01-11 23:00:00	ES	Futures	1258.41	1258.41	1257.42	1257.92	2452.0
2011-01-11 00:00:00	NQ	Futures	2624.91	2624.91	2624.05	2624.91	136.0
2011-01-11 01:00:00	NQ	Futures	2624.91	2625.49	2624.05	2624.91	172.0
2011-01-11 02:00:00	NQ	Futures	2625.2	2626.06	2623.19	2623.76	455.0
2011-01-11 03:00:00	NQ	Futures	2623.76	2626.92	2623.19	2625.77	2244.0
2011-01-11 04:00:00	NQ	Futures	2625.49	2625.77	2622.04	2622.33	1355.0
2011-01-11 05:00:00	NQ	Futures	2622.62	2627.5	2620.89	2627.21	1838.0
2011-01-11 06:00:00	NQ	Futures	2627.21	2632.09	2626.63	2632.09	2086.0
2011-01-11 07:00:00	NQ	Futures	2632.37	2635.24	2631.8	2632.66	3759.0
2011-01-11 08:00:00	NQ	Futures	2632.66	2634.38	2630.08	2633.24	4101.0
2011-01-11 09:00:00	NQ	Futures	2632.95	2634.38	2623.48	2624.05	36162.0
2011-01-11 10:00:00	NQ	Futures	2624.05	2629.5	2622.33	2628.07	27812.0
2011-01-11 11:00:00	NQ	Futures	2628.07	2630.65	2624.62	2626.06	32130.0
2011-01-11 12:00:00	NQ	Futures	2626.06	2630.37	2624.62	2629.22	10333.0
2011-01-11 13:00:00	NQ	Futures	2628.93	2629.22	2618.6	2620.03	28429.0
2011-01-11 14:00:00	NQ	Futures	2619.75	2624.62	2615.44	2623.76	21161.0
2011-01-11 15:00:00	NQ	Futures	2623.76	2627.21	2621.75	2624.91	25029.0
2011-01-11 16:00:00	NQ	Futures	2624.91	2626.63	2622.62	2622.9	8315.0
2011-01-11 17:00:00	NQ	Futures	2622.9	2623.48	2622.33	2623.48	29.0
2011-01-11 18:00:00	NQ	Futures	2624.05	2624.34	2622.9	2624.34	87.0
2011-01-11 19:00:00	NQ	Futures	2624.62	2626.92	2624.62	2626.63	173.0
2011-01-11 20:00:00	NQ	Futures	2626.35	2626.92	2625.2	2626.06	123.0
2011-01-11 21:00:00	NQ	Futures	2626.35	2628.64	2626.35	2628.07	177.0
2011-01-11 22:00:00	NQ	Futures	2627.78	2628.36	2627.21	2627.78	96.0
2011-01-11 23:00:00	NQ	Futures	2627.78	2627.78	2626.35	2627.5	135.0
2011-01-11 00:00:00	YM	Futures	11113.1	11113.1	11105.5	11110.3	125.0
2011-01-11 01:00:00	YM	Futures	11111.2	11120.8	11109.3	11112.2	360.0

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

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