PREVIEW / futures_1hour / 2009-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-08.parquet
  size:    47 KB
  rows:    1,383

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-08 00:00:00	ES	Futures	1070.62	1071.1	1069.65	1070.38	3385.0
2009-12-08 01:00:00	ES	Futures	1070.38	1071.35	1069.65	1070.62	2902.0
2009-12-08 02:00:00	ES	Futures	1070.86	1070.86	1068.2	1068.44	7213.0
2009-12-08 03:00:00	ES	Futures	1068.44	1071.83	1066.74	1069.89	25050.0
2009-12-08 04:00:00	ES	Futures	1070.14	1072.56	1068.44	1072.07	19386.0
2009-12-08 05:00:00	ES	Futures	1071.83	1072.8	1070.38	1070.38	11217.0
2009-12-08 06:00:00	ES	Futures	1070.38	1070.38	1062.38	1064.56	57753.0
2009-12-08 07:00:00	ES	Futures	1064.32	1064.56	1058.99	1061.42	73966.0
2009-12-08 08:00:00	ES	Futures	1061.42	1062.63	1058.02	1059.96	91484.0
2009-12-08 09:00:00	ES	Futures	1059.96	1062.38	1053.91	1058.27	350357.0
2009-12-08 10:00:00	ES	Futures	1058.27	1060.69	1055.84	1058.02	291555.0
2009-12-08 11:00:00	ES	Futures	1058.02	1063.35	1057.54	1060.69	297606.0
2009-12-08 12:00:00	ES	Futures	1060.69	1061.66	1058.51	1060.93	128666.0
2009-12-08 13:00:00	ES	Futures	1060.93	1061.66	1057.06	1058.99	179722.0
2009-12-08 14:00:00	ES	Futures	1058.99	1059.96	1054.88	1055.6	223159.0
2009-12-08 15:00:00	ES	Futures	1055.6	1058.75	1055.36	1057.3	223422.0
2009-12-08 16:00:00	ES	Futures	1057.54	1057.54	1055.36	1055.84	93843.0
2009-12-08 17:00:00	ES	Futures	1055.84	1056.33	1055.84	1056.09	1000.0
2009-12-08 18:00:00	ES	Futures	1055.6	1056.33	1054.63	1056.33	5832.0
2009-12-08 19:00:00	ES	Futures	1056.33	1058.75	1056.09	1058.51	7738.0
2009-12-08 20:00:00	ES	Futures	1058.75	1058.99	1057.3	1058.75	3410.0
2009-12-08 21:00:00	ES	Futures	1058.75	1059.48	1058.27	1058.99	3517.0
2009-12-08 22:00:00	ES	Futures	1058.75	1058.99	1058.27	1058.51	1609.0
2009-12-08 23:00:00	ES	Futures	1058.27	1059.48	1058.02	1058.75	2409.0
2009-12-08 00:00:00	NQ	Futures	2037.14	2037.71	2035.15	2036.57	168.0
2009-12-08 01:00:00	NQ	Futures	2036.29	2038.85	2035.43	2037.43	187.0
2009-12-08 02:00:00	NQ	Futures	2037.71	2038.0	2032.01	2032.01	561.0
2009-12-08 03:00:00	NQ	Futures	2032.29	2039.71	2029.73	2036.29	2537.0
2009-12-08 04:00:00	NQ	Futures	2036.57	2041.13	2033.72	2040.28	1836.0
2009-12-08 05:00:00	NQ	Futures	2040.28	2041.7	2037.14	2037.14	1130.0
2009-12-08 06:00:00	NQ	Futures	2037.14	2037.14	2019.17	2023.45	6504.0
2009-12-08 07:00:00	NQ	Futures	2023.17	2023.17	2012.9	2017.75	6392.0
2009-12-08 08:00:00	NQ	Futures	2017.75	2020.03	2012.9	2017.18	6337.0
2009-12-08 09:00:00	NQ	Futures	2016.89	2023.45	2007.77	2016.32	66606.0
2009-12-08 10:00:00	NQ	Futures	2016.61	2023.45	2013.19	2017.75	49292.0
2009-12-08 11:00:00	NQ	Futures	2017.75	2037.71	2016.61	2034.58	68917.0
2009-12-08 12:00:00	NQ	Futures	2034.29	2036.0	2028.87	2032.86	27384.0
2009-12-08 13:00:00	NQ	Futures	2032.86	2033.72	2026.02	2030.01	24782.0
2009-12-08 14:00:00	NQ	Futures	2030.3	2031.72	2020.6	2021.46	32516.0
2009-12-08 15:00:00	NQ	Futures	2021.46	2026.59	2020.03	2020.89	38244.0
2009-12-08 16:00:00	NQ	Futures	2020.89	2021.17	2016.04	2017.75	12107.0
2009-12-08 17:00:00	NQ	Futures	2017.75	2018.6	2017.75	2018.32	110.0
2009-12-08 18:00:00	NQ	Futures	2017.46	2018.03	2014.9	2018.03	410.0
2009-12-08 19:00:00	NQ	Futures	2018.32	2022.31	2018.32	2022.03	321.0
2009-12-08 20:00:00	NQ	Futures	2022.03	2023.17	2019.75	2022.88	419.0
2009-12-08 21:00:00	NQ	Futures	2022.88	2023.45	2022.6	2022.88	271.0
2009-12-08 22:00:00	NQ	Futures	2022.88	2023.17	2022.31	2022.6	118.0
2009-12-08 23:00:00	NQ	Futures	2022.6	2024.31	2021.46	2023.74	192.0
2009-12-08 00:00:00	YM	Futures	9673.9	9676.7	9665.5	9672.1	218.0
2009-12-08 01:00:00	YM	Futures	9672.1	9679.5	9668.3	9676.7	230.0

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

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