PREVIEW / stock_1hour / 2017-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-04.parquet
  size:    1.1 MB
  rows:    50,397
  symbols: 2,937

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
2017-12-04 04:00:00	AAPL	Stock	43.0575	43.125	43.0425	43.0425	10668.0
2017-12-04 05:00:00	AAPL	Stock	43.0425	43.095	43.0425	43.095	6596.0
2017-12-04 06:00:00	AAPL	Stock	43.095	43.18	43.08	43.15	31716.0
2017-12-04 07:00:00	AAPL	Stock	43.1375	43.1825	43.09	43.125	241624.0
2017-12-04 08:00:00	AAPL	Stock	43.1	43.17	43.05	43.1125	368428.0
2017-12-04 09:00:00	AAPL	Stock	43.1225	43.155	42.8632	42.9075	15310812.0
2017-12-04 10:00:00	AAPL	Stock	42.91	42.9725	42.5325	42.6275	23913700.0
2017-12-04 11:00:00	AAPL	Stock	42.625	42.92	42.52	42.8725	13817808.0
2017-12-04 12:00:00	AAPL	Stock	42.8715	43.0475	42.7575	42.87	10818504.0
2017-12-04 13:00:00	AAPL	Stock	42.87	42.9388	42.775	42.87	6639476.0
2017-12-04 14:00:00	AAPL	Stock	42.8725	42.8725	42.58	42.725	10510520.0
2017-12-04 15:00:00	AAPL	Stock	42.725	42.745	42.4075	42.44	18711480.0
2017-12-04 16:00:00	AAPL	Stock	42.45	42.7348	42.34	42.435	15998240.0
2017-12-04 17:00:00	AAPL	Stock	42.435	42.4475	42.38	42.4225	25036.0
2017-12-04 18:00:00	AAPL	Stock	42.425	42.475	42.4075	42.435	68748.0
2017-12-04 19:00:00	AAPL	Stock	42.435	42.46	42.4	42.4	23212.0
2017-12-04 06:00:00	MSFT	Stock	84.95	85.03	84.95	85.03	540.0
2017-12-04 07:00:00	MSFT	Stock	84.91	84.91	84.67	84.7	13534.0
2017-12-04 08:00:00	MSFT	Stock	84.8	84.88	84.51	84.62	23042.0
2017-12-04 09:00:00	MSFT	Stock	84.56	84.62	83.36	83.475	3294953.0
2017-12-04 10:00:00	MSFT	Stock	83.485	83.555	82.45	82.47	4801859.0
2017-12-04 11:00:00	MSFT	Stock	82.47	82.59	81.743	81.87	4410227.0
2017-12-04 12:00:00	MSFT	Stock	81.87	82.25	81.83	82.24	3031108.0
2017-12-04 13:00:00	MSFT	Stock	82.235	82.295	82.05	82.23	2283355.0
2017-12-04 14:00:00	MSFT	Stock	82.23	82.236	80.86	81.0	4734958.0
2017-12-04 15:00:00	MSFT	Stock	81.005	81.15	80.7	81.07	9322078.0
2017-12-04 16:00:00	MSFT	Stock	81.07	81.19	81.0	81.03	3683093.0
2017-12-04 17:00:00	MSFT	Stock	81.1	81.2	81.1	81.14	19256.0
2017-12-04 18:00:00	MSFT	Stock	81.18	81.2	81.05	81.2	2541.0
2017-12-04 19:00:00	MSFT	Stock	81.2	81.2	81.16	81.2	4614.0
2017-12-04 04:00:00	NVDA	Stock	4.9988	5.0	4.996	4.996	103840.0
2017-12-04 05:00:00	NVDA	Stock	4.9838	4.992	4.9838	4.992	18400.0
2017-12-04 06:00:00	NVDA	Stock	4.9925	5.0188	4.9925	5.0188	78320.0
2017-12-04 07:00:00	NVDA	Stock	5.0075	5.0128	4.995	5.0	1353160.0
2017-12-04 08:00:00	NVDA	Stock	5.0063	5.0173	4.9913	5.01	3239320.0
2017-12-04 09:00:00	NVDA	Stock	5.0063	5.0138	4.809	4.8257	129397720.0
2017-12-04 10:00:00	NVDA	Stock	4.8257	4.8318	4.6125	4.647	379210520.0
2017-12-04 11:00:00	NVDA	Stock	4.648	4.7712	4.64	4.766	152059760.0
2017-12-04 12:00:00	NVDA	Stock	4.7661	4.785	4.7252	4.7542	101525920.0
2017-12-04 13:00:00	NVDA	Stock	4.7542	5.0	4.7252	4.7386	74956880.0
2017-12-04 14:00:00	NVDA	Stock	4.7384	4.7462	4.69	4.7022	83119560.0
2017-12-04 15:00:00	NVDA	Stock	4.7015	4.7016	4.6515	4.6664	117888800.0
2017-12-04 16:00:00	NVDA	Stock	4.6665	4.6869	4.6512	4.6553	164806000.0
2017-12-04 17:00:00	NVDA	Stock	4.6612	4.6688	4.6538	4.666	893160.0
2017-12-04 18:00:00	NVDA	Stock	4.6638	4.6675	4.6583	4.6638	602560.0
2017-12-04 19:00:00	NVDA	Stock	4.66	4.6663	4.66	4.6648	787000.0
2017-12-04 04:00:00	AMZN	Stock	58.525	58.525	58.525	58.525	4000.0
2017-12-04 05:00:00	AMZN	Stock	58.5175	58.525	58.4995	58.525	28520.0
2017-12-04 06:00:00	AMZN	Stock	58.571	58.571	58.571	58.571	3760.0
2017-12-04 07:00:00	AMZN	Stock	58.55	58.7885	58.5	58.6025	286620.0

> showing 50 of 50,397 rows — these rows as CSV

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