PREVIEW / stock_30min / 2014-03-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-14.parquet
  size:    1.6 MB
  rows:    81,376
  symbols: 3,543

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
2014-03-14 04:00:00	AAPL	Stock	18.8925	18.9286	18.8925	18.8929	16800.0
2014-03-14 06:30:00	AAPL	Stock	18.9071	18.9071	18.9018	18.9018	5600.0
2014-03-14 07:00:00	AAPL	Stock	18.9071	18.9371	18.9036	18.9286	96096.0
2014-03-14 07:30:00	AAPL	Stock	18.9143	18.9143	18.8968	18.9114	47012.0
2014-03-14 08:00:00	AAPL	Stock	18.9196	18.9286	18.9	18.9029	167944.0
2014-03-14 08:30:00	AAPL	Stock	18.8996	18.9007	18.8786	18.885	168952.0
2014-03-14 09:00:00	AAPL	Stock	18.8929	18.9161	18.8589	18.8779	258608.0
2014-03-14 09:30:00	AAPL	Stock	18.8646	18.9604	18.7939	18.8089	29984836.0
2014-03-14 10:00:00	AAPL	Stock	18.8046	18.86	18.7536	18.7737	27339592.0
2014-03-14 10:30:00	AAPL	Stock	18.7722	18.7925	18.7057	18.73	19126604.0
2014-03-14 11:00:00	AAPL	Stock	18.7307	18.7736	18.6786	18.7618	19492984.0
2014-03-14 11:30:00	AAPL	Stock	18.7624	18.8296	18.7554	18.8099	15768956.0
2014-03-14 12:00:00	AAPL	Stock	18.8107	18.8175	18.7579	18.7654	6671168.0
2014-03-14 12:30:00	AAPL	Stock	18.7668	18.7857	18.7414	18.7661	6541696.0
2014-03-14 13:00:00	AAPL	Stock	18.7659	18.7736	18.7343	18.75	4988396.0
2014-03-14 13:30:00	AAPL	Stock	18.7504	18.7693	18.7354	18.7522	6088684.0
2014-03-14 14:00:00	AAPL	Stock	18.7496	18.7504	18.7096	18.73	5777464.0
2014-03-14 14:30:00	AAPL	Stock	18.73	18.7321	18.6875	18.6925	6342112.0
2014-03-14 15:00:00	AAPL	Stock	18.6943	18.7207	18.6861	18.7096	8940120.0
2014-03-14 15:30:00	AAPL	Stock	18.711	18.7639	18.7068	18.7379	26016340.0
2014-03-14 16:00:00	AAPL	Stock	18.7382	18.7732	18.7332	18.7461	9120020.0
2014-03-14 16:30:00	AAPL	Stock	18.7418	18.7605	18.7393	18.7396	164528.0
2014-03-14 17:00:00	AAPL	Stock	18.7429	18.7429	18.7329	18.7329	310464.0
2014-03-14 17:30:00	AAPL	Stock	18.7332	18.7332	18.7311	18.7311	14000.0
2014-03-14 18:00:00	AAPL	Stock	18.7268	18.7425	18.7268	18.7425	37464.0
2014-03-14 18:30:00	AAPL	Stock	18.7382	18.7382	18.7382	18.7382	277088.0
2014-03-14 19:30:00	AAPL	Stock	18.7321	18.7425	18.7264	18.7425	114324.0
2014-03-14 06:00:00	MSFT	Stock	37.87	37.87	37.87	37.87	100.0
2014-03-14 07:30:00	MSFT	Stock	37.77	37.77	37.76	37.76	1000.0
2014-03-14 08:30:00	MSFT	Stock	37.69	37.8	37.66	37.8	10423.0
2014-03-14 09:00:00	MSFT	Stock	37.8	37.8	37.61	37.65	15000.0
2014-03-14 09:30:00	MSFT	Stock	37.68	38.09	37.63	37.824	3551743.0
2014-03-14 10:00:00	MSFT	Stock	37.83	38.13	37.82	37.99	3232041.0
2014-03-14 10:30:00	MSFT	Stock	38.0	38.035	37.82	37.86	1746207.0
2014-03-14 11:00:00	MSFT	Stock	37.86	37.95	37.815	37.94	1253418.0
2014-03-14 11:30:00	MSFT	Stock	37.94	38.135	37.9	38.095	1552607.0
2014-03-14 12:00:00	MSFT	Stock	38.09	38.11	37.921	37.921	1030811.0
2014-03-14 12:30:00	MSFT	Stock	37.925	37.97	37.8	37.95	1637952.0
2014-03-14 13:00:00	MSFT	Stock	37.955	38.0	37.89	37.92	1025772.0
2014-03-14 13:30:00	MSFT	Stock	37.92	37.97	37.81	37.86	728164.0
2014-03-14 14:00:00	MSFT	Stock	37.86	37.88	37.785	37.843	925261.0
2014-03-14 14:30:00	MSFT	Stock	37.845	37.85	37.76	37.765	1114161.0
2014-03-14 15:00:00	MSFT	Stock	37.765	37.89	37.76	37.855	1702038.0
2014-03-14 15:30:00	MSFT	Stock	37.86	37.925	37.69	37.7	4260949.0
2014-03-14 16:00:00	MSFT	Stock	37.7	38.041	37.65	37.7	2528015.0
2014-03-14 16:30:00	MSFT	Stock	37.69	37.7	37.69	37.7	61155.0
2014-03-14 17:00:00	MSFT	Stock	37.69	37.821	37.67	37.67	1172.0
2014-03-14 17:30:00	MSFT	Stock	37.67	37.69	37.67	37.69	400.0
2014-03-14 18:30:00	MSFT	Stock	37.67	37.7	37.67	37.7	7660.0
2014-03-14 19:00:00	MSFT	Stock	37.7	37.7	37.67	37.67	2500.0

> showing 50 of 81,376 rows — these rows as CSV

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