PREVIEW / stock_30min / 2010-11-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-17.parquet
  size:    1.4 MB
  rows:    75,177
  symbols: 3,504

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
2010-11-17 05:00:00	AAPL	Stock	10.8036	10.8036	10.8036	10.8036	13860.0
2010-11-17 05:30:00	AAPL	Stock	10.7946	10.7946	10.7946	10.7946	2800.0
2010-11-17 06:00:00	AAPL	Stock	10.7871	10.7871	10.7843	10.7843	14000.0
2010-11-17 06:30:00	AAPL	Stock	10.7864	10.7864	10.7864	10.7864	2800.0
2010-11-17 07:00:00	AAPL	Stock	10.8029	10.8029	10.7536	10.7561	112000.0
2010-11-17 07:30:00	AAPL	Stock	10.7529	10.7707	10.7461	10.7682	145740.0
2010-11-17 08:00:00	AAPL	Stock	10.7746	10.7911	10.7618	10.7821	1545992.0
2010-11-17 08:30:00	AAPL	Stock	10.7821	10.8007	10.7707	10.7714	1521884.0
2010-11-17 09:00:00	AAPL	Stock	10.775	10.7857	10.7536	10.7554	1304380.0
2010-11-17 09:30:00	AAPL	Stock	10.755	10.8136	10.7232	10.7543	69359612.0
2010-11-17 10:00:00	AAPL	Stock	10.7532	10.8214	10.7532	10.8082	47048988.0
2010-11-17 10:30:00	AAPL	Stock	10.8089	10.8568	10.7929	10.8279	40328876.0
2010-11-17 11:00:00	AAPL	Stock	10.8286	10.8371	10.79	10.8287	26698392.0
2010-11-17 11:30:00	AAPL	Stock	10.8261	10.8304	10.7911	10.8179	18391100.0
2010-11-17 12:00:00	AAPL	Stock	10.8192	10.8304	10.8036	10.8093	11457460.0
2010-11-17 12:30:00	AAPL	Stock	10.8079	10.8132	10.7929	10.8018	12356680.0
2010-11-17 13:00:00	AAPL	Stock	10.8011	10.8107	10.7725	10.8039	17362380.0
2010-11-17 13:30:00	AAPL	Stock	10.8052	10.8125	10.7818	10.7865	14509404.0
2010-11-17 14:00:00	AAPL	Stock	10.7875	10.8036	10.7857	10.7886	11376484.0
2010-11-17 14:30:00	AAPL	Stock	10.7907	10.8104	10.7579	10.7711	23052988.0
2010-11-17 15:00:00	AAPL	Stock	10.7693	10.7718	10.6343	10.6471	83207236.0
2010-11-17 15:30:00	AAPL	Stock	10.6493	10.7339	10.6457	10.7268	83135724.0
2010-11-17 16:00:00	AAPL	Stock	10.7314	10.7621	10.7243	10.7339	8951544.0
2010-11-17 16:30:00	AAPL	Stock	10.7339	10.735	10.6544	10.7325	363888.0
2010-11-17 17:00:00	AAPL	Stock	10.7268	10.7296	10.7214	10.7268	142688.0
2010-11-17 17:30:00	AAPL	Stock	10.7304	10.7321	10.7286	10.7321	56308.0
2010-11-17 18:00:00	AAPL	Stock	10.7339	10.7468	10.7271	10.7443	315980.0
2010-11-17 18:30:00	AAPL	Stock	10.7443	10.7479	10.7411	10.7479	80920.0
2010-11-17 19:00:00	AAPL	Stock	10.7418	10.7475	10.7418	10.7464	53172.0
2010-11-17 19:30:00	AAPL	Stock	10.7471	10.7679	10.7471	10.7679	320068.0
2010-11-17 07:00:00	MSFT	Stock	25.81	25.81	25.81	25.81	1000.0
2010-11-17 07:30:00	MSFT	Stock	25.81	25.82	25.81	25.82	200.0
2010-11-17 08:00:00	MSFT	Stock	25.85	25.91	25.85	25.9	10160.0
2010-11-17 08:30:00	MSFT	Stock	25.91	25.91	25.86	25.86	10719.0
2010-11-17 09:00:00	MSFT	Stock	25.88	25.91	25.85	25.91	8541.0
2010-11-17 09:30:00	MSFT	Stock	25.9	25.91	25.783	25.815	6882620.0
2010-11-17 10:00:00	MSFT	Stock	25.816	25.84	25.76	25.81	3794030.0
2010-11-17 10:30:00	MSFT	Stock	25.82	25.83	25.76	25.77	4126410.0
2010-11-17 11:00:00	MSFT	Stock	25.778	25.78	25.7	25.74	2845304.0
2010-11-17 11:30:00	MSFT	Stock	25.74	25.8	25.71	25.78	2741038.0
2010-11-17 12:00:00	MSFT	Stock	25.785	25.79	25.73	25.752	1892671.0
2010-11-17 12:30:00	MSFT	Stock	25.755	25.77	25.73	25.77	3580879.0
2010-11-17 13:00:00	MSFT	Stock	25.76	25.78	25.73	25.745	1878340.0
2010-11-17 13:30:00	MSFT	Stock	25.75	25.75	25.7	25.71	2540290.0
2010-11-17 14:00:00	MSFT	Stock	25.715	25.77	25.71	25.72	2525611.0
2010-11-17 14:30:00	MSFT	Stock	25.72	25.78	25.71	25.75	5911185.0
2010-11-17 15:00:00	MSFT	Stock	25.75	25.77	25.58	25.61	4658447.0
2010-11-17 15:30:00	MSFT	Stock	25.61	25.68	25.55	25.59	9157709.0
2010-11-17 16:00:00	MSFT	Stock	25.58	25.739	25.51	25.6	2874678.0
2010-11-17 16:30:00	MSFT	Stock	25.6	25.62	25.54	25.57	72050.0

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

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