PREVIEW / stock_1hour / 2014-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-19.parquet
  size:    1.0 MB
  rows:    48,371
  symbols: 3,564

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
2014-06-19 04:00:00	AAPL	Stock	23.125	23.1675	23.1025	23.14	26000.0
2014-06-19 05:00:00	AAPL	Stock	23.1325	23.1425	23.125	23.1325	12080.0
2014-06-19 06:00:00	AAPL	Stock	23.1325	23.14	23.1125	23.1375	63444.0
2014-06-19 07:00:00	AAPL	Stock	23.1375	23.145	23.035	23.04	202136.0
2014-06-19 08:00:00	AAPL	Stock	23.0425	23.13	23.02	23.0725	526072.0
2014-06-19 09:00:00	AAPL	Stock	23.0725	23.08	22.975	23.0025	14908272.0
2014-06-19 10:00:00	AAPL	Stock	23.005	23.07	22.9625	22.9825	17939040.0
2014-06-19 11:00:00	AAPL	Stock	22.98	22.9975	22.9025	22.9188	12570688.0
2014-06-19 12:00:00	AAPL	Stock	22.9195	22.9675	22.86	22.865	10723680.0
2014-06-19 13:00:00	AAPL	Stock	22.8638	22.8875	22.8425	22.875	10438832.0
2014-06-19 14:00:00	AAPL	Stock	22.875	22.9935	22.8575	22.935	17187620.0
2014-06-19 15:00:00	AAPL	Stock	22.9375	23.0175	22.915	22.96	36907784.0
2014-06-19 16:00:00	AAPL	Stock	22.965	23.045	22.9025	22.965	12496312.0
2014-06-19 17:00:00	AAPL	Stock	22.91	22.9275	22.91	22.9275	27832.0
2014-06-19 18:00:00	AAPL	Stock	22.9125	22.9275	22.8925	22.9	91900.0
2014-06-19 19:00:00	AAPL	Stock	22.895	22.91	22.875	22.8775	85824.0
2014-06-19 04:00:00	MSFT	Stock	41.48	41.48	41.48	41.48	325.0
2014-06-19 07:00:00	MSFT	Stock	41.64	41.64	41.64	41.64	525.0
2014-06-19 08:00:00	MSFT	Stock	41.66	41.66	41.66	41.66	100.0
2014-06-19 09:00:00	MSFT	Stock	41.57	41.77	41.56	41.66	2393629.0
2014-06-19 10:00:00	MSFT	Stock	41.66	41.745	41.48	41.544	2848111.0
2014-06-19 11:00:00	MSFT	Stock	41.54	41.56	41.42	41.505	2396409.0
2014-06-19 12:00:00	MSFT	Stock	41.503	41.615	41.43	41.442	971558.0
2014-06-19 13:00:00	MSFT	Stock	41.44	41.48	41.33	41.43	1646140.0
2014-06-19 14:00:00	MSFT	Stock	41.43	41.475	41.39	41.45	1282611.0
2014-06-19 15:00:00	MSFT	Stock	41.45	41.5	41.38	41.5	4278110.0
2014-06-19 16:00:00	MSFT	Stock	41.51	41.529	41.33	41.51	3061297.0
2014-06-19 18:00:00	MSFT	Stock	41.51	41.51	41.51	41.51	8260.0
2014-06-19 19:00:00	MSFT	Stock	41.43	41.49	41.43	41.49	1200.0
2014-06-19 06:00:00	NVDA	Stock	0.4858	0.4858	0.475	0.475	244520.0
2014-06-19 07:00:00	NVDA	Stock	0.4798	0.4798	0.4798	0.4798	4000.0
2014-06-19 08:00:00	NVDA	Stock	0.4785	0.4815	0.4785	0.4798	448000.0
2014-06-19 09:00:00	NVDA	Stock	0.4812	0.4832	0.475	0.48	135228880.0
2014-06-19 10:00:00	NVDA	Stock	0.4798	0.4815	0.4765	0.4775	114929600.0
2014-06-19 11:00:00	NVDA	Stock	0.4772	0.4775	0.4753	0.4768	43012560.0
2014-06-19 12:00:00	NVDA	Stock	0.4768	0.4775	0.476	0.4775	15644480.0
2014-06-19 13:00:00	NVDA	Stock	0.4774	0.478	0.4753	0.4755	31313720.0
2014-06-19 14:00:00	NVDA	Stock	0.4755	0.478	0.4753	0.4778	44055840.0
2014-06-19 15:00:00	NVDA	Stock	0.4775	0.479	0.4774	0.4782	62224440.0
2014-06-19 16:00:00	NVDA	Stock	0.4785	0.4785	0.4778	0.4785	14182640.0
2014-06-19 05:00:00	AMZN	Stock	16.75	16.75	16.6765	16.735	17400.0
2014-06-19 06:00:00	AMZN	Stock	16.7645	16.7645	16.75	16.75	20000.0
2014-06-19 07:00:00	AMZN	Stock	16.788	16.825	16.7785	16.8015	184040.0
2014-06-19 08:00:00	AMZN	Stock	16.8075	16.824	16.7	16.801	504280.0
2014-06-19 09:00:00	AMZN	Stock	16.7935	16.945	16.58	16.6135	27199620.0
2014-06-19 10:00:00	AMZN	Stock	16.623	16.6255	16.4115	16.4365	23248640.0
2014-06-19 11:00:00	AMZN	Stock	16.4375	16.522	16.4335	16.462	9373420.0
2014-06-19 12:00:00	AMZN	Stock	16.4595	16.4655	16.336	16.3635	10047300.0
2014-06-19 13:00:00	AMZN	Stock	16.367	16.3975	16.299	16.3869	5380620.0
2014-06-19 14:00:00	AMZN	Stock	16.389	16.459	16.38	16.436	5363480.0

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

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