PREVIEW / stock_1hour / 2012-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-11.parquet
  size:    930 KB
  rows:    43,658
  symbols: 3,470

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
2012-09-11 04:00:00	AAPL	Stock	23.6261	23.6786	23.6261	23.6786	181244.0
2012-09-11 05:00:00	AAPL	Stock	23.6964	23.7196	23.6789	23.7143	72520.0
2012-09-11 06:00:00	AAPL	Stock	23.6893	23.75	23.6786	23.7446	115556.0
2012-09-11 07:00:00	AAPL	Stock	23.7464	23.7946	23.7143	23.7936	1219736.0
2012-09-11 08:00:00	AAPL	Stock	23.7921	23.8714	23.7314	23.7679	5535096.0
2012-09-11 09:00:00	AAPL	Stock	23.7711	23.9182	23.7071	23.8979	92529304.0
2012-09-11 10:00:00	AAPL	Stock	23.8978	23.9321	23.6861	23.8536	82001500.0
2012-09-11 11:00:00	AAPL	Stock	23.8536	23.8764	23.75	23.7893	33996648.0
2012-09-11 12:00:00	AAPL	Stock	23.7893	23.83	23.5989	23.647	57733984.0
2012-09-11 13:00:00	AAPL	Stock	23.6482	23.7764	23.5861	23.6996	56315196.0
2012-09-11 14:00:00	AAPL	Stock	23.6964	23.7054	23.4839	23.5135	66231816.0
2012-09-11 15:00:00	AAPL	Stock	23.5096	23.6746	23.4464	23.5929	82371464.0
2012-09-11 16:00:00	AAPL	Stock	23.5929	23.8192	23.4737	23.6046	15394008.0
2012-09-11 17:00:00	AAPL	Stock	23.5957	23.6511	23.5957	23.6357	540176.0
2012-09-11 18:00:00	AAPL	Stock	23.6361	23.6364	23.6071	23.6286	250796.0
2012-09-11 19:00:00	AAPL	Stock	23.6286	23.6429	23.6214	23.6429	295624.0
2012-09-11 08:00:00	MSFT	Stock	30.76	30.79	30.75	30.75	5900.0
2012-09-11 09:00:00	MSFT	Stock	30.79	30.85	30.6	30.8	3628463.0
2012-09-11 10:00:00	MSFT	Stock	30.81	30.86	30.7	30.84	3705500.0
2012-09-11 11:00:00	MSFT	Stock	30.85	30.91	30.79	30.795	2449314.0
2012-09-11 12:00:00	MSFT	Stock	30.795	30.88	30.79	30.87	1733033.0
2012-09-11 13:00:00	MSFT	Stock	30.87	30.9	30.855	30.9	1599444.0
2012-09-11 14:00:00	MSFT	Stock	30.895	30.9	30.8	30.83	2772729.0
2012-09-11 15:00:00	MSFT	Stock	30.83	30.88	30.77	30.79	5476860.0
2012-09-11 16:00:00	MSFT	Stock	30.79	30.842	30.75	30.79	2448104.0
2012-09-11 17:00:00	MSFT	Stock	30.75	30.8	30.75	30.8	10935.0
2012-09-11 18:00:00	MSFT	Stock	30.8	30.8	30.75	30.75	15037.0
2012-09-11 19:00:00	MSFT	Stock	30.75	30.75	30.75	30.75	1700.0
2012-09-11 08:00:00	NVDA	Stock	0.332	0.332	0.332	0.332	16000.0
2012-09-11 09:00:00	NVDA	Stock	0.3335	0.3342	0.3305	0.3342	43245640.0
2012-09-11 10:00:00	NVDA	Stock	0.3342	0.339	0.3333	0.338	93074600.0
2012-09-11 11:00:00	NVDA	Stock	0.338	0.3413	0.3364	0.337	84362880.0
2012-09-11 12:00:00	NVDA	Stock	0.337	0.338	0.3348	0.3378	37948880.0
2012-09-11 13:00:00	NVDA	Stock	0.3378	0.3393	0.3375	0.3382	23139560.0
2012-09-11 14:00:00	NVDA	Stock	0.3382	0.339	0.3368	0.3375	30200800.0
2012-09-11 15:00:00	NVDA	Stock	0.3374	0.3378	0.335	0.3358	57689800.0
2012-09-11 16:00:00	NVDA	Stock	0.336	0.3365	0.3324	0.3358	11659640.0
2012-09-11 18:00:00	NVDA	Stock	0.3362	0.3362	0.3362	0.3362	4000.0
2012-09-11 19:00:00	NVDA	Stock	0.3365	0.3365	0.3365	0.3365	116000.0
2012-09-11 04:00:00	AMZN	Stock	12.87	12.87	12.87	12.87	4000.0
2012-09-11 06:00:00	AMZN	Stock	12.922	12.922	12.9145	12.9145	8000.0
2012-09-11 07:00:00	AMZN	Stock	12.9295	12.9495	12.9295	12.9445	101840.0
2012-09-11 08:00:00	AMZN	Stock	12.908	12.94	12.873	12.893	203540.0
2012-09-11 09:00:00	AMZN	Stock	12.895	12.895	12.7795	12.8525	7547240.0
2012-09-11 10:00:00	AMZN	Stock	12.862	12.8655	12.7679	12.8235	8090420.0
2012-09-11 11:00:00	AMZN	Stock	12.824	12.835	12.713	12.7405	8926300.0
2012-09-11 12:00:00	AMZN	Stock	12.7405	12.7874	12.728	12.74	5286920.0
2012-09-11 13:00:00	AMZN	Stock	12.741	12.8335	12.74	12.8095	4812860.0
2012-09-11 14:00:00	AMZN	Stock	12.8085	12.87	12.797	12.8155	5228620.0
2012-09-11 15:00:00	AMZN	Stock	12.8175	12.8215	12.764	12.788	8261280.0

> showing 50 of 43,658 rows — these rows as CSV

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