PREVIEW / stock_1hour / 2016-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-29.parquet
  size:    1.0 MB
  rows:    49,066
  symbols: 3,361

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-03-29 04:00:00	AAPL	Stock	26.385	26.415	26.3175	26.415	35868.0
2016-03-29 05:00:00	AAPL	Stock	26.345	26.345	26.2975	26.3275	11000.0
2016-03-29 06:00:00	AAPL	Stock	26.325	26.325	26.28	26.28	8936.0
2016-03-29 07:00:00	AAPL	Stock	26.2325	26.25	26.18	26.2475	26456.0
2016-03-29 08:00:00	AAPL	Stock	26.25	26.265	26.21	26.2625	126284.0
2016-03-29 09:00:00	AAPL	Stock	26.2525	26.495	26.22	26.4845	13203904.0
2016-03-29 10:00:00	AAPL	Stock	26.4845	26.71	26.4475	26.6925	21427624.0
2016-03-29 11:00:00	AAPL	Stock	26.6925	26.74	26.5925	26.6818	13222720.0
2016-03-29 12:00:00	AAPL	Stock	26.6788	26.84	26.6725	26.8075	15456292.0
2016-03-29 13:00:00	AAPL	Stock	26.8075	26.875	26.75	26.8612	10445920.0
2016-03-29 14:00:00	AAPL	Stock	26.8618	26.94	26.8425	26.89	13122824.0
2016-03-29 15:00:00	AAPL	Stock	26.8875	26.9475	26.88	26.92	17542388.0
2016-03-29 16:00:00	AAPL	Stock	26.92	26.93	26.9	26.9225	9382852.0
2016-03-29 17:00:00	AAPL	Stock	26.9125	26.92	26.8925	26.9	218444.0
2016-03-29 18:00:00	AAPL	Stock	26.8975	26.92	26.8975	26.915	43560.0
2016-03-29 19:00:00	AAPL	Stock	26.9125	26.9425	26.9125	26.93	58800.0
2016-03-29 04:00:00	MSFT	Stock	53.54	53.54	53.54	53.54	100.0
2016-03-29 05:00:00	MSFT	Stock	53.57	53.57	53.13	53.13	700.0
2016-03-29 07:00:00	MSFT	Stock	53.4	53.4	53.4	53.4	100.0
2016-03-29 08:00:00	MSFT	Stock	53.4	53.43	53.39	53.43	349.0
2016-03-29 09:00:00	MSFT	Stock	53.44	53.77	53.44	53.65	1568791.0
2016-03-29 10:00:00	MSFT	Stock	53.65	54.15	53.61	54.11	2451874.0
2016-03-29 11:00:00	MSFT	Stock	54.11	54.32	54.1	54.217	2297299.0
2016-03-29 12:00:00	MSFT	Stock	54.22	54.8	54.19	54.695	3144438.0
2016-03-29 13:00:00	MSFT	Stock	54.7	54.74	54.43	54.5	1816793.0
2016-03-29 14:00:00	MSFT	Stock	54.51	54.86	54.47	54.725	2948288.0
2016-03-29 15:00:00	MSFT	Stock	54.72	54.845	54.62	54.72	5082050.0
2016-03-29 16:00:00	MSFT	Stock	54.73	54.74	54.6	54.71	2974642.0
2016-03-29 17:00:00	MSFT	Stock	54.71	54.75	54.6	54.75	87357.0
2016-03-29 18:00:00	MSFT	Stock	54.72	54.75	54.72	54.75	1612.0
2016-03-29 19:00:00	MSFT	Stock	54.72	54.79	54.72	54.79	1500.0
2016-03-29 09:00:00	NVDA	Stock	0.867	0.8772	0.865	0.8744	27496760.0
2016-03-29 10:00:00	NVDA	Stock	0.8746	0.879	0.869	0.8692	28845920.0
2016-03-29 11:00:00	NVDA	Stock	0.8692	0.8741	0.8685	0.8725	19628240.0
2016-03-29 12:00:00	NVDA	Stock	0.8722	0.8796	0.8718	0.8788	22969200.0
2016-03-29 13:00:00	NVDA	Stock	0.8788	0.8798	0.8757	0.8777	36349720.0
2016-03-29 14:00:00	NVDA	Stock	0.8776	0.884	0.8776	0.8829	46205560.0
2016-03-29 15:00:00	NVDA	Stock	0.8828	0.8868	0.8826	0.8848	62393240.0
2016-03-29 16:00:00	NVDA	Stock	0.8848	0.885	0.8848	0.885	8472040.0
2016-03-29 17:00:00	NVDA	Stock	0.885	0.885	0.885	0.885	12000.0
2016-03-29 19:00:00	NVDA	Stock	0.8875	0.8875	0.8875	0.8875	8000.0
2016-03-29 05:00:00	AMZN	Stock	28.95	28.95	28.95	28.95	2000.0
2016-03-29 07:00:00	AMZN	Stock	28.95	28.95	28.9	28.9	6200.0
2016-03-29 08:00:00	AMZN	Stock	28.9	28.97	28.89	28.9275	80600.0
2016-03-29 09:00:00	AMZN	Stock	28.925	29.0178	28.825	28.9075	6348040.0
2016-03-29 10:00:00	AMZN	Stock	28.923	29.19	28.8885	29.1495	8546680.0
2016-03-29 11:00:00	AMZN	Stock	29.1535	29.4708	29.1455	29.4041	13656120.0
2016-03-29 12:00:00	AMZN	Stock	29.416	29.6835	29.315	29.5755	10610440.0
2016-03-29 13:00:00	AMZN	Stock	29.578	29.7485	29.5755	29.7244	9749560.0
2016-03-29 14:00:00	AMZN	Stock	29.728	29.7925	29.6062	29.6103	8050300.0

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

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