PREVIEW / stock_1hour / 2017-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-26.parquet
  size:    1.0 MB
  rows:    47,800
  symbols: 2,991

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
2017-07-26 04:00:00	AAPL	Stock	38.26	38.3225	38.26	38.3225	2400.0
2017-07-26 06:00:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	400.0
2017-07-26 07:00:00	AAPL	Stock	38.3025	38.34	38.2875	38.31	14864.0
2017-07-26 08:00:00	AAPL	Stock	38.325	38.355	38.3	38.335	145864.0
2017-07-26 09:00:00	AAPL	Stock	38.335	38.4825	38.265	38.3575	8621840.0
2017-07-26 10:00:00	AAPL	Stock	38.3572	38.4825	38.2875	38.2968	10682728.0
2017-07-26 11:00:00	AAPL	Stock	38.2972	38.41	38.295	38.365	6374260.0
2017-07-26 12:00:00	AAPL	Stock	38.3688	38.445	38.3525	38.4	4860816.0
2017-07-26 13:00:00	AAPL	Stock	38.4	38.4075	38.34	38.3575	2937824.0
2017-07-26 14:00:00	AAPL	Stock	38.3525	38.45	38.3275	38.39	5257012.0
2017-07-26 15:00:00	AAPL	Stock	38.3875	38.4255	38.3062	38.375	7515196.0
2017-07-26 16:00:00	AAPL	Stock	38.375	38.425	38.3	38.4125	10148168.0
2017-07-26 17:00:00	AAPL	Stock	38.4125	38.45	38.365	38.45	388356.0
2017-07-26 18:00:00	AAPL	Stock	38.445	38.48	38.4375	38.455	62932.0
2017-07-26 19:00:00	AAPL	Stock	38.455	38.48	38.445	38.4575	60644.0
2017-07-26 04:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	100.0
2017-07-26 05:00:00	MSFT	Stock	74.28	74.28	74.28	74.28	100.0
2017-07-26 08:00:00	MSFT	Stock	74.2	74.33	74.2	74.33	13528.0
2017-07-26 09:00:00	MSFT	Stock	74.33	74.38	74.06	74.19	1922824.0
2017-07-26 10:00:00	MSFT	Stock	74.195	74.3	74.07	74.075	2122564.0
2017-07-26 11:00:00	MSFT	Stock	74.08	74.17	73.95	73.98	1775909.0
2017-07-26 12:00:00	MSFT	Stock	73.985	74.15	73.95	73.96	1678376.0
2017-07-26 13:00:00	MSFT	Stock	73.96	74.045	73.86	73.9	942953.0
2017-07-26 14:00:00	MSFT	Stock	73.905	74.03	73.81	73.895	1586342.0
2017-07-26 15:00:00	MSFT	Stock	73.89	74.05	73.84	74.05	2651775.0
2017-07-26 16:00:00	MSFT	Stock	74.05	74.06	73.89	74.0	1914519.0
2017-07-26 17:00:00	MSFT	Stock	73.95	74.05	73.93	73.93	159799.0
2017-07-26 18:00:00	MSFT	Stock	74.04	74.05	73.95	74.04	10003.0
2017-07-26 19:00:00	MSFT	Stock	74.05	74.12	74.05	74.05	5375.0
2017-07-26 05:00:00	NVDA	Stock	4.1873	4.1873	4.1873	4.1873	8000.0
2017-07-26 06:00:00	NVDA	Stock	4.1875	4.207	4.1875	4.207	278880.0
2017-07-26 07:00:00	NVDA	Stock	4.2	4.2	4.1875	4.1878	357720.0
2017-07-26 08:00:00	NVDA	Stock	4.188	4.2112	4.1835	4.1905	2881000.0
2017-07-26 09:00:00	NVDA	Stock	4.1925	4.247	4.1758	4.2374	142750280.0
2017-07-26 10:00:00	NVDA	Stock	4.2385	4.2482	4.1915	4.1998	121715720.0
2017-07-26 11:00:00	NVDA	Stock	4.1995	4.217	4.1712	4.181	81215080.0
2017-07-26 12:00:00	NVDA	Stock	4.182	4.1908	4.1528	4.1615	52315760.0
2017-07-26 13:00:00	NVDA	Stock	4.161	4.1771	4.1572	4.1656	41841880.0
2017-07-26 14:00:00	NVDA	Stock	4.165	4.1812	4.1462	4.1618	59903280.0
2017-07-26 15:00:00	NVDA	Stock	4.1625	4.1835	4.161	4.1802	69199200.0
2017-07-26 16:00:00	NVDA	Stock	4.18	4.1825	4.1628	4.1788	3733720.0
2017-07-26 17:00:00	NVDA	Stock	4.1788	4.1875	4.175	4.187	3652320.0
2017-07-26 18:00:00	NVDA	Stock	4.1825	4.193	4.1825	4.193	893600.0
2017-07-26 19:00:00	NVDA	Stock	4.193	4.193	4.1838	4.1925	334720.0
2017-07-26 05:00:00	AMZN	Stock	52.094	52.094	52.094	52.094	2000.0
2017-07-26 07:00:00	AMZN	Stock	52.1	52.1335	52.0985	52.1	18040.0
2017-07-26 08:00:00	AMZN	Stock	52.14	52.25	52.1	52.2125	152640.0
2017-07-26 09:00:00	AMZN	Stock	52.2225	52.5815	52.16	52.529	11008860.0
2017-07-26 10:00:00	AMZN	Stock	52.5205	52.65	52.5	52.5755	7798500.0
2017-07-26 11:00:00	AMZN	Stock	52.5685	52.609	52.4735	52.5	4311480.0

> showing 50 of 47,800 rows — these rows as CSV

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