PREVIEW / futures_1hour / 2012-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-17.parquet
  size:    50 KB
  rows:    1,515

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-17 00:00:00	ES	Futures	1479.39	1479.65	1477.86	1478.62	3286.0
2012-10-17 01:00:00	ES	Futures	1478.62	1479.65	1477.86	1479.13	4407.0
2012-10-17 02:00:00	ES	Futures	1479.13	1480.67	1479.13	1479.65	12419.0
2012-10-17 03:00:00	ES	Futures	1479.65	1481.69	1478.62	1479.39	27922.0
2012-10-17 04:00:00	ES	Futures	1479.39	1481.43	1479.13	1479.9	20072.0
2012-10-17 05:00:00	ES	Futures	1479.9	1482.2	1479.9	1481.69	18027.0
2012-10-17 06:00:00	ES	Futures	1481.69	1483.22	1481.43	1482.71	17156.0
2012-10-17 07:00:00	ES	Futures	1482.46	1484.76	1482.46	1483.73	36079.0
2012-10-17 08:00:00	ES	Futures	1483.48	1486.03	1482.2	1484.76	78484.0
2012-10-17 09:00:00	ES	Futures	1484.76	1485.78	1480.16	1484.76	235392.0
2012-10-17 10:00:00	ES	Futures	1484.76	1488.59	1484.5	1486.8	245973.0
2012-10-17 11:00:00	ES	Futures	1486.8	1487.82	1485.01	1487.31	188747.0
2012-10-17 12:00:00	ES	Futures	1487.31	1489.61	1487.05	1488.33	95010.0
2012-10-17 13:00:00	ES	Futures	1488.33	1488.84	1482.97	1484.76	113547.0
2012-10-17 14:00:00	ES	Futures	1484.76	1488.33	1484.5	1487.82	91161.0
2012-10-17 15:00:00	ES	Futures	1487.57	1489.61	1487.05	1488.08	219515.0
2012-10-17 16:00:00	ES	Futures	1488.08	1490.12	1487.57	1489.1	80019.0
2012-10-17 17:00:00	ES	Futures	1488.84	1489.35	1488.33	1488.84	1259.0
2012-10-17 18:00:00	ES	Futures	1488.59	1489.1	1487.82	1488.08	2528.0
2012-10-17 19:00:00	ES	Futures	1488.33	1488.84	1487.82	1488.33	1875.0
2012-10-17 20:00:00	ES	Futures	1488.08	1488.84	1487.31	1487.82	3752.0
2012-10-17 21:00:00	ES	Futures	1487.82	1488.08	1487.05	1487.57	4503.0
2012-10-17 22:00:00	ES	Futures	1487.82	1489.61	1487.57	1489.35	4389.0
2012-10-17 23:00:00	ES	Futures	1489.61	1489.86	1488.59	1488.59	2870.0
2012-10-17 00:00:00	NQ	Futures	3205.93	3207.09	3203.9	3204.77	652.0
2012-10-17 01:00:00	NQ	Futures	3204.48	3207.67	3203.31	3207.09	521.0
2012-10-17 02:00:00	NQ	Futures	3207.38	3209.71	3207.09	3207.96	872.0
2012-10-17 03:00:00	NQ	Futures	3207.96	3212.03	3205.64	3207.38	2644.0
2012-10-17 04:00:00	NQ	Futures	3207.38	3212.03	3207.09	3209.71	1489.0
2012-10-17 05:00:00	NQ	Futures	3209.71	3214.65	3209.42	3213.77	1253.0
2012-10-17 06:00:00	NQ	Futures	3213.77	3216.68	3212.32	3214.36	2101.0
2012-10-17 07:00:00	NQ	Futures	3214.36	3216.68	3208.54	3209.71	3941.0
2012-10-17 08:00:00	NQ	Futures	3209.71	3212.61	3206.51	3209.71	6496.0
2012-10-17 09:00:00	NQ	Futures	3209.42	3221.33	3200.41	3219.3	47877.0
2012-10-17 10:00:00	NQ	Futures	3219.01	3229.76	3217.84	3221.04	53312.0
2012-10-17 11:00:00	NQ	Futures	3220.75	3228.3	3217.26	3226.27	21495.0
2012-10-17 12:00:00	NQ	Futures	3226.27	3229.76	3225.69	3227.14	11653.0
2012-10-17 13:00:00	NQ	Futures	3226.85	3228.3	3211.74	3213.19	19140.0
2012-10-17 14:00:00	NQ	Futures	3213.19	3220.17	3212.32	3218.42	14083.0
2012-10-17 15:00:00	NQ	Futures	3218.42	3226.56	3216.68	3219.59	27716.0
2012-10-17 16:00:00	NQ	Futures	3219.59	3223.36	3219.3	3221.33	6031.0
2012-10-17 17:00:00	NQ	Futures	3221.91	3221.91	3221.04	3221.33	55.0
2012-10-17 18:00:00	NQ	Futures	3221.91	3221.91	3219.59	3219.88	371.0
2012-10-17 19:00:00	NQ	Futures	3219.88	3221.33	3219.88	3220.75	122.0
2012-10-17 20:00:00	NQ	Futures	3220.17	3221.62	3219.3	3219.88	323.0
2012-10-17 21:00:00	NQ	Futures	3219.88	3220.75	3219.01	3220.17	418.0
2012-10-17 22:00:00	NQ	Futures	3220.75	3223.65	3220.17	3223.36	523.0
2012-10-17 23:00:00	NQ	Futures	3223.36	3224.24	3221.62	3221.62	379.0
2012-10-17 00:00:00	YM	Futures	13446.9	13451.9	13439.9	13443.9	749.0
2012-10-17 01:00:00	YM	Futures	13444.9	13451.9	13438.9	13449.9	691.0

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

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