PREVIEW / futures_1hour / 2010-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-20.parquet
  size:    44 KB
  rows:    1,376

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-04-20 00:00:00	ES	Futures	1169.34	1170.31	1169.09	1169.58	3030.0
2010-04-20 01:00:00	ES	Futures	1169.58	1169.58	1168.11	1168.11	3626.0
2010-04-20 02:00:00	ES	Futures	1168.11	1168.6	1167.62	1168.6	10409.0
2010-04-20 03:00:00	ES	Futures	1168.6	1171.05	1168.11	1170.31	25547.0
2010-04-20 04:00:00	ES	Futures	1170.31	1170.8	1168.6	1170.07	20544.0
2010-04-20 05:00:00	ES	Futures	1169.82	1171.54	1167.38	1171.05	33567.0
2010-04-20 06:00:00	ES	Futures	1170.8	1175.2	1170.8	1175.2	41642.0
2010-04-20 07:00:00	ES	Futures	1175.2	1176.18	1172.27	1173.0	46183.0
2010-04-20 08:00:00	ES	Futures	1173.25	1174.22	1172.02	1172.76	40341.0
2010-04-20 09:00:00	ES	Futures	1173.0	1175.45	1171.78	1173.98	272243.0
2010-04-20 10:00:00	ES	Futures	1173.73	1174.47	1170.31	1173.0	256024.0
2010-04-20 11:00:00	ES	Futures	1173.0	1175.93	1172.76	1175.45	155204.0
2010-04-20 12:00:00	ES	Futures	1175.69	1178.13	1175.45	1175.93	150844.0
2010-04-20 13:00:00	ES	Futures	1176.18	1176.91	1175.45	1175.93	62713.0
2010-04-20 14:00:00	ES	Futures	1175.93	1177.65	1174.47	1177.4	115660.0
2010-04-20 15:00:00	ES	Futures	1177.16	1177.89	1175.2	1176.91	163444.0
2010-04-20 16:00:00	ES	Futures	1176.91	1181.56	1176.42	1180.58	132239.0
2010-04-20 17:00:00	ES	Futures	1180.58	1180.58	1179.36	1179.85	4985.0
2010-04-20 18:00:00	ES	Futures	1179.85	1180.33	1178.87	1179.85	4404.0
2010-04-20 19:00:00	ES	Futures	1179.85	1180.09	1178.87	1179.6	1842.0
2010-04-20 20:00:00	ES	Futures	1179.36	1180.33	1179.36	1180.09	4046.0
2010-04-20 21:00:00	ES	Futures	1180.09	1182.53	1180.09	1182.05	9986.0
2010-04-20 22:00:00	ES	Futures	1182.05	1182.29	1180.33	1180.82	4432.0
2010-04-20 23:00:00	ES	Futures	1180.82	1182.05	1180.58	1181.31	2231.0
2010-04-20 00:00:00	NQ	Futures	2304.73	2306.16	2304.44	2305.87	200.0
2010-04-20 01:00:00	NQ	Futures	2305.59	2305.59	2303.01	2303.29	168.0
2010-04-20 02:00:00	NQ	Futures	2303.29	2303.58	2301.29	2302.72	622.0
2010-04-20 03:00:00	NQ	Futures	2302.72	2307.88	2302.15	2307.3	1719.0
2010-04-20 04:00:00	NQ	Futures	2307.3	2308.16	2305.59	2307.59	1641.0
2010-04-20 05:00:00	NQ	Futures	2307.88	2310.45	2302.15	2309.59	2207.0
2010-04-20 06:00:00	NQ	Futures	2309.59	2317.04	2309.31	2317.04	2072.0
2010-04-20 07:00:00	NQ	Futures	2316.75	2318.76	2312.75	2313.6	2375.0
2010-04-20 08:00:00	NQ	Futures	2313.32	2315.61	2310.74	2311.89	3939.0
2010-04-20 09:00:00	NQ	Futures	2311.89	2316.18	2305.87	2308.45	42717.0
2010-04-20 10:00:00	NQ	Futures	2308.45	2309.88	2299.0	2306.44	44359.0
2010-04-20 11:00:00	NQ	Futures	2306.73	2313.6	2306.73	2313.32	23927.0
2010-04-20 12:00:00	NQ	Futures	2313.03	2319.33	2312.17	2315.9	28860.0
2010-04-20 13:00:00	NQ	Futures	2315.9	2317.04	2314.18	2315.61	11833.0
2010-04-20 14:00:00	NQ	Futures	2315.61	2318.76	2312.46	2318.19	18340.0
2010-04-20 15:00:00	NQ	Futures	2317.9	2319.9	2313.32	2313.6	31477.0
2010-04-20 16:00:00	NQ	Futures	2313.6	2337.37	2312.17	2335.94	26268.0
2010-04-20 17:00:00	NQ	Futures	2335.94	2335.94	2331.36	2333.94	3792.0
2010-04-20 18:00:00	NQ	Futures	2331.65	2333.08	2331.36	2332.22	939.0
2010-04-20 19:00:00	NQ	Futures	2331.93	2332.79	2331.07	2332.5	377.0
2010-04-20 20:00:00	NQ	Futures	2332.22	2333.94	2331.93	2332.79	557.0
2010-04-20 21:00:00	NQ	Futures	2333.08	2336.23	2333.08	2335.65	627.0
2010-04-20 22:00:00	NQ	Futures	2335.65	2335.65	2333.08	2333.36	512.0
2010-04-20 23:00:00	NQ	Futures	2333.36	2335.94	2333.36	2334.51	276.0
2010-04-20 00:00:00	YM	Futures	10385.6	10392.2	10384.7	10391.2	124.0
2010-04-20 01:00:00	YM	Futures	10390.3	10390.3	10380.9	10380.9	169.0

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

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