PREVIEW / futures_1hour / 2019-07-16

all futures 1-hour files

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

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-07-16 00:00:00	ES	Futures	3269.85	3270.12	3268.76	3269.85	2333.0
2019-07-16 01:00:00	ES	Futures	3269.85	3270.93	3269.03	3270.12	4676.0
2019-07-16 02:00:00	ES	Futures	3270.12	3270.12	3267.68	3267.68	5463.0
2019-07-16 03:00:00	ES	Futures	3267.95	3269.03	3266.33	3267.95	14916.0
2019-07-16 04:00:00	ES	Futures	3267.68	3269.58	3267.41	3269.31	9426.0
2019-07-16 05:00:00	ES	Futures	3269.03	3270.12	3266.06	3267.41	11222.0
2019-07-16 06:00:00	ES	Futures	3267.41	3269.58	3265.79	3266.6	11526.0
2019-07-16 07:00:00	ES	Futures	3266.6	3270.93	3266.33	3270.12	17717.0
2019-07-16 08:00:00	ES	Futures	3270.12	3272.01	3267.41	3267.68	25751.0
2019-07-16 09:00:00	ES	Futures	3267.68	3268.76	3263.62	3266.33	100464.0
2019-07-16 10:00:00	ES	Futures	3266.6	3268.76	3263.89	3266.87	91898.0
2019-07-16 11:00:00	ES	Futures	3267.14	3267.68	3259.83	3260.37	81604.0
2019-07-16 12:00:00	ES	Futures	3260.37	3261.18	3253.33	3258.21	157959.0
2019-07-16 13:00:00	ES	Futures	3258.21	3263.08	3254.69	3254.96	85194.0
2019-07-16 14:00:00	ES	Futures	3254.96	3259.02	3253.33	3257.12	73915.0
2019-07-16 15:00:00	ES	Futures	3257.12	3261.18	3255.23	3256.58	144416.0
2019-07-16 16:00:00	ES	Futures	3256.31	3258.75	3253.87	3254.69	47526.0
2019-07-16 18:00:00	ES	Futures	3254.69	3256.04	3252.79	3255.77	5017.0
2019-07-16 19:00:00	ES	Futures	3255.77	3256.04	3254.69	3255.77	2126.0
2019-07-16 20:00:00	ES	Futures	3255.5	3256.58	3254.15	3254.69	5503.0
2019-07-16 21:00:00	ES	Futures	3254.42	3257.39	3251.98	3257.39	10923.0
2019-07-16 22:00:00	ES	Futures	3257.39	3258.48	3256.04	3256.85	6510.0
2019-07-16 23:00:00	ES	Futures	3256.58	3258.48	3256.58	3257.39	2796.0
2019-07-16 00:00:00	NQ	Futures	9281.66	9282.82	9276.14	9280.21	1034.0
2019-07-16 01:00:00	NQ	Futures	9280.21	9286.3	9276.14	9281.08	1933.0
2019-07-16 02:00:00	NQ	Futures	9281.37	9282.53	9270.63	9271.21	2278.0
2019-07-16 03:00:00	NQ	Futures	9271.5	9279.63	9269.18	9275.27	3987.0
2019-07-16 04:00:00	NQ	Futures	9275.27	9281.08	9274.4	9278.17	2799.0
2019-07-16 05:00:00	NQ	Futures	9278.47	9280.79	9267.44	9271.21	3114.0
2019-07-16 06:00:00	NQ	Futures	9271.5	9277.59	9265.7	9271.79	3926.0
2019-07-16 07:00:00	NQ	Futures	9271.79	9283.11	9270.34	9275.56	7438.0
2019-07-16 08:00:00	NQ	Futures	9275.56	9281.37	9265.99	9266.57	7833.0
2019-07-16 09:00:00	NQ	Futures	9266.57	9270.34	9252.06	9267.73	34897.0
2019-07-16 10:00:00	NQ	Futures	9267.44	9267.73	9246.55	9259.61	38261.0
2019-07-16 11:00:00	NQ	Futures	9259.9	9261.35	9236.97	9239.01	29491.0
2019-07-16 12:00:00	NQ	Futures	9239.01	9242.49	9196.35	9228.27	54205.0
2019-07-16 13:00:00	NQ	Futures	9227.98	9245.39	9210.57	9211.44	31338.0
2019-07-16 14:00:00	NQ	Futures	9211.44	9230.59	9209.41	9224.79	25663.0
2019-07-16 15:00:00	NQ	Futures	9224.79	9237.85	9220.73	9224.79	33686.0
2019-07-16 16:00:00	NQ	Futures	9224.79	9227.69	9211.44	9211.73	8314.0
2019-07-16 18:00:00	NQ	Futures	9214.63	9221.02	9210.86	9219.86	2099.0
2019-07-16 19:00:00	NQ	Futures	9219.86	9220.44	9213.76	9216.66	1240.0
2019-07-16 20:00:00	NQ	Futures	9216.66	9219.86	9209.12	9210.28	2121.0
2019-07-16 21:00:00	NQ	Futures	9210.28	9220.44	9202.74	9219.86	4206.0
2019-07-16 22:00:00	NQ	Futures	9219.86	9225.95	9215.79	9218.99	2664.0
2019-07-16 23:00:00	NQ	Futures	9218.7	9224.79	9217.54	9220.15	1246.0
2019-07-16 00:00:00	YM	Futures	29746.4	29750.7	29738.8	29744.2	684.0
2019-07-16 01:00:00	YM	Futures	29745.3	29755.1	29738.8	29747.5	1066.0
2019-07-16 02:00:00	YM	Futures	29747.5	29748.6	29725.7	29726.8	1442.0
2019-07-16 03:00:00	YM	Futures	29726.8	29743.1	29715.9	29731.2	2983.0

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

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