PREVIEW / futures_1hour / 2012-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-03.parquet
  size:    49 KB
  rows:    1,511

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-10-03 00:00:00	ES	Futures	1469.17	1469.94	1468.66	1469.68	2318.0
2012-10-03 01:00:00	ES	Futures	1469.68	1470.45	1468.92	1470.19	2481.0
2012-10-03 02:00:00	ES	Futures	1469.94	1469.94	1467.64	1468.66	8258.0
2012-10-03 03:00:00	ES	Futures	1468.66	1469.94	1467.38	1469.43	32892.0
2012-10-03 04:00:00	ES	Futures	1469.68	1472.24	1469.43	1470.7	22953.0
2012-10-03 05:00:00	ES	Futures	1470.96	1474.03	1470.7	1473.0	22784.0
2012-10-03 06:00:00	ES	Futures	1473.26	1473.77	1471.22	1471.47	12094.0
2012-10-03 07:00:00	ES	Futures	1471.47	1473.0	1470.96	1472.49	22435.0
2012-10-03 08:00:00	ES	Futures	1472.49	1475.3	1471.98	1474.28	71165.0
2012-10-03 09:00:00	ES	Futures	1474.54	1475.05	1468.66	1469.68	172969.0
2012-10-03 10:00:00	ES	Futures	1469.94	1475.3	1466.87	1472.49	332987.0
2012-10-03 11:00:00	ES	Futures	1472.49	1479.39	1472.24	1478.37	257633.0
2012-10-03 12:00:00	ES	Futures	1478.62	1480.41	1477.6	1479.13	82686.0
2012-10-03 13:00:00	ES	Futures	1479.13	1479.39	1473.77	1475.05	108024.0
2012-10-03 14:00:00	ES	Futures	1475.05	1476.32	1473.0	1474.54	102663.0
2012-10-03 15:00:00	ES	Futures	1474.28	1477.6	1472.49	1476.84	189978.0
2012-10-03 16:00:00	ES	Futures	1477.09	1477.6	1475.56	1476.84	73229.0
2012-10-03 17:00:00	ES	Futures	1476.84	1478.88	1476.58	1478.11	3767.0
2012-10-03 18:00:00	ES	Futures	1478.11	1481.18	1477.6	1479.65	7858.0
2012-10-03 19:00:00	ES	Futures	1479.9	1479.9	1478.37	1479.13	4234.0
2012-10-03 20:00:00	ES	Futures	1478.88	1479.65	1478.37	1479.39	3575.0
2012-10-03 21:00:00	ES	Futures	1479.13	1479.65	1476.58	1477.86	7323.0
2012-10-03 22:00:00	ES	Futures	1477.6	1484.24	1477.6	1483.73	17157.0
2012-10-03 23:00:00	ES	Futures	1483.73	1484.24	1482.71	1483.48	6583.0
2012-10-03 00:00:00	NQ	Futures	3244.87	3246.32	3243.99	3245.74	213.0
2012-10-03 01:00:00	NQ	Futures	3245.45	3247.19	3244.87	3246.9	252.0
2012-10-03 02:00:00	NQ	Futures	3246.03	3246.03	3241.09	3242.83	593.0
2012-10-03 03:00:00	NQ	Futures	3243.12	3246.9	3240.51	3246.61	2843.0
2012-10-03 04:00:00	NQ	Futures	3246.61	3253.29	3246.61	3249.81	1742.0
2012-10-03 05:00:00	NQ	Futures	3249.81	3257.07	3249.52	3254.46	1675.0
2012-10-03 06:00:00	NQ	Futures	3254.46	3255.04	3250.1	3251.84	1670.0
2012-10-03 07:00:00	NQ	Futures	3252.13	3254.16	3248.93	3253.0	2838.0
2012-10-03 08:00:00	NQ	Futures	3253.0	3259.98	3251.55	3256.2	8517.0
2012-10-03 09:00:00	NQ	Futures	3256.49	3261.43	3248.35	3251.55	25369.0
2012-10-03 10:00:00	NQ	Futures	3251.55	3263.46	3243.41	3255.91	40854.0
2012-10-03 11:00:00	NQ	Futures	3255.62	3272.18	3255.04	3270.15	32125.0
2012-10-03 12:00:00	NQ	Futures	3270.15	3274.51	3266.66	3270.73	14264.0
2012-10-03 13:00:00	NQ	Futures	3270.73	3270.73	3256.49	3259.4	17459.0
2012-10-03 14:00:00	NQ	Futures	3259.1	3263.46	3255.33	3259.98	15944.0
2012-10-03 15:00:00	NQ	Futures	3259.69	3270.44	3255.91	3268.11	27230.0
2012-10-03 16:00:00	NQ	Futures	3268.4	3268.4	3264.04	3266.37	7845.0
2012-10-03 17:00:00	NQ	Futures	3266.37	3270.44	3266.08	3269.57	288.0
2012-10-03 18:00:00	NQ	Futures	3269.86	3276.54	3268.11	3271.89	724.0
2012-10-03 19:00:00	NQ	Futures	3272.18	3272.18	3269.57	3270.73	495.0
2012-10-03 20:00:00	NQ	Futures	3270.15	3272.18	3269.57	3271.31	533.0
2012-10-03 21:00:00	NQ	Futures	3271.31	3271.89	3266.08	3268.11	824.0
2012-10-03 22:00:00	NQ	Futures	3268.11	3282.93	3268.11	3281.77	2276.0
2012-10-03 23:00:00	NQ	Futures	3281.77	3284.38	3280.61	3282.64	1509.0
2012-10-03 00:00:00	YM	Futures	13394.9	13398.9	13389.9	13398.9	295.0
2012-10-03 01:00:00	YM	Futures	13397.9	13402.9	13393.9	13399.9	238.0

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

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