PREVIEW / stock_1hour / 2018-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-20.parquet
  size:    1.1 MB
  rows:    49,526
  symbols: 2,891

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-02-20 04:00:00	AAPL	Stock	42.775	42.9	42.7	42.7	42368.0
2018-02-20 05:00:00	AAPL	Stock	42.7	42.7	42.545	42.675	123464.0
2018-02-20 06:00:00	AAPL	Stock	42.725	42.7475	42.6475	42.7475	100004.0
2018-02-20 07:00:00	AAPL	Stock	42.7475	42.935	42.725	42.9225	349820.0
2018-02-20 08:00:00	AAPL	Stock	42.915	43.0625	42.735	42.955	956596.0
2018-02-20 09:00:00	AAPL	Stock	42.9875	43.26	42.88	43.215	18796852.0
2018-02-20 10:00:00	AAPL	Stock	43.2175	43.5	43.175	43.3575	20857192.0
2018-02-20 11:00:00	AAPL	Stock	43.36	43.565	43.337	43.5138	13422296.0
2018-02-20 12:00:00	AAPL	Stock	43.5175	43.56	43.42	43.4425	9009612.0
2018-02-20 13:00:00	AAPL	Stock	43.4425	43.5425	43.3325	43.53	9122536.0
2018-02-20 14:00:00	AAPL	Stock	43.53	43.5375	42.8675	43.1475	13597048.0
2018-02-20 15:00:00	AAPL	Stock	43.1525	43.195	42.855	42.9625	25717684.0
2018-02-20 16:00:00	AAPL	Stock	42.9725	43.3478	42.925	42.935	11423828.0
2018-02-20 17:00:00	AAPL	Stock	42.95	42.9825	42.9325	42.9325	166384.0
2018-02-20 18:00:00	AAPL	Stock	42.935	43.0	42.9125	42.9925	52596.0
2018-02-20 19:00:00	AAPL	Stock	42.97	43.0625	42.97	43.0575	44584.0
2018-02-20 04:00:00	MSFT	Stock	92.0	92.0	91.3	91.35	7244.0
2018-02-20 05:00:00	MSFT	Stock	91.35	91.35	91.35	91.35	500.0
2018-02-20 06:00:00	MSFT	Stock	91.45	91.54	91.45	91.5	3305.0
2018-02-20 07:00:00	MSFT	Stock	91.67	91.67	91.5	91.5	6372.0
2018-02-20 08:00:00	MSFT	Stock	91.5	91.65	91.42	91.54	11934.0
2018-02-20 09:00:00	MSFT	Stock	91.59	92.32	91.01	92.11	3210337.0
2018-02-20 10:00:00	MSFT	Stock	92.1	92.42	91.95	92.2	3285039.0
2018-02-20 11:00:00	MSFT	Stock	92.2	92.82	92.17	92.775	2347218.0
2018-02-20 12:00:00	MSFT	Stock	92.77	93.02	92.73	92.989	1549658.0
2018-02-20 13:00:00	MSFT	Stock	92.99	93.02	92.657	92.96	1751785.0
2018-02-20 14:00:00	MSFT	Stock	92.955	93.06	92.511	92.519	2343927.0
2018-02-20 15:00:00	MSFT	Stock	92.52	92.91	92.08	92.72	4644896.0
2018-02-20 16:00:00	MSFT	Stock	92.72	93.64	92.72	92.75	8775178.0
2018-02-20 17:00:00	MSFT	Stock	92.75	92.86	92.74	92.76	6605.0
2018-02-20 18:00:00	MSFT	Stock	92.76	92.76	92.62	92.71	35622.0
2018-02-20 19:00:00	MSFT	Stock	92.9	92.9	92.77	92.77	550.0
2018-02-20 04:00:00	NVDA	Stock	6.095	6.1	6.0482	6.0482	166560.0
2018-02-20 05:00:00	NVDA	Stock	6.0375	6.0375	6.025	6.0375	59720.0
2018-02-20 06:00:00	NVDA	Stock	6.0428	6.0723	6.0252	6.0723	290600.0
2018-02-20 07:00:00	NVDA	Stock	6.0688	6.0963	6.0575	6.0875	548680.0
2018-02-20 08:00:00	NVDA	Stock	6.08	6.1633	6.0675	6.1363	1515000.0
2018-02-20 09:00:00	NVDA	Stock	6.1283	6.2375	6.115	6.2085	102252080.0
2018-02-20 10:00:00	NVDA	Stock	6.2075	6.2623	6.055	6.235	121278960.0
2018-02-20 11:00:00	NVDA	Stock	6.2342	6.2968	6.23	6.287	79750880.0
2018-02-20 12:00:00	NVDA	Stock	6.288	6.289	6.2475	6.2654	39914480.0
2018-02-20 13:00:00	NVDA	Stock	6.265	6.2922	6.2428	6.28	46372400.0
2018-02-20 14:00:00	NVDA	Stock	6.2808	6.2812	6.2162	6.2284	46891280.0
2018-02-20 15:00:00	NVDA	Stock	6.2298	6.2392	6.1675	6.2268	98792720.0
2018-02-20 16:00:00	NVDA	Stock	6.227	6.234	6.2145	6.2275	8876080.0
2018-02-20 17:00:00	NVDA	Stock	6.227	6.233	6.2243	6.225	135280.0
2018-02-20 18:00:00	NVDA	Stock	6.2245	6.232	6.2243	6.232	250880.0
2018-02-20 19:00:00	NVDA	Stock	6.2275	6.2468	6.2275	6.246	343680.0
2018-02-20 05:00:00	AMZN	Stock	72.013	72.013	71.5	71.674	188040.0
2018-02-20 06:00:00	AMZN	Stock	71.65	71.7	71.62	71.6895	31140.0

> showing 50 of 49,526 rows — these rows as CSV

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