PREVIEW / stock_1hour / 2017-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-24.parquet
  size:    1.0 MB
  rows:    47,049
  symbols: 3,052

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-24 04:00:00	AAPL	Stock	35.2675	35.285	35.2675	35.285	1600.0
2017-03-24 06:00:00	AAPL	Stock	35.3075	35.3375	35.2875	35.2875	6328.0
2017-03-24 07:00:00	AAPL	Stock	35.315	35.3375	35.19	35.3175	137240.0
2017-03-24 08:00:00	AAPL	Stock	35.2625	35.35	35.225	35.325	138664.0
2017-03-24 09:00:00	AAPL	Stock	35.325	35.435	35.3	35.3825	12859184.0
2017-03-24 10:00:00	AAPL	Stock	35.3847	35.4075	35.315	35.3775	9765696.0
2017-03-24 11:00:00	AAPL	Stock	35.38	35.4125	35.3375	35.355	6401552.0
2017-03-24 12:00:00	AAPL	Stock	35.355	35.365	35.2375	35.3225	9114988.0
2017-03-24 13:00:00	AAPL	Stock	35.3212	35.3325	35.1895	35.1938	5896096.0
2017-03-24 14:00:00	AAPL	Stock	35.1925	35.255	35.155	35.1675	6477312.0
2017-03-24 15:00:00	AAPL	Stock	35.17	35.2875	35.0875	35.1575	21203276.0
2017-03-24 16:00:00	AAPL	Stock	35.16	35.2075	35.025	35.0575	8980176.0
2017-03-24 17:00:00	AAPL	Stock	35.05	35.085	35.0125	35.085	209576.0
2017-03-24 18:00:00	AAPL	Stock	35.0825	35.12	35.0825	35.11	40356.0
2017-03-24 19:00:00	AAPL	Stock	35.11	35.11	35.0825	35.1075	50232.0
2017-03-24 04:00:00	MSFT	Stock	65.0	65.0	65.0	65.0	164.0
2017-03-24 05:00:00	MSFT	Stock	65.08	65.08	65.08	65.08	100.0
2017-03-24 08:00:00	MSFT	Stock	64.9	64.92	64.9	64.92	490.0
2017-03-24 09:00:00	MSFT	Stock	65.05	65.2	64.835	65.135	2184474.0
2017-03-24 10:00:00	MSFT	Stock	65.13	65.4	65.13	65.355	2449591.0
2017-03-24 11:00:00	MSFT	Stock	65.36	65.44	65.3	65.42	1620433.0
2017-03-24 12:00:00	MSFT	Stock	65.42	65.45	65.15	65.235	1901288.0
2017-03-24 13:00:00	MSFT	Stock	65.24	65.265	64.98	65.005	1411893.0
2017-03-24 14:00:00	MSFT	Stock	65.005	65.139	64.82	64.845	1948181.0
2017-03-24 15:00:00	MSFT	Stock	64.84	65.27	64.76	64.99	7004861.0
2017-03-24 16:00:00	MSFT	Stock	64.99	65.05	64.98	65.01	2542658.0
2017-03-24 17:00:00	MSFT	Stock	65.01	65.14	65.01	65.05	4700.0
2017-03-24 19:00:00	MSFT	Stock	65.03	65.13	65.03	65.13	300.0
2017-03-24 06:00:00	NVDA	Stock	2.6863	2.6863	2.685	2.685	8000.0
2017-03-24 07:00:00	NVDA	Stock	2.686	2.686	2.6855	2.6855	28800.0
2017-03-24 08:00:00	NVDA	Stock	2.6943	2.725	2.69	2.7232	4710600.0
2017-03-24 09:00:00	NVDA	Stock	2.7198	2.7323	2.7058	2.7176	87069120.0
2017-03-24 10:00:00	NVDA	Stock	2.7178	2.7231	2.7063	2.7122	64189960.0
2017-03-24 11:00:00	NVDA	Stock	2.7128	2.716	2.7023	2.7142	42186080.0
2017-03-24 12:00:00	NVDA	Stock	2.7142	2.7142	2.6915	2.7013	42922960.0
2017-03-24 13:00:00	NVDA	Stock	2.7015	2.7038	2.692	2.6938	22147200.0
2017-03-24 14:00:00	NVDA	Stock	2.6945	2.6978	2.6707	2.6715	35200400.0
2017-03-24 15:00:00	NVDA	Stock	2.6715	2.693	2.6605	2.6868	86527720.0
2017-03-24 16:00:00	NVDA	Stock	2.6868	2.6912	2.6868	2.6903	26407960.0
2017-03-24 17:00:00	NVDA	Stock	2.6903	2.6912	2.689	2.69	183200.0
2017-03-24 18:00:00	NVDA	Stock	2.69	2.6912	2.689	2.689	188320.0
2017-03-24 19:00:00	NVDA	Stock	2.689	2.6912	2.6868	2.6868	70880.0
2017-03-24 06:00:00	AMZN	Stock	42.475	42.475	42.475	42.475	2140.0
2017-03-24 07:00:00	AMZN	Stock	42.474	42.5625	42.474	42.5625	24540.0
2017-03-24 08:00:00	AMZN	Stock	42.5625	42.5625	42.5	42.55	69340.0
2017-03-24 09:00:00	AMZN	Stock	42.5	42.59	42.412	42.449	5763180.0
2017-03-24 10:00:00	AMZN	Stock	42.4455	42.4805	42.385	42.44	3033300.0
2017-03-24 11:00:00	AMZN	Stock	42.459	42.527	42.433	42.527	2668620.0
2017-03-24 12:00:00	AMZN	Stock	42.5215	42.5435	42.425	42.5245	3701760.0
2017-03-24 13:00:00	AMZN	Stock	42.5225	42.5276	42.413	42.4275	2462300.0

> showing 50 of 47,049 rows — these rows as CSV

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