PREVIEW / futures_1hour / 2010-11-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	1175.95	1176.94	1175.21	1175.95	2316.0
2010-11-03 01:00:00	ES	Futures	1175.95	1176.2	1175.21	1175.7	2319.0
2010-11-03 02:00:00	ES	Futures	1175.46	1176.94	1175.46	1176.44	1533.0
2010-11-03 03:00:00	ES	Futures	1176.44	1176.94	1174.23	1176.2	13393.0
2010-11-03 04:00:00	ES	Futures	1175.95	1176.44	1173.98	1174.72	25502.0
2010-11-03 05:00:00	ES	Futures	1174.72	1177.43	1173.98	1177.18	19632.0
2010-11-03 06:00:00	ES	Futures	1177.18	1177.68	1176.2	1176.94	18439.0
2010-11-03 07:00:00	ES	Futures	1176.69	1177.92	1175.95	1177.43	17688.0
2010-11-03 08:00:00	ES	Futures	1177.18	1178.42	1176.44	1177.68	50998.0
2010-11-03 09:00:00	ES	Futures	1177.43	1177.68	1173.49	1174.23	152496.0
2010-11-03 10:00:00	ES	Futures	1174.23	1175.95	1172.25	1172.75	219303.0
2010-11-03 11:00:00	ES	Futures	1172.75	1173.24	1169.3	1170.53	219940.0
2010-11-03 12:00:00	ES	Futures	1170.77	1171.27	1168.06	1170.04	155870.0
2010-11-03 13:00:00	ES	Futures	1170.04	1172.01	1169.05	1170.53	101520.0
2010-11-03 14:00:00	ES	Futures	1170.28	1176.94	1162.89	1175.21	759534.0
2010-11-03 15:00:00	ES	Futures	1174.96	1178.66	1173.49	1178.17	423154.0
2010-11-03 16:00:00	ES	Futures	1177.92	1181.13	1177.92	1180.14	145247.0
2010-11-03 17:00:00	ES	Futures	1180.14	1180.39	1179.89	1180.14	2331.0
2010-11-03 18:00:00	ES	Futures	1180.63	1180.63	1179.15	1179.89	4449.0
2010-11-03 19:00:00	ES	Futures	1179.65	1180.88	1179.4	1179.89	6832.0
2010-11-03 20:00:00	ES	Futures	1180.14	1180.63	1179.15	1179.4	7617.0
2010-11-03 21:00:00	ES	Futures	1179.65	1180.63	1179.4	1180.14	4365.0
2010-11-03 22:00:00	ES	Futures	1180.14	1180.88	1179.65	1180.39	5152.0
2010-11-03 23:00:00	ES	Futures	1180.39	1181.13	1179.65	1180.14	5076.0
2010-11-03 00:00:00	NQ	Futures	2469.66	2470.52	2468.51	2469.08	219.0
2010-11-03 01:00:00	NQ	Futures	2469.08	2469.37	2467.94	2468.22	139.0
2010-11-03 02:00:00	NQ	Futures	2468.8	2469.66	2467.36	2468.8	389.0
2010-11-03 03:00:00	NQ	Futures	2468.51	2469.37	2463.34	2466.5	2034.0
2010-11-03 04:00:00	NQ	Futures	2466.79	2467.07	2463.63	2464.49	1529.0
2010-11-03 05:00:00	NQ	Futures	2464.49	2469.94	2463.63	2469.66	845.0
2010-11-03 06:00:00	NQ	Futures	2469.94	2470.23	2467.36	2468.8	911.0
2010-11-03 07:00:00	NQ	Futures	2468.51	2470.8	2467.94	2470.23	867.0
2010-11-03 08:00:00	NQ	Futures	2470.23	2471.95	2467.36	2469.94	3402.0
2010-11-03 09:00:00	NQ	Futures	2469.66	2470.23	2462.77	2463.63	28123.0
2010-11-03 10:00:00	NQ	Futures	2463.92	2467.36	2457.89	2459.62	38307.0
2010-11-03 11:00:00	NQ	Futures	2459.33	2461.34	2451.58	2456.46	34183.0
2010-11-03 12:00:00	NQ	Futures	2456.75	2457.32	2451.3	2455.89	25618.0
2010-11-03 13:00:00	NQ	Futures	2455.89	2461.05	2455.02	2457.32	19488.0
2010-11-03 14:00:00	NQ	Futures	2457.03	2473.1	2444.41	2470.52	108264.0
2010-11-03 15:00:00	NQ	Futures	2470.52	2475.97	2465.07	2474.25	64739.0
2010-11-03 16:00:00	NQ	Futures	2474.25	2486.01	2474.25	2485.15	18252.0
2010-11-03 17:00:00	NQ	Futures	2485.44	2485.72	2484.86	2484.86	112.0
2010-11-03 18:00:00	NQ	Futures	2484.86	2484.86	2481.99	2483.43	324.0
2010-11-03 19:00:00	NQ	Futures	2483.14	2485.44	2483.14	2484.0	487.0
2010-11-03 20:00:00	NQ	Futures	2484.29	2485.44	2482.85	2483.14	253.0
2010-11-03 21:00:00	NQ	Futures	2483.14	2485.72	2483.14	2485.44	248.0
2010-11-03 22:00:00	NQ	Futures	2485.44	2487.16	2484.86	2484.86	317.0
2010-11-03 23:00:00	NQ	Futures	2485.44	2486.3	2483.43	2484.0	261.0
2010-11-03 00:00:00	YM	Futures	10626.8	10630.6	10620.1	10624.9	82.0
2010-11-03 01:00:00	YM	Futures	10626.8	10626.8	10617.3	10620.1	92.0

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

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