PREVIEW / futures_1hour / 2019-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-26.parquet
  size:    42 KB
  rows:    1,344

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
2019-12-26 00:00:00	ES	Futures	3500.9	3501.5	3500.7	3501.2	994.0
2019-12-26 01:00:00	ES	Futures	3501.2	3501.5	3500.7	3501.2	745.0
2019-12-26 02:00:00	ES	Futures	3501.2	3502.5	3501.2	3501.7	2619.0
2019-12-26 03:00:00	ES	Futures	3502.0	3502.0	3500.4	3501.2	2539.0
2019-12-26 04:00:00	ES	Futures	3501.2	3502.0	3500.9	3502.0	902.0
2019-12-26 05:00:00	ES	Futures	3502.0	3502.3	3501.7	3501.7	2258.0
2019-12-26 06:00:00	ES	Futures	3501.7	3502.5	3501.5	3501.7	1508.0
2019-12-26 07:00:00	ES	Futures	3502.0	3502.3	3501.2	3501.7	1238.0
2019-12-26 08:00:00	ES	Futures	3501.5	3504.4	3500.7	3501.7	6529.0
2019-12-26 09:00:00	ES	Futures	3501.7	3506.1	3500.1	3504.2	60416.0
2019-12-26 10:00:00	ES	Futures	3504.4	3508.2	3504.2	3507.4	42005.0
2019-12-26 11:00:00	ES	Futures	3507.7	3509.9	3506.6	3507.7	44004.0
2019-12-26 12:00:00	ES	Futures	3507.7	3507.7	3504.2	3506.9	35469.0
2019-12-26 13:00:00	ES	Futures	3506.6	3509.1	3506.3	3508.5	29457.0
2019-12-26 14:00:00	ES	Futures	3508.2	3509.6	3506.6	3506.9	22566.0
2019-12-26 15:00:00	ES	Futures	3506.6	3515.0	3504.7	3514.7	115388.0
2019-12-26 16:00:00	ES	Futures	3514.7	3517.2	3513.7	3514.5	59349.0
2019-12-26 18:00:00	ES	Futures	3514.2	3516.1	3513.7	3515.6	4391.0
2019-12-26 19:00:00	ES	Futures	3515.8	3520.4	3515.0	3519.9	9875.0
2019-12-26 20:00:00	ES	Futures	3519.9	3521.8	3519.1	3521.5	7870.0
2019-12-26 21:00:00	ES	Futures	3521.2	3522.9	3521.0	3522.1	7104.0
2019-12-26 22:00:00	ES	Futures	3521.8	3522.9	3521.8	3522.3	3417.0
2019-12-26 23:00:00	ES	Futures	3522.3	3522.9	3521.5	3521.5	2595.0
2019-12-26 00:00:00	NQ	Futures	10105.16	10106.61	10104.87	10106.32	688.0
2019-12-26 01:00:00	NQ	Futures	10106.32	10108.34	10105.16	10107.47	663.0
2019-12-26 02:00:00	NQ	Futures	10107.76	10112.97	10107.18	10110.37	2201.0
2019-12-26 03:00:00	NQ	Futures	10110.08	10110.08	10104.87	10106.9	1803.0
2019-12-26 04:00:00	NQ	Futures	10106.9	10111.52	10105.74	10110.94	2067.0
2019-12-26 05:00:00	NQ	Futures	10110.65	10111.52	10108.34	10110.08	1585.0
2019-12-26 06:00:00	NQ	Futures	10110.37	10112.97	10108.34	10109.79	1095.0
2019-12-26 07:00:00	NQ	Futures	10109.5	10110.08	10106.32	10109.79	1058.0
2019-12-26 08:00:00	NQ	Futures	10109.79	10121.06	10106.32	10113.26	4408.0
2019-12-26 09:00:00	NQ	Futures	10113.26	10133.79	10108.34	10128.87	24237.0
2019-12-26 10:00:00	NQ	Futures	10128.87	10143.04	10128.87	10141.02	18981.0
2019-12-26 11:00:00	NQ	Futures	10141.31	10156.34	10141.02	10153.74	18759.0
2019-12-26 12:00:00	NQ	Futures	10153.74	10154.03	10140.44	10150.85	15082.0
2019-12-26 13:00:00	NQ	Futures	10150.56	10168.49	10150.56	10166.46	16069.0
2019-12-26 14:00:00	NQ	Futures	10166.46	10169.65	10161.55	10163.28	9843.0
2019-12-26 15:00:00	NQ	Futures	10163.28	10181.21	10154.9	10180.35	28077.0
2019-12-26 16:00:00	NQ	Futures	10180.63	10184.68	10178.03	10181.5	12034.0
2019-12-26 18:00:00	NQ	Futures	10180.06	10190.18	10179.19	10187.86	2815.0
2019-12-26 19:00:00	NQ	Futures	10188.15	10203.77	10186.71	10202.32	4403.0
2019-12-26 20:00:00	NQ	Futures	10202.32	10213.02	10199.72	10212.15	4801.0
2019-12-26 21:00:00	NQ	Futures	10212.15	10216.2	10211.0	10213.02	3177.0
2019-12-26 22:00:00	NQ	Futures	10213.02	10218.23	10212.15	10215.62	2882.0
2019-12-26 23:00:00	NQ	Futures	10215.62	10216.2	10209.26	10210.13	1901.0
2019-12-26 00:00:00	YM	Futures	31071.6	31076.0	31068.4	31070.5	324.0
2019-12-26 01:00:00	YM	Futures	31071.6	31073.8	31068.4	31072.7	229.0
2019-12-26 02:00:00	YM	Futures	31072.7	31082.5	31069.4	31078.2	695.0
2019-12-26 03:00:00	YM	Futures	31078.2	31080.3	31062.9	31069.4	842.0

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

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