PREVIEW / stock_1hour / 2017-08-02

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-02.parquet
  size:    1.0 MB
  rows:    47,784
  symbols: 2,989

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-08-02 04:00:00	AAPL	Stock	39.805	39.9375	39.7625	39.8275	270964.0
2017-08-02 05:00:00	AAPL	Stock	39.8275	39.8825	39.8	39.825	95060.0
2017-08-02 06:00:00	AAPL	Stock	39.8	39.845	39.5125	39.5875	776240.0
2017-08-02 07:00:00	AAPL	Stock	39.61	39.825	39.565	39.71	1282164.0
2017-08-02 08:00:00	AAPL	Stock	39.7025	40.0	39.54	39.7875	7078904.0
2017-08-02 09:00:00	AAPL	Stock	39.7875	39.9375	39.425	39.485	77021092.0
2017-08-02 10:00:00	AAPL	Stock	39.478	39.61	39.04	39.2525	58304076.0
2017-08-02 11:00:00	AAPL	Stock	39.2525	39.5175	39.1025	39.445	29559820.0
2017-08-02 12:00:00	AAPL	Stock	39.4475	39.4875	39.2325	39.2812	13470300.0
2017-08-02 13:00:00	AAPL	Stock	39.2825	39.4098	39.18	39.3448	14653240.0
2017-08-02 14:00:00	AAPL	Stock	39.3475	39.5025	39.305	39.479	13791960.0
2017-08-02 15:00:00	AAPL	Stock	39.48	39.595	39.25	39.2875	26036312.0
2017-08-02 16:00:00	AAPL	Stock	39.2875	39.665	39.235	39.3	10394748.0
2017-08-02 17:00:00	AAPL	Stock	39.29	39.32	39.2525	39.3	141920.0
2017-08-02 18:00:00	AAPL	Stock	39.305	39.325	39.25	39.2725	661232.0
2017-08-02 19:00:00	AAPL	Stock	39.27	39.3	39.26	39.26	54336.0
2017-08-02 04:00:00	MSFT	Stock	72.74	72.74	72.5	72.55	4474.0
2017-08-02 05:00:00	MSFT	Stock	72.64	72.64	72.64	72.64	100.0
2017-08-02 06:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	100.0
2017-08-02 07:00:00	MSFT	Stock	72.5	72.63	72.5	72.63	16843.0
2017-08-02 08:00:00	MSFT	Stock	72.61	72.72	72.57	72.65	19286.0
2017-08-02 09:00:00	MSFT	Stock	72.72	72.75	72.15	72.21	3090351.0
2017-08-02 10:00:00	MSFT	Stock	72.21	72.3	71.69	71.75	4678857.0
2017-08-02 11:00:00	MSFT	Stock	71.75	71.84	71.58	71.644	3136294.0
2017-08-02 12:00:00	MSFT	Stock	71.65	71.7	71.46	71.54	2243996.0
2017-08-02 13:00:00	MSFT	Stock	71.545	72.15	71.445	72.05	2993614.0
2017-08-02 14:00:00	MSFT	Stock	72.05	72.26	71.99	72.2	2225117.0
2017-08-02 15:00:00	MSFT	Stock	72.2	72.41	72.025	72.245	4349948.0
2017-08-02 16:00:00	MSFT	Stock	72.25	72.26	72.15	72.26	2305058.0
2017-08-02 17:00:00	MSFT	Stock	72.26	72.38	72.26	72.26	3895.0
2017-08-02 18:00:00	MSFT	Stock	72.3	72.35	72.29	72.29	3400.0
2017-08-02 19:00:00	MSFT	Stock	72.29	72.29	72.29	72.29	3100.0
2017-08-02 04:00:00	NVDA	Stock	4.1462	4.15	4.146	4.15	84800.0
2017-08-02 05:00:00	NVDA	Stock	4.1462	4.1462	4.1375	4.1375	88760.0
2017-08-02 06:00:00	NVDA	Stock	4.138	4.149	4.1375	4.1438	157000.0
2017-08-02 07:00:00	NVDA	Stock	4.1462	4.1468	4.13	4.1412	259520.0
2017-08-02 08:00:00	NVDA	Stock	4.1425	4.146	4.1338	4.14	494480.0
2017-08-02 09:00:00	NVDA	Stock	4.1375	4.1478	4.0923	4.1091	87007920.0
2017-08-02 10:00:00	NVDA	Stock	4.1096	4.1162	4.0365	4.0522	91335760.0
2017-08-02 11:00:00	NVDA	Stock	4.053	4.0703	4.0318	4.0566	56262280.0
2017-08-02 12:00:00	NVDA	Stock	4.0568	4.068	4.05	4.0662	23997640.0
2017-08-02 13:00:00	NVDA	Stock	4.0658	4.1005	4.0513	4.0951	43939520.0
2017-08-02 14:00:00	NVDA	Stock	4.0945	4.1182	4.0878	4.1142	54462440.0
2017-08-02 15:00:00	NVDA	Stock	4.1143	4.1215	4.0925	4.1068	58792720.0
2017-08-02 16:00:00	NVDA	Stock	4.1098	4.1098	4.0875	4.1068	14296520.0
2017-08-02 17:00:00	NVDA	Stock	4.1072	4.1222	4.1005	4.1162	1036600.0
2017-08-02 18:00:00	NVDA	Stock	4.12	4.1212	4.1098	4.12	12046240.0
2017-08-02 19:00:00	NVDA	Stock	4.1185	4.1215	4.1155	4.12	332200.0
2017-08-02 04:00:00	AMZN	Stock	50.15	50.15	50.15	50.15	2000.0
2017-08-02 06:00:00	AMZN	Stock	50.155	50.185	50.1	50.1	34220.0

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

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