PREVIEW / futures_1hour / 2009-12-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-01.parquet
  size:    46 KB
  rows:    1,369

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-12-01 00:00:00	ES	Futures	1061.9	1062.38	1059.96	1062.14	4264.0
2009-12-01 01:00:00	ES	Futures	1062.38	1062.38	1059.96	1061.66	5232.0
2009-12-01 02:00:00	ES	Futures	1061.66	1063.84	1061.42	1061.9	15040.0
2009-12-01 03:00:00	ES	Futures	1062.14	1068.92	1061.9	1068.44	52675.0
2009-12-01 04:00:00	ES	Futures	1068.44	1070.62	1067.96	1068.92	26352.0
2009-12-01 05:00:00	ES	Futures	1069.17	1070.14	1067.47	1068.44	18845.0
2009-12-01 06:00:00	ES	Futures	1068.44	1070.14	1067.47	1070.14	15573.0
2009-12-01 07:00:00	ES	Futures	1069.89	1070.62	1068.68	1068.68	20351.0
2009-12-01 08:00:00	ES	Futures	1068.92	1070.14	1068.2	1069.65	26566.0
2009-12-01 09:00:00	ES	Futures	1069.41	1074.01	1068.92	1072.32	250456.0
2009-12-01 10:00:00	ES	Futures	1072.07	1073.53	1067.96	1070.86	325209.0
2009-12-01 11:00:00	ES	Futures	1071.1	1074.25	1070.86	1073.53	208786.0
2009-12-01 12:00:00	ES	Futures	1073.28	1074.98	1072.8	1073.53	121912.0
2009-12-01 13:00:00	ES	Futures	1073.53	1077.16	1073.53	1075.95	137333.0
2009-12-01 14:00:00	ES	Futures	1075.95	1076.92	1073.77	1074.74	148788.0
2009-12-01 15:00:00	ES	Futures	1074.74	1075.46	1072.07	1073.04	292457.0
2009-12-01 16:00:00	ES	Futures	1073.04	1074.25	1072.32	1073.28	113897.0
2009-12-01 17:00:00	ES	Futures	1073.28	1073.77	1073.28	1073.28	794.0
2009-12-01 18:00:00	ES	Futures	1073.28	1074.5	1073.04	1074.01	4546.0
2009-12-01 19:00:00	ES	Futures	1074.01	1074.5	1072.8	1074.01	4724.0
2009-12-01 20:00:00	ES	Futures	1074.01	1074.5	1072.56	1072.8	3897.0
2009-12-01 21:00:00	ES	Futures	1072.8	1073.77	1072.8	1073.28	2117.0
2009-12-01 22:00:00	ES	Futures	1073.28	1074.01	1073.28	1073.53	2138.0
2009-12-01 23:00:00	ES	Futures	1073.77	1074.01	1073.04	1073.53	1102.0
2009-12-01 00:00:00	NQ	Futures	2018.89	2020.89	2015.47	2020.6	549.0
2009-12-01 01:00:00	NQ	Futures	2020.32	2021.46	2016.89	2019.75	569.0
2009-12-01 02:00:00	NQ	Futures	2020.03	2024.02	2020.03	2021.46	859.0
2009-12-01 03:00:00	NQ	Futures	2021.74	2033.72	2020.6	2032.86	4018.0
2009-12-01 04:00:00	NQ	Futures	2032.86	2037.14	2032.29	2034.0	2215.0
2009-12-01 05:00:00	NQ	Futures	2033.72	2035.72	2031.15	2032.86	1214.0
2009-12-01 06:00:00	NQ	Futures	2033.15	2036.29	2031.44	2036.0	840.0
2009-12-01 07:00:00	NQ	Futures	2036.0	2036.29	2032.58	2032.86	807.0
2009-12-01 08:00:00	NQ	Futures	2032.86	2035.15	2030.87	2034.58	2393.0
2009-12-01 09:00:00	NQ	Futures	2034.58	2044.27	2031.72	2043.13	46763.0
2009-12-01 10:00:00	NQ	Futures	2042.56	2045.7	2034.58	2041.7	49766.0
2009-12-01 11:00:00	NQ	Futures	2041.7	2046.27	2039.71	2045.7	32189.0
2009-12-01 12:00:00	NQ	Futures	2045.41	2049.12	2045.13	2047.41	20792.0
2009-12-01 13:00:00	NQ	Futures	2047.41	2052.26	2046.55	2049.12	16735.0
2009-12-01 14:00:00	NQ	Futures	2049.12	2051.4	2044.84	2046.55	21001.0
2009-12-01 15:00:00	NQ	Futures	2046.55	2048.26	2037.71	2038.85	48644.0
2009-12-01 16:00:00	NQ	Futures	2039.14	2043.99	2038.0	2041.99	13902.0
2009-12-01 17:00:00	NQ	Futures	2041.99	2042.85	2041.7	2042.28	72.0
2009-12-01 18:00:00	NQ	Futures	2042.28	2044.84	2041.99	2043.7	301.0
2009-12-01 19:00:00	NQ	Futures	2043.7	2043.99	2041.42	2043.13	699.0
2009-12-01 20:00:00	NQ	Futures	2043.13	2043.7	2040.28	2040.56	471.0
2009-12-01 21:00:00	NQ	Futures	2040.85	2042.85	2040.85	2041.7	200.0
2009-12-01 22:00:00	NQ	Futures	2041.99	2043.13	2041.42	2042.56	201.0
2009-12-01 23:00:00	NQ	Futures	2042.56	2042.85	2041.42	2041.99	113.0
2009-12-01 00:00:00	YM	Futures	9622.8	9628.3	9606.9	9626.5	309.0
2009-12-01 01:00:00	YM	Futures	9626.5	9628.3	9611.6	9621.8	316.0

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

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