PREVIEW / stock_1hour / 2015-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-18.parquet
  size:    1.1 MB
  rows:    50,123
  symbols: 3,459

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-09-18 04:00:00	AAPL	Stock	28.525	28.575	28.4975	28.5	16260.0
2015-09-18 05:00:00	AAPL	Stock	28.5	28.5475	28.45	28.45	48260.0
2015-09-18 06:00:00	AAPL	Stock	28.455	28.47	28.275	28.31	86964.0
2015-09-18 07:00:00	AAPL	Stock	28.31	28.3175	28.2025	28.24	260780.0
2015-09-18 08:00:00	AAPL	Stock	28.2475	28.4425	28.19	28.235	975620.0
2015-09-18 09:00:00	AAPL	Stock	28.235	28.3275	27.955	28.3225	69002644.0
2015-09-18 10:00:00	AAPL	Stock	28.3175	28.575	28.29	28.385	35419772.0
2015-09-18 11:00:00	AAPL	Stock	28.385	28.575	28.3825	28.5075	22482896.0
2015-09-18 12:00:00	AAPL	Stock	28.51	28.52	28.335	28.3775	17974236.0
2015-09-18 13:00:00	AAPL	Stock	28.3708	28.5208	28.3238	28.3512	20484500.0
2015-09-18 14:00:00	AAPL	Stock	28.35	28.525	28.325	28.485	18466092.0
2015-09-18 15:00:00	AAPL	Stock	28.485	28.5225	28.33	28.3725	37904140.0
2015-09-18 16:00:00	AAPL	Stock	28.3625	28.4125	28.3125	28.38	41495752.0
2015-09-18 17:00:00	AAPL	Stock	28.385	28.3925	28.359	28.3925	347440.0
2015-09-18 18:00:00	AAPL	Stock	28.38	28.38	28.3625	28.3775	43056.0
2015-09-18 19:00:00	AAPL	Stock	28.38	28.38	28.3625	28.3625	959628.0
2015-09-18 06:00:00	MSFT	Stock	44.0	44.0	43.98	43.98	600.0
2015-09-18 07:00:00	MSFT	Stock	43.7	43.78	43.7	43.7	2400.0
2015-09-18 08:00:00	MSFT	Stock	43.7	43.75	43.65	43.75	20150.0
2015-09-18 09:00:00	MSFT	Stock	43.7	43.79	43.43	43.509	18536060.0
2015-09-18 10:00:00	MSFT	Stock	43.51	43.75	43.44	43.69	4320882.0
2015-09-18 11:00:00	MSFT	Stock	43.69	43.99	43.68	43.85	2550349.0
2015-09-18 12:00:00	MSFT	Stock	43.85	43.86	43.44	43.54	2570747.0
2015-09-18 13:00:00	MSFT	Stock	43.545	43.63	43.33	43.37	2650032.0
2015-09-18 14:00:00	MSFT	Stock	43.37	43.7	43.33	43.62	2565598.0
2015-09-18 15:00:00	MSFT	Stock	43.63	43.68	43.36	43.48	7004464.0
2015-09-18 16:00:00	MSFT	Stock	43.48	43.6	43.44	43.54	15103872.0
2015-09-18 17:00:00	MSFT	Stock	43.7	43.71	43.475	43.62	95228.0
2015-09-18 18:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	255.0
2015-09-18 19:00:00	MSFT	Stock	43.48	43.62	43.48	43.62	127150.0
2015-09-18 07:00:00	NVDA	Stock	0.5775	0.5775	0.5775	0.5775	8000.0
2015-09-18 08:00:00	NVDA	Stock	0.5792	0.5792	0.5792	0.5792	4000.0
2015-09-18 09:00:00	NVDA	Stock	0.5745	0.5815	0.5712	0.5812	58999280.0
2015-09-18 10:00:00	NVDA	Stock	0.5812	0.5848	0.5795	0.5844	30751480.0
2015-09-18 11:00:00	NVDA	Stock	0.5843	0.5872	0.584	0.584	19117400.0
2015-09-18 12:00:00	NVDA	Stock	0.584	0.5841	0.5808	0.5819	15204120.0
2015-09-18 13:00:00	NVDA	Stock	0.5818	0.5826	0.5788	0.579	21180000.0
2015-09-18 14:00:00	NVDA	Stock	0.579	0.5828	0.5785	0.5824	22659840.0
2015-09-18 15:00:00	NVDA	Stock	0.5828	0.5832	0.5804	0.5825	83536760.0
2015-09-18 16:00:00	NVDA	Stock	0.5825	0.5825	0.5822	0.5822	47453040.0
2015-09-18 17:00:00	NVDA	Stock	0.587	0.587	0.5822	0.5822	341680.0
2015-09-18 19:00:00	NVDA	Stock	0.5822	0.5822	0.5822	0.5822	336280.0
2015-09-18 04:00:00	AMZN	Stock	26.901	26.901	26.901	26.901	2000.0
2015-09-18 05:00:00	AMZN	Stock	26.8655	26.9215	26.856	26.856	9020.0
2015-09-18 06:00:00	AMZN	Stock	26.7365	26.7415	26.735	26.7415	32000.0
2015-09-18 07:00:00	AMZN	Stock	26.7405	26.75	26.651	26.668	124760.0
2015-09-18 08:00:00	AMZN	Stock	26.7095	26.7585	26.6575	26.7	296400.0
2015-09-18 09:00:00	AMZN	Stock	26.737	26.93	26.5505	26.904	27808560.0
2015-09-18 10:00:00	AMZN	Stock	26.9195	27.1245	26.85	27.085	13160480.0
2015-09-18 11:00:00	AMZN	Stock	27.095	27.3118	27.0635	27.2682	14117760.0

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

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