PREVIEW / futures_1hour / 2008-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-19.parquet
  size:    39 KB
  rows:    1,021

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
2008-09-19 00:00:00	ES	Futures	1167.87	1170.47	1167.63	1170.23	7188.0
2008-09-19 01:00:00	ES	Futures	1170.0	1171.18	1168.81	1169.29	10277.0
2008-09-19 02:00:00	ES	Futures	1169.29	1175.68	1165.26	1174.97	46158.0
2008-09-19 03:00:00	ES	Futures	1175.2	1176.39	1166.21	1170.47	79597.0
2008-09-19 04:00:00	ES	Futures	1170.23	1176.15	1166.45	1175.91	40655.0
2008-09-19 05:00:00	ES	Futures	1175.91	1180.41	1173.07	1177.57	52702.0
2008-09-19 06:00:00	ES	Futures	1177.57	1184.43	1176.62	1178.75	58604.0
2008-09-19 07:00:00	ES	Futures	1178.75	1190.58	1175.2	1182.54	100701.0
2008-09-19 08:00:00	ES	Futures	1182.54	1200.29	1181.12	1200.29	169735.0
2008-09-19 09:00:00	ES	Futures	1200.05	1222.3	1183.96	1184.9	639028.0
2008-09-19 10:00:00	ES	Futures	1184.67	1187.74	1171.42	1175.2	617864.0
2008-09-19 11:00:00	ES	Futures	1175.2	1191.29	1175.2	1190.58	383684.0
2008-09-19 12:00:00	ES	Futures	1190.58	1200.05	1189.16	1193.19	257725.0
2008-09-19 13:00:00	ES	Futures	1193.19	1193.9	1184.43	1184.43	206129.0
2008-09-19 14:00:00	ES	Futures	1184.43	1188.45	1181.35	1184.67	262183.0
2008-09-19 15:00:00	ES	Futures	1184.67	1189.16	1171.89	1186.56	592674.0
2008-09-19 16:00:00	ES	Futures	1186.56	1186.8	1176.86	1180.17	179162.0
2008-09-19 00:00:00	NQ	Futures	1979.05	1979.33	1975.93	1977.91	332.0
2008-09-19 01:00:00	NQ	Futures	1977.63	1978.48	1970.27	1970.84	1038.0
2008-09-19 02:00:00	NQ	Futures	1970.27	1979.33	1968.01	1979.05	1709.0
2008-09-19 03:00:00	NQ	Futures	1979.33	1979.61	1964.05	1973.1	3497.0
2008-09-19 04:00:00	NQ	Futures	1973.39	1979.61	1966.03	1979.05	2200.0
2008-09-19 05:00:00	NQ	Futures	1978.76	1983.01	1973.39	1977.91	3604.0
2008-09-19 06:00:00	NQ	Futures	1977.35	1984.14	1975.93	1976.78	1906.0
2008-09-19 07:00:00	NQ	Futures	1977.07	1990.65	1969.43	1986.97	7435.0
2008-09-19 08:00:00	NQ	Futures	1986.4	2018.94	1986.4	2007.06	17745.0
2008-09-19 09:00:00	NQ	Futures	2007.63	2039.03	1970.84	1972.82	96839.0
2008-09-19 10:00:00	NQ	Futures	1972.82	1977.91	1948.2	1959.52	86477.0
2008-09-19 11:00:00	NQ	Futures	1960.09	1991.78	1959.52	1989.52	63443.0
2008-09-19 12:00:00	NQ	Futures	1989.23	1998.57	1984.99	1989.52	49557.0
2008-09-19 13:00:00	NQ	Futures	1989.23	1989.52	1971.97	1973.39	39075.0
2008-09-19 14:00:00	NQ	Futures	1973.1	1976.5	1962.92	1971.69	45437.0
2008-09-19 15:00:00	NQ	Futures	1971.97	1982.16	1955.84	1979.89	83146.0
2008-09-19 16:00:00	NQ	Futures	1979.89	1980.74	1959.24	1968.01	15303.0
2008-09-19 00:00:00	YM	Futures	10175.7	10184.8	10166.6	10182.1	403.0
2008-09-19 01:00:00	YM	Futures	10183.0	10193.0	10173.9	10176.6	319.0
2008-09-19 02:00:00	YM	Futures	10173.0	10221.2	10148.4	10218.4	1734.0
2008-09-19 03:00:00	YM	Futures	10220.3	10227.5	10154.8	10187.5	4890.0
2008-09-19 04:00:00	YM	Futures	10184.8	10230.3	10161.1	10229.4	2465.0
2008-09-19 05:00:00	YM	Futures	10228.4	10253.0	10202.1	10230.3	3643.0
2008-09-19 06:00:00	YM	Futures	10229.4	10278.5	10227.5	10244.8	3336.0
2008-09-19 07:00:00	YM	Futures	10245.7	10323.0	10232.1	10284.8	6369.0
2008-09-19 08:00:00	YM	Futures	10286.7	10383.1	10277.6	10377.6	9656.0
2008-09-19 09:00:00	YM	Futures	10378.5	10560.4	10347.6	10354.9	46555.0
2008-09-19 10:00:00	YM	Futures	10351.2	10384.9	10267.6	10297.6	46160.0
2008-09-19 11:00:00	YM	Futures	10297.6	10395.8	10297.6	10380.3	35108.0
2008-09-19 12:00:00	YM	Futures	10380.3	10439.5	10368.5	10406.7	21459.0
2008-09-19 13:00:00	YM	Futures	10407.6	10419.4	10343.0	10346.7	17575.0
2008-09-19 14:00:00	YM	Futures	10346.7	10365.8	10313.9	10333.0	26192.0
2008-09-19 15:00:00	YM	Futures	10332.1	10364.0	10250.3	10358.5	43438.0

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

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