PREVIEW / stock_1hour / 2018-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-06.parquet
  size:    1.1 MB
  rows:    48,128
  symbols: 2,840

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-06 04:00:00	AAPL	Stock	42.7025	42.7875	42.6275	42.75	19572.0
2018-04-06 05:00:00	AAPL	Stock	42.75	42.8075	42.7	42.8075	9496.0
2018-04-06 06:00:00	AAPL	Stock	42.825	42.85	42.755	42.755	31172.0
2018-04-06 07:00:00	AAPL	Stock	42.76	42.8	42.5175	42.5525	256768.0
2018-04-06 08:00:00	AAPL	Stock	42.575	42.8675	42.5375	42.8	660228.0
2018-04-06 09:00:00	AAPL	Stock	42.8	43.12	42.6	43.0275	14112688.0
2018-04-06 10:00:00	AAPL	Stock	43.0275	43.06	42.58	42.6682	15953648.0
2018-04-06 11:00:00	AAPL	Stock	42.665	42.7645	42.4325	42.72	13478244.0
2018-04-06 12:00:00	AAPL	Stock	42.7225	42.8225	42.4875	42.805	8727308.0
2018-04-06 13:00:00	AAPL	Stock	42.7975	42.7975	42.27	42.28	10766836.0
2018-04-06 14:00:00	AAPL	Stock	42.275	42.395	42.1	42.185	17066084.0
2018-04-06 15:00:00	AAPL	Stock	42.19	42.3075	42.05	42.0875	27425880.0
2018-04-06 16:00:00	AAPL	Stock	42.095	42.17	42.0925	42.1625	12829000.0
2018-04-06 17:00:00	AAPL	Stock	42.16	42.17	42.105	42.1175	86712.0
2018-04-06 18:00:00	AAPL	Stock	42.1325	42.1325	42.0625	42.1125	106468.0
2018-04-06 19:00:00	AAPL	Stock	42.095	42.145	42.0925	42.1225	48324.0
2018-04-06 04:00:00	MSFT	Stock	90.8	91.4	90.8	91.4	300.0
2018-04-06 05:00:00	MSFT	Stock	91.5	91.5	91.5	91.5	373.0
2018-04-06 06:00:00	MSFT	Stock	91.75	91.89	91.75	91.89	1273.0
2018-04-06 07:00:00	MSFT	Stock	91.65	91.65	91.29	91.3	4312.0
2018-04-06 08:00:00	MSFT	Stock	91.7	91.95	91.15	91.78	56378.0
2018-04-06 09:00:00	MSFT	Stock	91.78	92.46	91.17	92.22	2378266.0
2018-04-06 10:00:00	MSFT	Stock	92.22	92.41	91.39	91.58	3206861.0
2018-04-06 11:00:00	MSFT	Stock	91.58	92.06	91.185	91.955	2994260.0
2018-04-06 12:00:00	MSFT	Stock	91.95	92.04	91.16	91.98	2335850.0
2018-04-06 13:00:00	MSFT	Stock	91.97	91.975	90.1	90.4	3202172.0
2018-04-06 14:00:00	MSFT	Stock	90.4	90.58	89.48	89.754	4364947.0
2018-04-06 15:00:00	MSFT	Stock	89.76	90.7	89.5	90.22	9391309.0
2018-04-06 16:00:00	MSFT	Stock	90.23	90.3	90.0	90.28	6491070.0
2018-04-06 17:00:00	MSFT	Stock	90.28	90.28	89.98	90.0	13783.0
2018-04-06 18:00:00	MSFT	Stock	90.22	90.22	90.0	90.05	6579.0
2018-04-06 19:00:00	MSFT	Stock	90.05	90.05	90.05	90.05	898.0
2018-04-06 04:00:00	NVDA	Stock	5.428	5.4725	5.428	5.4525	51840.0
2018-04-06 05:00:00	NVDA	Stock	5.4423	5.4525	5.4423	5.4525	23160.0
2018-04-06 06:00:00	NVDA	Stock	5.4623	5.4752	5.4623	5.4625	89000.0
2018-04-06 07:00:00	NVDA	Stock	5.4503	5.455	5.4312	5.4312	1369480.0
2018-04-06 08:00:00	NVDA	Stock	5.4469	5.48	5.429	5.4695	3904760.0
2018-04-06 09:00:00	NVDA	Stock	5.4688	5.54	5.4188	5.5181	95644040.0
2018-04-06 10:00:00	NVDA	Stock	5.5178	5.5245	5.3903	5.4145	111238920.0
2018-04-06 11:00:00	NVDA	Stock	5.4128	5.4842	5.3918	5.4688	71555640.0
2018-04-06 12:00:00	NVDA	Stock	5.468	5.4842	5.4178	5.434	49040760.0
2018-04-06 13:00:00	NVDA	Stock	5.432	5.443	5.365	5.368	72812320.0
2018-04-06 14:00:00	NVDA	Stock	5.3675	5.4112	5.3288	5.339	92370240.0
2018-04-06 15:00:00	NVDA	Stock	5.343	5.3863	5.3268	5.3543	128437760.0
2018-04-06 16:00:00	NVDA	Stock	5.3562	5.4136	5.3475	5.359	5311600.0
2018-04-06 17:00:00	NVDA	Stock	5.3565	5.3623	5.3515	5.3515	178640.0
2018-04-06 18:00:00	NVDA	Stock	5.3525	5.3525	5.3288	5.3435	186320.0
2018-04-06 19:00:00	NVDA	Stock	5.345	5.35	5.3388	5.3405	211160.0
2018-04-06 05:00:00	AMZN	Stock	71.576	71.576	71.576	71.576	2000.0
2018-04-06 06:00:00	AMZN	Stock	71.675	71.708	71.675	71.7005	22620.0

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

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