PREVIEW / stock_30min / 2012-09-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-25.parquet
  size:    1.4 MB
  rows:    76,565
  symbols: 3,501

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-09-25 04:00:00	AAPL	Stock	24.5625	24.5893	24.5539	24.5718	440272.0
2012-09-25 04:30:00	AAPL	Stock	24.5464	24.5679	24.5464	24.5679	44800.0
2012-09-25 05:30:00	AAPL	Stock	24.515	24.5161	24.515	24.5161	16800.0
2012-09-25 06:00:00	AAPL	Stock	24.5357	24.5679	24.5357	24.5679	49000.0
2012-09-25 06:30:00	AAPL	Stock	24.5675	24.5714	24.5675	24.5714	36400.0
2012-09-25 07:00:00	AAPL	Stock	24.5714	24.5893	24.5143	24.5657	345716.0
2012-09-25 07:30:00	AAPL	Stock	24.5804	24.5854	24.5179	24.5321	215600.0
2012-09-25 08:00:00	AAPL	Stock	24.5357	24.5836	24.5093	24.5814	1476048.0
2012-09-25 08:30:00	AAPL	Stock	24.5836	24.6568	24.5836	24.6425	1509060.0
2012-09-25 09:00:00	AAPL	Stock	24.6418	24.6429	24.5646	24.5718	1162336.0
2012-09-25 09:30:00	AAPL	Stock	24.5807	24.7421	24.5	24.6129	71174012.0
2012-09-25 10:00:00	AAPL	Stock	24.6171	24.6696	24.5468	24.5982	41327524.0
2012-09-25 10:30:00	AAPL	Stock	24.5984	24.6429	24.5864	24.6275	19173420.0
2012-09-25 11:00:00	AAPL	Stock	24.6254	24.7096	24.625	24.685	21846468.0
2012-09-25 11:30:00	AAPL	Stock	24.6839	24.7125	24.6311	24.6446	15059660.0
2012-09-25 12:00:00	AAPL	Stock	24.6439	24.6518	24.5918	24.6065	13901132.0
2012-09-25 12:30:00	AAPL	Stock	24.6082	24.6094	24.5225	24.5714	25755744.0
2012-09-25 13:00:00	AAPL	Stock	24.5714	24.5757	24.4829	24.5079	21824264.0
2012-09-25 13:30:00	AAPL	Stock	24.5094	24.5636	24.4964	24.5443	16008216.0
2012-09-25 14:00:00	AAPL	Stock	24.5468	24.5511	24.4514	24.4632	21198296.0
2012-09-25 14:30:00	AAPL	Stock	24.4632	24.4818	24.2507	24.2604	48271888.0
2012-09-25 15:00:00	AAPL	Stock	24.2568	24.2946	24.1339	24.2107	87815308.0
2012-09-25 15:30:00	AAPL	Stock	24.2104	24.2468	24.0357	24.0607	78480696.0
2012-09-25 16:00:00	AAPL	Stock	24.0607	24.6416	24.0219	24.0786	14009436.0
2012-09-25 16:30:00	AAPL	Stock	24.0775	24.6386	24.055	24.095	996940.0
2012-09-25 17:00:00	AAPL	Stock	24.1025	24.5108	24.055	24.1032	4023516.0
2012-09-25 17:30:00	AAPL	Stock	24.1007	24.1071	24.0796	24.0893	378364.0
2012-09-25 18:00:00	AAPL	Stock	24.0896	24.0964	24.0786	24.0893	109704.0
2012-09-25 18:30:00	AAPL	Stock	24.0789	24.1071	24.0696	24.0954	393764.0
2012-09-25 19:00:00	AAPL	Stock	24.0914	24.0979	24.0821	24.0893	206136.0
2012-09-25 19:30:00	AAPL	Stock	24.0911	24.1107	24.0821	24.1107	143892.0
2012-09-25 08:00:00	MSFT	Stock	30.88	30.88	30.82	30.82	3200.0
2012-09-25 08:30:00	MSFT	Stock	30.83	30.9	30.83	30.9	7399.0
2012-09-25 09:00:00	MSFT	Stock	30.92	30.97	30.88	30.95	51603.0
2012-09-25 09:30:00	MSFT	Stock	30.95	31.0	30.69	30.74	3473221.0
2012-09-25 10:00:00	MSFT	Stock	30.735	30.86	30.71	30.735	4092711.0
2012-09-25 10:30:00	MSFT	Stock	30.735	30.78	30.72	30.765	2153131.0
2012-09-25 11:00:00	MSFT	Stock	30.765	30.89	30.76	30.852	1970612.0
2012-09-25 11:30:00	MSFT	Stock	30.855	30.92	30.85	30.895	1727995.0
2012-09-25 12:00:00	MSFT	Stock	30.894	30.9	30.76	30.78	1511820.0
2012-09-25 12:30:00	MSFT	Stock	30.79	30.8	30.69	30.712	3420095.0
2012-09-25 13:00:00	MSFT	Stock	30.71	30.72	30.68	30.695	1106699.0
2012-09-25 13:30:00	MSFT	Stock	30.7	30.74	30.66	30.728	1404335.0
2012-09-25 14:00:00	MSFT	Stock	30.72	30.76	30.67	30.693	1606013.0
2012-09-25 14:30:00	MSFT	Stock	30.695	30.75	30.59	30.607	2679575.0
2012-09-25 15:00:00	MSFT	Stock	30.608	30.69	30.53	30.62	3940323.0
2012-09-25 15:30:00	MSFT	Stock	30.615	30.72	30.36	30.39	13859139.0
2012-09-25 16:00:00	MSFT	Stock	30.395	30.885	30.2	30.24	5242115.0
2012-09-25 16:30:00	MSFT	Stock	30.24	30.62	30.24	30.37	330778.0
2012-09-25 17:00:00	MSFT	Stock	30.33	30.39	30.28	30.37	8014.0

> showing 50 of 76,565 rows — these rows as CSV

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