PREVIEW / futures_1hour / 2012-10-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1484.5	1484.76	1483.99	1484.24	1192.0
2012-10-08 01:00:00	ES	Futures	1484.24	1485.01	1483.99	1484.24	2418.0
2012-10-08 02:00:00	ES	Futures	1484.24	1486.29	1484.24	1486.03	5857.0
2012-10-08 03:00:00	ES	Futures	1485.78	1485.78	1481.18	1481.69	42490.0
2012-10-08 04:00:00	ES	Futures	1481.69	1482.71	1480.67	1482.2	20790.0
2012-10-08 05:00:00	ES	Futures	1482.2	1482.46	1481.43	1481.43	10431.0
2012-10-08 06:00:00	ES	Futures	1481.43	1482.2	1480.16	1481.69	14768.0
2012-10-08 07:00:00	ES	Futures	1481.69	1482.2	1480.41	1481.43	13840.0
2012-10-08 08:00:00	ES	Futures	1481.69	1483.73	1481.18	1481.94	26735.0
2012-10-08 09:00:00	ES	Futures	1481.69	1482.71	1479.65	1481.69	140223.0
2012-10-08 10:00:00	ES	Futures	1481.43	1484.24	1479.65	1482.2	187190.0
2012-10-08 11:00:00	ES	Futures	1482.46	1483.22	1479.13	1480.92	159517.0
2012-10-08 12:00:00	ES	Futures	1480.92	1482.46	1480.16	1482.2	56270.0
2012-10-08 13:00:00	ES	Futures	1482.46	1482.97	1480.92	1481.69	44388.0
2012-10-08 14:00:00	ES	Futures	1481.69	1482.71	1481.18	1481.94	37019.0
2012-10-08 15:00:00	ES	Futures	1481.94	1485.27	1481.94	1482.46	123813.0
2012-10-08 16:00:00	ES	Futures	1482.46	1482.97	1480.67	1480.92	49289.0
2012-10-08 17:00:00	ES	Futures	1480.92	1481.69	1480.92	1481.43	942.0
2012-10-08 18:00:00	ES	Futures	1481.43	1481.43	1480.41	1481.18	1611.0
2012-10-08 19:00:00	ES	Futures	1481.43	1483.22	1481.18	1482.97	3167.0
2012-10-08 20:00:00	ES	Futures	1483.22	1485.01	1482.71	1484.5	6784.0
2012-10-08 21:00:00	ES	Futures	1484.76	1485.52	1484.24	1484.76	4874.0
2012-10-08 22:00:00	ES	Futures	1485.01	1486.29	1484.76	1485.27	6117.0
2012-10-08 23:00:00	ES	Futures	1485.01	1485.52	1484.5	1484.76	2155.0
2012-10-08 00:00:00	NQ	Futures	3252.71	3252.71	3251.26	3252.13	330.0
2012-10-08 01:00:00	NQ	Futures	3252.13	3253.87	3251.26	3251.84	151.0
2012-10-08 02:00:00	NQ	Futures	3251.55	3256.78	3251.55	3255.04	576.0
2012-10-08 03:00:00	NQ	Futures	3255.04	3255.04	3244.58	3245.16	3959.0
2012-10-08 04:00:00	NQ	Futures	3244.58	3246.32	3241.67	3245.16	1741.0
2012-10-08 05:00:00	NQ	Futures	3245.16	3245.45	3242.83	3242.83	1011.0
2012-10-08 06:00:00	NQ	Futures	3243.12	3243.99	3239.64	3243.7	1273.0
2012-10-08 07:00:00	NQ	Futures	3243.41	3245.16	3240.8	3243.99	1613.0
2012-10-08 08:00:00	NQ	Futures	3243.99	3247.77	3241.38	3243.12	4616.0
2012-10-08 09:00:00	NQ	Futures	3242.83	3246.61	3231.21	3243.99	40699.0
2012-10-08 10:00:00	NQ	Futures	3244.29	3250.39	3231.21	3237.6	34942.0
2012-10-08 11:00:00	NQ	Futures	3237.89	3239.64	3224.82	3232.95	28441.0
2012-10-08 12:00:00	NQ	Futures	3232.95	3234.99	3227.72	3231.21	14889.0
2012-10-08 13:00:00	NQ	Futures	3231.21	3234.7	3226.85	3229.18	12900.0
2012-10-08 14:00:00	NQ	Futures	3229.18	3232.08	3226.56	3229.18	8995.0
2012-10-08 15:00:00	NQ	Futures	3229.47	3241.09	3229.18	3232.95	27130.0
2012-10-08 16:00:00	NQ	Futures	3232.95	3233.82	3226.56	3227.43	5500.0
2012-10-08 17:00:00	NQ	Futures	3227.43	3228.59	3227.14	3227.72	77.0
2012-10-08 18:00:00	NQ	Futures	3227.43	3228.88	3226.85	3228.01	170.0
2012-10-08 19:00:00	NQ	Futures	3228.3	3232.37	3228.3	3232.37	286.0
2012-10-08 20:00:00	NQ	Futures	3232.08	3235.57	3231.79	3234.7	816.0
2012-10-08 21:00:00	NQ	Futures	3234.7	3237.6	3234.41	3235.57	525.0
2012-10-08 22:00:00	NQ	Futures	3235.86	3239.05	3235.86	3237.02	565.0
2012-10-08 23:00:00	NQ	Futures	3236.73	3237.89	3235.86	3236.15	204.0
2012-10-08 00:00:00	YM	Futures	13520.0	13521.0	13515.0	13520.0	185.0
2012-10-08 01:00:00	YM	Futures	13520.0	13524.0	13516.0	13519.0	205.0

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

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