PREVIEW / futures_1hour / 2012-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-20.parquet
  size:    49 KB
  rows:    1,492

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-20 00:00:00	ES	Futures	1419.5	1420.25	1418.74	1418.74	2300.0
2012-03-20 01:00:00	ES	Futures	1418.74	1420.0	1418.48	1420.0	4026.0
2012-03-20 02:00:00	ES	Futures	1419.75	1420.76	1419.5	1420.25	3318.0
2012-03-20 03:00:00	ES	Futures	1420.0	1420.25	1417.72	1417.72	9809.0
2012-03-20 04:00:00	ES	Futures	1417.72	1418.23	1415.95	1417.98	28534.0
2012-03-20 05:00:00	ES	Futures	1417.98	1418.48	1411.65	1413.17	55494.0
2012-03-20 06:00:00	ES	Futures	1412.92	1413.68	1411.65	1411.91	34718.0
2012-03-20 07:00:00	ES	Futures	1412.16	1413.93	1411.91	1412.41	32815.0
2012-03-20 08:00:00	ES	Futures	1412.41	1413.17	1410.89	1411.91	60831.0
2012-03-20 09:00:00	ES	Futures	1411.91	1413.68	1408.36	1411.4	229513.0
2012-03-20 10:00:00	ES	Futures	1411.65	1414.44	1410.64	1413.42	228005.0
2012-03-20 11:00:00	ES	Futures	1413.17	1414.69	1411.4	1413.17	235701.0
2012-03-20 12:00:00	ES	Futures	1412.92	1414.44	1412.66	1413.93	144334.0
2012-03-20 13:00:00	ES	Futures	1413.93	1416.46	1413.68	1415.95	101537.0
2012-03-20 14:00:00	ES	Futures	1415.95	1417.72	1414.94	1416.46	107671.0
2012-03-20 15:00:00	ES	Futures	1416.46	1418.23	1414.69	1416.21	216265.0
2012-03-20 16:00:00	ES	Futures	1416.21	1418.23	1415.45	1417.72	66125.0
2012-03-20 17:00:00	ES	Futures	1417.47	1417.72	1416.71	1417.22	2194.0
2012-03-20 18:00:00	ES	Futures	1416.97	1417.22	1416.21	1416.71	2697.0
2012-03-20 19:00:00	ES	Futures	1416.71	1416.97	1415.45	1416.71	5218.0
2012-03-20 20:00:00	ES	Futures	1416.46	1421.27	1416.46	1421.01	12033.0
2012-03-20 21:00:00	ES	Futures	1421.01	1422.28	1420.51	1421.01	11101.0
2012-03-20 22:00:00	ES	Futures	1421.01	1422.28	1420.76	1421.52	6700.0
2012-03-20 23:00:00	ES	Futures	1421.52	1421.77	1419.5	1419.75	4474.0
2012-03-20 00:00:00	NQ	Futures	3154.02	3154.02	3151.71	3151.71	668.0
2012-03-20 01:00:00	NQ	Futures	3151.71	3152.86	3151.13	3152.86	423.0
2012-03-20 02:00:00	NQ	Futures	3153.15	3155.76	3153.15	3154.6	218.0
2012-03-20 03:00:00	NQ	Futures	3154.6	3154.6	3149.1	3149.39	872.0
2012-03-20 04:00:00	NQ	Futures	3149.39	3151.13	3146.5	3151.13	2219.0
2012-03-20 05:00:00	NQ	Futures	3151.13	3152.0	3138.98	3141.87	3220.0
2012-03-20 06:00:00	NQ	Futures	3141.59	3142.74	3139.56	3139.56	1741.0
2012-03-20 07:00:00	NQ	Futures	3139.85	3145.06	3139.85	3141.59	4233.0
2012-03-20 08:00:00	NQ	Futures	3141.59	3142.45	3138.4	3140.14	6283.0
2012-03-20 09:00:00	NQ	Futures	3140.14	3142.45	3131.75	3135.51	31787.0
2012-03-20 10:00:00	NQ	Futures	3135.8	3141.87	3131.75	3139.27	27526.0
2012-03-20 11:00:00	NQ	Futures	3139.27	3144.77	3135.51	3140.43	26053.0
2012-03-20 12:00:00	NQ	Futures	3140.14	3145.35	3138.69	3143.9	15189.0
2012-03-20 13:00:00	NQ	Futures	3143.9	3154.02	3142.74	3153.44	19940.0
2012-03-20 14:00:00	NQ	Futures	3153.73	3160.38	3151.71	3157.78	24931.0
2012-03-20 15:00:00	NQ	Futures	3158.07	3165.59	3158.07	3162.41	34443.0
2012-03-20 16:00:00	NQ	Futures	3162.41	3168.19	3161.25	3166.75	10584.0
2012-03-20 17:00:00	NQ	Futures	3166.75	3166.75	3162.99	3164.14	882.0
2012-03-20 18:00:00	NQ	Futures	3162.7	3163.56	3161.25	3162.41	529.0
2012-03-20 19:00:00	NQ	Futures	3162.41	3162.7	3160.09	3162.12	345.0
2012-03-20 20:00:00	NQ	Futures	3162.41	3171.37	3162.41	3171.08	1013.0
2012-03-20 21:00:00	NQ	Futures	3171.08	3173.98	3171.08	3171.66	843.0
2012-03-20 22:00:00	NQ	Futures	3171.95	3174.27	3171.66	3173.11	441.0
2012-03-20 23:00:00	NQ	Futures	3173.11	3174.55	3169.64	3170.22	388.0
2012-03-20 00:00:00	YM	Futures	13110.3	13113.3	13104.3	13104.3	118.0
2012-03-20 01:00:00	YM	Futures	13103.3	13112.3	13101.3	13111.3	167.0

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

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