PREVIEW / futures_1hour / 2009-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-19.parquet
  size:    34 KB
  rows:    930

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-01-19 00:00:00	ES	Futures	814.49	815.21	813.31	814.26	706.0
2009-01-19 01:00:00	ES	Futures	814.49	814.97	813.07	813.55	1192.0
2009-01-19 02:00:00	ES	Futures	813.31	815.44	812.12	814.97	4270.0
2009-01-19 03:00:00	ES	Futures	815.21	816.87	809.51	811.89	15696.0
2009-01-19 04:00:00	ES	Futures	811.89	814.26	808.8	811.17	12031.0
2009-01-19 05:00:00	ES	Futures	811.17	812.83	810.23	811.89	4547.0
2009-01-19 06:00:00	ES	Futures	812.12	813.07	809.99	810.23	5348.0
2009-01-19 07:00:00	ES	Futures	810.23	811.17	805.48	805.96	11588.0
2009-01-19 08:00:00	ES	Futures	805.96	806.19	797.18	801.92	28343.0
2009-01-19 09:00:00	ES	Futures	801.92	802.4	794.33	796.71	17597.0
2009-01-19 10:00:00	ES	Futures	796.47	799.08	791.72	794.81	30599.0
2009-01-19 11:00:00	ES	Futures	794.81	797.42	793.15	796.94	11627.0
2009-01-19 18:00:00	ES	Futures	796.94	800.5	795.52	798.13	4866.0
2009-01-19 19:00:00	ES	Futures	798.13	798.13	789.83	791.25	9227.0
2009-01-19 20:00:00	ES	Futures	791.25	792.91	790.78	792.67	3959.0
2009-01-19 21:00:00	ES	Futures	792.67	794.33	791.49	794.33	2486.0
2009-01-19 22:00:00	ES	Futures	794.33	794.33	792.44	794.1	2233.0
2009-01-19 23:00:00	ES	Futures	793.86	794.81	791.25	791.72	2311.0
2009-01-19 00:00:00	NQ	Futures	1368.98	1369.26	1367.0	1368.98	37.0
2009-01-19 01:00:00	NQ	Futures	1368.42	1369.55	1367.57	1367.85	211.0
2009-01-19 02:00:00	NQ	Futures	1368.42	1368.98	1364.46	1368.98	191.0
2009-01-19 03:00:00	NQ	Futures	1368.98	1371.81	1361.36	1365.31	1036.0
2009-01-19 04:00:00	NQ	Futures	1364.75	1368.42	1359.1	1364.18	555.0
2009-01-19 05:00:00	NQ	Futures	1363.62	1366.16	1361.64	1364.75	153.0
2009-01-19 06:00:00	NQ	Futures	1364.75	1365.59	1360.79	1361.36	424.0
2009-01-19 07:00:00	NQ	Futures	1361.36	1363.33	1355.99	1357.12	769.0
2009-01-19 08:00:00	NQ	Futures	1356.84	1357.12	1343.0	1350.06	2437.0
2009-01-19 09:00:00	NQ	Futures	1350.91	1350.91	1342.16	1344.13	2398.0
2009-01-19 10:00:00	NQ	Futures	1343.85	1348.37	1335.38	1338.77	2347.0
2009-01-19 11:00:00	NQ	Futures	1339.9	1344.98	1337.07	1343.57	836.0
2009-01-19 18:00:00	NQ	Futures	1344.13	1349.78	1342.44	1346.96	290.0
2009-01-19 19:00:00	NQ	Futures	1345.83	1345.83	1333.4	1334.81	410.0
2009-01-19 20:00:00	NQ	Futures	1335.1	1336.79	1334.53	1335.66	194.0
2009-01-19 21:00:00	NQ	Futures	1335.94	1337.35	1334.53	1337.07	131.0
2009-01-19 22:00:00	NQ	Futures	1337.92	1338.48	1336.23	1337.64	107.0
2009-01-19 23:00:00	NQ	Futures	1337.92	1339.05	1333.97	1333.97	291.0
2009-01-19 00:00:00	YM	Futures	7586.4	7590.9	7582.7	7587.3	106.0
2009-01-19 01:00:00	YM	Futures	7589.1	7590.9	7582.7	7587.3	186.0
2009-01-19 02:00:00	YM	Futures	7584.5	7593.6	7570.0	7593.6	412.0
2009-01-19 03:00:00	YM	Futures	7593.6	7603.7	7551.7	7570.9	1118.0
2009-01-19 04:00:00	YM	Futures	7575.4	7589.1	7546.3	7566.3	700.0
2009-01-19 05:00:00	YM	Futures	7567.2	7577.2	7557.2	7567.2	434.0
2009-01-19 06:00:00	YM	Futures	7568.1	7577.2	7552.6	7553.5	322.0
2009-01-19 07:00:00	YM	Futures	7551.7	7561.8	7519.8	7521.7	493.0
2009-01-19 08:00:00	YM	Futures	7518.9	7518.9	7446.9	7481.6	1928.0
2009-01-19 09:00:00	YM	Futures	7485.2	7490.7	7428.7	7436.9	1378.0
2009-01-19 10:00:00	YM	Futures	7437.8	7460.6	7392.3	7418.7	3846.0
2009-01-19 11:00:00	YM	Futures	7419.6	7445.1	7408.7	7440.6	1291.0
2009-01-19 18:00:00	YM	Futures	7445.1	7476.1	7434.2	7453.3	432.0
2009-01-19 19:00:00	YM	Futures	7451.5	7451.5	7385.9	7397.7	471.0

> showing 50 of 930 rows — these rows as CSV

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