PREVIEW / futures_1hour / 2012-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-09.parquet
  size:    48 KB
  rows:    1,482

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-09 00:00:00	ES	Futures	1484.76	1484.76	1483.48	1483.99	2153.0
2012-10-09 01:00:00	ES	Futures	1483.99	1485.27	1483.22	1484.76	5004.0
2012-10-09 02:00:00	ES	Futures	1485.01	1485.27	1483.22	1483.48	5624.0
2012-10-09 03:00:00	ES	Futures	1483.48	1484.24	1477.09	1478.88	55569.0
2012-10-09 04:00:00	ES	Futures	1478.88	1480.67	1478.37	1479.65	26120.0
2012-10-09 05:00:00	ES	Futures	1479.65	1481.43	1477.86	1480.41	22924.0
2012-10-09 06:00:00	ES	Futures	1480.41	1481.43	1479.9	1480.41	13010.0
2012-10-09 07:00:00	ES	Futures	1480.67	1482.97	1480.67	1482.2	21914.0
2012-10-09 08:00:00	ES	Futures	1482.46	1485.52	1481.69	1483.73	50473.0
2012-10-09 09:00:00	ES	Futures	1483.48	1483.99	1478.62	1478.88	225124.0
2012-10-09 10:00:00	ES	Futures	1479.13	1481.94	1470.96	1472.24	346241.0
2012-10-09 11:00:00	ES	Futures	1472.49	1472.49	1468.15	1469.94	354658.0
2012-10-09 12:00:00	ES	Futures	1469.94	1473.0	1468.92	1469.17	149121.0
2012-10-09 13:00:00	ES	Futures	1469.43	1473.0	1468.92	1470.96	104759.0
2012-10-09 14:00:00	ES	Futures	1470.96	1473.26	1469.68	1472.75	124317.0
2012-10-09 15:00:00	ES	Futures	1472.75	1473.77	1467.13	1467.89	304455.0
2012-10-09 16:00:00	ES	Futures	1467.89	1469.17	1466.62	1468.66	119867.0
2012-10-09 17:00:00	ES	Futures	1468.66	1468.92	1467.64	1468.41	4189.0
2012-10-09 18:00:00	ES	Futures	1468.15	1468.66	1465.85	1465.85	5167.0
2012-10-09 19:00:00	ES	Futures	1466.11	1466.62	1462.53	1463.81	8300.0
2012-10-09 20:00:00	ES	Futures	1463.81	1465.34	1463.81	1464.57	7833.0
2012-10-09 21:00:00	ES	Futures	1464.57	1466.11	1464.06	1465.34	4148.0
2012-10-09 22:00:00	ES	Futures	1465.34	1465.34	1463.55	1464.06	4200.0
2012-10-09 23:00:00	ES	Futures	1464.06	1467.38	1464.06	1466.87	5914.0
2012-10-09 00:00:00	NQ	Futures	3236.15	3236.44	3232.95	3233.53	616.0
2012-10-09 01:00:00	NQ	Futures	3233.82	3236.15	3232.37	3235.86	525.0
2012-10-09 02:00:00	NQ	Futures	3235.57	3236.44	3232.66	3232.66	408.0
2012-10-09 03:00:00	NQ	Futures	3232.95	3234.41	3216.1	3219.59	6219.0
2012-10-09 04:00:00	NQ	Futures	3219.3	3222.49	3217.84	3219.01	2082.0
2012-10-09 05:00:00	NQ	Futures	3219.01	3221.33	3215.81	3219.3	1992.0
2012-10-09 06:00:00	NQ	Futures	3219.3	3221.91	3218.42	3221.04	1409.0
2012-10-09 07:00:00	NQ	Futures	3221.33	3226.56	3220.75	3225.69	2609.0
2012-10-09 08:00:00	NQ	Futures	3225.4	3230.92	3224.24	3227.43	4499.0
2012-10-09 09:00:00	NQ	Futures	3227.14	3228.59	3201.28	3203.02	57444.0
2012-10-09 10:00:00	NQ	Futures	3203.02	3210.87	3176.0	3181.52	64461.0
2012-10-09 11:00:00	NQ	Futures	3181.23	3183.55	3173.09	3180.07	50909.0
2012-10-09 12:00:00	NQ	Futures	3180.07	3189.95	3177.16	3180.65	33630.0
2012-10-09 13:00:00	NQ	Futures	3180.94	3191.98	3180.65	3186.75	24522.0
2012-10-09 14:00:00	NQ	Futures	3186.75	3192.85	3183.85	3190.24	28680.0
2012-10-09 15:00:00	NQ	Futures	3190.53	3192.56	3176.29	3181.23	41143.0
2012-10-09 16:00:00	NQ	Futures	3181.23	3182.39	3177.16	3180.65	10075.0
2012-10-09 17:00:00	NQ	Futures	3180.65	3181.23	3178.32	3180.07	362.0
2012-10-09 18:00:00	NQ	Futures	3178.91	3180.94	3175.13	3176.29	539.0
2012-10-09 19:00:00	NQ	Futures	3176.29	3178.03	3169.61	3171.35	846.0
2012-10-09 20:00:00	NQ	Futures	3171.64	3175.13	3171.35	3173.97	673.0
2012-10-09 21:00:00	NQ	Futures	3173.38	3176.58	3172.8	3175.42	542.0
2012-10-09 22:00:00	NQ	Futures	3175.42	3175.42	3171.64	3173.38	594.0
2012-10-09 23:00:00	NQ	Futures	3173.38	3181.52	3173.09	3180.94	1381.0
2012-10-09 00:00:00	YM	Futures	13538.0	13538.0	13529.0	13530.0	283.0
2012-10-09 01:00:00	YM	Futures	13531.0	13539.0	13525.0	13538.0	550.0

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

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