PREVIEW / futures_1hour / 2012-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-18.parquet
  size:    48 KB
  rows:    1,501

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-18 00:00:00	ES	Futures	1402.55	1402.8	1401.79	1402.29	1729.0
2012-04-18 01:00:00	ES	Futures	1402.55	1402.8	1401.79	1402.04	3920.0
2012-04-18 02:00:00	ES	Futures	1402.29	1403.05	1400.77	1401.03	7820.0
2012-04-18 03:00:00	ES	Futures	1401.03	1402.29	1398.75	1401.79	34018.0
2012-04-18 04:00:00	ES	Futures	1401.53	1402.8	1398.5	1398.5	28561.0
2012-04-18 05:00:00	ES	Futures	1398.75	1401.03	1398.24	1400.02	26880.0
2012-04-18 06:00:00	ES	Futures	1400.02	1400.27	1396.47	1396.73	24860.0
2012-04-18 07:00:00	ES	Futures	1396.73	1397.49	1394.7	1396.73	41915.0
2012-04-18 08:00:00	ES	Futures	1396.98	1398.5	1394.2	1395.97	68847.0
2012-04-18 09:00:00	ES	Futures	1395.97	1400.52	1395.21	1400.02	267334.0
2012-04-18 10:00:00	ES	Futures	1400.27	1402.04	1397.74	1401.03	411235.0
2012-04-18 11:00:00	ES	Futures	1401.03	1401.28	1395.71	1399.26	291767.0
2012-04-18 12:00:00	ES	Futures	1399.26	1399.51	1397.23	1397.99	89218.0
2012-04-18 13:00:00	ES	Futures	1397.99	1399.51	1394.96	1395.71	98849.0
2012-04-18 14:00:00	ES	Futures	1395.71	1400.52	1395.21	1400.02	103425.0
2012-04-18 15:00:00	ES	Futures	1400.27	1402.29	1396.73	1397.74	224006.0
2012-04-18 16:00:00	ES	Futures	1397.74	1398.24	1394.45	1396.47	93490.0
2012-04-18 17:00:00	ES	Futures	1396.47	1396.73	1395.71	1396.22	1745.0
2012-04-18 18:00:00	ES	Futures	1396.47	1396.47	1395.46	1396.22	1613.0
2012-04-18 19:00:00	ES	Futures	1396.22	1396.73	1395.46	1395.97	3097.0
2012-04-18 20:00:00	ES	Futures	1395.97	1398.5	1395.21	1398.24	7207.0
2012-04-18 21:00:00	ES	Futures	1397.99	1399.26	1395.71	1396.47	8777.0
2012-04-18 22:00:00	ES	Futures	1396.47	1397.99	1396.22	1397.49	2126.0
2012-04-18 23:00:00	ES	Futures	1397.23	1397.74	1396.73	1397.23	2041.0
2012-04-18 00:00:00	NQ	Futures	3145.35	3145.35	3142.45	3143.9	302.0
2012-04-18 01:00:00	NQ	Futures	3143.61	3145.63	3143.61	3145.06	416.0
2012-04-18 02:00:00	NQ	Futures	3145.35	3145.92	3140.72	3141.59	764.0
2012-04-18 03:00:00	NQ	Futures	3141.59	3143.03	3135.51	3141.3	3202.0
2012-04-18 04:00:00	NQ	Futures	3141.59	3143.61	3135.22	3135.22	2339.0
2012-04-18 05:00:00	NQ	Futures	3135.22	3140.43	3135.22	3138.4	2410.0
2012-04-18 06:00:00	NQ	Futures	3138.4	3138.69	3131.75	3131.75	1744.0
2012-04-18 07:00:00	NQ	Futures	3132.04	3132.33	3125.68	3131.17	4294.0
2012-04-18 08:00:00	NQ	Futures	3131.46	3138.98	3129.73	3134.36	7808.0
2012-04-18 09:00:00	NQ	Futures	3134.36	3149.39	3132.04	3148.82	48558.0
2012-04-18 10:00:00	NQ	Futures	3148.53	3152.0	3141.01	3148.53	70746.0
2012-04-18 11:00:00	NQ	Futures	3148.53	3149.39	3127.7	3139.27	38923.0
2012-04-18 12:00:00	NQ	Futures	3139.27	3140.72	3132.91	3138.12	13345.0
2012-04-18 13:00:00	NQ	Futures	3137.83	3141.87	3130.31	3132.04	13570.0
2012-04-18 14:00:00	NQ	Futures	3132.33	3151.71	3130.6	3151.13	19369.0
2012-04-18 15:00:00	NQ	Futures	3151.13	3156.05	3136.38	3137.54	36223.0
2012-04-18 16:00:00	NQ	Futures	3137.54	3137.54	3117.0	3129.44	21244.0
2012-04-18 17:00:00	NQ	Futures	3129.44	3130.89	3128.57	3130.02	497.0
2012-04-18 18:00:00	NQ	Futures	3130.6	3131.46	3128.57	3130.89	399.0
2012-04-18 19:00:00	NQ	Futures	3130.31	3130.89	3126.26	3126.84	508.0
2012-04-18 20:00:00	NQ	Futures	3126.84	3131.46	3125.97	3131.17	735.0
2012-04-18 21:00:00	NQ	Futures	3130.89	3132.91	3127.13	3128.57	860.0
2012-04-18 22:00:00	NQ	Futures	3128.57	3132.04	3128.28	3130.89	278.0
2012-04-18 23:00:00	NQ	Futures	3131.17	3131.75	3129.15	3130.31	224.0
2012-04-18 00:00:00	YM	Futures	12995.7	12999.7	12992.7	12995.7	257.0
2012-04-18 01:00:00	YM	Futures	12997.7	12999.7	12990.8	12995.7	606.0

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

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