PREVIEW / stock_1hour / 2015-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-30.parquet
  size:    1.1 MB
  rows:    49,235
  symbols: 3,527

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-01-30 04:00:00	AAPL	Stock	29.725	29.725	29.5975	29.6025	27464.0
2015-01-30 05:00:00	AAPL	Stock	29.6	29.6625	29.525	29.585	50928.0
2015-01-30 06:00:00	AAPL	Stock	29.5875	29.65	29.55	29.57	53636.0
2015-01-30 07:00:00	AAPL	Stock	29.5975	29.625	29.555	29.59	346628.0
2015-01-30 08:00:00	AAPL	Stock	29.59	29.725	29.55	29.61	2241160.0
2015-01-30 09:00:00	AAPL	Stock	29.6175	30.0	29.5225	29.9075	61213236.0
2015-01-30 10:00:00	AAPL	Stock	29.9025	29.985	29.705	29.8125	53240776.0
2015-01-30 11:00:00	AAPL	Stock	29.8125	29.8525	29.6925	29.7925	27758556.0
2015-01-30 12:00:00	AAPL	Stock	29.7912	29.9075	29.78	29.84	22019240.0
2015-01-30 13:00:00	AAPL	Stock	29.84	29.895	29.725	29.8025	19235780.0
2015-01-30 14:00:00	AAPL	Stock	29.8002	29.91	29.705	29.7675	27232800.0
2015-01-30 15:00:00	AAPL	Stock	29.765	29.7825	29.2125	29.29	69420492.0
2015-01-30 16:00:00	AAPL	Stock	29.29	29.855	29.258	29.3125	24374636.0
2015-01-30 17:00:00	AAPL	Stock	29.32	29.35	29.29	29.335	417716.0
2015-01-30 18:00:00	AAPL	Stock	29.335	29.335	29.29	29.3125	132192.0
2015-01-30 19:00:00	AAPL	Stock	29.3225	29.345	29.3125	29.3175	138152.0
2015-01-30 04:00:00	MSFT	Stock	42.11	42.11	41.88	41.88	13454.0
2015-01-30 05:00:00	MSFT	Stock	42.11	42.11	41.97	41.97	600.0
2015-01-30 06:00:00	MSFT	Stock	42.0	42.0	41.99	41.99	2000.0
2015-01-30 07:00:00	MSFT	Stock	42.04	42.04	41.9	41.9	11192.0
2015-01-30 08:00:00	MSFT	Stock	41.94	41.97	41.71	41.75	59229.0
2015-01-30 09:00:00	MSFT	Stock	41.75	41.76	41.16	41.21	8763221.0
2015-01-30 10:00:00	MSFT	Stock	41.2	41.33	40.88	40.965	11020778.0
2015-01-30 11:00:00	MSFT	Stock	40.965	41.13	40.76	40.884	7718348.0
2015-01-30 12:00:00	MSFT	Stock	40.88	41.17	40.88	40.99	5705558.0
2015-01-30 13:00:00	MSFT	Stock	40.99	41.06	40.81	40.995	4541233.0
2015-01-30 14:00:00	MSFT	Stock	40.995	41.01	40.56	40.7	9247504.0
2015-01-30 15:00:00	MSFT	Stock	40.7	40.77	40.35	40.42	20822777.0
2015-01-30 16:00:00	MSFT	Stock	40.42	41.1	40.36	40.95	7057406.0
2015-01-30 17:00:00	MSFT	Stock	40.44	40.48	40.4	40.48	114184.0
2015-01-30 18:00:00	MSFT	Stock	40.4	40.47	40.4	40.47	5914.0
2015-01-30 19:00:00	MSFT	Stock	40.45	40.48	40.41	40.41	7262.0
2015-01-30 09:00:00	NVDA	Stock	0.4908	0.4967	0.487	0.487	28976360.0
2015-01-30 10:00:00	NVDA	Stock	0.487	0.489	0.4815	0.4843	26719560.0
2015-01-30 11:00:00	NVDA	Stock	0.4841	0.487	0.4838	0.4865	16324120.0
2015-01-30 12:00:00	NVDA	Stock	0.4868	0.489	0.485	0.4855	11648720.0
2015-01-30 13:00:00	NVDA	Stock	0.4855	0.4885	0.4845	0.4852	24636760.0
2015-01-30 14:00:00	NVDA	Stock	0.4852	0.4868	0.4825	0.483	29030800.0
2015-01-30 15:00:00	NVDA	Stock	0.483	0.4837	0.4793	0.4803	83433160.0
2015-01-30 16:00:00	NVDA	Stock	0.4801	0.4855	0.4795	0.4855	72519360.0
2015-01-30 17:00:00	NVDA	Stock	0.4801	0.4801	0.4801	0.4801	128960.0
2015-01-30 19:00:00	NVDA	Stock	0.4825	0.4825	0.4825	0.4825	8000.0
2015-01-30 04:00:00	AMZN	Stock	17.275	17.4	17.25	17.3775	327560.0
2015-01-30 05:00:00	AMZN	Stock	17.4	17.4	17.2	17.25	203600.0
2015-01-30 06:00:00	AMZN	Stock	17.25	17.35	17.2235	17.344	463680.0
2015-01-30 07:00:00	AMZN	Stock	17.325	17.3675	17.2125	17.288	3172540.0
2015-01-30 08:00:00	AMZN	Stock	17.2845	17.6675	17.2	17.6645	10436300.0
2015-01-30 09:00:00	AMZN	Stock	17.6525	17.6525	17.225	17.2785	106762640.0
2015-01-30 10:00:00	AMZN	Stock	17.2855	17.46	17.037	17.4135	84781960.0
2015-01-30 11:00:00	AMZN	Stock	17.4225	17.62	17.287	17.6105	54141260.0

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

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