PREVIEW / futures_1hour / 2009-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-02.parquet
  size:    43 KB
  rows:    1,242

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
2009-03-02 00:00:00	ES	Futures	685.7	686.18	683.57	685.94	4474.0
2009-03-02 01:00:00	ES	Futures	685.94	687.36	685.23	686.18	2423.0
2009-03-02 02:00:00	ES	Futures	686.18	687.36	684.04	685.23	11275.0
2009-03-02 03:00:00	ES	Futures	685.23	686.89	681.43	683.33	28807.0
2009-03-02 04:00:00	ES	Futures	683.09	686.89	681.67	686.41	18058.0
2009-03-02 05:00:00	ES	Futures	686.41	686.41	680.96	680.96	16552.0
2009-03-02 06:00:00	ES	Futures	681.2	682.86	674.79	679.54	41616.0
2009-03-02 07:00:00	ES	Futures	679.3	681.67	677.16	681.2	32982.0
2009-03-02 08:00:00	ES	Futures	680.96	684.99	679.3	681.67	74670.0
2009-03-02 09:00:00	ES	Futures	681.67	687.13	680.25	683.81	280568.0
2009-03-02 10:00:00	ES	Futures	683.81	686.89	676.93	678.11	382848.0
2009-03-02 11:00:00	ES	Futures	677.88	679.54	669.34	671.23	363089.0
2009-03-02 12:00:00	ES	Futures	671.0	673.84	668.39	669.1	278626.0
2009-03-02 13:00:00	ES	Futures	669.1	672.89	666.97	672.66	241044.0
2009-03-02 14:00:00	ES	Futures	672.66	675.98	668.86	669.81	296110.0
2009-03-02 15:00:00	ES	Futures	669.81	670.52	662.93	664.83	600310.0
2009-03-02 16:00:00	ES	Futures	665.07	669.81	663.64	669.34	157957.0
2009-03-02 17:00:00	ES	Futures	669.1	669.81	668.39	669.34	2484.0
2009-03-02 18:00:00	ES	Futures	668.86	670.76	668.39	669.81	3321.0
2009-03-02 19:00:00	ES	Futures	670.05	672.42	669.57	671.23	6402.0
2009-03-02 20:00:00	ES	Futures	671.23	675.03	671.0	674.79	8096.0
2009-03-02 21:00:00	ES	Futures	674.79	677.16	674.56	675.74	7790.0
2009-03-02 22:00:00	ES	Futures	675.5	678.59	675.03	678.35	6456.0
2009-03-02 23:00:00	ES	Futures	678.11	678.35	677.16	677.64	5525.0
2009-03-02 00:00:00	NQ	Futures	1241.63	1242.19	1237.96	1242.19	215.0
2009-03-02 01:00:00	NQ	Futures	1242.19	1244.17	1240.22	1242.19	141.0
2009-03-02 02:00:00	NQ	Futures	1242.19	1244.73	1240.22	1242.76	544.0
2009-03-02 03:00:00	NQ	Futures	1242.76	1246.43	1239.09	1240.5	3332.0
2009-03-02 04:00:00	NQ	Futures	1240.5	1246.99	1238.24	1246.43	638.0
2009-03-02 05:00:00	NQ	Futures	1245.86	1245.86	1237.39	1237.96	850.0
2009-03-02 06:00:00	NQ	Futures	1238.24	1239.93	1223.84	1232.03	3794.0
2009-03-02 07:00:00	NQ	Futures	1231.74	1238.8	1229.2	1238.24	3806.0
2009-03-02 08:00:00	NQ	Futures	1238.24	1244.17	1235.42	1239.93	6930.0
2009-03-02 09:00:00	NQ	Futures	1239.93	1260.55	1239.65	1252.64	56696.0
2009-03-02 10:00:00	NQ	Futures	1252.92	1258.85	1236.83	1238.8	53465.0
2009-03-02 11:00:00	NQ	Futures	1238.52	1243.04	1224.97	1228.92	49634.0
2009-03-02 12:00:00	NQ	Futures	1228.64	1234.57	1221.3	1222.71	44250.0
2009-03-02 13:00:00	NQ	Futures	1222.43	1229.77	1217.34	1229.77	41932.0
2009-03-02 14:00:00	NQ	Futures	1229.77	1232.87	1219.88	1222.43	39719.0
2009-03-02 15:00:00	NQ	Futures	1222.43	1226.38	1213.39	1219.88	71389.0
2009-03-02 16:00:00	NQ	Futures	1219.88	1230.33	1219.04	1226.94	17365.0
2009-03-02 17:00:00	NQ	Futures	1227.79	1228.64	1226.66	1227.51	120.0
2009-03-02 18:00:00	NQ	Futures	1224.68	1228.07	1224.68	1227.51	236.0
2009-03-02 19:00:00	NQ	Futures	1227.79	1230.61	1227.23	1227.51	161.0
2009-03-02 20:00:00	NQ	Futures	1228.07	1235.42	1228.07	1234.57	383.0
2009-03-02 21:00:00	NQ	Futures	1235.42	1237.96	1233.44	1236.54	479.0
2009-03-02 22:00:00	NQ	Futures	1236.54	1238.52	1235.7	1237.96	719.0
2009-03-02 23:00:00	NQ	Futures	1237.96	1238.52	1237.11	1237.67	443.0
2009-03-02 00:00:00	YM	Futures	6342.5	6342.5	6321.5	6340.6	755.0
2009-03-02 01:00:00	YM	Futures	6339.7	6356.1	6336.1	6343.4	330.0

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

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