PREVIEW / stock_1hour / 2018-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-27.parquet
  size:    1.1 MB
  rows:    48,868
  symbols: 2,737

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-11-27 04:00:00	AAPL	Stock	42.9375	43.21	42.9375	43.0375	36516.0
2018-11-27 05:00:00	AAPL	Stock	42.975	42.975	42.9025	42.9475	21344.0
2018-11-27 06:00:00	AAPL	Stock	42.9	43.0	42.8375	43.0	61840.0
2018-11-27 07:00:00	AAPL	Stock	42.9575	42.9775	42.7	42.775	419504.0
2018-11-27 08:00:00	AAPL	Stock	42.7092	43.025	42.6925	42.95	1729664.0
2018-11-27 09:00:00	AAPL	Stock	42.915	43.295	42.72	43.185	29290612.0
2018-11-27 10:00:00	AAPL	Stock	43.1825	43.6675	43.04	43.5525	30394664.0
2018-11-27 11:00:00	AAPL	Stock	43.5475	43.6925	43.33	43.502	15522280.0
2018-11-27 12:00:00	AAPL	Stock	43.5	43.5112	43.1025	43.2075	11229148.0
2018-11-27 13:00:00	AAPL	Stock	43.2125	43.445	43.1425	43.44	11984992.0
2018-11-27 14:00:00	AAPL	Stock	43.4425	43.56	43.27	43.275	10803424.0
2018-11-27 15:00:00	AAPL	Stock	43.2725	43.575	43.2175	43.5625	18622132.0
2018-11-27 16:00:00	AAPL	Stock	43.56	43.7	43.5425	43.695	12799368.0
2018-11-27 17:00:00	AAPL	Stock	43.7	43.9	43.6875	43.79	437588.0
2018-11-27 18:00:00	AAPL	Stock	43.7875	43.9	43.7875	43.8875	273800.0
2018-11-27 19:00:00	AAPL	Stock	43.8875	43.9675	43.8775	43.9225	236212.0
2018-11-27 04:00:00	MSFT	Stock	106.82	107.0	106.52	106.52	14096.0
2018-11-27 05:00:00	MSFT	Stock	106.5	106.79	106.5	106.5	4002.0
2018-11-27 06:00:00	MSFT	Stock	106.3	106.3	106.3	106.3	450.0
2018-11-27 07:00:00	MSFT	Stock	106.58	106.58	105.82	106.0	11200.0
2018-11-27 08:00:00	MSFT	Stock	106.02	106.5	105.91	106.27	38688.0
2018-11-27 09:00:00	MSFT	Stock	106.4	106.5	105.36	106.39	3141146.0
2018-11-27 10:00:00	MSFT	Stock	106.38	107.04	106.03	106.62	4802628.0
2018-11-27 11:00:00	MSFT	Stock	106.61	107.17	106.51	106.935	2970428.0
2018-11-27 12:00:00	MSFT	Stock	106.94	106.98	106.1	106.18	2277850.0
2018-11-27 13:00:00	MSFT	Stock	106.18	106.995	106.0	106.989	3104621.0
2018-11-27 14:00:00	MSFT	Stock	106.98	107.33	106.83	106.98	2586538.0
2018-11-27 15:00:00	MSFT	Stock	106.98	107.23	106.8	107.2	3993394.0
2018-11-27 16:00:00	MSFT	Stock	107.16	107.75	107.0	107.75	3230492.0
2018-11-27 17:00:00	MSFT	Stock	107.65	107.66	107.5	107.65	31475.0
2018-11-27 18:00:00	MSFT	Stock	107.57	107.65	107.57	107.62	7303.0
2018-11-27 19:00:00	MSFT	Stock	107.6	107.75	107.51	107.75	19539.0
2018-11-27 04:00:00	NVDA	Stock	3.8	3.815	3.8	3.805	88800.0
2018-11-27 05:00:00	NVDA	Stock	3.8	3.805	3.7975	3.7975	38000.0
2018-11-27 06:00:00	NVDA	Stock	3.8025	3.8025	3.8025	3.8025	27720.0
2018-11-27 07:00:00	NVDA	Stock	3.8	3.8	3.765	3.7702	983720.0
2018-11-27 08:00:00	NVDA	Stock	3.7888	3.8013	3.7635	3.79	2302440.0
2018-11-27 09:00:00	NVDA	Stock	3.7882	3.8712	3.7668	3.8638	130157240.0
2018-11-27 10:00:00	NVDA	Stock	3.8644	3.8655	3.7638	3.8255	155930720.0
2018-11-27 11:00:00	NVDA	Stock	3.8255	3.8953	3.821	3.8898	99428520.0
2018-11-27 12:00:00	NVDA	Stock	3.8895	3.9252	3.8478	3.8562	93363160.0
2018-11-27 13:00:00	NVDA	Stock	3.8562	3.887	3.8512	3.8808	54684120.0
2018-11-27 14:00:00	NVDA	Stock	3.8832	3.9008	3.832	3.8328	62428640.0
2018-11-27 15:00:00	NVDA	Stock	3.8333	3.8572	3.809	3.8432	85481440.0
2018-11-27 16:00:00	NVDA	Stock	3.8432	3.8562	3.838	3.8558	9647960.0
2018-11-27 17:00:00	NVDA	Stock	3.8558	3.8675	3.8515	3.8638	808200.0
2018-11-27 18:00:00	NVDA	Stock	3.8638	3.8675	3.86	3.8663	595680.0
2018-11-27 19:00:00	NVDA	Stock	3.8663	3.875	3.8648	3.8705	673120.0
2018-11-27 04:00:00	AMZN	Stock	78.9185	78.947	78.9015	78.947	18200.0
2018-11-27 05:00:00	AMZN	Stock	78.773	78.773	78.773	78.773	4000.0

> showing 50 of 48,868 rows — these rows as CSV

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