PREVIEW / stock_1hour / 2012-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-24.parquet
  size:    951 KB
  rows:    45,136
  symbols: 3,479

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-24 04:00:00	AAPL	Stock	24.9964	24.9964	24.9286	24.9286	65912.0
2012-09-24 05:00:00	AAPL	Stock	24.9357	24.9446	24.8768	24.8929	28812.0
2012-09-24 06:00:00	AAPL	Stock	24.8921	24.8929	24.875	24.875	19600.0
2012-09-24 07:00:00	AAPL	Stock	24.8446	24.875	24.8114	24.825	962248.0
2012-09-24 08:00:00	AAPL	Stock	24.825	24.8571	24.3525	24.4464	16341332.0
2012-09-24 09:00:00	AAPL	Stock	24.4461	24.8193	24.3586	24.7646	151173820.0
2012-09-24 10:00:00	AAPL	Stock	24.7654	24.8257	24.6086	24.7055	96104456.0
2012-09-24 11:00:00	AAPL	Stock	24.6982	24.757	24.6264	24.6786	46643800.0
2012-09-24 12:00:00	AAPL	Stock	24.6779	24.6779	24.4796	24.5396	71786624.0
2012-09-24 13:00:00	AAPL	Stock	24.5379	24.5689	24.4168	24.4583	64949948.0
2012-09-24 14:00:00	AAPL	Stock	24.4586	24.6964	24.4471	24.6477	74586792.0
2012-09-24 15:00:00	AAPL	Stock	24.6471	24.7118	24.5964	24.6371	67467288.0
2012-09-24 16:00:00	AAPL	Stock	24.6386	24.766	24.5276	24.6393	15765120.0
2012-09-24 17:00:00	AAPL	Stock	24.6354	24.6711	24.5732	24.5964	1021944.0
2012-09-24 18:00:00	AAPL	Stock	24.5889	24.5889	24.4643	24.525	1108464.0
2012-09-24 19:00:00	AAPL	Stock	24.5321	24.5357	24.5146	24.5321	479612.0
2012-09-24 07:00:00	MSFT	Stock	31.07	31.07	31.0	31.0	29225.0
2012-09-24 08:00:00	MSFT	Stock	31.07	31.23	31.0	31.0	34625.0
2012-09-24 09:00:00	MSFT	Stock	31.03	31.1	30.83	30.84	7845306.0
2012-09-24 10:00:00	MSFT	Stock	30.85	30.86	30.69	30.775	8255284.0
2012-09-24 11:00:00	MSFT	Stock	30.775	30.81	30.64	30.69	4703567.0
2012-09-24 12:00:00	MSFT	Stock	30.69	30.77	30.67	30.73	4179749.0
2012-09-24 13:00:00	MSFT	Stock	30.73	30.79	30.64	30.69	4020900.0
2012-09-24 14:00:00	MSFT	Stock	30.69	30.88	30.69	30.855	3146670.0
2012-09-24 15:00:00	MSFT	Stock	30.86	30.86	30.75	30.75	8433165.0
2012-09-24 16:00:00	MSFT	Stock	30.75	30.858	30.71	30.851	3223115.0
2012-09-24 17:00:00	MSFT	Stock	30.77	30.78	30.77	30.77	116667.0
2012-09-24 18:00:00	MSFT	Stock	30.77	30.77	30.77	30.77	300.0
2012-09-24 19:00:00	MSFT	Stock	30.77	30.77	30.74	30.77	18998.0
2012-09-24 08:00:00	NVDA	Stock	0.3418	0.3418	0.3375	0.338	38800.0
2012-09-24 09:00:00	NVDA	Stock	0.3418	0.3418	0.3356	0.3365	50009240.0
2012-09-24 10:00:00	NVDA	Stock	0.3365	0.3405	0.3362	0.3402	61481520.0
2012-09-24 11:00:00	NVDA	Stock	0.3402	0.3404	0.3382	0.3398	45035360.0
2012-09-24 12:00:00	NVDA	Stock	0.3398	0.34	0.3385	0.339	29655160.0
2012-09-24 13:00:00	NVDA	Stock	0.339	0.3395	0.3382	0.3388	36206240.0
2012-09-24 14:00:00	NVDA	Stock	0.3388	0.3408	0.3388	0.3405	27537560.0
2012-09-24 15:00:00	NVDA	Stock	0.3402	0.342	0.3402	0.3415	89205320.0
2012-09-24 16:00:00	NVDA	Stock	0.3413	0.342	0.3368	0.3368	12651560.0
2012-09-24 17:00:00	NVDA	Stock	0.3413	0.3415	0.3413	0.3413	1977320.0
2012-09-24 19:00:00	NVDA	Stock	0.3425	0.3425	0.3425	0.3425	40000.0
2012-09-24 05:00:00	AMZN	Stock	12.8305	12.8305	12.8305	12.8305	14000.0
2012-09-24 06:00:00	AMZN	Stock	12.8305	12.8305	12.8305	12.8305	4000.0
2012-09-24 07:00:00	AMZN	Stock	12.8105	12.8115	12.8	12.8055	64600.0
2012-09-24 08:00:00	AMZN	Stock	12.823	12.8755	12.775	12.7755	114960.0
2012-09-24 09:00:00	AMZN	Stock	12.7755	12.795	12.655	12.6875	11293480.0
2012-09-24 10:00:00	AMZN	Stock	12.6853	12.74	12.65	12.74	10434560.0
2012-09-24 11:00:00	AMZN	Stock	12.74	12.7705	12.7125	12.765	6638560.0
2012-09-24 12:00:00	AMZN	Stock	12.765	12.771	12.731	12.766	4616380.0
2012-09-24 13:00:00	AMZN	Stock	12.7675	12.78	12.718	12.727	3958460.0
2012-09-24 14:00:00	AMZN	Stock	12.723	12.7695	12.721	12.7548	3995540.0

> showing 50 of 45,136 rows — these rows as CSV

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