PREVIEW / futures_1hour / 2009-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-31.parquet
  size:    36 KB
  rows:    1,004

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-07-31 00:00:00	ES	Futures	950.92	951.4	950.43	951.16	2702.0
2009-07-31 01:00:00	ES	Futures	951.16	951.88	950.43	951.64	2919.0
2009-07-31 02:00:00	ES	Futures	951.88	952.36	950.43	950.92	6322.0
2009-07-31 03:00:00	ES	Futures	950.92	953.57	950.43	952.36	19723.0
2009-07-31 04:00:00	ES	Futures	952.12	952.12	948.75	948.99	10823.0
2009-07-31 05:00:00	ES	Futures	948.99	949.95	948.26	949.71	8697.0
2009-07-31 06:00:00	ES	Futures	949.71	951.88	949.23	950.92	7491.0
2009-07-31 07:00:00	ES	Futures	951.16	952.12	950.19	950.92	12394.0
2009-07-31 08:00:00	ES	Futures	951.16	955.5	943.68	944.41	135142.0
2009-07-31 09:00:00	ES	Futures	944.41	955.02	943.92	949.95	320692.0
2009-07-31 10:00:00	ES	Futures	950.19	953.57	944.89	951.88	410920.0
2009-07-31 11:00:00	ES	Futures	951.88	952.61	948.02	951.16	213447.0
2009-07-31 12:00:00	ES	Futures	951.4	951.88	948.51	949.71	98537.0
2009-07-31 13:00:00	ES	Futures	949.95	952.61	948.75	951.88	81186.0
2009-07-31 14:00:00	ES	Futures	951.88	954.53	949.71	950.92	171814.0
2009-07-31 15:00:00	ES	Futures	950.92	955.5	947.78	948.99	438914.0
2009-07-31 16:00:00	ES	Futures	948.99	950.19	946.82	947.3	116410.0
2009-07-31 00:00:00	NQ	Futures	1835.6	1836.46	1834.46	1835.89	195.0
2009-07-31 01:00:00	NQ	Futures	1835.89	1836.46	1835.03	1835.89	246.0
2009-07-31 02:00:00	NQ	Futures	1836.46	1837.03	1834.46	1834.46	397.0
2009-07-31 03:00:00	NQ	Futures	1834.46	1839.31	1833.89	1837.31	1303.0
2009-07-31 04:00:00	NQ	Futures	1837.03	1837.03	1832.19	1833.32	988.0
2009-07-31 05:00:00	NQ	Futures	1833.32	1833.61	1830.76	1832.76	928.0
2009-07-31 06:00:00	NQ	Futures	1832.76	1836.17	1831.05	1834.75	919.0
2009-07-31 07:00:00	NQ	Futures	1835.03	1838.17	1833.61	1835.32	1601.0
2009-07-31 08:00:00	NQ	Futures	1835.6	1841.01	1823.36	1824.21	11244.0
2009-07-31 09:00:00	NQ	Futures	1824.5	1844.15	1823.36	1833.61	44995.0
2009-07-31 10:00:00	NQ	Futures	1833.61	1843.58	1826.2	1841.3	54421.0
2009-07-31 11:00:00	NQ	Futures	1841.01	1842.15	1835.89	1838.45	26142.0
2009-07-31 12:00:00	NQ	Futures	1838.74	1839.88	1832.76	1835.03	17936.0
2009-07-31 13:00:00	NQ	Futures	1835.32	1839.59	1833.61	1837.03	12590.0
2009-07-31 14:00:00	NQ	Futures	1837.03	1841.3	1830.19	1831.62	24487.0
2009-07-31 15:00:00	NQ	Futures	1831.62	1839.88	1823.36	1825.35	46330.0
2009-07-31 16:00:00	NQ	Futures	1825.07	1826.2	1821.08	1823.93	10606.0
2009-07-31 00:00:00	YM	Futures	8437.3	8441.0	8431.8	8438.3	97.0
2009-07-31 01:00:00	YM	Futures	8438.3	8441.0	8433.6	8440.1	247.0
2009-07-31 02:00:00	YM	Futures	8439.2	8447.5	8437.3	8438.3	628.0
2009-07-31 03:00:00	YM	Futures	8439.2	8461.4	8436.4	8452.1	1361.0
2009-07-31 04:00:00	YM	Futures	8452.1	8452.1	8427.2	8430.9	797.0
2009-07-31 05:00:00	YM	Futures	8431.8	8432.7	8420.7	8432.7	443.0
2009-07-31 06:00:00	YM	Futures	8435.5	8449.3	8429.9	8442.0	534.0
2009-07-31 07:00:00	YM	Futures	8442.9	8451.2	8434.6	8443.8	792.0
2009-07-31 08:00:00	YM	Futures	8444.7	8505.8	8387.4	8392.0	6751.0
2009-07-31 09:00:00	YM	Futures	8392.0	8481.7	8388.3	8445.6	21652.0
2009-07-31 10:00:00	YM	Futures	8445.6	8477.1	8405.0	8457.7	28346.0
2009-07-31 11:00:00	YM	Futures	8456.7	8463.2	8429.9	8452.1	16216.0
2009-07-31 12:00:00	YM	Futures	8453.0	8456.7	8427.2	8437.3	9074.0
2009-07-31 13:00:00	YM	Futures	8438.3	8459.5	8429.0	8454.0	5969.0
2009-07-31 14:00:00	YM	Futures	8454.0	8475.2	8433.6	8442.0	14473.0
2009-07-31 15:00:00	YM	Futures	8441.0	8485.4	8420.7	8431.8	22538.0

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

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