PREVIEW / stock_1hour / 2013-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-03.parquet
  size:    965 KB
  rows:    45,418
  symbols: 3,476

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-03 04:00:00	AAPL	Stock	19.6086	19.6086	19.5636	19.5643	30744.0
2013-01-03 05:00:00	AAPL	Stock	19.5218	19.5257	19.5218	19.5257	5600.0
2013-01-03 06:00:00	AAPL	Stock	19.5004	19.5386	19.5004	19.5386	23772.0
2013-01-03 07:00:00	AAPL	Stock	19.5389	19.5389	19.4954	19.5	448028.0
2013-01-03 08:00:00	AAPL	Stock	19.5	19.6082	19.4821	19.5439	1779876.0
2013-01-03 09:00:00	AAPL	Stock	19.5361	19.5936	19.4143	19.5804	62384840.0
2013-01-03 10:00:00	AAPL	Stock	19.5804	19.6311	19.5271	19.5471	56039648.0
2013-01-03 11:00:00	AAPL	Stock	19.5496	19.6125	19.52	19.5479	37170224.0
2013-01-03 12:00:00	AAPL	Stock	19.5446	19.6021	19.5443	19.5529	21907396.0
2013-01-03 13:00:00	AAPL	Stock	19.5518	19.5782	19.5	19.552	19743192.0
2013-01-03 14:00:00	AAPL	Stock	19.5489	19.5716	19.4464	19.4818	44942184.0
2013-01-03 15:00:00	AAPL	Stock	19.4796	19.4943	19.3214	19.3707	89704832.0
2013-01-03 16:00:00	AAPL	Stock	19.3657	19.5665	19.35	19.35	7663264.0
2013-01-03 17:00:00	AAPL	Stock	19.3468	19.35	19.3268	19.3321	380352.0
2013-01-03 18:00:00	AAPL	Stock	19.3321	19.3393	19.3246	19.3318	180684.0
2013-01-03 19:00:00	AAPL	Stock	19.3336	19.3571	19.3268	19.3571	325612.0
2013-01-03 06:00:00	MSFT	Stock	27.69	27.69	27.68	27.69	3100.0
2013-01-03 07:00:00	MSFT	Stock	27.56	27.56	27.53	27.55	9828.0
2013-01-03 08:00:00	MSFT	Stock	27.56	27.67	27.55	27.62	11151.0
2013-01-03 09:00:00	MSFT	Stock	27.62	27.65	27.39	27.47	4620469.0
2013-01-03 10:00:00	MSFT	Stock	27.47	27.54	27.37	27.38	6242358.0
2013-01-03 11:00:00	MSFT	Stock	27.38	27.51	27.38	27.425	5929705.0
2013-01-03 12:00:00	MSFT	Stock	27.427	27.44	27.33	27.355	4375921.0
2013-01-03 13:00:00	MSFT	Stock	27.35	27.4	27.31	27.35	2643531.0
2013-01-03 14:00:00	MSFT	Stock	27.35	27.37	27.16	27.32	7901459.0
2013-01-03 15:00:00	MSFT	Stock	27.32	27.33	27.19	27.28	10707218.0
2013-01-03 16:00:00	MSFT	Stock	27.28	27.438	27.25	27.32	3154942.0
2013-01-03 17:00:00	MSFT	Stock	27.32	27.33	27.32	27.32	4502.0
2013-01-03 18:00:00	MSFT	Stock	27.3	27.32	27.3	27.3	991.0
2013-01-03 19:00:00	MSFT	Stock	27.3	27.3	27.28	27.29	2741.0
2013-01-03 09:00:00	NVDA	Stock	0.3168	0.3188	0.3145	0.317	37986240.0
2013-01-03 10:00:00	NVDA	Stock	0.317	0.3198	0.3163	0.3193	47240200.0
2013-01-03 11:00:00	NVDA	Stock	0.3192	0.3205	0.3188	0.3205	33687880.0
2013-01-03 12:00:00	NVDA	Stock	0.3203	0.3215	0.3198	0.3205	28029720.0
2013-01-03 13:00:00	NVDA	Stock	0.3205	0.3216	0.3196	0.3215	33427200.0
2013-01-03 14:00:00	NVDA	Stock	0.3215	0.3218	0.319	0.3201	38663040.0
2013-01-03 15:00:00	NVDA	Stock	0.32	0.3203	0.3174	0.3183	63320760.0
2013-01-03 16:00:00	NVDA	Stock	0.3183	0.3189	0.3178	0.3178	11897640.0
2013-01-03 17:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	40000.0
2013-01-03 04:00:00	AMZN	Stock	12.7945	12.8405	12.7945	12.8405	4000.0
2013-01-03 05:00:00	AMZN	Stock	12.837	12.849	12.8295	12.849	6000.0
2013-01-03 08:00:00	AMZN	Stock	12.81	12.8665	12.7925	12.8	261560.0
2013-01-03 09:00:00	AMZN	Stock	12.8005	12.942	12.8	12.9415	7916440.0
2013-01-03 10:00:00	AMZN	Stock	12.942	12.988	12.905	12.952	9562760.0
2013-01-03 11:00:00	AMZN	Stock	12.951	12.999	12.935	12.9709	7032380.0
2013-01-03 12:00:00	AMZN	Stock	12.9698	12.9945	12.9569	12.9715	3092060.0
2013-01-03 13:00:00	AMZN	Stock	12.9665	13.044	12.9665	13.016	4803820.0
2013-01-03 14:00:00	AMZN	Stock	13.016	13.0375	12.9025	12.9351	6646640.0
2013-01-03 15:00:00	AMZN	Stock	12.931	12.9365	12.861	12.9255	11057000.0
2013-01-03 16:00:00	AMZN	Stock	12.924	12.9356	12.91	12.924	442880.0

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

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