PREVIEW / futures_1hour / 2009-03-20

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-20.parquet
  size:    36 KB
  rows:    1,009

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-20 00:00:00	ES	Futures	741.67	743.34	741.67	741.91	3243.0
2009-03-20 01:00:00	ES	Futures	741.91	742.39	739.99	740.47	4968.0
2009-03-20 02:00:00	ES	Futures	740.47	741.67	739.99	740.95	2448.0
2009-03-20 03:00:00	ES	Futures	740.95	742.86	740.71	741.67	7184.0
2009-03-20 04:00:00	ES	Futures	741.43	743.34	740.95	742.63	24620.0
2009-03-20 05:00:00	ES	Futures	742.86	742.86	739.75	741.43	13725.0
2009-03-20 06:00:00	ES	Futures	741.43	745.02	739.03	745.02	23273.0
2009-03-20 07:00:00	ES	Futures	745.02	750.29	744.3	749.81	41133.0
2009-03-20 08:00:00	ES	Futures	749.81	752.45	747.9	751.25	61330.0
2009-03-20 09:00:00	ES	Futures	751.49	752.93	746.22	747.42	321568.0
2009-03-20 10:00:00	ES	Futures	747.66	749.81	744.3	748.86	298218.0
2009-03-20 11:00:00	ES	Futures	748.62	748.86	743.1	745.26	256278.0
2009-03-20 12:00:00	ES	Futures	745.26	747.9	739.03	740.71	203806.0
2009-03-20 13:00:00	ES	Futures	740.71	741.67	732.32	732.56	258115.0
2009-03-20 14:00:00	ES	Futures	732.56	734.48	729.92	733.52	275116.0
2009-03-20 15:00:00	ES	Futures	733.76	739.99	731.36	731.36	412948.0
2009-03-20 16:00:00	ES	Futures	731.36	733.04	730.64	732.08	118186.0
2009-03-20 00:00:00	NQ	Futures	1359.61	1361.88	1359.04	1359.33	53.0
2009-03-20 01:00:00	NQ	Futures	1359.33	1359.33	1355.92	1357.9	178.0
2009-03-20 02:00:00	NQ	Futures	1356.2	1359.61	1356.2	1359.61	143.0
2009-03-20 03:00:00	NQ	Futures	1359.33	1363.87	1359.04	1361.6	477.0
2009-03-20 04:00:00	NQ	Futures	1361.31	1365.01	1360.75	1364.16	1158.0
2009-03-20 05:00:00	NQ	Futures	1364.72	1364.72	1359.04	1362.45	846.0
2009-03-20 06:00:00	NQ	Futures	1362.45	1368.13	1358.76	1367.0	1208.0
2009-03-20 07:00:00	NQ	Futures	1367.0	1372.4	1365.86	1370.69	3405.0
2009-03-20 08:00:00	NQ	Futures	1370.69	1373.53	1367.28	1371.83	5404.0
2009-03-20 09:00:00	NQ	Futures	1371.54	1386.6	1365.01	1378.93	54438.0
2009-03-20 10:00:00	NQ	Futures	1378.93	1379.78	1371.26	1378.08	46237.0
2009-03-20 11:00:00	NQ	Futures	1378.08	1378.08	1364.72	1367.0	38624.0
2009-03-20 12:00:00	NQ	Futures	1366.71	1370.41	1352.79	1355.35	39010.0
2009-03-20 13:00:00	NQ	Futures	1355.35	1356.2	1341.14	1342.28	39247.0
2009-03-20 14:00:00	NQ	Futures	1341.99	1348.24	1338.01	1346.82	39052.0
2009-03-20 15:00:00	NQ	Futures	1346.82	1357.34	1345.12	1347.68	50135.0
2009-03-20 16:00:00	NQ	Futures	1347.11	1350.52	1346.54	1349.1	10046.0
2009-03-20 00:00:00	YM	Futures	6709.2	6716.6	6704.7	6708.3	214.0
2009-03-20 01:00:00	YM	Futures	6708.3	6710.2	6683.5	6693.6	691.0
2009-03-20 02:00:00	YM	Futures	6692.7	6701.9	6690.9	6699.1	166.0
2009-03-20 03:00:00	YM	Futures	6700.1	6712.0	6696.4	6698.2	360.0
2009-03-20 04:00:00	YM	Futures	6699.1	6715.7	6694.5	6711.1	1152.0
2009-03-20 05:00:00	YM	Futures	6712.0	6712.0	6690.0	6704.7	890.0
2009-03-20 06:00:00	YM	Futures	6704.7	6732.2	6685.4	6728.5	1433.0
2009-03-20 07:00:00	YM	Futures	6729.5	6774.5	6725.8	6766.2	2657.0
2009-03-20 08:00:00	YM	Futures	6769.0	6788.3	6752.4	6781.8	2769.0
2009-03-20 09:00:00	YM	Futures	6780.0	6802.1	6754.3	6766.2	20553.0
2009-03-20 10:00:00	YM	Futures	6767.1	6792.9	6741.4	6785.5	24008.0
2009-03-20 11:00:00	YM	Futures	6783.7	6785.5	6737.7	6757.0	19619.0
2009-03-20 12:00:00	YM	Futures	6758.0	6781.8	6709.2	6721.2	16334.0
2009-03-20 13:00:00	YM	Futures	6720.3	6726.7	6645.8	6649.5	17213.0
2009-03-20 14:00:00	YM	Futures	6649.5	6652.3	6615.5	6645.8	21488.0
2009-03-20 15:00:00	YM	Futures	6645.8	6691.8	6627.5	6629.3	25951.0

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

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