PREVIEW / futures_30min / 2010-07-02

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-07-02.parquet
  size:    60 KB
  rows:    2,020

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
2010-07-02 00:00:00	ES	Futures	1005.32	1006.3	1004.58	1006.06	1847.0
2010-07-02 00:30:00	ES	Futures	1006.06	1007.04	1005.81	1006.06	1187.0
2010-07-02 01:00:00	ES	Futures	1006.3	1006.3	1004.34	1004.58	1767.0
2010-07-02 01:30:00	ES	Futures	1004.34	1004.83	1003.36	1004.09	2592.0
2010-07-02 02:00:00	ES	Futures	1004.34	1005.57	1003.85	1005.07	5707.0
2010-07-02 02:30:00	ES	Futures	1005.07	1005.81	1004.34	1005.32	6747.0
2010-07-02 03:00:00	ES	Futures	1005.32	1005.57	1002.13	1002.38	18210.0
2010-07-02 03:30:00	ES	Futures	1002.38	1003.11	1000.9	1001.88	15214.0
2010-07-02 04:00:00	ES	Futures	1001.88	1003.85	1001.15	1003.6	8434.0
2010-07-02 04:30:00	ES	Futures	1003.85	1004.83	1003.11	1003.85	9273.0
2010-07-02 05:00:00	ES	Futures	1003.6	1004.58	1002.38	1002.87	7048.0
2010-07-02 05:30:00	ES	Futures	1003.11	1004.09	1002.62	1003.6	7119.0
2010-07-02 06:00:00	ES	Futures	1003.6	1004.83	1003.36	1003.85	5234.0
2010-07-02 06:30:00	ES	Futures	1003.85	1004.09	1002.62	1002.62	4772.0
2010-07-02 07:00:00	ES	Futures	1002.62	1004.83	1002.62	1004.58	9444.0
2010-07-02 07:30:00	ES	Futures	1004.58	1006.3	1004.09	1006.3	16220.0
2010-07-02 08:00:00	ES	Futures	1006.3	1010.96	1004.09	1010.23	44088.0
2010-07-02 08:30:00	ES	Futures	1010.23	1013.42	998.69	1002.62	223669.0
2010-07-02 09:00:00	ES	Futures	1002.62	1008.76	1002.13	1007.04	69204.0
2010-07-02 09:30:00	ES	Futures	1007.04	1009.98	1002.62	1005.07	228790.0
2010-07-02 10:00:00	ES	Futures	1005.07	1007.28	1000.41	1004.58	179420.0
2010-07-02 10:30:00	ES	Futures	1004.83	1005.32	1001.15	1001.88	106106.0
2010-07-02 11:00:00	ES	Futures	1001.88	1003.36	998.69	998.69	122408.0
2010-07-02 11:30:00	ES	Futures	998.94	999.19	994.03	996.98	160111.0
2010-07-02 12:00:00	ES	Futures	996.98	999.43	995.75	997.71	83388.0
2010-07-02 12:30:00	ES	Futures	997.71	998.2	994.52	995.01	54372.0
2010-07-02 13:00:00	ES	Futures	995.01	996.73	992.07	994.28	108347.0
2010-07-02 13:30:00	ES	Futures	994.03	998.69	993.79	998.2	58319.0
2010-07-02 14:00:00	ES	Futures	998.2	998.69	995.75	996.73	53078.0
2010-07-02 14:30:00	ES	Futures	996.98	998.2	995.01	997.96	61041.0
2010-07-02 15:00:00	ES	Futures	997.96	1002.62	996.98	1001.39	90742.0
2010-07-02 15:30:00	ES	Futures	1001.39	1007.04	997.96	998.45	217399.0
2010-07-02 16:00:00	ES	Futures	998.45	998.69	994.52	995.5	113159.0
2010-07-02 00:00:00	NQ	Futures	1988.2	1989.91	1985.9	1988.48	261.0
2010-07-02 00:30:00	NQ	Futures	1988.2	1989.91	1987.91	1988.77	95.0
2010-07-02 01:00:00	NQ	Futures	1988.77	1989.05	1985.33	1986.48	273.0
2010-07-02 01:30:00	NQ	Futures	1986.48	1986.76	1983.61	1985.62	261.0
2010-07-02 02:00:00	NQ	Futures	1985.33	1987.91	1985.04	1987.62	468.0
2010-07-02 02:30:00	NQ	Futures	1987.34	1988.48	1985.9	1987.34	493.0
2010-07-02 03:00:00	NQ	Futures	1987.05	1987.05	1981.6	1981.89	1596.0
2010-07-02 03:30:00	NQ	Futures	1981.89	1983.32	1979.02	1980.46	1467.0
2010-07-02 04:00:00	NQ	Futures	1980.46	1985.9	1979.6	1985.62	1670.0
2010-07-02 04:30:00	NQ	Futures	1985.33	1987.91	1984.47	1984.76	859.0
2010-07-02 05:00:00	NQ	Futures	1984.47	1985.9	1982.18	1983.32	707.0
2010-07-02 05:30:00	NQ	Futures	1983.32	1985.62	1982.46	1984.18	286.0
2010-07-02 06:00:00	NQ	Futures	1984.18	1986.48	1983.9	1985.04	337.0
2010-07-02 06:30:00	NQ	Futures	1984.76	1985.9	1983.9	1984.18	509.0
2010-07-02 07:00:00	NQ	Futures	1984.18	1986.48	1983.9	1986.19	807.0
2010-07-02 07:30:00	NQ	Futures	1986.19	1991.35	1985.33	1991.06	1798.0
2010-07-02 08:00:00	NQ	Futures	1991.06	1993.64	1981.03	1992.49	3965.0

> showing 50 of 2,020 rows — these rows as CSV

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