PREVIEW / futures_1hour / 2010-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-01.parquet
  size:    42 KB
  rows:    1,261

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-01 00:00:00	ES	Futures	1140.98	1143.43	1140.98	1143.18	5445.0
2010-04-01 01:00:00	ES	Futures	1143.18	1143.43	1142.2	1142.94	4309.0
2010-04-01 02:00:00	ES	Futures	1142.94	1143.67	1142.2	1142.94	8799.0
2010-04-01 03:00:00	ES	Futures	1143.18	1145.63	1142.69	1145.38	21926.0
2010-04-01 04:00:00	ES	Futures	1145.14	1145.87	1144.4	1145.87	18730.0
2010-04-01 05:00:00	ES	Futures	1145.63	1145.87	1144.16	1144.4	11346.0
2010-04-01 06:00:00	ES	Futures	1144.65	1144.65	1143.67	1144.16	7452.0
2010-04-01 07:00:00	ES	Futures	1144.16	1144.89	1143.67	1144.4	16089.0
2010-04-01 08:00:00	ES	Futures	1144.16	1147.09	1143.91	1146.11	60257.0
2010-04-01 09:00:00	ES	Futures	1146.36	1151.0	1145.87	1149.54	271417.0
2010-04-01 10:00:00	ES	Futures	1149.78	1151.25	1146.6	1147.58	307822.0
2010-04-01 11:00:00	ES	Futures	1147.58	1149.54	1146.11	1148.31	187262.0
2010-04-01 12:00:00	ES	Futures	1148.56	1148.8	1147.09	1147.58	90827.0
2010-04-01 13:00:00	ES	Futures	1147.58	1148.56	1143.91	1144.65	157728.0
2010-04-01 14:00:00	ES	Futures	1144.89	1145.63	1140.25	1143.18	346959.0
2010-04-01 15:00:00	ES	Futures	1143.18	1147.58	1142.2	1147.34	270083.0
2010-04-01 16:00:00	ES	Futures	1147.34	1147.83	1146.85	1147.58	109047.0
2010-04-01 17:00:00	ES	Futures	1147.58	1148.8	1147.34	1148.56	2693.0
2010-04-01 18:00:00	ES	Futures	1148.31	1148.31	1147.34	1147.58	1880.0
2010-04-01 19:00:00	ES	Futures	1147.58	1147.83	1146.36	1146.85	1798.0
2010-04-01 20:00:00	ES	Futures	1146.6	1146.6	1145.14	1145.63	2678.0
2010-04-01 21:00:00	ES	Futures	1145.63	1145.87	1144.4	1145.14	2732.0
2010-04-01 22:00:00	ES	Futures	1145.14	1145.14	1144.65	1145.14	796.0
2010-04-01 23:00:00	ES	Futures	1145.14	1145.63	1144.89	1145.14	717.0
2010-04-01 00:00:00	NQ	Futures	2242.58	2246.02	2242.58	2245.73	365.0
2010-04-01 01:00:00	NQ	Futures	2245.73	2246.59	2244.59	2246.02	319.0
2010-04-01 02:00:00	NQ	Futures	2246.31	2247.74	2245.45	2247.45	531.0
2010-04-01 03:00:00	NQ	Futures	2247.17	2253.47	2246.88	2253.18	2414.0
2010-04-01 04:00:00	NQ	Futures	2253.18	2253.75	2246.31	2246.88	3384.0
2010-04-01 05:00:00	NQ	Futures	2247.17	2247.45	2242.58	2244.02	3351.0
2010-04-01 06:00:00	NQ	Futures	2244.02	2244.3	2243.16	2244.02	948.0
2010-04-01 07:00:00	NQ	Futures	2244.3	2246.88	2244.3	2246.02	1638.0
2010-04-01 08:00:00	NQ	Futures	2246.31	2252.61	2246.02	2248.6	6377.0
2010-04-01 09:00:00	NQ	Futures	2248.31	2264.06	2248.02	2261.48	52094.0
2010-04-01 10:00:00	NQ	Futures	2262.06	2264.92	2249.46	2251.46	49054.0
2010-04-01 11:00:00	NQ	Futures	2251.75	2252.03	2245.16	2249.74	37792.0
2010-04-01 12:00:00	NQ	Futures	2249.46	2250.6	2245.45	2247.45	17968.0
2010-04-01 13:00:00	NQ	Futures	2247.45	2247.74	2232.27	2234.28	32502.0
2010-04-01 14:00:00	NQ	Futures	2234.28	2236.86	2223.11	2231.7	46799.0
2010-04-01 15:00:00	NQ	Futures	2231.7	2241.44	2230.27	2240.87	37795.0
2010-04-01 16:00:00	NQ	Futures	2240.58	2240.87	2236.86	2238.29	13842.0
2010-04-01 17:00:00	NQ	Futures	2238.29	2240.58	2238.0	2240.01	304.0
2010-04-01 18:00:00	NQ	Futures	2240.29	2240.29	2239.15	2240.01	496.0
2010-04-01 19:00:00	NQ	Futures	2240.01	2240.58	2238.0	2238.29	369.0
2010-04-01 20:00:00	NQ	Futures	2238.0	2238.29	2235.42	2236.57	335.0
2010-04-01 21:00:00	NQ	Futures	2236.57	2236.57	2234.57	2235.71	225.0
2010-04-01 22:00:00	NQ	Futures	2235.42	2236.28	2235.42	2235.71	122.0
2010-04-01 23:00:00	NQ	Futures	2235.71	2236.28	2235.42	2235.71	77.0
2010-04-01 00:00:00	YM	Futures	10179.5	10195.5	10179.5	10195.5	432.0
2010-04-01 01:00:00	YM	Futures	10195.5	10199.3	10188.0	10193.6	325.0

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

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