PREVIEW / stock_1hour / 2013-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-07.parquet
  size:    958 KB
  rows:    45,223
  symbols: 3,480

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-01-07 04:00:00	AAPL	Stock	18.8214	18.8214	18.75	18.7636	84000.0
2013-01-07 05:00:00	AAPL	Stock	18.7796	18.7796	18.7375	18.7375	81060.0
2013-01-07 06:00:00	AAPL	Stock	18.7325	18.7507	18.7325	18.7504	26600.0
2013-01-07 07:00:00	AAPL	Stock	18.7679	18.7679	18.6079	18.6407	735700.0
2013-01-07 08:00:00	AAPL	Stock	18.6429	18.6946	18.5804	18.615	3696364.0
2013-01-07 09:00:00	AAPL	Stock	18.6079	18.7321	18.4	18.4411	100827944.0
2013-01-07 10:00:00	AAPL	Stock	18.4336	18.7318	18.4315	18.6772	91782012.0
2013-01-07 11:00:00	AAPL	Stock	18.6821	18.9036	18.6679	18.6989	81413108.0
2013-01-07 12:00:00	AAPL	Stock	18.6964	18.7261	18.6107	18.6875	43149120.0
2013-01-07 13:00:00	AAPL	Stock	18.6834	18.7393	18.6229	18.6596	27596324.0
2013-01-07 14:00:00	AAPL	Stock	18.6607	18.7118	18.5814	18.6304	32947712.0
2013-01-07 15:00:00	AAPL	Stock	18.6282	18.8104	18.6021	18.7132	81428284.0
2013-01-07 16:00:00	AAPL	Stock	18.7132	18.7542	18.6509	18.6821	15883000.0
2013-01-07 17:00:00	AAPL	Stock	18.6786	18.6964	18.6786	18.6879	328608.0
2013-01-07 18:00:00	AAPL	Stock	18.6943	18.6964	18.6854	18.6868	126784.0
2013-01-07 19:00:00	AAPL	Stock	18.6918	18.6932	18.6518	18.6636	446292.0
2013-01-07 04:00:00	MSFT	Stock	26.86	26.86	26.86	26.86	100.0
2013-01-07 06:00:00	MSFT	Stock	26.75	26.86	26.75	26.79	970.0
2013-01-07 07:00:00	MSFT	Stock	26.84	26.88	26.8	26.88	4322.0
2013-01-07 08:00:00	MSFT	Stock	26.83	26.88	26.71	26.86	55491.0
2013-01-07 09:00:00	MSFT	Stock	26.81	26.85	26.64	26.65	6299718.0
2013-01-07 10:00:00	MSFT	Stock	26.66	26.88	26.64	26.77	6660618.0
2013-01-07 11:00:00	MSFT	Stock	26.772	26.84	26.72	26.75	4093772.0
2013-01-07 12:00:00	MSFT	Stock	26.75	26.79	26.73	26.77	3963545.0
2013-01-07 13:00:00	MSFT	Stock	26.77	26.79	26.72	26.74	3104110.0
2013-01-07 14:00:00	MSFT	Stock	26.735	26.75	26.7	26.716	3792516.0
2013-01-07 15:00:00	MSFT	Stock	26.715	26.74	26.68	26.71	7204376.0
2013-01-07 16:00:00	MSFT	Stock	26.72	26.824	26.69	26.74	1550856.0
2013-01-07 17:00:00	MSFT	Stock	26.72	26.74	26.71	26.71	10314.0
2013-01-07 18:00:00	MSFT	Stock	26.72	26.72	26.7	26.72	18587.0
2013-01-07 19:00:00	MSFT	Stock	26.72	26.72	26.7	26.71	6575.0
2013-01-07 05:00:00	NVDA	Stock	0.3348	0.3348	0.3348	0.3348	40000.0
2013-01-07 06:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	48000.0
2013-01-07 07:00:00	NVDA	Stock	0.3338	0.337	0.3325	0.3325	793880.0
2013-01-07 08:00:00	NVDA	Stock	0.3318	0.335	0.3295	0.33	2018200.0
2013-01-07 09:00:00	NVDA	Stock	0.33	0.3373	0.322	0.3225	112690480.0
2013-01-07 10:00:00	NVDA	Stock	0.3225	0.3245	0.319	0.3205	136576560.0
2013-01-07 11:00:00	NVDA	Stock	0.3205	0.3205	0.317	0.3187	67636320.0
2013-01-07 12:00:00	NVDA	Stock	0.3185	0.3215	0.3176	0.3204	83262360.0
2013-01-07 13:00:00	NVDA	Stock	0.3204	0.3218	0.3198	0.3205	44969600.0
2013-01-07 14:00:00	NVDA	Stock	0.3204	0.3215	0.319	0.3193	42317920.0
2013-01-07 15:00:00	NVDA	Stock	0.3193	0.3208	0.3188	0.3195	87780840.0
2013-01-07 16:00:00	NVDA	Stock	0.3193	0.3212	0.3192	0.3192	12889480.0
2013-01-07 17:00:00	NVDA	Stock	0.32	0.32	0.32	0.32	8000.0
2013-01-07 18:00:00	NVDA	Stock	0.32	0.3205	0.32	0.3205	48200.0
2013-01-07 19:00:00	NVDA	Stock	0.3205	0.3208	0.3205	0.3208	120600.0
2013-01-07 04:00:00	AMZN	Stock	13.08	13.16	13.08	13.16	21980.0
2013-01-07 05:00:00	AMZN	Stock	13.23	13.23	13.162	13.162	13100.0
2013-01-07 06:00:00	AMZN	Stock	13.201	13.2685	13.201	13.2685	81000.0
2013-01-07 07:00:00	AMZN	Stock	13.2525	13.27	13.2075	13.2225	313800.0

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

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