PREVIEW / stock_30min / 2011-08-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-15.parquet
  size:    1.4 MB
  rows:    76,837
  symbols: 3,547

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-08-15 04:00:00	AAPL	Stock	13.5714	13.63	13.5393	13.63	61600.0
2011-08-15 04:30:00	AAPL	Stock	13.6111	13.6125	13.6111	13.6125	5600.0
2011-08-15 05:30:00	AAPL	Stock	13.6321	13.6321	13.6071	13.6075	23800.0
2011-08-15 06:00:00	AAPL	Stock	13.575	13.575	13.5429	13.5539	60200.0
2011-08-15 06:30:00	AAPL	Stock	13.5539	13.5539	13.5375	13.5511	55860.0
2011-08-15 07:00:00	AAPL	Stock	13.5511	13.5721	13.5418	13.5721	286720.0
2011-08-15 07:30:00	AAPL	Stock	13.5693	13.5725	13.3929	13.4639	1386112.0
2011-08-15 08:00:00	AAPL	Stock	13.4639	13.4804	13.4393	13.4643	1690416.0
2011-08-15 08:30:00	AAPL	Stock	13.4607	13.4607	13.4161	13.4393	1061396.0
2011-08-15 09:00:00	AAPL	Stock	13.4429	13.5714	13.4393	13.5582	2369416.0
2011-08-15 09:30:00	AAPL	Stock	13.5586	13.7371	13.5032	13.6775	98859880.0
2011-08-15 10:00:00	AAPL	Stock	13.6775	13.7479	13.6625	13.7454	45040184.0
2011-08-15 10:30:00	AAPL	Stock	13.7443	13.7489	13.6875	13.6957	38018008.0
2011-08-15 11:00:00	AAPL	Stock	13.6929	13.705	13.6071	13.6143	39957400.0
2011-08-15 11:30:00	AAPL	Stock	13.6146	13.6761	13.595	13.6575	29938104.0
2011-08-15 12:00:00	AAPL	Stock	13.6568	13.6714	13.6025	13.6332	26338676.0
2011-08-15 12:30:00	AAPL	Stock	13.6321	13.6904	13.6193	13.685	19562956.0
2011-08-15 13:00:00	AAPL	Stock	13.6854	13.6979	13.6607	13.6786	20272476.0
2011-08-15 13:30:00	AAPL	Stock	13.6779	13.7011	13.6614	13.6879	15412068.0
2011-08-15 14:00:00	AAPL	Stock	13.6857	13.6994	13.6679	13.6907	18176704.0
2011-08-15 14:30:00	AAPL	Stock	13.6907	13.7	13.6679	13.6995	20042316.0
2011-08-15 15:00:00	AAPL	Stock	13.6997	13.7082	13.6607	13.6692	23602684.0
2011-08-15 15:30:00	AAPL	Stock	13.6696	13.7064	13.6639	13.6893	45789324.0
2011-08-15 16:00:00	AAPL	Stock	13.6888	13.696	13.6685	13.6932	7948304.0
2011-08-15 16:30:00	AAPL	Stock	13.6932	13.6932	13.6758	13.6882	1111572.0
2011-08-15 17:00:00	AAPL	Stock	13.6893	13.6904	13.6821	13.6904	86380.0
2011-08-15 17:30:00	AAPL	Stock	13.6893	13.7107	13.6893	13.7018	258720.0
2011-08-15 18:00:00	AAPL	Stock	13.6982	13.6982	13.6807	13.6839	224560.0
2011-08-15 18:30:00	AAPL	Stock	13.6864	13.7089	13.6839	13.7089	79240.0
2011-08-15 19:00:00	AAPL	Stock	13.6857	13.6871	13.6804	13.685	60620.0
2011-08-15 19:30:00	AAPL	Stock	13.6857	13.6929	13.6846	13.685	175420.0
2011-08-15 05:30:00	MSFT	Stock	25.21	25.21	25.2	25.2	700.0
2011-08-15 06:30:00	MSFT	Stock	25.2	25.2	25.1	25.1	600.0
2011-08-15 07:00:00	MSFT	Stock	25.2	25.27	25.2	25.27	1150.0
2011-08-15 07:30:00	MSFT	Stock	25.23	25.23	24.99	25.03	84478.0
2011-08-15 08:00:00	MSFT	Stock	25.05	25.16	25.04	25.16	45547.0
2011-08-15 08:30:00	MSFT	Stock	25.17	25.25	25.16	25.2	35665.0
2011-08-15 09:00:00	MSFT	Stock	25.23	25.4	25.14	25.21	91283.0
2011-08-15 09:30:00	MSFT	Stock	25.24	25.58	25.17	25.42	6308430.0
2011-08-15 10:00:00	MSFT	Stock	25.43	25.51	25.38	25.5	4152237.0
2011-08-15 10:30:00	MSFT	Stock	25.502	25.53	25.35	25.36	4592668.0
2011-08-15 11:00:00	MSFT	Stock	25.355	25.405	25.17	25.208	5229864.0
2011-08-15 11:30:00	MSFT	Stock	25.2	25.33	25.15	25.263	4373165.0
2011-08-15 12:00:00	MSFT	Stock	25.265	25.35	25.25	25.34	2508027.0
2011-08-15 12:30:00	MSFT	Stock	25.34	25.38	25.3	25.35	1946133.0
2011-08-15 13:00:00	MSFT	Stock	25.343	25.39	25.26	25.322	2172209.0
2011-08-15 13:30:00	MSFT	Stock	25.322	25.35	25.265	25.32	1521692.0
2011-08-15 14:00:00	MSFT	Stock	25.31	25.45	25.31	25.42	3072337.0
2011-08-15 14:30:00	MSFT	Stock	25.425	25.48	25.36	25.42	3109219.0
2011-08-15 15:00:00	MSFT	Stock	25.43	25.47	25.35	25.393	5325204.0

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

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