PREVIEW / stock_1hour / 2017-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-31.parquet
  size:    1.0 MB
  rows:    47,773
  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-31 04:00:00	AAPL	Stock	37.4375	37.465	37.4375	37.465	924.0
2017-07-31 05:00:00	AAPL	Stock	37.55	37.5625	37.51	37.51	7792.0
2017-07-31 06:00:00	AAPL	Stock	37.5125	37.55	37.5	37.5	12796.0
2017-07-31 07:00:00	AAPL	Stock	37.5	37.525	37.5	37.5	69920.0
2017-07-31 08:00:00	AAPL	Stock	37.4775	37.525	37.455	37.455	224348.0
2017-07-31 09:00:00	AAPL	Stock	37.455	37.5825	37.305	37.3475	11590948.0
2017-07-31 10:00:00	AAPL	Stock	37.3475	37.365	37.0625	37.1975	12806328.0
2017-07-31 11:00:00	AAPL	Stock	37.2	37.275	37.135	37.2012	5750948.0
2017-07-31 12:00:00	AAPL	Stock	37.2	37.2438	37.1085	37.185	5359544.0
2017-07-31 13:00:00	AAPL	Stock	37.1875	37.21	37.06	37.1	5818084.0
2017-07-31 14:00:00	AAPL	Stock	37.1002	37.2025	37.0325	37.1287	6430060.0
2017-07-31 15:00:00	AAPL	Stock	37.1275	37.25	37.1275	37.1925	11888484.0
2017-07-31 16:00:00	AAPL	Stock	37.1925	37.2225	37.0902	37.1875	9735328.0
2017-07-31 17:00:00	AAPL	Stock	37.185	37.1875	37.0075	37.03	170724.0
2017-07-31 18:00:00	AAPL	Stock	37.03	37.0375	37.0	37.0125	99648.0
2017-07-31 19:00:00	AAPL	Stock	37.0125	37.05	37.0075	37.0275	51224.0
2017-07-31 05:00:00	MSFT	Stock	73.5	73.5	73.5	73.5	2419.0
2017-07-31 07:00:00	MSFT	Stock	73.3	73.3	73.2	73.3	6855.0
2017-07-31 08:00:00	MSFT	Stock	73.3	73.59	73.11	73.31	19633.0
2017-07-31 09:00:00	MSFT	Stock	73.35	73.44	72.8	72.83	2022286.0
2017-07-31 10:00:00	MSFT	Stock	72.83	72.906	72.41	72.52	2869073.0
2017-07-31 11:00:00	MSFT	Stock	72.53	73.05	72.525	72.945	1891283.0
2017-07-31 12:00:00	MSFT	Stock	72.945	73.31	72.865	73.29	2051346.0
2017-07-31 13:00:00	MSFT	Stock	73.299	73.37	73.14	73.285	1707125.0
2017-07-31 14:00:00	MSFT	Stock	73.287	73.29	72.84	72.86	1929726.0
2017-07-31 15:00:00	MSFT	Stock	72.86	72.92	72.61	72.72	4668182.0
2017-07-31 16:00:00	MSFT	Stock	72.7	72.72	72.49	72.7	3856042.0
2017-07-31 17:00:00	MSFT	Stock	72.68	72.69	72.6	72.6	1542.0
2017-07-31 18:00:00	MSFT	Stock	72.6	72.6	72.6	72.6	297.0
2017-07-31 19:00:00	MSFT	Stock	72.7	72.7	72.68	72.68	1464.0
2017-07-31 04:00:00	NVDA	Stock	4.1188	4.13	4.1188	4.13	53320.0
2017-07-31 05:00:00	NVDA	Stock	4.1188	4.1188	4.1188	4.1188	4240.0
2017-07-31 06:00:00	NVDA	Stock	4.1275	4.15	4.1275	4.15	194520.0
2017-07-31 07:00:00	NVDA	Stock	4.15	4.15	4.1278	4.1375	240360.0
2017-07-31 08:00:00	NVDA	Stock	4.13	4.1388	4.1252	4.1325	797040.0
2017-07-31 09:00:00	NVDA	Stock	4.1318	4.16	4.1175	4.1195	86336840.0
2017-07-31 10:00:00	NVDA	Stock	4.1197	4.1248	4.055	4.068	125780200.0
2017-07-31 11:00:00	NVDA	Stock	4.0678	4.0943	4.0593	4.0922	59226560.0
2017-07-31 12:00:00	NVDA	Stock	4.0918	4.0918	4.0588	4.0612	39387600.0
2017-07-31 13:00:00	NVDA	Stock	4.0612	4.0636	4.0203	4.0325	53769440.0
2017-07-31 14:00:00	NVDA	Stock	4.0329	4.0635	4.0155	4.0608	55212520.0
2017-07-31 15:00:00	NVDA	Stock	4.0605	4.0795	4.0575	4.0628	71248040.0
2017-07-31 16:00:00	NVDA	Stock	4.063	4.0653	4.0088	4.025	13739960.0
2017-07-31 17:00:00	NVDA	Stock	4.0288	4.0737	4.0162	4.0312	1464320.0
2017-07-31 18:00:00	NVDA	Stock	4.0312	4.0375	4.0252	4.03	493600.0
2017-07-31 19:00:00	NVDA	Stock	4.0288	4.0295	4.0212	4.0295	306200.0
2017-07-31 04:00:00	AMZN	Stock	51.2	51.2	51.2	51.2	4560.0
2017-07-31 05:00:00	AMZN	Stock	51.2945	51.296	51.2945	51.296	4000.0
2017-07-31 06:00:00	AMZN	Stock	51.2845	51.2845	51.215	51.225	20580.0
2017-07-31 07:00:00	AMZN	Stock	51.1725	51.1885	51.1115	51.1115	84620.0

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

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