PREVIEW / stock_1hour / 2012-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-26.parquet
  size:    930 KB
  rows:    44,406
  symbols: 3,490

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-07-26 04:00:00	AAPL	Stock	20.6071	20.6071	20.5536	20.5714	87780.0
2012-07-26 05:00:00	AAPL	Stock	20.5536	20.5646	20.5432	20.5432	47600.0
2012-07-26 06:00:00	AAPL	Stock	20.5411	20.6571	20.5411	20.625	222068.0
2012-07-26 07:00:00	AAPL	Stock	20.625	20.7411	20.625	20.7071	1806084.0
2012-07-26 08:00:00	AAPL	Stock	20.7079	20.7321	20.5346	20.5789	5564692.0
2012-07-26 09:00:00	AAPL	Stock	20.5771	20.7307	20.5182	20.5396	75508888.0
2012-07-26 10:00:00	AAPL	Stock	20.5382	20.6375	20.4843	20.5246	87640392.0
2012-07-26 11:00:00	AAPL	Stock	20.5246	20.5475	20.3929	20.4107	51394252.0
2012-07-26 12:00:00	AAPL	Stock	20.4086	20.5071	20.37	20.5007	41283340.0
2012-07-26 13:00:00	AAPL	Stock	20.4996	20.5682	20.4864	20.4904	32179812.0
2012-07-26 14:00:00	AAPL	Stock	20.4929	20.5654	20.4671	20.5418	35969584.0
2012-07-26 15:00:00	AAPL	Stock	20.5422	20.5682	20.5054	20.5236	50975176.0
2012-07-26 16:00:00	AAPL	Stock	20.517	20.5821	20.4821	20.4964	8274476.0
2012-07-26 17:00:00	AAPL	Stock	20.4861	20.5314	20.4746	20.4911	460236.0
2012-07-26 18:00:00	AAPL	Stock	20.4914	20.5132	20.4886	20.5107	87836.0
2012-07-26 19:00:00	AAPL	Stock	20.5061	20.5179	20.5	20.5175	164360.0
2012-07-26 06:00:00	MSFT	Stock	28.88	28.88	28.88	28.88	200.0
2012-07-26 07:00:00	MSFT	Stock	28.96	29.39	28.96	29.05	10040.0
2012-07-26 08:00:00	MSFT	Stock	29.1	29.23	28.83	29.14	95188.0
2012-07-26 09:00:00	MSFT	Stock	29.12	29.5	29.1	29.17	5679077.0
2012-07-26 10:00:00	MSFT	Stock	29.17	29.375	29.1	29.19	7631654.0
2012-07-26 11:00:00	MSFT	Stock	29.2	29.23	29.09	29.16	5146502.0
2012-07-26 12:00:00	MSFT	Stock	29.16	29.23	29.115	29.22	3233240.0
2012-07-26 13:00:00	MSFT	Stock	29.21	29.28	29.11	29.13	4453224.0
2012-07-26 14:00:00	MSFT	Stock	29.136	29.22	29.12	29.185	3882645.0
2012-07-26 15:00:00	MSFT	Stock	29.185	29.32	29.13	29.16	11536726.0
2012-07-26 16:00:00	MSFT	Stock	29.175	29.24	29.14	29.21	1892840.0
2012-07-26 17:00:00	MSFT	Stock	29.19	29.22	29.15	29.22	81206.0
2012-07-26 18:00:00	MSFT	Stock	29.16	29.16	29.16	29.16	700.0
2012-07-26 19:00:00	MSFT	Stock	29.18	29.2	29.18	29.18	1500.0
2012-07-26 07:00:00	NVDA	Stock	0.334	0.334	0.334	0.334	12000.0
2012-07-26 08:00:00	NVDA	Stock	0.3342	0.3342	0.3298	0.3338	66000.0
2012-07-26 09:00:00	NVDA	Stock	0.3338	0.337	0.3309	0.332	36495440.0
2012-07-26 10:00:00	NVDA	Stock	0.3322	0.335	0.3295	0.331	62265840.0
2012-07-26 11:00:00	NVDA	Stock	0.3313	0.3322	0.3263	0.328	56427960.0
2012-07-26 12:00:00	NVDA	Stock	0.3279	0.328	0.3263	0.3275	26678160.0
2012-07-26 13:00:00	NVDA	Stock	0.3274	0.3295	0.3265	0.3268	29942880.0
2012-07-26 14:00:00	NVDA	Stock	0.327	0.329	0.3268	0.3273	45374520.0
2012-07-26 15:00:00	NVDA	Stock	0.3275	0.331	0.3273	0.3288	69971440.0
2012-07-26 16:00:00	NVDA	Stock	0.3288	0.3298	0.3288	0.3289	3159440.0
2012-07-26 17:00:00	NVDA	Stock	0.3288	0.3298	0.3288	0.3298	180400.0
2012-07-26 19:00:00	NVDA	Stock	0.328	0.328	0.328	0.328	17400.0
2012-07-26 04:00:00	AMZN	Stock	10.9	10.9	10.8995	10.8995	10000.0
2012-07-26 07:00:00	AMZN	Stock	10.935	10.9955	10.935	10.995	91200.0
2012-07-26 08:00:00	AMZN	Stock	10.963	10.9775	10.931	10.9715	141760.0
2012-07-26 09:00:00	AMZN	Stock	10.9635	11.0445	10.903	11.0135	10894640.0
2012-07-26 10:00:00	AMZN	Stock	11.019	11.0475	10.8265	10.849	14310460.0
2012-07-26 11:00:00	AMZN	Stock	10.8495	10.8695	10.7475	10.8135	9673100.0
2012-07-26 12:00:00	AMZN	Stock	10.815	10.9315	10.8075	10.928	9438480.0
2012-07-26 13:00:00	AMZN	Stock	10.9275	10.958	10.8955	10.9095	6986400.0

> showing 50 of 44,406 rows — these rows as CSV

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