PREVIEW / futures_1hour / 2018-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-03.parquet
  size:    39 KB
  rows:    1,204

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
2018-09-03 00:00:00	ES	Futures	3164.97	3165.24	3163.61	3163.88	1748.0
2018-09-03 01:00:00	ES	Futures	3164.15	3165.79	3163.61	3164.7	4310.0
2018-09-03 02:00:00	ES	Futures	3164.7	3165.79	3163.33	3164.42	5261.0
2018-09-03 03:00:00	ES	Futures	3164.7	3167.69	3164.15	3167.42	10254.0
2018-09-03 04:00:00	ES	Futures	3167.42	3171.78	3166.88	3170.96	12183.0
2018-09-03 05:00:00	ES	Futures	3170.96	3172.33	3169.87	3170.42	6238.0
2018-09-03 06:00:00	ES	Futures	3170.15	3173.96	3169.87	3172.6	5277.0
2018-09-03 07:00:00	ES	Futures	3172.87	3174.23	3170.42	3170.42	6676.0
2018-09-03 08:00:00	ES	Futures	3170.42	3171.51	3168.51	3169.06	7528.0
2018-09-03 09:00:00	ES	Futures	3169.06	3170.42	3167.97	3170.42	9621.0
2018-09-03 10:00:00	ES	Futures	3170.42	3171.24	3168.51	3170.42	9732.0
2018-09-03 11:00:00	ES	Futures	3170.42	3172.05	3168.24	3170.96	9350.0
2018-09-03 12:00:00	ES	Futures	3170.96	3171.51	3169.33	3169.6	4179.0
2018-09-03 13:00:00	ES	Futures	3169.6	3169.6	3169.6	3169.6	2.0
2018-09-03 18:00:00	ES	Futures	3169.06	3170.69	3168.51	3169.06	2989.0
2018-09-03 19:00:00	ES	Futures	3169.33	3169.6	3167.69	3167.97	2333.0
2018-09-03 20:00:00	ES	Futures	3167.69	3167.97	3164.15	3166.88	9407.0
2018-09-03 21:00:00	ES	Futures	3166.6	3168.24	3162.52	3167.15	11170.0
2018-09-03 22:00:00	ES	Futures	3167.15	3168.24	3166.06	3167.97	5079.0
2018-09-03 23:00:00	ES	Futures	3168.24	3168.51	3166.33	3166.88	2219.0
2018-09-03 00:00:00	NQ	Futures	9029.51	9029.51	9025.39	9025.98	431.0
2018-09-03 01:00:00	NQ	Futures	9026.27	9031.28	9023.92	9027.74	896.0
2018-09-03 02:00:00	NQ	Futures	9027.45	9030.69	9019.21	9023.03	1588.0
2018-09-03 03:00:00	NQ	Futures	9022.74	9030.1	9021.27	9028.33	2566.0
2018-09-03 04:00:00	NQ	Futures	9028.63	9042.76	9027.74	9036.58	3438.0
2018-09-03 05:00:00	NQ	Futures	9036.87	9040.99	9032.45	9033.93	1622.0
2018-09-03 06:00:00	NQ	Futures	9034.22	9043.64	9032.75	9038.93	1847.0
2018-09-03 07:00:00	NQ	Futures	9038.93	9044.53	9034.81	9035.69	1735.0
2018-09-03 08:00:00	NQ	Futures	9035.69	9038.93	9030.1	9032.16	2046.0
2018-09-03 09:00:00	NQ	Futures	9032.16	9039.23	9028.63	9038.64	3189.0
2018-09-03 10:00:00	NQ	Futures	9038.64	9043.35	9035.1	9041.29	3156.0
2018-09-03 11:00:00	NQ	Futures	9041.58	9052.47	9038.64	9046.88	4501.0
2018-09-03 12:00:00	NQ	Futures	9047.18	9052.77	9044.82	9046.0	2105.0
2018-09-03 18:00:00	NQ	Futures	9045.7	9049.53	9038.93	9042.17	1121.0
2018-09-03 19:00:00	NQ	Futures	9041.88	9042.46	9037.17	9037.17	572.0
2018-09-03 20:00:00	NQ	Futures	9037.17	9037.17	9025.68	9033.93	3274.0
2018-09-03 21:00:00	NQ	Futures	9033.93	9038.34	9018.03	9035.99	5279.0
2018-09-03 22:00:00	NQ	Futures	9035.69	9041.58	9031.57	9040.99	2652.0
2018-09-03 23:00:00	NQ	Futures	9041.29	9042.17	9034.22	9035.69	1001.0
2018-09-03 00:00:00	YM	Futures	28238.4	28238.4	28225.4	28228.7	412.0
2018-09-03 01:00:00	YM	Futures	28229.7	28241.7	28222.1	28234.1	947.0
2018-09-03 02:00:00	YM	Futures	28234.1	28247.1	28226.5	28238.4	1269.0
2018-09-03 03:00:00	YM	Futures	28238.4	28264.5	28231.9	28262.4	2094.0
2018-09-03 04:00:00	YM	Futures	28263.4	28308.0	28259.1	28299.3	2811.0
2018-09-03 05:00:00	YM	Futures	28299.3	28317.8	28295.0	28299.3	1515.0
2018-09-03 06:00:00	YM	Futures	28300.4	28335.2	28296.1	28329.8	1599.0
2018-09-03 07:00:00	YM	Futures	28330.8	28352.6	28314.5	28316.7	1921.0
2018-09-03 08:00:00	YM	Futures	28316.7	28325.4	28291.7	28295.0	1498.0
2018-09-03 09:00:00	YM	Futures	28293.9	28309.1	28285.2	28309.1	2398.0
2018-09-03 10:00:00	YM	Futures	28309.1	28317.8	28286.3	28302.6	2247.0

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

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