PREVIEW / futures_1hour / 2012-08-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1427.8	1428.31	1427.04	1428.06	2050.0
2012-08-14 01:00:00	ES	Futures	1428.06	1429.33	1427.55	1429.33	2651.0
2012-08-14 02:00:00	ES	Futures	1429.33	1430.34	1428.56	1428.82	7254.0
2012-08-14 03:00:00	ES	Futures	1429.07	1431.87	1428.82	1431.36	23831.0
2012-08-14 04:00:00	ES	Futures	1431.36	1431.87	1429.33	1429.84	15343.0
2012-08-14 05:00:00	ES	Futures	1429.84	1431.11	1429.07	1429.58	16480.0
2012-08-14 06:00:00	ES	Futures	1429.58	1430.34	1428.56	1429.07	14334.0
2012-08-14 07:00:00	ES	Futures	1429.07	1429.58	1427.8	1429.58	18278.0
2012-08-14 08:00:00	ES	Futures	1429.58	1433.65	1429.07	1430.85	92889.0
2012-08-14 09:00:00	ES	Futures	1431.11	1432.12	1426.28	1428.06	200728.0
2012-08-14 10:00:00	ES	Futures	1428.06	1429.84	1426.02	1428.82	301485.0
2012-08-14 11:00:00	ES	Futures	1428.56	1431.11	1428.06	1430.09	150936.0
2012-08-14 12:00:00	ES	Futures	1430.09	1430.6	1426.78	1428.06	98347.0
2012-08-14 13:00:00	ES	Futures	1428.06	1428.56	1426.28	1427.8	57623.0
2012-08-14 14:00:00	ES	Futures	1427.8	1428.56	1426.53	1428.56	57977.0
2012-08-14 15:00:00	ES	Futures	1428.56	1428.56	1421.19	1425.26	267292.0
2012-08-14 16:00:00	ES	Futures	1425.51	1426.78	1423.73	1424.75	73470.0
2012-08-14 17:00:00	ES	Futures	1424.75	1424.75	1424.24	1424.5	973.0
2012-08-14 18:00:00	ES	Futures	1424.24	1424.75	1423.73	1423.99	1947.0
2012-08-14 19:00:00	ES	Futures	1423.99	1424.24	1423.48	1424.24	1703.0
2012-08-14 20:00:00	ES	Futures	1424.24	1424.75	1422.46	1422.46	3670.0
2012-08-14 21:00:00	ES	Futures	1422.46	1422.72	1421.44	1421.95	4416.0
2012-08-14 22:00:00	ES	Futures	1422.21	1422.97	1421.95	1422.72	3256.0
2012-08-14 23:00:00	ES	Futures	1422.72	1422.72	1421.7	1421.95	2049.0
2012-08-14 00:00:00	NQ	Futures	3169.89	3171.34	3169.31	3170.18	268.0
2012-08-14 01:00:00	NQ	Futures	3171.34	3173.08	3169.31	3173.08	290.0
2012-08-14 02:00:00	NQ	Futures	3173.08	3173.95	3170.18	3170.47	957.0
2012-08-14 03:00:00	NQ	Futures	3170.47	3175.11	3169.89	3173.66	2723.0
2012-08-14 04:00:00	NQ	Futures	3173.95	3174.53	3168.73	3169.89	1782.0
2012-08-14 05:00:00	NQ	Futures	3169.31	3171.63	3167.86	3169.02	1646.0
2012-08-14 06:00:00	NQ	Futures	3168.44	3170.18	3166.7	3167.57	1343.0
2012-08-14 07:00:00	NQ	Futures	3167.57	3169.6	3165.54	3169.31	2437.0
2012-08-14 08:00:00	NQ	Futures	3169.6	3178.88	3168.15	3176.27	9342.0
2012-08-14 09:00:00	NQ	Futures	3175.98	3178.01	3166.99	3173.37	31749.0
2012-08-14 10:00:00	NQ	Futures	3173.37	3176.56	3166.41	3176.56	33034.0
2012-08-14 11:00:00	NQ	Futures	3176.85	3180.62	3175.11	3176.27	20352.0
2012-08-14 12:00:00	NQ	Futures	3176.27	3178.01	3163.51	3168.15	18448.0
2012-08-14 13:00:00	NQ	Futures	3168.44	3172.5	3164.67	3170.76	11808.0
2012-08-14 14:00:00	NQ	Futures	3170.47	3171.63	3164.96	3171.34	12619.0
2012-08-14 15:00:00	NQ	Futures	3171.05	3171.63	3154.82	3162.93	29411.0
2012-08-14 16:00:00	NQ	Futures	3162.93	3164.96	3156.56	3159.75	6312.0
2012-08-14 17:00:00	NQ	Futures	3159.46	3159.75	3158.01	3159.46	83.0
2012-08-14 18:00:00	NQ	Futures	3159.17	3160.04	3158.59	3158.88	270.0
2012-08-14 19:00:00	NQ	Futures	3158.59	3159.46	3158.01	3159.46	144.0
2012-08-14 20:00:00	NQ	Futures	3159.46	3160.04	3155.4	3155.69	237.0
2012-08-14 21:00:00	NQ	Futures	3155.69	3156.85	3154.24	3155.4	409.0
2012-08-14 22:00:00	NQ	Futures	3155.69	3157.43	3154.82	3157.43	260.0
2012-08-14 23:00:00	NQ	Futures	3157.43	3157.43	3154.82	3155.11	318.0
2012-08-14 00:00:00	YM	Futures	13073.4	13077.4	13066.5	13076.4	233.0
2012-08-14 01:00:00	YM	Futures	13075.4	13085.3	13072.4	13085.3	353.0

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

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