PREVIEW / futures_1hour / 2012-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-20.parquet
  size:    40 KB
  rows:    1,184

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-01-20 00:00:00	ES	Futures	1318.91	1320.92	1318.65	1320.92	4466.0
2012-01-20 01:00:00	ES	Futures	1320.92	1321.93	1320.17	1320.67	3315.0
2012-01-20 02:00:00	ES	Futures	1320.67	1321.68	1319.66	1320.42	4912.0
2012-01-20 03:00:00	ES	Futures	1320.67	1321.17	1316.39	1316.64	30950.0
2012-01-20 04:00:00	ES	Futures	1316.89	1318.65	1315.63	1316.39	29621.0
2012-01-20 05:00:00	ES	Futures	1316.39	1319.91	1315.63	1317.65	24776.0
2012-01-20 06:00:00	ES	Futures	1317.65	1318.91	1316.64	1317.39	26003.0
2012-01-20 07:00:00	ES	Futures	1317.39	1320.17	1316.64	1318.4	32796.0
2012-01-20 08:00:00	ES	Futures	1318.65	1318.65	1316.39	1317.65	45833.0
2012-01-20 09:00:00	ES	Futures	1317.65	1319.91	1316.64	1318.65	224728.0
2012-01-20 10:00:00	ES	Futures	1318.91	1319.41	1315.88	1316.89	228161.0
2012-01-20 11:00:00	ES	Futures	1317.14	1317.65	1315.13	1316.89	190831.0
2012-01-20 12:00:00	ES	Futures	1316.89	1319.16	1316.39	1318.15	107382.0
2012-01-20 13:00:00	ES	Futures	1318.4	1320.17	1317.9	1318.4	95061.0
2012-01-20 14:00:00	ES	Futures	1318.4	1318.91	1316.13	1317.9	73743.0
2012-01-20 15:00:00	ES	Futures	1317.65	1321.68	1317.65	1321.43	178098.0
2012-01-20 16:00:00	ES	Futures	1321.43	1322.18	1320.67	1321.68	75161.0
2012-01-20 00:00:00	NQ	Futures	2803.37	2808.56	2803.37	2807.99	481.0
2012-01-20 01:00:00	NQ	Futures	2808.28	2810.01	2807.41	2807.99	409.0
2012-01-20 02:00:00	NQ	Futures	2808.28	2810.01	2805.96	2807.99	485.0
2012-01-20 03:00:00	NQ	Futures	2808.28	2810.87	2800.77	2801.06	2574.0
2012-01-20 04:00:00	NQ	Futures	2801.06	2805.39	2799.61	2800.77	2173.0
2012-01-20 05:00:00	NQ	Futures	2800.77	2808.56	2798.74	2803.94	1808.0
2012-01-20 06:00:00	NQ	Futures	2804.23	2807.41	2803.08	2803.65	1868.0
2012-01-20 07:00:00	NQ	Futures	2803.65	2809.72	2802.5	2805.68	2826.0
2012-01-20 08:00:00	NQ	Futures	2805.96	2805.96	2799.61	2801.06	4907.0
2012-01-20 09:00:00	NQ	Futures	2801.06	2808.56	2799.61	2804.52	32514.0
2012-01-20 10:00:00	NQ	Futures	2805.1	2812.32	2802.5	2807.12	25935.0
2012-01-20 11:00:00	NQ	Futures	2807.41	2808.56	2802.5	2806.54	15119.0
2012-01-20 12:00:00	NQ	Futures	2806.54	2809.43	2805.39	2808.85	8412.0
2012-01-20 13:00:00	NQ	Futures	2808.56	2813.18	2808.56	2808.56	10697.0
2012-01-20 14:00:00	NQ	Futures	2808.85	2810.3	2802.5	2806.25	11875.0
2012-01-20 15:00:00	NQ	Futures	2806.25	2812.61	2804.23	2812.61	21718.0
2012-01-20 16:00:00	NQ	Futures	2812.61	2815.21	2812.03	2813.76	5353.0
2012-01-20 00:00:00	YM	Futures	12464.5	12483.3	12464.5	12480.4	301.0
2012-01-20 01:00:00	YM	Futures	12481.4	12491.3	12478.4	12481.4	385.0
2012-01-20 02:00:00	YM	Futures	12480.4	12491.3	12473.4	12482.4	545.0
2012-01-20 03:00:00	YM	Futures	12482.4	12487.3	12452.6	12453.6	2323.0
2012-01-20 04:00:00	YM	Futures	12454.6	12469.5	12442.7	12448.7	1540.0
2012-01-20 05:00:00	YM	Futures	12449.7	12478.4	12441.7	12460.6	1831.0
2012-01-20 06:00:00	YM	Futures	12458.6	12471.5	12452.6	12457.6	1193.0
2012-01-20 07:00:00	YM	Futures	12457.6	12479.4	12451.6	12467.5	1309.0
2012-01-20 08:00:00	YM	Futures	12466.5	12468.5	12447.7	12456.6	2621.0
2012-01-20 09:00:00	YM	Futures	12456.6	12502.2	12451.6	12495.2	13313.0
2012-01-20 10:00:00	YM	Futures	12494.3	12525.0	12480.4	12511.1	14490.0
2012-01-20 11:00:00	YM	Futures	12512.1	12516.1	12492.3	12509.1	6781.0
2012-01-20 12:00:00	YM	Futures	12508.1	12524.0	12505.2	12517.0	4621.0
2012-01-20 13:00:00	YM	Futures	12517.0	12531.9	12515.1	12519.0	5288.0
2012-01-20 14:00:00	YM	Futures	12519.0	12523.0	12504.2	12522.0	4534.0
2012-01-20 15:00:00	YM	Futures	12522.0	12555.7	12521.0	12555.7	8333.0

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

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