PREVIEW / stock_1hour / 2016-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-08.parquet
  size:    1.0 MB
  rows:    48,052
  symbols: 3,334

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
2016-04-08 04:00:00	AAPL	Stock	27.335	27.3425	27.2825	27.3075	3440.0
2016-04-08 06:00:00	AAPL	Stock	27.3	27.3425	27.3	27.3425	3808.0
2016-04-08 07:00:00	AAPL	Stock	27.35	27.375	27.31	27.35	79688.0
2016-04-08 08:00:00	AAPL	Stock	27.35	27.405	27.3125	27.375	396184.0
2016-04-08 09:00:00	AAPL	Stock	27.375	27.3875	27.17	27.36	14718976.0
2016-04-08 10:00:00	AAPL	Stock	27.3575	27.4425	27.3375	27.3475	14909040.0
2016-04-08 11:00:00	AAPL	Stock	27.3472	27.375	27.175	27.245	12259720.0
2016-04-08 12:00:00	AAPL	Stock	27.245	27.25	27.06	27.2025	9879608.0
2016-04-08 13:00:00	AAPL	Stock	27.2025	27.21	27.0525	27.21	7756452.0
2016-04-08 14:00:00	AAPL	Stock	27.2102	27.25	27.1475	27.175	6516308.0
2016-04-08 15:00:00	AAPL	Stock	27.1762	27.182	27.0425	27.165	13873732.0
2016-04-08 16:00:00	AAPL	Stock	27.165	27.22	27.1208	27.16	6320436.0
2016-04-08 17:00:00	AAPL	Stock	27.1475	27.16	27.1475	27.1475	18588.0
2016-04-08 18:00:00	AAPL	Stock	27.1475	27.175	27.145	27.1525	30816.0
2016-04-08 19:00:00	AAPL	Stock	27.1525	27.16	27.1425	27.1425	70756.0
2016-04-08 04:00:00	MSFT	Stock	54.63	54.63	54.63	54.63	200.0
2016-04-08 06:00:00	MSFT	Stock	54.87	54.87	54.87	54.87	200.0
2016-04-08 07:00:00	MSFT	Stock	54.76	54.78	54.6	54.64	1041.0
2016-04-08 08:00:00	MSFT	Stock	54.76	54.93	54.73	54.86	16140.0
2016-04-08 09:00:00	MSFT	Stock	54.86	55.16	54.67	55.12	2310074.0
2016-04-08 10:00:00	MSFT	Stock	55.139	55.28	54.835	54.84	3132563.0
2016-04-08 11:00:00	MSFT	Stock	54.84	55.05	54.73	54.83	2051044.0
2016-04-08 12:00:00	MSFT	Stock	54.822	54.875	54.49	54.59	2167467.0
2016-04-08 13:00:00	MSFT	Stock	54.58	54.595	54.39	54.56	2443948.0
2016-04-08 14:00:00	MSFT	Stock	54.57	54.71	54.39	54.52	2262319.0
2016-04-08 15:00:00	MSFT	Stock	54.52	54.53	54.32	54.42	4370148.0
2016-04-08 16:00:00	MSFT	Stock	54.42	54.46	54.42	54.46	2089261.0
2016-04-08 17:00:00	MSFT	Stock	54.4	54.51	54.4	54.4	2400.0
2016-04-08 18:00:00	MSFT	Stock	54.4	54.4	54.39	54.39	1000.0
2016-04-08 07:00:00	NVDA	Stock	0.8922	0.8925	0.8922	0.8922	28000.0
2016-04-08 08:00:00	NVDA	Stock	0.8922	0.8925	0.8922	0.8925	24000.0
2016-04-08 09:00:00	NVDA	Stock	0.8945	0.896	0.8902	0.8953	19639240.0
2016-04-08 10:00:00	NVDA	Stock	0.8953	0.8988	0.8912	0.8914	31465720.0
2016-04-08 11:00:00	NVDA	Stock	0.8914	0.896	0.8879	0.8912	37310440.0
2016-04-08 12:00:00	NVDA	Stock	0.891	0.8912	0.8826	0.8893	31242360.0
2016-04-08 13:00:00	NVDA	Stock	0.8892	0.8925	0.886	0.8925	36264080.0
2016-04-08 14:00:00	NVDA	Stock	0.8926	0.8948	0.8916	0.8932	32111240.0
2016-04-08 15:00:00	NVDA	Stock	0.893	0.8932	0.8884	0.8915	41591240.0
2016-04-08 16:00:00	NVDA	Stock	0.8915	0.8928	0.8915	0.8928	15635560.0
2016-04-08 17:00:00	NVDA	Stock	0.8935	0.8935	0.8935	0.8935	6000.0
2016-04-08 07:00:00	AMZN	Stock	29.7155	29.763	29.7155	29.7625	42660.0
2016-04-08 08:00:00	AMZN	Stock	29.875	29.875	29.73	29.83	184640.0
2016-04-08 09:00:00	AMZN	Stock	29.8385	29.8495	29.584	29.7774	7252000.0
2016-04-08 10:00:00	AMZN	Stock	29.795	29.893	29.689	29.689	7734920.0
2016-04-08 11:00:00	AMZN	Stock	29.687	29.723	29.55	29.649	4816120.0
2016-04-08 12:00:00	AMZN	Stock	29.639	29.6595	29.45	29.633	5571980.0
2016-04-08 13:00:00	AMZN	Stock	29.6215	29.7285	29.55	29.7285	4283640.0
2016-04-08 14:00:00	AMZN	Stock	29.7315	29.822	29.6655	29.696	6189740.0
2016-04-08 15:00:00	AMZN	Stock	29.6915	29.7425	29.618	29.73	8320900.0
2016-04-08 16:00:00	AMZN	Stock	29.73	29.73	29.6815	29.725	328980.0

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

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