PREVIEW / stock_1hour / 2018-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-06.parquet
  size:    1.1 MB
  rows:    48,493
  symbols: 2,802

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-07-06 04:00:00	AAPL	Stock	46.2125	46.25	46.15	46.25	3280.0
2018-07-06 05:00:00	AAPL	Stock	46.325	46.325	46.2625	46.2625	1936.0
2018-07-06 06:00:00	AAPL	Stock	46.2875	46.2975	46.25	46.25	2488.0
2018-07-06 07:00:00	AAPL	Stock	46.275	46.3175	46.245	46.2625	58304.0
2018-07-06 08:00:00	AAPL	Stock	46.275	46.5088	46.25	46.385	226248.0
2018-07-06 09:00:00	AAPL	Stock	46.3775	46.79	46.3	46.7825	9815008.0
2018-07-06 10:00:00	AAPL	Stock	46.7825	46.805	46.505	46.6675	8732796.0
2018-07-06 11:00:00	AAPL	Stock	46.665	46.935	46.665	46.85	9104228.0
2018-07-06 12:00:00	AAPL	Stock	46.8538	46.9625	46.8475	46.92	5261152.0
2018-07-06 13:00:00	AAPL	Stock	46.92	46.9375	46.845	46.92	3283456.0
2018-07-06 14:00:00	AAPL	Stock	46.92	46.945	46.84	46.906	3475488.0
2018-07-06 15:00:00	AAPL	Stock	46.9075	47.1085	46.8625	46.995	14745872.0
2018-07-06 16:00:00	AAPL	Stock	47.055	47.1	46.9925	47.0675	7258812.0
2018-07-06 17:00:00	AAPL	Stock	47.07	47.075	47.0425	47.0625	18480.0
2018-07-06 18:00:00	AAPL	Stock	47.0625	47.0725	47.055	47.055	12416.0
2018-07-06 19:00:00	AAPL	Stock	47.04	47.0875	47.04	47.0875	17884.0
2018-07-06 04:00:00	MSFT	Stock	99.6	99.6	99.6	99.6	100.0
2018-07-06 08:00:00	MSFT	Stock	99.4	100.08	99.29	99.84	27510.0
2018-07-06 09:00:00	MSFT	Stock	99.62	100.4	99.62	100.26	1919995.0
2018-07-06 10:00:00	MSFT	Stock	100.25	100.45	100.02	100.325	2118052.0
2018-07-06 11:00:00	MSFT	Stock	100.33	101.21	100.32	101.09	2548564.0
2018-07-06 12:00:00	MSFT	Stock	101.095	101.35	101.02	101.1	1643668.0
2018-07-06 13:00:00	MSFT	Stock	101.105	101.21	101.08	101.085	798523.0
2018-07-06 14:00:00	MSFT	Stock	101.085	101.155	100.96	101.095	1162929.0
2018-07-06 15:00:00	MSFT	Stock	101.095	101.43	100.71	101.17	3722264.0
2018-07-06 16:00:00	MSFT	Stock	101.16	101.26	101.14	101.2	2743581.0
2018-07-06 17:00:00	MSFT	Stock	101.14	101.14	101.11	101.11	1023.0
2018-07-06 18:00:00	MSFT	Stock	101.11	101.16	101.1	101.16	1215.0
2018-07-06 19:00:00	MSFT	Stock	101.16	101.16	101.12	101.16	2519.0
2018-07-06 04:00:00	NVDA	Stock	6.05	6.0675	6.05	6.0675	22040.0
2018-07-06 07:00:00	NVDA	Stock	6.05	6.05	6.025	6.025	118840.0
2018-07-06 08:00:00	NVDA	Stock	6.0449	6.0742	6.025	6.05	1202320.0
2018-07-06 09:00:00	NVDA	Stock	6.04	6.0925	6.022	6.0609	38330760.0
2018-07-06 10:00:00	NVDA	Stock	6.0608	6.1205	6.0524	6.1175	42185280.0
2018-07-06 11:00:00	NVDA	Stock	6.1182	6.1745	6.1178	6.172	43836600.0
2018-07-06 12:00:00	NVDA	Stock	6.172	6.1763	6.151	6.1568	25053400.0
2018-07-06 13:00:00	NVDA	Stock	6.1558	6.172	6.1488	6.1672	17521840.0
2018-07-06 14:00:00	NVDA	Stock	6.1675	6.176	6.1575	6.1658	21184560.0
2018-07-06 15:00:00	NVDA	Stock	6.165	6.1916	6.1648	6.183	50868840.0
2018-07-06 16:00:00	NVDA	Stock	6.1833	6.1888	6.18	6.1848	19877280.0
2018-07-06 17:00:00	NVDA	Stock	6.18	6.1898	6.18	6.1895	54040.0
2018-07-06 18:00:00	NVDA	Stock	6.184	6.187	6.183	6.187	51680.0
2018-07-06 19:00:00	NVDA	Stock	6.1833	6.1865	6.1833	6.1833	143040.0
2018-07-06 04:00:00	AMZN	Stock	85.15	85.15	85.15	85.15	2000.0
2018-07-06 05:00:00	AMZN	Stock	85.05	85.05	85.05	85.05	2000.0
2018-07-06 06:00:00	AMZN	Stock	85.0	85.0	85.0	85.0	4820.0
2018-07-06 07:00:00	AMZN	Stock	84.9	84.925	84.75	84.75	60020.0
2018-07-06 08:00:00	AMZN	Stock	84.7602	85.2	84.755	84.9895	308220.0
2018-07-06 09:00:00	AMZN	Stock	84.928	85.4003	84.5835	85.329	9787100.0
2018-07-06 10:00:00	AMZN	Stock	85.3305	85.449	85.2	85.3435	7270740.0

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

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