PREVIEW / futures_1hour / 2019-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-05.parquet
  size:    45 KB
  rows:    1,394

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-04-05 00:00:00	ES	Futures	3130.69	3131.5	3130.15	3130.15	3235.0
2019-04-05 01:00:00	ES	Futures	3130.42	3130.96	3129.6	3130.96	7834.0
2019-04-05 02:00:00	ES	Futures	3130.96	3132.32	3130.15	3132.04	9309.0
2019-04-05 03:00:00	ES	Futures	3131.77	3133.13	3130.42	3130.69	14506.0
2019-04-05 04:00:00	ES	Futures	3130.96	3133.13	3130.42	3130.69	8472.0
2019-04-05 05:00:00	ES	Futures	3130.96	3131.5	3129.6	3130.96	7254.0
2019-04-05 06:00:00	ES	Futures	3130.96	3131.77	3129.33	3131.23	6996.0
2019-04-05 07:00:00	ES	Futures	3131.23	3131.5	3128.25	3129.33	9168.0
2019-04-05 08:00:00	ES	Futures	3129.33	3137.74	3128.79	3134.21	56554.0
2019-04-05 09:00:00	ES	Futures	3134.21	3137.47	3130.42	3136.92	175908.0
2019-04-05 10:00:00	ES	Futures	3136.65	3140.99	3135.57	3138.01	168797.0
2019-04-05 11:00:00	ES	Futures	3138.01	3140.72	3135.84	3136.92	131485.0
2019-04-05 12:00:00	ES	Futures	3137.2	3139.64	3134.21	3137.47	76644.0
2019-04-05 13:00:00	ES	Futures	3137.47	3139.64	3136.38	3139.64	46687.0
2019-04-05 14:00:00	ES	Futures	3139.36	3140.18	3135.57	3137.74	92797.0
2019-04-05 15:00:00	ES	Futures	3137.74	3141.8	3135.84	3140.72	183920.0
2019-04-05 16:00:00	ES	Futures	3140.72	3142.62	3139.64	3142.35	60374.0
2019-04-05 00:00:00	NQ	Futures	8819.99	8822.61	8817.66	8819.12	1159.0
2019-04-05 01:00:00	NQ	Futures	8819.41	8823.48	8817.95	8823.48	1850.0
2019-04-05 02:00:00	NQ	Futures	8823.19	8827.27	8820.57	8825.81	2832.0
2019-04-05 03:00:00	NQ	Futures	8825.81	8833.67	8824.65	8825.52	5443.0
2019-04-05 04:00:00	NQ	Futures	8825.52	8834.55	8822.32	8824.07	5552.0
2019-04-05 05:00:00	NQ	Futures	8824.07	8827.56	8820.57	8824.94	3141.0
2019-04-05 06:00:00	NQ	Futures	8824.94	8827.27	8820.28	8825.81	2416.0
2019-04-05 07:00:00	NQ	Futures	8826.1	8826.1	8814.17	8818.53	4150.0
2019-04-05 08:00:00	NQ	Futures	8818.24	8853.18	8816.79	8838.92	21589.0
2019-04-05 09:00:00	NQ	Futures	8838.62	8850.27	8824.65	8844.16	64467.0
2019-04-05 10:00:00	NQ	Futures	8844.16	8859.88	8837.46	8848.52	65719.0
2019-04-05 11:00:00	NQ	Futures	8848.81	8855.22	8841.24	8847.65	39630.0
2019-04-05 12:00:00	NQ	Futures	8847.36	8856.68	8842.41	8847.94	23323.0
2019-04-05 13:00:00	NQ	Futures	8848.52	8854.64	8846.49	8853.76	14358.0
2019-04-05 14:00:00	NQ	Futures	8853.76	8854.35	8842.41	8847.36	22708.0
2019-04-05 15:00:00	NQ	Futures	8847.36	8860.75	8843.28	8855.8	36374.0
2019-04-05 16:00:00	NQ	Futures	8855.8	8865.99	8854.64	8865.99	9243.0
2019-04-05 00:00:00	YM	Futures	28744.9	28754.7	28737.3	28738.3	1755.0
2019-04-05 01:00:00	YM	Futures	28740.5	28747.0	28734.0	28743.8	1042.0
2019-04-05 02:00:00	YM	Futures	28742.7	28755.7	28737.3	28750.3	1143.0
2019-04-05 03:00:00	YM	Futures	28751.4	28765.5	28744.9	28747.0	2683.0
2019-04-05 04:00:00	YM	Futures	28747.0	28764.4	28740.5	28749.2	1857.0
2019-04-05 05:00:00	YM	Futures	28748.1	28748.1	28723.1	28734.0	2832.0
2019-04-05 06:00:00	YM	Futures	28734.0	28741.6	28723.1	28735.1	1477.0
2019-04-05 07:00:00	YM	Futures	28734.0	28743.8	28717.7	28726.4	2041.0
2019-04-05 08:00:00	YM	Futures	28728.6	28833.0	28724.2	28793.8	10665.0
2019-04-05 09:00:00	YM	Futures	28796.0	28821.0	28735.1	28777.5	25103.0
2019-04-05 10:00:00	YM	Futures	28776.4	28781.8	28718.8	28743.8	21727.0
2019-04-05 11:00:00	YM	Futures	28744.9	28761.2	28715.5	28731.8	17217.0
2019-04-05 12:00:00	YM	Futures	28730.7	28757.9	28686.1	28730.7	11577.0
2019-04-05 13:00:00	YM	Futures	28731.8	28747.0	28719.9	28746.0	7630.0
2019-04-05 14:00:00	YM	Futures	28744.9	28753.6	28723.1	28735.1	8719.0
2019-04-05 15:00:00	YM	Futures	28735.1	28773.1	28715.5	28749.2	15935.0

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

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