PREVIEW / futures_1hour / 2019-05-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-30.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-05-30 00:00:00	ES	Futures	3020.08	3021.71	3019.81	3021.16	3704.0
2019-05-30 01:00:00	ES	Futures	3021.16	3021.98	3020.08	3021.98	6114.0
2019-05-30 02:00:00	ES	Futures	3021.98	3025.5	3020.89	3024.42	11770.0
2019-05-30 03:00:00	ES	Futures	3024.69	3028.75	3023.6	3026.59	22326.0
2019-05-30 04:00:00	ES	Futures	3026.86	3026.86	3023.33	3024.15	11631.0
2019-05-30 05:00:00	ES	Futures	3024.15	3027.67	3024.15	3027.13	15768.0
2019-05-30 06:00:00	ES	Futures	3027.13	3027.94	3021.71	3022.79	17378.0
2019-05-30 07:00:00	ES	Futures	3022.79	3023.87	3020.89	3022.25	15294.0
2019-05-30 08:00:00	ES	Futures	3022.25	3027.13	3020.08	3024.15	43345.0
2019-05-30 09:00:00	ES	Futures	3023.87	3033.91	3021.71	3032.28	160537.0
2019-05-30 10:00:00	ES	Futures	3032.28	3035.26	3021.98	3024.69	169758.0
2019-05-30 11:00:00	ES	Futures	3024.69	3026.86	3017.1	3020.62	135622.0
2019-05-30 12:00:00	ES	Futures	3020.89	3029.57	3018.72	3026.86	108846.0
2019-05-30 13:00:00	ES	Futures	3026.86	3028.21	3018.18	3021.16	86810.0
2019-05-30 14:00:00	ES	Futures	3021.43	3023.87	3010.86	3020.35	134828.0
2019-05-30 15:00:00	ES	Futures	3020.35	3027.4	3012.22	3024.69	212657.0
2019-05-30 16:00:00	ES	Futures	3024.69	3026.59	3023.06	3025.23	37539.0
2019-05-30 18:00:00	ES	Futures	3024.15	3026.59	3023.87	3024.69	3580.0
2019-05-30 19:00:00	ES	Futures	3024.69	3026.04	2998.12	2999.48	52444.0
2019-05-30 20:00:00	ES	Futures	2999.75	3004.9	2996.76	3000.02	48292.0
2019-05-30 21:00:00	ES	Futures	2999.75	3007.61	2998.12	3003.81	30557.0
2019-05-30 22:00:00	ES	Futures	3003.81	3006.52	2997.04	3005.44	26536.0
2019-05-30 23:00:00	ES	Futures	3005.44	3010.32	3003.27	3007.34	18019.0
2019-05-30 00:00:00	NQ	Futures	8420.82	8427.51	8420.23	8425.18	1868.0
2019-05-30 01:00:00	NQ	Futures	8424.89	8428.39	8419.65	8427.8	3001.0
2019-05-30 02:00:00	NQ	Futures	8427.51	8441.2	8422.85	8437.7	5186.0
2019-05-30 03:00:00	NQ	Futures	8437.7	8447.89	8430.71	8442.65	8611.0
2019-05-30 04:00:00	NQ	Futures	8442.36	8442.65	8427.8	8432.46	4848.0
2019-05-30 05:00:00	NQ	Futures	8432.17	8442.94	8431.59	8442.65	4521.0
2019-05-30 06:00:00	NQ	Futures	8442.07	8443.82	8422.85	8426.06	6249.0
2019-05-30 07:00:00	NQ	Futures	8426.06	8433.63	8419.07	8426.93	6639.0
2019-05-30 08:00:00	NQ	Futures	8426.93	8443.53	8417.61	8434.21	12386.0
2019-05-30 09:00:00	NQ	Futures	8434.21	8465.94	8428.09	8457.79	59127.0
2019-05-30 10:00:00	NQ	Futures	8458.08	8468.27	8432.46	8438.87	52802.0
2019-05-30 11:00:00	NQ	Futures	8438.58	8448.18	8422.27	8433.92	44299.0
2019-05-30 12:00:00	NQ	Futures	8433.92	8456.92	8425.47	8446.73	32155.0
2019-05-30 13:00:00	NQ	Futures	8447.31	8450.22	8418.49	8428.97	27744.0
2019-05-30 14:00:00	NQ	Futures	8428.68	8434.79	8395.78	8429.26	43111.0
2019-05-30 15:00:00	NQ	Futures	8429.26	8453.72	8401.02	8445.56	54983.0
2019-05-30 16:00:00	NQ	Futures	8445.85	8452.55	8441.78	8449.06	6489.0
2019-05-30 18:00:00	NQ	Futures	8445.56	8450.51	8442.65	8444.69	1431.0
2019-05-30 19:00:00	NQ	Futures	8444.98	8449.93	8365.2	8370.45	14378.0
2019-05-30 20:00:00	NQ	Futures	8370.15	8383.26	8360.25	8373.07	14850.0
2019-05-30 21:00:00	NQ	Futures	8372.77	8396.36	8365.5	8387.33	10698.0
2019-05-30 22:00:00	NQ	Futures	8387.33	8393.74	8366.08	8389.95	7820.0
2019-05-30 23:00:00	NQ	Futures	8389.37	8404.8	8382.09	8397.52	5563.0
2019-05-30 00:00:00	YM	Futures	27330.9	27345.0	27328.7	27339.6	966.0
2019-05-30 01:00:00	YM	Futures	27338.5	27347.2	27325.5	27347.2	1843.0
2019-05-30 02:00:00	YM	Futures	27346.1	27386.4	27344.0	27376.6	4014.0
2019-05-30 03:00:00	YM	Futures	27376.6	27414.7	27364.6	27390.7	5674.0

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

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