PREVIEW / stock_1hour / 2015-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-11.parquet
  size:    1.0 MB
  rows:    49,549
  symbols: 3,405

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
2015-12-11 04:00:00	AAPL	Stock	29.0425	29.0425	28.9325	28.9875	83176.0
2015-12-11 05:00:00	AAPL	Stock	28.965	28.965	28.805	28.8125	9680.0
2015-12-11 06:00:00	AAPL	Stock	28.83	28.845	28.7775	28.8125	31564.0
2015-12-11 07:00:00	AAPL	Stock	28.8375	28.875	28.72	28.725	299500.0
2015-12-11 08:00:00	AAPL	Stock	28.75	28.86	28.7325	28.8325	609516.0
2015-12-11 09:00:00	AAPL	Stock	28.825	28.8475	28.5525	28.6265	23976060.0
2015-12-11 10:00:00	AAPL	Stock	28.6225	28.7125	28.445	28.49	29036708.0
2015-12-11 11:00:00	AAPL	Stock	28.4888	28.52	28.295	28.33	24609820.0
2015-12-11 12:00:00	AAPL	Stock	28.3325	28.3875	28.2128	28.375	22109608.0
2015-12-11 13:00:00	AAPL	Stock	28.374	28.45	28.295	28.4088	15963372.0
2015-12-11 14:00:00	AAPL	Stock	28.41	28.45	28.3125	28.345	14232068.0
2015-12-11 15:00:00	AAPL	Stock	28.345	28.42	28.215	28.2925	28550520.0
2015-12-11 16:00:00	AAPL	Stock	28.295	28.325	28.2875	28.295	15169716.0
2015-12-11 17:00:00	AAPL	Stock	28.3	28.31	28.285	28.285	50056.0
2015-12-11 18:00:00	AAPL	Stock	28.285	28.2875	28.25	28.26	161680.0
2015-12-11 19:00:00	AAPL	Stock	28.25	28.26	28.22	28.2375	55660.0
2015-12-11 04:00:00	MSFT	Stock	55.2	55.2	55.2	55.2	500.0
2015-12-11 05:00:00	MSFT	Stock	55.0	55.0	55.0	55.0	400.0
2015-12-11 07:00:00	MSFT	Stock	55.0	55.0	54.7	54.7	35201.0
2015-12-11 08:00:00	MSFT	Stock	54.79	54.95	54.72	54.87	52065.0
2015-12-11 09:00:00	MSFT	Stock	54.82	54.896	54.38	54.885	4680242.0
2015-12-11 10:00:00	MSFT	Stock	54.89	55.1	54.73	54.75	5188007.0
2015-12-11 11:00:00	MSFT	Stock	54.75	54.84	54.3	54.3	4096334.0
2015-12-11 12:00:00	MSFT	Stock	54.31	54.6	54.12	54.49	4165047.0
2015-12-11 13:00:00	MSFT	Stock	54.48	54.68	54.257	54.57	2819575.0
2015-12-11 14:00:00	MSFT	Stock	54.57	54.69	54.285	54.32	3318266.0
2015-12-11 15:00:00	MSFT	Stock	54.315	54.47	54.01	54.08	8769630.0
2015-12-11 16:00:00	MSFT	Stock	54.06	54.528	53.98	53.98	4180234.0
2015-12-11 17:00:00	MSFT	Stock	54.06	54.06	53.92	53.96	6824.0
2015-12-11 18:00:00	MSFT	Stock	53.96	53.96	53.83	53.83	3137.0
2015-12-11 19:00:00	MSFT	Stock	53.85	53.85	53.85	53.85	700.0
2015-12-11 07:00:00	NVDA	Stock	0.8028	0.8028	0.8028	0.8028	4800.0
2015-12-11 08:00:00	NVDA	Stock	0.8195	0.8195	0.8175	0.818	137640.0
2015-12-11 09:00:00	NVDA	Stock	0.818	0.8204	0.8135	0.8165	29899840.0
2015-12-11 10:00:00	NVDA	Stock	0.8165	0.822	0.815	0.8156	37504600.0
2015-12-11 11:00:00	NVDA	Stock	0.8156	0.8188	0.8142	0.8152	19465880.0
2015-12-11 12:00:00	NVDA	Stock	0.8152	0.8165	0.8113	0.815	20409920.0
2015-12-11 13:00:00	NVDA	Stock	0.8148	0.8181	0.8138	0.8172	15790480.0
2015-12-11 14:00:00	NVDA	Stock	0.8172	0.8188	0.8126	0.8128	22649680.0
2015-12-11 15:00:00	NVDA	Stock	0.8125	0.814	0.8105	0.812	60643080.0
2015-12-11 16:00:00	NVDA	Stock	0.8123	0.8123	0.8123	0.8123	10542640.0
2015-12-11 17:00:00	NVDA	Stock	0.8052	0.8052	0.8052	0.8052	40000.0
2015-12-11 18:00:00	NVDA	Stock	0.8052	0.8052	0.8052	0.8052	20000.0
2015-12-11 04:00:00	AMZN	Stock	33.045	33.045	32.993	33.0155	10000.0
2015-12-11 05:00:00	AMZN	Stock	33.05	33.05	32.9	32.9	10000.0
2015-12-11 06:00:00	AMZN	Stock	32.8435	32.8475	32.79	32.79	7000.0
2015-12-11 07:00:00	AMZN	Stock	32.8295	32.938	32.6985	32.725	149360.0
2015-12-11 08:00:00	AMZN	Stock	32.725	32.95	32.7005	32.777	408880.0
2015-12-11 09:00:00	AMZN	Stock	32.778	32.894	32.5425	32.584	15014360.0
2015-12-11 10:00:00	AMZN	Stock	32.5884	32.79	32.527	32.5483	11932440.0

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

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