PREVIEW / stock_1hour / 2012-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-19.parquet
  size:    968 KB
  rows:    45,345
  symbols: 3,495

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
2012-12-19 04:00:00	AAPL	Stock	19.1196	19.1429	19.0689	19.1054	130676.0
2012-12-19 05:00:00	AAPL	Stock	19.105	19.1214	19.0714	19.0732	103012.0
2012-12-19 06:00:00	AAPL	Stock	19.0889	19.1232	19.0739	19.0739	56000.0
2012-12-19 07:00:00	AAPL	Stock	19.0714	19.1032	19.0021	19.0161	756896.0
2012-12-19 08:00:00	AAPL	Stock	19.0161	19.1036	18.8893	18.9571	4969048.0
2012-12-19 09:00:00	AAPL	Stock	18.9514	19.0536	18.8929	18.9136	70962612.0
2012-12-19 10:00:00	AAPL	Stock	18.9121	18.9614	18.7679	18.9289	98466424.0
2012-12-19 11:00:00	AAPL	Stock	18.9286	19.0607	18.9182	18.9365	66043936.0
2012-12-19 12:00:00	AAPL	Stock	18.9407	18.9929	18.9071	18.9375	41480404.0
2012-12-19 13:00:00	AAPL	Stock	18.9354	18.9554	18.8304	18.8964	37743216.0
2012-12-19 14:00:00	AAPL	Stock	18.8929	18.9107	18.8307	18.8976	36658468.0
2012-12-19 15:00:00	AAPL	Stock	18.8975	18.925	18.7893	18.7896	73214932.0
2012-12-19 16:00:00	AAPL	Stock	18.7971	19.0714	18.7693	18.8071	11416160.0
2012-12-19 17:00:00	AAPL	Stock	18.8089	18.8164	18.7821	18.7871	689920.0
2012-12-19 18:00:00	AAPL	Stock	18.7871	18.7968	18.7768	18.7839	534996.0
2012-12-19 19:00:00	AAPL	Stock	18.7804	18.7854	18.7589	18.775	475412.0
2012-12-19 04:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	100.0
2012-12-19 05:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	350.0
2012-12-19 06:00:00	MSFT	Stock	27.6	27.7	27.6	27.6	3150.0
2012-12-19 07:00:00	MSFT	Stock	27.59	27.6	27.55	27.55	968.0
2012-12-19 08:00:00	MSFT	Stock	27.57	27.67	27.55	27.57	28230.0
2012-12-19 09:00:00	MSFT	Stock	27.57	27.73	27.49	27.52	6000824.0
2012-12-19 10:00:00	MSFT	Stock	27.52	27.56	27.34	27.39	6236152.0
2012-12-19 11:00:00	MSFT	Stock	27.395	27.42	27.31	27.315	6188392.0
2012-12-19 12:00:00	MSFT	Stock	27.315	27.36	27.25	27.33	4536300.0
2012-12-19 13:00:00	MSFT	Stock	27.334	27.34	27.28	27.32	4425239.0
2012-12-19 14:00:00	MSFT	Stock	27.315	27.33	27.25	27.285	6082191.0
2012-12-19 15:00:00	MSFT	Stock	27.29	27.36	27.25	27.31	11183906.0
2012-12-19 16:00:00	MSFT	Stock	27.31	27.613	27.285	27.3	8118274.0
2012-12-19 17:00:00	MSFT	Stock	27.417	27.417	27.3	27.3	17410.0
2012-12-19 18:00:00	MSFT	Stock	27.3	27.3	27.28	27.3	1750.0
2012-12-19 19:00:00	MSFT	Stock	27.29	27.31	27.29	27.31	2606.0
2012-12-19 09:00:00	NVDA	Stock	0.314	0.3188	0.314	0.3155	37976440.0
2012-12-19 10:00:00	NVDA	Stock	0.3155	0.3173	0.315	0.3163	80485080.0
2012-12-19 11:00:00	NVDA	Stock	0.3163	0.3183	0.316	0.3173	72701000.0
2012-12-19 12:00:00	NVDA	Stock	0.3173	0.3188	0.317	0.3186	35053720.0
2012-12-19 13:00:00	NVDA	Stock	0.3188	0.3198	0.3183	0.3196	64126960.0
2012-12-19 14:00:00	NVDA	Stock	0.3196	0.32	0.317	0.3183	63046040.0
2012-12-19 15:00:00	NVDA	Stock	0.3183	0.3193	0.3163	0.3163	76657520.0
2012-12-19 16:00:00	NVDA	Stock	0.3163	0.3188	0.3155	0.3155	8215640.0
2012-12-19 17:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	4000.0
2012-12-19 18:00:00	NVDA	Stock	0.3188	0.3188	0.3188	0.3188	8000.0
2012-12-19 04:00:00	AMZN	Stock	13.0335	13.0335	13.0335	13.0335	5000.0
2012-12-19 07:00:00	AMZN	Stock	13.04	13.05	13.04	13.05	20100.0
2012-12-19 08:00:00	AMZN	Stock	13.05	13.0915	13.0	13.075	475600.0
2012-12-19 09:00:00	AMZN	Stock	13.075	13.131	12.911	12.928	9003540.0
2012-12-19 10:00:00	AMZN	Stock	12.9285	12.9845	12.884	12.9707	6732820.0
2012-12-19 11:00:00	AMZN	Stock	12.9709	12.9985	12.9244	12.9285	5661700.0
2012-12-19 12:00:00	AMZN	Stock	12.9295	12.959	12.8995	12.9325	3182660.0
2012-12-19 13:00:00	AMZN	Stock	12.9315	12.958	12.896	12.9503	3524740.0

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

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