PREVIEW / stock_1hour / 2012-05-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-21.parquet
  size:    940 KB
  rows:    44,394
  symbols: 3,524

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-05-21 04:00:00	AAPL	Stock	19.1071	19.1071	19.0	19.0714	18760.0
2012-05-21 05:00:00	AAPL	Stock	19.0714	19.0714	19.0714	19.0714	16800.0
2012-05-21 06:00:00	AAPL	Stock	19.0714	19.1071	19.0571	19.1071	31416.0
2012-05-21 07:00:00	AAPL	Stock	19.1429	19.1429	19.0721	19.0846	326340.0
2012-05-21 08:00:00	AAPL	Stock	19.0768	19.1071	19.045	19.0575	4377912.0
2012-05-21 09:00:00	AAPL	Stock	19.0639	19.2543	19.0564	19.19	67702516.0
2012-05-21 10:00:00	AAPL	Stock	19.1925	19.6246	19.1511	19.5261	139170556.0
2012-05-21 11:00:00	AAPL	Stock	19.525	19.5657	19.4464	19.5446	67692016.0
2012-05-21 12:00:00	AAPL	Stock	19.5418	19.8036	19.525	19.7461	100056964.0
2012-05-21 13:00:00	AAPL	Stock	19.7493	19.8093	19.7336	19.7697	38940776.0
2012-05-21 14:00:00	AAPL	Stock	19.7721	19.9121	19.6821	19.8965	64599416.0
2012-05-21 15:00:00	AAPL	Stock	19.8915	20.055	19.8518	20.0464	119295484.0
2012-05-21 16:00:00	AAPL	Stock	20.0457	20.1196	19.1982	20.1071	18730068.0
2012-05-21 17:00:00	AAPL	Stock	20.1075	20.1679	20.0457	20.1561	2523780.0
2012-05-21 18:00:00	AAPL	Stock	20.15	20.1643	20.1268	20.1429	594748.0
2012-05-21 19:00:00	AAPL	Stock	20.1357	20.1529	20.1325	20.1429	441980.0
2012-05-21 07:00:00	MSFT	Stock	29.5	29.67	29.45	29.45	13892.0
2012-05-21 08:00:00	MSFT	Stock	29.5	29.5	29.2	29.22	22980.0
2012-05-21 09:00:00	MSFT	Stock	29.23	29.34	29.06	29.32	4982090.0
2012-05-21 10:00:00	MSFT	Stock	29.31	29.55	29.29	29.505	6182950.0
2012-05-21 11:00:00	MSFT	Stock	29.5	29.54	29.4	29.475	4254577.0
2012-05-21 12:00:00	MSFT	Stock	29.478	29.79	29.45	29.65	4083802.0
2012-05-21 13:00:00	MSFT	Stock	29.655	29.67	29.555	29.58	2982734.0
2012-05-21 14:00:00	MSFT	Stock	29.58	29.65	29.51	29.635	2824368.0
2012-05-21 15:00:00	MSFT	Stock	29.64	29.79	29.635	29.75	8605624.0
2012-05-21 16:00:00	MSFT	Stock	29.74	29.79	29.23	29.75	3908591.0
2012-05-21 17:00:00	MSFT	Stock	29.75	29.75	29.7	29.75	4547.0
2012-05-21 18:00:00	MSFT	Stock	29.74	29.75	29.74	29.75	905.0
2012-05-21 19:00:00	MSFT	Stock	29.75	29.77	29.75	29.77	6352.0
2012-05-21 07:00:00	NVDA	Stock	0.305	0.305	0.305	0.305	40000.0
2012-05-21 08:00:00	NVDA	Stock	0.3038	0.3045	0.3038	0.304	192000.0
2012-05-21 09:00:00	NVDA	Stock	0.304	0.3042	0.3004	0.3022	54303200.0
2012-05-21 10:00:00	NVDA	Stock	0.3022	0.3062	0.3018	0.3058	82004560.0
2012-05-21 11:00:00	NVDA	Stock	0.3058	0.307	0.3045	0.3048	48343520.0
2012-05-21 12:00:00	NVDA	Stock	0.3048	0.308	0.3045	0.307	41139840.0
2012-05-21 13:00:00	NVDA	Stock	0.307	0.308	0.306	0.3075	31542040.0
2012-05-21 14:00:00	NVDA	Stock	0.3078	0.308	0.306	0.3069	31696480.0
2012-05-21 15:00:00	NVDA	Stock	0.3068	0.3088	0.3065	0.3074	103042840.0
2012-05-21 16:00:00	NVDA	Stock	0.3073	0.3087	0.3057	0.3073	4539960.0
2012-05-21 17:00:00	NVDA	Stock	0.3073	0.3083	0.3073	0.3083	811040.0
2012-05-21 18:00:00	NVDA	Stock	0.3083	0.3088	0.3083	0.3088	99400.0
2012-05-21 19:00:00	NVDA	Stock	0.3085	0.3085	0.3085	0.3085	40000.0
2012-05-21 05:00:00	AMZN	Stock	10.735	10.743	10.735	10.743	7500.0
2012-05-21 07:00:00	AMZN	Stock	10.7835	10.7835	10.736	10.736	4980.0
2012-05-21 08:00:00	AMZN	Stock	10.735	10.755	10.73	10.748	90400.0
2012-05-21 09:00:00	AMZN	Stock	10.726	10.7925	10.641	10.735	10515660.0
2012-05-21 10:00:00	AMZN	Stock	10.7265	10.917	10.6895	10.9062	14053740.0
2012-05-21 11:00:00	AMZN	Stock	10.9045	10.9115	10.827	10.858	8990720.0
2012-05-21 12:00:00	AMZN	Stock	10.8625	10.999	10.8495	10.9165	11506540.0
2012-05-21 13:00:00	AMZN	Stock	10.9175	10.937	10.884	10.9166	5402380.0

> showing 50 of 44,394 rows — these rows as CSV

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