PREVIEW / futures_1hour / 2010-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-20.parquet
  size:    38 KB
  rows:    1,088

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
2010-08-20 00:00:00	ES	Futures	1051.45	1051.45	1049.0	1049.49	10947.0
2010-08-20 01:00:00	ES	Futures	1049.49	1052.68	1049.49	1052.19	6156.0
2010-08-20 02:00:00	ES	Futures	1052.19	1054.15	1051.21	1052.68	10748.0
2010-08-20 03:00:00	ES	Futures	1052.68	1056.11	1051.7	1052.43	37202.0
2010-08-20 04:00:00	ES	Futures	1052.43	1054.15	1049.49	1049.98	28329.0
2010-08-20 05:00:00	ES	Futures	1049.98	1051.7	1047.03	1048.02	30456.0
2010-08-20 06:00:00	ES	Futures	1048.26	1049.0	1043.84	1044.34	51488.0
2010-08-20 07:00:00	ES	Futures	1044.34	1047.77	1043.84	1046.54	29565.0
2010-08-20 08:00:00	ES	Futures	1046.3	1048.51	1044.83	1048.51	59566.0
2010-08-20 09:00:00	ES	Futures	1048.51	1051.45	1044.58	1047.28	309704.0
2010-08-20 10:00:00	ES	Futures	1047.53	1049.73	1045.07	1047.28	308220.0
2010-08-20 11:00:00	ES	Futures	1047.28	1048.26	1042.13	1042.86	220514.0
2010-08-20 12:00:00	ES	Futures	1042.62	1045.81	1042.62	1045.32	102878.0
2010-08-20 13:00:00	ES	Futures	1045.32	1047.53	1045.07	1046.3	91431.0
2010-08-20 14:00:00	ES	Futures	1046.05	1051.7	1046.05	1049.98	170155.0
2010-08-20 15:00:00	ES	Futures	1049.98	1051.7	1048.75	1050.22	218923.0
2010-08-20 16:00:00	ES	Futures	1049.98	1051.21	1048.75	1051.21	84481.0
2010-08-20 00:00:00	NQ	Futures	2085.34	2085.91	2081.9	2083.34	461.0
2010-08-20 01:00:00	NQ	Futures	2083.34	2088.21	2083.34	2087.92	494.0
2010-08-20 02:00:00	NQ	Futures	2087.63	2090.5	2085.63	2087.92	828.0
2010-08-20 03:00:00	NQ	Futures	2088.21	2094.51	2086.2	2087.92	2327.0
2010-08-20 04:00:00	NQ	Futures	2087.92	2090.5	2081.9	2083.05	2331.0
2010-08-20 05:00:00	NQ	Futures	2083.05	2087.06	2078.46	2080.76	1699.0
2010-08-20 06:00:00	NQ	Futures	2080.76	2082.76	2073.31	2073.59	3363.0
2010-08-20 07:00:00	NQ	Futures	2073.31	2081.04	2073.02	2079.04	3326.0
2010-08-20 08:00:00	NQ	Futures	2079.04	2081.9	2075.88	2081.9	5054.0
2010-08-20 09:00:00	NQ	Futures	2081.9	2090.79	2077.89	2086.2	50339.0
2010-08-20 10:00:00	NQ	Futures	2086.2	2093.36	2079.32	2083.34	55360.0
2010-08-20 11:00:00	NQ	Futures	2083.05	2085.63	2074.16	2075.31	30795.0
2010-08-20 12:00:00	NQ	Futures	2075.31	2083.05	2075.31	2082.48	17083.0
2010-08-20 13:00:00	NQ	Futures	2082.48	2087.35	2082.19	2085.34	16332.0
2010-08-20 14:00:00	NQ	Futures	2085.63	2097.38	2084.77	2093.65	29419.0
2010-08-20 15:00:00	NQ	Futures	2093.65	2095.66	2089.93	2092.51	35145.0
2010-08-20 16:00:00	NQ	Futures	2092.51	2093.94	2091.07	2093.94	7085.0
2010-08-20 00:00:00	YM	Futures	9685.7	9685.7	9667.7	9675.3	377.0
2010-08-20 01:00:00	YM	Futures	9676.2	9696.1	9673.4	9692.3	499.0
2010-08-20 02:00:00	YM	Futures	9692.3	9706.5	9681.9	9694.2	983.0
2010-08-20 03:00:00	YM	Futures	9694.2	9723.5	9689.5	9693.3	2039.0
2010-08-20 04:00:00	YM	Futures	9693.3	9707.5	9668.6	9673.4	2129.0
2010-08-20 05:00:00	YM	Futures	9674.3	9685.7	9651.6	9660.1	1463.0
2010-08-20 06:00:00	YM	Futures	9661.1	9666.7	9624.1	9629.8	2784.0
2010-08-20 07:00:00	YM	Futures	9628.9	9654.4	9626.0	9644.0	1246.0
2010-08-20 08:00:00	YM	Futures	9645.0	9663.9	9636.5	9662.0	3125.0
2010-08-20 09:00:00	YM	Futures	9662.0	9681.9	9613.7	9636.5	21204.0
2010-08-20 10:00:00	YM	Futures	9636.5	9651.6	9610.9	9630.8	21590.0
2010-08-20 11:00:00	YM	Futures	9632.7	9637.4	9586.3	9592.0	15607.0
2010-08-20 12:00:00	YM	Futures	9591.0	9616.6	9589.1	9614.7	8628.0
2010-08-20 13:00:00	YM	Futures	9614.7	9629.8	9611.8	9620.4	6540.0
2010-08-20 14:00:00	YM	Futures	9620.4	9663.0	9616.6	9650.7	12314.0
2010-08-20 15:00:00	YM	Futures	9649.7	9662.0	9637.4	9652.5	15659.0

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

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