PREVIEW / futures_1hour / 2010-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-25.parquet
  size:    46 KB
  rows:    1,374

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-08-25 00:00:00	ES	Futures	1033.54	1033.78	1030.84	1032.07	5186.0
2010-08-25 01:00:00	ES	Futures	1032.31	1032.31	1028.14	1028.88	9238.0
2010-08-25 02:00:00	ES	Futures	1028.88	1031.82	1028.39	1031.82	11289.0
2010-08-25 03:00:00	ES	Futures	1031.58	1035.5	1029.61	1033.78	34215.0
2010-08-25 04:00:00	ES	Futures	1034.03	1035.99	1031.82	1031.82	31759.0
2010-08-25 05:00:00	ES	Futures	1032.07	1033.29	1029.37	1030.1	19088.0
2010-08-25 06:00:00	ES	Futures	1030.1	1031.08	1028.63	1030.1	17651.0
2010-08-25 07:00:00	ES	Futures	1030.1	1030.35	1026.91	1028.63	31633.0
2010-08-25 08:00:00	ES	Futures	1028.63	1028.88	1021.76	1023.23	111911.0
2010-08-25 09:00:00	ES	Futures	1023.48	1028.14	1020.04	1022.25	316620.0
2010-08-25 10:00:00	ES	Futures	1022.25	1026.67	1017.83	1025.93	473716.0
2010-08-25 11:00:00	ES	Futures	1026.18	1029.37	1023.97	1027.65	308306.0
2010-08-25 12:00:00	ES	Futures	1027.65	1028.88	1024.21	1024.95	152629.0
2010-08-25 13:00:00	ES	Futures	1025.2	1029.37	1024.46	1028.14	125471.0
2010-08-25 14:00:00	ES	Futures	1028.14	1035.01	1027.89	1034.52	298261.0
2010-08-25 15:00:00	ES	Futures	1034.77	1038.2	1031.08	1034.27	377743.0
2010-08-25 16:00:00	ES	Futures	1034.27	1036.73	1032.8	1035.75	104064.0
2010-08-25 17:00:00	ES	Futures	1035.75	1035.99	1035.26	1035.5	1562.0
2010-08-25 18:00:00	ES	Futures	1035.26	1035.5	1034.77	1035.26	1820.0
2010-08-25 19:00:00	ES	Futures	1035.26	1036.97	1035.26	1036.73	3720.0
2010-08-25 20:00:00	ES	Futures	1036.97	1036.97	1034.03	1035.01	8359.0
2010-08-25 21:00:00	ES	Futures	1035.01	1035.99	1034.77	1035.99	4281.0
2010-08-25 22:00:00	ES	Futures	1035.99	1036.97	1035.75	1036.73	4827.0
2010-08-25 23:00:00	ES	Futures	1036.97	1037.71	1035.99	1037.22	3334.0
2010-08-25 00:00:00	NQ	Futures	2037.48	2038.92	2032.9	2035.77	158.0
2010-08-25 01:00:00	NQ	Futures	2035.77	2036.05	2028.31	2029.46	546.0
2010-08-25 02:00:00	NQ	Futures	2029.17	2034.33	2028.31	2034.05	743.0
2010-08-25 03:00:00	NQ	Futures	2034.05	2040.92	2030.61	2038.92	2007.0
2010-08-25 04:00:00	NQ	Futures	2038.63	2042.07	2034.05	2035.19	1793.0
2010-08-25 05:00:00	NQ	Futures	2034.91	2038.34	2029.46	2030.61	2686.0
2010-08-25 06:00:00	NQ	Futures	2030.89	2031.47	2027.17	2029.75	2892.0
2010-08-25 07:00:00	NQ	Futures	2030.03	2030.32	2024.3	2027.17	1729.0
2010-08-25 08:00:00	NQ	Futures	2027.45	2027.74	2014.56	2016.28	10916.0
2010-08-25 09:00:00	NQ	Futures	2016.28	2031.47	2013.7	2023.16	53619.0
2010-08-25 10:00:00	NQ	Futures	2023.16	2034.05	2015.71	2032.61	66174.0
2010-08-25 11:00:00	NQ	Futures	2032.61	2040.64	2027.45	2037.2	52164.0
2010-08-25 12:00:00	NQ	Futures	2036.91	2040.06	2030.03	2032.61	24217.0
2010-08-25 13:00:00	NQ	Futures	2032.33	2039.49	2030.89	2036.62	21532.0
2010-08-25 14:00:00	NQ	Futures	2036.62	2052.96	2036.34	2051.81	48042.0
2010-08-25 15:00:00	NQ	Futures	2051.81	2061.56	2046.37	2052.39	51612.0
2010-08-25 16:00:00	NQ	Futures	2052.39	2054.96	2047.51	2052.67	11682.0
2010-08-25 17:00:00	NQ	Futures	2052.96	2053.25	2052.39	2052.96	188.0
2010-08-25 18:00:00	NQ	Futures	2052.39	2052.96	2051.53	2052.96	177.0
2010-08-25 19:00:00	NQ	Futures	2052.96	2055.54	2052.96	2054.68	280.0
2010-08-25 20:00:00	NQ	Futures	2054.96	2055.25	2050.38	2051.81	293.0
2010-08-25 21:00:00	NQ	Futures	2052.1	2054.11	2052.1	2054.11	155.0
2010-08-25 22:00:00	NQ	Futures	2053.82	2055.54	2053.25	2055.25	159.0
2010-08-25 23:00:00	NQ	Futures	2054.96	2056.97	2053.82	2055.82	182.0
2010-08-25 00:00:00	YM	Futures	9509.6	9514.3	9489.7	9502.0	219.0
2010-08-25 01:00:00	YM	Futures	9501.1	9502.0	9470.8	9474.6	482.0

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

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