PREVIEW / futures_1hour / 2010-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-25.parquet
  size:    48 KB
  rows:    1,400

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-05-25 00:00:00	ES	Futures	1029.52	1031.97	1029.03	1029.77	10081.0
2010-05-25 01:00:00	ES	Futures	1029.77	1030.99	1028.06	1028.79	9165.0
2010-05-25 02:00:00	ES	Futures	1028.79	1031.72	1019.01	1022.44	58386.0
2010-05-25 03:00:00	ES	Futures	1022.44	1025.12	1018.28	1023.17	87475.0
2010-05-25 04:00:00	ES	Futures	1023.41	1024.63	1018.28	1019.99	47362.0
2010-05-25 05:00:00	ES	Futures	1019.99	1022.19	1018.52	1018.52	32337.0
2010-05-25 06:00:00	ES	Futures	1018.52	1023.66	1013.64	1022.92	62396.0
2010-05-25 07:00:00	ES	Futures	1023.17	1023.41	1017.06	1021.95	59882.0
2010-05-25 08:00:00	ES	Futures	1021.95	1025.37	1019.01	1020.24	113562.0
2010-05-25 09:00:00	ES	Futures	1020.24	1025.86	1015.35	1024.39	504693.0
2010-05-25 10:00:00	ES	Futures	1024.39	1030.99	1022.19	1026.1	526641.0
2010-05-25 11:00:00	ES	Futures	1026.1	1032.95	1025.86	1032.21	352208.0
2010-05-25 12:00:00	ES	Futures	1032.21	1035.15	1027.57	1030.5	247627.0
2010-05-25 13:00:00	ES	Futures	1030.5	1031.48	1025.61	1027.57	190372.0
2010-05-25 14:00:00	ES	Futures	1027.81	1040.03	1025.86	1037.1	330032.0
2010-05-25 15:00:00	ES	Futures	1037.1	1049.81	1036.86	1049.32	560627.0
2010-05-25 16:00:00	ES	Futures	1049.32	1052.74	1048.1	1052.26	138525.0
2010-05-25 17:00:00	ES	Futures	1052.5	1060.32	1052.5	1059.34	15179.0
2010-05-25 18:00:00	ES	Futures	1059.34	1059.34	1054.45	1055.68	12375.0
2010-05-25 19:00:00	ES	Futures	1055.92	1058.37	1055.19	1057.88	11163.0
2010-05-25 20:00:00	ES	Futures	1057.88	1059.1	1055.68	1055.92	14716.0
2010-05-25 21:00:00	ES	Futures	1055.68	1055.68	1049.08	1049.81	19010.0
2010-05-25 22:00:00	ES	Futures	1049.81	1052.26	1047.86	1051.77	11117.0
2010-05-25 23:00:00	ES	Futures	1051.52	1054.7	1049.32	1053.97	9847.0
2010-05-25 00:00:00	NQ	Futures	2044.99	2048.71	2044.13	2045.85	981.0
2010-05-25 01:00:00	NQ	Futures	2045.56	2047.56	2041.84	2043.84	755.0
2010-05-25 02:00:00	NQ	Futures	2043.27	2048.42	2022.94	2031.24	6050.0
2010-05-25 03:00:00	NQ	Futures	2031.24	2038.11	2026.37	2035.54	7304.0
2010-05-25 04:00:00	NQ	Futures	2035.54	2037.83	2026.95	2029.81	3311.0
2010-05-25 05:00:00	NQ	Futures	2030.1	2032.39	2026.09	2026.09	2521.0
2010-05-25 06:00:00	NQ	Futures	2026.09	2036.68	2017.21	2036.11	4487.0
2010-05-25 07:00:00	NQ	Futures	2035.82	2036.4	2024.37	2034.68	3824.0
2010-05-25 08:00:00	NQ	Futures	2034.68	2039.55	2027.8	2028.95	10073.0
2010-05-25 09:00:00	NQ	Futures	2029.52	2032.67	2009.48	2024.94	70421.0
2010-05-25 10:00:00	NQ	Futures	2025.8	2042.12	2022.08	2033.53	68249.0
2010-05-25 11:00:00	NQ	Futures	2033.53	2047.85	2032.1	2046.42	38511.0
2010-05-25 12:00:00	NQ	Futures	2046.99	2054.44	2038.11	2044.99	30678.0
2010-05-25 13:00:00	NQ	Futures	2044.99	2045.85	2034.39	2037.54	26316.0
2010-05-25 14:00:00	NQ	Futures	2037.54	2064.17	2034.1	2057.59	41153.0
2010-05-25 15:00:00	NQ	Futures	2057.59	2081.64	2057.01	2078.78	86149.0
2010-05-25 16:00:00	NQ	Futures	2078.78	2087.66	2075.06	2086.8	17329.0
2010-05-25 17:00:00	NQ	Futures	2086.8	2101.12	2086.22	2099.11	1560.0
2010-05-25 18:00:00	NQ	Futures	2099.11	2099.11	2091.09	2095.1	775.0
2010-05-25 19:00:00	NQ	Futures	2094.53	2099.11	2093.96	2098.82	432.0
2010-05-25 20:00:00	NQ	Futures	2098.25	2099.97	2093.1	2093.96	780.0
2010-05-25 21:00:00	NQ	Futures	2093.38	2093.38	2081.07	2082.5	1479.0
2010-05-25 22:00:00	NQ	Futures	2082.22	2087.08	2078.21	2086.22	919.0
2010-05-25 23:00:00	NQ	Futures	2085.94	2091.38	2080.78	2090.81	744.0
2010-05-25 00:00:00	YM	Futures	9311.9	9331.7	9309.1	9315.7	809.0
2010-05-25 01:00:00	YM	Futures	9316.6	9323.2	9300.6	9311.0	1011.0

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

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