PREVIEW / futures_1hour / 2011-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-01.parquet
  size:    48 KB
  rows:    1,436

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-01 00:00:00	ES	Futures	1218.1	1219.59	1215.85	1215.85	3527.0
2011-09-01 01:00:00	ES	Futures	1216.1	1217.35	1215.35	1216.6	4543.0
2011-09-01 02:00:00	ES	Futures	1216.85	1220.59	1215.35	1220.34	19334.0
2011-09-01 03:00:00	ES	Futures	1220.34	1221.59	1210.86	1211.61	51702.0
2011-09-01 04:00:00	ES	Futures	1211.86	1212.61	1209.12	1209.62	35869.0
2011-09-01 05:00:00	ES	Futures	1209.87	1210.12	1205.63	1208.87	44839.0
2011-09-01 06:00:00	ES	Futures	1209.12	1210.61	1207.37	1208.62	27906.0
2011-09-01 07:00:00	ES	Futures	1208.87	1212.61	1208.62	1210.61	32042.0
2011-09-01 08:00:00	ES	Futures	1210.61	1216.1	1209.62	1215.35	71247.0
2011-09-01 09:00:00	ES	Futures	1215.6	1217.35	1208.37	1210.86	238230.0
2011-09-01 10:00:00	ES	Futures	1210.86	1225.58	1208.87	1213.36	682921.0
2011-09-01 11:00:00	ES	Futures	1213.36	1217.1	1209.87	1216.1	336478.0
2011-09-01 12:00:00	ES	Futures	1216.1	1216.85	1211.36	1211.86	125878.0
2011-09-01 13:00:00	ES	Futures	1211.86	1212.36	1203.38	1204.63	233780.0
2011-09-01 14:00:00	ES	Futures	1204.63	1207.37	1201.14	1203.88	219923.0
2011-09-01 15:00:00	ES	Futures	1204.13	1206.62	1199.39	1201.14	369392.0
2011-09-01 16:00:00	ES	Futures	1201.14	1202.13	1196.15	1197.89	102908.0
2011-09-01 17:00:00	ES	Futures	1197.89	1199.64	1197.65	1198.89	3561.0
2011-09-01 18:00:00	ES	Futures	1198.39	1199.64	1198.14	1198.39	3408.0
2011-09-01 19:00:00	ES	Futures	1198.39	1199.14	1196.4	1197.15	3836.0
2011-09-01 20:00:00	ES	Futures	1197.15	1200.39	1196.4	1199.89	6879.0
2011-09-01 21:00:00	ES	Futures	1199.89	1200.39	1198.64	1199.14	3892.0
2011-09-01 22:00:00	ES	Futures	1199.14	1199.14	1189.91	1192.16	17881.0
2011-09-01 23:00:00	ES	Futures	1191.91	1193.41	1190.41	1192.41	7857.0
2011-09-01 00:00:00	NQ	Futures	2590.18	2591.9	2585.86	2585.86	339.0
2011-09-01 01:00:00	NQ	Futures	2586.15	2589.02	2585.28	2588.74	920.0
2011-09-01 02:00:00	NQ	Futures	2588.45	2595.64	2585.28	2595.64	1507.0
2011-09-01 03:00:00	NQ	Futures	2595.64	2597.94	2576.07	2578.38	5053.0
2011-09-01 04:00:00	NQ	Futures	2578.66	2580.1	2572.62	2574.06	2717.0
2011-09-01 05:00:00	NQ	Futures	2574.06	2575.21	2566.0	2572.33	1948.0
2011-09-01 06:00:00	NQ	Futures	2572.05	2576.36	2570.03	2572.62	1599.0
2011-09-01 07:00:00	NQ	Futures	2572.91	2578.66	2572.62	2575.21	2731.0
2011-09-01 08:00:00	NQ	Futures	2575.21	2586.15	2572.62	2584.71	5275.0
2011-09-01 09:00:00	NQ	Futures	2585.0	2591.61	2575.79	2584.13	39006.0
2011-09-01 10:00:00	NQ	Futures	2583.56	2605.71	2580.1	2580.68	63216.0
2011-09-01 11:00:00	NQ	Futures	2580.68	2588.16	2572.91	2585.57	29476.0
2011-09-01 12:00:00	NQ	Futures	2585.86	2586.15	2570.9	2571.47	17051.0
2011-09-01 13:00:00	NQ	Futures	2571.76	2573.2	2556.22	2558.81	22023.0
2011-09-01 14:00:00	NQ	Futures	2558.52	2566.0	2550.18	2559.1	20441.0
2011-09-01 15:00:00	NQ	Futures	2558.81	2565.14	2551.04	2554.78	36345.0
2011-09-01 16:00:00	NQ	Futures	2554.78	2558.52	2549.31	2551.61	8939.0
2011-09-01 17:00:00	NQ	Futures	2551.61	2555.07	2551.61	2554.2	230.0
2011-09-01 18:00:00	NQ	Futures	2553.34	2554.49	2552.77	2553.05	233.0
2011-09-01 19:00:00	NQ	Futures	2553.34	2554.78	2550.18	2551.04	468.0
2011-09-01 20:00:00	NQ	Futures	2550.75	2557.37	2549.89	2555.93	433.0
2011-09-01 21:00:00	NQ	Futures	2556.51	2557.37	2553.92	2554.2	399.0
2011-09-01 22:00:00	NQ	Futures	2554.2	2554.49	2536.65	2540.1	2089.0
2011-09-01 23:00:00	NQ	Futures	2540.1	2542.69	2536.65	2541.26	802.0
2011-09-01 00:00:00	YM	Futures	11275.1	11280.9	11252.8	11252.8	234.0
2011-09-01 01:00:00	YM	Futures	11254.7	11265.4	11248.9	11260.5	228.0

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

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