PREVIEW / futures_1hour / 2010-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-18.parquet
  size:    48 KB
  rows:    1,432

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-18 00:00:00	ES	Futures	1169.79	1171.02	1167.82	1170.53	11091.0
2010-11-18 01:00:00	ES	Futures	1170.77	1171.76	1170.04	1171.27	11402.0
2010-11-18 02:00:00	ES	Futures	1171.51	1172.25	1169.79	1169.79	16732.0
2010-11-18 03:00:00	ES	Futures	1169.79	1173.73	1168.56	1173.24	42151.0
2010-11-18 04:00:00	ES	Futures	1173.24	1173.73	1172.25	1173.24	21790.0
2010-11-18 05:00:00	ES	Futures	1173.24	1173.98	1172.01	1172.75	23475.0
2010-11-18 06:00:00	ES	Futures	1172.75	1174.96	1172.75	1174.23	28238.0
2010-11-18 07:00:00	ES	Futures	1174.23	1174.47	1172.01	1172.5	28254.0
2010-11-18 08:00:00	ES	Futures	1172.25	1174.47	1172.25	1172.25	52725.0
2010-11-18 09:00:00	ES	Futures	1172.25	1175.95	1171.51	1173.49	263693.0
2010-11-18 10:00:00	ES	Futures	1173.73	1181.87	1173.73	1180.63	452732.0
2010-11-18 11:00:00	ES	Futures	1180.63	1181.87	1179.15	1179.89	217394.0
2010-11-18 12:00:00	ES	Futures	1179.89	1182.11	1179.65	1181.37	144958.0
2010-11-18 13:00:00	ES	Futures	1181.62	1181.62	1179.89	1180.14	101820.0
2010-11-18 14:00:00	ES	Futures	1180.14	1181.37	1178.42	1180.39	148715.0
2010-11-18 15:00:00	ES	Futures	1180.39	1181.13	1176.69	1178.17	291194.0
2010-11-18 16:00:00	ES	Futures	1178.17	1181.37	1177.92	1179.89	131487.0
2010-11-18 17:00:00	ES	Futures	1180.14	1181.37	1179.89	1181.37	3732.0
2010-11-18 18:00:00	ES	Futures	1181.37	1182.85	1181.13	1182.61	9588.0
2010-11-18 19:00:00	ES	Futures	1182.36	1182.85	1180.88	1181.37	5565.0
2010-11-18 20:00:00	ES	Futures	1181.37	1181.62	1179.15	1179.65	7286.0
2010-11-18 21:00:00	ES	Futures	1179.65	1180.63	1179.15	1180.14	7733.0
2010-11-18 22:00:00	ES	Futures	1179.89	1180.14	1177.68	1177.68	9239.0
2010-11-18 23:00:00	ES	Futures	1177.68	1178.42	1176.94	1178.17	8334.0
2010-11-18 00:00:00	NQ	Futures	2422.89	2426.05	2420.02	2425.47	638.0
2010-11-18 01:00:00	NQ	Futures	2425.76	2427.2	2424.9	2426.33	447.0
2010-11-18 02:00:00	NQ	Futures	2426.33	2428.06	2424.61	2424.61	1113.0
2010-11-18 03:00:00	NQ	Futures	2424.61	2437.24	2423.18	2436.09	4005.0
2010-11-18 04:00:00	NQ	Futures	2436.09	2437.24	2434.94	2436.66	1829.0
2010-11-18 05:00:00	NQ	Futures	2436.38	2437.24	2434.08	2434.94	1113.0
2010-11-18 06:00:00	NQ	Futures	2435.23	2438.1	2434.94	2437.24	2136.0
2010-11-18 07:00:00	NQ	Futures	2437.24	2437.24	2433.22	2433.79	1912.0
2010-11-18 08:00:00	NQ	Futures	2433.79	2437.81	2433.22	2433.79	4933.0
2010-11-18 09:00:00	NQ	Futures	2433.79	2444.12	2432.07	2440.97	45193.0
2010-11-18 10:00:00	NQ	Futures	2440.97	2458.47	2440.97	2457.03	60962.0
2010-11-18 11:00:00	NQ	Futures	2457.32	2459.62	2453.02	2459.04	38350.0
2010-11-18 12:00:00	NQ	Futures	2459.04	2463.63	2459.04	2460.76	24278.0
2010-11-18 13:00:00	NQ	Futures	2460.76	2460.76	2456.46	2456.75	16945.0
2010-11-18 14:00:00	NQ	Futures	2457.03	2458.47	2450.72	2455.02	25316.0
2010-11-18 15:00:00	NQ	Futures	2455.02	2456.75	2445.84	2446.13	51145.0
2010-11-18 16:00:00	NQ	Futures	2446.13	2451.3	2444.41	2448.43	17160.0
2010-11-18 17:00:00	NQ	Futures	2449.0	2452.16	2448.71	2452.16	243.0
2010-11-18 18:00:00	NQ	Futures	2451.3	2453.88	2450.72	2453.88	400.0
2010-11-18 19:00:00	NQ	Futures	2453.59	2453.59	2449.57	2450.43	500.0
2010-11-18 20:00:00	NQ	Futures	2450.43	2450.72	2446.42	2446.99	456.0
2010-11-18 21:00:00	NQ	Futures	2446.99	2449.0	2446.7	2448.14	380.0
2010-11-18 22:00:00	NQ	Futures	2448.14	2448.43	2443.55	2444.12	641.0
2010-11-18 23:00:00	NQ	Futures	2444.12	2444.41	2441.25	2444.12	767.0
2010-11-18 00:00:00	YM	Futures	10532.5	10543.0	10521.1	10542.0	512.0
2010-11-18 01:00:00	YM	Futures	10542.0	10548.7	10537.3	10544.9	686.0

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

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