PREVIEW / stock_1hour / 2017-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-16.parquet
  size:    1.0 MB
  rows:    48,242
  symbols: 3,089

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-03-16 04:00:00	AAPL	Stock	35.1875	35.245	35.1875	35.225	9988.0
2017-03-16 05:00:00	AAPL	Stock	35.22	35.25	35.21	35.21	19268.0
2017-03-16 06:00:00	AAPL	Stock	35.2225	35.2225	35.175	35.1875	26592.0
2017-03-16 07:00:00	AAPL	Stock	35.1875	35.2	35.1725	35.1875	63684.0
2017-03-16 08:00:00	AAPL	Stock	35.185	35.2	35.115	35.155	380184.0
2017-03-16 09:00:00	AAPL	Stock	35.17	35.255	35.105	35.1925	14860604.0
2017-03-16 10:00:00	AAPL	Stock	35.1927	35.2225	35.0875	35.1358	11250192.0
2017-03-16 11:00:00	AAPL	Stock	35.135	35.1505	35.065	35.1425	7870956.0
2017-03-16 12:00:00	AAPL	Stock	35.145	35.215	35.13	35.2	7374412.0
2017-03-16 13:00:00	AAPL	Stock	35.2025	35.2025	35.13	35.1602	5274816.0
2017-03-16 14:00:00	AAPL	Stock	35.16	35.1975	35.115	35.125	5206988.0
2017-03-16 15:00:00	AAPL	Stock	35.125	35.1825	35.095	35.1725	11728168.0
2017-03-16 16:00:00	AAPL	Stock	35.1725	35.1825	35.125	35.18	4754852.0
2017-03-16 17:00:00	AAPL	Stock	35.175	35.175	35.04	35.1725	189668.0
2017-03-16 18:00:00	AAPL	Stock	35.16	35.17	35.15	35.15	4016.0
2017-03-16 19:00:00	AAPL	Stock	35.1625	35.165	35.145	35.1525	32204.0
2017-03-16 04:00:00	MSFT	Stock	64.98	64.98	64.98	64.98	351.0
2017-03-16 05:00:00	MSFT	Stock	64.97	64.97	64.97	64.97	600.0
2017-03-16 07:00:00	MSFT	Stock	64.86	64.86	64.86	64.86	200.0
2017-03-16 08:00:00	MSFT	Stock	64.9	64.94	64.75	64.91	4208.0
2017-03-16 09:00:00	MSFT	Stock	64.92	64.92	64.53	64.55	2974514.0
2017-03-16 10:00:00	MSFT	Stock	64.55	64.595	64.3	64.41	3245269.0
2017-03-16 11:00:00	MSFT	Stock	64.41	64.48	64.32	64.46	2067522.0
2017-03-16 12:00:00	MSFT	Stock	64.455	64.67	64.44	64.55	2386279.0
2017-03-16 13:00:00	MSFT	Stock	64.56	64.565	64.45	64.54	1131242.0
2017-03-16 14:00:00	MSFT	Stock	64.54	64.57	64.37	64.386	1439485.0
2017-03-16 15:00:00	MSFT	Stock	64.38	64.65	64.34	64.64	3954544.0
2017-03-16 16:00:00	MSFT	Stock	64.64	64.64	64.6	64.64	1968540.0
2017-03-16 17:00:00	MSFT	Stock	64.63	64.63	64.63	64.63	485.0
2017-03-16 18:00:00	MSFT	Stock	64.63	64.65	64.63	64.63	3696.0
2017-03-16 19:00:00	MSFT	Stock	64.69	64.69	64.57	64.57	740.0
2017-03-16 05:00:00	NVDA	Stock	2.5712	2.575	2.5712	2.575	42720.0
2017-03-16 06:00:00	NVDA	Stock	2.5825	2.5875	2.5825	2.5872	143880.0
2017-03-16 07:00:00	NVDA	Stock	2.5872	2.5872	2.5765	2.5813	80600.0
2017-03-16 08:00:00	NVDA	Stock	2.5775	2.5885	2.5638	2.57	899360.0
2017-03-16 09:00:00	NVDA	Stock	2.572	2.59	2.5602	2.575	95514560.0
2017-03-16 10:00:00	NVDA	Stock	2.575	2.589	2.5723	2.5822	84579040.0
2017-03-16 11:00:00	NVDA	Stock	2.5822	2.5832	2.5658	2.5818	62711800.0
2017-03-16 12:00:00	NVDA	Stock	2.5815	2.5898	2.577	2.582	70522040.0
2017-03-16 13:00:00	NVDA	Stock	2.582	2.5872	2.571	2.5845	42633520.0
2017-03-16 14:00:00	NVDA	Stock	2.5847	2.592	2.5843	2.5892	52844480.0
2017-03-16 15:00:00	NVDA	Stock	2.5895	2.5958	2.5872	2.5952	94259880.0
2017-03-16 16:00:00	NVDA	Stock	2.5952	2.5975	2.5938	2.5965	1207920.0
2017-03-16 17:00:00	NVDA	Stock	2.5975	2.6212	2.5975	2.62	763280.0
2017-03-16 18:00:00	NVDA	Stock	2.6175	2.625	2.615	2.624	2383800.0
2017-03-16 19:00:00	NVDA	Stock	2.6242	2.6275	2.6233	2.6272	517440.0
2017-03-16 06:00:00	AMZN	Stock	42.865	42.865	42.865	42.865	2720.0
2017-03-16 07:00:00	AMZN	Stock	42.865	42.865	42.8385	42.8385	4140.0
2017-03-16 08:00:00	AMZN	Stock	42.773	42.8125	42.6485	42.8	183240.0
2017-03-16 09:00:00	AMZN	Stock	42.8	42.8	42.645	42.7	4943000.0

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

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