PREVIEW / stock_30min / 2011-04-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-18.parquet
  size:    1.4 MB
  rows:    76,154
  symbols: 3,532

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-04-18 04:00:00	AAPL	Stock	11.7143	11.7143	11.7082	11.7082	5600.0
2011-04-18 04:30:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	5600.0
2011-04-18 06:00:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	5600.0
2011-04-18 06:30:00	AAPL	Stock	11.6625	11.6625	11.6521	11.6521	8400.0
2011-04-18 07:00:00	AAPL	Stock	11.6796	11.7143	11.6796	11.7143	90020.0
2011-04-18 07:30:00	AAPL	Stock	11.7143	11.7421	11.7143	11.7268	209104.0
2011-04-18 08:00:00	AAPL	Stock	11.725	11.7611	11.7179	11.7604	818552.0
2011-04-18 08:30:00	AAPL	Stock	11.7607	11.7675	11.7375	11.7375	701652.0
2011-04-18 09:00:00	AAPL	Stock	11.7379	11.7429	11.6154	11.6468	6735428.0
2011-04-18 09:30:00	AAPL	Stock	11.6482	11.7193	11.4432	11.4929	146321588.0
2011-04-18 10:00:00	AAPL	Stock	11.4907	11.5143	11.4343	11.4764	77393372.0
2011-04-18 10:30:00	AAPL	Stock	11.4773	11.5136	11.4482	11.4636	39724832.0
2011-04-18 11:00:00	AAPL	Stock	11.4629	11.5296	11.4464	11.52	35655088.0
2011-04-18 11:30:00	AAPL	Stock	11.52	11.5839	11.5111	11.5786	32310684.0
2011-04-18 12:00:00	AAPL	Stock	11.5789	11.6064	11.5646	11.5775	27322456.0
2011-04-18 12:30:00	AAPL	Stock	11.5764	11.5868	11.5568	11.5857	14126980.0
2011-04-18 13:00:00	AAPL	Stock	11.5885	11.5886	11.5486	11.5621	12136264.0
2011-04-18 13:30:00	AAPL	Stock	11.5621	11.6464	11.5579	11.6382	27573840.0
2011-04-18 14:00:00	AAPL	Stock	11.6386	11.6617	11.6218	11.6325	22253448.0
2011-04-18 14:30:00	AAPL	Stock	11.6322	11.7607	11.6171	11.7354	44249044.0
2011-04-18 15:00:00	AAPL	Stock	11.7354	11.7711	11.6964	11.7621	38083976.0
2011-04-18 15:30:00	AAPL	Stock	11.7636	11.8654	11.7476	11.8518	68345536.0
2011-04-18 16:00:00	AAPL	Stock	11.8518	11.86	11.4821	11.8393	7697872.0
2011-04-18 16:30:00	AAPL	Stock	11.8411	11.8518	11.6579	11.8318	377104.0
2011-04-18 17:00:00	AAPL	Stock	11.8321	11.8357	11.825	11.8261	162932.0
2011-04-18 17:30:00	AAPL	Stock	11.83	11.8321	11.8268	11.8321	207172.0
2011-04-18 18:00:00	AAPL	Stock	11.8321	11.8518	11.8321	11.8393	233100.0
2011-04-18 18:30:00	AAPL	Stock	11.8429	11.8443	11.8393	11.8393	25452.0
2011-04-18 19:00:00	AAPL	Stock	11.8332	11.8332	11.8221	11.825	148260.0
2011-04-18 19:30:00	AAPL	Stock	11.8239	11.8429	11.8161	11.8339	320880.0
2011-04-18 04:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	200.0
2011-04-18 07:00:00	MSFT	Stock	25.35	25.35	25.26	25.26	600.0
2011-04-18 07:30:00	MSFT	Stock	25.32	25.32	25.26	25.32	1900.0
2011-04-18 08:00:00	MSFT	Stock	25.31	25.32	25.28	25.32	6812.0
2011-04-18 08:30:00	MSFT	Stock	25.3	25.32	25.27	25.3	8700.0
2011-04-18 09:00:00	MSFT	Stock	25.3	25.3	25.05	25.08	51270.0
2011-04-18 09:30:00	MSFT	Stock	25.09	25.16	25.01	25.025	6236672.0
2011-04-18 10:00:00	MSFT	Stock	25.02	25.03	24.72	24.77	12235604.0
2011-04-18 10:30:00	MSFT	Stock	24.775	24.91	24.77	24.84	6468339.0
2011-04-18 11:00:00	MSFT	Stock	24.845	24.94	24.82	24.9	2594408.0
2011-04-18 11:30:00	MSFT	Stock	24.9	24.96	24.87	24.891	1683101.0
2011-04-18 12:00:00	MSFT	Stock	24.895	24.94	24.89	24.93	2077877.0
2011-04-18 12:30:00	MSFT	Stock	24.925	25.03	24.92	25.03	1801940.0
2011-04-18 13:00:00	MSFT	Stock	25.03	25.12	24.97	25.1	3489424.0
2011-04-18 13:30:00	MSFT	Stock	25.1	25.28	25.08	25.28	3187786.0
2011-04-18 14:00:00	MSFT	Stock	25.27	25.28	25.12	25.12	2116270.0
2011-04-18 14:30:00	MSFT	Stock	25.12	25.27	25.12	25.2	2508113.0
2011-04-18 15:00:00	MSFT	Stock	25.2	25.23	25.11	25.14	2434496.0
2011-04-18 15:30:00	MSFT	Stock	25.15	25.16	25.07	25.09	7207884.0
2011-04-18 16:00:00	MSFT	Stock	25.09	25.38	24.74	24.988	2888742.0

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

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