PREVIEW / futures_1hour / 2011-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-20.parquet
  size:    49 KB
  rows:    1,460

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-09-20 00:00:00	ES	Futures	1191.35	1195.11	1190.6	1192.1	6125.0
2011-09-20 01:00:00	ES	Futures	1192.1	1195.36	1191.85	1193.11	5861.0
2011-09-20 02:00:00	ES	Futures	1193.11	1196.62	1191.85	1195.11	20596.0
2011-09-20 03:00:00	ES	Futures	1194.86	1203.14	1193.61	1201.88	60898.0
2011-09-20 04:00:00	ES	Futures	1201.63	1205.14	1200.88	1201.63	32134.0
2011-09-20 05:00:00	ES	Futures	1201.38	1213.67	1201.13	1212.92	64214.0
2011-09-20 06:00:00	ES	Futures	1212.92	1215.17	1208.65	1209.66	39968.0
2011-09-20 07:00:00	ES	Futures	1209.41	1211.91	1208.65	1210.16	35237.0
2011-09-20 08:00:00	ES	Futures	1210.41	1212.16	1205.9	1208.4	103401.0
2011-09-20 09:00:00	ES	Futures	1208.65	1209.66	1198.12	1201.88	333326.0
2011-09-20 10:00:00	ES	Futures	1201.88	1214.67	1199.88	1214.17	434752.0
2011-09-20 11:00:00	ES	Futures	1214.17	1218.18	1213.92	1216.93	383127.0
2011-09-20 12:00:00	ES	Futures	1217.18	1217.18	1211.41	1215.17	152856.0
2011-09-20 13:00:00	ES	Futures	1215.17	1217.68	1212.92	1214.17	114279.0
2011-09-20 14:00:00	ES	Futures	1214.17	1217.18	1209.66	1210.91	177765.0
2011-09-20 15:00:00	ES	Futures	1210.66	1212.16	1199.38	1200.38	464398.0
2011-09-20 16:00:00	ES	Futures	1200.38	1203.39	1198.62	1202.64	90795.0
2011-09-20 17:00:00	ES	Futures	1202.64	1203.64	1200.88	1201.38	3200.0
2011-09-20 18:00:00	ES	Futures	1201.13	1203.14	1197.87	1199.12	7196.0
2011-09-20 19:00:00	ES	Futures	1198.87	1201.63	1198.12	1201.63	3505.0
2011-09-20 20:00:00	ES	Futures	1201.63	1204.64	1201.13	1203.39	12051.0
2011-09-20 21:00:00	ES	Futures	1203.39	1203.64	1200.13	1202.64	9734.0
2011-09-20 22:00:00	ES	Futures	1202.64	1203.64	1201.88	1202.64	2555.0
2011-09-20 23:00:00	ES	Futures	1202.64	1205.64	1202.38	1205.39	5062.0
2011-09-20 00:00:00	NQ	Futures	2639.02	2646.22	2638.15	2640.17	295.0
2011-09-20 01:00:00	NQ	Futures	2640.46	2646.51	2639.88	2642.19	364.0
2011-09-20 02:00:00	NQ	Futures	2642.19	2649.68	2639.88	2647.09	1255.0
2011-09-20 03:00:00	NQ	Futures	2647.09	2664.39	2644.21	2661.79	4725.0
2011-09-20 04:00:00	NQ	Futures	2661.5	2668.42	2658.91	2660.64	3971.0
2011-09-20 05:00:00	NQ	Futures	2660.64	2685.44	2660.06	2683.99	4831.0
2011-09-20 06:00:00	NQ	Futures	2683.99	2688.03	2675.34	2676.5	3241.0
2011-09-20 07:00:00	NQ	Futures	2676.79	2681.11	2674.19	2679.09	4454.0
2011-09-20 08:00:00	NQ	Futures	2679.09	2682.26	2671.31	2675.92	10208.0
2011-09-20 09:00:00	NQ	Futures	2676.21	2677.65	2650.55	2658.91	47478.0
2011-09-20 10:00:00	NQ	Futures	2658.91	2682.84	2655.16	2681.4	45429.0
2011-09-20 11:00:00	NQ	Futures	2681.4	2690.05	2677.94	2688.03	41262.0
2011-09-20 12:00:00	NQ	Futures	2688.32	2688.32	2674.48	2681.11	20410.0
2011-09-20 13:00:00	NQ	Futures	2681.11	2684.28	2673.04	2677.65	19420.0
2011-09-20 14:00:00	NQ	Futures	2677.36	2685.15	2661.79	2664.68	31150.0
2011-09-20 15:00:00	NQ	Futures	2664.68	2667.85	2637.86	2643.05	68942.0
2011-09-20 16:00:00	NQ	Futures	2643.34	2653.14	2642.19	2652.28	11742.0
2011-09-20 17:00:00	NQ	Futures	2652.86	2654.01	2649.4	2651.41	431.0
2011-09-20 18:00:00	NQ	Futures	2651.41	2653.72	2643.92	2647.95	677.0
2011-09-20 19:00:00	NQ	Futures	2646.8	2652.28	2645.94	2652.28	438.0
2011-09-20 20:00:00	NQ	Futures	2652.28	2657.76	2651.99	2654.87	1031.0
2011-09-20 21:00:00	NQ	Futures	2655.74	2656.31	2649.4	2654.3	1255.0
2011-09-20 22:00:00	NQ	Futures	2654.87	2656.89	2653.72	2656.03	246.0
2011-09-20 23:00:00	NQ	Futures	2656.03	2659.77	2654.3	2659.49	553.0
2011-09-20 00:00:00	YM	Futures	11072.4	11100.9	11065.5	11076.3	707.0
2011-09-20 01:00:00	YM	Futures	11078.3	11099.9	11073.3	11081.2	445.0

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

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