PREVIEW / futures_1hour / 2012-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-23.parquet
  size:    48 KB
  rows:    1,432

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-23 00:00:00	ES	Futures	1441.28	1441.79	1440.52	1440.52	2348.0
2012-08-23 01:00:00	ES	Futures	1440.52	1441.53	1440.26	1441.02	4332.0
2012-08-23 02:00:00	ES	Futures	1441.28	1441.28	1439.5	1440.77	7867.0
2012-08-23 03:00:00	ES	Futures	1441.02	1442.3	1439.5	1439.5	30711.0
2012-08-23 04:00:00	ES	Futures	1439.5	1440.26	1437.21	1438.99	33346.0
2012-08-23 05:00:00	ES	Futures	1438.99	1441.28	1438.99	1441.02	21347.0
2012-08-23 06:00:00	ES	Futures	1440.77	1441.02	1439.24	1440.01	11282.0
2012-08-23 07:00:00	ES	Futures	1439.75	1440.01	1434.67	1435.43	42325.0
2012-08-23 08:00:00	ES	Futures	1435.68	1436.45	1431.62	1432.12	69696.0
2012-08-23 09:00:00	ES	Futures	1432.12	1433.4	1426.78	1427.8	210343.0
2012-08-23 10:00:00	ES	Futures	1427.55	1430.85	1425.51	1429.33	304707.0
2012-08-23 11:00:00	ES	Futures	1429.33	1431.11	1427.29	1428.82	168853.0
2012-08-23 12:00:00	ES	Futures	1428.82	1429.33	1425.51	1426.02	137778.0
2012-08-23 13:00:00	ES	Futures	1425.77	1426.02	1421.95	1423.99	130288.0
2012-08-23 14:00:00	ES	Futures	1423.99	1426.78	1423.48	1425.0	72683.0
2012-08-23 15:00:00	ES	Futures	1425.26	1427.04	1422.97	1424.75	221323.0
2012-08-23 16:00:00	ES	Futures	1424.5	1425.0	1423.22	1424.24	78823.0
2012-08-23 17:00:00	ES	Futures	1424.24	1425.26	1423.99	1425.0	1392.0
2012-08-23 18:00:00	ES	Futures	1425.26	1425.77	1425.0	1425.26	2782.0
2012-08-23 19:00:00	ES	Futures	1425.26	1426.02	1425.0	1425.26	1883.0
2012-08-23 20:00:00	ES	Futures	1425.26	1426.02	1423.99	1424.5	5193.0
2012-08-23 21:00:00	ES	Futures	1424.5	1425.51	1423.99	1424.5	5125.0
2012-08-23 22:00:00	ES	Futures	1424.5	1425.77	1424.5	1425.26	2297.0
2012-08-23 23:00:00	ES	Futures	1425.26	1425.26	1423.99	1425.0	2189.0
2012-08-23 00:00:00	NQ	Futures	3235.99	3235.99	3233.38	3233.38	652.0
2012-08-23 01:00:00	NQ	Futures	3233.38	3235.7	3233.09	3235.41	345.0
2012-08-23 02:00:00	NQ	Futures	3234.54	3235.41	3231.06	3234.83	626.0
2012-08-23 03:00:00	NQ	Futures	3234.83	3238.02	3232.51	3232.51	2204.0
2012-08-23 04:00:00	NQ	Futures	3232.51	3234.25	3226.13	3229.61	3210.0
2012-08-23 05:00:00	NQ	Futures	3229.9	3234.83	3229.61	3233.67	1132.0
2012-08-23 06:00:00	NQ	Futures	3233.96	3234.25	3230.48	3232.51	844.0
2012-08-23 07:00:00	NQ	Futures	3232.51	3233.09	3221.78	3223.52	2858.0
2012-08-23 08:00:00	NQ	Futures	3223.81	3225.55	3214.53	3215.69	6998.0
2012-08-23 09:00:00	NQ	Futures	3215.69	3217.43	3200.62	3202.36	33932.0
2012-08-23 10:00:00	NQ	Futures	3202.36	3213.95	3194.24	3211.64	43616.0
2012-08-23 11:00:00	NQ	Futures	3211.64	3223.81	3207.87	3213.37	27003.0
2012-08-23 12:00:00	NQ	Futures	3213.37	3213.95	3201.49	3203.52	22028.0
2012-08-23 13:00:00	NQ	Futures	3203.81	3205.55	3193.37	3202.36	15879.0
2012-08-23 14:00:00	NQ	Futures	3202.36	3210.77	3200.04	3207.29	12763.0
2012-08-23 15:00:00	NQ	Futures	3207.29	3215.11	3200.62	3202.36	27427.0
2012-08-23 16:00:00	NQ	Futures	3202.65	3203.81	3198.88	3200.62	7867.0
2012-08-23 17:00:00	NQ	Futures	3200.62	3202.94	3200.33	3202.94	66.0
2012-08-23 18:00:00	NQ	Futures	3202.65	3203.23	3201.49	3202.07	232.0
2012-08-23 19:00:00	NQ	Futures	3202.36	3204.1	3201.78	3203.23	172.0
2012-08-23 20:00:00	NQ	Futures	3202.94	3204.39	3200.62	3201.49	288.0
2012-08-23 21:00:00	NQ	Futures	3200.91	3203.52	3200.62	3201.78	275.0
2012-08-23 22:00:00	NQ	Futures	3201.78	3204.1	3201.78	3203.23	373.0
2012-08-23 23:00:00	NQ	Futures	3203.23	3203.52	3201.2	3203.52	295.0
2012-08-23 00:00:00	YM	Futures	13129.1	13129.1	13118.2	13120.1	428.0
2012-08-23 01:00:00	YM	Futures	13120.1	13127.1	13117.2	13124.1	371.0

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

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