PREVIEW / stock_30min / 2012-09-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-14.parquet
  size:    1.5 MB
  rows:    77,634
  symbols: 3,503

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-09-14 04:00:00	AAPL	Stock	24.475	24.5	24.475	24.4821	41720.0
2012-09-14 04:30:00	AAPL	Stock	24.5	24.5	24.5	24.5	2800.0
2012-09-14 05:00:00	AAPL	Stock	24.4929	24.4929	24.4911	24.4911	5600.0
2012-09-14 05:30:00	AAPL	Stock	24.5143	24.5357	24.5143	24.5357	25200.0
2012-09-14 06:00:00	AAPL	Stock	24.5482	24.5482	24.5357	24.5425	67060.0
2012-09-14 06:30:00	AAPL	Stock	24.5425	24.5429	24.5089	24.5429	42980.0
2012-09-14 07:00:00	AAPL	Stock	24.5536	24.5804	24.5268	24.5689	780024.0
2012-09-14 07:30:00	AAPL	Stock	24.5561	24.5711	24.5357	24.5464	721616.0
2012-09-14 08:00:00	AAPL	Stock	24.5393	24.6214	24.5357	24.6161	3197180.0
2012-09-14 08:30:00	AAPL	Stock	24.6114	24.6282	24.5507	24.5804	2647876.0
2012-09-14 09:00:00	AAPL	Stock	24.5871	24.6493	24.5807	24.6429	2870420.0
2012-09-14 09:30:00	AAPL	Stock	24.6379	24.8521	24.5675	24.7564	129530016.0
2012-09-14 10:00:00	AAPL	Stock	24.7559	24.8393	24.7229	24.7962	56416108.0
2012-09-14 10:30:00	AAPL	Stock	24.7964	24.8171	24.7582	24.815	33025076.0
2012-09-14 11:00:00	AAPL	Stock	24.8136	24.8393	24.7786	24.8221	30596412.0
2012-09-14 11:30:00	AAPL	Stock	24.8218	24.8864	24.8107	24.8354	40313924.0
2012-09-14 12:00:00	AAPL	Stock	24.8357	24.8921	24.8232	24.875	25090128.0
2012-09-14 12:30:00	AAPL	Stock	24.8746	24.8857	24.8536	24.8571	17773616.0
2012-09-14 13:00:00	AAPL	Stock	24.8564	24.8649	24.7643	24.7714	24317832.0
2012-09-14 13:30:00	AAPL	Stock	24.7681	24.8025	24.6496	24.6718	45043236.0
2012-09-14 14:00:00	AAPL	Stock	24.6713	24.7784	24.6713	24.7546	32762156.0
2012-09-14 14:30:00	AAPL	Stock	24.7546	24.7982	24.72	24.7846	23854824.0
2012-09-14 15:00:00	AAPL	Stock	24.7857	24.7939	24.6618	24.7029	32998840.0
2012-09-14 15:30:00	AAPL	Stock	24.7018	24.7061	24.6311	24.6871	57715196.0
2012-09-14 16:00:00	AAPL	Stock	24.6875	24.7608	24.6821	24.7089	23038904.0
2012-09-14 16:30:00	AAPL	Stock	24.7089	24.8097	24.3961	24.7039	1447264.0
2012-09-14 17:00:00	AAPL	Stock	24.7071	24.7364	24.7046	24.735	501228.0
2012-09-14 17:30:00	AAPL	Stock	24.7339	24.7379	24.725	24.725	249844.0
2012-09-14 18:00:00	AAPL	Stock	24.725	24.7286	24.7157	24.7175	222236.0
2012-09-14 18:30:00	AAPL	Stock	24.7193	24.7193	24.7161	24.7193	45080.0
2012-09-14 19:00:00	AAPL	Stock	24.7189	24.7375	24.7189	24.7375	195748.0
2012-09-14 19:30:00	AAPL	Stock	24.7304	24.7589	24.7304	24.75	251104.0
2012-09-14 06:00:00	MSFT	Stock	31.06	31.12	31.06	31.12	200.0
2012-09-14 06:30:00	MSFT	Stock	31.12	31.12	31.12	31.12	900.0
2012-09-14 07:00:00	MSFT	Stock	31.12	31.15	31.08	31.08	3200.0
2012-09-14 07:30:00	MSFT	Stock	31.08	31.08	31.07	31.08	500.0
2012-09-14 08:00:00	MSFT	Stock	31.05	31.13	31.05	31.13	43120.0
2012-09-14 08:30:00	MSFT	Stock	31.15	31.15	30.97	31.09	109138.0
2012-09-14 09:00:00	MSFT	Stock	31.07	31.09	30.96	30.98	27826.0
2012-09-14 09:30:00	MSFT	Stock	31.01	31.07	30.81	30.9	5603099.0
2012-09-14 10:00:00	MSFT	Stock	30.9	31.15	30.89	31.04	5726468.0
2012-09-14 10:30:00	MSFT	Stock	31.044	31.12	31.03	31.12	2532358.0
2012-09-14 11:00:00	MSFT	Stock	31.115	31.14	31.03	31.08	2696545.0
2012-09-14 11:30:00	MSFT	Stock	31.09	31.11	31.02	31.06	2045153.0
2012-09-14 12:00:00	MSFT	Stock	31.052	31.15	31.05	31.15	1721916.0
2012-09-14 12:30:00	MSFT	Stock	31.15	31.15	31.11	31.13	2299840.0
2012-09-14 13:00:00	MSFT	Stock	31.13	31.19	31.08	31.09	2095334.0
2012-09-14 13:30:00	MSFT	Stock	31.1	31.2	31.09	31.18	2240957.0
2012-09-14 14:00:00	MSFT	Stock	31.183	31.25	31.15	31.183	2306358.0
2012-09-14 14:30:00	MSFT	Stock	31.18	31.24	31.16	31.2	2415484.0

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

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