PREVIEW / stock_1hour / 2012-12-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-24.parquet
  size:    631 KB
  rows:    27,545
  symbols: 3,456

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-24 04:00:00	AAPL	Stock	18.5393	18.5818	18.5393	18.5818	58800.0
2012-12-24 05:00:00	AAPL	Stock	18.6064	18.6064	18.6064	18.6064	81060.0
2012-12-24 06:00:00	AAPL	Stock	18.625	18.625	18.625	18.625	2800.0
2012-12-24 07:00:00	AAPL	Stock	18.625	18.6554	18.5714	18.6071	346444.0
2012-12-24 08:00:00	AAPL	Stock	18.6225	18.7714	18.5475	18.6996	2503704.0
2012-12-24 09:00:00	AAPL	Stock	18.6964	18.7232	18.5539	18.6746	49066108.0
2012-12-24 10:00:00	AAPL	Stock	18.6782	18.6946	18.5818	18.591	40660088.0
2012-12-24 11:00:00	AAPL	Stock	18.5961	18.6114	18.5254	18.5815	37263604.0
2012-12-24 12:00:00	AAPL	Stock	18.5855	18.6261	18.5425	18.5782	39134004.0
2012-12-24 13:00:00	AAPL	Stock	18.57	18.6149	18.5546	18.5585	4379340.0
2012-12-24 14:00:00	AAPL	Stock	18.5707	18.5875	18.5625	18.5714	136304.0
2012-12-24 15:00:00	AAPL	Stock	18.5714	18.575	18.5629	18.5714	107548.0
2012-12-24 16:00:00	AAPL	Stock	18.5732	18.5732	18.55	18.55	47348.0
2012-12-24 06:00:00	MSFT	Stock	27.35	27.35	27.2	27.2	600.0
2012-12-24 07:00:00	MSFT	Stock	27.16	27.26	27.16	27.25	8925.0
2012-12-24 08:00:00	MSFT	Stock	27.27	27.3	27.17	27.19	35428.0
2012-12-24 09:00:00	MSFT	Stock	27.19	27.25	27.07	27.07	4401822.0
2012-12-24 10:00:00	MSFT	Stock	27.07	27.14	27.01	27.06	5533023.0
2012-12-24 11:00:00	MSFT	Stock	27.06	27.1	27.02	27.03	3347213.0
2012-12-24 12:00:00	MSFT	Stock	27.03	27.07	27.0	27.07	4657513.0
2012-12-24 13:00:00	MSFT	Stock	27.06	27.09	27.02	27.03	1724477.0
2012-12-24 14:00:00	MSFT	Stock	27.03	27.08	27.02	27.04	4675.0
2012-12-24 15:00:00	MSFT	Stock	27.02	27.02	27.0	27.0	1344.0
2012-12-24 16:00:00	MSFT	Stock	27.05	27.05	27.0	27.05	5007.0
2012-12-24 07:00:00	NVDA	Stock	0.3088	0.3088	0.3088	0.3088	4000.0
2012-12-24 09:00:00	NVDA	Stock	0.3085	0.3093	0.306	0.3074	23238320.0
2012-12-24 10:00:00	NVDA	Stock	0.3073	0.3095	0.3061	0.3066	29256720.0
2012-12-24 11:00:00	NVDA	Stock	0.3068	0.3073	0.3062	0.3062	24692200.0
2012-12-24 12:00:00	NVDA	Stock	0.3065	0.3073	0.3052	0.3062	40765920.0
2012-12-24 13:00:00	NVDA	Stock	0.3062	0.3062	0.3052	0.3058	8868080.0
2012-12-24 14:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	152160.0
2012-12-24 08:00:00	AMZN	Stock	12.84	12.9	12.84	12.8875	113580.0
2012-12-24 09:00:00	AMZN	Stock	12.895	12.975	12.853	12.8665	5582180.0
2012-12-24 10:00:00	AMZN	Stock	12.8665	12.9555	12.848	12.915	4942460.0
2012-12-24 11:00:00	AMZN	Stock	12.9155	12.9625	12.895	12.957	3667700.0
2012-12-24 12:00:00	AMZN	Stock	12.9555	12.956	12.9	12.9305	4436100.0
2012-12-24 13:00:00	AMZN	Stock	12.9305	12.931	12.922	12.93	899300.0
2012-12-24 14:00:00	AMZN	Stock	12.9365	12.9365	12.925	12.931	28700.0
2012-12-24 15:00:00	AMZN	Stock	12.9155	12.93	12.9155	12.93	10000.0
2012-12-24 16:00:00	AMZN	Stock	12.9345	12.9345	12.9345	12.9345	3940.0
2012-12-24 06:00:00	META	Stock	26.4	26.4	26.4	26.4	400.0
2012-12-24 07:00:00	META	Stock	26.4	26.45	26.34	26.4	11250.0
2012-12-24 08:00:00	META	Stock	26.38	26.74	26.34	26.66	314351.0
2012-12-24 09:00:00	META	Stock	26.67	26.72	26.2	26.45	6587470.0
2012-12-24 10:00:00	META	Stock	26.45	26.74	26.41	26.66	7402348.0
2012-12-24 11:00:00	META	Stock	26.65	26.93	26.58	26.76	7459866.0
2012-12-24 12:00:00	META	Stock	26.75	26.96	26.65	26.93	6094467.0
2012-12-24 13:00:00	META	Stock	26.92	26.94	26.869	26.93	176682.0
2012-12-24 14:00:00	META	Stock	26.93	26.94	26.92	26.93	17201.0
2012-12-24 15:00:00	META	Stock	26.92	26.93	26.91	26.93	17165.0

> showing 50 of 27,545 rows — these rows as CSV

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