PREVIEW / futures_1hour / 2010-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-09.parquet
  size:    46 KB
  rows:    1,348

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-06-09 00:00:00	ES	Futures	1032.21	1033.19	1030.75	1032.7	5021.0
2010-06-09 01:00:00	ES	Futures	1032.7	1033.92	1030.5	1033.68	5992.0
2010-06-09 02:00:00	ES	Futures	1033.43	1038.57	1032.95	1037.1	19221.0
2010-06-09 03:00:00	ES	Futures	1037.1	1040.03	1035.39	1037.1	31534.0
2010-06-09 04:00:00	ES	Futures	1036.86	1037.35	1032.46	1033.68	36833.0
2010-06-09 05:00:00	ES	Futures	1033.43	1035.15	1030.01	1033.19	30562.0
2010-06-09 06:00:00	ES	Futures	1033.19	1038.08	1032.46	1036.86	26609.0
2010-06-09 07:00:00	ES	Futures	1036.86	1042.23	1036.37	1041.74	49759.0
2010-06-09 08:00:00	ES	Futures	1041.99	1043.7	1041.26	1041.99	72432.0
2010-06-09 09:00:00	ES	Futures	1041.99	1045.17	1040.52	1042.97	331268.0
2010-06-09 10:00:00	ES	Futures	1042.72	1046.39	1039.3	1046.14	349831.0
2010-06-09 11:00:00	ES	Futures	1046.14	1053.72	1045.41	1050.79	373083.0
2010-06-09 12:00:00	ES	Futures	1050.79	1052.26	1048.59	1048.59	126922.0
2010-06-09 13:00:00	ES	Futures	1048.83	1050.06	1044.92	1047.12	178365.0
2010-06-09 14:00:00	ES	Futures	1047.12	1048.1	1037.35	1037.83	311477.0
2010-06-09 15:00:00	ES	Futures	1037.59	1039.79	1027.81	1031.23	593977.0
2010-06-09 16:00:00	ES	Futures	1031.23	1032.95	1030.5	1030.99	99430.0
2010-06-09 17:00:00	ES	Futures	1030.99	1031.23	1029.52	1029.52	3030.0
2010-06-09 18:00:00	ES	Futures	1029.03	1031.72	1028.79	1030.75	6511.0
2010-06-09 19:00:00	ES	Futures	1030.75	1031.97	1029.03	1031.72	4919.0
2010-06-09 20:00:00	ES	Futures	1031.72	1032.21	1029.03	1029.77	6133.0
2010-06-09 21:00:00	ES	Futures	1029.77	1033.68	1029.52	1033.43	7194.0
2010-06-09 22:00:00	ES	Futures	1033.19	1034.66	1030.99	1031.72	5839.0
2010-06-09 23:00:00	ES	Futures	1031.97	1036.12	1030.75	1034.9	7851.0
2010-06-09 00:00:00	NQ	Futures	2046.7	2049.28	2043.84	2048.42	260.0
2010-06-09 01:00:00	NQ	Futures	2048.42	2049.57	2044.13	2049.0	347.0
2010-06-09 02:00:00	NQ	Futures	2049.0	2057.59	2047.56	2054.15	1424.0
2010-06-09 03:00:00	NQ	Futures	2054.44	2058.73	2051.0	2053.58	2635.0
2010-06-09 04:00:00	NQ	Futures	2053.58	2055.01	2046.13	2047.85	3145.0
2010-06-09 05:00:00	NQ	Futures	2047.85	2051.86	2041.55	2048.14	2097.0
2010-06-09 06:00:00	NQ	Futures	2047.85	2055.58	2045.85	2053.86	1962.0
2010-06-09 07:00:00	NQ	Futures	2054.15	2063.89	2053.29	2063.31	3155.0
2010-06-09 08:00:00	NQ	Futures	2063.31	2070.76	2062.46	2066.46	6248.0
2010-06-09 09:00:00	NQ	Futures	2066.75	2072.19	2061.02	2065.32	53939.0
2010-06-09 10:00:00	NQ	Futures	2065.03	2071.91	2054.15	2071.62	46839.0
2010-06-09 11:00:00	NQ	Futures	2071.62	2088.8	2070.47	2081.64	44301.0
2010-06-09 12:00:00	NQ	Futures	2081.64	2087.66	2077.06	2077.35	18403.0
2010-06-09 13:00:00	NQ	Futures	2077.35	2080.5	2069.04	2073.34	25575.0
2010-06-09 14:00:00	NQ	Futures	2073.34	2075.34	2053.01	2053.58	38214.0
2010-06-09 15:00:00	NQ	Futures	2053.58	2058.16	2031.81	2037.54	80075.0
2010-06-09 16:00:00	NQ	Futures	2037.54	2041.55	2037.25	2038.97	8877.0
2010-06-09 17:00:00	NQ	Futures	2038.97	2040.12	2035.82	2036.97	242.0
2010-06-09 18:00:00	NQ	Futures	2035.25	2039.26	2033.53	2038.4	457.0
2010-06-09 19:00:00	NQ	Futures	2037.54	2039.55	2035.25	2038.69	113.0
2010-06-09 20:00:00	NQ	Futures	2038.69	2040.69	2034.68	2036.11	440.0
2010-06-09 21:00:00	NQ	Futures	2036.4	2042.98	2036.11	2042.7	493.0
2010-06-09 22:00:00	NQ	Futures	2042.12	2044.7	2038.4	2039.83	235.0
2010-06-09 23:00:00	NQ	Futures	2040.4	2047.85	2038.69	2046.42	468.0
2010-06-09 00:00:00	YM	Futures	9296.9	9306.3	9289.4	9303.5	393.0
2010-06-09 01:00:00	YM	Futures	9303.5	9316.6	9288.4	9314.8	424.0

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

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