PREVIEW / futures_1hour / 2010-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-26.parquet
  size:    34 KB
  rows:    945

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
2010-11-26 00:00:00	ES	Futures	1179.89	1179.89	1177.18	1177.43	5217.0
2010-11-26 01:00:00	ES	Futures	1177.68	1177.92	1174.72	1175.21	10374.0
2010-11-26 02:00:00	ES	Futures	1175.46	1177.92	1175.21	1175.7	11305.0
2010-11-26 03:00:00	ES	Futures	1175.46	1178.91	1174.23	1176.44	24748.0
2010-11-26 04:00:00	ES	Futures	1176.69	1177.18	1169.05	1170.53	49914.0
2010-11-26 05:00:00	ES	Futures	1170.53	1171.76	1167.82	1170.04	28365.0
2010-11-26 06:00:00	ES	Futures	1170.04	1170.04	1165.85	1168.8	47375.0
2010-11-26 07:00:00	ES	Futures	1168.8	1170.77	1165.85	1170.53	46663.0
2010-11-26 08:00:00	ES	Futures	1170.53	1171.02	1167.57	1170.53	44703.0
2010-11-26 09:00:00	ES	Futures	1170.53	1174.23	1168.56	1173.98	182004.0
2010-11-26 10:00:00	ES	Futures	1174.23	1176.44	1172.25	1172.5	131884.0
2010-11-26 11:00:00	ES	Futures	1172.25	1173.49	1170.04	1172.25	83633.0
2010-11-26 12:00:00	ES	Futures	1172.01	1173.49	1170.53	1171.27	82598.0
2010-11-26 13:00:00	ES	Futures	1171.27	1171.27	1166.34	1166.58	68301.0
2010-11-26 00:00:00	NQ	Futures	2475.39	2475.39	2470.52	2470.52	439.0
2010-11-26 01:00:00	NQ	Futures	2471.09	2471.67	2466.5	2466.79	654.0
2010-11-26 02:00:00	NQ	Futures	2467.36	2472.24	2467.07	2469.08	615.0
2010-11-26 03:00:00	NQ	Futures	2468.8	2473.67	2467.07	2469.94	1764.0
2010-11-26 04:00:00	NQ	Futures	2469.66	2470.8	2453.88	2455.89	3617.0
2010-11-26 05:00:00	NQ	Futures	2455.89	2458.47	2451.01	2456.17	2473.0
2010-11-26 06:00:00	NQ	Futures	2456.17	2456.17	2449.86	2453.88	2343.0
2010-11-26 07:00:00	NQ	Futures	2453.59	2457.61	2451.01	2457.03	2192.0
2010-11-26 08:00:00	NQ	Futures	2457.32	2460.19	2453.02	2459.62	4488.0
2010-11-26 09:00:00	NQ	Futures	2459.62	2474.53	2457.61	2472.81	29487.0
2010-11-26 10:00:00	NQ	Futures	2472.53	2479.12	2469.37	2470.52	19672.0
2010-11-26 11:00:00	NQ	Futures	2470.52	2475.68	2468.8	2473.67	10902.0
2010-11-26 12:00:00	NQ	Futures	2473.96	2475.11	2469.94	2471.38	14235.0
2010-11-26 13:00:00	NQ	Futures	2471.38	2471.38	2460.76	2461.91	7329.0
2010-11-26 00:00:00	YM	Futures	10628.7	10628.7	10609.7	10611.6	398.0
2010-11-26 01:00:00	YM	Futures	10613.5	10614.4	10591.6	10594.4	467.0
2010-11-26 02:00:00	YM	Futures	10595.4	10618.2	10593.5	10602.0	809.0
2010-11-26 03:00:00	YM	Futures	10601.1	10626.8	10590.6	10607.8	1252.0
2010-11-26 04:00:00	YM	Futures	10607.8	10610.6	10550.6	10558.2	2180.0
2010-11-26 05:00:00	YM	Futures	10558.2	10562.0	10535.4	10549.7	1455.0
2010-11-26 06:00:00	YM	Futures	10547.7	10547.7	10520.1	10541.1	1936.0
2010-11-26 07:00:00	YM	Futures	10540.1	10560.1	10525.8	10557.3	1289.0
2010-11-26 08:00:00	YM	Futures	10555.4	10560.1	10530.6	10549.7	3551.0
2010-11-26 09:00:00	YM	Futures	10550.6	10566.8	10521.1	10565.8	14850.0
2010-11-26 10:00:00	YM	Futures	10565.8	10585.9	10554.4	10559.2	8818.0
2010-11-26 11:00:00	YM	Futures	10559.2	10567.8	10542.0	10559.2	5657.0
2010-11-26 12:00:00	YM	Futures	10558.2	10566.8	10543.0	10546.8	5960.0
2010-11-26 13:00:00	YM	Futures	10546.8	10547.7	10505.8	10506.8	2967.0
2010-11-26 00:00:00	CL	Futures	156.48	156.54	155.94	156.02	972.0
2010-11-26 01:00:00	CL	Futures	156.02	156.24	155.74	155.74	1182.0
2010-11-26 02:00:00	CL	Futures	155.75	156.15	155.66	156.09	2054.0
2010-11-26 03:00:00	CL	Futures	156.09	156.8	156.05	156.2	3773.0
2010-11-26 04:00:00	CL	Futures	156.18	156.22	155.14	155.49	7115.0
2010-11-26 05:00:00	CL	Futures	155.49	155.49	155.01	155.34	4911.0
2010-11-26 06:00:00	CL	Futures	155.34	155.36	154.49	154.9	6670.0
2010-11-26 07:00:00	CL	Futures	154.86	155.38	154.78	155.27	5314.0

> showing 50 of 945 rows — these rows as CSV

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