PREVIEW / stock_1hour / 2015-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-19.parquet
  size:    1.1 MB
  rows:    50,435
  symbols: 3,509

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-03-19 04:00:00	AAPL	Stock	32.0	32.125	31.9925	32.0625	129984.0
2015-03-19 05:00:00	AAPL	Stock	32.0625	32.0975	32.0625	32.075	16000.0
2015-03-19 06:00:00	AAPL	Stock	32.075	32.225	32.075	32.1525	76700.0
2015-03-19 07:00:00	AAPL	Stock	32.175	32.1875	32.135	32.15	141160.0
2015-03-19 08:00:00	AAPL	Stock	32.15	32.215	32.1175	32.17	719036.0
2015-03-19 09:00:00	AAPL	Stock	32.1825	32.3112	32.075	32.1305	31028772.0
2015-03-19 10:00:00	AAPL	Stock	32.13	32.1575	32.015	32.0925	28261272.0
2015-03-19 11:00:00	AAPL	Stock	32.09	32.1225	31.955	32.045	21969748.0
2015-03-19 12:00:00	AAPL	Stock	32.0462	32.055	31.875	31.875	15119648.0
2015-03-19 13:00:00	AAPL	Stock	31.875	32.0475	31.85	31.9235	17538036.0
2015-03-19 14:00:00	AAPL	Stock	31.9228	32.0475	31.915	32.0438	12844956.0
2015-03-19 15:00:00	AAPL	Stock	32.0448	32.0625	31.8575	31.8725	28210976.0
2015-03-19 16:00:00	AAPL	Stock	31.8738	32.0315	31.835	31.84	15647572.0
2015-03-19 17:00:00	AAPL	Stock	31.84	31.8738	31.825	31.84	296052.0
2015-03-19 18:00:00	AAPL	Stock	31.835	31.8738	31.8325	31.8425	112008.0
2015-03-19 19:00:00	AAPL	Stock	31.8375	31.8425	31.825	31.84	198492.0
2015-03-19 05:00:00	MSFT	Stock	42.47	42.47	42.47	42.47	800.0
2015-03-19 07:00:00	MSFT	Stock	42.42	42.45	42.42	42.45	900.0
2015-03-19 08:00:00	MSFT	Stock	42.44	42.44	42.33	42.33	7459.0
2015-03-19 09:00:00	MSFT	Stock	42.39	42.49	42.22	42.4	3295681.0
2015-03-19 10:00:00	MSFT	Stock	42.39	42.59	42.36	42.58	3349508.0
2015-03-19 11:00:00	MSFT	Stock	42.58	42.59	42.4	42.476	2821931.0
2015-03-19 12:00:00	MSFT	Stock	42.48	42.53	42.4	42.425	2121854.0
2015-03-19 13:00:00	MSFT	Stock	42.42	42.55	42.4	42.417	2019235.0
2015-03-19 14:00:00	MSFT	Stock	42.42	42.505	42.34	42.35	3666098.0
2015-03-19 15:00:00	MSFT	Stock	42.355	42.47	42.28	42.28	9532381.0
2015-03-19 16:00:00	MSFT	Stock	42.3	42.501	42.285	42.446	5884151.0
2015-03-19 17:00:00	MSFT	Stock	42.33	42.48	42.285	42.285	68105.0
2015-03-19 19:00:00	MSFT	Stock	42.37	42.37	42.37	42.37	650.0
2015-03-19 08:00:00	NVDA	Stock	0.5712	0.5712	0.5712	0.5712	4000.0
2015-03-19 09:00:00	NVDA	Stock	0.5738	0.575	0.5695	0.5739	22356560.0
2015-03-19 10:00:00	NVDA	Stock	0.5739	0.581	0.5732	0.5795	53948680.0
2015-03-19 11:00:00	NVDA	Stock	0.5797	0.58	0.577	0.5795	30596440.0
2015-03-19 12:00:00	NVDA	Stock	0.5798	0.5802	0.5782	0.5799	34607360.0
2015-03-19 13:00:00	NVDA	Stock	0.5798	0.581	0.5792	0.5802	18798560.0
2015-03-19 14:00:00	NVDA	Stock	0.5805	0.5825	0.5801	0.581	27086160.0
2015-03-19 15:00:00	NVDA	Stock	0.581	0.5812	0.578	0.5802	81314800.0
2015-03-19 16:00:00	NVDA	Stock	0.5804	0.5809	0.579	0.5793	24784040.0
2015-03-19 17:00:00	NVDA	Stock	0.5804	0.5804	0.5804	0.5804	923640.0
2015-03-19 07:00:00	AMZN	Stock	18.7445	18.7445	18.7445	18.7445	2000.0
2015-03-19 08:00:00	AMZN	Stock	18.708	18.7495	18.67	18.689	34020.0
2015-03-19 09:00:00	AMZN	Stock	18.675	18.7955	18.63	18.7365	5802700.0
2015-03-19 10:00:00	AMZN	Stock	18.729	18.8555	18.687	18.7705	6526660.0
2015-03-19 11:00:00	AMZN	Stock	18.772	18.8115	18.725	18.7715	3296560.0
2015-03-19 12:00:00	AMZN	Stock	18.766	18.773	18.6155	18.619	3599120.0
2015-03-19 13:00:00	AMZN	Stock	18.6182	18.735	18.6095	18.67	4330860.0
2015-03-19 14:00:00	AMZN	Stock	18.6682	18.7245	18.653	18.69	2630220.0
2015-03-19 15:00:00	AMZN	Stock	18.6845	18.7186	18.6485	18.6595	6006120.0
2015-03-19 16:00:00	AMZN	Stock	18.66	18.764	18.66	18.662	243000.0
2015-03-19 17:00:00	AMZN	Stock	18.662	18.666	18.662	18.662	56880.0

> showing 50 of 50,435 rows — these rows as CSV

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