PREVIEW / futures_1hour / 2012-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-26.parquet
  size:    49 KB
  rows:    1,484

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
2012-09-26 00:00:00	ES	Futures	1470.45	1470.45	1468.92	1469.43	3088.0
2012-09-26 01:00:00	ES	Futures	1469.68	1470.7	1469.43	1469.68	5671.0
2012-09-26 02:00:00	ES	Futures	1469.43	1471.22	1469.17	1470.45	8581.0
2012-09-26 03:00:00	ES	Futures	1470.7	1470.96	1467.13	1467.89	39863.0
2012-09-26 04:00:00	ES	Futures	1467.64	1468.66	1465.85	1468.41	27368.0
2012-09-26 05:00:00	ES	Futures	1468.41	1470.45	1467.89	1468.15	19680.0
2012-09-26 06:00:00	ES	Futures	1468.15	1468.92	1466.87	1467.89	13589.0
2012-09-26 07:00:00	ES	Futures	1468.15	1468.41	1465.08	1466.62	38942.0
2012-09-26 08:00:00	ES	Futures	1466.62	1467.13	1463.81	1465.85	62974.0
2012-09-26 09:00:00	ES	Futures	1465.85	1467.13	1461.51	1463.81	213979.0
2012-09-26 10:00:00	ES	Futures	1463.55	1464.32	1455.12	1456.4	356085.0
2012-09-26 11:00:00	ES	Futures	1456.4	1462.02	1456.4	1460.23	237716.0
2012-09-26 12:00:00	ES	Futures	1460.23	1463.3	1459.46	1462.79	151160.0
2012-09-26 13:00:00	ES	Futures	1462.79	1464.83	1459.98	1459.98	98060.0
2012-09-26 14:00:00	ES	Futures	1459.98	1463.81	1459.98	1461.25	115305.0
2012-09-26 15:00:00	ES	Futures	1461.25	1461.76	1457.68	1458.95	261860.0
2012-09-26 16:00:00	ES	Futures	1458.95	1460.74	1457.68	1460.49	96490.0
2012-09-26 17:00:00	ES	Futures	1460.49	1461.25	1460.23	1461.0	2377.0
2012-09-26 18:00:00	ES	Futures	1461.25	1462.02	1460.74	1461.0	3602.0
2012-09-26 19:00:00	ES	Futures	1461.25	1462.02	1460.49	1460.74	3618.0
2012-09-26 20:00:00	ES	Futures	1461.0	1461.76	1460.49	1461.25	4620.0
2012-09-26 21:00:00	ES	Futures	1461.51	1464.32	1461.25	1464.06	8462.0
2012-09-26 22:00:00	ES	Futures	1464.06	1464.83	1462.79	1463.55	6894.0
2012-09-26 23:00:00	ES	Futures	1463.55	1464.06	1462.79	1464.06	3543.0
2012-09-26 00:00:00	NQ	Futures	3260.85	3261.14	3257.07	3258.23	353.0
2012-09-26 01:00:00	NQ	Futures	3257.94	3260.56	3257.07	3257.07	744.0
2012-09-26 02:00:00	NQ	Futures	3257.36	3260.85	3256.78	3259.69	1014.0
2012-09-26 03:00:00	NQ	Futures	3259.69	3259.69	3251.84	3253.29	2943.0
2012-09-26 04:00:00	NQ	Futures	3253.0	3253.58	3249.52	3253.58	2561.0
2012-09-26 05:00:00	NQ	Futures	3253.58	3258.52	3252.71	3253.0	1176.0
2012-09-26 06:00:00	NQ	Futures	3253.0	3255.91	3252.13	3254.46	1206.0
2012-09-26 07:00:00	NQ	Futures	3254.46	3255.04	3246.9	3250.39	2550.0
2012-09-26 08:00:00	NQ	Futures	3250.39	3251.84	3244.29	3249.23	5775.0
2012-09-26 09:00:00	NQ	Futures	3249.52	3251.26	3234.99	3239.05	40559.0
2012-09-26 10:00:00	NQ	Futures	3239.05	3240.22	3210.58	3214.07	57374.0
2012-09-26 11:00:00	NQ	Futures	3214.07	3227.14	3213.77	3224.24	31309.0
2012-09-26 12:00:00	NQ	Futures	3224.24	3231.21	3220.17	3227.43	20824.0
2012-09-26 13:00:00	NQ	Futures	3227.43	3236.44	3224.53	3224.53	17993.0
2012-09-26 14:00:00	NQ	Futures	3224.53	3239.35	3224.53	3232.37	25386.0
2012-09-26 15:00:00	NQ	Futures	3232.66	3232.95	3222.2	3227.72	31952.0
2012-09-26 16:00:00	NQ	Futures	3227.72	3230.34	3223.07	3229.76	6348.0
2012-09-26 17:00:00	NQ	Futures	3229.76	3231.21	3229.47	3230.34	343.0
2012-09-26 18:00:00	NQ	Futures	3230.63	3232.95	3229.76	3231.5	398.0
2012-09-26 19:00:00	NQ	Futures	3231.5	3233.53	3230.34	3231.21	372.0
2012-09-26 20:00:00	NQ	Futures	3230.92	3232.95	3230.05	3231.5	324.0
2012-09-26 21:00:00	NQ	Futures	3232.08	3237.89	3230.92	3237.31	696.0
2012-09-26 22:00:00	NQ	Futures	3237.6	3238.47	3234.7	3236.44	518.0
2012-09-26 23:00:00	NQ	Futures	3236.44	3236.44	3232.95	3234.99	1015.0
2012-09-26 00:00:00	YM	Futures	13425.9	13425.9	13410.9	13416.9	373.0
2012-09-26 01:00:00	YM	Futures	13416.9	13426.9	13415.9	13418.9	488.0

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

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