PREVIEW / futures_1hour / 2011-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-20.parquet
  size:    47 KB
  rows:    1,430

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-06-20 00:00:00	ES	Futures	1258.25	1259.0	1256.01	1257.0	5947.0
2011-06-20 01:00:00	ES	Futures	1257.25	1257.75	1255.01	1255.51	7764.0
2011-06-20 02:00:00	ES	Futures	1255.51	1255.76	1253.26	1255.26	22753.0
2011-06-20 03:00:00	ES	Futures	1255.01	1256.51	1253.26	1254.51	39021.0
2011-06-20 04:00:00	ES	Futures	1254.51	1257.25	1253.76	1255.76	23471.0
2011-06-20 05:00:00	ES	Futures	1256.01	1258.0	1255.76	1257.25	16277.0
2011-06-20 06:00:00	ES	Futures	1257.25	1259.25	1256.51	1257.0	15562.0
2011-06-20 07:00:00	ES	Futures	1257.0	1257.0	1254.26	1255.51	23082.0
2011-06-20 08:00:00	ES	Futures	1255.76	1259.25	1255.01	1257.25	47783.0
2011-06-20 09:00:00	ES	Futures	1257.25	1264.74	1257.0	1263.99	233981.0
2011-06-20 10:00:00	ES	Futures	1263.74	1268.48	1260.99	1266.73	341220.0
2011-06-20 11:00:00	ES	Futures	1266.73	1271.72	1265.23	1271.47	208492.0
2011-06-20 12:00:00	ES	Futures	1271.47	1272.22	1269.47	1269.97	114200.0
2011-06-20 13:00:00	ES	Futures	1269.72	1270.72	1267.48	1267.98	100810.0
2011-06-20 14:00:00	ES	Futures	1268.23	1271.97	1267.48	1270.97	105772.0
2011-06-20 15:00:00	ES	Futures	1270.72	1271.22	1266.48	1269.72	237323.0
2011-06-20 16:00:00	ES	Futures	1269.97	1270.97	1268.98	1270.22	88134.0
2011-06-20 17:00:00	ES	Futures	1270.22	1270.47	1269.97	1269.97	887.0
2011-06-20 18:00:00	ES	Futures	1269.97	1270.72	1269.72	1270.22	2532.0
2011-06-20 19:00:00	ES	Futures	1270.22	1272.97	1269.97	1272.22	7058.0
2011-06-20 20:00:00	ES	Futures	1272.22	1273.71	1270.97	1272.22	6253.0
2011-06-20 21:00:00	ES	Futures	1271.97	1272.72	1269.72	1271.47	8202.0
2011-06-20 22:00:00	ES	Futures	1271.47	1271.97	1268.73	1270.22	6119.0
2011-06-20 23:00:00	ES	Futures	1270.22	1270.22	1269.22	1269.22	2274.0
2011-06-20 00:00:00	NQ	Futures	2513.34	2514.49	2509.03	2510.75	768.0
2011-06-20 01:00:00	NQ	Futures	2510.75	2512.19	2506.72	2507.3	552.0
2011-06-20 02:00:00	NQ	Futures	2507.3	2507.59	2502.41	2506.15	2216.0
2011-06-20 03:00:00	NQ	Futures	2505.86	2508.74	2502.41	2504.42	3170.0
2011-06-20 04:00:00	NQ	Futures	2504.42	2510.18	2503.85	2508.16	2219.0
2011-06-20 05:00:00	NQ	Futures	2508.16	2512.77	2507.87	2511.62	1404.0
2011-06-20 06:00:00	NQ	Futures	2511.33	2514.78	2510.18	2511.04	1869.0
2011-06-20 07:00:00	NQ	Futures	2510.46	2510.46	2505.0	2507.87	2937.0
2011-06-20 08:00:00	NQ	Futures	2507.87	2514.21	2506.72	2510.18	4802.0
2011-06-20 09:00:00	NQ	Futures	2510.18	2527.44	2510.18	2525.43	39680.0
2011-06-20 10:00:00	NQ	Futures	2525.43	2527.73	2515.93	2523.13	43493.0
2011-06-20 11:00:00	NQ	Futures	2523.13	2536.36	2520.54	2535.5	23954.0
2011-06-20 12:00:00	NQ	Futures	2535.5	2540.39	2533.77	2536.08	17518.0
2011-06-20 13:00:00	NQ	Futures	2536.08	2538.09	2532.05	2532.62	13267.0
2011-06-20 14:00:00	NQ	Futures	2532.62	2538.95	2531.47	2537.8	14076.0
2011-06-20 15:00:00	NQ	Futures	2537.8	2537.8	2527.73	2532.33	33722.0
2011-06-20 16:00:00	NQ	Futures	2532.62	2534.35	2529.74	2534.35	6447.0
2011-06-20 17:00:00	NQ	Futures	2533.77	2534.92	2533.49	2533.77	58.0
2011-06-20 18:00:00	NQ	Futures	2534.35	2535.5	2533.77	2534.35	206.0
2011-06-20 19:00:00	NQ	Futures	2534.06	2539.53	2533.77	2537.23	439.0
2011-06-20 20:00:00	NQ	Futures	2536.94	2539.24	2534.06	2536.94	188.0
2011-06-20 21:00:00	NQ	Futures	2535.5	2537.51	2532.62	2534.92	540.0
2011-06-20 22:00:00	NQ	Futures	2534.64	2535.79	2530.03	2532.33	428.0
2011-06-20 23:00:00	NQ	Futures	2532.33	2532.62	2530.9	2530.9	130.0
2011-06-20 00:00:00	YM	Futures	11520.1	11529.8	11498.8	11506.5	675.0
2011-06-20 01:00:00	YM	Futures	11507.5	11512.3	11492.0	11496.8	468.0

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

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