PREVIEW / futures_1hour / 2011-08-17

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-17.parquet
  size:    47 KB
  rows:    1,422

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-17 00:00:00	ES	Futures	1186.42	1191.91	1185.92	1190.41	7454.0
2011-08-17 01:00:00	ES	Futures	1190.66	1192.66	1189.42	1189.42	8205.0
2011-08-17 02:00:00	ES	Futures	1189.66	1190.16	1185.42	1185.92	23283.0
2011-08-17 03:00:00	ES	Futures	1186.17	1189.17	1180.94	1188.67	54303.0
2011-08-17 04:00:00	ES	Futures	1188.67	1192.41	1184.93	1187.92	34483.0
2011-08-17 05:00:00	ES	Futures	1187.67	1191.91	1187.67	1188.17	23050.0
2011-08-17 06:00:00	ES	Futures	1188.17	1195.9	1187.42	1194.15	28980.0
2011-08-17 07:00:00	ES	Futures	1194.15	1195.9	1192.91	1194.65	41825.0
2011-08-17 08:00:00	ES	Futures	1194.4	1195.15	1190.66	1192.91	40291.0
2011-08-17 09:00:00	ES	Futures	1192.66	1203.38	1192.16	1201.64	291120.0
2011-08-17 10:00:00	ES	Futures	1201.64	1203.88	1194.9	1195.15	310934.0
2011-08-17 11:00:00	ES	Futures	1195.4	1199.14	1187.42	1189.17	330764.0
2011-08-17 12:00:00	ES	Futures	1189.17	1190.16	1183.68	1185.67	216989.0
2011-08-17 13:00:00	ES	Futures	1185.42	1187.17	1178.69	1182.43	202101.0
2011-08-17 14:00:00	ES	Futures	1182.43	1187.92	1182.18	1187.17	131091.0
2011-08-17 15:00:00	ES	Futures	1187.17	1189.66	1185.18	1188.42	215186.0
2011-08-17 16:00:00	ES	Futures	1188.42	1189.66	1183.43	1184.43	95314.0
2011-08-17 17:00:00	ES	Futures	1184.43	1186.17	1183.68	1183.68	2751.0
2011-08-17 18:00:00	ES	Futures	1184.43	1186.17	1183.93	1184.68	2594.0
2011-08-17 19:00:00	ES	Futures	1184.68	1185.67	1183.43	1185.42	4065.0
2011-08-17 20:00:00	ES	Futures	1185.42	1185.42	1179.94	1180.69	9247.0
2011-08-17 21:00:00	ES	Futures	1180.69	1181.43	1178.69	1180.94	13275.0
2011-08-17 22:00:00	ES	Futures	1180.94	1181.43	1179.19	1180.69	4829.0
2011-08-17 23:00:00	ES	Futures	1180.69	1181.43	1179.69	1179.94	1993.0
2011-08-17 00:00:00	NQ	Futures	2520.54	2530.9	2519.67	2529.17	653.0
2011-08-17 01:00:00	NQ	Futures	2528.88	2531.18	2526.0	2526.29	622.0
2011-08-17 02:00:00	NQ	Futures	2526.0	2526.0	2516.51	2517.08	1336.0
2011-08-17 03:00:00	NQ	Futures	2517.66	2524.28	2508.74	2523.13	3477.0
2011-08-17 04:00:00	NQ	Futures	2523.13	2530.32	2514.78	2521.11	1584.0
2011-08-17 05:00:00	NQ	Futures	2521.11	2529.17	2521.11	2521.97	1626.0
2011-08-17 06:00:00	NQ	Futures	2522.26	2534.64	2521.11	2531.76	1950.0
2011-08-17 07:00:00	NQ	Futures	2531.18	2535.21	2529.17	2533.49	2526.0
2011-08-17 08:00:00	NQ	Futures	2532.91	2534.06	2524.56	2528.02	4442.0
2011-08-17 09:00:00	NQ	Futures	2528.31	2548.45	2521.69	2544.71	37691.0
2011-08-17 10:00:00	NQ	Futures	2544.71	2546.15	2522.84	2523.13	37714.0
2011-08-17 11:00:00	NQ	Futures	2523.13	2530.03	2502.41	2506.44	46217.0
2011-08-17 12:00:00	NQ	Futures	2506.72	2513.63	2493.77	2502.98	27907.0
2011-08-17 13:00:00	NQ	Futures	2502.98	2502.98	2483.13	2489.46	30138.0
2011-08-17 14:00:00	NQ	Futures	2489.46	2504.71	2489.46	2501.83	17868.0
2011-08-17 15:00:00	NQ	Futures	2501.83	2510.18	2497.23	2509.03	39125.0
2011-08-17 16:00:00	NQ	Futures	2509.03	2511.33	2494.35	2494.93	11116.0
2011-08-17 17:00:00	NQ	Futures	2495.5	2498.09	2494.93	2494.93	273.0
2011-08-17 18:00:00	NQ	Futures	2496.08	2498.67	2494.06	2496.65	245.0
2011-08-17 19:00:00	NQ	Futures	2496.65	2496.94	2493.49	2495.79	619.0
2011-08-17 20:00:00	NQ	Futures	2496.65	2496.65	2485.14	2487.44	882.0
2011-08-17 21:00:00	NQ	Futures	2487.16	2489.17	2483.7	2488.31	1037.0
2011-08-17 22:00:00	NQ	Futures	2487.44	2488.59	2484.57	2487.44	509.0
2011-08-17 23:00:00	NQ	Futures	2487.44	2489.75	2485.43	2486.0	239.0
2011-08-17 00:00:00	YM	Futures	11005.9	11045.6	11000.0	11038.8	421.0
2011-08-17 01:00:00	YM	Futures	11039.8	11055.2	11025.2	11026.2	353.0

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

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