PREVIEW / futures_1hour / 2012-03-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-28.parquet
  size:    48 KB
  rows:    1,476

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-03-28 00:00:00	ES	Futures	1424.3	1425.31	1423.04	1423.29	5112.0
2012-03-28 01:00:00	ES	Futures	1423.29	1425.06	1423.04	1424.3	3765.0
2012-03-28 02:00:00	ES	Futures	1424.05	1424.3	1422.53	1423.04	9050.0
2012-03-28 03:00:00	ES	Futures	1422.78	1428.6	1422.78	1427.59	38822.0
2012-03-28 04:00:00	ES	Futures	1427.34	1429.11	1424.05	1424.3	28375.0
2012-03-28 05:00:00	ES	Futures	1424.3	1426.07	1423.04	1425.06	19609.0
2012-03-28 06:00:00	ES	Futures	1425.06	1427.08	1424.05	1426.33	14231.0
2012-03-28 07:00:00	ES	Futures	1426.07	1427.59	1425.57	1425.82	29504.0
2012-03-28 08:00:00	ES	Futures	1425.57	1427.08	1421.77	1422.03	69987.0
2012-03-28 09:00:00	ES	Futures	1422.03	1425.57	1420.51	1422.53	209728.0
2012-03-28 10:00:00	ES	Futures	1422.53	1424.55	1417.47	1419.24	257402.0
2012-03-28 11:00:00	ES	Futures	1419.24	1419.75	1409.38	1412.16	339974.0
2012-03-28 12:00:00	ES	Futures	1412.41	1414.44	1411.4	1412.66	178982.0
2012-03-28 13:00:00	ES	Futures	1412.41	1413.93	1410.39	1411.91	97224.0
2012-03-28 14:00:00	ES	Futures	1411.91	1414.18	1408.62	1413.68	129382.0
2012-03-28 15:00:00	ES	Futures	1413.68	1417.72	1412.66	1417.22	222523.0
2012-03-28 16:00:00	ES	Futures	1416.97	1417.72	1415.95	1416.21	70340.0
2012-03-28 17:00:00	ES	Futures	1416.46	1417.47	1416.46	1417.22	1868.0
2012-03-28 18:00:00	ES	Futures	1417.22	1418.23	1416.97	1417.47	2771.0
2012-03-28 19:00:00	ES	Futures	1417.72	1418.23	1416.71	1417.72	3571.0
2012-03-28 20:00:00	ES	Futures	1417.98	1418.48	1416.71	1417.22	4916.0
2012-03-28 21:00:00	ES	Futures	1417.22	1417.22	1414.44	1414.69	6541.0
2012-03-28 22:00:00	ES	Futures	1414.69	1416.21	1414.18	1415.45	4005.0
2012-03-28 23:00:00	ES	Futures	1415.45	1417.47	1415.19	1416.71	3760.0
2012-03-28 00:00:00	NQ	Futures	3212.73	3214.75	3210.13	3210.42	573.0
2012-03-28 01:00:00	NQ	Futures	3210.42	3214.75	3210.42	3213.02	358.0
2012-03-28 02:00:00	NQ	Futures	3213.02	3213.6	3210.7	3211.28	857.0
2012-03-28 03:00:00	NQ	Futures	3211.57	3224.59	3211.57	3222.27	4893.0
2012-03-28 04:00:00	NQ	Futures	3222.27	3225.74	3214.17	3215.33	2621.0
2012-03-28 05:00:00	NQ	Futures	3215.04	3219.38	3211.57	3215.91	2486.0
2012-03-28 06:00:00	NQ	Futures	3215.91	3219.38	3213.31	3217.36	1676.0
2012-03-28 07:00:00	NQ	Futures	3217.65	3222.56	3216.49	3217.07	4301.0
2012-03-28 08:00:00	NQ	Futures	3217.36	3220.54	3210.99	3211.57	6499.0
2012-03-28 09:00:00	NQ	Futures	3211.28	3227.77	3210.42	3220.83	35772.0
2012-03-28 10:00:00	NQ	Futures	3220.83	3224.3	3206.37	3210.42	36939.0
2012-03-28 11:00:00	NQ	Futures	3210.13	3212.15	3187.86	3192.77	37457.0
2012-03-28 12:00:00	NQ	Futures	3192.77	3195.96	3187.28	3192.48	27443.0
2012-03-28 13:00:00	NQ	Futures	3192.48	3195.96	3184.68	3189.59	16787.0
2012-03-28 14:00:00	NQ	Futures	3189.59	3197.4	3181.5	3196.82	20843.0
2012-03-28 15:00:00	NQ	Futures	3197.11	3203.76	3195.09	3200.58	29551.0
2012-03-28 16:00:00	NQ	Futures	3200.58	3203.76	3198.85	3200.29	7798.0
2012-03-28 17:00:00	NQ	Futures	3200.58	3203.19	3200.58	3202.03	177.0
2012-03-28 18:00:00	NQ	Futures	3202.9	3205.21	3202.61	3203.76	283.0
2012-03-28 19:00:00	NQ	Futures	3204.05	3204.05	3201.16	3203.19	415.0
2012-03-28 20:00:00	NQ	Futures	3203.76	3204.34	3200.29	3202.61	433.0
2012-03-28 21:00:00	NQ	Futures	3202.61	3202.61	3196.53	3196.82	726.0
2012-03-28 22:00:00	NQ	Futures	3196.82	3199.43	3196.24	3197.98	442.0
2012-03-28 23:00:00	NQ	Futures	3197.69	3202.32	3197.4	3200.58	371.0
2012-03-28 00:00:00	YM	Futures	13083.4	13092.4	13075.4	13076.4	471.0
2012-03-28 01:00:00	YM	Futures	13075.4	13089.4	13075.4	13083.4	208.0

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

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