PREVIEW / futures_1hour / 2010-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-25.parquet
  size:    46 KB
  rows:    1,357

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-03-25 00:00:00	ES	Futures	1138.29	1138.78	1138.05	1138.54	1076.0
2010-03-25 01:00:00	ES	Futures	1138.78	1139.03	1137.56	1138.29	3131.0
2010-03-25 02:00:00	ES	Futures	1138.29	1139.76	1137.8	1139.52	2146.0
2010-03-25 03:00:00	ES	Futures	1139.52	1140.49	1138.78	1139.27	6968.0
2010-03-25 04:00:00	ES	Futures	1139.52	1140.49	1138.54	1139.76	14907.0
2010-03-25 05:00:00	ES	Futures	1139.52	1142.94	1139.52	1142.2	19507.0
2010-03-25 06:00:00	ES	Futures	1142.45	1142.94	1141.47	1142.45	11399.0
2010-03-25 07:00:00	ES	Futures	1142.45	1144.4	1142.2	1143.91	27594.0
2010-03-25 08:00:00	ES	Futures	1143.91	1144.65	1142.69	1143.67	47843.0
2010-03-25 09:00:00	ES	Futures	1143.67	1146.36	1143.18	1143.91	232056.0
2010-03-25 10:00:00	ES	Futures	1144.16	1145.63	1141.47	1144.65	225534.0
2010-03-25 11:00:00	ES	Futures	1144.65	1149.54	1144.4	1148.56	276323.0
2010-03-25 12:00:00	ES	Futures	1148.8	1150.27	1146.85	1148.8	189744.0
2010-03-25 13:00:00	ES	Futures	1148.8	1149.78	1142.94	1143.91	295052.0
2010-03-25 14:00:00	ES	Futures	1143.91	1145.14	1139.76	1141.96	293643.0
2010-03-25 15:00:00	ES	Futures	1141.96	1144.89	1134.38	1135.6	565092.0
2010-03-25 16:00:00	ES	Futures	1135.6	1136.83	1134.14	1134.63	132505.0
2010-03-25 17:00:00	ES	Futures	1134.63	1134.63	1133.4	1133.89	3676.0
2010-03-25 18:00:00	ES	Futures	1133.89	1134.63	1133.65	1133.89	3255.0
2010-03-25 19:00:00	ES	Futures	1133.89	1134.38	1132.43	1134.38	6541.0
2010-03-25 20:00:00	ES	Futures	1134.38	1134.63	1132.92	1132.92	6312.0
2010-03-25 21:00:00	ES	Futures	1132.92	1134.14	1132.92	1133.89	2666.0
2010-03-25 22:00:00	ES	Futures	1133.89	1136.34	1133.89	1136.09	8561.0
2010-03-25 23:00:00	ES	Futures	1136.09	1137.56	1136.09	1137.07	6832.0
2010-03-25 00:00:00	NQ	Futures	2236.0	2236.57	2236.0	2236.0	69.0
2010-03-25 01:00:00	NQ	Futures	2236.28	2236.86	2234.85	2236.0	94.0
2010-03-25 02:00:00	NQ	Futures	2235.42	2237.72	2235.14	2237.43	91.0
2010-03-25 03:00:00	NQ	Futures	2237.43	2239.72	2236.86	2238.0	488.0
2010-03-25 04:00:00	NQ	Futures	2238.0	2240.29	2237.72	2238.57	1107.0
2010-03-25 05:00:00	NQ	Futures	2238.86	2244.02	2238.29	2243.16	1520.0
2010-03-25 06:00:00	NQ	Futures	2243.16	2244.02	2241.44	2242.87	673.0
2010-03-25 07:00:00	NQ	Futures	2242.87	2244.87	2242.87	2244.3	1280.0
2010-03-25 08:00:00	NQ	Futures	2244.3	2246.88	2243.44	2245.73	3916.0
2010-03-25 09:00:00	NQ	Futures	2245.73	2254.61	2245.45	2248.31	43327.0
2010-03-25 10:00:00	NQ	Futures	2248.02	2252.89	2242.58	2249.46	35105.0
2010-03-25 11:00:00	NQ	Futures	2249.46	2261.48	2248.88	2259.19	44928.0
2010-03-25 12:00:00	NQ	Futures	2259.19	2259.19	2253.47	2255.18	27070.0
2010-03-25 13:00:00	NQ	Futures	2255.18	2258.33	2245.45	2248.02	35435.0
2010-03-25 14:00:00	NQ	Futures	2248.02	2249.17	2236.57	2241.15	41560.0
2010-03-25 15:00:00	NQ	Futures	2241.44	2249.17	2228.84	2230.27	51944.0
2010-03-25 16:00:00	NQ	Futures	2230.27	2233.71	2228.27	2228.84	12403.0
2010-03-25 17:00:00	NQ	Futures	2228.55	2229.12	2227.12	2228.27	172.0
2010-03-25 18:00:00	NQ	Futures	2228.27	2229.12	2227.69	2227.69	183.0
2010-03-25 19:00:00	NQ	Futures	2227.69	2228.27	2224.83	2227.41	444.0
2010-03-25 20:00:00	NQ	Futures	2227.98	2228.55	2225.97	2225.97	324.0
2010-03-25 21:00:00	NQ	Futures	2226.26	2228.84	2225.97	2228.27	302.0
2010-03-25 22:00:00	NQ	Futures	2228.55	2232.27	2228.55	2232.27	354.0
2010-03-25 23:00:00	NQ	Futures	2232.56	2234.57	2231.99	2234.28	582.0
2010-03-25 00:00:00	YM	Futures	10145.6	10151.3	10144.7	10151.3	122.0
2010-03-25 01:00:00	YM	Futures	10151.3	10154.1	10140.0	10146.6	203.0

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

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