PREVIEW / futures_1hour / 2009-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-01.parquet
  size:    32 KB
  rows:    864

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-05-01 00:00:00	ES	Futures	833.21	833.21	831.05	831.77	1517.0
2009-05-01 01:00:00	ES	Futures	831.53	833.69	831.29	833.45	2132.0
2009-05-01 02:00:00	ES	Futures	833.45	833.69	832.97	833.45	1465.0
2009-05-01 03:00:00	ES	Futures	833.69	837.28	833.45	836.8	9430.0
2009-05-01 04:00:00	ES	Futures	837.04	837.28	836.08	837.04	2999.0
2009-05-01 05:00:00	ES	Futures	837.28	837.52	835.84	836.56	2582.0
2009-05-01 06:00:00	ES	Futures	836.56	837.76	836.08	837.52	5556.0
2009-05-01 07:00:00	ES	Futures	837.52	838.72	837.04	837.52	8942.0
2009-05-01 08:00:00	ES	Futures	837.52	838.0	835.84	836.8	18014.0
2009-05-01 09:00:00	ES	Futures	836.56	836.8	828.89	832.97	220682.0
2009-05-01 10:00:00	ES	Futures	832.73	834.17	826.74	831.05	309929.0
2009-05-01 11:00:00	ES	Futures	831.05	836.56	830.57	832.97	229081.0
2009-05-01 12:00:00	ES	Futures	832.97	836.32	831.77	835.12	160778.0
2009-05-01 13:00:00	ES	Futures	835.12	841.11	834.17	838.24	187297.0
2009-05-01 14:00:00	ES	Futures	838.24	839.92	835.36	836.08	139585.0
2009-05-01 15:00:00	ES	Futures	835.84	838.24	830.81	838.0	327690.0
2009-05-01 16:00:00	ES	Futures	837.76	841.83	837.52	840.16	143742.0
2009-05-01 00:00:00	NQ	Futures	1582.94	1582.94	1580.39	1580.39	91.0
2009-05-01 01:00:00	NQ	Futures	1580.95	1585.22	1580.39	1584.36	75.0
2009-05-01 02:00:00	NQ	Futures	1584.36	1585.5	1583.51	1584.65	93.0
2009-05-01 03:00:00	NQ	Futures	1584.65	1590.61	1584.36	1590.05	433.0
2009-05-01 04:00:00	NQ	Futures	1590.33	1592.32	1588.91	1589.76	410.0
2009-05-01 05:00:00	NQ	Futures	1590.05	1590.33	1588.06	1590.05	126.0
2009-05-01 06:00:00	NQ	Futures	1589.19	1591.47	1588.91	1590.9	860.0
2009-05-01 07:00:00	NQ	Futures	1591.47	1592.32	1588.91	1589.48	771.0
2009-05-01 08:00:00	NQ	Futures	1589.48	1590.33	1584.65	1585.5	2740.0
2009-05-01 09:00:00	NQ	Futures	1585.22	1585.5	1573.0	1578.97	29423.0
2009-05-01 10:00:00	NQ	Futures	1578.97	1582.09	1569.59	1577.26	36514.0
2009-05-01 11:00:00	NQ	Futures	1577.26	1584.65	1575.84	1576.98	26444.0
2009-05-01 12:00:00	NQ	Futures	1577.26	1586.64	1575.56	1585.22	19879.0
2009-05-01 13:00:00	NQ	Futures	1585.22	1594.31	1583.23	1589.19	25197.0
2009-05-01 14:00:00	NQ	Futures	1589.76	1591.47	1582.09	1582.66	21478.0
2009-05-01 15:00:00	NQ	Futures	1582.94	1586.64	1574.7	1585.78	46910.0
2009-05-01 16:00:00	NQ	Futures	1585.78	1593.46	1585.5	1589.76	17098.0
2009-05-01 00:00:00	YM	Futures	7464.6	7464.6	7448.1	7448.1	112.0
2009-05-01 01:00:00	YM	Futures	7449.0	7467.4	7448.1	7467.4	98.0
2009-05-01 02:00:00	YM	Futures	7466.5	7470.1	7465.5	7469.2	148.0
2009-05-01 03:00:00	YM	Futures	7469.2	7495.9	7469.2	7493.1	444.0
2009-05-01 04:00:00	YM	Futures	7494.9	7496.8	7490.4	7493.1	356.0
2009-05-01 05:00:00	YM	Futures	7493.1	7496.8	7483.9	7491.3	181.0
2009-05-01 06:00:00	YM	Futures	7487.6	7503.2	7487.6	7500.5	274.0
2009-05-01 07:00:00	YM	Futures	7502.3	7506.0	7494.0	7498.6	386.0
2009-05-01 08:00:00	YM	Futures	7495.9	7500.5	7482.1	7489.4	948.0
2009-05-01 09:00:00	YM	Futures	7489.4	7490.4	7418.7	7450.8	14078.0
2009-05-01 10:00:00	YM	Futures	7450.8	7460.9	7394.8	7438.0	25710.0
2009-05-01 11:00:00	YM	Futures	7437.1	7483.9	7435.2	7452.7	16393.0
2009-05-01 12:00:00	YM	Futures	7452.7	7469.2	7438.9	7458.2	11109.0
2009-05-01 13:00:00	YM	Futures	7458.2	7507.8	7451.8	7485.8	12576.0
2009-05-01 14:00:00	YM	Futures	7484.8	7499.5	7463.7	7468.3	10765.0
2009-05-01 15:00:00	YM	Futures	7469.2	7501.4	7426.9	7501.4	21152.0

> showing 50 of 864 rows — these rows as CSV

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