PREVIEW / stock_30min / 2012-02-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-02-15.parquet
  size:    1.5 MB
  rows:    77,071
  symbols: 3,536

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-02-15 04:00:00	AAPL	Stock	18.2982	18.5243	18.2982	18.5	61460.0
2012-02-15 04:30:00	AAPL	Stock	18.4821	18.4911	18.4493	18.4493	96600.0
2012-02-15 05:00:00	AAPL	Stock	18.4554	18.4893	18.4536	18.4893	22400.0
2012-02-15 05:30:00	AAPL	Stock	18.4643	18.4643	18.4325	18.4561	73500.0
2012-02-15 06:00:00	AAPL	Stock	18.4536	18.4604	18.4464	18.4604	263200.0
2012-02-15 06:30:00	AAPL	Stock	18.455	18.4604	18.4429	18.4532	91812.0
2012-02-15 07:00:00	AAPL	Stock	18.4393	18.4536	18.3929	18.4229	646436.0
2012-02-15 07:30:00	AAPL	Stock	18.4239	18.4421	18.4118	18.4143	1405040.0
2012-02-15 08:00:00	AAPL	Stock	18.4143	18.4604	18.3414	18.3589	4047372.0
2012-02-15 08:30:00	AAPL	Stock	18.3589	18.3679	18.2786	18.2789	4311776.0
2012-02-15 09:00:00	AAPL	Stock	18.2814	18.3893	18.2768	18.3743	5970804.0
2012-02-15 09:30:00	AAPL	Stock	18.3725	18.5196	18.3618	18.4904	136317440.0
2012-02-15 10:00:00	AAPL	Stock	18.4875	18.5618	18.4804	18.5396	92332604.0
2012-02-15 10:30:00	AAPL	Stock	18.5421	18.7457	18.5364	18.6646	126569352.0
2012-02-15 11:00:00	AAPL	Stock	18.6646	18.7339	18.6504	18.7286	60972464.0
2012-02-15 11:30:00	AAPL	Stock	18.7286	18.7961	18.6971	18.7861	69350260.0
2012-02-15 12:00:00	AAPL	Stock	18.7886	18.7886	18.6075	18.625	67521048.0
2012-02-15 12:30:00	AAPL	Stock	18.625	18.6261	18.0989	18.1814	242207644.0
2012-02-15 13:00:00	AAPL	Stock	18.1821	18.35	17.9314	18.335	164148516.0
2012-02-15 13:30:00	AAPL	Stock	18.3379	18.3411	18.1446	18.2675	74584944.0
2012-02-15 14:00:00	AAPL	Stock	18.2675	18.2857	18.0718	18.1718	70744604.0
2012-02-15 14:30:00	AAPL	Stock	18.1737	18.1754	17.9857	18.0093	74559856.0
2012-02-15 15:00:00	AAPL	Stock	18.005	18.0157	17.7721	17.8332	149171456.0
2012-02-15 15:30:00	AAPL	Stock	17.8324	17.85	17.7461	17.7704	126946680.0
2012-02-15 16:00:00	AAPL	Stock	17.7636	18.7684	17.76	17.8018	17086244.0
2012-02-15 16:30:00	AAPL	Stock	17.8018	18.29	17.7739	17.7857	1446704.0
2012-02-15 17:00:00	AAPL	Stock	17.7871	17.7893	17.6611	17.6611	2147740.0
2012-02-15 17:30:00	AAPL	Stock	17.6614	17.7107	17.6079	17.6857	3141908.0
2012-02-15 18:00:00	AAPL	Stock	17.6911	17.6964	17.6618	17.6625	1478120.0
2012-02-15 18:30:00	AAPL	Stock	17.6607	17.6679	17.6429	17.6475	850864.0
2012-02-15 19:00:00	AAPL	Stock	17.6482	17.6493	17.6204	17.6357	501564.0
2012-02-15 19:30:00	AAPL	Stock	17.6404	17.6568	17.6286	17.6361	1013768.0
2012-02-15 04:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	800.0
2012-02-15 05:30:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-02-15 06:30:00	MSFT	Stock	30.46	30.46	30.46	30.46	920.0
2012-02-15 07:00:00	MSFT	Stock	30.39	30.39	30.33	30.33	1900.0
2012-02-15 07:30:00	MSFT	Stock	30.39	30.42	30.36	30.38	7306.0
2012-02-15 08:00:00	MSFT	Stock	30.34	30.37	30.31	30.34	11720.0
2012-02-15 08:30:00	MSFT	Stock	30.34	30.39	30.33	30.33	18730.0
2012-02-15 09:00:00	MSFT	Stock	30.34	30.36	30.31	30.34	7198.0
2012-02-15 09:30:00	MSFT	Stock	30.35	30.39	30.12	30.235	5432659.0
2012-02-15 10:00:00	MSFT	Stock	30.24	30.33	30.22	30.27	3348655.0
2012-02-15 10:30:00	MSFT	Stock	30.275	30.38	30.27	30.285	2300396.0
2012-02-15 11:00:00	MSFT	Stock	30.29	30.33	30.245	30.33	2204434.0
2012-02-15 11:30:00	MSFT	Stock	30.33	30.36	30.3	30.328	2111478.0
2012-02-15 12:00:00	MSFT	Stock	30.33	30.34	30.25	30.25	1633169.0
2012-02-15 12:30:00	MSFT	Stock	30.258	30.27	30.12	30.21	3582701.0
2012-02-15 13:00:00	MSFT	Stock	30.21	30.22	30.11	30.18	3418437.0
2012-02-15 13:30:00	MSFT	Stock	30.19	30.225	30.15	30.22	2035129.0
2012-02-15 14:00:00	MSFT	Stock	30.215	30.25	30.09	30.15	2785116.0

> showing 50 of 77,071 rows — these rows as CSV

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