PREVIEW / stock_1hour / 2011-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-21.parquet
  size:    937 KB
  rows:    44,366
  symbols: 3,544

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
2011-07-21 04:00:00	AAPL	Stock	13.8071	13.8071	13.7746	13.7754	36400.0
2011-07-21 05:00:00	AAPL	Stock	13.7736	13.7736	13.6911	13.7143	87220.0
2011-07-21 06:00:00	AAPL	Stock	13.6993	13.7321	13.6982	13.7321	69720.0
2011-07-21 07:00:00	AAPL	Stock	13.7696	13.8236	13.7561	13.8236	531776.0
2011-07-21 08:00:00	AAPL	Stock	13.8214	13.8986	13.8179	13.8818	4629716.0
2011-07-21 09:00:00	AAPL	Stock	13.8804	13.8804	13.7107	13.7636	106840692.0
2011-07-21 10:00:00	AAPL	Stock	13.7636	13.9307	13.7507	13.9071	119867496.0
2011-07-21 11:00:00	AAPL	Stock	13.9064	13.9125	13.7975	13.8482	65301012.0
2011-07-21 12:00:00	AAPL	Stock	13.8468	13.8929	13.8046	13.8554	57826860.0
2011-07-21 13:00:00	AAPL	Stock	13.8564	13.8736	13.8218	13.8675	38086748.0
2011-07-21 14:00:00	AAPL	Stock	13.8679	13.87	13.8296	13.8507	33289284.0
2011-07-21 15:00:00	AAPL	Stock	13.8496	13.8804	13.8261	13.8314	66219664.0
2011-07-21 16:00:00	AAPL	Stock	13.8332	13.879	13.8145	13.8475	11185944.0
2011-07-21 17:00:00	AAPL	Stock	13.8396	13.8732	13.8396	13.8436	387072.0
2011-07-21 18:00:00	AAPL	Stock	13.8443	13.8532	13.8318	13.85	95480.0
2011-07-21 19:00:00	AAPL	Stock	13.8546	13.8786	13.8511	13.8786	434224.0
2011-07-21 07:00:00	MSFT	Stock	27.04	27.04	26.95	27.0	740.0
2011-07-21 08:00:00	MSFT	Stock	27.0	27.13	26.95	27.12	589491.0
2011-07-21 09:00:00	MSFT	Stock	27.12	27.125	26.65	26.95	10681655.0
2011-07-21 10:00:00	MSFT	Stock	26.95	27.31	26.9	27.24	10401017.0
2011-07-21 11:00:00	MSFT	Stock	27.238	27.24	26.935	27.03	8866829.0
2011-07-21 12:00:00	MSFT	Stock	27.02	27.25	27.01	27.165	6894575.0
2011-07-21 13:00:00	MSFT	Stock	27.16	27.19	27.02	27.09	6260214.0
2011-07-21 14:00:00	MSFT	Stock	27.09	27.21	27.04	27.17	8122058.0
2011-07-21 15:00:00	MSFT	Stock	27.17	27.22	27.06	27.1	17628500.0
2011-07-21 16:00:00	MSFT	Stock	27.1	27.85	26.4	26.89	10459273.0
2011-07-21 17:00:00	MSFT	Stock	26.88	27.23	26.85	27.05	555821.0
2011-07-21 18:00:00	MSFT	Stock	27.05	27.09	26.9	26.91	180101.0
2011-07-21 19:00:00	MSFT	Stock	26.9	27.0	26.9	27.0	75305.0
2011-07-21 08:00:00	NVDA	Stock	0.3522	0.3522	0.3488	0.3515	744000.0
2011-07-21 09:00:00	NVDA	Stock	0.3515	0.3538	0.3462	0.35	147278440.0
2011-07-21 10:00:00	NVDA	Stock	0.35	0.3568	0.3493	0.3518	156957760.0
2011-07-21 11:00:00	NVDA	Stock	0.3518	0.3572	0.3515	0.3572	105312280.0
2011-07-21 12:00:00	NVDA	Stock	0.357	0.3618	0.3565	0.3602	128896960.0
2011-07-21 13:00:00	NVDA	Stock	0.3602	0.369	0.3595	0.367	205303520.0
2011-07-21 14:00:00	NVDA	Stock	0.3668	0.37	0.3658	0.3682	141741240.0
2011-07-21 15:00:00	NVDA	Stock	0.3681	0.3685	0.3668	0.3675	221757520.0
2011-07-21 16:00:00	NVDA	Stock	0.3672	0.3725	0.3605	0.37	11950160.0
2011-07-21 17:00:00	NVDA	Stock	0.3705	0.3705	0.3676	0.3705	603120.0
2011-07-21 18:00:00	NVDA	Stock	0.3698	0.3718	0.3698	0.3718	242840.0
2011-07-21 19:00:00	NVDA	Stock	0.3713	0.3723	0.3713	0.3723	152000.0
2011-07-21 05:00:00	AMZN	Stock	10.7125	10.7125	10.663	10.663	16000.0
2011-07-21 06:00:00	AMZN	Stock	10.748	10.748	10.748	10.748	2000.0
2011-07-21 08:00:00	AMZN	Stock	10.804	10.8645	10.801	10.835	139300.0
2011-07-21 09:00:00	AMZN	Stock	10.82	10.8715	10.6585	10.7056	11450720.0
2011-07-21 10:00:00	AMZN	Stock	10.712	10.8425	10.691	10.756	15889960.0
2011-07-21 11:00:00	AMZN	Stock	10.7525	10.7785	10.5535	10.577	16564860.0
2011-07-21 12:00:00	AMZN	Stock	10.577	10.6635	10.565	10.6365	13426460.0
2011-07-21 13:00:00	AMZN	Stock	10.6396	10.6525	10.591	10.646	6489240.0
2011-07-21 14:00:00	AMZN	Stock	10.643	10.663	10.5915	10.6585	9191480.0

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

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