PREVIEW / futures_1hour / 2012-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-13.parquet
  size:    46 KB
  rows:    1,417

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-08-13 00:00:00	ES	Futures	1421.95	1422.72	1421.7	1422.21	1588.0
2012-08-13 01:00:00	ES	Futures	1422.21	1422.72	1421.7	1421.7	2177.0
2012-08-13 02:00:00	ES	Futures	1421.7	1422.46	1420.68	1422.46	6520.0
2012-08-13 03:00:00	ES	Futures	1422.21	1423.73	1420.94	1421.95	20021.0
2012-08-13 04:00:00	ES	Futures	1421.95	1423.73	1421.44	1423.22	13155.0
2012-08-13 05:00:00	ES	Futures	1423.48	1425.77	1423.48	1424.24	19772.0
2012-08-13 06:00:00	ES	Futures	1424.24	1426.53	1423.73	1426.28	15506.0
2012-08-13 07:00:00	ES	Futures	1426.53	1428.06	1425.77	1426.28	24458.0
2012-08-13 08:00:00	ES	Futures	1426.28	1426.53	1424.5	1425.0	23857.0
2012-08-13 09:00:00	ES	Futures	1424.75	1426.28	1422.46	1424.75	138301.0
2012-08-13 10:00:00	ES	Futures	1425.0	1425.77	1419.66	1419.66	239546.0
2012-08-13 11:00:00	ES	Futures	1419.92	1420.94	1418.14	1420.17	183162.0
2012-08-13 12:00:00	ES	Futures	1420.43	1421.95	1418.65	1421.7	121757.0
2012-08-13 13:00:00	ES	Futures	1421.7	1422.72	1420.17	1421.7	72751.0
2012-08-13 14:00:00	ES	Futures	1421.95	1426.02	1421.19	1424.75	99302.0
2012-08-13 15:00:00	ES	Futures	1424.75	1425.77	1422.97	1425.77	131073.0
2012-08-13 16:00:00	ES	Futures	1425.26	1427.04	1425.26	1426.02	66665.0
2012-08-13 17:00:00	ES	Futures	1426.02	1427.04	1425.77	1426.78	1628.0
2012-08-13 18:00:00	ES	Futures	1426.78	1426.78	1425.26	1425.51	2422.0
2012-08-13 19:00:00	ES	Futures	1425.51	1426.28	1425.26	1425.51	1938.0
2012-08-13 20:00:00	ES	Futures	1425.26	1426.78	1425.26	1426.53	3427.0
2012-08-13 21:00:00	ES	Futures	1426.53	1431.36	1426.53	1428.82	16882.0
2012-08-13 22:00:00	ES	Futures	1428.82	1429.07	1427.55	1428.56	3884.0
2012-08-13 23:00:00	ES	Futures	1428.56	1428.82	1427.55	1427.8	1917.0
2012-08-13 00:00:00	NQ	Futures	3147.28	3148.44	3146.41	3147.86	177.0
2012-08-13 01:00:00	NQ	Futures	3147.86	3148.73	3146.7	3146.99	233.0
2012-08-13 02:00:00	NQ	Futures	3146.99	3148.15	3144.96	3147.86	456.0
2012-08-13 03:00:00	NQ	Futures	3147.86	3151.05	3144.67	3147.28	1670.0
2012-08-13 04:00:00	NQ	Futures	3147.57	3151.92	3145.83	3151.05	1212.0
2012-08-13 05:00:00	NQ	Futures	3151.34	3155.69	3151.34	3152.21	2468.0
2012-08-13 06:00:00	NQ	Futures	3151.92	3156.85	3151.34	3156.56	1093.0
2012-08-13 07:00:00	NQ	Futures	3156.85	3160.62	3155.69	3156.56	2280.0
2012-08-13 08:00:00	NQ	Futures	3156.56	3157.14	3153.37	3155.11	2547.0
2012-08-13 09:00:00	NQ	Futures	3155.11	3159.75	3149.89	3155.11	21749.0
2012-08-13 10:00:00	NQ	Futures	3155.11	3158.3	3142.93	3142.93	30153.0
2012-08-13 11:00:00	NQ	Futures	3143.22	3148.15	3137.42	3146.41	22277.0
2012-08-13 12:00:00	NQ	Futures	3146.41	3152.79	3142.93	3152.79	13041.0
2012-08-13 13:00:00	NQ	Futures	3152.79	3154.82	3149.89	3153.08	9504.0
2012-08-13 14:00:00	NQ	Futures	3153.08	3161.49	3151.63	3158.88	11529.0
2012-08-13 15:00:00	NQ	Futures	3159.17	3162.07	3155.11	3162.07	20064.0
2012-08-13 16:00:00	NQ	Futures	3162.07	3165.25	3162.07	3163.51	4994.0
2012-08-13 17:00:00	NQ	Futures	3163.51	3164.96	3163.22	3164.96	132.0
2012-08-13 18:00:00	NQ	Futures	3164.96	3164.96	3162.07	3162.07	360.0
2012-08-13 19:00:00	NQ	Futures	3162.07	3163.22	3161.2	3161.49	100.0
2012-08-13 20:00:00	NQ	Futures	3161.49	3164.67	3161.49	3164.67	308.0
2012-08-13 21:00:00	NQ	Futures	3164.67	3174.53	3164.67	3171.92	1980.0
2012-08-13 22:00:00	NQ	Futures	3171.63	3172.21	3169.02	3171.63	575.0
2012-08-13 23:00:00	NQ	Futures	3171.34	3171.34	3169.6	3169.89	388.0
2012-08-13 00:00:00	YM	Futures	13064.5	13068.4	13062.5	13066.5	235.0
2012-08-13 01:00:00	YM	Futures	13065.5	13070.4	13061.5	13061.5	292.0

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

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