PREVIEW / stock_1hour / 2015-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-14.parquet
  size:    1.0 MB
  rows:    48,582
  symbols: 3,483

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-07-14 04:00:00	AAPL	Stock	31.49	31.49	31.42	31.4475	17176.0
2015-07-14 05:00:00	AAPL	Stock	31.4375	31.4625	31.4375	31.45	10264.0
2015-07-14 06:00:00	AAPL	Stock	31.45	31.47	31.4125	31.415	22752.0
2015-07-14 07:00:00	AAPL	Stock	31.4225	31.4475	31.4	31.4125	56500.0
2015-07-14 08:00:00	AAPL	Stock	31.415	31.4625	31.3975	31.4025	410288.0
2015-07-14 09:00:00	AAPL	Stock	31.405	31.5375	31.285	31.3238	18180232.0
2015-07-14 10:00:00	AAPL	Stock	31.325	31.4275	31.26	31.385	22128528.0
2015-07-14 11:00:00	AAPL	Stock	31.38	31.5075	31.38	31.47	14979056.0
2015-07-14 12:00:00	AAPL	Stock	31.4725	31.495	31.42	31.4775	9454144.0
2015-07-14 13:00:00	AAPL	Stock	31.4775	31.575	31.46	31.575	12075768.0
2015-07-14 14:00:00	AAPL	Stock	31.5725	31.5925	31.5375	31.55	10175716.0
2015-07-14 15:00:00	AAPL	Stock	31.55	31.555	31.39	31.4025	22472184.0
2015-07-14 16:00:00	AAPL	Stock	31.4005	31.415	31.3635	31.415	8964128.0
2015-07-14 17:00:00	AAPL	Stock	31.4125	31.425	31.4025	31.4075	178688.0
2015-07-14 18:00:00	AAPL	Stock	31.4075	31.42	31.4	31.4175	78080.0
2015-07-14 19:00:00	AAPL	Stock	31.4175	31.42	31.4	31.41	126108.0
2015-07-14 05:00:00	MSFT	Stock	45.58	45.58	45.5	45.5	1550.0
2015-07-14 06:00:00	MSFT	Stock	45.51	45.51	45.5	45.5	1500.0
2015-07-14 08:00:00	MSFT	Stock	45.54	45.57	45.47	45.47	2200.0
2015-07-14 09:00:00	MSFT	Stock	45.5	45.69	45.31	45.6	2987954.0
2015-07-14 10:00:00	MSFT	Stock	45.62	45.72	45.57	45.71	3030179.0
2015-07-14 11:00:00	MSFT	Stock	45.71	45.96	45.705	45.83	3431483.0
2015-07-14 12:00:00	MSFT	Stock	45.84	45.89	45.63	45.681	1844231.0
2015-07-14 13:00:00	MSFT	Stock	45.68	45.735	45.64	45.7	1879134.0
2015-07-14 14:00:00	MSFT	Stock	45.69	45.79	45.68	45.74	2588460.0
2015-07-14 15:00:00	MSFT	Stock	45.74	45.8	45.6	45.62	3177357.0
2015-07-14 16:00:00	MSFT	Stock	45.61	45.726	45.61	45.726	2960564.0
2015-07-14 17:00:00	MSFT	Stock	45.59	45.59	45.59	45.59	100.0
2015-07-14 18:00:00	MSFT	Stock	45.59	45.69	45.59	45.69	3351.0
2015-07-14 19:00:00	MSFT	Stock	45.65	45.65	45.65	45.65	200.0
2015-07-14 08:00:00	NVDA	Stock	0.4971	0.4971	0.4971	0.4971	4000.0
2015-07-14 09:00:00	NVDA	Stock	0.4982	0.4982	0.4908	0.4932	48794920.0
2015-07-14 10:00:00	NVDA	Stock	0.4934	0.497	0.4926	0.495	44049200.0
2015-07-14 11:00:00	NVDA	Stock	0.495	0.4972	0.495	0.497	39618200.0
2015-07-14 12:00:00	NVDA	Stock	0.4969	0.4978	0.4952	0.4956	19903480.0
2015-07-14 13:00:00	NVDA	Stock	0.4956	0.4958	0.495	0.4952	11664800.0
2015-07-14 14:00:00	NVDA	Stock	0.495	0.4968	0.495	0.4963	13013640.0
2015-07-14 15:00:00	NVDA	Stock	0.4964	0.4982	0.4963	0.4972	36892000.0
2015-07-14 16:00:00	NVDA	Stock	0.4975	0.498	0.4952	0.4956	13717000.0
2015-07-14 04:00:00	AMZN	Stock	22.9775	23.0115	22.9325	23.0115	72660.0
2015-07-14 05:00:00	AMZN	Stock	23.0145	23.125	22.9885	23.125	42000.0
2015-07-14 06:00:00	AMZN	Stock	23.1	23.1	23.075	23.075	20480.0
2015-07-14 07:00:00	AMZN	Stock	23.0875	23.175	23.085	23.15	129520.0
2015-07-14 08:00:00	AMZN	Stock	23.149	23.15	23.05	23.05	635960.0
2015-07-14 09:00:00	AMZN	Stock	23.075	23.2495	22.908	23.1	19236340.0
2015-07-14 10:00:00	AMZN	Stock	23.0855	23.204	23.074	23.1665	8819820.0
2015-07-14 11:00:00	AMZN	Stock	23.1655	23.325	23.1535	23.3222	10324860.0
2015-07-14 12:00:00	AMZN	Stock	23.3305	23.382	23.3	23.3485	5951080.0
2015-07-14 13:00:00	AMZN	Stock	23.349	23.3825	23.288	23.3475	5594220.0
2015-07-14 14:00:00	AMZN	Stock	23.3419	23.4625	23.3275	23.4624	5896420.0

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

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