PREVIEW / futures_1hour / 2012-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-04.parquet
  size:    47 KB
  rows:    1,400

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-06-04 00:00:00	ES	Futures	1281.11	1282.12	1279.09	1281.11	7167.0
2012-06-04 01:00:00	ES	Futures	1281.11	1282.88	1280.1	1281.87	7152.0
2012-06-04 02:00:00	ES	Futures	1282.12	1283.64	1280.1	1281.87	14193.0
2012-06-04 03:00:00	ES	Futures	1281.87	1284.91	1280.61	1283.64	39833.0
2012-06-04 04:00:00	ES	Futures	1283.64	1284.65	1282.12	1284.15	29706.0
2012-06-04 05:00:00	ES	Futures	1283.9	1287.18	1283.64	1285.92	24047.0
2012-06-04 06:00:00	ES	Futures	1286.17	1292.24	1285.67	1290.73	37784.0
2012-06-04 07:00:00	ES	Futures	1290.73	1293.51	1290.22	1292.75	45254.0
2012-06-04 08:00:00	ES	Futures	1292.75	1294.01	1290.73	1292.75	46833.0
2012-06-04 09:00:00	ES	Futures	1292.5	1296.8	1287.69	1289.21	329176.0
2012-06-04 10:00:00	ES	Futures	1289.46	1292.24	1284.65	1290.47	374383.0
2012-06-04 11:00:00	ES	Futures	1290.47	1290.98	1285.41	1285.67	192941.0
2012-06-04 12:00:00	ES	Futures	1285.67	1286.93	1280.86	1282.63	180346.0
2012-06-04 13:00:00	ES	Futures	1282.88	1286.17	1280.35	1284.91	169395.0
2012-06-04 14:00:00	ES	Futures	1284.91	1294.52	1283.64	1289.97	246825.0
2012-06-04 15:00:00	ES	Futures	1290.22	1293.51	1286.43	1290.98	292136.0
2012-06-04 16:00:00	ES	Futures	1291.23	1291.49	1285.92	1289.21	132191.0
2012-06-04 17:00:00	ES	Futures	1289.21	1289.46	1287.18	1287.69	2400.0
2012-06-04 18:00:00	ES	Futures	1287.94	1289.97	1287.69	1289.97	4067.0
2012-06-04 19:00:00	ES	Futures	1289.71	1290.47	1288.96	1290.47	3577.0
2012-06-04 20:00:00	ES	Futures	1290.47	1293.26	1290.22	1291.99	11353.0
2012-06-04 21:00:00	ES	Futures	1291.99	1295.03	1291.49	1294.52	9386.0
2012-06-04 22:00:00	ES	Futures	1294.27	1294.77	1293.76	1294.27	3530.0
2012-06-04 23:00:00	ES	Futures	1294.01	1294.52	1290.73	1292.24	5499.0
2012-06-04 00:00:00	NQ	Futures	2820.86	2824.62	2817.1	2820.57	1131.0
2012-06-04 01:00:00	NQ	Futures	2820.86	2825.2	2819.42	2822.89	1005.0
2012-06-04 02:00:00	NQ	Futures	2822.89	2826.36	2820.28	2825.49	1602.0
2012-06-04 03:00:00	NQ	Futures	2825.2	2832.14	2822.89	2828.38	4851.0
2012-06-04 04:00:00	NQ	Futures	2828.67	2830.69	2825.2	2829.54	2494.0
2012-06-04 05:00:00	NQ	Futures	2829.54	2837.64	2829.25	2835.32	2994.0
2012-06-04 06:00:00	NQ	Futures	2835.61	2846.89	2834.74	2844.29	3944.0
2012-06-04 07:00:00	NQ	Futures	2844.0	2850.65	2844.0	2847.76	5707.0
2012-06-04 08:00:00	NQ	Futures	2847.76	2852.1	2844.58	2848.34	7087.0
2012-06-04 09:00:00	NQ	Futures	2848.63	2869.16	2838.79	2841.4	49715.0
2012-06-04 10:00:00	NQ	Futures	2841.97	2856.72	2826.07	2848.63	51357.0
2012-06-04 11:00:00	NQ	Futures	2848.63	2850.65	2834.45	2834.74	21694.0
2012-06-04 12:00:00	NQ	Futures	2834.74	2838.21	2827.22	2833.59	19723.0
2012-06-04 13:00:00	NQ	Futures	2833.88	2841.4	2827.22	2840.53	21371.0
2012-06-04 14:00:00	NQ	Futures	2840.53	2866.27	2836.77	2854.99	32142.0
2012-06-04 15:00:00	NQ	Futures	2854.41	2867.42	2846.31	2863.95	35316.0
2012-06-04 16:00:00	NQ	Futures	2864.24	2864.82	2853.25	2860.19	11562.0
2012-06-04 17:00:00	NQ	Futures	2860.19	2860.77	2857.3	2858.46	229.0
2012-06-04 18:00:00	NQ	Futures	2858.75	2862.22	2858.17	2861.93	238.0
2012-06-04 19:00:00	NQ	Futures	2861.93	2864.24	2861.06	2864.24	633.0
2012-06-04 20:00:00	NQ	Futures	2863.95	2869.16	2863.66	2866.56	1384.0
2012-06-04 21:00:00	NQ	Futures	2866.27	2872.05	2865.4	2870.6	665.0
2012-06-04 22:00:00	NQ	Futures	2870.89	2872.63	2869.16	2870.03	578.0
2012-06-04 23:00:00	NQ	Futures	2870.03	2870.89	2864.53	2867.42	703.0
2012-06-04 00:00:00	YM	Futures	11975.5	11989.5	11964.6	11978.5	815.0
2012-06-04 01:00:00	YM	Futures	11979.5	11997.4	11973.5	11985.5	831.0

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

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