PREVIEW / futures_1hour / 2011-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-05.parquet
  size:    50 KB
  rows:    1,477

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-10-05 00:00:00	ES	Futures	1115.62	1117.13	1114.37	1115.12	5534.0
2011-10-05 01:00:00	ES	Futures	1115.37	1116.63	1112.11	1115.12	12085.0
2011-10-05 02:00:00	ES	Futures	1115.12	1119.38	1111.86	1118.13	23737.0
2011-10-05 03:00:00	ES	Futures	1118.13	1119.63	1109.86	1111.61	57960.0
2011-10-05 04:00:00	ES	Futures	1111.36	1118.88	1111.36	1118.38	39434.0
2011-10-05 05:00:00	ES	Futures	1118.38	1119.13	1112.11	1116.37	31582.0
2011-10-05 06:00:00	ES	Futures	1116.37	1128.16	1115.37	1125.9	68086.0
2011-10-05 07:00:00	ES	Futures	1125.9	1126.66	1121.14	1121.64	38623.0
2011-10-05 08:00:00	ES	Futures	1121.64	1126.15	1116.63	1117.38	117362.0
2011-10-05 09:00:00	ES	Futures	1117.38	1124.15	1112.86	1117.88	383570.0
2011-10-05 10:00:00	ES	Futures	1117.63	1132.42	1116.37	1131.42	616290.0
2011-10-05 11:00:00	ES	Futures	1131.42	1131.92	1124.9	1130.17	261302.0
2011-10-05 12:00:00	ES	Futures	1130.17	1131.42	1121.14	1125.4	221538.0
2011-10-05 13:00:00	ES	Futures	1125.4	1136.94	1125.4	1135.68	243007.0
2011-10-05 14:00:00	ES	Futures	1135.68	1137.44	1129.67	1135.18	220234.0
2011-10-05 15:00:00	ES	Futures	1134.93	1144.71	1130.67	1141.95	463262.0
2011-10-05 16:00:00	ES	Futures	1142.2	1142.96	1137.44	1138.94	106341.0
2011-10-05 17:00:00	ES	Futures	1138.69	1139.7	1137.94	1139.19	2560.0
2011-10-05 18:00:00	ES	Futures	1139.19	1139.44	1136.44	1136.44	3584.0
2011-10-05 19:00:00	ES	Futures	1136.44	1138.94	1135.18	1135.43	11754.0
2011-10-05 20:00:00	ES	Futures	1135.43	1137.94	1134.43	1136.44	14382.0
2011-10-05 21:00:00	ES	Futures	1136.44	1138.44	1134.43	1137.44	8794.0
2011-10-05 22:00:00	ES	Futures	1137.69	1137.69	1135.18	1136.69	4361.0
2011-10-05 23:00:00	ES	Futures	1136.69	1136.69	1134.43	1136.18	3836.0
2011-10-05 00:00:00	NQ	Futures	2436.61	2440.07	2434.02	2435.17	685.0
2011-10-05 01:00:00	NQ	Futures	2434.88	2436.61	2426.52	2435.46	2092.0
2011-10-05 02:00:00	NQ	Futures	2435.75	2444.97	2429.69	2442.67	1693.0
2011-10-05 03:00:00	NQ	Futures	2442.38	2446.13	2423.06	2425.66	2952.0
2011-10-05 04:00:00	NQ	Futures	2426.23	2439.21	2425.37	2438.63	2291.0
2011-10-05 05:00:00	NQ	Futures	2438.34	2440.36	2425.95	2434.59	1451.0
2011-10-05 06:00:00	NQ	Futures	2434.88	2457.95	2432.86	2452.18	4004.0
2011-10-05 07:00:00	NQ	Futures	2451.61	2454.49	2443.53	2444.11	4201.0
2011-10-05 08:00:00	NQ	Futures	2444.4	2453.62	2432.0	2433.44	9893.0
2011-10-05 09:00:00	NQ	Futures	2433.73	2446.7	2421.04	2434.88	58235.0
2011-10-05 10:00:00	NQ	Futures	2433.73	2481.88	2431.14	2480.15	96674.0
2011-10-05 11:00:00	NQ	Futures	2480.15	2489.95	2466.31	2485.92	40704.0
2011-10-05 12:00:00	NQ	Futures	2486.2	2488.8	2464.0	2477.84	31139.0
2011-10-05 13:00:00	NQ	Futures	2478.13	2507.25	2477.27	2504.37	36528.0
2011-10-05 14:00:00	NQ	Futures	2504.37	2511.29	2493.12	2505.23	36226.0
2011-10-05 15:00:00	NQ	Futures	2504.95	2516.48	2491.68	2509.85	53019.0
2011-10-05 16:00:00	NQ	Futures	2509.56	2509.85	2498.89	2503.79	10787.0
2011-10-05 17:00:00	NQ	Futures	2504.37	2504.66	2501.77	2504.66	429.0
2011-10-05 18:00:00	NQ	Futures	2504.95	2505.23	2493.99	2494.28	1511.0
2011-10-05 19:00:00	NQ	Futures	2494.28	2500.91	2483.32	2483.9	4122.0
2011-10-05 20:00:00	NQ	Futures	2483.9	2485.34	2477.84	2482.46	3237.0
2011-10-05 21:00:00	NQ	Futures	2482.46	2488.51	2481.3	2484.19	1687.0
2011-10-05 22:00:00	NQ	Futures	2484.19	2488.8	2481.59	2487.65	755.0
2011-10-05 23:00:00	NQ	Futures	2486.78	2488.8	2483.61	2487.93	494.0
2011-10-05 00:00:00	YM	Futures	10504.3	10516.1	10495.4	10501.3	490.0
2011-10-05 01:00:00	YM	Futures	10500.3	10510.2	10474.7	10500.3	999.0

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

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