PREVIEW / stock_30min / 2011-01-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-19.parquet
  size:    1.5 MB
  rows:    79,706
  symbols: 3,524

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-01-19 04:00:00	AAPL	Stock	12.3314	12.3429	12.3257	12.3396	28000.0
2011-01-19 04:30:00	AAPL	Stock	12.3475	12.3607	12.3468	12.3489	78400.0
2011-01-19 05:00:00	AAPL	Stock	12.375	12.375	12.3439	12.3739	25200.0
2011-01-19 05:30:00	AAPL	Stock	12.375	12.4104	12.3686	12.3686	125076.0
2011-01-19 06:00:00	AAPL	Stock	12.3929	12.3929	12.3204	12.3214	236880.0
2011-01-19 06:30:00	AAPL	Stock	12.3204	12.3204	12.2471	12.2964	443380.0
2011-01-19 07:00:00	AAPL	Stock	12.3064	12.4036	12.3064	12.3714	2293676.0
2011-01-19 07:30:00	AAPL	Stock	12.3711	12.4107	12.3693	12.3904	3248504.0
2011-01-19 08:00:00	AAPL	Stock	12.3921	12.4107	12.3205	12.4036	7677992.0
2011-01-19 08:30:00	AAPL	Stock	12.4036	12.5321	12.4021	12.4904	23370872.0
2011-01-19 09:00:00	AAPL	Stock	12.4882	12.5082	12.4389	12.4411	15618596.0
2011-01-19 09:30:00	AAPL	Stock	12.4425	12.45	12.2639	12.2639	288766380.0
2011-01-19 10:00:00	AAPL	Stock	12.2643	12.2932	12.1607	12.1886	149390528.0
2011-01-19 10:30:00	AAPL	Stock	12.1886	12.2396	12.1429	12.2393	96680248.0
2011-01-19 11:00:00	AAPL	Stock	12.2396	12.2554	12.2061	12.2384	52042676.0
2011-01-19 11:30:00	AAPL	Stock	12.239	12.315	12.2388	12.2829	58270352.0
2011-01-19 12:00:00	AAPL	Stock	12.2827	12.2907	12.2354	12.2417	26807032.0
2011-01-19 12:30:00	AAPL	Stock	12.2414	12.2421	12.1981	12.2279	33412876.0
2011-01-19 13:00:00	AAPL	Stock	12.2279	12.26	12.1918	12.2357	32740232.0
2011-01-19 13:30:00	AAPL	Stock	12.2343	12.2439	12.1986	12.2179	26051872.0
2011-01-19 14:00:00	AAPL	Stock	12.2189	12.2321	12.1836	12.1999	29546692.0
2011-01-19 14:30:00	AAPL	Stock	12.201	12.2086	12.0893	12.1228	73453156.0
2011-01-19 15:00:00	AAPL	Stock	12.1209	12.1393	12.0536	12.09	78381968.0
2011-01-19 15:30:00	AAPL	Stock	12.09	12.1061	12.0314	12.1014	103916092.0
2011-01-19 16:00:00	AAPL	Stock	12.0947	12.2541	12.0714	12.0771	19514516.0
2011-01-19 16:30:00	AAPL	Stock	12.0779	12.4515	12.075	12.0818	1054508.0
2011-01-19 17:00:00	AAPL	Stock	12.0811	12.0814	12.0275	12.0286	1025360.0
2011-01-19 17:30:00	AAPL	Stock	12.0279	12.0418	12.0179	12.025	1007776.0
2011-01-19 18:00:00	AAPL	Stock	12.0261	12.1014	12.0111	12.0143	705404.0
2011-01-19 18:30:00	AAPL	Stock	12.015	12.0168	12.0075	12.0079	329028.0
2011-01-19 19:00:00	AAPL	Stock	12.0079	12.0229	12.0071	12.0171	249648.0
2011-01-19 19:30:00	AAPL	Stock	12.0143	12.0304	12.0107	12.0236	560056.0
2011-01-19 04:00:00	MSFT	Stock	28.67	28.67	28.66	28.66	200.0
2011-01-19 04:30:00	MSFT	Stock	28.66	28.66	28.66	28.66	100.0
2011-01-19 07:00:00	MSFT	Stock	28.78	28.78	28.78	28.78	200.0
2011-01-19 07:30:00	MSFT	Stock	28.75	28.75	28.75	28.75	3900.0
2011-01-19 08:00:00	MSFT	Stock	28.76	28.77	28.7	28.72	8600.0
2011-01-19 08:30:00	MSFT	Stock	28.71	28.71	28.64	28.66	51717.0
2011-01-19 09:00:00	MSFT	Stock	28.66	28.67	28.45	28.45	113922.0
2011-01-19 09:30:00	MSFT	Stock	28.45	28.68	28.45	28.58	6654000.0
2011-01-19 10:00:00	MSFT	Stock	28.572	28.66	28.54	28.55	4121955.0
2011-01-19 10:30:00	MSFT	Stock	28.54	28.64	28.495	28.604	3406373.0
2011-01-19 11:00:00	MSFT	Stock	28.605	28.62	28.51	28.54	2095145.0
2011-01-19 11:30:00	MSFT	Stock	28.538	28.57	28.44	28.455	2811320.0
2011-01-19 12:00:00	MSFT	Stock	28.45	28.49	28.41	28.47	2424734.0
2011-01-19 12:30:00	MSFT	Stock	28.47	28.48	28.32	28.32	3865435.0
2011-01-19 13:00:00	MSFT	Stock	28.32	28.42	28.29	28.372	3328713.0
2011-01-19 13:30:00	MSFT	Stock	28.38	28.43	28.29	28.312	2267839.0
2011-01-19 14:00:00	MSFT	Stock	28.32	28.36	28.29	28.36	2939905.0
2011-01-19 14:30:00	MSFT	Stock	28.355	28.39	28.27	28.31	2360771.0

> showing 50 of 79,706 rows — these rows as CSV

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