PREVIEW / futures_1hour / 2019-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-07.parquet
  size:    59 KB
  rows:    1,863

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-10-07 00:00:00	ES	Futures	3191.66	3194.38	3190.85	3194.11	4227.0
2019-10-07 01:00:00	ES	Futures	3194.11	3194.11	3192.48	3193.57	2652.0
2019-10-07 02:00:00	ES	Futures	3193.29	3196.01	3191.94	3191.94	7854.0
2019-10-07 03:00:00	ES	Futures	3191.66	3197.91	3189.49	3192.21	21692.0
2019-10-07 04:00:00	ES	Futures	3192.21	3193.57	3188.95	3189.76	24877.0
2019-10-07 05:00:00	ES	Futures	3189.76	3192.21	3189.49	3191.12	13191.0
2019-10-07 06:00:00	ES	Futures	3191.12	3201.71	3189.49	3201.17	20847.0
2019-10-07 07:00:00	ES	Futures	3201.17	3201.71	3197.64	3198.45	17490.0
2019-10-07 08:00:00	ES	Futures	3198.45	3201.17	3196.82	3197.37	16837.0
2019-10-07 09:00:00	ES	Futures	3197.1	3199.0	3188.13	3192.75	122023.0
2019-10-07 10:00:00	ES	Futures	3192.75	3203.34	3190.58	3202.26	146788.0
2019-10-07 11:00:00	ES	Futures	3202.53	3210.68	3201.71	3210.68	131316.0
2019-10-07 12:00:00	ES	Futures	3210.68	3210.68	3203.07	3205.25	65619.0
2019-10-07 13:00:00	ES	Futures	3205.25	3215.57	3199.27	3214.21	160123.0
2019-10-07 14:00:00	ES	Futures	3214.21	3215.02	3193.02	3198.73	142889.0
2019-10-07 15:00:00	ES	Futures	3198.73	3203.34	3190.85	3191.94	205746.0
2019-10-07 16:00:00	ES	Futures	3191.94	3192.48	3188.95	3189.76	69730.0
2019-10-07 18:00:00	ES	Futures	3188.4	3191.94	3187.59	3190.85	5797.0
2019-10-07 19:00:00	ES	Futures	3190.85	3192.48	3189.76	3191.12	3858.0
2019-10-07 20:00:00	ES	Futures	3191.12	3197.64	3190.31	3196.55	10454.0
2019-10-07 21:00:00	ES	Futures	3196.55	3200.36	3194.65	3199.27	10358.0
2019-10-07 22:00:00	ES	Futures	3199.27	3202.26	3198.73	3201.71	10785.0
2019-10-07 23:00:00	ES	Futures	3201.71	3204.7	3201.44	3201.71	8509.0
2019-10-07 00:00:00	NQ	Futures	8980.57	8993.35	8977.37	8991.32	2532.0
2019-10-07 01:00:00	NQ	Futures	8991.32	8991.61	8984.93	8988.99	1295.0
2019-10-07 02:00:00	NQ	Futures	8988.41	8998.87	8983.47	8984.35	4101.0
2019-10-07 03:00:00	NQ	Futures	8983.77	9003.52	8975.92	8986.67	9166.0
2019-10-07 04:00:00	NQ	Futures	8987.25	8991.32	8973.02	8976.79	7450.0
2019-10-07 05:00:00	NQ	Futures	8976.5	8985.22	8973.89	8982.31	4115.0
2019-10-07 06:00:00	NQ	Futures	8982.6	9015.72	8977.08	9014.56	6260.0
2019-10-07 07:00:00	NQ	Futures	9014.56	9015.72	8998.0	9000.9	6013.0
2019-10-07 08:00:00	NQ	Futures	9000.32	9011.36	8991.9	8993.64	7759.0
2019-10-07 09:00:00	NQ	Futures	8993.64	9013.1	8975.34	8993.35	47842.0
2019-10-07 10:00:00	NQ	Futures	8993.06	9031.99	8982.89	9029.95	49135.0
2019-10-07 11:00:00	NQ	Futures	9029.66	9049.13	9027.34	9048.25	38524.0
2019-10-07 12:00:00	NQ	Futures	9048.25	9049.13	9021.82	9027.92	21864.0
2019-10-07 13:00:00	NQ	Futures	9027.92	9063.07	9006.42	9054.65	48039.0
2019-10-07 14:00:00	NQ	Futures	9054.65	9056.68	8990.45	9009.62	43460.0
2019-10-07 15:00:00	NQ	Futures	9009.62	9022.98	8986.09	8990.16	50934.0
2019-10-07 16:00:00	NQ	Futures	8989.57	8998.87	8982.89	8992.77	11512.0
2019-10-07 18:00:00	NQ	Futures	8988.99	9000.32	8982.89	8995.97	1880.0
2019-10-07 19:00:00	NQ	Futures	8995.97	9002.36	8993.06	8997.13	1145.0
2019-10-07 20:00:00	NQ	Futures	8997.13	9020.37	8994.22	9016.01	4236.0
2019-10-07 21:00:00	NQ	Futures	9016.59	9032.86	9010.49	9027.34	5007.0
2019-10-07 22:00:00	NQ	Futures	9027.63	9038.09	9025.31	9035.47	5028.0
2019-10-07 23:00:00	NQ	Futures	9035.76	9044.48	9033.44	9034.02	3449.0
2019-10-07 00:00:00	YM	Futures	28751.0	28773.9	28742.3	28771.7	1060.0
2019-10-07 01:00:00	YM	Futures	28770.6	28770.6	28757.5	28766.2	745.0
2019-10-07 02:00:00	YM	Futures	28765.2	28782.6	28743.4	28744.5	2331.0
2019-10-07 03:00:00	YM	Futures	28743.4	28793.4	28714.0	28741.2	5311.0

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

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