PREVIEW / futures_1hour / 2011-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-05.parquet
  size:    48 KB
  rows:    1,471

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
2011-04-05 00:00:00	ES	Futures	1318.42	1319.17	1318.17	1318.17	3828.0
2011-04-05 01:00:00	ES	Futures	1318.17	1319.66	1317.68	1319.66	4391.0
2011-04-05 02:00:00	ES	Futures	1319.41	1319.66	1317.43	1318.17	7808.0
2011-04-05 03:00:00	ES	Futures	1318.17	1319.17	1316.93	1317.18	20596.0
2011-04-05 04:00:00	ES	Futures	1317.18	1317.68	1314.69	1316.68	30680.0
2011-04-05 05:00:00	ES	Futures	1316.43	1317.43	1315.69	1315.94	11637.0
2011-04-05 06:00:00	ES	Futures	1315.69	1316.43	1314.69	1315.94	19147.0
2011-04-05 07:00:00	ES	Futures	1316.18	1318.17	1315.69	1317.43	25976.0
2011-04-05 08:00:00	ES	Futures	1317.43	1317.92	1314.94	1316.18	38768.0
2011-04-05 09:00:00	ES	Futures	1316.43	1320.16	1316.18	1319.17	199341.0
2011-04-05 10:00:00	ES	Futures	1319.41	1323.64	1317.18	1321.65	298377.0
2011-04-05 11:00:00	ES	Futures	1321.4	1325.13	1320.91	1324.63	187288.0
2011-04-05 12:00:00	ES	Futures	1324.38	1325.13	1323.14	1324.38	117214.0
2011-04-05 13:00:00	ES	Futures	1324.38	1325.87	1323.89	1324.13	90864.0
2011-04-05 14:00:00	ES	Futures	1324.13	1324.63	1320.91	1322.4	159346.0
2011-04-05 15:00:00	ES	Futures	1322.15	1322.64	1318.42	1319.41	212144.0
2011-04-05 16:00:00	ES	Futures	1319.41	1319.91	1317.68	1318.17	95377.0
2011-04-05 17:00:00	ES	Futures	1318.17	1318.42	1317.92	1318.42	617.0
2011-04-05 18:00:00	ES	Futures	1318.67	1319.66	1318.42	1319.41	4680.0
2011-04-05 19:00:00	ES	Futures	1319.41	1319.66	1318.92	1319.17	2696.0
2011-04-05 20:00:00	ES	Futures	1319.17	1320.41	1318.42	1320.16	7751.0
2011-04-05 21:00:00	ES	Futures	1320.41	1320.66	1318.67	1320.16	6159.0
2011-04-05 22:00:00	ES	Futures	1320.16	1320.66	1319.66	1320.16	2157.0
2011-04-05 23:00:00	ES	Futures	1320.16	1320.91	1319.91	1320.91	5994.0
2011-04-05 00:00:00	NQ	Futures	2684.67	2685.53	2680.65	2680.93	1190.0
2011-04-05 01:00:00	NQ	Futures	2680.93	2685.24	2679.79	2685.24	497.0
2011-04-05 02:00:00	NQ	Futures	2685.24	2685.24	2674.9	2675.48	4124.0
2011-04-05 03:00:00	NQ	Futures	2675.19	2678.06	2668.01	2670.02	4233.0
2011-04-05 04:00:00	NQ	Futures	2670.02	2671.17	2664.27	2668.01	3189.0
2011-04-05 05:00:00	NQ	Futures	2668.01	2670.59	2666.28	2667.14	1548.0
2011-04-05 06:00:00	NQ	Futures	2667.14	2668.29	2664.84	2668.01	1430.0
2011-04-05 07:00:00	NQ	Futures	2667.72	2673.18	2667.72	2671.45	3787.0
2011-04-05 08:00:00	NQ	Futures	2671.74	2674.9	2670.02	2673.18	7002.0
2011-04-05 09:00:00	NQ	Futures	2673.18	2680.07	2670.02	2676.05	40671.0
2011-04-05 10:00:00	NQ	Futures	2675.48	2687.83	2669.15	2686.11	51300.0
2011-04-05 11:00:00	NQ	Futures	2686.11	2688.12	2680.93	2686.11	27029.0
2011-04-05 12:00:00	NQ	Futures	2686.39	2687.83	2683.52	2686.97	17124.0
2011-04-05 13:00:00	NQ	Futures	2687.26	2689.27	2685.24	2686.39	11303.0
2011-04-05 14:00:00	NQ	Futures	2686.39	2688.12	2672.89	2675.76	21911.0
2011-04-05 15:00:00	NQ	Futures	2675.76	2676.62	2666.57	2670.3	38837.0
2011-04-05 16:00:00	NQ	Futures	2670.59	2671.74	2669.15	2670.59	6678.0
2011-04-05 17:00:00	NQ	Futures	2670.59	2671.17	2669.73	2670.88	88.0
2011-04-05 18:00:00	NQ	Futures	2670.88	2674.61	2670.88	2674.04	543.0
2011-04-05 19:00:00	NQ	Futures	2673.75	2674.61	2673.18	2673.75	232.0
2011-04-05 20:00:00	NQ	Futures	2674.04	2675.48	2672.6	2674.9	546.0
2011-04-05 21:00:00	NQ	Futures	2674.9	2675.76	2672.6	2675.48	439.0
2011-04-05 22:00:00	NQ	Futures	2675.76	2675.76	2674.04	2674.9	161.0
2011-04-05 23:00:00	NQ	Futures	2675.48	2677.2	2674.33	2676.91	444.0
2011-04-05 00:00:00	YM	Futures	11863.6	11869.4	11862.6	11863.6	144.0
2011-04-05 01:00:00	YM	Futures	11864.5	11873.2	11856.8	11871.3	202.0

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

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