PREVIEW / stock_1hour / 2018-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-06.parquet
  size:    1.1 MB
  rows:    52,332
  symbols: 2,917

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
2018-02-06 04:00:00	AAPL	Stock	38.9025	39.225	38.875	39.0075	145928.0
2018-02-06 05:00:00	AAPL	Stock	38.93	39.1725	38.7875	39.17	134552.0
2018-02-06 06:00:00	AAPL	Stock	39.13	39.17	38.775	38.8	206072.0
2018-02-06 07:00:00	AAPL	Stock	38.815	39.1325	38.6225	38.9475	625316.0
2018-02-06 08:00:00	AAPL	Stock	39.0	39.125	38.5675	39.0	1058160.0
2018-02-06 09:00:00	AAPL	Stock	39.0	40.25	38.5	39.7145	50760324.0
2018-02-06 10:00:00	AAPL	Stock	39.7138	40.1	39.0525	39.4675	39303632.0
2018-02-06 11:00:00	AAPL	Stock	39.47	39.85	39.125	39.635	21528848.0
2018-02-06 12:00:00	AAPL	Stock	39.64	40.223	39.625	40.1332	23425276.0
2018-02-06 13:00:00	AAPL	Stock	40.1275	40.18	39.745	39.8225	17774120.0
2018-02-06 14:00:00	AAPL	Stock	39.8162	40.49	39.6525	40.445	25375368.0
2018-02-06 15:00:00	AAPL	Stock	40.4575	40.93	40.3825	40.765	41757232.0
2018-02-06 16:00:00	AAPL	Stock	40.7575	40.87	40.6675	40.7125	16308764.0
2018-02-06 17:00:00	AAPL	Stock	40.7	40.7925	40.6775	40.7375	214260.0
2018-02-06 18:00:00	AAPL	Stock	40.75	40.79	40.6125	40.675	99132.0
2018-02-06 19:00:00	AAPL	Stock	40.725	40.75	40.635	40.715	63280.0
2018-02-06 04:00:00	MSFT	Stock	87.0	88.29	87.0	87.68	28874.0
2018-02-06 05:00:00	MSFT	Stock	87.51	87.59	87.0	87.59	21814.0
2018-02-06 06:00:00	MSFT	Stock	87.52	87.52	86.82	86.82	12595.0
2018-02-06 07:00:00	MSFT	Stock	87.0	87.15	86.0	86.9	40429.0
2018-02-06 08:00:00	MSFT	Stock	87.0	87.75	86.35	87.75	204861.0
2018-02-06 09:00:00	MSFT	Stock	87.61	89.27	85.25	87.99	11802611.0
2018-02-06 10:00:00	MSFT	Stock	87.99	89.33	86.54	87.83	9460540.0
2018-02-06 11:00:00	MSFT	Stock	87.85	88.28	86.83	87.965	6431086.0
2018-02-06 12:00:00	MSFT	Stock	87.98	89.88	87.94	89.555	6270077.0
2018-02-06 13:00:00	MSFT	Stock	89.55	89.92	88.5	88.68	6243093.0
2018-02-06 14:00:00	MSFT	Stock	88.67	90.46	88.01	90.27	6329787.0
2018-02-06 15:00:00	MSFT	Stock	90.27	91.475	89.84	91.34	9558601.0
2018-02-06 16:00:00	MSFT	Stock	91.35	91.41	88.649	91.25	5321178.0
2018-02-06 17:00:00	MSFT	Stock	91.25	91.45	91.05	91.31	15733.0
2018-02-06 18:00:00	MSFT	Stock	91.4	91.65	88.573	91.1	10026.0
2018-02-06 19:00:00	MSFT	Stock	91.35	91.35	91.1	91.21	4085.0
2018-02-06 04:00:00	NVDA	Stock	5.225	5.285	5.1875	5.2188	948680.0
2018-02-06 05:00:00	NVDA	Stock	5.21	5.21	5.1252	5.177	552320.0
2018-02-06 06:00:00	NVDA	Stock	5.2	5.2	5.1235	5.1238	451440.0
2018-02-06 07:00:00	NVDA	Stock	5.1128	5.2	5.05	5.1875	2354400.0
2018-02-06 08:00:00	NVDA	Stock	5.1763	5.2345	5.053	5.2225	5208760.0
2018-02-06 09:00:00	NVDA	Stock	5.22	5.6418	5.1	5.5193	245344240.0
2018-02-06 10:00:00	NVDA	Stock	5.516	5.5598	5.3	5.4045	202695400.0
2018-02-06 11:00:00	NVDA	Stock	5.41	5.4645	5.362	5.4265	76880760.0
2018-02-06 12:00:00	NVDA	Stock	5.4281	5.5612	5.42	5.5105	99091840.0
2018-02-06 13:00:00	NVDA	Stock	5.5095	5.5113	5.4038	5.425	49630200.0
2018-02-06 14:00:00	NVDA	Stock	5.4225	5.5328	5.4038	5.5286	62949080.0
2018-02-06 15:00:00	NVDA	Stock	5.532	5.6425	5.5245	5.639	140376320.0
2018-02-06 16:00:00	NVDA	Stock	5.6395	5.6748	5.625	5.6678	21884760.0
2018-02-06 17:00:00	NVDA	Stock	5.6678	5.7125	5.6675	5.71	1806040.0
2018-02-06 18:00:00	NVDA	Stock	5.707	5.7428	5.707	5.7275	2781640.0
2018-02-06 19:00:00	NVDA	Stock	5.7265	5.7338	5.7198	5.7198	766600.0
2018-02-06 04:00:00	AMZN	Stock	68.7	69.0	68.4995	68.4995	67500.0
2018-02-06 05:00:00	AMZN	Stock	68.25	68.25	67.5	68.2	52980.0

> showing 50 of 52,332 rows — these rows as CSV

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