PREVIEW / futures_1hour / 2011-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-25.parquet
  size:    35 KB
  rows:    971

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-25 00:00:00	ES	Futures	1158.25	1159.51	1156.75	1157.0	2979.0
2011-11-25 01:00:00	ES	Futures	1157.25	1160.01	1156.5	1159.76	3449.0
2011-11-25 02:00:00	ES	Futures	1160.01	1161.26	1157.0	1159.25	10082.0
2011-11-25 03:00:00	ES	Futures	1159.51	1162.51	1153.74	1154.49	46461.0
2011-11-25 04:00:00	ES	Futures	1154.49	1157.5	1150.98	1156.25	45541.0
2011-11-25 05:00:00	ES	Futures	1156.25	1157.0	1151.98	1151.98	32676.0
2011-11-25 06:00:00	ES	Futures	1152.23	1157.25	1151.48	1155.24	25984.0
2011-11-25 07:00:00	ES	Futures	1154.99	1157.5	1153.74	1155.49	24761.0
2011-11-25 08:00:00	ES	Futures	1155.49	1160.01	1153.24	1159.25	50229.0
2011-11-25 09:00:00	ES	Futures	1159.51	1172.04	1158.0	1168.28	245116.0
2011-11-25 10:00:00	ES	Futures	1168.53	1174.8	1168.03	1171.04	248746.0
2011-11-25 11:00:00	ES	Futures	1171.04	1173.3	1164.02	1164.77	192604.0
2011-11-25 12:00:00	ES	Futures	1165.02	1166.28	1160.76	1161.01	195203.0
2011-11-25 13:00:00	ES	Futures	1160.76	1161.76	1152.73	1157.0	71394.0
2011-11-25 00:00:00	NQ	Futures	2483.32	2485.05	2480.15	2480.44	305.0
2011-11-25 01:00:00	NQ	Futures	2480.15	2483.03	2478.42	2483.03	397.0
2011-11-25 02:00:00	NQ	Futures	2483.03	2487.93	2480.15	2484.76	463.0
2011-11-25 03:00:00	NQ	Futures	2484.19	2489.95	2472.94	2474.67	2745.0
2011-11-25 04:00:00	NQ	Futures	2474.38	2478.13	2463.14	2476.4	3639.0
2011-11-25 05:00:00	NQ	Futures	2475.83	2477.55	2469.19	2469.19	1305.0
2011-11-25 06:00:00	NQ	Futures	2468.91	2478.13	2468.91	2474.1	1710.0
2011-11-25 07:00:00	NQ	Futures	2473.52	2479.0	2471.5	2475.25	1371.0
2011-11-25 08:00:00	NQ	Futures	2474.96	2484.76	2472.65	2483.32	4095.0
2011-11-25 09:00:00	NQ	Futures	2483.61	2517.06	2480.44	2503.5	39996.0
2011-11-25 10:00:00	NQ	Futures	2503.5	2515.9	2502.35	2506.68	26339.0
2011-11-25 11:00:00	NQ	Futures	2506.96	2510.71	2487.93	2490.24	22768.0
2011-11-25 12:00:00	NQ	Futures	2490.24	2496.87	2479.57	2479.86	22171.0
2011-11-25 13:00:00	NQ	Futures	2479.57	2481.59	2469.77	2479.0	6134.0
2011-11-25 00:00:00	YM	Futures	11018.2	11025.1	11001.5	11006.4	248.0
2011-11-25 01:00:00	YM	Futures	11004.4	11025.1	11000.5	11025.1	275.0
2011-11-25 02:00:00	YM	Futures	11025.1	11041.8	11009.4	11029.0	806.0
2011-11-25 03:00:00	YM	Futures	11028.1	11045.8	10984.7	10990.6	2631.0
2011-11-25 04:00:00	YM	Futures	10988.7	11009.4	10956.2	10999.5	1920.0
2011-11-25 05:00:00	YM	Futures	10998.5	11004.4	10970.0	10970.0	868.0
2011-11-25 06:00:00	YM	Futures	10968.0	11007.4	10965.0	10990.6	801.0
2011-11-25 07:00:00	YM	Futures	10989.7	11011.3	10981.8	10996.6	600.0
2011-11-25 08:00:00	YM	Futures	10991.6	11028.1	10975.9	11023.1	1740.0
2011-11-25 09:00:00	YM	Futures	11023.1	11131.4	11018.2	11107.8	12613.0
2011-11-25 10:00:00	YM	Futures	11108.8	11163.9	11103.9	11129.5	10724.0
2011-11-25 11:00:00	YM	Futures	11129.5	11151.1	11070.4	11076.3	8998.0
2011-11-25 12:00:00	YM	Futures	11076.3	11088.1	11042.8	11043.8	7931.0
2011-11-25 13:00:00	YM	Futures	11043.8	11044.8	10975.9	11014.3	2793.0
2011-11-25 00:00:00	CL	Futures	163.34	163.34	162.85	162.85	357.0
2011-11-25 01:00:00	CL	Futures	162.82	163.09	162.7	162.88	310.0
2011-11-25 02:00:00	CL	Futures	162.85	162.99	162.29	162.68	1171.0
2011-11-25 03:00:00	CL	Futures	162.66	162.88	161.99	162.09	2694.0
2011-11-25 04:00:00	CL	Futures	162.09	162.34	161.45	162.04	3222.0
2011-11-25 05:00:00	CL	Futures	162.01	162.19	161.6	161.6	1566.0
2011-11-25 06:00:00	CL	Futures	161.57	162.02	161.28	161.5	3495.0
2011-11-25 07:00:00	CL	Futures	161.46	161.68	160.59	160.7	5534.0

> showing 50 of 971 rows — these rows as CSV

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