PREVIEW / stock_30min / 2013-05-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-21.parquet
  size:    1.5 MB
  rows:    77,955
  symbols: 3,508

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
2013-05-21 04:00:00	AAPL	Stock	15.7157	15.7157	15.6786	15.7154	16800.0
2013-05-21 05:00:00	AAPL	Stock	15.6786	15.6786	15.6786	15.6786	8400.0
2013-05-21 06:00:00	AAPL	Stock	15.6718	15.6764	15.6718	15.6764	12600.0
2013-05-21 06:30:00	AAPL	Stock	15.6661	15.6696	15.6604	15.6604	50036.0
2013-05-21 07:00:00	AAPL	Stock	15.6607	15.7107	15.6607	15.6964	75768.0
2013-05-21 07:30:00	AAPL	Stock	15.6925	15.6925	15.6671	15.6793	63616.0
2013-05-21 08:00:00	AAPL	Stock	15.6857	15.75	15.6514	15.7304	825216.0
2013-05-21 08:30:00	AAPL	Stock	15.7286	15.8121	15.6996	15.7075	865116.0
2013-05-21 09:00:00	AAPL	Stock	15.7139	15.7232	15.6125	15.6407	1240932.0
2013-05-21 09:30:00	AAPL	Stock	15.6482	15.7407	15.5071	15.6275	83479256.0
2013-05-21 10:00:00	AAPL	Stock	15.63	15.6536	15.5089	15.5367	38005296.0
2013-05-21 10:30:00	AAPL	Stock	15.5371	15.6789	15.525	15.6457	36252636.0
2013-05-21 11:00:00	AAPL	Stock	15.6504	15.76	15.6336	15.6589	35219576.0
2013-05-21 11:30:00	AAPL	Stock	15.66	15.7757	15.66	15.7243	31916724.0
2013-05-21 12:00:00	AAPL	Stock	15.7246	15.8036	15.6971	15.7746	29090180.0
2013-05-21 12:30:00	AAPL	Stock	15.7746	15.9086	15.7561	15.9014	35806876.0
2013-05-21 13:00:00	AAPL	Stock	15.9011	15.91	15.8071	15.8196	36149624.0
2013-05-21 13:30:00	AAPL	Stock	15.8257	15.8382	15.7589	15.8186	16430232.0
2013-05-21 14:00:00	AAPL	Stock	15.8143	15.8343	15.7607	15.7607	12095692.0
2013-05-21 14:30:00	AAPL	Stock	15.7607	15.7607	15.6607	15.6946	28592480.0
2013-05-21 15:00:00	AAPL	Stock	15.6964	15.7861	15.6918	15.7361	20608784.0
2013-05-21 15:30:00	AAPL	Stock	15.7357	15.7857	15.6984	15.7021	28514836.0
2013-05-21 16:00:00	AAPL	Stock	15.7021	15.8121	15.6077	15.6077	12904920.0
2013-05-21 16:30:00	AAPL	Stock	15.6982	15.733	15.6825	15.7021	506100.0
2013-05-21 17:00:00	AAPL	Stock	15.6907	15.6921	15.6907	15.6921	18088.0
2013-05-21 17:30:00	AAPL	Stock	15.6921	15.6921	15.6818	15.6818	14448.0
2013-05-21 18:00:00	AAPL	Stock	15.6904	15.7321	15.6904	15.7321	392336.0
2013-05-21 18:30:00	AAPL	Stock	15.7157	15.7339	15.7143	15.7321	117180.0
2013-05-21 19:00:00	AAPL	Stock	15.7339	15.7339	15.7164	15.7164	18928.0
2013-05-21 19:30:00	AAPL	Stock	15.7179	15.7271	15.7143	15.7214	83048.0
2013-05-21 06:00:00	MSFT	Stock	34.99	34.99	34.99	34.99	100.0
2013-05-21 06:30:00	MSFT	Stock	34.99	34.99	34.99	34.99	845.0
2013-05-21 07:30:00	MSFT	Stock	35.1	35.14	35.1	35.14	4650.0
2013-05-21 08:00:00	MSFT	Stock	35.29	35.29	34.9	35.24	39559.0
2013-05-21 08:30:00	MSFT	Stock	35.24	35.27	35.06	35.2	203090.0
2013-05-21 09:00:00	MSFT	Stock	35.22	35.29	35.07	35.13	184282.0
2013-05-21 09:30:00	MSFT	Stock	35.14	35.272	35.07	35.11	7466721.0
2013-05-21 10:00:00	MSFT	Stock	35.1	35.14	34.91	35.04	6428355.0
2013-05-21 10:30:00	MSFT	Stock	35.045	35.1	34.95	34.955	3909177.0
2013-05-21 11:00:00	MSFT	Stock	34.96	35.01	34.8	34.845	3313485.0
2013-05-21 11:30:00	MSFT	Stock	34.85	35.02	34.81	34.88	2382334.0
2013-05-21 12:00:00	MSFT	Stock	34.89	34.995	34.885	34.99	1394139.0
2013-05-21 12:30:00	MSFT	Stock	34.985	35.02	34.94	34.993	2200693.0
2013-05-21 13:00:00	MSFT	Stock	35.0	35.08	34.99	35.07	2358477.0
2013-05-21 13:30:00	MSFT	Stock	35.07	35.07	35.015	35.04	1839166.0
2013-05-21 14:00:00	MSFT	Stock	35.03	35.059	34.88	34.887	2344478.0
2013-05-21 14:30:00	MSFT	Stock	34.88	34.93	34.72	34.84	4099665.0
2013-05-21 15:00:00	MSFT	Stock	34.845	34.88	34.81	34.84	2146033.0
2013-05-21 15:30:00	MSFT	Stock	34.835	34.9	34.79	34.85	4831368.0
2013-05-21 16:00:00	MSFT	Stock	34.855	35.06	34.82	34.84	1447568.0

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

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