PREVIEW / stock_1hour / 2012-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-15.parquet
  size:    926 KB
  rows:    43,837
  symbols: 3,478

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-10-15 04:00:00	AAPL	Stock	22.5357	22.6071	22.5357	22.6071	67200.0
2012-10-15 05:00:00	AAPL	Stock	22.6071	22.6393	22.6071	22.6393	12488.0
2012-10-15 06:00:00	AAPL	Stock	22.6268	22.6346	22.6268	22.6346	20580.0
2012-10-15 07:00:00	AAPL	Stock	22.625	22.6436	22.6004	22.6146	434448.0
2012-10-15 08:00:00	AAPL	Stock	22.6129	22.6325	22.5536	22.5636	1841700.0
2012-10-15 09:00:00	AAPL	Stock	22.5621	22.6686	22.455	22.5186	53158784.0
2012-10-15 10:00:00	AAPL	Stock	22.5186	22.5836	22.2804	22.3848	86890776.0
2012-10-15 11:00:00	AAPL	Stock	22.3918	22.5804	22.3521	22.4643	66662764.0
2012-10-15 12:00:00	AAPL	Stock	22.4643	22.525	22.3907	22.465	36482824.0
2012-10-15 13:00:00	AAPL	Stock	22.4718	22.545	22.3779	22.4243	35929096.0
2012-10-15 14:00:00	AAPL	Stock	22.4236	22.53	22.4236	22.4857	28035056.0
2012-10-15 15:00:00	AAPL	Stock	22.4871	22.6832	22.4554	22.6696	84337260.0
2012-10-15 16:00:00	AAPL	Stock	22.67	22.6768	22.4188	22.6607	23446220.0
2012-10-15 17:00:00	AAPL	Stock	22.6611	22.6911	22.6611	22.6904	532140.0
2012-10-15 18:00:00	AAPL	Stock	22.6893	22.71	22.6893	22.7071	288288.0
2012-10-15 19:00:00	AAPL	Stock	22.7036	22.73	22.6929	22.7271	339024.0
2012-10-15 07:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	500.0
2012-10-15 08:00:00	MSFT	Stock	29.32	29.43	29.32	29.38	17795.0
2012-10-15 09:00:00	MSFT	Stock	29.37	29.49	29.29	29.345	4346419.0
2012-10-15 10:00:00	MSFT	Stock	29.34	29.45	29.25	29.29	5728846.0
2012-10-15 11:00:00	MSFT	Stock	29.29	29.49	29.27	29.485	4296784.0
2012-10-15 12:00:00	MSFT	Stock	29.48	29.72	29.48	29.59	6384591.0
2012-10-15 13:00:00	MSFT	Stock	29.58	29.66	29.53	29.55	3937776.0
2012-10-15 14:00:00	MSFT	Stock	29.54	29.57	29.4	29.46	3824841.0
2012-10-15 15:00:00	MSFT	Stock	29.46	29.54	29.44	29.505	7686831.0
2012-10-15 16:00:00	MSFT	Stock	29.51	29.556	29.329	29.48	4686532.0
2012-10-15 17:00:00	MSFT	Stock	29.51	29.52	29.51	29.52	21898.0
2012-10-15 18:00:00	MSFT	Stock	29.49	29.54	29.49	29.54	2611.0
2012-10-15 19:00:00	MSFT	Stock	29.52	29.54	29.51	29.54	6691.0
2012-10-15 07:00:00	NVDA	Stock	0.3165	0.3165	0.3165	0.3165	28000.0
2012-10-15 08:00:00	NVDA	Stock	0.3175	0.3175	0.3175	0.3175	7000.0
2012-10-15 09:00:00	NVDA	Stock	0.318	0.3188	0.3138	0.3145	33979320.0
2012-10-15 10:00:00	NVDA	Stock	0.3143	0.3155	0.3125	0.3155	45552560.0
2012-10-15 11:00:00	NVDA	Stock	0.3155	0.3185	0.3153	0.3176	35180440.0
2012-10-15 12:00:00	NVDA	Stock	0.3176	0.3183	0.3168	0.3178	30309120.0
2012-10-15 13:00:00	NVDA	Stock	0.3178	0.3183	0.3178	0.318	9844160.0
2012-10-15 14:00:00	NVDA	Stock	0.3183	0.3188	0.3171	0.3177	15177560.0
2012-10-15 15:00:00	NVDA	Stock	0.3175	0.32	0.3175	0.3196	69299960.0
2012-10-15 16:00:00	NVDA	Stock	0.3195	0.3198	0.3153	0.3195	2003040.0
2012-10-15 17:00:00	NVDA	Stock	0.319	0.319	0.3185	0.3185	16000.0
2012-10-15 06:00:00	AMZN	Stock	12.236	12.236	12.236	12.236	6000.0
2012-10-15 07:00:00	AMZN	Stock	12.2225	12.2225	12.2225	12.2225	3920.0
2012-10-15 08:00:00	AMZN	Stock	12.2195	12.2195	12.17	12.17	82720.0
2012-10-15 09:00:00	AMZN	Stock	12.175	12.1875	12.011	12.045	7360500.0
2012-10-15 10:00:00	AMZN	Stock	12.045	12.0515	11.9255	11.979	10855980.0
2012-10-15 11:00:00	AMZN	Stock	11.9775	12.127	11.955	12.0811	8117660.0
2012-10-15 12:00:00	AMZN	Stock	12.081	12.095	12.043	12.0565	6000580.0
2012-10-15 13:00:00	AMZN	Stock	12.056	12.098	12.0505	12.0925	2906440.0
2012-10-15 14:00:00	AMZN	Stock	12.092	12.1613	12.0895	12.133	6291820.0
2012-10-15 15:00:00	AMZN	Stock	12.131	12.2388	12.126	12.2095	14691720.0

> showing 50 of 43,837 rows — these rows as CSV

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