PREVIEW / futures_1hour / 2010-11-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	1172.01	1172.25	1171.76	1172.25	2248.0
2010-11-01 01:00:00	ES	Futures	1172.01	1172.25	1170.04	1171.51	6316.0
2010-11-01 02:00:00	ES	Futures	1171.76	1172.25	1170.77	1171.51	4688.0
2010-11-01 03:00:00	ES	Futures	1171.51	1172.25	1171.02	1171.76	9240.0
2010-11-01 04:00:00	ES	Futures	1171.76	1172.99	1170.28	1172.99	30064.0
2010-11-01 05:00:00	ES	Futures	1172.75	1172.99	1169.3	1170.28	31647.0
2010-11-01 06:00:00	ES	Futures	1170.28	1170.53	1167.82	1169.79	46522.0
2010-11-01 07:00:00	ES	Futures	1170.04	1170.28	1168.31	1168.31	18074.0
2010-11-01 08:00:00	ES	Futures	1168.56	1169.3	1167.32	1169.05	52809.0
2010-11-01 09:00:00	ES	Futures	1169.05	1172.99	1168.8	1171.51	210415.0
2010-11-01 10:00:00	ES	Futures	1171.51	1175.95	1171.51	1172.5	394331.0
2010-11-01 11:00:00	ES	Futures	1172.25	1172.5	1166.34	1169.3	312056.0
2010-11-01 12:00:00	ES	Futures	1169.3	1169.79	1166.09	1167.08	130595.0
2010-11-01 13:00:00	ES	Futures	1166.83	1169.3	1165.6	1167.82	117024.0
2010-11-01 14:00:00	ES	Futures	1167.82	1168.31	1162.15	1163.13	165832.0
2010-11-01 15:00:00	ES	Futures	1163.13	1164.61	1157.22	1164.37	357172.0
2010-11-01 16:00:00	ES	Futures	1164.12	1166.58	1163.87	1165.6	78204.0
2010-11-01 17:00:00	ES	Futures	1165.6	1166.09	1164.61	1165.11	2528.0
2010-11-01 18:00:00	ES	Futures	1165.11	1165.6	1164.12	1164.86	3507.0
2010-11-01 19:00:00	ES	Futures	1164.86	1166.09	1164.86	1166.09	2736.0
2010-11-01 20:00:00	ES	Futures	1165.85	1167.08	1165.35	1167.08	5847.0
2010-11-01 21:00:00	ES	Futures	1166.83	1167.32	1164.86	1165.6	4569.0
2010-11-01 22:00:00	ES	Futures	1165.35	1165.85	1164.86	1165.35	3384.0
2010-11-01 23:00:00	ES	Futures	1165.6	1167.08	1165.6	1166.58	3740.0
2010-11-01 00:00:00	NQ	Futures	2450.43	2451.01	2450.15	2450.72	241.0
2010-11-01 01:00:00	NQ	Futures	2450.43	2450.72	2448.43	2450.15	408.0
2010-11-01 02:00:00	NQ	Futures	2450.15	2450.43	2448.43	2449.29	402.0
2010-11-01 03:00:00	NQ	Futures	2449.57	2451.01	2448.71	2449.86	681.0
2010-11-01 04:00:00	NQ	Futures	2450.15	2451.58	2447.85	2451.3	2309.0
2010-11-01 05:00:00	NQ	Futures	2451.3	2451.58	2445.56	2446.7	2082.0
2010-11-01 06:00:00	NQ	Futures	2446.99	2448.14	2443.26	2447.28	2383.0
2010-11-01 07:00:00	NQ	Futures	2447.28	2447.57	2443.84	2443.84	1437.0
2010-11-01 08:00:00	NQ	Futures	2443.84	2445.84	2439.82	2444.41	4428.0
2010-11-01 09:00:00	NQ	Futures	2444.7	2460.19	2442.97	2455.89	37484.0
2010-11-01 10:00:00	NQ	Futures	2456.17	2463.34	2448.71	2449.86	53206.0
2010-11-01 11:00:00	NQ	Futures	2450.15	2450.15	2432.93	2442.11	54165.0
2010-11-01 12:00:00	NQ	Futures	2442.4	2445.27	2439.53	2441.83	23284.0
2010-11-01 13:00:00	NQ	Futures	2441.54	2447.28	2437.81	2444.41	18000.0
2010-11-01 14:00:00	NQ	Futures	2444.41	2445.84	2436.95	2439.25	24152.0
2010-11-01 15:00:00	NQ	Futures	2439.53	2440.11	2427.2	2439.25	48918.0
2010-11-01 16:00:00	NQ	Futures	2439.53	2444.7	2438.1	2442.4	8777.0
2010-11-01 17:00:00	NQ	Futures	2441.83	2442.69	2440.97	2441.54	114.0
2010-11-01 18:00:00	NQ	Futures	2441.54	2442.11	2440.11	2440.68	191.0
2010-11-01 19:00:00	NQ	Futures	2441.25	2443.55	2441.25	2443.55	205.0
2010-11-01 20:00:00	NQ	Futures	2443.26	2446.42	2442.97	2446.42	505.0
2010-11-01 21:00:00	NQ	Futures	2446.42	2447.28	2443.26	2444.7	521.0
2010-11-01 22:00:00	NQ	Futures	2444.7	2444.98	2443.55	2443.84	267.0
2010-11-01 23:00:00	NQ	Futures	2443.84	2445.84	2443.26	2444.98	323.0
2010-11-01 00:00:00	YM	Futures	10612.5	10615.4	10610.6	10612.5	200.0
2010-11-01 01:00:00	YM	Futures	10610.6	10610.6	10593.5	10609.7	367.0

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

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