PREVIEW / futures_1hour / 2012-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-12.parquet
  size:    49 KB
  rows:    1,491

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-04-12 00:00:00	ES	Futures	1384.84	1384.84	1382.56	1383.07	3735.0
2012-04-12 01:00:00	ES	Futures	1383.07	1385.85	1382.56	1385.34	5995.0
2012-04-12 02:00:00	ES	Futures	1385.6	1388.13	1385.09	1387.87	14376.0
2012-04-12 03:00:00	ES	Futures	1387.87	1388.88	1382.81	1384.58	36996.0
2012-04-12 04:00:00	ES	Futures	1384.58	1389.14	1384.33	1386.1	30416.0
2012-04-12 05:00:00	ES	Futures	1386.1	1387.11	1381.8	1383.32	40555.0
2012-04-12 06:00:00	ES	Futures	1383.32	1386.86	1382.56	1386.1	22357.0
2012-04-12 07:00:00	ES	Futures	1386.1	1388.38	1385.34	1387.37	28392.0
2012-04-12 08:00:00	ES	Futures	1387.11	1388.13	1379.78	1382.31	103813.0
2012-04-12 09:00:00	ES	Futures	1382.05	1390.15	1381.29	1389.64	262702.0
2012-04-12 10:00:00	ES	Futures	1389.64	1394.96	1387.87	1393.69	323779.0
2012-04-12 11:00:00	ES	Futures	1393.69	1396.22	1393.44	1395.21	242773.0
2012-04-12 12:00:00	ES	Futures	1395.46	1399.0	1394.45	1398.24	196645.0
2012-04-12 13:00:00	ES	Futures	1398.24	1399.51	1395.97	1396.47	114928.0
2012-04-12 14:00:00	ES	Futures	1396.47	1400.27	1396.47	1399.26	92671.0
2012-04-12 15:00:00	ES	Futures	1399.0	1400.77	1397.74	1400.02	170037.0
2012-04-12 16:00:00	ES	Futures	1400.02	1402.8	1398.75	1401.53	126816.0
2012-04-12 17:00:00	ES	Futures	1401.53	1402.04	1400.02	1400.27	4651.0
2012-04-12 18:00:00	ES	Futures	1400.52	1401.79	1400.02	1401.03	3270.0
2012-04-12 19:00:00	ES	Futures	1400.77	1402.04	1400.02	1402.04	2733.0
2012-04-12 20:00:00	ES	Futures	1402.04	1403.05	1400.77	1402.8	5454.0
2012-04-12 21:00:00	ES	Futures	1402.8	1405.08	1401.79	1402.04	10565.0
2012-04-12 22:00:00	ES	Futures	1402.04	1402.29	1398.24	1398.75	24062.0
2012-04-12 23:00:00	ES	Futures	1399.0	1400.52	1398.24	1398.5	4806.0
2012-04-12 00:00:00	NQ	Futures	3137.54	3137.54	3133.78	3134.36	456.0
2012-04-12 01:00:00	NQ	Futures	3134.64	3140.14	3134.64	3138.69	416.0
2012-04-12 02:00:00	NQ	Futures	3138.69	3144.19	3138.4	3144.19	1181.0
2012-04-12 03:00:00	NQ	Futures	3143.9	3147.37	3133.78	3138.4	4066.0
2012-04-12 04:00:00	NQ	Futures	3138.4	3148.24	3138.12	3140.72	3338.0
2012-04-12 05:00:00	NQ	Futures	3141.01	3142.45	3131.17	3134.93	4508.0
2012-04-12 06:00:00	NQ	Futures	3135.51	3142.74	3133.78	3142.16	2428.0
2012-04-12 07:00:00	NQ	Futures	3141.87	3148.53	3140.72	3145.63	3628.0
2012-04-12 08:00:00	NQ	Futures	3145.63	3147.66	3130.89	3135.51	10668.0
2012-04-12 09:00:00	NQ	Futures	3135.22	3152.86	3131.75	3149.39	46224.0
2012-04-12 10:00:00	NQ	Futures	3149.39	3167.61	3145.35	3162.99	56384.0
2012-04-12 11:00:00	NQ	Futures	3162.7	3169.06	3160.96	3165.88	36396.0
2012-04-12 12:00:00	NQ	Futures	3165.88	3167.61	3158.36	3165.88	25238.0
2012-04-12 13:00:00	NQ	Futures	3165.88	3167.32	3154.6	3157.2	19528.0
2012-04-12 14:00:00	NQ	Futures	3157.2	3168.48	3156.91	3165.59	15750.0
2012-04-12 15:00:00	NQ	Futures	3165.59	3169.35	3163.28	3165.88	27590.0
2012-04-12 16:00:00	NQ	Futures	3165.59	3169.93	3153.15	3167.61	23415.0
2012-04-12 17:00:00	NQ	Futures	3167.32	3167.32	3162.7	3163.56	659.0
2012-04-12 18:00:00	NQ	Futures	3163.85	3165.59	3162.99	3164.14	274.0
2012-04-12 19:00:00	NQ	Futures	3164.43	3166.75	3162.41	3166.75	266.0
2012-04-12 20:00:00	NQ	Futures	3166.46	3168.77	3164.14	3168.77	378.0
2012-04-12 21:00:00	NQ	Futures	3168.48	3172.82	3167.32	3167.32	1016.0
2012-04-12 22:00:00	NQ	Futures	3166.75	3166.75	3160.38	3161.83	1665.0
2012-04-12 23:00:00	NQ	Futures	3161.83	3165.01	3160.96	3161.25	335.0
2012-04-12 00:00:00	YM	Futures	12730.7	12732.7	12718.8	12720.8	252.0
2012-04-12 01:00:00	YM	Futures	12720.8	12741.7	12717.8	12740.7	477.0

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

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