PREVIEW / futures_1hour / 2020-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-12.parquet
  size:    16 KB
  rows:    317

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
2020-04-12 18:00:00	ES	Futures	3085.51	3094.84	2982.61	3018.83	53302.0
2020-04-12 19:00:00	ES	Futures	3019.11	3030.63	3006.21	3011.97	20300.0
2020-04-12 20:00:00	ES	Futures	3011.97	3018.56	2997.7	2999.62	17623.0
2020-04-12 21:00:00	ES	Futures	2999.62	3017.73	2996.6	3012.25	15992.0
2020-04-12 22:00:00	ES	Futures	3012.25	3022.95	3010.87	3015.26	14609.0
2020-04-12 23:00:00	ES	Futures	3015.26	3018.56	3002.64	3007.03	13335.0
2020-04-12 18:00:00	NQ	Futures	9478.7	9514.69	9224.19	9299.32	11722.0
2020-04-12 19:00:00	NQ	Futures	9298.17	9329.02	9261.9	9277.32	4034.0
2020-04-12 20:00:00	NQ	Futures	9278.18	9293.03	9238.76	9243.33	4110.0
2020-04-12 21:00:00	NQ	Futures	9245.33	9302.46	9237.9	9283.61	4356.0
2020-04-12 22:00:00	NQ	Futures	9284.18	9308.74	9274.18	9286.46	2797.0
2020-04-12 23:00:00	NQ	Futures	9286.18	9294.46	9249.33	9264.18	2773.0
2020-04-12 18:00:00	YM	Futures	26111.3	26190.1	25310.6	25599.8	7280.0
2020-04-12 19:00:00	YM	Futures	25597.6	25713.7	25499.0	25551.6	2892.0
2020-04-12 20:00:00	YM	Futures	25550.5	25610.7	25442.0	25462.8	3171.0
2020-04-12 21:00:00	YM	Futures	25460.7	25602.0	25432.2	25555.9	3196.0
2020-04-12 22:00:00	YM	Futures	25553.8	25655.6	25545.0	25587.7	2434.0
2020-04-12 23:00:00	YM	Futures	25577.9	25603.0	25483.7	25512.1	1724.0
2020-04-12 18:00:00	CL	Futures	21.85	21.97	19.57	20.2	36799.0
2020-04-12 19:00:00	CL	Futures	20.2	20.65	20.14	20.63	10466.0
2020-04-12 20:00:00	CL	Futures	20.63	21.65	20.6	21.54	28652.0
2020-04-12 21:00:00	CL	Futures	21.53	21.82	21.18	21.28	22328.0
2020-04-12 22:00:00	CL	Futures	21.28	21.49	21.11	21.26	9886.0
2020-04-12 23:00:00	CL	Futures	21.25	21.39	21.14	21.2	6415.0
2020-04-12 18:00:00	GC	Futures	2174.0	2180.7	2160.9	2166.0	5430.0
2020-04-12 19:00:00	GC	Futures	2166.0	2174.8	2165.1	2169.5	2455.0
2020-04-12 20:00:00	GC	Futures	2169.3	2175.8	2168.1	2168.9	2923.0
2020-04-12 21:00:00	GC	Futures	2169.0	2169.8	2157.4	2161.6	6343.0
2020-04-12 22:00:00	GC	Futures	2161.7	2161.9	2151.4	2155.1	6400.0
2020-04-12 23:00:00	GC	Futures	2155.1	2160.6	2155.1	2159.0	2605.0
2020-04-12 18:00:00	ZN	Futures	137.276074	137.540156	137.198403	137.462485	17369.0
2020-04-12 19:00:00	ZN	Futures	137.462485	137.509087	137.431416	137.431416	3222.0
2020-04-12 20:00:00	ZN	Futures	137.431416	137.493553	137.369279	137.415882	6846.0
2020-04-12 21:00:00	ZN	Futures	137.400348	137.44695	137.353745	137.369279	5866.0
2020-04-12 22:00:00	ZN	Futures	137.369279	137.384814	137.322677	137.338211	4728.0
2020-04-12 23:00:00	ZN	Futures	137.338211	137.384814	137.322677	137.369279	3581.0

> showing 36 of 317 rows — these rows as CSV

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