PREVIEW / stock_1hour / 2015-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-08.parquet
  size:    1.0 MB
  rows:    48,177
  symbols: 3,496

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
2015-04-08 04:00:00	AAPL	Stock	32.5	32.5	31.3325	31.3375	129604.0
2015-04-08 05:00:00	AAPL	Stock	31.345	31.39	31.3125	31.3475	80808.0
2015-04-08 06:00:00	AAPL	Stock	31.3075	31.4125	31.2775	31.3475	91620.0
2015-04-08 07:00:00	AAPL	Stock	31.3375	31.45	31.32	31.45	215452.0
2015-04-08 08:00:00	AAPL	Stock	31.44	31.4775	31.32	31.42	783816.0
2015-04-08 09:00:00	AAPL	Stock	31.4225	31.6	31.2775	31.4938	27087776.0
2015-04-08 10:00:00	AAPL	Stock	31.495	31.575	31.2425	31.3325	30883540.0
2015-04-08 11:00:00	AAPL	Stock	31.335	31.435	31.305	31.42	12900908.0
2015-04-08 12:00:00	AAPL	Stock	31.4225	31.5275	31.365	31.375	12848684.0
2015-04-08 13:00:00	AAPL	Stock	31.3775	31.445	31.3125	31.41	11756264.0
2015-04-08 14:00:00	AAPL	Stock	31.4125	31.5188	31.2962	31.3732	19433540.0
2015-04-08 15:00:00	AAPL	Stock	31.375	31.4125	31.3	31.4	18527160.0
2015-04-08 16:00:00	AAPL	Stock	31.3975	31.435	31.3862	31.435	5107376.0
2015-04-08 17:00:00	AAPL	Stock	31.43	31.47	31.43	31.465	193020.0
2015-04-08 18:00:00	AAPL	Stock	31.4698	31.4725	31.4575	31.4575	98388.0
2015-04-08 19:00:00	AAPL	Stock	31.4575	31.4625	31.4425	31.45	28496.0
2015-04-08 05:00:00	MSFT	Stock	41.42	41.42	41.42	41.42	100.0
2015-04-08 08:00:00	MSFT	Stock	41.57	41.57	41.519	41.519	4600.0
2015-04-08 09:00:00	MSFT	Stock	41.52	41.69	41.33	41.65	3002543.0
2015-04-08 10:00:00	MSFT	Stock	41.65	41.677	41.16	41.28	4143527.0
2015-04-08 11:00:00	MSFT	Stock	41.28	41.39	41.25	41.273	2314605.0
2015-04-08 12:00:00	MSFT	Stock	41.274	41.3	41.16	41.26	2245619.0
2015-04-08 13:00:00	MSFT	Stock	41.264	41.28	41.17	41.2	1777054.0
2015-04-08 14:00:00	MSFT	Stock	41.2	41.43	41.04	41.21	3551030.0
2015-04-08 15:00:00	MSFT	Stock	41.21	41.44	41.18	41.42	4662962.0
2015-04-08 16:00:00	MSFT	Stock	41.42	41.43	40.98	41.42	1589654.0
2015-04-08 17:00:00	MSFT	Stock	41.43	41.43	41.42	41.43	7269.0
2015-04-08 18:00:00	MSFT	Stock	41.43	41.43	41.43	41.43	460.0
2015-04-08 19:00:00	MSFT	Stock	41.43	41.45	41.43	41.45	2500.0
2015-04-08 07:00:00	NVDA	Stock	0.545	0.545	0.545	0.545	8000.0
2015-04-08 09:00:00	NVDA	Stock	0.547	0.5482	0.5428	0.544	31993360.0
2015-04-08 10:00:00	NVDA	Stock	0.544	0.545	0.5418	0.5445	45809520.0
2015-04-08 11:00:00	NVDA	Stock	0.5445	0.5468	0.5441	0.5458	46352920.0
2015-04-08 12:00:00	NVDA	Stock	0.5459	0.5482	0.5455	0.547	31848120.0
2015-04-08 13:00:00	NVDA	Stock	0.547	0.5486	0.5462	0.5472	31344680.0
2015-04-08 14:00:00	NVDA	Stock	0.5475	0.5512	0.5462	0.5484	49636040.0
2015-04-08 15:00:00	NVDA	Stock	0.5484	0.5525	0.5482	0.5508	105886560.0
2015-04-08 16:00:00	NVDA	Stock	0.5505	0.5508	0.55	0.5508	11167320.0
2015-04-08 17:00:00	NVDA	Stock	0.5505	0.5525	0.5505	0.5525	10000.0
2015-04-08 07:00:00	AMZN	Stock	18.764	18.8195	18.764	18.8195	14000.0
2015-04-08 08:00:00	AMZN	Stock	18.7705	18.84	18.7705	18.84	18620.0
2015-04-08 09:00:00	AMZN	Stock	18.8195	19.027	18.7325	19.0075	8236140.0
2015-04-08 10:00:00	AMZN	Stock	19.014	19.025	18.929	18.9755	9098240.0
2015-04-08 11:00:00	AMZN	Stock	18.9765	19.0775	18.945	19.0445	6062060.0
2015-04-08 12:00:00	AMZN	Stock	19.047	19.079	19.0005	19.029	3945680.0
2015-04-08 13:00:00	AMZN	Stock	19.029	19.033	18.9455	19.0295	3357080.0
2015-04-08 14:00:00	AMZN	Stock	19.019	19.0605	18.964	18.9995	5173120.0
2015-04-08 15:00:00	AMZN	Stock	18.9995	19.064	18.976	19.06	7379240.0
2015-04-08 16:00:00	AMZN	Stock	19.06	19.073	19.0555	19.073	1973500.0
2015-04-08 17:00:00	AMZN	Stock	19.0735	19.095	19.0735	19.095	4000.0

> showing 50 of 48,177 rows — these rows as CSV

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