PREVIEW / futures_1hour / 2011-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-18.parquet
  size:    50 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-08-18 00:00:00	ES	Futures	1179.94	1180.19	1173.95	1176.2	17286.0
2011-08-18 01:00:00	ES	Futures	1176.2	1180.44	1176.2	1178.19	8341.0
2011-08-18 02:00:00	ES	Futures	1178.44	1179.19	1174.45	1176.2	15473.0
2011-08-18 03:00:00	ES	Futures	1176.2	1179.69	1171.21	1172.46	53574.0
2011-08-18 04:00:00	ES	Futures	1172.21	1175.2	1167.97	1168.96	53255.0
2011-08-18 05:00:00	ES	Futures	1168.71	1169.71	1159.49	1164.97	86851.0
2011-08-18 06:00:00	ES	Futures	1165.22	1167.22	1161.98	1166.47	39520.0
2011-08-18 07:00:00	ES	Futures	1166.47	1168.71	1162.48	1162.73	54634.0
2011-08-18 08:00:00	ES	Futures	1162.73	1165.22	1158.24	1158.99	111848.0
2011-08-18 09:00:00	ES	Futures	1159.24	1160.98	1146.77	1148.76	510391.0
2011-08-18 10:00:00	ES	Futures	1149.01	1149.01	1128.31	1140.78	824021.0
2011-08-18 11:00:00	ES	Futures	1141.03	1145.27	1134.55	1144.27	367472.0
2011-08-18 12:00:00	ES	Futures	1144.27	1145.52	1138.54	1140.53	236644.0
2011-08-18 13:00:00	ES	Futures	1140.28	1141.28	1130.8	1133.05	255593.0
2011-08-18 14:00:00	ES	Futures	1132.8	1141.03	1130.06	1130.06	327771.0
2011-08-18 15:00:00	ES	Futures	1130.06	1139.78	1125.57	1137.54	639946.0
2011-08-18 16:00:00	ES	Futures	1137.54	1142.28	1136.29	1140.03	155582.0
2011-08-18 17:00:00	ES	Futures	1140.28	1141.53	1138.54	1141.28	10735.0
2011-08-18 18:00:00	ES	Futures	1140.03	1142.03	1138.79	1141.28	8647.0
2011-08-18 19:00:00	ES	Futures	1141.28	1142.28	1133.3	1134.05	11568.0
2011-08-18 20:00:00	ES	Futures	1134.3	1136.54	1133.05	1133.3	16648.0
2011-08-18 21:00:00	ES	Futures	1133.8	1134.05	1129.56	1131.8	17766.0
2011-08-18 22:00:00	ES	Futures	1132.05	1133.8	1129.81	1132.3	9119.0
2011-08-18 23:00:00	ES	Futures	1132.3	1135.54	1129.56	1132.3	10790.0
2011-08-18 00:00:00	NQ	Futures	2486.0	2486.58	2475.36	2479.67	976.0
2011-08-18 01:00:00	NQ	Futures	2480.82	2487.44	2479.67	2483.7	564.0
2011-08-18 02:00:00	NQ	Futures	2483.99	2485.14	2475.64	2478.52	1226.0
2011-08-18 03:00:00	NQ	Futures	2478.23	2483.99	2470.75	2470.75	5729.0
2011-08-18 04:00:00	NQ	Futures	2470.46	2473.63	2458.67	2461.54	4191.0
2011-08-18 05:00:00	NQ	Futures	2460.97	2462.98	2441.4	2451.76	5810.0
2011-08-18 06:00:00	NQ	Futures	2452.05	2456.94	2448.31	2455.21	2742.0
2011-08-18 07:00:00	NQ	Futures	2455.21	2459.53	2446.29	2448.88	4716.0
2011-08-18 08:00:00	NQ	Futures	2448.88	2455.5	2442.84	2446.87	12458.0
2011-08-18 09:00:00	NQ	Futures	2447.16	2451.18	2408.31	2409.46	73980.0
2011-08-18 10:00:00	NQ	Futures	2409.46	2409.46	2375.5	2401.11	98784.0
2011-08-18 11:00:00	NQ	Futures	2401.4	2411.76	2389.6	2410.03	43126.0
2011-08-18 12:00:00	NQ	Futures	2410.03	2417.8	2399.39	2404.57	32330.0
2011-08-18 13:00:00	NQ	Futures	2404.28	2406.01	2382.12	2385.29	28866.0
2011-08-18 14:00:00	NQ	Futures	2385.29	2399.39	2374.64	2374.93	33682.0
2011-08-18 15:00:00	NQ	Futures	2374.93	2394.78	2363.13	2387.01	75489.0
2011-08-18 16:00:00	NQ	Futures	2387.01	2401.69	2386.15	2397.66	15225.0
2011-08-18 17:00:00	NQ	Futures	2396.8	2400.25	2393.34	2400.25	346.0
2011-08-18 18:00:00	NQ	Futures	2397.37	2399.1	2393.63	2398.81	527.0
2011-08-18 19:00:00	NQ	Futures	2398.81	2400.25	2385.86	2386.73	777.0
2011-08-18 20:00:00	NQ	Futures	2386.73	2391.33	2385.29	2385.57	1009.0
2011-08-18 21:00:00	NQ	Futures	2386.15	2387.01	2378.38	2382.12	1266.0
2011-08-18 22:00:00	NQ	Futures	2382.41	2386.73	2379.24	2384.14	568.0
2011-08-18 23:00:00	NQ	Futures	2383.85	2391.04	2378.38	2383.56	684.0
2011-08-18 00:00:00	YM	Futures	10962.3	10972.0	10917.7	10936.1	1283.0
2011-08-18 01:00:00	YM	Futures	10937.1	10964.2	10935.2	10951.6	586.0

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

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