PREVIEW / futures_1hour / 2011-09-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1163.98	1164.23	1161.73	1162.98	1609.0
2011-09-13 01:00:00	ES	Futures	1162.98	1163.23	1159.74	1160.23	3504.0
2011-09-13 02:00:00	ES	Futures	1160.48	1164.72	1159.74	1163.48	5587.0
2011-09-13 03:00:00	ES	Futures	1163.48	1163.48	1147.02	1147.76	20563.0
2011-09-13 04:00:00	ES	Futures	1148.01	1151.26	1142.28	1148.76	23542.0
2011-09-13 05:00:00	ES	Futures	1149.01	1151.75	1144.52	1145.77	12520.0
2011-09-13 06:00:00	ES	Futures	1145.52	1151.51	1143.52	1149.01	11475.0
2011-09-13 07:00:00	ES	Futures	1149.26	1162.73	1149.01	1154.25	30195.0
2011-09-13 08:00:00	ES	Futures	1154.75	1162.23	1151.01	1158.49	19431.0
2011-09-13 09:00:00	ES	Futures	1158.49	1167.22	1153.75	1166.47	42236.0
2011-09-13 10:00:00	ES	Futures	1166.47	1171.46	1160.73	1162.73	48064.0
2011-09-13 11:00:00	ES	Futures	1162.48	1165.22	1157.24	1161.48	26469.0
2011-09-13 12:00:00	ES	Futures	1161.23	1166.22	1157.74	1164.97	17951.0
2011-09-13 13:00:00	ES	Futures	1165.22	1171.21	1164.97	1169.21	18013.0
2011-09-13 14:00:00	ES	Futures	1169.21	1173.95	1166.47	1168.22	27498.0
2011-09-13 15:00:00	ES	Futures	1168.22	1172.46	1161.98	1169.21	45382.0
2011-09-13 16:00:00	ES	Futures	1169.21	1169.96	1164.97	1166.72	11669.0
2011-09-13 17:00:00	ES	Futures	1166.47	1167.97	1165.97	1167.97	174.0
2011-09-13 18:00:00	ES	Futures	1167.72	1167.72	1164.72	1167.22	736.0
2011-09-13 19:00:00	ES	Futures	1167.22	1167.47	1163.73	1164.23	1168.0
2011-09-13 20:00:00	ES	Futures	1164.47	1169.21	1164.47	1168.22	1548.0
2011-09-13 21:00:00	ES	Futures	1168.46	1168.96	1165.22	1165.22	1821.0
2011-09-13 22:00:00	ES	Futures	1165.22	1166.47	1162.48	1162.73	1077.0
2011-09-13 23:00:00	ES	Futures	1162.73	1162.98	1155.0	1155.99	2517.0
2011-09-13 00:00:00	NQ	Futures	2535.79	2535.79	2531.18	2532.62	58.0
2011-09-13 01:00:00	NQ	Futures	2532.05	2533.2	2528.88	2528.88	358.0
2011-09-13 02:00:00	NQ	Futures	2529.46	2537.23	2527.73	2534.64	272.0
2011-09-13 03:00:00	NQ	Futures	2535.79	2535.79	2502.41	2505.57	1489.0
2011-09-13 04:00:00	NQ	Futures	2504.42	2510.46	2494.06	2505.86	813.0
2011-09-13 05:00:00	NQ	Futures	2506.72	2512.48	2499.82	2501.54	380.0
2011-09-13 06:00:00	NQ	Futures	2500.97	2512.77	2497.23	2507.01	322.0
2011-09-13 07:00:00	NQ	Futures	2507.59	2536.08	2507.3	2521.97	2673.0
2011-09-13 08:00:00	NQ	Futures	2521.97	2536.08	2514.21	2527.73	1310.0
2011-09-13 09:00:00	NQ	Futures	2527.44	2540.97	2519.96	2539.53	5124.0
2011-09-13 10:00:00	NQ	Futures	2539.53	2548.74	2528.02	2532.33	7981.0
2011-09-13 11:00:00	NQ	Futures	2532.05	2537.23	2523.99	2533.2	4084.0
2011-09-13 12:00:00	NQ	Futures	2532.33	2542.69	2525.14	2540.39	2699.0
2011-09-13 13:00:00	NQ	Futures	2540.97	2556.79	2540.97	2553.05	2469.0
2011-09-13 14:00:00	NQ	Futures	2553.05	2561.97	2548.74	2552.48	3098.0
2011-09-13 15:00:00	NQ	Futures	2552.48	2561.69	2540.68	2556.22	6322.0
2011-09-13 16:00:00	NQ	Futures	2555.93	2559.1	2549.6	2551.9	1132.0
2011-09-13 17:00:00	NQ	Futures	2551.9	2554.2	2551.9	2554.2	25.0
2011-09-13 18:00:00	NQ	Futures	2553.05	2553.05	2548.45	2553.05	53.0
2011-09-13 19:00:00	NQ	Futures	2553.05	2554.78	2547.01	2548.74	65.0
2011-09-13 20:00:00	NQ	Futures	2548.16	2556.79	2547.59	2555.36	328.0
2011-09-13 21:00:00	NQ	Futures	2555.07	2557.37	2550.46	2550.46	98.0
2011-09-13 22:00:00	NQ	Futures	2549.6	2552.48	2545.0	2546.15	86.0
2011-09-13 23:00:00	NQ	Futures	2545.0	2545.0	2530.61	2531.47	378.0
2011-09-13 00:00:00	YM	Futures	10851.8	10851.8	10832.1	10840.0	174.0
2011-09-13 01:00:00	YM	Futures	10840.0	10842.0	10818.3	10822.3	557.0

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

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