PREVIEW / stock_30min / 2010-05-06

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-06.parquet
  size:    1.6 MB
  rows:    82,648
  symbols: 3,492

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
2010-05-06 04:00:00	AAPL	Stock	9.1129	9.2857	9.1129	9.1536	92400.0
2010-05-06 04:30:00	AAPL	Stock	9.1536	9.1536	9.1286	9.1429	42000.0
2010-05-06 05:00:00	AAPL	Stock	9.1429	9.1429	9.1429	9.1429	2800.0
2010-05-06 05:30:00	AAPL	Stock	9.1286	9.1286	9.1286	9.1286	2800.0
2010-05-06 06:00:00	AAPL	Stock	9.1357	9.1607	9.1339	9.1607	14000.0
2010-05-06 06:30:00	AAPL	Stock	9.1625	9.1643	9.1625	9.1643	11200.0
2010-05-06 07:00:00	AAPL	Stock	9.1714	9.1918	9.1661	9.1661	106344.0
2010-05-06 07:30:00	AAPL	Stock	9.1689	9.1714	9.1425	9.15	121408.0
2010-05-06 08:00:00	AAPL	Stock	9.155	9.1661	9.0957	9.1286	1357552.0
2010-05-06 08:30:00	AAPL	Stock	9.1375	9.1429	9.0536	9.0554	1625596.0
2010-05-06 09:00:00	AAPL	Stock	9.0536	9.0782	9.0357	9.06	2554748.0
2010-05-06 09:30:00	AAPL	Stock	9.0654	9.2082	9.055	9.1771	92122464.0
2010-05-06 10:00:00	AAPL	Stock	9.1789	9.2232	9.14	9.1632	59262420.0
2010-05-06 10:30:00	AAPL	Stock	9.1636	9.1857	9.1096	9.1332	43344784.0
2010-05-06 11:00:00	AAPL	Stock	9.1336	9.1396	9.0536	9.1125	59904040.0
2010-05-06 11:30:00	AAPL	Stock	9.1104	9.1161	9.0446	9.1129	50654996.0
2010-05-06 12:00:00	AAPL	Stock	9.1136	9.1285	9.0839	9.0897	37883384.0
2010-05-06 12:30:00	AAPL	Stock	9.0896	9.1032	8.9807	9.0414	50270752.0
2010-05-06 13:00:00	AAPL	Stock	9.043	9.0607	8.9572	8.9964	47043388.0
2010-05-06 13:30:00	AAPL	Stock	8.9946	9.0114	8.9471	8.975	47138644.0
2010-05-06 14:00:00	AAPL	Stock	8.9739	8.9825	8.7946	8.8514	113328796.0
2010-05-06 14:30:00	AAPL	Stock	8.8448	8.8557	7.1161	8.6789	304642912.0
2010-05-06 15:00:00	AAPL	Stock	8.6775	8.9161	8.5643	8.7032	177227904.0
2010-05-06 15:30:00	AAPL	Stock	8.7032	9.0536	8.6464	8.7875	161075600.0
2010-05-06 16:00:00	AAPL	Stock	8.7886	8.8482	8.6191	8.7893	17729516.0
2010-05-06 16:30:00	AAPL	Stock	8.7921	8.9816	8.7236	8.7236	2843008.0
2010-05-06 17:00:00	AAPL	Stock	8.7286	8.8008	8.5943	8.6396	1465240.0
2010-05-06 17:30:00	AAPL	Stock	8.6429	8.6557	8.5764	8.625	1991304.0
2010-05-06 18:00:00	AAPL	Stock	8.625	8.6568	8.5807	8.5954	1387428.0
2010-05-06 18:30:00	AAPL	Stock	8.6071	8.62	8.5364	8.5536	1366428.0
2010-05-06 19:00:00	AAPL	Stock	8.5675	9.1755	8.5196	8.5607	1134196.0
2010-05-06 19:30:00	AAPL	Stock	8.5675	8.6429	8.5557	8.6429	1216264.0
2010-05-06 06:30:00	MSFT	Stock	29.9	29.9	29.9	29.9	3100.0
2010-05-06 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	1000.0
2010-05-06 07:30:00	MSFT	Stock	29.77	29.84	29.77	29.84	1839.0
2010-05-06 08:00:00	MSFT	Stock	29.84	29.84	29.73	29.77	4814.0
2010-05-06 08:30:00	MSFT	Stock	29.79	29.82	29.69	29.7	11813.0
2010-05-06 09:00:00	MSFT	Stock	29.7	29.76	29.57	29.61	35531.0
2010-05-06 09:30:00	MSFT	Stock	29.61	29.8	29.52	29.76	6181929.0
2010-05-06 10:00:00	MSFT	Stock	29.76	29.84	29.64	29.65	4421399.0
2010-05-06 10:30:00	MSFT	Stock	29.65	29.72	29.63	29.68	4735599.0
2010-05-06 11:00:00	MSFT	Stock	29.67	29.7	29.62	29.66	6052034.0
2010-05-06 11:30:00	MSFT	Stock	29.66	29.75	29.58	29.72	6556582.0
2010-05-06 12:00:00	MSFT	Stock	29.73	29.88	29.725	29.766	3593673.0
2010-05-06 12:30:00	MSFT	Stock	29.765	29.81	29.67	29.765	3202241.0
2010-05-06 13:00:00	MSFT	Stock	29.76	29.81	29.67	29.718	5738292.0
2010-05-06 13:30:00	MSFT	Stock	29.71	29.72	29.61	29.671	6349034.0
2010-05-06 14:00:00	MSFT	Stock	29.68	29.74	29.31	29.31	13725410.0
2010-05-06 14:30:00	MSFT	Stock	29.32	29.33	27.91	28.8	26361047.0
2010-05-06 15:00:00	MSFT	Stock	28.8	29.38	28.56	28.8	18324167.0

> showing 50 of 82,648 rows — these rows as CSV

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