PREVIEW / futures_1hour / 2011-09-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1140.03	1140.03	1133.3	1134.05	8380.0
2011-09-06 01:00:00	ES	Futures	1134.05	1137.54	1133.3	1135.54	7152.0
2011-09-06 02:00:00	ES	Futures	1135.79	1144.52	1135.04	1143.52	23320.0
2011-09-06 03:00:00	ES	Futures	1143.77	1149.01	1142.78	1148.26	95414.0
2011-09-06 04:00:00	ES	Futures	1148.26	1153.5	1143.77	1148.76	114535.0
2011-09-06 05:00:00	ES	Futures	1149.01	1153.75	1147.02	1149.76	35132.0
2011-09-06 06:00:00	ES	Futures	1149.51	1151.51	1146.52	1149.26	25638.0
2011-09-06 07:00:00	ES	Futures	1149.26	1151.01	1139.28	1139.78	50568.0
2011-09-06 08:00:00	ES	Futures	1139.78	1142.78	1135.54	1136.04	98175.0
2011-09-06 09:00:00	ES	Futures	1136.04	1145.77	1133.3	1144.52	414979.0
2011-09-06 10:00:00	ES	Futures	1144.52	1151.01	1135.54	1142.28	589227.0
2011-09-06 11:00:00	ES	Futures	1142.03	1149.01	1140.03	1147.51	354900.0
2011-09-06 12:00:00	ES	Futures	1147.76	1152.25	1146.77	1148.76	176266.0
2011-09-06 13:00:00	ES	Futures	1149.01	1155.99	1147.76	1153.75	211166.0
2011-09-06 14:00:00	ES	Futures	1153.5	1160.23	1152.75	1153.5	240295.0
2011-09-06 15:00:00	ES	Futures	1153.5	1163.23	1148.51	1161.73	512689.0
2011-09-06 16:00:00	ES	Futures	1161.73	1163.73	1160.23	1162.48	115758.0
2011-09-06 17:00:00	ES	Futures	1162.48	1164.47	1161.98	1164.23	3319.0
2011-09-06 18:00:00	ES	Futures	1163.73	1164.23	1162.48	1163.23	4760.0
2011-09-06 19:00:00	ES	Futures	1162.98	1165.47	1162.73	1163.98	5830.0
2011-09-06 20:00:00	ES	Futures	1163.98	1164.97	1163.23	1164.23	6350.0
2011-09-06 21:00:00	ES	Futures	1164.47	1169.21	1164.23	1166.22	16690.0
2011-09-06 22:00:00	ES	Futures	1166.22	1168.46	1165.22	1166.97	5679.0
2011-09-06 23:00:00	ES	Futures	1166.72	1169.96	1166.72	1167.97	3961.0
2011-09-06 00:00:00	NQ	Futures	2441.98	2441.98	2430.18	2431.33	622.0
2011-09-06 01:00:00	NQ	Futures	2431.33	2438.81	2430.47	2433.92	394.0
2011-09-06 02:00:00	NQ	Futures	2433.92	2455.21	2433.34	2452.62	2576.0
2011-09-06 03:00:00	NQ	Futures	2452.62	2465.29	2450.03	2463.27	6832.0
2011-09-06 04:00:00	NQ	Futures	2463.27	2474.49	2455.21	2465.0	9280.0
2011-09-06 05:00:00	NQ	Futures	2464.71	2472.48	2460.68	2465.57	2920.0
2011-09-06 06:00:00	NQ	Futures	2465.29	2470.75	2459.24	2465.57	2292.0
2011-09-06 07:00:00	NQ	Futures	2465.57	2469.03	2445.14	2445.14	3905.0
2011-09-06 08:00:00	NQ	Futures	2445.72	2453.77	2441.4	2443.13	7297.0
2011-09-06 09:00:00	NQ	Futures	2443.13	2451.76	2435.36	2448.59	46666.0
2011-09-06 10:00:00	NQ	Futures	2449.75	2458.38	2431.04	2447.73	54424.0
2011-09-06 11:00:00	NQ	Futures	2447.73	2462.41	2440.54	2455.21	34774.0
2011-09-06 12:00:00	NQ	Futures	2454.93	2465.29	2453.49	2456.36	19572.0
2011-09-06 13:00:00	NQ	Futures	2456.36	2476.8	2453.77	2472.77	25813.0
2011-09-06 14:00:00	NQ	Futures	2472.48	2489.46	2471.33	2475.93	27904.0
2011-09-06 15:00:00	NQ	Futures	2476.22	2499.24	2463.85	2495.5	52434.0
2011-09-06 16:00:00	NQ	Futures	2495.5	2498.67	2491.76	2494.93	7484.0
2011-09-06 17:00:00	NQ	Futures	2494.35	2498.09	2493.77	2496.65	218.0
2011-09-06 18:00:00	NQ	Futures	2498.09	2498.09	2494.35	2495.5	244.0
2011-09-06 19:00:00	NQ	Futures	2496.08	2500.97	2495.79	2498.09	450.0
2011-09-06 20:00:00	NQ	Futures	2497.8	2499.24	2496.08	2498.38	422.0
2011-09-06 21:00:00	NQ	Futures	2498.67	2507.01	2498.67	2502.12	1112.0
2011-09-06 22:00:00	NQ	Futures	2502.41	2506.15	2500.39	2502.69	350.0
2011-09-06 23:00:00	NQ	Futures	2503.27	2509.31	2502.98	2505.0	488.0
2011-09-06 00:00:00	YM	Futures	10628.2	10628.2	10576.9	10579.8	589.0
2011-09-06 01:00:00	YM	Futures	10581.7	10607.8	10574.9	10594.3	384.0

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

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