PREVIEW / stock_1hour / 2014-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-30.parquet
  size:    1.0 MB
  rows:    49,176
  symbols: 3,555

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-04-30 04:00:00	AAPL	Stock	21.0714	21.0714	21.0357	21.0357	5600.0
2014-04-30 05:00:00	AAPL	Stock	21.0857	21.0857	21.0721	21.0721	29680.0
2014-04-30 06:00:00	AAPL	Stock	21.0736	21.1286	21.0736	21.1286	51492.0
2014-04-30 07:00:00	AAPL	Stock	21.1246	21.2343	21.0946	21.2282	939400.0
2014-04-30 08:00:00	AAPL	Stock	21.2146	21.2568	21.1593	21.1939	1781696.0
2014-04-30 09:00:00	AAPL	Stock	21.1964	21.25	21.1161	21.1629	37499392.0
2014-04-30 10:00:00	AAPL	Stock	21.1643	21.4	21.1436	21.3986	62373108.0
2014-04-30 11:00:00	AAPL	Stock	21.3954	21.4082	21.2861	21.3132	32950484.0
2014-04-30 12:00:00	AAPL	Stock	21.3143	21.385	21.3141	21.3439	19075112.0
2014-04-30 13:00:00	AAPL	Stock	21.3421	21.3646	21.3214	21.3564	13544972.0
2014-04-30 14:00:00	AAPL	Stock	21.3536	21.4071	21.2104	21.2189	45506384.0
2014-04-30 15:00:00	AAPL	Stock	21.2188	21.24	21.0643	21.0729	71773548.0
2014-04-30 16:00:00	AAPL	Stock	21.0746	21.3319	21.0704	21.1214	99670088.0
2014-04-30 17:00:00	AAPL	Stock	21.1214	21.1214	21.0746	21.0964	269780.0
2014-04-30 18:00:00	AAPL	Stock	21.1143	21.1304	21.0746	21.1304	287476.0
2014-04-30 19:00:00	AAPL	Stock	21.1182	21.1329	21.1168	21.1168	141316.0
2014-04-30 04:00:00	MSFT	Stock	40.5	40.5	40.5	40.5	100.0
2014-04-30 07:00:00	MSFT	Stock	40.36	40.51	40.36	40.51	300.0
2014-04-30 08:00:00	MSFT	Stock	40.51	40.51	40.45	40.49	7800.0
2014-04-30 09:00:00	MSFT	Stock	40.48	40.495	40.17	40.27	3238388.0
2014-04-30 10:00:00	MSFT	Stock	40.265	40.34	40.19	40.256	5377419.0
2014-04-30 11:00:00	MSFT	Stock	40.25	40.35	40.245	40.3	3282125.0
2014-04-30 12:00:00	MSFT	Stock	40.31	40.39	40.3	40.375	2457775.0
2014-04-30 13:00:00	MSFT	Stock	40.375	40.39	40.33	40.34	1698201.0
2014-04-30 14:00:00	MSFT	Stock	40.335	40.46	40.27	40.4	4560063.0
2014-04-30 15:00:00	MSFT	Stock	40.4	40.5	40.24	40.4	8479210.0
2014-04-30 16:00:00	MSFT	Stock	40.4	40.413	40.24	40.289	4701573.0
2014-04-30 17:00:00	MSFT	Stock	40.38	40.4	40.34	40.4	33396.0
2014-04-30 18:00:00	MSFT	Stock	40.34	40.34	40.31	40.31	3815.0
2014-04-30 19:00:00	MSFT	Stock	40.35	40.39	40.35	40.38	5298.0
2014-04-30 08:00:00	NVDA	Stock	0.4673	0.4673	0.4673	0.4673	1504000.0
2014-04-30 09:00:00	NVDA	Stock	0.4673	0.4673	0.462	0.464	22556880.0
2014-04-30 10:00:00	NVDA	Stock	0.4643	0.4668	0.4628	0.464	41189360.0
2014-04-30 11:00:00	NVDA	Stock	0.464	0.4648	0.4625	0.4635	20123400.0
2014-04-30 12:00:00	NVDA	Stock	0.4638	0.4643	0.4628	0.4636	16333600.0
2014-04-30 13:00:00	NVDA	Stock	0.4638	0.4645	0.4635	0.4638	19972640.0
2014-04-30 14:00:00	NVDA	Stock	0.4635	0.4643	0.4608	0.4625	57663000.0
2014-04-30 15:00:00	NVDA	Stock	0.4625	0.4643	0.4612	0.4615	90154720.0
2014-04-30 16:00:00	NVDA	Stock	0.4618	0.4665	0.4614	0.4617	22355160.0
2014-04-30 17:00:00	NVDA	Stock	0.4618	0.4622	0.4618	0.4622	141280.0
2014-04-30 18:00:00	NVDA	Stock	0.464	0.4643	0.464	0.4643	144000.0
2014-04-30 07:00:00	AMZN	Stock	14.8775	14.8775	14.8775	14.8775	2000.0
2014-04-30 08:00:00	AMZN	Stock	14.9	14.901	14.839	14.875	508260.0
2014-04-30 09:00:00	AMZN	Stock	14.88	15.0822	14.84	14.9865	12288400.0
2014-04-30 10:00:00	AMZN	Stock	14.9915	15.15	14.908	15.0755	14205860.0
2014-04-30 11:00:00	AMZN	Stock	15.075	15.125	15.0263	15.0432	7275680.0
2014-04-30 12:00:00	AMZN	Stock	15.0432	15.0935	15.0195	15.08	4109360.0
2014-04-30 13:00:00	AMZN	Stock	15.086	15.115	15.055	15.091	5197260.0
2014-04-30 14:00:00	AMZN	Stock	15.091	15.228	15.057	15.169	10228920.0
2014-04-30 15:00:00	AMZN	Stock	15.1785	15.2155	15.1055	15.1955	13929020.0

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

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