PREVIEW / futures_1hour / 2011-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-26.parquet
  size:    48 KB
  rows:    1,473

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-01-26 00:00:00	ES	Futures	1277.22	1279.69	1276.72	1278.46	7479.0
2011-01-26 01:00:00	ES	Futures	1278.21	1279.2	1277.47	1277.71	3928.0
2011-01-26 02:00:00	ES	Futures	1277.47	1278.46	1276.23	1276.97	10106.0
2011-01-26 03:00:00	ES	Futures	1276.72	1279.45	1276.23	1278.95	19661.0
2011-01-26 04:00:00	ES	Futures	1278.95	1279.94	1278.7	1279.69	16424.0
2011-01-26 05:00:00	ES	Futures	1279.69	1280.44	1278.95	1279.69	12698.0
2011-01-26 06:00:00	ES	Futures	1279.69	1280.93	1278.95	1280.44	15238.0
2011-01-26 07:00:00	ES	Futures	1280.44	1281.18	1278.7	1278.95	17554.0
2011-01-26 08:00:00	ES	Futures	1278.95	1279.69	1277.22	1277.71	29149.0
2011-01-26 09:00:00	ES	Futures	1277.71	1278.21	1274.99	1276.48	191541.0
2011-01-26 10:00:00	ES	Futures	1276.48	1282.66	1276.23	1280.19	352795.0
2011-01-26 11:00:00	ES	Futures	1280.19	1281.18	1277.22	1278.7	161008.0
2011-01-26 12:00:00	ES	Futures	1278.7	1280.93	1277.96	1280.68	77348.0
2011-01-26 13:00:00	ES	Futures	1280.44	1282.41	1279.45	1280.68	77122.0
2011-01-26 14:00:00	ES	Futures	1280.68	1283.4	1277.96	1282.17	243869.0
2011-01-26 15:00:00	ES	Futures	1281.92	1283.4	1279.45	1279.69	253720.0
2011-01-26 16:00:00	ES	Futures	1279.69	1280.93	1279.45	1279.94	95867.0
2011-01-26 17:00:00	ES	Futures	1279.94	1279.94	1279.2	1279.45	2037.0
2011-01-26 18:00:00	ES	Futures	1279.45	1279.69	1278.7	1279.69	4396.0
2011-01-26 19:00:00	ES	Futures	1279.69	1280.68	1279.45	1280.44	3674.0
2011-01-26 20:00:00	ES	Futures	1280.44	1281.42	1278.95	1279.2	5489.0
2011-01-26 21:00:00	ES	Futures	1278.95	1280.19	1278.46	1280.19	4596.0
2011-01-26 22:00:00	ES	Futures	1279.94	1280.93	1279.69	1280.68	1617.0
2011-01-26 23:00:00	ES	Futures	1280.68	1281.67	1279.69	1281.18	3018.0
2011-01-26 00:00:00	NQ	Futures	2646.15	2650.74	2644.72	2649.31	975.0
2011-01-26 01:00:00	NQ	Futures	2649.02	2650.46	2648.74	2649.6	519.0
2011-01-26 02:00:00	NQ	Futures	2649.02	2650.74	2646.44	2647.87	1003.0
2011-01-26 03:00:00	NQ	Futures	2647.3	2650.74	2645.29	2650.17	2161.0
2011-01-26 04:00:00	NQ	Futures	2650.46	2652.18	2649.88	2650.74	1911.0
2011-01-26 05:00:00	NQ	Futures	2651.03	2652.18	2649.02	2650.74	1368.0
2011-01-26 06:00:00	NQ	Futures	2650.74	2653.9	2650.46	2653.9	1385.0
2011-01-26 07:00:00	NQ	Futures	2653.9	2654.48	2650.17	2650.46	2471.0
2011-01-26 08:00:00	NQ	Futures	2650.46	2651.32	2647.59	2649.31	2686.0
2011-01-26 09:00:00	NQ	Futures	2649.31	2649.31	2638.69	2643.86	31741.0
2011-01-26 10:00:00	NQ	Futures	2644.14	2663.66	2642.99	2657.06	48324.0
2011-01-26 11:00:00	NQ	Futures	2656.77	2659.64	2649.31	2652.75	23260.0
2011-01-26 12:00:00	NQ	Futures	2652.47	2659.07	2651.61	2657.63	10649.0
2011-01-26 13:00:00	NQ	Futures	2657.63	2662.51	2654.48	2659.93	13215.0
2011-01-26 14:00:00	NQ	Futures	2659.64	2662.23	2652.47	2659.64	26827.0
2011-01-26 15:00:00	NQ	Futures	2659.93	2663.37	2655.05	2655.62	34260.0
2011-01-26 16:00:00	NQ	Futures	2655.62	2661.65	2655.34	2661.08	12717.0
2011-01-26 17:00:00	NQ	Futures	2661.08	2661.36	2659.93	2659.93	94.0
2011-01-26 18:00:00	NQ	Futures	2659.93	2660.79	2658.49	2660.22	351.0
2011-01-26 19:00:00	NQ	Futures	2660.22	2661.94	2659.64	2661.36	150.0
2011-01-26 20:00:00	NQ	Futures	2661.08	2662.8	2658.21	2658.49	454.0
2011-01-26 21:00:00	NQ	Futures	2658.78	2661.65	2657.35	2661.08	302.0
2011-01-26 22:00:00	NQ	Futures	2661.08	2661.65	2660.5	2660.79	132.0
2011-01-26 23:00:00	NQ	Futures	2661.08	2662.23	2659.64	2661.08	153.0
2011-01-26 00:00:00	YM	Futures	11441.7	11459.9	11437.8	11449.3	629.0
2011-01-26 01:00:00	YM	Futures	11448.4	11455.1	11443.6	11443.6	270.0

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

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