PREVIEW / futures_1hour / 2012-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-22.parquet
  size:    31 KB
  rows:    957

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
2012-11-22 00:00:00	ES	Futures	1420.63	1421.4	1420.38	1421.14	2866.0
2012-11-22 01:00:00	ES	Futures	1420.89	1422.42	1420.63	1421.91	1605.0
2012-11-22 02:00:00	ES	Futures	1421.91	1422.68	1420.89	1421.14	5576.0
2012-11-22 03:00:00	ES	Futures	1421.14	1423.19	1420.63	1422.68	20149.0
2012-11-22 04:00:00	ES	Futures	1422.93	1423.44	1421.14	1422.17	11751.0
2012-11-22 05:00:00	ES	Futures	1422.42	1423.44	1422.17	1423.19	6827.0
2012-11-22 06:00:00	ES	Futures	1422.93	1423.44	1421.66	1423.19	7105.0
2012-11-22 07:00:00	ES	Futures	1422.93	1424.21	1422.93	1423.95	8622.0
2012-11-22 08:00:00	ES	Futures	1423.95	1424.21	1422.93	1423.44	3425.0
2012-11-22 09:00:00	ES	Futures	1423.19	1423.44	1420.89	1423.44	11013.0
2012-11-22 10:00:00	ES	Futures	1423.44	1423.44	1421.66	1422.17	6121.0
2012-11-22 11:00:00	ES	Futures	1422.17	1422.68	1421.4	1421.91	4896.0
2012-11-22 18:00:00	ES	Futures	1422.17	1422.68	1421.66	1422.17	1010.0
2012-11-22 19:00:00	ES	Futures	1421.91	1422.42	1420.63	1421.91	1562.0
2012-11-22 20:00:00	ES	Futures	1421.66	1422.42	1421.4	1422.17	988.0
2012-11-22 21:00:00	ES	Futures	1422.17	1422.42	1421.66	1421.91	1073.0
2012-11-22 22:00:00	ES	Futures	1421.91	1422.17	1421.4	1421.4	535.0
2012-11-22 23:00:00	ES	Futures	1421.66	1422.42	1421.14	1421.14	1161.0
2012-11-22 00:00:00	NQ	Futures	3024.9	3025.19	3023.16	3023.74	315.0
2012-11-22 01:00:00	NQ	Futures	3023.16	3024.03	3022.87	3023.74	215.0
2012-11-22 02:00:00	NQ	Futures	3023.74	3026.93	3022.87	3023.45	1063.0
2012-11-22 03:00:00	NQ	Futures	3023.45	3028.39	3022.58	3028.1	2268.0
2012-11-22 04:00:00	NQ	Futures	3028.1	3029.26	3027.22	3027.52	1019.0
2012-11-22 05:00:00	NQ	Futures	3027.52	3028.68	3025.48	3026.06	551.0
2012-11-22 06:00:00	NQ	Futures	3025.77	3027.52	3023.16	3026.64	606.0
2012-11-22 07:00:00	NQ	Futures	3026.64	3028.68	3026.06	3028.39	588.0
2012-11-22 08:00:00	NQ	Futures	3028.1	3028.97	3025.19	3025.48	579.0
2012-11-22 09:00:00	NQ	Futures	3025.48	3025.77	3018.51	3024.61	1997.0
2012-11-22 10:00:00	NQ	Futures	3024.9	3024.9	3022.58	3023.74	778.0
2012-11-22 11:00:00	NQ	Futures	3023.74	3024.03	3021.99	3021.99	455.0
2012-11-22 18:00:00	NQ	Futures	3022.87	3024.61	3021.99	3023.74	99.0
2012-11-22 19:00:00	NQ	Futures	3023.74	3024.9	3021.99	3023.74	177.0
2012-11-22 20:00:00	NQ	Futures	3024.03	3024.32	3023.16	3024.03	78.0
2012-11-22 21:00:00	NQ	Futures	3024.03	3024.32	3022.28	3023.16	90.0
2012-11-22 22:00:00	NQ	Futures	3023.16	3023.45	3022.87	3023.16	36.0
2012-11-22 23:00:00	NQ	Futures	3023.16	3025.48	3022.87	3024.61	128.0
2012-11-22 00:00:00	YM	Futures	12820.6	12824.6	12818.6	12824.6	278.0
2012-11-22 01:00:00	YM	Futures	12822.6	12830.6	12822.6	12829.6	269.0
2012-11-22 02:00:00	YM	Futures	12829.6	12839.6	12826.6	12828.6	717.0
2012-11-22 03:00:00	YM	Futures	12828.6	12842.6	12819.6	12839.6	1530.0
2012-11-22 04:00:00	YM	Futures	12838.6	12842.6	12826.6	12833.6	712.0
2012-11-22 05:00:00	YM	Futures	12834.6	12839.6	12833.6	12837.6	338.0
2012-11-22 06:00:00	YM	Futures	12836.6	12841.6	12828.6	12838.6	407.0
2012-11-22 07:00:00	YM	Futures	12839.6	12848.6	12837.6	12845.6	603.0
2012-11-22 08:00:00	YM	Futures	12846.6	12848.6	12839.6	12840.6	347.0
2012-11-22 09:00:00	YM	Futures	12842.6	12850.6	12830.6	12846.6	844.0
2012-11-22 10:00:00	YM	Futures	12847.6	12847.6	12839.6	12842.6	442.0
2012-11-22 11:00:00	YM	Futures	12842.6	12845.6	12838.6	12840.6	191.0
2012-11-22 18:00:00	YM	Futures	12840.6	12840.6	12833.6	12837.6	102.0
2012-11-22 19:00:00	YM	Futures	12837.6	12841.6	12829.6	12838.6	198.0

> showing 50 of 957 rows — these rows as CSV

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