PREVIEW / futures_1hour / 2009-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-12.parquet
  size:    42 KB
  rows:    1,200

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-03-12 00:00:00	ES	Futures	678.11	679.3	677.88	678.82	2368.0
2009-03-12 01:00:00	ES	Futures	678.82	679.3	678.11	678.35	1756.0
2009-03-12 02:00:00	ES	Futures	678.35	679.77	676.93	679.77	3639.0
2009-03-12 03:00:00	ES	Futures	679.77	680.96	677.64	680.48	5957.0
2009-03-12 04:00:00	ES	Futures	680.48	682.86	676.93	678.59	24014.0
2009-03-12 05:00:00	ES	Futures	678.82	679.06	676.93	677.88	9225.0
2009-03-12 06:00:00	ES	Futures	677.88	677.88	674.79	675.98	25233.0
2009-03-12 07:00:00	ES	Futures	675.98	679.06	675.5	678.82	18698.0
2009-03-12 08:00:00	ES	Futures	678.82	684.52	678.59	682.86	79005.0
2009-03-12 09:00:00	ES	Futures	682.86	685.7	677.88	683.09	172362.0
2009-03-12 10:00:00	ES	Futures	683.09	697.56	682.62	694.48	228082.0
2009-03-12 11:00:00	ES	Futures	694.48	696.61	690.68	694.24	129320.0
2009-03-12 12:00:00	ES	Futures	694.48	701.12	694.24	700.65	110178.0
2009-03-12 13:00:00	ES	Futures	700.65	702.78	698.04	701.12	103893.0
2009-03-12 14:00:00	ES	Futures	701.36	709.42	699.7	707.05	123777.0
2009-03-12 15:00:00	ES	Futures	707.05	713.93	705.63	711.32	184723.0
2009-03-12 16:00:00	ES	Futures	711.56	714.4	711.08	711.32	41532.0
2009-03-12 17:00:00	ES	Futures	711.56	711.79	711.08	711.08	1179.0
2009-03-12 18:00:00	ES	Futures	710.84	711.56	710.13	710.37	2474.0
2009-03-12 19:00:00	ES	Futures	710.37	711.32	710.13	711.32	1464.0
2009-03-12 20:00:00	ES	Futures	711.08	711.56	710.13	711.56	1969.0
2009-03-12 21:00:00	ES	Futures	711.32	712.03	709.66	709.9	1471.0
2009-03-12 22:00:00	ES	Futures	709.9	710.37	709.42	709.9	1384.0
2009-03-12 23:00:00	ES	Futures	709.9	713.22	709.9	712.5	1323.0
2009-03-12 00:00:00	NQ	Futures	1261.39	1263.65	1260.55	1262.81	141.0
2009-03-12 01:00:00	NQ	Futures	1261.96	1263.37	1261.39	1261.68	79.0
2009-03-12 02:00:00	NQ	Futures	1261.39	1265.07	1260.55	1265.07	213.0
2009-03-12 03:00:00	NQ	Futures	1264.5	1267.32	1261.96	1266.48	337.0
2009-03-12 04:00:00	NQ	Futures	1266.19	1271.0	1260.26	1263.09	1206.0
2009-03-12 05:00:00	NQ	Futures	1263.09	1263.37	1260.26	1261.96	630.0
2009-03-12 06:00:00	NQ	Futures	1261.68	1261.68	1257.16	1257.16	1140.0
2009-03-12 07:00:00	NQ	Futures	1257.16	1260.83	1255.75	1259.42	1627.0
2009-03-12 08:00:00	NQ	Futures	1259.42	1270.15	1258.85	1267.89	4665.0
2009-03-12 09:00:00	NQ	Futures	1267.89	1273.25	1258.01	1264.78	26481.0
2009-03-12 10:00:00	NQ	Futures	1265.07	1288.79	1264.22	1285.11	32234.0
2009-03-12 11:00:00	NQ	Futures	1285.4	1292.74	1278.62	1289.63	15990.0
2009-03-12 12:00:00	NQ	Futures	1289.91	1299.52	1289.07	1298.1	13320.0
2009-03-12 13:00:00	NQ	Futures	1298.39	1300.93	1294.43	1297.82	13329.0
2009-03-12 14:00:00	NQ	Futures	1297.82	1312.22	1294.15	1307.14	21148.0
2009-03-12 15:00:00	NQ	Futures	1307.14	1319.0	1304.32	1314.2	32713.0
2009-03-12 16:00:00	NQ	Futures	1314.2	1317.02	1309.12	1314.48	7368.0
2009-03-12 17:00:00	NQ	Futures	1315.33	1315.33	1314.2	1314.76	15.0
2009-03-12 18:00:00	NQ	Futures	1313.35	1314.76	1313.07	1313.63	45.0
2009-03-12 19:00:00	NQ	Futures	1313.35	1315.33	1313.35	1315.05	68.0
2009-03-12 20:00:00	NQ	Futures	1314.48	1315.05	1312.22	1313.63	165.0
2009-03-12 21:00:00	NQ	Futures	1313.63	1315.33	1310.53	1310.81	162.0
2009-03-12 22:00:00	NQ	Futures	1310.53	1311.66	1310.25	1311.09	21.0
2009-03-12 23:00:00	NQ	Futures	1311.09	1316.18	1311.09	1315.61	33.0
2009-03-12 00:00:00	YM	Futures	6259.0	6267.2	6253.4	6264.5	50.0
2009-03-12 01:00:00	YM	Futures	6259.0	6267.2	6257.1	6267.2	25.0

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

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