PREVIEW / stock_1hour / 2013-09-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-03.parquet
  size:    1.0 MB
  rows:    47,988
  symbols: 3,532

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
2013-09-03 04:00:00	AAPL	Stock	17.6036	17.6071	17.5357	17.5364	50960.0
2013-09-03 05:00:00	AAPL	Stock	17.5118	17.5118	17.5118	17.5118	5292.0
2013-09-03 06:00:00	AAPL	Stock	17.5207	17.5207	17.4286	17.4893	136724.0
2013-09-03 07:00:00	AAPL	Stock	17.4879	17.5625	17.4879	17.5286	961940.0
2013-09-03 08:00:00	AAPL	Stock	17.5311	17.5907	17.5	17.5821	3114720.0
2013-09-03 09:00:00	AAPL	Stock	17.5779	17.8786	17.5714	17.7211	67905880.0
2013-09-03 10:00:00	AAPL	Stock	17.7191	17.7457	17.6189	17.6864	51876272.0
2013-09-03 11:00:00	AAPL	Stock	17.6893	17.7054	17.5625	17.6296	41288184.0
2013-09-03 12:00:00	AAPL	Stock	17.6254	17.6957	17.5261	17.5379	45145072.0
2013-09-03 13:00:00	AAPL	Stock	17.5417	17.5775	17.4289	17.4393	39091332.0
2013-09-03 14:00:00	AAPL	Stock	17.4389	17.505	17.4054	17.505	34948788.0
2013-09-03 15:00:00	AAPL	Stock	17.505	17.5321	17.4214	17.4489	38761940.0
2013-09-03 16:00:00	AAPL	Stock	17.4489	17.5947	17.4329	17.4418	6591116.0
2013-09-03 17:00:00	AAPL	Stock	17.4493	17.4493	17.4107	17.4196	465920.0
2013-09-03 18:00:00	AAPL	Stock	17.4196	17.4232	17.415	17.4221	48496.0
2013-09-03 19:00:00	AAPL	Stock	17.4232	17.4332	17.4232	17.4296	51576.0
2013-09-03 04:00:00	MSFT	Stock	33.4	34.06	32.89	32.9	70490.0
2013-09-03 05:00:00	MSFT	Stock	33.02	33.02	32.65	32.74	38619.0
2013-09-03 06:00:00	MSFT	Stock	32.74	32.8	32.3	32.45	100258.0
2013-09-03 07:00:00	MSFT	Stock	32.49	32.5	31.68	31.83	1269021.0
2013-09-03 08:00:00	MSFT	Stock	31.83	32.4	31.62	31.75	4516801.0
2013-09-03 09:00:00	MSFT	Stock	31.75	32.07	31.6	31.9	34178100.0
2013-09-03 10:00:00	MSFT	Stock	31.9	31.94	31.33	31.41	33762331.0
2013-09-03 11:00:00	MSFT	Stock	31.41	31.48	31.29	31.33	19097817.0
2013-09-03 12:00:00	MSFT	Stock	31.33	31.5	31.31	31.42	11313733.0
2013-09-03 13:00:00	MSFT	Stock	31.415	31.59	31.34	31.56	9867123.0
2013-09-03 14:00:00	MSFT	Stock	31.559	31.74	31.46	31.709	11059344.0
2013-09-03 15:00:00	MSFT	Stock	31.71	31.89	31.61	31.88	19766073.0
2013-09-03 16:00:00	MSFT	Stock	31.88	31.89	31.463	31.83	3262435.0
2013-09-03 17:00:00	MSFT	Stock	31.83	31.88	31.45	31.82	71636.0
2013-09-03 18:00:00	MSFT	Stock	31.82	31.83	31.81	31.81	8350.0
2013-09-03 19:00:00	MSFT	Stock	31.81	31.84	31.79	31.82	9088.0
2013-09-03 08:00:00	NVDA	Stock	0.3713	0.3713	0.37	0.37	96000.0
2013-09-03 09:00:00	NVDA	Stock	0.3718	0.3743	0.3698	0.371	35903000.0
2013-09-03 10:00:00	NVDA	Stock	0.3713	0.3723	0.3692	0.372	35492280.0
2013-09-03 11:00:00	NVDA	Stock	0.3718	0.3725	0.3682	0.3688	27986760.0
2013-09-03 12:00:00	NVDA	Stock	0.369	0.3692	0.3668	0.3676	33573600.0
2013-09-03 13:00:00	NVDA	Stock	0.3675	0.3688	0.3668	0.3675	42809200.0
2013-09-03 14:00:00	NVDA	Stock	0.3676	0.3699	0.3675	0.3698	30692400.0
2013-09-03 15:00:00	NVDA	Stock	0.3698	0.3705	0.368	0.3692	60265440.0
2013-09-03 16:00:00	NVDA	Stock	0.369	0.3696	0.3685	0.369	15680680.0
2013-09-03 17:00:00	NVDA	Stock	0.3688	0.369	0.3688	0.369	281040.0
2013-09-03 18:00:00	NVDA	Stock	0.3668	0.3668	0.3668	0.3668	4000.0
2013-09-03 08:00:00	AMZN	Stock	14.171	14.216	14.1375	14.216	56900.0
2013-09-03 09:00:00	AMZN	Stock	14.2	14.407	14.2	14.3835	12097200.0
2013-09-03 10:00:00	AMZN	Stock	14.382	14.5295	14.342	14.493	13552980.0
2013-09-03 11:00:00	AMZN	Stock	14.4955	14.5695	14.4	14.4267	8090040.0
2013-09-03 12:00:00	AMZN	Stock	14.4298	14.4965	14.3925	14.395	3864320.0
2013-09-03 13:00:00	AMZN	Stock	14.3995	14.4304	14.3325	14.36	4008180.0
2013-09-03 14:00:00	AMZN	Stock	14.3565	14.438	14.3565	14.4325	4342480.0

> showing 50 of 47,988 rows — these rows as CSV

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