PREVIEW / stock_1hour / 2017-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-18.parquet
  size:    1.1 MB
  rows:    50,682
  symbols: 2,951

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-12-18 04:00:00	AAPL	Stock	43.56	43.7675	43.56	43.7075	28416.0
2017-12-18 05:00:00	AAPL	Stock	43.7275	43.7675	43.7275	43.7625	4844.0
2017-12-18 06:00:00	AAPL	Stock	43.78	43.975	43.78	43.83	82092.0
2017-12-18 07:00:00	AAPL	Stock	43.8175	43.84	43.725	43.7625	180148.0
2017-12-18 08:00:00	AAPL	Stock	43.8875	43.8875	43.7025	43.7275	349912.0
2017-12-18 09:00:00	AAPL	Stock	43.705	44.07	43.7025	44.0525	19945732.0
2017-12-18 10:00:00	AAPL	Stock	44.0525	44.15	43.9888	44.0865	16961048.0
2017-12-18 11:00:00	AAPL	Stock	44.085	44.1725	44.0525	44.13	9163032.0
2017-12-18 12:00:00	AAPL	Stock	44.1325	44.1575	44.0675	44.1175	6093520.0
2017-12-18 13:00:00	AAPL	Stock	44.1165	44.2525	44.0925	44.2522	8898492.0
2017-12-18 14:00:00	AAPL	Stock	44.2525	44.2925	44.165	44.275	7794316.0
2017-12-18 15:00:00	AAPL	Stock	44.2725	44.3	44.1075	44.1075	17944740.0
2017-12-18 16:00:00	AAPL	Stock	44.1075	44.2425	44.105	44.13	19557624.0
2017-12-18 17:00:00	AAPL	Stock	44.1175	44.12	44.105	44.1075	71940.0
2017-12-18 18:00:00	AAPL	Stock	44.12	44.15	44.12	44.1475	27508.0
2017-12-18 19:00:00	AAPL	Stock	44.1475	44.165	44.1125	44.1475	83912.0
2017-12-18 04:00:00	MSFT	Stock	87.3	87.51	87.3	87.51	7253.0
2017-12-18 05:00:00	MSFT	Stock	87.88	87.88	87.32	87.32	539.0
2017-12-18 06:00:00	MSFT	Stock	87.65	87.65	87.64	87.64	4544.0
2017-12-18 07:00:00	MSFT	Stock	87.42	87.64	87.42	87.55	9377.0
2017-12-18 08:00:00	MSFT	Stock	87.37	87.64	87.21	87.34	45339.0
2017-12-18 09:00:00	MSFT	Stock	87.34	87.5	86.86	87.02	2492296.0
2017-12-18 10:00:00	MSFT	Stock	87.035	87.1	86.585	86.59	2513584.0
2017-12-18 11:00:00	MSFT	Stock	86.585	86.86	86.36	86.76	2098581.0
2017-12-18 12:00:00	MSFT	Stock	86.75	86.96	86.71	86.825	1453917.0
2017-12-18 13:00:00	MSFT	Stock	86.83	86.88	86.67	86.69	1429449.0
2017-12-18 14:00:00	MSFT	Stock	86.69	86.7	86.46	86.475	1886191.0
2017-12-18 15:00:00	MSFT	Stock	86.47	86.5	86.23	86.44	4541267.0
2017-12-18 16:00:00	MSFT	Stock	86.45	86.45	86.25	86.38	3866402.0
2017-12-18 17:00:00	MSFT	Stock	86.38	86.4	86.35	86.38	12577.0
2017-12-18 18:00:00	MSFT	Stock	86.39	86.4	86.38	86.38	1963.0
2017-12-18 19:00:00	MSFT	Stock	86.4	86.4	86.4	86.4	848.0
2017-12-18 04:00:00	NVDA	Stock	4.818	4.85	4.818	4.8425	73040.0
2017-12-18 05:00:00	NVDA	Stock	4.8598	4.8598	4.8598	4.8598	8400.0
2017-12-18 06:00:00	NVDA	Stock	4.85	4.8578	4.85	4.8525	31240.0
2017-12-18 07:00:00	NVDA	Stock	4.8505	4.8505	4.8375	4.8425	637160.0
2017-12-18 08:00:00	NVDA	Stock	4.8408	4.85	4.8338	4.836	2800840.0
2017-12-18 09:00:00	NVDA	Stock	4.8398	4.8615	4.8	4.8465	84429920.0
2017-12-18 10:00:00	NVDA	Stock	4.8465	4.8848	4.835	4.8813	79826200.0
2017-12-18 11:00:00	NVDA	Stock	4.883	4.9035	4.871	4.8844	51414240.0
2017-12-18 12:00:00	NVDA	Stock	4.8838	4.9435	4.8838	4.9344	65847560.0
2017-12-18 13:00:00	NVDA	Stock	4.9348	4.9348	4.9105	4.924	42898000.0
2017-12-18 14:00:00	NVDA	Stock	4.9239	4.9395	4.9128	4.9372	36363960.0
2017-12-18 15:00:00	NVDA	Stock	4.9368	4.9505	4.9268	4.949	79857040.0
2017-12-18 16:00:00	NVDA	Stock	4.9475	4.9625	4.9458	4.9538	21244040.0
2017-12-18 17:00:00	NVDA	Stock	4.9538	4.96	4.9475	4.96	708200.0
2017-12-18 18:00:00	NVDA	Stock	4.9595	4.972	4.9595	4.9658	1224840.0
2017-12-18 19:00:00	NVDA	Stock	4.9625	4.9725	4.9625	4.9725	494560.0
2017-12-18 05:00:00	AMZN	Stock	59.437	59.437	59.4	59.4	6160.0
2017-12-18 06:00:00	AMZN	Stock	59.4	59.5	59.4	59.443	48800.0

> showing 50 of 50,682 rows — these rows as CSV

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