PREVIEW / stock_1hour / 2016-01-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-14.parquet
  size:    1.1 MB
  rows:    49,846
  symbols: 3,406

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-01-14 04:00:00	AAPL	Stock	24.385	24.395	24.275	24.345	40548.0
2016-01-14 05:00:00	AAPL	Stock	24.35	24.39	24.25	24.28	47080.0
2016-01-14 06:00:00	AAPL	Stock	24.3125	24.3125	24.175	24.215	64592.0
2016-01-14 07:00:00	AAPL	Stock	24.23	24.355	24.2225	24.345	231948.0
2016-01-14 08:00:00	AAPL	Stock	24.34	24.4375	24.235	24.415	1374696.0
2016-01-14 09:00:00	AAPL	Stock	24.4175	24.505	23.94	23.995	35802696.0
2016-01-14 10:00:00	AAPL	Stock	23.9852	24.58	23.935	24.4775	49341636.0
2016-01-14 11:00:00	AAPL	Stock	24.4825	24.5825	24.3175	24.5425	22685876.0
2016-01-14 12:00:00	AAPL	Stock	24.5425	24.68	24.4325	24.6325	19135120.0
2016-01-14 13:00:00	AAPL	Stock	24.6325	24.895	24.6125	24.868	22092548.0
2016-01-14 14:00:00	AAPL	Stock	24.87	25.0438	24.8578	25.0125	28988236.0
2016-01-14 15:00:00	AAPL	Stock	25.0125	25.12	24.8375	24.8775	41392076.0
2016-01-14 16:00:00	AAPL	Stock	24.88	25.034	24.59	24.68	10733500.0
2016-01-14 17:00:00	AAPL	Stock	24.68	24.7375	24.65	24.6875	467324.0
2016-01-14 18:00:00	AAPL	Stock	24.6875	24.6875	24.65	24.6875	210948.0
2016-01-14 19:00:00	AAPL	Stock	24.6625	24.825	24.6625	24.8125	232512.0
2016-01-14 05:00:00	MSFT	Stock	51.75	51.75	51.75	51.75	1000.0
2016-01-14 06:00:00	MSFT	Stock	51.74	51.74	51.36	51.36	2964.0
2016-01-14 07:00:00	MSFT	Stock	51.63	51.89	51.58	51.89	6382.0
2016-01-14 08:00:00	MSFT	Stock	51.82	51.98	51.64	51.88	347928.0
2016-01-14 09:00:00	MSFT	Stock	51.9	52.09	51.64	51.75	5087062.0
2016-01-14 10:00:00	MSFT	Stock	51.75	52.77	51.57	52.47	10417260.0
2016-01-14 11:00:00	MSFT	Stock	52.48	52.92	52.29	52.92	4920850.0
2016-01-14 12:00:00	MSFT	Stock	52.92	53.01	52.56	52.56	4024854.0
2016-01-14 13:00:00	MSFT	Stock	52.56	53.1	52.45	53.032	4989583.0
2016-01-14 14:00:00	MSFT	Stock	53.04	53.36	52.85	53.29	4552271.0
2016-01-14 15:00:00	MSFT	Stock	53.3	53.416	52.95	53.06	8806869.0
2016-01-14 16:00:00	MSFT	Stock	53.11	53.19	52.72	52.72	5956067.0
2016-01-14 17:00:00	MSFT	Stock	52.75	52.94	52.66	52.85	13897.0
2016-01-14 18:00:00	MSFT	Stock	52.85	52.96	52.85	52.85	11000.0
2016-01-14 19:00:00	MSFT	Stock	52.9	52.9	52.77	52.77	4885.0
2016-01-14 04:00:00	NVDA	Stock	0.727	0.727	0.7038	0.7038	12000.0
2016-01-14 07:00:00	NVDA	Stock	0.7125	0.7125	0.7125	0.7125	12000.0
2016-01-14 08:00:00	NVDA	Stock	0.7085	0.7198	0.7002	0.7128	285440.0
2016-01-14 09:00:00	NVDA	Stock	0.715	0.7213	0.696	0.697	98214440.0
2016-01-14 10:00:00	NVDA	Stock	0.697	0.7108	0.6955	0.7022	108367240.0
2016-01-14 11:00:00	NVDA	Stock	0.7024	0.7095	0.697	0.7076	69542560.0
2016-01-14 12:00:00	NVDA	Stock	0.7078	0.716	0.7076	0.714	69117840.0
2016-01-14 13:00:00	NVDA	Stock	0.7138	0.7208	0.7133	0.72	48157280.0
2016-01-14 14:00:00	NVDA	Stock	0.7201	0.725	0.7195	0.7228	45834320.0
2016-01-14 15:00:00	NVDA	Stock	0.723	0.7239	0.716	0.7168	100822320.0
2016-01-14 16:00:00	NVDA	Stock	0.7168	0.717	0.715	0.715	18531040.0
2016-01-14 17:00:00	NVDA	Stock	0.7138	0.725	0.7138	0.725	117160.0
2016-01-14 18:00:00	NVDA	Stock	0.715	0.715	0.713	0.713	58960.0
2016-01-14 04:00:00	AMZN	Stock	29.1015	29.1665	29.1015	29.1665	4000.0
2016-01-14 05:00:00	AMZN	Stock	29.0	29.0	29.0	29.0	10000.0
2016-01-14 06:00:00	AMZN	Stock	28.85	28.9245	28.8	28.9245	33940.0
2016-01-14 07:00:00	AMZN	Stock	28.92	29.19	28.92	29.1875	230820.0
2016-01-14 08:00:00	AMZN	Stock	29.1535	29.258	29.08	29.0905	728760.0
2016-01-14 09:00:00	AMZN	Stock	29.1875	29.3	28.494	28.55	26760880.0

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

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