PREVIEW / futures_1hour / 2011-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-23.parquet
  size:    46 KB
  rows:    1,381

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-11-23 00:00:00	ES	Futures	1173.05	1173.8	1171.79	1173.55	4496.0
2011-11-23 01:00:00	ES	Futures	1173.3	1174.3	1171.79	1174.05	4088.0
2011-11-23 02:00:00	ES	Futures	1174.3	1176.06	1173.55	1173.8	16178.0
2011-11-23 03:00:00	ES	Futures	1173.8	1180.07	1172.54	1177.56	54201.0
2011-11-23 04:00:00	ES	Futures	1177.56	1181.32	1174.05	1177.81	37970.0
2011-11-23 05:00:00	ES	Futures	1177.81	1180.57	1170.79	1176.06	64307.0
2011-11-23 06:00:00	ES	Futures	1176.06	1181.57	1174.55	1178.56	47390.0
2011-11-23 07:00:00	ES	Futures	1178.31	1179.57	1174.55	1176.56	43959.0
2011-11-23 08:00:00	ES	Futures	1176.56	1178.56	1174.05	1175.3	48524.0
2011-11-23 09:00:00	ES	Futures	1175.55	1180.07	1171.79	1171.79	248355.0
2011-11-23 10:00:00	ES	Futures	1172.04	1173.55	1167.53	1170.54	373698.0
2011-11-23 11:00:00	ES	Futures	1170.54	1172.04	1164.52	1168.03	297216.0
2011-11-23 12:00:00	ES	Futures	1168.28	1173.05	1166.78	1172.29	168283.0
2011-11-23 13:00:00	ES	Futures	1172.04	1173.05	1167.28	1168.28	127319.0
2011-11-23 14:00:00	ES	Futures	1168.28	1169.28	1164.52	1166.78	173930.0
2011-11-23 15:00:00	ES	Futures	1166.78	1173.55	1163.27	1164.02	391711.0
2011-11-23 16:00:00	ES	Futures	1164.02	1164.77	1162.01	1163.27	119540.0
2011-11-23 17:00:00	ES	Futures	1163.02	1163.77	1163.02	1163.52	1164.0
2011-11-23 18:00:00	ES	Futures	1163.77	1165.02	1163.02	1164.52	6530.0
2011-11-23 19:00:00	ES	Futures	1164.52	1166.02	1163.52	1165.52	6021.0
2011-11-23 20:00:00	ES	Futures	1165.52	1168.03	1164.77	1167.78	8091.0
2011-11-23 21:00:00	ES	Futures	1167.53	1171.04	1166.78	1170.29	7488.0
2011-11-23 22:00:00	ES	Futures	1170.29	1171.54	1169.79	1170.04	4939.0
2011-11-23 23:00:00	ES	Futures	1170.04	1170.79	1168.28	1168.53	2327.0
2011-11-23 00:00:00	NQ	Futures	2527.43	2529.74	2526.28	2528.59	386.0
2011-11-23 01:00:00	NQ	Futures	2528.88	2531.47	2525.99	2529.45	463.0
2011-11-23 02:00:00	NQ	Futures	2529.45	2533.78	2527.72	2528.3	824.0
2011-11-23 03:00:00	NQ	Futures	2528.59	2541.85	2526.57	2536.66	3424.0
2011-11-23 04:00:00	NQ	Futures	2536.37	2545.02	2529.74	2540.12	3040.0
2011-11-23 05:00:00	NQ	Futures	2539.83	2545.6	2524.84	2534.93	4088.0
2011-11-23 06:00:00	NQ	Futures	2535.22	2545.31	2532.62	2537.53	3628.0
2011-11-23 07:00:00	NQ	Futures	2537.53	2540.12	2530.89	2535.22	2391.0
2011-11-23 08:00:00	NQ	Futures	2535.22	2539.54	2530.61	2533.49	3883.0
2011-11-23 09:00:00	NQ	Futures	2533.49	2543.0	2519.65	2519.94	35856.0
2011-11-23 10:00:00	NQ	Futures	2519.94	2523.4	2504.95	2515.04	50955.0
2011-11-23 11:00:00	NQ	Futures	2514.46	2517.92	2503.5	2508.98	30174.0
2011-11-23 12:00:00	NQ	Futures	2509.27	2517.92	2506.39	2516.77	17993.0
2011-11-23 13:00:00	NQ	Futures	2516.48	2520.23	2507.83	2510.14	16743.0
2011-11-23 14:00:00	NQ	Futures	2509.85	2510.71	2500.91	2506.1	20531.0
2011-11-23 15:00:00	NQ	Futures	2505.81	2519.94	2497.16	2497.74	38859.0
2011-11-23 16:00:00	NQ	Futures	2498.03	2500.04	2493.12	2497.74	9263.0
2011-11-23 17:00:00	NQ	Futures	2498.03	2498.31	2496.87	2498.03	38.0
2011-11-23 18:00:00	NQ	Futures	2498.03	2500.62	2496.87	2498.89	243.0
2011-11-23 19:00:00	NQ	Futures	2499.47	2503.22	2497.74	2500.62	634.0
2011-11-23 20:00:00	NQ	Futures	2500.04	2502.93	2497.74	2501.49	628.0
2011-11-23 21:00:00	NQ	Futures	2501.49	2508.41	2499.76	2508.12	482.0
2011-11-23 22:00:00	NQ	Futures	2507.54	2508.98	2504.37	2506.68	528.0
2011-11-23 23:00:00	NQ	Futures	2507.25	2509.56	2506.68	2506.68	539.0
2011-11-23 00:00:00	YM	Futures	11158.0	11165.9	11150.1	11162.0	481.0
2011-11-23 01:00:00	YM	Futures	11161.0	11166.9	11147.2	11162.9	462.0

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

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