PREVIEW / futures_1hour / 2009-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-17.parquet
  size:    36 KB
  rows:    1,025

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-04-17 00:00:00	ES	Futures	822.42	822.42	820.75	821.23	4345.0
2009-04-17 01:00:00	ES	Futures	821.23	822.42	820.51	822.18	3268.0
2009-04-17 02:00:00	ES	Futures	822.18	822.42	820.51	821.23	4584.0
2009-04-17 03:00:00	ES	Futures	821.46	823.14	819.55	820.27	15101.0
2009-04-17 04:00:00	ES	Futures	820.51	822.18	819.79	820.27	10182.0
2009-04-17 05:00:00	ES	Futures	820.27	824.82	818.35	823.86	23779.0
2009-04-17 06:00:00	ES	Futures	823.62	828.17	822.42	827.46	39126.0
2009-04-17 07:00:00	ES	Futures	827.46	829.61	824.82	828.17	28880.0
2009-04-17 08:00:00	ES	Futures	828.17	829.13	823.38	823.62	49945.0
2009-04-17 09:00:00	ES	Futures	823.86	829.13	823.14	825.78	286641.0
2009-04-17 10:00:00	ES	Futures	825.78	828.41	821.23	823.62	255657.0
2009-04-17 11:00:00	ES	Futures	823.86	828.65	821.7	826.98	204640.0
2009-04-17 12:00:00	ES	Futures	826.98	829.13	825.3	828.65	144613.0
2009-04-17 13:00:00	ES	Futures	828.65	833.93	828.17	832.97	162224.0
2009-04-17 14:00:00	ES	Futures	832.97	835.6	830.09	830.57	182043.0
2009-04-17 15:00:00	ES	Futures	830.57	835.84	828.89	830.33	334958.0
2009-04-17 16:00:00	ES	Futures	830.33	831.29	829.13	831.05	89113.0
2009-04-17 00:00:00	NQ	Futures	1523.56	1524.13	1521.85	1522.71	176.0
2009-04-17 01:00:00	NQ	Futures	1522.99	1528.39	1521.85	1528.1	192.0
2009-04-17 02:00:00	NQ	Futures	1526.4	1528.67	1524.13	1524.69	343.0
2009-04-17 03:00:00	NQ	Futures	1524.98	1527.82	1519.3	1521.57	2027.0
2009-04-17 04:00:00	NQ	Futures	1521.85	1525.26	1521.28	1521.85	1143.0
2009-04-17 05:00:00	NQ	Futures	1521.85	1529.81	1520.15	1528.1	1403.0
2009-04-17 06:00:00	NQ	Futures	1527.82	1534.07	1525.26	1532.65	2127.0
2009-04-17 07:00:00	NQ	Futures	1532.65	1534.92	1527.25	1534.07	2446.0
2009-04-17 08:00:00	NQ	Futures	1533.79	1536.06	1525.26	1525.55	4003.0
2009-04-17 09:00:00	NQ	Futures	1525.26	1532.37	1521.57	1528.96	44568.0
2009-04-17 10:00:00	NQ	Futures	1528.96	1533.22	1520.15	1522.14	38548.0
2009-04-17 11:00:00	NQ	Futures	1522.42	1529.24	1520.72	1526.97	20953.0
2009-04-17 12:00:00	NQ	Futures	1526.97	1532.37	1522.99	1531.8	18568.0
2009-04-17 13:00:00	NQ	Futures	1532.08	1542.31	1531.23	1542.31	25047.0
2009-04-17 14:00:00	NQ	Futures	1542.31	1546.57	1535.78	1537.2	28535.0
2009-04-17 15:00:00	NQ	Futures	1536.91	1544.3	1535.49	1537.2	44928.0
2009-04-17 16:00:00	NQ	Futures	1537.48	1539.19	1534.64	1537.48	8309.0
2009-04-17 00:00:00	YM	Futures	7383.8	7383.8	7362.6	7369.1	765.0
2009-04-17 01:00:00	YM	Futures	7369.1	7381.0	7365.4	7378.2	315.0
2009-04-17 02:00:00	YM	Futures	7379.2	7382.8	7367.2	7371.8	393.0
2009-04-17 03:00:00	YM	Futures	7373.6	7389.3	7357.1	7365.4	1388.0
2009-04-17 04:00:00	YM	Futures	7365.4	7387.4	7363.5	7370.9	1077.0
2009-04-17 05:00:00	YM	Futures	7372.7	7407.6	7357.1	7399.4	1446.0
2009-04-17 06:00:00	YM	Futures	7398.5	7436.1	7390.2	7427.9	2202.0
2009-04-17 07:00:00	YM	Futures	7427.9	7443.5	7410.4	7436.1	1923.0
2009-04-17 08:00:00	YM	Futures	7436.1	7442.6	7400.3	7400.3	2573.0
2009-04-17 09:00:00	YM	Futures	7400.3	7454.5	7400.3	7427.9	21997.0
2009-04-17 10:00:00	YM	Futures	7427.9	7444.4	7382.8	7403.1	22891.0
2009-04-17 11:00:00	YM	Futures	7404.0	7437.1	7387.4	7425.1	17194.0
2009-04-17 12:00:00	YM	Futures	7426.0	7438.9	7404.0	7431.5	12161.0
2009-04-17 13:00:00	YM	Futures	7431.5	7466.5	7426.0	7459.1	12679.0
2009-04-17 14:00:00	YM	Futures	7459.1	7477.5	7429.7	7433.4	15485.0
2009-04-17 15:00:00	YM	Futures	7435.2	7476.6	7408.6	7427.9	24032.0

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

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