PREVIEW / futures_1hour / 2011-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-24.parquet
  size:    34 KB
  rows:    988

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-11-24 00:00:00	ES	Futures	1168.53	1170.04	1165.52	1166.02	5404.0
2011-11-24 01:00:00	ES	Futures	1166.02	1167.53	1164.27	1167.28	4059.0
2011-11-24 02:00:00	ES	Futures	1167.28	1172.29	1167.03	1170.04	11607.0
2011-11-24 03:00:00	ES	Futures	1170.04	1172.54	1167.03	1168.28	27292.0
2011-11-24 04:00:00	ES	Futures	1168.28	1177.31	1168.03	1176.31	30918.0
2011-11-24 05:00:00	ES	Futures	1176.31	1176.56	1169.79	1170.29	25421.0
2011-11-24 06:00:00	ES	Futures	1170.29	1173.8	1170.04	1172.54	13916.0
2011-11-24 07:00:00	ES	Futures	1172.8	1174.8	1171.54	1173.3	14430.0
2011-11-24 08:00:00	ES	Futures	1173.3	1174.8	1168.03	1169.79	21616.0
2011-11-24 09:00:00	ES	Futures	1169.79	1170.54	1159.51	1162.51	49056.0
2011-11-24 10:00:00	ES	Futures	1162.77	1166.53	1159.76	1164.02	25149.0
2011-11-24 11:00:00	ES	Futures	1164.27	1167.03	1161.76	1162.77	15829.0
2011-11-24 18:00:00	ES	Futures	1163.52	1164.27	1156.5	1161.01	11008.0
2011-11-24 19:00:00	ES	Futures	1161.01	1163.02	1159.0	1160.01	4943.0
2011-11-24 20:00:00	ES	Futures	1160.01	1161.76	1157.0	1159.51	6344.0
2011-11-24 21:00:00	ES	Futures	1159.51	1160.51	1158.5	1159.0	3520.0
2011-11-24 22:00:00	ES	Futures	1159.0	1161.01	1157.25	1158.25	5048.0
2011-11-24 23:00:00	ES	Futures	1158.25	1158.75	1156.5	1158.0	4221.0
2011-11-24 00:00:00	NQ	Futures	2506.96	2508.98	2501.2	2501.49	438.0
2011-11-24 01:00:00	NQ	Futures	2501.49	2503.22	2496.87	2500.62	781.0
2011-11-24 02:00:00	NQ	Futures	2500.62	2507.83	2500.33	2503.22	1815.0
2011-11-24 03:00:00	NQ	Futures	2503.22	2508.98	2498.89	2502.64	2707.0
2011-11-24 04:00:00	NQ	Futures	2502.93	2518.79	2502.93	2518.21	2380.0
2011-11-24 05:00:00	NQ	Futures	2518.79	2519.36	2508.41	2509.85	1556.0
2011-11-24 06:00:00	NQ	Futures	2510.14	2515.04	2508.41	2513.31	1384.0
2011-11-24 07:00:00	NQ	Futures	2514.46	2517.34	2512.15	2512.44	1364.0
2011-11-24 08:00:00	NQ	Futures	2513.31	2515.04	2500.91	2503.22	1127.0
2011-11-24 09:00:00	NQ	Futures	2503.5	2504.66	2480.73	2488.8	4845.0
2011-11-24 10:00:00	NQ	Futures	2488.51	2494.85	2484.47	2489.95	2924.0
2011-11-24 11:00:00	NQ	Futures	2490.24	2495.72	2487.93	2487.93	1515.0
2011-11-24 18:00:00	NQ	Futures	2487.93	2493.7	2481.59	2489.09	708.0
2011-11-24 19:00:00	NQ	Futures	2489.38	2491.11	2485.05	2485.05	348.0
2011-11-24 20:00:00	NQ	Futures	2485.92	2488.8	2482.17	2485.05	532.0
2011-11-24 21:00:00	NQ	Futures	2485.34	2487.36	2483.61	2485.92	277.0
2011-11-24 22:00:00	NQ	Futures	2485.34	2487.07	2483.03	2484.19	529.0
2011-11-24 23:00:00	NQ	Futures	2484.47	2485.05	2481.59	2482.74	345.0
2011-11-24 00:00:00	YM	Futures	11100.9	11114.7	11084.2	11087.1	340.0
2011-11-24 01:00:00	YM	Futures	11085.2	11098.9	11067.4	11098.9	353.0
2011-11-24 02:00:00	YM	Futures	11098.0	11138.3	11093.0	11118.6	1129.0
2011-11-24 03:00:00	YM	Futures	11119.6	11137.3	11096.0	11111.7	1289.0
2011-11-24 04:00:00	YM	Futures	11106.8	11173.8	11105.8	11169.8	1816.0
2011-11-24 05:00:00	YM	Futures	11169.8	11169.8	11117.7	11123.6	606.0
2011-11-24 06:00:00	YM	Futures	11124.5	11145.2	11117.7	11136.4	683.0
2011-11-24 07:00:00	YM	Futures	11137.3	11153.1	11126.5	11139.3	503.0
2011-11-24 08:00:00	YM	Futures	11141.3	11146.2	11094.0	11106.8	709.0
2011-11-24 09:00:00	YM	Futures	11108.8	11113.7	11022.2	11043.8	2129.0
2011-11-24 10:00:00	YM	Futures	11044.8	11072.4	11026.1	11055.6	1201.0
2011-11-24 11:00:00	YM	Futures	11054.6	11078.3	11037.9	11041.8	584.0
2011-11-24 18:00:00	YM	Futures	11060.5	11061.5	10999.5	11030.0	360.0
2011-11-24 19:00:00	YM	Futures	11033.0	11050.7	11020.2	11028.1	290.0

> showing 50 of 988 rows — these rows as CSV

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