PREVIEW / futures_1hour / 2011-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-14.parquet
  size:    49 KB
  rows:    1,448

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-03-14 00:00:00	ES	Futures	1286.37	1288.61	1285.13	1288.11	3785.0
2011-03-14 01:00:00	ES	Futures	1288.11	1289.85	1285.13	1288.11	5568.0
2011-03-14 02:00:00	ES	Futures	1288.11	1289.6	1286.87	1287.86	7675.0
2011-03-14 03:00:00	ES	Futures	1287.86	1289.11	1283.14	1286.12	28632.0
2011-03-14 04:00:00	ES	Futures	1286.37	1287.62	1280.91	1285.63	33890.0
2011-03-14 05:00:00	ES	Futures	1285.63	1289.85	1283.89	1287.86	23874.0
2011-03-14 06:00:00	ES	Futures	1288.11	1290.6	1286.62	1288.11	22985.0
2011-03-14 07:00:00	ES	Futures	1287.86	1288.61	1282.65	1283.64	34898.0
2011-03-14 08:00:00	ES	Futures	1283.89	1285.63	1282.15	1284.39	43690.0
2011-03-14 09:00:00	ES	Futures	1284.63	1286.87	1281.4	1285.38	268056.0
2011-03-14 10:00:00	ES	Futures	1285.13	1287.12	1278.18	1278.67	373902.0
2011-03-14 11:00:00	ES	Futures	1278.67	1280.66	1273.45	1275.44	343464.0
2011-03-14 12:00:00	ES	Futures	1275.44	1276.68	1272.96	1276.19	180298.0
2011-03-14 13:00:00	ES	Futures	1275.94	1278.67	1274.95	1277.18	145541.0
2011-03-14 14:00:00	ES	Futures	1276.93	1281.65	1276.93	1277.68	203935.0
2011-03-14 15:00:00	ES	Futures	1277.68	1285.38	1277.18	1283.39	425591.0
2011-03-14 16:00:00	ES	Futures	1283.14	1283.64	1281.4	1283.14	97403.0
2011-03-14 17:00:00	ES	Futures	1283.14	1283.39	1282.9	1282.9	1669.0
2011-03-14 18:00:00	ES	Futures	1283.14	1285.13	1282.9	1283.39	4655.0
2011-03-14 19:00:00	ES	Futures	1283.14	1284.39	1275.44	1277.68	21713.0
2011-03-14 20:00:00	ES	Futures	1277.93	1280.91	1272.96	1275.69	23330.0
2011-03-14 21:00:00	ES	Futures	1275.69	1277.68	1271.96	1274.45	20238.0
2011-03-14 22:00:00	ES	Futures	1274.45	1274.45	1259.05	1261.28	74486.0
2011-03-14 23:00:00	ES	Futures	1261.28	1265.51	1252.34	1253.08	73501.0
2011-03-14 00:00:00	NQ	Futures	2628.64	2634.1	2626.34	2633.81	346.0
2011-03-14 01:00:00	NQ	Futures	2633.81	2635.25	2626.06	2630.94	807.0
2011-03-14 02:00:00	NQ	Futures	2630.65	2633.53	2629.22	2630.37	460.0
2011-03-14 03:00:00	NQ	Futures	2630.08	2632.95	2618.3	2624.91	3644.0
2011-03-14 04:00:00	NQ	Futures	2624.62	2628.07	2615.14	2624.62	3450.0
2011-03-14 05:00:00	NQ	Futures	2624.62	2633.81	2621.17	2630.08	2425.0
2011-03-14 06:00:00	NQ	Futures	2630.37	2635.54	2625.48	2628.64	4045.0
2011-03-14 07:00:00	NQ	Futures	2628.64	2630.08	2620.6	2623.18	4168.0
2011-03-14 08:00:00	NQ	Futures	2623.47	2630.65	2622.32	2627.21	7389.0
2011-03-14 09:00:00	NQ	Futures	2626.92	2643.87	2622.9	2641.57	50209.0
2011-03-14 10:00:00	NQ	Futures	2641.28	2644.16	2619.16	2619.74	68043.0
2011-03-14 11:00:00	NQ	Futures	2620.02	2625.48	2612.27	2614.28	58648.0
2011-03-14 12:00:00	NQ	Futures	2614.56	2618.59	2609.97	2618.3	28979.0
2011-03-14 13:00:00	NQ	Futures	2618.3	2624.33	2616.58	2620.6	30770.0
2011-03-14 14:00:00	NQ	Futures	2620.6	2629.5	2618.87	2621.17	28708.0
2011-03-14 15:00:00	NQ	Futures	2621.46	2635.54	2620.6	2629.79	61669.0
2011-03-14 16:00:00	NQ	Futures	2629.79	2634.1	2625.2	2632.38	10626.0
2011-03-14 17:00:00	NQ	Futures	2632.38	2632.95	2631.52	2632.67	84.0
2011-03-14 18:00:00	NQ	Futures	2632.38	2635.25	2631.52	2632.38	303.0
2011-03-14 19:00:00	NQ	Futures	2632.95	2634.39	2615.71	2622.32	1297.0
2011-03-14 20:00:00	NQ	Futures	2622.61	2627.78	2610.25	2616.58	1568.0
2011-03-14 21:00:00	NQ	Futures	2616.58	2622.32	2609.68	2614.85	1998.0
2011-03-14 22:00:00	NQ	Futures	2614.85	2614.85	2590.14	2592.73	7515.0
2011-03-14 23:00:00	NQ	Futures	2593.88	2598.76	2574.34	2575.78	5909.0
2011-03-14 00:00:00	YM	Futures	11505.3	11523.6	11496.6	11518.8	239.0
2011-03-14 01:00:00	YM	Futures	11521.7	11532.2	11495.6	11520.7	405.0

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

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