PREVIEW / futures_1hour / 2011-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-12.parquet
  size:    41 KB
  rows:    1,172

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-08-12 00:00:00	ES	Futures	1155.5	1156.74	1152.75	1153.5	4560.0
2011-08-12 01:00:00	ES	Futures	1153.5	1156.24	1152.25	1154.75	11794.0
2011-08-12 02:00:00	ES	Futures	1154.5	1158.74	1151.51	1154.25	36652.0
2011-08-12 03:00:00	ES	Futures	1154.5	1159.49	1144.02	1155.0	112326.0
2011-08-12 04:00:00	ES	Futures	1155.25	1164.97	1153.5	1160.73	52738.0
2011-08-12 05:00:00	ES	Futures	1160.73	1171.71	1158.99	1169.46	59287.0
2011-08-12 06:00:00	ES	Futures	1169.46	1170.96	1161.98	1164.23	41879.0
2011-08-12 07:00:00	ES	Futures	1164.23	1173.95	1164.23	1171.21	51245.0
2011-08-12 08:00:00	ES	Futures	1171.21	1176.7	1166.97	1174.7	114740.0
2011-08-12 09:00:00	ES	Futures	1174.7	1183.43	1168.22	1172.21	481215.0
2011-08-12 10:00:00	ES	Futures	1172.21	1178.19	1164.72	1171.71	488001.0
2011-08-12 11:00:00	ES	Futures	1171.71	1183.93	1168.46	1181.93	332592.0
2011-08-12 12:00:00	ES	Futures	1181.93	1182.93	1173.95	1176.94	154946.0
2011-08-12 13:00:00	ES	Futures	1176.94	1180.69	1174.7	1179.44	90354.0
2011-08-12 14:00:00	ES	Futures	1179.69	1180.94	1169.46	1173.45	201505.0
2011-08-12 15:00:00	ES	Futures	1173.45	1176.7	1167.72	1173.45	298268.0
2011-08-12 16:00:00	ES	Futures	1173.45	1177.69	1172.46	1174.2	112230.0
2011-08-12 00:00:00	NQ	Futures	2462.7	2466.15	2457.8	2458.38	309.0
2011-08-12 01:00:00	NQ	Futures	2458.67	2463.85	2455.79	2461.26	582.0
2011-08-12 02:00:00	NQ	Futures	2460.11	2469.03	2452.34	2456.94	3375.0
2011-08-12 03:00:00	NQ	Futures	2456.94	2467.59	2433.34	2460.11	8894.0
2011-08-12 04:00:00	NQ	Futures	2460.11	2479.67	2456.08	2470.46	3545.0
2011-08-12 05:00:00	NQ	Futures	2470.46	2492.05	2467.59	2489.46	4427.0
2011-08-12 06:00:00	NQ	Futures	2489.46	2492.05	2473.63	2477.66	3400.0
2011-08-12 07:00:00	NQ	Futures	2478.23	2495.21	2478.23	2489.46	4099.0
2011-08-12 08:00:00	NQ	Futures	2489.75	2503.27	2480.54	2497.23	10165.0
2011-08-12 09:00:00	NQ	Futures	2496.94	2509.6	2478.81	2488.88	61663.0
2011-08-12 10:00:00	NQ	Futures	2489.17	2513.34	2476.22	2503.27	53263.0
2011-08-12 11:00:00	NQ	Futures	2503.27	2523.7	2496.65	2519.67	32741.0
2011-08-12 12:00:00	NQ	Futures	2519.39	2521.4	2502.69	2508.74	19401.0
2011-08-12 13:00:00	NQ	Futures	2509.03	2521.4	2508.16	2519.96	14375.0
2011-08-12 14:00:00	NQ	Futures	2519.67	2523.41	2501.54	2508.16	25027.0
2011-08-12 15:00:00	NQ	Futures	2507.87	2516.22	2500.97	2508.45	34407.0
2011-08-12 16:00:00	NQ	Futures	2508.16	2514.49	2506.15	2506.72	6772.0
2011-08-12 00:00:00	YM	Futures	10655.3	10667.9	10635.0	10641.7	1292.0
2011-08-12 01:00:00	YM	Futures	10641.7	10655.3	10628.2	10648.5	1698.0
2011-08-12 02:00:00	YM	Futures	10645.6	10679.5	10614.6	10638.8	4760.0
2011-08-12 03:00:00	YM	Futures	10638.8	10678.5	10547.8	10640.8	13038.0
2011-08-12 04:00:00	YM	Futures	10641.7	10727.9	10630.1	10692.1	4498.0
2011-08-12 05:00:00	YM	Futures	10690.2	10782.2	10680.5	10767.6	5786.0
2011-08-12 06:00:00	YM	Futures	10764.7	10778.3	10712.4	10720.2	5476.0
2011-08-12 07:00:00	YM	Futures	10722.1	10803.5	10722.1	10783.1	2206.0
2011-08-12 08:00:00	YM	Futures	10782.2	10826.7	10715.3	10816.1	8858.0
2011-08-12 09:00:00	YM	Futures	10816.1	10903.2	10793.8	10822.8	52582.0
2011-08-12 10:00:00	YM	Futures	10827.7	10883.8	10764.7	10833.5	48392.0
2011-08-12 11:00:00	YM	Futures	10834.5	10951.6	10812.2	10937.1	44044.0
2011-08-12 12:00:00	YM	Futures	10938.1	10946.8	10870.3	10895.5	19752.0
2011-08-12 13:00:00	YM	Futures	10894.5	10928.4	10880.9	10915.8	13026.0
2011-08-12 14:00:00	YM	Futures	10917.7	10931.3	10838.3	10878.0	27766.0
2011-08-12 15:00:00	YM	Futures	10878.0	10901.3	10822.8	10885.8	35202.0

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

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