PREVIEW / stock_30min / 2012-03-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-12.parquet
  size:    1.4 MB
  rows:    74,407
  symbols: 3,512

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-03-12 05:00:00	AAPL	Stock	19.4643	19.4643	19.4414	19.4414	45808.0
2012-03-12 05:30:00	AAPL	Stock	19.4568	19.4568	19.4564	19.4564	8400.0
2012-03-12 06:00:00	AAPL	Stock	19.4557	19.4557	19.4536	19.4546	39200.0
2012-03-12 07:00:00	AAPL	Stock	19.4607	19.4993	19.4607	19.4821	420140.0
2012-03-12 07:30:00	AAPL	Stock	19.4821	19.4821	19.4643	19.4793	385868.0
2012-03-12 08:00:00	AAPL	Stock	19.4793	19.6107	19.4761	19.5714	4427332.0
2012-03-12 08:30:00	AAPL	Stock	19.5711	19.5846	19.5575	19.5832	2515548.0
2012-03-12 09:00:00	AAPL	Stock	19.5843	19.6246	19.5821	19.6068	4204816.0
2012-03-12 09:30:00	AAPL	Stock	19.6068	19.6936	19.5796	19.6104	84109872.0
2012-03-12 10:00:00	AAPL	Stock	19.6111	19.6446	19.5357	19.6114	53570048.0
2012-03-12 10:30:00	AAPL	Stock	19.6111	19.625	19.5561	19.6246	28072436.0
2012-03-12 11:00:00	AAPL	Stock	19.6241	19.6286	19.5689	19.5982	21542612.0
2012-03-12 11:30:00	AAPL	Stock	19.6007	19.6229	19.5939	19.6093	16341444.0
2012-03-12 12:00:00	AAPL	Stock	19.6093	19.6339	19.5914	19.6282	13731956.0
2012-03-12 12:30:00	AAPL	Stock	19.6246	19.6925	19.6211	19.6904	34635804.0
2012-03-12 13:00:00	AAPL	Stock	19.6921	19.6925	19.6539	19.6736	14084364.0
2012-03-12 13:30:00	AAPL	Stock	19.6746	19.7093	19.6707	19.6832	22460564.0
2012-03-12 14:00:00	AAPL	Stock	19.685	19.7021	19.6782	19.6814	11063500.0
2012-03-12 14:30:00	AAPL	Stock	19.6814	19.6896	19.67	19.6857	12022388.0
2012-03-12 15:00:00	AAPL	Stock	19.6871	19.6886	19.6504	19.6786	19055876.0
2012-03-12 15:30:00	AAPL	Stock	19.6793	19.7143	19.6736	19.7143	40641552.0
2012-03-12 16:00:00	AAPL	Stock	19.7143	19.7329	19.6333	19.7325	11710328.0
2012-03-12 16:30:00	AAPL	Stock	19.7321	19.7354	19.6068	19.7321	494620.0
2012-03-12 17:00:00	AAPL	Stock	19.7321	19.7343	19.7261	19.7321	423024.0
2012-03-12 17:30:00	AAPL	Stock	19.7321	19.7357	19.7311	19.7343	141708.0
2012-03-12 18:00:00	AAPL	Stock	19.7339	19.7536	19.7329	19.75	1183784.0
2012-03-12 18:30:00	AAPL	Stock	19.7507	19.7857	19.7507	19.775	1052156.0
2012-03-12 19:00:00	AAPL	Stock	19.775	19.7786	19.7729	19.7782	370076.0
2012-03-12 19:30:00	AAPL	Stock	19.775	19.7846	19.77	19.7764	477624.0
2012-03-12 07:30:00	MSFT	Stock	31.99	31.99	31.99	31.99	100.0
2012-03-12 08:00:00	MSFT	Stock	31.95	31.95	31.9	31.9	1608.0
2012-03-12 08:30:00	MSFT	Stock	31.99	31.99	31.91	31.91	1000.0
2012-03-12 09:00:00	MSFT	Stock	31.91	31.95	31.89	31.95	20116.0
2012-03-12 09:30:00	MSFT	Stock	31.97	32.1	31.82	32.07	3287678.0
2012-03-12 10:00:00	MSFT	Stock	32.07	32.09	31.97	32.039	3603352.0
2012-03-12 10:30:00	MSFT	Stock	32.035	32.08	31.96	32.08	2604323.0
2012-03-12 11:00:00	MSFT	Stock	32.075	32.1	32.0	32.045	2147743.0
2012-03-12 11:30:00	MSFT	Stock	32.045	32.07	32.005	32.06	2482045.0
2012-03-12 12:00:00	MSFT	Stock	32.05	32.13	32.03	32.06	2228966.0
2012-03-12 12:30:00	MSFT	Stock	32.06	32.12	32.04	32.1	1740916.0
2012-03-12 13:00:00	MSFT	Stock	32.097	32.12	32.06	32.101	1218381.0
2012-03-12 13:30:00	MSFT	Stock	32.105	32.2	32.1	32.14	1594142.0
2012-03-12 14:00:00	MSFT	Stock	32.14	32.16	32.11	32.135	1342462.0
2012-03-12 14:30:00	MSFT	Stock	32.135	32.14	32.08	32.12	1775480.0
2012-03-12 15:00:00	MSFT	Stock	32.115	32.12	32.1	32.1	1529716.0
2012-03-12 15:30:00	MSFT	Stock	32.105	32.11	32.02	32.05	5896284.0
2012-03-12 16:00:00	MSFT	Stock	32.05	32.1	32.03	32.04	1749668.0
2012-03-12 16:30:00	MSFT	Stock	31.994	32.11	31.994	32.04	36629.0
2012-03-12 17:00:00	MSFT	Stock	32.04	32.04	32.04	32.04	100.0
2012-03-12 17:30:00	MSFT	Stock	32.08	32.08	32.08	32.08	891.0

> showing 50 of 74,407 rows — these rows as CSV

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