PREVIEW / futures_1hour / 2009-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-18.parquet
  size:    38 KB
  rows:    1,103

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-18 00:00:00	ES	Futures	1067.18	1067.66	1066.69	1067.66	1644.0
2009-12-18 01:00:00	ES	Futures	1067.42	1069.37	1067.42	1067.66	5104.0
2009-12-18 02:00:00	ES	Futures	1067.91	1069.37	1066.93	1068.39	9562.0
2009-12-18 03:00:00	ES	Futures	1068.15	1070.34	1068.15	1068.64	21218.0
2009-12-18 04:00:00	ES	Futures	1068.39	1071.07	1068.39	1070.83	13746.0
2009-12-18 05:00:00	ES	Futures	1070.83	1073.01	1070.34	1071.07	24926.0
2009-12-18 06:00:00	ES	Futures	1070.83	1071.8	1066.93	1067.66	23271.0
2009-12-18 07:00:00	ES	Futures	1067.42	1070.34	1067.42	1069.37	38295.0
2009-12-18 08:00:00	ES	Futures	1069.37	1070.1	1066.69	1066.93	32690.0
2009-12-18 09:00:00	ES	Futures	1066.93	1069.37	1065.47	1066.93	231628.0
2009-12-18 10:00:00	ES	Futures	1066.93	1068.39	1062.55	1064.01	251258.0
2009-12-18 11:00:00	ES	Futures	1063.77	1064.5	1059.15	1061.34	228116.0
2009-12-18 12:00:00	ES	Futures	1061.34	1064.99	1060.37	1064.26	143652.0
2009-12-18 13:00:00	ES	Futures	1064.5	1066.93	1064.01	1065.47	129004.0
2009-12-18 14:00:00	ES	Futures	1065.47	1066.2	1064.26	1065.96	90337.0
2009-12-18 15:00:00	ES	Futures	1065.96	1069.37	1063.53	1068.64	291874.0
2009-12-18 16:00:00	ES	Futures	1068.88	1069.12	1067.18	1068.39	123282.0
2009-12-18 00:00:00	NQ	Futures	2043.68	2046.53	2043.68	2046.25	216.0
2009-12-18 01:00:00	NQ	Futures	2046.53	2047.1	2043.68	2044.53	410.0
2009-12-18 02:00:00	NQ	Futures	2044.25	2045.39	2041.96	2043.11	932.0
2009-12-18 03:00:00	NQ	Futures	2043.11	2048.82	2043.11	2043.68	2472.0
2009-12-18 04:00:00	NQ	Futures	2043.68	2048.25	2043.68	2047.96	952.0
2009-12-18 05:00:00	NQ	Futures	2047.96	2051.39	2046.82	2048.25	2234.0
2009-12-18 06:00:00	NQ	Futures	2048.53	2049.1	2041.96	2043.11	1599.0
2009-12-18 07:00:00	NQ	Futures	2043.11	2046.82	2042.53	2045.68	2018.0
2009-12-18 08:00:00	NQ	Futures	2045.68	2046.53	2041.96	2043.11	3560.0
2009-12-18 09:00:00	NQ	Futures	2043.11	2059.67	2042.82	2054.53	58251.0
2009-12-18 10:00:00	NQ	Futures	2054.53	2057.1	2044.82	2048.53	41415.0
2009-12-18 11:00:00	NQ	Futures	2048.53	2049.96	2042.53	2046.53	37050.0
2009-12-18 12:00:00	NQ	Futures	2046.82	2055.67	2045.39	2055.1	27648.0
2009-12-18 13:00:00	NQ	Futures	2055.1	2059.67	2051.67	2056.24	27850.0
2009-12-18 14:00:00	NQ	Futures	2056.24	2059.67	2054.82	2058.81	16362.0
2009-12-18 15:00:00	NQ	Futures	2058.81	2064.53	2053.1	2063.67	45139.0
2009-12-18 16:00:00	NQ	Futures	2063.67	2065.1	2061.96	2063.38	13587.0
2009-12-18 00:00:00	YM	Futures	9633.2	9635.1	9627.6	9633.2	139.0
2009-12-18 01:00:00	YM	Futures	9632.3	9646.3	9631.4	9632.3	322.0
2009-12-18 02:00:00	YM	Futures	9633.2	9642.6	9625.8	9637.9	804.0
2009-12-18 03:00:00	YM	Futures	9637.0	9651.0	9634.2	9638.9	1428.0
2009-12-18 04:00:00	YM	Futures	9637.9	9654.8	9637.0	9653.8	1067.0
2009-12-18 05:00:00	YM	Futures	9653.8	9683.8	9652.9	9658.5	1875.0
2009-12-18 06:00:00	YM	Futures	9657.6	9666.0	9631.4	9632.3	1046.0
2009-12-18 07:00:00	YM	Futures	9632.3	9652.0	9632.3	9644.5	1432.0
2009-12-18 08:00:00	YM	Futures	9645.4	9650.1	9629.5	9630.4	1250.0
2009-12-18 09:00:00	YM	Futures	9630.4	9651.0	9615.5	9621.1	15289.0
2009-12-18 10:00:00	YM	Futures	9621.1	9629.5	9580.8	9592.1	20102.0
2009-12-18 11:00:00	YM	Futures	9591.1	9595.8	9546.2	9561.2	17573.0
2009-12-18 12:00:00	YM	Futures	9561.2	9590.2	9555.6	9586.5	9932.0
2009-12-18 13:00:00	YM	Futures	9586.5	9605.2	9584.6	9590.2	9105.0
2009-12-18 14:00:00	YM	Futures	9591.1	9595.8	9578.0	9589.3	5975.0
2009-12-18 15:00:00	YM	Futures	9589.3	9619.2	9568.7	9614.5	14417.0

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

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