PREVIEW / futures_1hour / 2012-03-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-19.parquet
  size:    48 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-03-19 00:00:00	ES	Futures	1418.74	1418.74	1417.72	1418.23	2405.0
2012-03-19 01:00:00	ES	Futures	1417.98	1418.48	1417.47	1418.23	1553.0
2012-03-19 02:00:00	ES	Futures	1418.23	1418.23	1417.22	1417.47	2104.0
2012-03-19 03:00:00	ES	Futures	1417.22	1417.47	1413.93	1414.18	9508.0
2012-03-19 04:00:00	ES	Futures	1413.93	1414.18	1410.13	1411.15	37965.0
2012-03-19 05:00:00	ES	Futures	1410.89	1413.17	1410.13	1412.41	19945.0
2012-03-19 06:00:00	ES	Futures	1412.41	1412.92	1411.15	1412.41	18364.0
2012-03-19 07:00:00	ES	Futures	1412.41	1414.18	1411.91	1413.17	24269.0
2012-03-19 08:00:00	ES	Futures	1413.17	1414.18	1411.4	1412.41	51794.0
2012-03-19 09:00:00	ES	Futures	1412.41	1418.23	1411.91	1417.47	160462.0
2012-03-19 10:00:00	ES	Futures	1417.47	1418.23	1414.94	1417.72	188722.0
2012-03-19 11:00:00	ES	Futures	1417.72	1420.76	1415.7	1420.51	236900.0
2012-03-19 12:00:00	ES	Futures	1420.51	1423.29	1420.25	1422.28	169993.0
2012-03-19 13:00:00	ES	Futures	1422.53	1424.81	1422.03	1424.05	153658.0
2012-03-19 14:00:00	ES	Futures	1424.3	1424.81	1422.28	1422.78	97601.0
2012-03-19 15:00:00	ES	Futures	1422.78	1423.54	1419.75	1420.51	225718.0
2012-03-19 16:00:00	ES	Futures	1420.51	1421.52	1419.5	1421.01	86275.0
2012-03-19 17:00:00	ES	Futures	1421.27	1421.77	1421.27	1421.52	1102.0
2012-03-19 18:00:00	ES	Futures	1421.01	1421.27	1420.51	1420.76	3224.0
2012-03-19 19:00:00	ES	Futures	1420.76	1421.01	1420.0	1420.51	2169.0
2012-03-19 20:00:00	ES	Futures	1420.51	1421.52	1420.25	1420.76	3119.0
2012-03-19 21:00:00	ES	Futures	1420.76	1421.52	1419.5	1420.25	3609.0
2012-03-19 22:00:00	ES	Futures	1420.25	1420.25	1418.48	1418.74	5827.0
2012-03-19 23:00:00	ES	Futures	1418.48	1420.0	1418.23	1419.5	5099.0
2012-03-19 00:00:00	NQ	Futures	3146.79	3146.79	3144.48	3144.77	387.0
2012-03-19 01:00:00	NQ	Futures	3144.48	3145.06	3143.32	3145.06	235.0
2012-03-19 02:00:00	NQ	Futures	3145.06	3145.06	3143.03	3143.03	211.0
2012-03-19 03:00:00	NQ	Futures	3143.03	3143.03	3136.38	3136.38	1064.0
2012-03-19 04:00:00	NQ	Futures	3136.09	3136.38	3126.55	3127.99	4497.0
2012-03-19 05:00:00	NQ	Futures	3127.7	3135.22	3126.55	3134.07	1976.0
2012-03-19 06:00:00	NQ	Futures	3134.07	3136.67	3131.75	3135.8	1425.0
2012-03-19 07:00:00	NQ	Futures	3135.8	3144.77	3135.51	3139.85	4392.0
2012-03-19 08:00:00	NQ	Futures	3139.85	3145.06	3123.66	3130.6	19091.0
2012-03-19 09:00:00	NQ	Futures	3130.31	3144.48	3128.86	3142.45	32628.0
2012-03-19 10:00:00	NQ	Futures	3142.45	3143.03	3132.04	3141.3	32394.0
2012-03-19 11:00:00	NQ	Futures	3141.3	3151.71	3138.12	3151.42	30534.0
2012-03-19 12:00:00	NQ	Futures	3151.42	3160.67	3151.13	3156.91	24796.0
2012-03-19 13:00:00	NQ	Futures	3156.91	3163.28	3156.33	3161.25	19916.0
2012-03-19 14:00:00	NQ	Futures	3161.25	3163.85	3160.09	3161.54	13687.0
2012-03-19 15:00:00	NQ	Futures	3161.83	3163.56	3154.31	3156.33	31339.0
2012-03-19 16:00:00	NQ	Futures	3156.62	3159.23	3154.31	3158.65	6744.0
2012-03-19 17:00:00	NQ	Futures	3158.94	3158.94	3157.49	3158.07	125.0
2012-03-19 18:00:00	NQ	Futures	3157.49	3158.07	3155.76	3155.76	241.0
2012-03-19 19:00:00	NQ	Futures	3156.05	3156.33	3155.47	3156.05	89.0
2012-03-19 20:00:00	NQ	Futures	3156.05	3157.78	3156.05	3156.91	284.0
2012-03-19 21:00:00	NQ	Futures	3156.91	3158.07	3154.31	3156.05	347.0
2012-03-19 22:00:00	NQ	Futures	3155.47	3155.47	3152.0	3152.0	377.0
2012-03-19 23:00:00	NQ	Futures	3151.71	3154.6	3151.13	3154.02	416.0
2012-03-19 00:00:00	YM	Futures	13149.2	13150.2	13144.2	13144.2	77.0
2012-03-19 01:00:00	YM	Futures	13143.2	13149.2	13141.2	13148.2	254.0

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

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