PREVIEW / futures_1hour / 2010-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-24.parquet
  size:    46 KB
  rows:    1,338

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
2010-11-24 00:00:00	ES	Futures	1167.32	1167.82	1166.58	1166.83	2943.0
2010-11-24 01:00:00	ES	Futures	1166.58	1167.82	1165.35	1165.35	3402.0
2010-11-24 02:00:00	ES	Futures	1165.6	1166.83	1165.35	1166.09	12320.0
2010-11-24 03:00:00	ES	Futures	1165.85	1166.58	1159.44	1159.68	54017.0
2010-11-24 04:00:00	ES	Futures	1159.68	1162.64	1158.94	1160.18	40492.0
2010-11-24 05:00:00	ES	Futures	1159.93	1164.61	1159.44	1164.37	28885.0
2010-11-24 06:00:00	ES	Futures	1164.37	1166.83	1163.63	1163.63	39644.0
2010-11-24 07:00:00	ES	Futures	1163.63	1166.34	1162.39	1165.11	47144.0
2010-11-24 08:00:00	ES	Futures	1165.11	1172.99	1164.86	1170.28	124032.0
2010-11-24 09:00:00	ES	Futures	1170.28	1174.72	1169.54	1173.73	270571.0
2010-11-24 10:00:00	ES	Futures	1173.49	1178.66	1171.27	1176.94	379445.0
2010-11-24 11:00:00	ES	Futures	1177.18	1178.42	1175.7	1177.43	156772.0
2010-11-24 12:00:00	ES	Futures	1177.18	1178.91	1176.94	1178.42	90895.0
2010-11-24 13:00:00	ES	Futures	1178.42	1180.14	1177.68	1178.91	79215.0
2010-11-24 14:00:00	ES	Futures	1179.15	1179.4	1177.18	1178.66	64445.0
2010-11-24 15:00:00	ES	Futures	1178.66	1180.63	1177.43	1179.89	211466.0
2010-11-24 16:00:00	ES	Futures	1179.89	1180.14	1178.17	1178.42	100321.0
2010-11-24 17:00:00	ES	Futures	1178.42	1178.91	1178.17	1178.42	552.0
2010-11-24 18:00:00	ES	Futures	1178.66	1179.89	1178.17	1179.15	3008.0
2010-11-24 19:00:00	ES	Futures	1179.15	1179.65	1177.43	1177.92	3321.0
2010-11-24 20:00:00	ES	Futures	1177.92	1178.17	1177.43	1177.68	2242.0
2010-11-24 21:00:00	ES	Futures	1177.43	1178.17	1176.94	1177.43	1962.0
2010-11-24 22:00:00	ES	Futures	1177.43	1178.42	1175.95	1177.92	3990.0
2010-11-24 23:00:00	ES	Futures	1177.92	1179.89	1177.68	1178.42	2514.0
2010-11-24 00:00:00	NQ	Futures	2440.97	2441.54	2440.11	2440.11	149.0
2010-11-24 01:00:00	NQ	Futures	2439.82	2440.97	2436.95	2437.52	274.0
2010-11-24 02:00:00	NQ	Futures	2437.24	2440.11	2437.24	2438.67	285.0
2010-11-24 03:00:00	NQ	Futures	2438.1	2439.53	2427.2	2427.48	2844.0
2010-11-24 04:00:00	NQ	Futures	2427.48	2432.36	2425.19	2427.48	2234.0
2010-11-24 05:00:00	NQ	Futures	2426.91	2436.09	2426.62	2435.52	1366.0
2010-11-24 06:00:00	NQ	Futures	2435.8	2439.53	2433.22	2433.22	2034.0
2010-11-24 07:00:00	NQ	Futures	2433.22	2438.67	2431.79	2436.66	2784.0
2010-11-24 08:00:00	NQ	Futures	2436.95	2454.74	2436.38	2451.58	12485.0
2010-11-24 09:00:00	NQ	Futures	2451.01	2466.5	2449.86	2464.21	50595.0
2010-11-24 10:00:00	NQ	Futures	2463.63	2482.57	2460.48	2479.99	69697.0
2010-11-24 11:00:00	NQ	Futures	2479.99	2482.28	2476.26	2479.12	27546.0
2010-11-24 12:00:00	NQ	Futures	2479.12	2481.99	2478.84	2481.42	18511.0
2010-11-24 13:00:00	NQ	Futures	2481.13	2485.15	2479.7	2480.27	15044.0
2010-11-24 14:00:00	NQ	Futures	2480.27	2481.42	2477.12	2479.12	15461.0
2010-11-24 15:00:00	NQ	Futures	2479.12	2481.99	2475.39	2478.55	32573.0
2010-11-24 16:00:00	NQ	Futures	2478.55	2479.12	2474.82	2476.26	9348.0
2010-11-24 17:00:00	NQ	Futures	2476.83	2477.98	2474.82	2477.69	105.0
2010-11-24 18:00:00	NQ	Futures	2477.69	2479.99	2477.4	2479.41	206.0
2010-11-24 19:00:00	NQ	Futures	2478.84	2479.7	2475.11	2475.97	285.0
2010-11-24 20:00:00	NQ	Futures	2475.68	2476.83	2472.24	2472.81	353.0
2010-11-24 21:00:00	NQ	Futures	2473.1	2475.97	2472.53	2474.25	190.0
2010-11-24 22:00:00	NQ	Futures	2473.96	2474.82	2472.24	2474.82	166.0
2010-11-24 23:00:00	NQ	Futures	2474.53	2479.12	2474.25	2475.39	193.0
2010-11-24 00:00:00	YM	Futures	10533.5	10538.2	10529.6	10529.6	151.0
2010-11-24 01:00:00	YM	Futures	10529.6	10538.2	10522.0	10522.0	362.0

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

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