PREVIEW / futures_1hour / 2011-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-23.parquet
  size:    48 KB
  rows:    1,410

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-23 00:00:00	ES	Futures	1128.56	1131.3	1126.56	1130.56	7202.0
2011-08-23 01:00:00	ES	Futures	1130.56	1132.05	1129.81	1131.3	6834.0
2011-08-23 02:00:00	ES	Futures	1131.05	1136.79	1130.56	1136.04	34990.0
2011-08-23 03:00:00	ES	Futures	1136.29	1143.03	1134.8	1141.78	67322.0
2011-08-23 04:00:00	ES	Futures	1142.03	1143.03	1136.54	1137.54	50552.0
2011-08-23 05:00:00	ES	Futures	1137.54	1140.03	1133.3	1139.04	40630.0
2011-08-23 06:00:00	ES	Futures	1139.04	1139.53	1134.3	1135.54	30349.0
2011-08-23 07:00:00	ES	Futures	1135.79	1138.79	1130.06	1130.56	52907.0
2011-08-23 08:00:00	ES	Futures	1130.56	1134.3	1124.07	1125.32	99440.0
2011-08-23 09:00:00	ES	Futures	1125.07	1128.06	1117.59	1123.57	405661.0
2011-08-23 10:00:00	ES	Futures	1123.57	1136.79	1122.82	1130.56	460186.0
2011-08-23 11:00:00	ES	Futures	1130.31	1145.02	1129.06	1144.02	429623.0
2011-08-23 12:00:00	ES	Futures	1144.27	1147.02	1140.03	1145.27	245506.0
2011-08-23 13:00:00	ES	Futures	1145.52	1147.76	1135.29	1139.04	286957.0
2011-08-23 14:00:00	ES	Futures	1139.28	1146.77	1135.29	1146.02	255126.0
2011-08-23 15:00:00	ES	Futures	1146.02	1157.24	1145.77	1156.24	646639.0
2011-08-23 16:00:00	ES	Futures	1156.49	1157.99	1155.25	1157.74	146464.0
2011-08-23 17:00:00	ES	Futures	1157.74	1158.99	1156.99	1157.24	3923.0
2011-08-23 18:00:00	ES	Futures	1157.24	1157.24	1154.25	1154.5	5485.0
2011-08-23 19:00:00	ES	Futures	1154.5	1155.0	1152.25	1153.25	7723.0
2011-08-23 20:00:00	ES	Futures	1153.0	1153.75	1149.51	1150.26	14520.0
2011-08-23 21:00:00	ES	Futures	1150.26	1152.25	1146.27	1147.27	16076.0
2011-08-23 22:00:00	ES	Futures	1147.27	1148.51	1143.77	1145.52	11661.0
2011-08-23 23:00:00	ES	Futures	1145.77	1148.01	1144.77	1147.27	6059.0
2011-08-23 00:00:00	NQ	Futures	2370.32	2375.5	2366.01	2374.06	505.0
2011-08-23 01:00:00	NQ	Futures	2374.35	2377.23	2372.62	2376.08	393.0
2011-08-23 02:00:00	NQ	Futures	2375.79	2385.57	2375.21	2384.71	1691.0
2011-08-23 03:00:00	NQ	Futures	2384.71	2396.8	2382.41	2394.21	3817.0
2011-08-23 04:00:00	NQ	Futures	2394.49	2396.22	2385.0	2386.15	2105.0
2011-08-23 05:00:00	NQ	Futures	2386.44	2391.91	2378.38	2389.6	1657.0
2011-08-23 06:00:00	NQ	Futures	2389.6	2390.18	2380.11	2382.12	1379.0
2011-08-23 07:00:00	NQ	Futures	2382.98	2389.6	2372.34	2373.49	2933.0
2011-08-23 08:00:00	NQ	Futures	2373.49	2381.83	2362.84	2365.43	6605.0
2011-08-23 09:00:00	NQ	Futures	2365.43	2385.29	2357.37	2378.09	39160.0
2011-08-23 10:00:00	NQ	Futures	2378.09	2401.69	2376.08	2387.88	42031.0
2011-08-23 11:00:00	NQ	Futures	2387.88	2415.21	2382.98	2413.78	32434.0
2011-08-23 12:00:00	NQ	Futures	2413.49	2422.98	2406.87	2419.24	23621.0
2011-08-23 13:00:00	NQ	Futures	2419.53	2425.29	2400.54	2408.88	24975.0
2011-08-23 14:00:00	NQ	Futures	2409.17	2430.18	2403.13	2428.16	23982.0
2011-08-23 15:00:00	NQ	Futures	2428.45	2448.31	2428.45	2447.44	49473.0
2011-08-23 16:00:00	NQ	Futures	2447.44	2450.9	2443.99	2447.16	12296.0
2011-08-23 17:00:00	NQ	Futures	2447.44	2448.88	2445.72	2447.16	155.0
2011-08-23 18:00:00	NQ	Futures	2447.44	2447.44	2439.1	2440.25	847.0
2011-08-23 19:00:00	NQ	Futures	2440.25	2440.25	2436.8	2437.95	666.0
2011-08-23 20:00:00	NQ	Futures	2437.95	2438.52	2431.33	2433.06	834.0
2011-08-23 21:00:00	NQ	Futures	2432.19	2437.37	2425.86	2429.03	841.0
2011-08-23 22:00:00	NQ	Futures	2428.16	2430.18	2421.83	2424.71	699.0
2011-08-23 23:00:00	NQ	Futures	2423.56	2429.31	2423.56	2428.16	558.0
2011-08-23 00:00:00	YM	Futures	10570.1	10590.4	10555.6	10585.6	427.0
2011-08-23 01:00:00	YM	Futures	10587.5	10599.1	10577.8	10587.5	508.0

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

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