PREVIEW / stock_30min / 2011-09-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-20.parquet
  size:    1.4 MB
  rows:    75,813
  symbols: 3,518

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-09-20 04:00:00	AAPL	Stock	14.6429	14.8018	14.6429	14.8018	67200.0
2011-09-20 04:30:00	AAPL	Stock	14.7496	14.7496	14.7496	14.7496	2800.0
2011-09-20 05:00:00	AAPL	Stock	14.7796	14.7893	14.7796	14.7893	11200.0
2011-09-20 05:30:00	AAPL	Stock	14.8214	14.8679	14.8125	14.8661	165060.0
2011-09-20 06:00:00	AAPL	Stock	14.8661	14.8929	14.8629	14.875	57400.0
2011-09-20 06:30:00	AAPL	Stock	14.8668	14.8675	14.8589	14.8589	18480.0
2011-09-20 07:00:00	AAPL	Stock	14.8443	14.8879	14.8232	14.8393	593152.0
2011-09-20 07:30:00	AAPL	Stock	14.8375	14.845	14.8146	14.8336	771092.0
2011-09-20 08:00:00	AAPL	Stock	14.8289	14.8571	14.8193	14.8532	2688112.0
2011-09-20 08:30:00	AAPL	Stock	14.8536	14.8543	14.8196	14.8321	2050216.0
2011-09-20 09:00:00	AAPL	Stock	14.8321	14.8393	14.7904	14.8339	3581928.0
2011-09-20 09:30:00	AAPL	Stock	14.8346	14.9357	14.8036	14.8986	122445148.0
2011-09-20 10:00:00	AAPL	Stock	14.8968	14.9929	14.8554	14.9879	71726256.0
2011-09-20 10:30:00	AAPL	Stock	14.9879	15.0714	14.9821	15.0207	80463852.0
2011-09-20 11:00:00	AAPL	Stock	15.0207	15.0536	14.9743	15.0196	47729444.0
2011-09-20 11:30:00	AAPL	Stock	15.0189	15.1021	15.0004	15.0957	43048964.0
2011-09-20 12:00:00	AAPL	Stock	15.0989	15.1021	15.0286	15.0639	30626288.0
2011-09-20 12:30:00	AAPL	Stock	15.0668	15.0996	15.0389	15.0557	26569004.0
2011-09-20 13:00:00	AAPL	Stock	15.0557	15.0646	14.98	15.0204	24963848.0
2011-09-20 13:30:00	AAPL	Stock	15.0196	15.0536	15.0011	15.0211	18823896.0
2011-09-20 14:00:00	AAPL	Stock	15.02	15.0518	14.9893	15.0279	24433080.0
2011-09-20 14:30:00	AAPL	Stock	15.0282	15.0479	14.8804	14.9186	59879456.0
2011-09-20 15:00:00	AAPL	Stock	14.9189	14.9441	14.6968	14.6996	94107412.0
2011-09-20 15:30:00	AAPL	Stock	14.6971	14.8304	14.6854	14.7664	96926032.0
2011-09-20 16:00:00	AAPL	Stock	14.75	14.9249	14.7011	14.7782	8704528.0
2011-09-20 16:30:00	AAPL	Stock	14.7782	15.0188	14.7035	14.8207	692552.0
2011-09-20 17:00:00	AAPL	Stock	14.8211	14.8318	14.7661	14.8282	513492.0
2011-09-20 17:30:00	AAPL	Stock	14.8264	14.8264	14.7661	14.7964	805700.0
2011-09-20 18:00:00	AAPL	Stock	14.7946	14.8018	14.7661	14.7771	338520.0
2011-09-20 18:30:00	AAPL	Stock	14.7857	14.7921	14.7793	14.7857	122108.0
2011-09-20 19:00:00	AAPL	Stock	14.7857	14.7964	14.7857	14.7929	53256.0
2011-09-20 19:30:00	AAPL	Stock	14.7911	14.8214	14.7864	14.8211	260344.0
2011-09-20 05:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	200.0
2011-09-20 06:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	500.0
2011-09-20 07:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	2000.0
2011-09-20 07:30:00	MSFT	Stock	27.3	27.3	27.3	27.3	600.0
2011-09-20 08:00:00	MSFT	Stock	27.27	27.28	27.27	27.28	550.0
2011-09-20 08:30:00	MSFT	Stock	27.26	27.35	27.26	27.35	13150.0
2011-09-20 09:00:00	MSFT	Stock	27.32	27.36	27.26	27.3	32827.0
2011-09-20 09:30:00	MSFT	Stock	27.27	27.345	27.02	27.22	5935398.0
2011-09-20 10:00:00	MSFT	Stock	27.211	27.39	27.16	27.376	4507401.0
2011-09-20 10:30:00	MSFT	Stock	27.38	27.47	27.34	27.47	2745793.0
2011-09-20 11:00:00	MSFT	Stock	27.461	27.5	27.41	27.44	3421855.0
2011-09-20 11:30:00	MSFT	Stock	27.45	27.5	27.38	27.48	2085953.0
2011-09-20 12:00:00	MSFT	Stock	27.48	27.48	27.39	27.425	1638918.0
2011-09-20 12:30:00	MSFT	Stock	27.425	27.43	27.26	27.333	2487401.0
2011-09-20 13:00:00	MSFT	Stock	27.33	27.36	27.24	27.27	2327778.0
2011-09-20 13:30:00	MSFT	Stock	27.27	27.29	27.16	27.22	3100259.0
2011-09-20 14:00:00	MSFT	Stock	27.216	27.32	27.21	27.226	3066864.0
2011-09-20 14:30:00	MSFT	Stock	27.23	27.26	27.12	27.17	2651014.0

> showing 50 of 75,813 rows — these rows as CSV

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