PREVIEW / futures_1hour / 2011-03-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-18.parquet
  size:    42 KB
  rows:    1,192

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-18 00:00:00	ES	Futures	1272.46	1274.45	1271.72	1271.72	7936.0
2011-03-18 01:00:00	ES	Futures	1271.96	1272.96	1270.23	1270.23	4324.0
2011-03-18 02:00:00	ES	Futures	1270.47	1270.97	1269.48	1269.73	3996.0
2011-03-18 03:00:00	ES	Futures	1269.48	1272.21	1268.49	1268.73	18123.0
2011-03-18 04:00:00	ES	Futures	1268.98	1271.22	1267.0	1267.24	38189.0
2011-03-18 05:00:00	ES	Futures	1267.49	1269.48	1267.0	1269.48	24886.0
2011-03-18 06:00:00	ES	Futures	1269.23	1269.98	1265.51	1269.23	30852.0
2011-03-18 07:00:00	ES	Futures	1269.23	1272.46	1268.49	1270.23	48282.0
2011-03-18 08:00:00	ES	Futures	1270.47	1279.42	1269.48	1276.19	165662.0
2011-03-18 09:00:00	ES	Futures	1276.19	1279.17	1272.71	1274.45	358643.0
2011-03-18 10:00:00	ES	Futures	1274.2	1274.95	1268.73	1272.71	324157.0
2011-03-18 11:00:00	ES	Futures	1272.71	1275.44	1267.0	1269.73	323057.0
2011-03-18 12:00:00	ES	Futures	1269.73	1272.21	1268.73	1268.98	147977.0
2011-03-18 13:00:00	ES	Futures	1268.73	1271.72	1268.73	1269.48	72069.0
2011-03-18 14:00:00	ES	Futures	1269.48	1269.98	1263.27	1264.51	187181.0
2011-03-18 15:00:00	ES	Futures	1264.26	1266.5	1262.77	1265.75	277184.0
2011-03-18 16:00:00	ES	Futures	1265.75	1267.49	1265.26	1266.5	133317.0
2011-03-18 00:00:00	NQ	Futures	2579.8	2584.68	2578.65	2578.94	916.0
2011-03-18 01:00:00	NQ	Futures	2578.65	2581.24	2575.2	2575.49	332.0
2011-03-18 02:00:00	NQ	Futures	2575.78	2576.93	2573.77	2574.34	330.0
2011-03-18 03:00:00	NQ	Futures	2574.34	2580.95	2573.77	2574.34	2211.0
2011-03-18 04:00:00	NQ	Futures	2574.34	2579.51	2570.32	2572.62	3889.0
2011-03-18 05:00:00	NQ	Futures	2572.62	2576.64	2570.89	2574.05	1869.0
2011-03-18 06:00:00	NQ	Futures	2574.05	2575.49	2568.31	2574.05	2245.0
2011-03-18 07:00:00	NQ	Futures	2574.05	2578.94	2572.9	2575.78	4497.0
2011-03-18 08:00:00	NQ	Futures	2575.49	2585.83	2573.19	2579.8	14841.0
2011-03-18 09:00:00	NQ	Futures	2579.8	2590.14	2569.74	2570.89	57987.0
2011-03-18 10:00:00	NQ	Futures	2570.61	2572.04	2553.37	2563.14	65378.0
2011-03-18 11:00:00	NQ	Futures	2563.14	2566.87	2546.47	2549.92	56459.0
2011-03-18 12:00:00	NQ	Futures	2549.92	2560.55	2549.34	2556.24	28299.0
2011-03-18 13:00:00	NQ	Futures	2556.53	2567.73	2556.53	2564.0	24457.0
2011-03-18 14:00:00	NQ	Futures	2564.0	2564.28	2550.21	2551.93	25707.0
2011-03-18 15:00:00	NQ	Futures	2551.93	2553.65	2546.18	2548.19	40757.0
2011-03-18 16:00:00	NQ	Futures	2548.48	2555.09	2547.62	2551.36	13047.0
2011-03-18 00:00:00	YM	Futures	11378.1	11391.6	11369.5	11374.3	420.0
2011-03-18 01:00:00	YM	Futures	11373.3	11381.0	11361.8	11363.7	180.0
2011-03-18 02:00:00	YM	Futures	11363.7	11365.6	11356.0	11356.9	201.0
2011-03-18 03:00:00	YM	Futures	11356.9	11379.1	11350.2	11352.1	1480.0
2011-03-18 04:00:00	YM	Futures	11353.1	11372.4	11341.5	11343.5	2388.0
2011-03-18 05:00:00	YM	Futures	11342.5	11358.9	11341.5	11356.0	1687.0
2011-03-18 06:00:00	YM	Futures	11356.0	11364.7	11330.9	11357.9	1612.0
2011-03-18 07:00:00	YM	Futures	11356.9	11372.4	11350.2	11356.9	2110.0
2011-03-18 08:00:00	YM	Futures	11357.9	11419.6	11351.2	11400.3	5580.0
2011-03-18 09:00:00	YM	Futures	11401.3	11428.2	11388.7	11403.2	19923.0
2011-03-18 10:00:00	YM	Futures	11405.1	11410.9	11371.4	11406.1	16534.0
2011-03-18 11:00:00	YM	Futures	11405.1	11425.3	11356.9	11385.8	17397.0
2011-03-18 12:00:00	YM	Futures	11384.9	11402.2	11375.2	11376.2	10313.0
2011-03-18 13:00:00	YM	Futures	11378.1	11397.4	11372.4	11375.2	5413.0
2011-03-18 14:00:00	YM	Futures	11375.2	11379.1	11331.9	11339.6	10929.0
2011-03-18 15:00:00	YM	Futures	11338.6	11362.7	11328.1	11355.0	12703.0

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

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