PREVIEW / futures_1hour / 2012-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-07.parquet
  size:    49 KB
  rows:    1,472

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-07 00:00:00	ES	Futures	1414.83	1415.34	1414.07	1414.58	2389.0
2012-08-07 01:00:00	ES	Futures	1414.32	1414.83	1413.31	1414.07	4386.0
2012-08-07 02:00:00	ES	Futures	1414.07	1415.09	1413.05	1414.58	6231.0
2012-08-07 03:00:00	ES	Futures	1414.58	1419.92	1413.82	1419.41	51183.0
2012-08-07 04:00:00	ES	Futures	1419.66	1419.66	1416.36	1416.87	30672.0
2012-08-07 05:00:00	ES	Futures	1417.12	1417.88	1415.09	1415.6	22206.0
2012-08-07 06:00:00	ES	Futures	1415.34	1418.39	1414.32	1417.88	23250.0
2012-08-07 07:00:00	ES	Futures	1417.88	1419.66	1417.38	1418.65	27494.0
2012-08-07 08:00:00	ES	Futures	1418.39	1421.7	1418.14	1419.16	42634.0
2012-08-07 09:00:00	ES	Futures	1419.41	1422.72	1418.65	1422.21	167651.0
2012-08-07 10:00:00	ES	Futures	1422.46	1424.5	1421.19	1423.22	289025.0
2012-08-07 11:00:00	ES	Futures	1423.22	1426.53	1421.19	1426.28	242901.0
2012-08-07 12:00:00	ES	Futures	1426.28	1427.29	1425.26	1426.28	108191.0
2012-08-07 13:00:00	ES	Futures	1426.28	1426.78	1425.51	1426.02	53181.0
2012-08-07 14:00:00	ES	Futures	1425.77	1426.02	1423.48	1423.99	68724.0
2012-08-07 15:00:00	ES	Futures	1423.99	1424.24	1420.43	1420.94	233732.0
2012-08-07 16:00:00	ES	Futures	1420.94	1422.21	1419.66	1420.94	67848.0
2012-08-07 17:00:00	ES	Futures	1421.19	1421.44	1419.66	1419.66	2142.0
2012-08-07 18:00:00	ES	Futures	1419.92	1421.19	1419.92	1420.68	1822.0
2012-08-07 19:00:00	ES	Futures	1420.68	1421.19	1419.41	1419.92	2510.0
2012-08-07 20:00:00	ES	Futures	1419.66	1419.92	1418.14	1418.9	8760.0
2012-08-07 21:00:00	ES	Futures	1418.9	1420.43	1418.65	1419.66	4884.0
2012-08-07 22:00:00	ES	Futures	1419.92	1420.43	1419.41	1419.41	1847.0
2012-08-07 23:00:00	ES	Futures	1419.41	1419.92	1418.39	1418.9	3359.0
2012-08-07 00:00:00	NQ	Futures	3123.22	3125.25	3122.93	3124.09	1160.0
2012-08-07 01:00:00	NQ	Futures	3124.09	3125.54	3121.77	3124.09	1312.0
2012-08-07 02:00:00	NQ	Futures	3124.09	3124.96	3121.48	3124.96	1047.0
2012-08-07 03:00:00	NQ	Futures	3124.67	3135.69	3122.64	3135.11	5030.0
2012-08-07 04:00:00	NQ	Futures	3135.11	3136.27	3129.89	3131.63	3373.0
2012-08-07 05:00:00	NQ	Futures	3131.92	3133.66	3127.86	3129.02	2368.0
2012-08-07 06:00:00	NQ	Futures	3129.02	3134.53	3126.99	3132.79	1727.0
2012-08-07 07:00:00	NQ	Futures	3132.79	3135.11	3131.05	3132.5	3245.0
2012-08-07 08:00:00	NQ	Futures	3132.5	3138.58	3131.63	3133.08	6511.0
2012-08-07 09:00:00	NQ	Futures	3133.37	3138.29	3126.99	3134.53	29447.0
2012-08-07 10:00:00	NQ	Futures	3134.53	3144.38	3132.5	3142.06	33053.0
2012-08-07 11:00:00	NQ	Futures	3142.06	3153.66	3135.98	3152.21	26570.0
2012-08-07 12:00:00	NQ	Futures	3152.21	3157.43	3150.76	3153.08	16143.0
2012-08-07 13:00:00	NQ	Futures	3153.08	3154.53	3150.18	3152.21	7697.0
2012-08-07 14:00:00	NQ	Futures	3152.21	3153.37	3148.44	3150.18	11483.0
2012-08-07 15:00:00	NQ	Futures	3150.18	3150.76	3142.06	3144.67	26539.0
2012-08-07 16:00:00	NQ	Futures	3144.38	3148.15	3139.16	3142.35	7968.0
2012-08-07 17:00:00	NQ	Futures	3142.64	3142.93	3139.45	3139.45	175.0
2012-08-07 18:00:00	NQ	Futures	3140.03	3141.77	3139.45	3141.48	182.0
2012-08-07 19:00:00	NQ	Futures	3141.77	3142.06	3140.03	3140.03	375.0
2012-08-07 20:00:00	NQ	Futures	3140.03	3140.32	3137.42	3139.74	673.0
2012-08-07 21:00:00	NQ	Futures	3139.45	3143.8	3138.87	3143.22	843.0
2012-08-07 22:00:00	NQ	Futures	3142.93	3144.96	3142.64	3142.64	561.0
2012-08-07 23:00:00	NQ	Futures	3142.64	3143.8	3141.19	3142.35	904.0
2012-08-07 00:00:00	YM	Futures	13002.8	13008.8	12995.8	12998.8	363.0
2012-08-07 01:00:00	YM	Futures	12998.8	13002.8	12989.9	12996.8	415.0

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

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