PREVIEW / futures_30min / 2010-08-20

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-08-20.parquet
  size:    60 KB
  rows:    2,007

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-08-20 00:00:00	ES	Futures	1051.45	1051.45	1049.24	1049.73	7619.0
2010-08-20 00:30:00	ES	Futures	1049.49	1049.98	1049.0	1049.49	3328.0
2010-08-20 01:00:00	ES	Futures	1049.49	1051.94	1049.49	1050.72	3186.0
2010-08-20 01:30:00	ES	Futures	1050.96	1052.68	1050.72	1052.19	2970.0
2010-08-20 02:00:00	ES	Futures	1052.19	1053.91	1051.21	1052.92	6237.0
2010-08-20 02:30:00	ES	Futures	1053.17	1054.15	1052.43	1052.68	4511.0
2010-08-20 03:00:00	ES	Futures	1052.68	1056.11	1052.68	1052.92	21529.0
2010-08-20 03:30:00	ES	Futures	1052.92	1054.64	1051.7	1052.43	15673.0
2010-08-20 04:00:00	ES	Futures	1052.43	1054.15	1050.47	1052.19	15928.0
2010-08-20 04:30:00	ES	Futures	1052.43	1052.43	1049.49	1049.98	12401.0
2010-08-20 05:00:00	ES	Futures	1049.98	1051.7	1049.49	1050.72	10839.0
2010-08-20 05:30:00	ES	Futures	1050.96	1050.96	1047.03	1048.02	19617.0
2010-08-20 06:00:00	ES	Futures	1048.26	1049.0	1043.84	1044.09	32109.0
2010-08-20 06:30:00	ES	Futures	1044.09	1046.54	1043.84	1044.34	19379.0
2010-08-20 07:00:00	ES	Futures	1044.34	1047.28	1043.84	1047.28	17963.0
2010-08-20 07:30:00	ES	Futures	1047.28	1047.77	1045.56	1046.54	11602.0
2010-08-20 08:00:00	ES	Futures	1046.3	1048.02	1045.81	1045.81	22694.0
2010-08-20 08:30:00	ES	Futures	1045.81	1048.51	1044.83	1048.51	36872.0
2010-08-20 09:00:00	ES	Futures	1048.51	1050.47	1046.79	1050.47	60927.0
2010-08-20 09:30:00	ES	Futures	1050.47	1051.45	1044.58	1047.28	248777.0
2010-08-20 10:00:00	ES	Futures	1047.53	1049.73	1045.07	1046.54	203133.0
2010-08-20 10:30:00	ES	Futures	1046.54	1049.24	1046.54	1047.28	105087.0
2010-08-20 11:00:00	ES	Futures	1047.28	1048.26	1044.58	1046.3	104598.0
2010-08-20 11:30:00	ES	Futures	1046.3	1046.3	1042.13	1042.86	115916.0
2010-08-20 12:00:00	ES	Futures	1042.62	1045.56	1042.62	1045.32	64688.0
2010-08-20 12:30:00	ES	Futures	1045.07	1045.81	1043.84	1045.32	38190.0
2010-08-20 13:00:00	ES	Futures	1045.32	1047.28	1045.32	1046.3	46755.0
2010-08-20 13:30:00	ES	Futures	1046.3	1047.53	1045.07	1046.3	44676.0
2010-08-20 14:00:00	ES	Futures	1046.05	1048.26	1046.05	1047.03	46906.0
2010-08-20 14:30:00	ES	Futures	1047.28	1051.7	1047.03	1049.98	123249.0
2010-08-20 15:00:00	ES	Futures	1049.98	1051.21	1048.75	1049.98	89309.0
2010-08-20 15:30:00	ES	Futures	1050.22	1051.7	1049.49	1050.22	129614.0
2010-08-20 16:00:00	ES	Futures	1049.98	1051.21	1048.75	1051.21	84481.0
2010-08-20 00:00:00	NQ	Futures	2085.34	2085.91	2083.05	2083.34	231.0
2010-08-20 00:30:00	NQ	Futures	2083.34	2084.19	2081.9	2083.34	230.0
2010-08-20 01:00:00	NQ	Futures	2083.34	2087.06	2083.34	2084.77	254.0
2010-08-20 01:30:00	NQ	Futures	2085.05	2088.21	2085.05	2087.92	240.0
2010-08-20 02:00:00	NQ	Futures	2087.63	2090.5	2085.63	2088.49	523.0
2010-08-20 02:30:00	NQ	Futures	2088.49	2090.5	2087.06	2087.92	305.0
2010-08-20 03:00:00	NQ	Futures	2088.21	2094.51	2088.21	2088.78	1528.0
2010-08-20 03:30:00	NQ	Futures	2088.49	2092.22	2086.2	2087.92	799.0
2010-08-20 04:00:00	NQ	Futures	2087.92	2090.5	2084.48	2087.63	1387.0
2010-08-20 04:30:00	NQ	Futures	2087.63	2087.63	2081.9	2083.05	944.0
2010-08-20 05:00:00	NQ	Futures	2083.05	2087.06	2082.19	2085.05	615.0
2010-08-20 05:30:00	NQ	Futures	2084.77	2084.77	2078.46	2080.76	1084.0
2010-08-20 06:00:00	NQ	Futures	2080.76	2082.76	2073.31	2073.88	2509.0
2010-08-20 06:30:00	NQ	Futures	2073.88	2077.32	2073.31	2073.59	854.0
2010-08-20 07:00:00	NQ	Futures	2073.31	2081.04	2073.02	2080.18	2284.0
2010-08-20 07:30:00	NQ	Futures	2080.47	2081.04	2077.03	2079.04	1042.0
2010-08-20 08:00:00	NQ	Futures	2079.04	2081.62	2077.6	2077.6	2087.0

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

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