PREVIEW / stock_1hour / 2018-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-02.parquet
  size:    1.1 MB
  rows:    49,432
  symbols: 2,841

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-05-02 04:00:00	AAPL	Stock	43.59	43.825	43.4525	43.455	338052.0
2018-05-02 05:00:00	AAPL	Stock	43.4875	43.765	43.415	43.7325	147680.0
2018-05-02 06:00:00	AAPL	Stock	43.7375	43.75	43.55	43.685	132352.0
2018-05-02 07:00:00	AAPL	Stock	43.6825	44.24	43.6575	44.22	2320040.0
2018-05-02 08:00:00	AAPL	Stock	44.11	44.3125	43.675	43.9475	5591144.0
2018-05-02 09:00:00	AAPL	Stock	43.925	44.0225	43.45	43.865	66190780.0
2018-05-02 10:00:00	AAPL	Stock	43.865	44.1875	43.865	43.975	37269000.0
2018-05-02 11:00:00	AAPL	Stock	43.9775	44.15	43.8025	43.9975	24394384.0
2018-05-02 12:00:00	AAPL	Stock	43.9925	44.1875	43.94	44.0575	18378340.0
2018-05-02 13:00:00	AAPL	Stock	44.056	44.25	44.041	44.2465	13844624.0
2018-05-02 14:00:00	AAPL	Stock	44.2475	44.4375	44.2175	44.3578	25975688.0
2018-05-02 15:00:00	AAPL	Stock	44.3625	44.4125	44.025	44.155	31528268.0
2018-05-02 16:00:00	AAPL	Stock	44.16	44.19	44.0675	44.0925	10267320.0
2018-05-02 17:00:00	AAPL	Stock	44.11	44.1425	44.09	44.1375	70012.0
2018-05-02 18:00:00	AAPL	Stock	44.13	44.15	44.125	44.1475	67196.0
2018-05-02 19:00:00	AAPL	Stock	44.135	44.1725	44.125	44.125	97912.0
2018-05-02 04:00:00	MSFT	Stock	95.05	95.3	95.05	95.25	920.0
2018-05-02 05:00:00	MSFT	Stock	95.29	95.58	95.29	95.58	3620.0
2018-05-02 07:00:00	MSFT	Stock	95.31	95.35	95.0	95.0	14400.0
2018-05-02 08:00:00	MSFT	Stock	95.2	95.4	94.71	94.87	46025.0
2018-05-02 09:00:00	MSFT	Stock	94.92	95.17	94.26	94.29	2637411.0
2018-05-02 10:00:00	MSFT	Stock	94.3	94.65	94.01	94.15	3377422.0
2018-05-02 11:00:00	MSFT	Stock	94.15	94.33	93.43	93.805	3197025.0
2018-05-02 12:00:00	MSFT	Stock	93.8	94.28	93.62	94.05	2341784.0
2018-05-02 13:00:00	MSFT	Stock	94.05	94.479	94.03	94.14	1697123.0
2018-05-02 14:00:00	MSFT	Stock	94.145	94.79	93.9	94.0	2681415.0
2018-05-02 15:00:00	MSFT	Stock	94.01	94.36	93.19	93.51	5833093.0
2018-05-02 16:00:00	MSFT	Stock	93.51	93.6	93.11	93.11	3351687.0
2018-05-02 17:00:00	MSFT	Stock	93.16	93.49	93.12	93.45	9860.0
2018-05-02 18:00:00	MSFT	Stock	93.33	93.51	93.33	93.44	2328.0
2018-05-02 19:00:00	MSFT	Stock	93.33	93.5	93.33	93.45	3005.0
2018-05-02 05:00:00	NVDA	Stock	5.71	5.71	5.71	5.71	12000.0
2018-05-02 06:00:00	NVDA	Stock	5.7025	5.7025	5.7025	5.7025	7800.0
2018-05-02 07:00:00	NVDA	Stock	5.7095	5.7198	5.6888	5.69	127400.0
2018-05-02 08:00:00	NVDA	Stock	5.7	5.7	5.6628	5.6675	610200.0
2018-05-02 09:00:00	NVDA	Stock	5.6688	5.7083	5.6313	5.6778	39363280.0
2018-05-02 10:00:00	NVDA	Stock	5.6768	5.717	5.6735	5.6855	39808760.0
2018-05-02 11:00:00	NVDA	Stock	5.6872	5.6971	5.6425	5.6631	30822440.0
2018-05-02 12:00:00	NVDA	Stock	5.663	5.6803	5.6553	5.676	15783760.0
2018-05-02 13:00:00	NVDA	Stock	5.6773	5.691	5.674	5.6788	12266120.0
2018-05-02 14:00:00	NVDA	Stock	5.6805	5.72	5.6738	5.6898	41361760.0
2018-05-02 15:00:00	NVDA	Stock	5.6908	5.7055	5.6478	5.6578	50241400.0
2018-05-02 16:00:00	NVDA	Stock	5.6578	5.67	5.6388	5.6388	2561680.0
2018-05-02 17:00:00	NVDA	Stock	5.6475	5.6535	5.644	5.6488	147080.0
2018-05-02 18:00:00	NVDA	Stock	5.6455	5.6578	5.6423	5.6475	369880.0
2018-05-02 19:00:00	NVDA	Stock	5.65	5.65	5.6425	5.6425	195680.0
2018-05-02 04:00:00	AMZN	Stock	79.65	79.65	79.6	79.6	5280.0
2018-05-02 05:00:00	AMZN	Stock	79.5785	79.6	79.575	79.6	19540.0
2018-05-02 06:00:00	AMZN	Stock	79.6	79.6	79.6	79.6	2000.0
2018-05-02 07:00:00	AMZN	Stock	79.35	79.475	79.242	79.25	109240.0

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

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