PREVIEW / futures_1hour / 2009-03-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	754.61	754.85	753.17	754.37	2077.0
2009-03-19 01:00:00	ES	Futures	754.37	754.37	751.73	752.21	2539.0
2009-03-19 02:00:00	ES	Futures	752.21	754.61	751.73	754.37	3750.0
2009-03-19 03:00:00	ES	Futures	754.37	756.52	752.69	753.41	10953.0
2009-03-19 04:00:00	ES	Futures	753.65	757.24	751.01	753.65	30515.0
2009-03-19 05:00:00	ES	Futures	753.89	756.52	752.93	754.37	21923.0
2009-03-19 06:00:00	ES	Futures	754.61	757.0	753.65	756.04	15436.0
2009-03-19 07:00:00	ES	Futures	755.81	762.51	755.33	762.04	49217.0
2009-03-19 08:00:00	ES	Futures	762.28	764.91	759.16	764.19	55882.0
2009-03-19 09:00:00	ES	Futures	764.43	768.27	753.89	753.89	364442.0
2009-03-19 10:00:00	ES	Futures	753.89	760.84	751.73	756.28	413364.0
2009-03-19 11:00:00	ES	Futures	756.28	758.92	745.74	750.53	358375.0
2009-03-19 12:00:00	ES	Futures	750.53	752.93	747.18	749.1	206000.0
2009-03-19 13:00:00	ES	Futures	749.1	755.09	747.66	753.17	210235.0
2009-03-19 14:00:00	ES	Futures	753.41	756.52	746.22	748.14	257441.0
2009-03-19 15:00:00	ES	Futures	748.38	752.45	745.02	746.94	365704.0
2009-03-19 16:00:00	ES	Futures	746.94	749.1	745.74	746.46	119468.0
2009-03-19 17:00:00	ES	Futures	746.7	746.7	744.3	745.26	5052.0
2009-03-19 18:00:00	ES	Futures	744.78	745.5	743.34	744.78	6007.0
2009-03-19 19:00:00	ES	Futures	744.78	745.02	744.06	744.3	2190.0
2009-03-19 20:00:00	ES	Futures	744.54	746.7	743.82	745.02	4399.0
2009-03-19 21:00:00	ES	Futures	745.02	746.22	744.06	744.54	1929.0
2009-03-19 22:00:00	ES	Futures	744.3	744.54	741.91	742.15	7240.0
2009-03-19 23:00:00	ES	Futures	742.15	742.86	741.67	741.67	3370.0
2009-03-19 00:00:00	NQ	Futures	1370.41	1370.69	1368.13	1369.84	84.0
2009-03-19 01:00:00	NQ	Futures	1370.12	1370.12	1365.29	1365.86	170.0
2009-03-19 02:00:00	NQ	Futures	1365.58	1370.12	1365.01	1368.99	207.0
2009-03-19 03:00:00	NQ	Futures	1368.99	1370.41	1365.58	1366.43	619.0
2009-03-19 04:00:00	NQ	Futures	1366.14	1372.11	1362.73	1366.14	1695.0
2009-03-19 05:00:00	NQ	Futures	1366.14	1371.26	1365.29	1368.99	1225.0
2009-03-19 06:00:00	NQ	Futures	1369.27	1373.53	1368.13	1371.83	668.0
2009-03-19 07:00:00	NQ	Futures	1371.83	1384.05	1371.83	1382.62	3298.0
2009-03-19 08:00:00	NQ	Futures	1382.34	1387.45	1377.23	1386.89	4500.0
2009-03-19 09:00:00	NQ	Futures	1387.17	1389.73	1368.99	1369.27	41530.0
2009-03-19 10:00:00	NQ	Futures	1368.99	1382.34	1367.0	1372.68	53427.0
2009-03-19 11:00:00	NQ	Futures	1372.96	1377.23	1357.62	1364.44	49253.0
2009-03-19 12:00:00	NQ	Futures	1364.72	1368.99	1360.46	1362.73	26010.0
2009-03-19 13:00:00	NQ	Futures	1362.73	1371.26	1359.33	1368.13	31189.0
2009-03-19 14:00:00	NQ	Futures	1368.42	1372.4	1362.17	1365.58	33886.0
2009-03-19 15:00:00	NQ	Futures	1365.29	1371.54	1363.87	1368.99	46681.0
2009-03-19 16:00:00	NQ	Futures	1368.7	1370.97	1366.43	1367.28	9630.0
2009-03-19 17:00:00	NQ	Futures	1367.28	1367.57	1364.16	1365.58	167.0
2009-03-19 18:00:00	NQ	Futures	1364.72	1366.14	1362.73	1366.14	183.0
2009-03-19 19:00:00	NQ	Futures	1365.58	1365.58	1363.59	1363.87	34.0
2009-03-19 20:00:00	NQ	Futures	1364.44	1367.0	1363.59	1365.58	261.0
2009-03-19 21:00:00	NQ	Futures	1365.58	1366.71	1363.59	1364.44	69.0
2009-03-19 22:00:00	NQ	Futures	1363.87	1363.87	1359.89	1360.46	98.0
2009-03-19 23:00:00	NQ	Futures	1360.46	1360.46	1358.47	1359.33	75.0
2009-03-19 00:00:00	YM	Futures	6805.7	6806.7	6793.8	6800.2	209.0
2009-03-19 01:00:00	YM	Futures	6800.2	6800.2	6781.8	6787.4	184.0

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

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