PREVIEW / stock_1hour / 2012-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-22.parquet
  size:    947 KB
  rows:    45,027
  symbols: 3,532

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-02-22 04:00:00	AAPL	Stock	18.4239	18.4239	18.3782	18.3982	42000.0
2012-02-22 05:00:00	AAPL	Stock	18.3964	18.3982	18.3964	18.3982	11620.0
2012-02-22 06:00:00	AAPL	Stock	18.3875	18.3875	18.3493	18.3493	84196.0
2012-02-22 07:00:00	AAPL	Stock	18.3571	18.385	18.345	18.3639	835044.0
2012-02-22 08:00:00	AAPL	Stock	18.3607	18.3786	18.2689	18.3232	5157656.0
2012-02-22 09:00:00	AAPL	Stock	18.3239	18.3536	18.1811	18.2789	79637544.0
2012-02-22 10:00:00	AAPL	Stock	18.2814	18.3621	18.2229	18.3618	89042996.0
2012-02-22 11:00:00	AAPL	Stock	18.3618	18.4104	18.2589	18.3054	84794836.0
2012-02-22 12:00:00	AAPL	Stock	18.3032	18.345	18.2786	18.3268	33659864.0
2012-02-22 13:00:00	AAPL	Stock	18.3271	18.3907	18.3061	18.3829	41814696.0
2012-02-22 14:00:00	AAPL	Stock	18.3814	18.3907	18.2586	18.2886	51095744.0
2012-02-22 15:00:00	AAPL	Stock	18.2846	18.3714	18.2825	18.3229	70942088.0
2012-02-22 16:00:00	AAPL	Stock	18.3229	18.3783	18.3145	18.3471	15459528.0
2012-02-22 17:00:00	AAPL	Stock	18.3479	18.3496	18.3357	18.3429	444640.0
2012-02-22 18:00:00	AAPL	Stock	18.34	18.3525	18.3357	18.3464	435260.0
2012-02-22 19:00:00	AAPL	Stock	18.3439	18.3439	18.3357	18.3425	397404.0
2012-02-22 07:00:00	MSFT	Stock	31.37	31.37	31.37	31.37	100.0
2012-02-22 08:00:00	MSFT	Stock	31.37	31.48	31.35	31.48	17800.0
2012-02-22 09:00:00	MSFT	Stock	31.48	31.6	31.43	31.58	4664856.0
2012-02-22 10:00:00	MSFT	Stock	31.58	31.68	31.34	31.421	12066767.0
2012-02-22 11:00:00	MSFT	Stock	31.425	31.49	31.37	31.455	6628302.0
2012-02-22 12:00:00	MSFT	Stock	31.46	31.46	31.32	31.36	4116939.0
2012-02-22 13:00:00	MSFT	Stock	31.36	31.45	31.33	31.38	3957624.0
2012-02-22 14:00:00	MSFT	Stock	31.38	31.43	31.35	31.35	4032125.0
2012-02-22 15:00:00	MSFT	Stock	31.35	31.36	31.18	31.27	10029234.0
2012-02-22 16:00:00	MSFT	Stock	31.27	31.7	31.17	31.25	2219806.0
2012-02-22 17:00:00	MSFT	Stock	31.24	31.52	31.18	31.18	6619.0
2012-02-22 18:00:00	MSFT	Stock	31.2	31.2	31.19	31.2	5372.0
2012-02-22 19:00:00	MSFT	Stock	31.2	31.2	31.18	31.19	12859.0
2012-02-22 08:00:00	NVDA	Stock	0.3962	0.3962	0.3962	0.3962	4000.0
2012-02-22 09:00:00	NVDA	Stock	0.3975	0.4028	0.395	0.4027	69277000.0
2012-02-22 10:00:00	NVDA	Stock	0.4025	0.406	0.402	0.4036	113143680.0
2012-02-22 11:00:00	NVDA	Stock	0.4038	0.4048	0.397	0.3985	67679520.0
2012-02-22 12:00:00	NVDA	Stock	0.3985	0.3988	0.396	0.3962	40097280.0
2012-02-22 13:00:00	NVDA	Stock	0.3962	0.3991	0.3955	0.399	46192120.0
2012-02-22 14:00:00	NVDA	Stock	0.399	0.399	0.3955	0.3955	51518320.0
2012-02-22 15:00:00	NVDA	Stock	0.3955	0.3968	0.395	0.3958	89153440.0
2012-02-22 16:00:00	NVDA	Stock	0.3955	0.3983	0.395	0.395	14331160.0
2012-02-22 17:00:00	NVDA	Stock	0.3958	0.3958	0.3958	0.3958	12000.0
2012-02-22 18:00:00	NVDA	Stock	0.3955	0.3955	0.395	0.395	24000.0
2012-02-22 19:00:00	NVDA	Stock	0.3958	0.396	0.3953	0.396	55120.0
2012-02-22 06:00:00	AMZN	Stock	9.075	9.075	9.075	9.075	6000.0
2012-02-22 07:00:00	AMZN	Stock	9.075	9.075	9.075	9.075	4000.0
2012-02-22 08:00:00	AMZN	Stock	9.05	9.069	9.05	9.069	86420.0
2012-02-22 09:00:00	AMZN	Stock	9.075	9.1495	9.045	9.0575	15068400.0
2012-02-22 10:00:00	AMZN	Stock	9.053	9.124	9.025	9.0525	23471020.0
2012-02-22 11:00:00	AMZN	Stock	9.0505	9.0855	9.024	9.033	19143040.0
2012-02-22 12:00:00	AMZN	Stock	9.0321	9.066	9.0145	9.027	14284700.0
2012-02-22 13:00:00	AMZN	Stock	9.0275	9.07	9.021	9.057	11498580.0
2012-02-22 14:00:00	AMZN	Stock	9.057	9.089	9.04	9.047	12993560.0

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

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