PREVIEW / futures_1hour / 2011-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-26.parquet
  size:    47 KB
  rows:    1,450

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
2011-07-26 00:00:00	ES	Futures	1332.32	1333.32	1332.07	1332.82	2176.0
2011-07-26 01:00:00	ES	Futures	1332.82	1333.82	1332.07	1332.32	5619.0
2011-07-26 02:00:00	ES	Futures	1332.32	1335.57	1331.83	1334.82	15819.0
2011-07-26 03:00:00	ES	Futures	1335.07	1336.56	1332.82	1333.57	38480.0
2011-07-26 04:00:00	ES	Futures	1333.32	1334.82	1331.58	1332.07	19867.0
2011-07-26 05:00:00	ES	Futures	1332.07	1332.07	1328.08	1330.08	29459.0
2011-07-26 06:00:00	ES	Futures	1329.83	1333.07	1329.58	1332.57	23961.0
2011-07-26 07:00:00	ES	Futures	1332.82	1334.32	1332.07	1332.57	24385.0
2011-07-26 08:00:00	ES	Futures	1332.57	1334.07	1331.58	1331.83	28938.0
2011-07-26 09:00:00	ES	Futures	1331.83	1331.83	1323.1	1324.09	286751.0
2011-07-26 10:00:00	ES	Futures	1324.59	1328.08	1322.35	1327.09	333238.0
2011-07-26 11:00:00	ES	Futures	1327.09	1329.58	1326.34	1327.34	204825.0
2011-07-26 12:00:00	ES	Futures	1327.59	1329.58	1326.84	1328.08	76152.0
2011-07-26 13:00:00	ES	Futures	1328.33	1328.83	1325.84	1327.84	70627.0
2011-07-26 14:00:00	ES	Futures	1327.84	1331.83	1327.09	1328.58	148689.0
2011-07-26 15:00:00	ES	Futures	1328.58	1329.33	1323.1	1325.34	234973.0
2011-07-26 16:00:00	ES	Futures	1325.34	1326.09	1322.35	1322.85	93158.0
2011-07-26 17:00:00	ES	Futures	1322.85	1323.6	1322.6	1322.85	2484.0
2011-07-26 18:00:00	ES	Futures	1322.35	1323.6	1321.85	1323.6	3799.0
2011-07-26 19:00:00	ES	Futures	1323.6	1323.84	1322.85	1323.1	3782.0
2011-07-26 20:00:00	ES	Futures	1323.1	1323.6	1321.6	1323.35	6644.0
2011-07-26 21:00:00	ES	Futures	1323.35	1324.59	1322.85	1323.84	5986.0
2011-07-26 22:00:00	ES	Futures	1324.09	1324.84	1323.6	1324.59	2584.0
2011-07-26 23:00:00	ES	Futures	1324.59	1325.34	1324.34	1324.84	2271.0
2011-07-26 00:00:00	NQ	Futures	2794.2	2796.5	2794.2	2796.22	124.0
2011-07-26 01:00:00	NQ	Futures	2796.22	2797.37	2794.49	2794.78	323.0
2011-07-26 02:00:00	NQ	Futures	2795.06	2800.53	2793.34	2798.23	918.0
2011-07-26 03:00:00	NQ	Futures	2798.23	2801.68	2795.64	2796.79	3135.0
2011-07-26 04:00:00	NQ	Futures	2797.08	2799.67	2793.34	2794.2	2016.0
2011-07-26 05:00:00	NQ	Futures	2793.91	2794.2	2786.72	2789.88	2351.0
2011-07-26 06:00:00	NQ	Futures	2790.17	2794.2	2789.31	2793.63	1935.0
2011-07-26 07:00:00	NQ	Futures	2793.63	2796.79	2791.04	2792.76	4221.0
2011-07-26 08:00:00	NQ	Futures	2792.76	2796.22	2790.75	2791.32	3474.0
2011-07-26 09:00:00	NQ	Futures	2791.32	2798.52	2781.54	2785.86	39173.0
2011-07-26 10:00:00	NQ	Futures	2784.7	2793.34	2779.24	2791.04	39964.0
2011-07-26 11:00:00	NQ	Futures	2791.04	2796.79	2790.75	2793.34	15712.0
2011-07-26 12:00:00	NQ	Futures	2793.34	2797.94	2791.32	2796.5	10207.0
2011-07-26 13:00:00	NQ	Futures	2796.5	2798.23	2791.04	2795.06	9099.0
2011-07-26 14:00:00	NQ	Futures	2795.35	2803.41	2793.63	2797.65	16349.0
2011-07-26 15:00:00	NQ	Futures	2797.65	2799.96	2789.31	2793.05	22499.0
2011-07-26 16:00:00	NQ	Futures	2793.05	2793.63	2782.98	2789.02	9992.0
2011-07-26 17:00:00	NQ	Futures	2789.02	2789.6	2786.14	2786.43	771.0
2011-07-26 18:00:00	NQ	Futures	2785.86	2787.01	2783.84	2787.01	355.0
2011-07-26 19:00:00	NQ	Futures	2787.29	2788.45	2785.28	2787.29	370.0
2011-07-26 20:00:00	NQ	Futures	2787.01	2787.58	2783.84	2787.01	491.0
2011-07-26 21:00:00	NQ	Futures	2787.01	2790.75	2787.01	2789.31	512.0
2011-07-26 22:00:00	NQ	Futures	2789.31	2790.75	2788.45	2790.46	132.0
2011-07-26 23:00:00	NQ	Futures	2790.46	2791.9	2790.46	2791.32	150.0
2011-07-26 00:00:00	YM	Futures	12174.7	12181.5	12171.8	12178.6	264.0
2011-07-26 01:00:00	YM	Futures	12178.6	12182.5	12173.7	12177.6	288.0

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

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