PREVIEW / stock_1hour / 2012-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-10.parquet
  size:    967 KB
  rows:    45,803
  symbols: 3,511

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-04-10 04:00:00	AAPL	Stock	22.7779	22.8368	22.7779	22.7857	342412.0
2012-04-10 05:00:00	AAPL	Stock	22.7768	22.8214	22.7679	22.8214	145040.0
2012-04-10 06:00:00	AAPL	Stock	22.8125	22.8571	22.8093	22.8518	163548.0
2012-04-10 07:00:00	AAPL	Stock	22.85	22.8743	22.775	22.8214	1067164.0
2012-04-10 08:00:00	AAPL	Stock	22.8286	22.8893	22.7225	22.8636	5745460.0
2012-04-10 09:00:00	AAPL	Stock	22.8625	22.9786	22.8393	22.9625	112293440.0
2012-04-10 10:00:00	AAPL	Stock	22.9639	23.0	22.8575	22.9179	115424148.0
2012-04-10 11:00:00	AAPL	Stock	22.9129	22.9243	22.6386	22.7471	144703944.0
2012-04-10 12:00:00	AAPL	Stock	22.7496	22.75	22.3929	22.6214	177923228.0
2012-04-10 13:00:00	AAPL	Stock	22.6229	22.6589	22.4861	22.5804	68217184.0
2012-04-10 14:00:00	AAPL	Stock	22.5782	22.6	22.3571	22.5157	110061336.0
2012-04-10 15:00:00	AAPL	Stock	22.5207	22.5868	22.3837	22.4554	126179340.0
2012-04-10 16:00:00	AAPL	Stock	22.4443	22.8866	22.37	22.5536	16877672.0
2012-04-10 17:00:00	AAPL	Stock	22.5514	22.5625	22.5375	22.5625	666512.0
2012-04-10 18:00:00	AAPL	Stock	22.5621	22.5679	22.55	22.55	459704.0
2012-04-10 19:00:00	AAPL	Stock	22.55	22.6068	22.5486	22.5714	1067920.0
2012-04-10 07:00:00	MSFT	Stock	31.26	31.26	31.14	31.14	3800.0
2012-04-10 08:00:00	MSFT	Stock	31.14	31.27	31.1	31.21	15096.0
2012-04-10 09:00:00	MSFT	Stock	31.2	31.2	30.9	31.09	5424369.0
2012-04-10 10:00:00	MSFT	Stock	31.099	31.12	30.86	30.89	5208495.0
2012-04-10 11:00:00	MSFT	Stock	30.894	30.91	30.59	30.641	7993290.0
2012-04-10 12:00:00	MSFT	Stock	30.64	30.69	30.39	30.51	8810717.0
2012-04-10 13:00:00	MSFT	Stock	30.51	30.51	30.35	30.41	5356245.0
2012-04-10 14:00:00	MSFT	Stock	30.41	30.45	30.31	30.39	5594536.0
2012-04-10 15:00:00	MSFT	Stock	30.39	30.48	30.3	30.47	11916962.0
2012-04-10 16:00:00	MSFT	Stock	30.47	30.675	30.31	30.55	2394335.0
2012-04-10 17:00:00	MSFT	Stock	30.57	30.6	30.51	30.6	7387.0
2012-04-10 18:00:00	MSFT	Stock	30.6	30.66	30.43	30.66	9542.0
2012-04-10 19:00:00	MSFT	Stock	30.6	30.65	30.6	30.65	370.0
2012-04-10 08:00:00	NVDA	Stock	0.361	0.361	0.361	0.361	104000.0
2012-04-10 09:00:00	NVDA	Stock	0.3612	0.3645	0.3575	0.3612	63275240.0
2012-04-10 10:00:00	NVDA	Stock	0.3612	0.363	0.36	0.3608	45123440.0
2012-04-10 11:00:00	NVDA	Stock	0.3608	0.3615	0.3565	0.357	45481840.0
2012-04-10 12:00:00	NVDA	Stock	0.3568	0.3572	0.3545	0.3558	49884560.0
2012-04-10 13:00:00	NVDA	Stock	0.3558	0.3561	0.3522	0.3555	71730120.0
2012-04-10 14:00:00	NVDA	Stock	0.3555	0.356	0.3533	0.3553	66249680.0
2012-04-10 15:00:00	NVDA	Stock	0.3553	0.3559	0.3538	0.354	102927520.0
2012-04-10 16:00:00	NVDA	Stock	0.354	0.361	0.3533	0.354	13112600.0
2012-04-10 17:00:00	NVDA	Stock	0.3555	0.3555	0.3555	0.3555	26000.0
2012-04-10 19:00:00	NVDA	Stock	0.3555	0.3558	0.3555	0.3558	106000.0
2012-04-10 07:00:00	AMZN	Stock	9.634	9.634	9.563	9.6	31400.0
2012-04-10 08:00:00	AMZN	Stock	9.5885	9.6365	9.57	9.62	233460.0
2012-04-10 09:00:00	AMZN	Stock	9.6355	9.676	9.6115	9.6265	9243200.0
2012-04-10 10:00:00	AMZN	Stock	9.626	9.6445	9.55	9.566	11350720.0
2012-04-10 11:00:00	AMZN	Stock	9.569	9.589	9.4645	9.4855	11760580.0
2012-04-10 12:00:00	AMZN	Stock	9.481	9.4915	9.388	9.4125	12353640.0
2012-04-10 13:00:00	AMZN	Stock	9.413	9.4295	9.344	9.419	9866500.0
2012-04-10 14:00:00	AMZN	Stock	9.416	9.424	9.335	9.3665	10713620.0
2012-04-10 15:00:00	AMZN	Stock	9.3675	9.3875	9.3285	9.3515	19008540.0
2012-04-10 16:00:00	AMZN	Stock	9.349	9.6356	9.3396	9.385	4109560.0

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

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