PREVIEW / stock_1hour / 2018-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-11.parquet
  size:    1.1 MB
  rows:    48,842
  symbols: 2,862

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-04-11 04:00:00	AAPL	Stock	43.125	43.125	43.125	43.125	4000.0
2018-04-11 05:00:00	AAPL	Stock	43.125	43.145	43.125	43.125	4388.0
2018-04-11 06:00:00	AAPL	Stock	43.1125	43.1125	42.915	42.9525	49796.0
2018-04-11 07:00:00	AAPL	Stock	42.9675	43.025	42.8775	42.99	204620.0
2018-04-11 08:00:00	AAPL	Stock	43.0	43.075	42.9	43.005	321696.0
2018-04-11 09:00:00	AAPL	Stock	43.01	43.1825	42.925	43.17	13099704.0
2018-04-11 10:00:00	AAPL	Stock	43.165	43.3115	43.025	43.1908	12191212.0
2018-04-11 11:00:00	AAPL	Stock	43.1875	43.3725	43.065	43.3112	9156792.0
2018-04-11 12:00:00	AAPL	Stock	43.31	43.4808	43.1725	43.25	8442816.0
2018-04-11 13:00:00	AAPL	Stock	43.25	43.35	43.1525	43.3177	6817932.0
2018-04-11 14:00:00	AAPL	Stock	43.32	43.41	43.2148	43.2975	9300780.0
2018-04-11 15:00:00	AAPL	Stock	43.2975	43.3225	43.0125	43.11	13672680.0
2018-04-11 16:00:00	AAPL	Stock	43.1125	43.125	43.0625	43.0875	5191592.0
2018-04-11 17:00:00	AAPL	Stock	43.1025	43.1125	43.09	43.1125	4760.0
2018-04-11 18:00:00	AAPL	Stock	43.1125	43.2	43.1025	43.2	44476.0
2018-04-11 19:00:00	AAPL	Stock	43.1875	43.2075	43.1375	43.18	48836.0
2018-04-11 04:00:00	MSFT	Stock	92.27	92.27	92.27	92.27	100.0
2018-04-11 05:00:00	MSFT	Stock	92.5	92.5	92.49	92.5	2119.0
2018-04-11 06:00:00	MSFT	Stock	92.19	92.29	92.06	92.29	5972.0
2018-04-11 07:00:00	MSFT	Stock	92.28	92.3	91.65	92.16	17887.0
2018-04-11 08:00:00	MSFT	Stock	92.14	93.08	91.67	92.09	26531.0
2018-04-11 09:00:00	MSFT	Stock	92.09	92.55	91.76	92.21	3434176.0
2018-04-11 10:00:00	MSFT	Stock	92.2	92.99	92.08	92.465	3113405.0
2018-04-11 11:00:00	MSFT	Stock	92.47	93.12	92.22	92.89	2240143.0
2018-04-11 12:00:00	MSFT	Stock	92.89	93.29	92.38	92.45	2130424.0
2018-04-11 13:00:00	MSFT	Stock	92.46	92.7	91.95	92.36	2372739.0
2018-04-11 14:00:00	MSFT	Stock	92.36	92.63	91.86	92.05	2369965.0
2018-04-11 15:00:00	MSFT	Stock	92.05	92.17	91.48	91.87	4469719.0
2018-04-11 16:00:00	MSFT	Stock	91.86	92.072	91.77	91.84	1952091.0
2018-04-11 17:00:00	MSFT	Stock	91.9	91.99	91.9	91.99	2008.0
2018-04-11 18:00:00	MSFT	Stock	91.86	91.99	91.86	91.99	3665.0
2018-04-11 19:00:00	MSFT	Stock	91.99	92.2	91.92	92.05	14886.0
2018-04-11 04:00:00	NVDA	Stock	5.7	5.7	5.6668	5.6668	60000.0
2018-04-11 05:00:00	NVDA	Stock	5.6715	5.6715	5.6715	5.6715	4000.0
2018-04-11 06:00:00	NVDA	Stock	5.6675	5.6763	5.6403	5.6575	404160.0
2018-04-11 07:00:00	NVDA	Stock	5.6675	5.675	5.6412	5.6693	2334280.0
2018-04-11 08:00:00	NVDA	Stock	5.655	5.71	5.6425	5.665	2117200.0
2018-04-11 09:00:00	NVDA	Stock	5.6625	5.7244	5.623	5.6829	83538000.0
2018-04-11 10:00:00	NVDA	Stock	5.6818	5.7165	5.6443	5.6602	65974720.0
2018-04-11 11:00:00	NVDA	Stock	5.6612	5.7042	5.6445	5.6944	35899120.0
2018-04-11 12:00:00	NVDA	Stock	5.6935	5.7175	5.6672	5.678	29602240.0
2018-04-11 13:00:00	NVDA	Stock	5.6782	5.6955	5.6675	5.6925	24647640.0
2018-04-11 14:00:00	NVDA	Stock	5.6928	5.7075	5.6638	5.6778	38860960.0
2018-04-11 15:00:00	NVDA	Stock	5.681	5.6838	5.6313	5.656	49653880.0
2018-04-11 16:00:00	NVDA	Stock	5.6555	5.6748	5.6485	5.6585	19666440.0
2018-04-11 17:00:00	NVDA	Stock	5.6553	5.6562	5.6548	5.6562	250640.0
2018-04-11 18:00:00	NVDA	Stock	5.6588	5.668	5.656	5.668	327240.0
2018-04-11 19:00:00	NVDA	Stock	5.668	5.6888	5.668	5.6888	382880.0
2018-04-11 04:00:00	AMZN	Stock	71.5955	71.5955	71.5955	71.5955	4100.0
2018-04-11 06:00:00	AMZN	Stock	71.35	71.35	71.35	71.35	4760.0

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

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