PREVIEW / futures_1hour / 2009-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-27.parquet
  size:    37 KB
  rows:    1,018

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-02-27 00:00:00	ES	Futures	714.88	716.06	708.47	711.32	7574.0
2009-02-27 01:00:00	ES	Futures	711.32	713.93	711.08	712.03	2463.0
2009-02-27 02:00:00	ES	Futures	712.27	717.25	712.27	716.54	9353.0
2009-02-27 03:00:00	ES	Futures	716.77	717.01	712.27	712.5	22922.0
2009-02-27 04:00:00	ES	Futures	712.5	714.88	710.84	712.74	12958.0
2009-02-27 05:00:00	ES	Futures	712.74	716.54	711.79	716.06	11591.0
2009-02-27 06:00:00	ES	Futures	716.06	716.3	710.13	711.08	10814.0
2009-02-27 07:00:00	ES	Futures	711.08	711.79	702.54	704.91	64555.0
2009-02-27 08:00:00	ES	Futures	705.15	705.86	692.11	698.04	143931.0
2009-02-27 09:00:00	ES	Futures	698.27	703.97	695.43	701.83	323369.0
2009-02-27 10:00:00	ES	Futures	701.83	708.47	699.22	705.39	458851.0
2009-02-27 11:00:00	ES	Futures	705.63	709.9	700.65	708.24	285729.0
2009-02-27 12:00:00	ES	Futures	708.24	710.61	704.2	708.0	192758.0
2009-02-27 13:00:00	ES	Futures	707.76	710.61	701.36	709.66	293956.0
2009-02-27 14:00:00	ES	Futures	709.42	712.27	702.07	707.29	315395.0
2009-02-27 15:00:00	ES	Futures	707.52	707.52	695.9	696.85	640911.0
2009-02-27 16:00:00	ES	Futures	697.09	698.75	694.95	695.43	173546.0
2009-02-27 00:00:00	NQ	Futures	1281.73	1284.55	1272.12	1276.36	287.0
2009-02-27 01:00:00	NQ	Futures	1276.36	1280.31	1274.95	1276.93	89.0
2009-02-27 02:00:00	NQ	Futures	1277.77	1284.83	1277.77	1284.55	273.0
2009-02-27 03:00:00	NQ	Futures	1284.83	1285.4	1277.21	1277.77	1500.0
2009-02-27 04:00:00	NQ	Futures	1277.49	1281.44	1274.95	1278.05	637.0
2009-02-27 05:00:00	NQ	Futures	1277.77	1282.01	1275.23	1281.73	742.0
2009-02-27 06:00:00	NQ	Futures	1281.44	1282.86	1273.54	1276.08	663.0
2009-02-27 07:00:00	NQ	Futures	1275.51	1275.51	1258.01	1265.91	5800.0
2009-02-27 08:00:00	NQ	Futures	1265.91	1268.45	1250.66	1257.44	14678.0
2009-02-27 09:00:00	NQ	Futures	1257.44	1277.21	1255.18	1272.97	59218.0
2009-02-27 10:00:00	NQ	Futures	1272.97	1282.01	1267.32	1272.41	62520.0
2009-02-27 11:00:00	NQ	Futures	1272.41	1279.18	1262.81	1275.8	44886.0
2009-02-27 12:00:00	NQ	Futures	1276.08	1281.16	1264.5	1272.41	34619.0
2009-02-27 13:00:00	NQ	Futures	1272.41	1278.9	1264.78	1277.21	39608.0
2009-02-27 14:00:00	NQ	Futures	1277.21	1282.86	1268.17	1278.05	42292.0
2009-02-27 15:00:00	NQ	Futures	1278.05	1278.05	1261.68	1262.52	76083.0
2009-02-27 16:00:00	NQ	Futures	1262.52	1265.63	1256.03	1257.44	15106.0
2009-02-27 00:00:00	YM	Futures	6547.5	6560.3	6507.4	6525.6	591.0
2009-02-27 01:00:00	YM	Futures	6525.6	6545.7	6522.9	6530.2	182.0
2009-02-27 02:00:00	YM	Futures	6531.1	6565.7	6531.1	6561.2	583.0
2009-02-27 03:00:00	YM	Futures	6563.9	6564.8	6526.5	6528.4	1238.0
2009-02-27 04:00:00	YM	Futures	6528.4	6551.1	6519.3	6534.7	796.0
2009-02-27 05:00:00	YM	Futures	6534.7	6561.2	6525.6	6561.2	652.0
2009-02-27 06:00:00	YM	Futures	6559.3	6560.3	6512.0	6523.8	672.0
2009-02-27 07:00:00	YM	Futures	6522.0	6524.7	6448.2	6469.1	4297.0
2009-02-27 08:00:00	YM	Futures	6469.1	6478.2	6389.9	6425.4	9707.0
2009-02-27 09:00:00	YM	Futures	6424.5	6470.0	6397.1	6450.9	23010.0
2009-02-27 10:00:00	YM	Futures	6450.0	6505.6	6429.9	6482.8	40765.0
2009-02-27 11:00:00	YM	Futures	6483.7	6530.2	6445.4	6519.3	27332.0
2009-02-27 12:00:00	YM	Futures	6519.3	6541.1	6485.5	6512.0	17482.0
2009-02-27 13:00:00	YM	Futures	6512.0	6536.6	6458.2	6523.8	29430.0
2009-02-27 14:00:00	YM	Futures	6522.9	6547.5	6473.7	6513.8	27881.0
2009-02-27 15:00:00	YM	Futures	6513.8	6513.8	6427.2	6429.0	49625.0

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

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