PREVIEW / futures_1hour / 2009-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-25.parquet
  size:    42 KB
  rows:    1,266

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-11-25 00:00:00	ES	Futures	1070.86	1071.1	1070.38	1070.86	2658.0
2009-11-25 01:00:00	ES	Futures	1070.62	1072.56	1070.62	1072.56	6376.0
2009-11-25 02:00:00	ES	Futures	1072.32	1074.74	1072.32	1073.53	11866.0
2009-11-25 03:00:00	ES	Futures	1073.53	1074.98	1072.32	1072.8	19820.0
2009-11-25 04:00:00	ES	Futures	1072.8	1074.74	1071.59	1074.25	13289.0
2009-11-25 05:00:00	ES	Futures	1074.25	1074.74	1071.83	1072.32	9852.0
2009-11-25 06:00:00	ES	Futures	1072.07	1074.74	1071.35	1073.77	14720.0
2009-11-25 07:00:00	ES	Futures	1073.53	1074.5	1072.56	1074.01	16523.0
2009-11-25 08:00:00	ES	Futures	1074.01	1076.68	1071.59	1073.77	72019.0
2009-11-25 09:00:00	ES	Futures	1073.77	1074.25	1068.92	1070.86	209524.0
2009-11-25 10:00:00	ES	Futures	1071.1	1074.01	1070.14	1072.56	210807.0
2009-11-25 11:00:00	ES	Futures	1072.56	1075.46	1072.07	1074.5	108579.0
2009-11-25 12:00:00	ES	Futures	1074.74	1074.98	1072.07	1073.04	62681.0
2009-11-25 13:00:00	ES	Futures	1073.04	1074.01	1072.8	1073.77	38496.0
2009-11-25 14:00:00	ES	Futures	1073.77	1075.71	1072.56	1075.22	67718.0
2009-11-25 15:00:00	ES	Futures	1074.98	1075.46	1073.53	1074.25	133977.0
2009-11-25 16:00:00	ES	Futures	1074.5	1075.22	1074.01	1074.5	50678.0
2009-11-25 17:00:00	ES	Futures	1074.25	1075.22	1074.25	1074.5	922.0
2009-11-25 18:00:00	ES	Futures	1074.74	1074.74	1073.77	1074.01	1195.0
2009-11-25 19:00:00	ES	Futures	1074.01	1074.25	1073.53	1074.01	1261.0
2009-11-25 20:00:00	ES	Futures	1074.01	1076.68	1074.01	1074.98	4512.0
2009-11-25 21:00:00	ES	Futures	1075.22	1075.22	1072.07	1072.32	4430.0
2009-11-25 22:00:00	ES	Futures	1072.56	1073.53	1070.38	1071.83	3694.0
2009-11-25 23:00:00	ES	Futures	1072.07	1072.56	1070.14	1071.1	3199.0
2009-11-25 00:00:00	NQ	Futures	2041.7	2042.85	2041.7	2042.28	103.0
2009-11-25 01:00:00	NQ	Futures	2042.28	2045.41	2042.28	2045.13	575.0
2009-11-25 02:00:00	NQ	Futures	2045.41	2048.55	2045.13	2046.84	773.0
2009-11-25 03:00:00	NQ	Futures	2046.84	2049.41	2045.41	2045.98	2417.0
2009-11-25 04:00:00	NQ	Futures	2045.7	2049.41	2043.7	2049.12	2002.0
2009-11-25 05:00:00	NQ	Futures	2049.12	2049.69	2044.56	2044.56	1257.0
2009-11-25 06:00:00	NQ	Futures	2044.84	2049.41	2043.42	2047.69	770.0
2009-11-25 07:00:00	NQ	Futures	2047.41	2048.83	2045.41	2048.26	956.0
2009-11-25 08:00:00	NQ	Futures	2047.98	2053.11	2043.42	2048.26	5659.0
2009-11-25 09:00:00	NQ	Futures	2048.55	2049.41	2038.0	2041.99	32645.0
2009-11-25 10:00:00	NQ	Futures	2042.28	2047.12	2040.85	2044.56	32915.0
2009-11-25 11:00:00	NQ	Futures	2044.56	2047.98	2043.7	2045.98	18807.0
2009-11-25 12:00:00	NQ	Futures	2046.27	2046.55	2040.85	2042.85	13946.0
2009-11-25 13:00:00	NQ	Futures	2042.56	2045.98	2041.99	2045.41	9888.0
2009-11-25 14:00:00	NQ	Futures	2045.13	2048.26	2043.13	2046.27	13983.0
2009-11-25 15:00:00	NQ	Futures	2046.27	2047.12	2043.13	2045.7	23126.0
2009-11-25 16:00:00	NQ	Futures	2045.98	2047.41	2045.41	2046.84	7495.0
2009-11-25 17:00:00	NQ	Futures	2046.84	2047.69	2046.84	2046.84	91.0
2009-11-25 18:00:00	NQ	Futures	2046.84	2047.41	2045.7	2046.55	30.0
2009-11-25 19:00:00	NQ	Futures	2045.98	2047.12	2044.56	2045.98	132.0
2009-11-25 20:00:00	NQ	Futures	2046.27	2050.26	2045.98	2047.41	295.0
2009-11-25 21:00:00	NQ	Futures	2047.69	2047.69	2041.7	2041.99	269.0
2009-11-25 22:00:00	NQ	Futures	2041.99	2043.99	2038.28	2041.42	203.0
2009-11-25 23:00:00	NQ	Futures	2041.42	2041.99	2037.43	2039.42	158.0
2009-11-25 00:00:00	YM	Futures	9689.7	9697.2	9689.7	9693.5	183.0
2009-11-25 01:00:00	YM	Futures	9692.5	9709.3	9691.6	9707.4	449.0

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

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