PREVIEW / futures_1hour / 2010-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-02.parquet
  size:    45 KB
  rows:    1,398

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-02 00:00:00	ES	Futures	1166.58	1168.06	1166.34	1167.82	3419.0
2010-11-02 01:00:00	ES	Futures	1167.82	1168.8	1167.08	1167.32	4429.0
2010-11-02 02:00:00	ES	Futures	1167.57	1168.06	1167.08	1167.08	2784.0
2010-11-02 03:00:00	ES	Futures	1167.32	1168.31	1166.58	1167.57	7590.0
2010-11-02 04:00:00	ES	Futures	1167.82	1170.53	1167.32	1169.05	32153.0
2010-11-02 05:00:00	ES	Futures	1169.05	1171.02	1168.8	1169.79	18387.0
2010-11-02 06:00:00	ES	Futures	1170.04	1171.76	1169.54	1171.02	25887.0
2010-11-02 07:00:00	ES	Futures	1170.77	1173.49	1170.28	1172.75	35479.0
2010-11-02 08:00:00	ES	Futures	1172.75	1174.47	1172.5	1173.24	69359.0
2010-11-02 09:00:00	ES	Futures	1173.24	1175.21	1171.51	1172.75	257403.0
2010-11-02 10:00:00	ES	Futures	1172.75	1173.49	1169.54	1171.27	263456.0
2010-11-02 11:00:00	ES	Futures	1171.02	1172.99	1170.53	1172.01	142168.0
2010-11-02 12:00:00	ES	Futures	1172.25	1174.23	1171.76	1173.73	120863.0
2010-11-02 13:00:00	ES	Futures	1173.73	1176.2	1173.49	1175.7	137525.0
2010-11-02 14:00:00	ES	Futures	1175.46	1175.95	1172.75	1173.49	120108.0
2010-11-02 15:00:00	ES	Futures	1173.49	1174.96	1172.5	1173.24	186946.0
2010-11-02 16:00:00	ES	Futures	1173.49	1176.69	1172.99	1175.95	120668.0
2010-11-02 17:00:00	ES	Futures	1175.95	1176.69	1175.7	1175.7	2074.0
2010-11-02 18:00:00	ES	Futures	1175.95	1176.94	1175.7	1176.44	1849.0
2010-11-02 19:00:00	ES	Futures	1176.69	1179.65	1176.44	1178.91	10391.0
2010-11-02 20:00:00	ES	Futures	1178.91	1178.91	1175.95	1176.2	7308.0
2010-11-02 21:00:00	ES	Futures	1176.2	1177.43	1174.96	1176.2	6661.0
2010-11-02 22:00:00	ES	Futures	1175.95	1177.43	1173.98	1176.69	8028.0
2010-11-02 23:00:00	ES	Futures	1176.44	1176.94	1175.7	1176.2	1869.0
2010-11-02 00:00:00	NQ	Futures	2445.27	2447.28	2444.7	2447.28	229.0
2010-11-02 01:00:00	NQ	Futures	2447.57	2448.14	2446.7	2448.14	236.0
2010-11-02 02:00:00	NQ	Futures	2448.43	2449.29	2446.99	2446.99	188.0
2010-11-02 03:00:00	NQ	Futures	2447.28	2449.86	2446.7	2448.43	867.0
2010-11-02 04:00:00	NQ	Futures	2448.71	2452.44	2447.85	2449.29	1745.0
2010-11-02 05:00:00	NQ	Futures	2449.86	2452.73	2449.0	2451.01	1121.0
2010-11-02 06:00:00	NQ	Futures	2451.01	2452.73	2449.57	2450.43	1305.0
2010-11-02 07:00:00	NQ	Futures	2450.72	2455.6	2450.15	2454.74	2062.0
2010-11-02 08:00:00	NQ	Futures	2454.74	2459.62	2454.74	2455.89	5581.0
2010-11-02 09:00:00	NQ	Futures	2455.6	2467.94	2455.02	2462.77	46970.0
2010-11-02 10:00:00	NQ	Futures	2462.77	2464.49	2455.02	2459.9	36210.0
2010-11-02 11:00:00	NQ	Futures	2459.62	2463.06	2458.47	2461.05	19616.0
2010-11-02 12:00:00	NQ	Futures	2461.05	2465.35	2459.04	2463.92	19318.0
2010-11-02 13:00:00	NQ	Futures	2464.21	2471.67	2464.21	2469.37	24994.0
2010-11-02 14:00:00	NQ	Futures	2469.66	2469.94	2462.77	2465.07	20799.0
2010-11-02 15:00:00	NQ	Futures	2465.35	2468.22	2462.77	2464.49	31562.0
2010-11-02 16:00:00	NQ	Futures	2464.49	2471.09	2463.92	2468.22	12289.0
2010-11-02 17:00:00	NQ	Futures	2468.51	2469.94	2467.94	2467.94	236.0
2010-11-02 18:00:00	NQ	Futures	2468.51	2470.8	2467.07	2470.23	241.0
2010-11-02 19:00:00	NQ	Futures	2470.23	2475.11	2470.23	2474.53	571.0
2010-11-02 20:00:00	NQ	Futures	2474.25	2474.25	2469.08	2469.94	317.0
2010-11-02 21:00:00	NQ	Futures	2469.66	2471.67	2467.36	2469.08	449.0
2010-11-02 22:00:00	NQ	Futures	2469.08	2471.38	2465.07	2470.23	367.0
2010-11-02 23:00:00	NQ	Futures	2470.23	2470.52	2468.22	2469.66	156.0
2010-11-02 00:00:00	YM	Futures	10564.9	10570.6	10561.1	10569.7	252.0
2010-11-02 01:00:00	YM	Futures	10569.7	10580.1	10565.8	10569.7	289.0

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

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