PREVIEW / stock_30min / 2010-01-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-28.parquet
  size:    1.4 MB
  rows:    73,833
  symbols: 3,419

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-01-28 04:30:00	AAPL	Stock	7.4464	7.4464	7.4429	7.4432	12600.0
2010-01-28 05:00:00	AAPL	Stock	7.4482	7.4482	7.4107	7.4107	47320.0
2010-01-28 05:30:00	AAPL	Stock	7.4129	7.4129	7.4129	7.4129	14000.0
2010-01-28 06:00:00	AAPL	Stock	7.4054	7.4054	7.4054	7.4054	2800.0
2010-01-28 06:30:00	AAPL	Stock	7.4079	7.4079	7.3929	7.3929	113400.0
2010-01-28 07:00:00	AAPL	Stock	7.3929	7.4107	7.3793	7.3932	302736.0
2010-01-28 07:30:00	AAPL	Stock	7.3929	7.4093	7.3929	7.4	293020.0
2010-01-28 08:00:00	AAPL	Stock	7.3996	7.41	7.3629	7.4018	3172008.0
2010-01-28 08:30:00	AAPL	Stock	7.4014	7.4014	7.34	7.34	5337444.0
2010-01-28 09:00:00	AAPL	Stock	7.3418	7.3504	7.3143	7.3179	9646224.0
2010-01-28 09:30:00	AAPL	Stock	7.3179	7.3393	7.1561	7.2229	190306592.0
2010-01-28 10:00:00	AAPL	Stock	7.2229	7.2411	7.1346	7.1574	134087044.0
2010-01-28 10:30:00	AAPL	Stock	7.1557	7.1929	7.1271	7.1464	97017508.0
2010-01-28 11:00:00	AAPL	Stock	7.1471	7.1643	7.1071	7.1502	105158844.0
2010-01-28 11:30:00	AAPL	Stock	7.1557	7.1854	7.1193	7.1636	84310128.0
2010-01-28 12:00:00	AAPL	Stock	7.1629	7.175	7.125	7.1311	46173736.0
2010-01-28 12:30:00	AAPL	Stock	7.1327	7.1482	7.1125	7.1425	49669816.0
2010-01-28 13:00:00	AAPL	Stock	7.1429	7.1443	7.0964	7.1262	67047428.0
2010-01-28 13:30:00	AAPL	Stock	7.1282	7.1486	7.1161	7.1336	52520384.0
2010-01-28 14:00:00	AAPL	Stock	7.1339	7.1414	7.0993	7.1361	48534332.0
2010-01-28 14:30:00	AAPL	Stock	7.135	7.1936	7.1179	7.1675	70279076.0
2010-01-28 15:00:00	AAPL	Stock	7.1671	7.2032	7.1546	7.1761	71542352.0
2010-01-28 15:30:00	AAPL	Stock	7.1764	7.1946	7.1057	7.1179	110278364.0
2010-01-28 16:00:00	AAPL	Stock	7.1179	7.1648	7.095	7.1371	12677560.0
2010-01-28 16:30:00	AAPL	Stock	7.1756	7.1756	7.1161	7.1404	2550688.0
2010-01-28 17:00:00	AAPL	Stock	7.1378	7.1461	7.1179	7.125	923524.0
2010-01-28 17:30:00	AAPL	Stock	7.1261	7.1268	7.1175	7.1214	459088.0
2010-01-28 18:00:00	AAPL	Stock	7.1232	7.1232	7.0914	7.0929	695324.0
2010-01-28 18:30:00	AAPL	Stock	7.1043	7.1071	7.0964	7.0993	294868.0
2010-01-28 19:00:00	AAPL	Stock	7.0964	7.1018	7.0896	7.0946	218484.0
2010-01-28 19:30:00	AAPL	Stock	7.0964	7.0982	7.0893	7.0904	417200.0
2010-01-28 06:30:00	MSFT	Stock	29.97	29.97	29.97	29.97	200.0
2010-01-28 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	700.0
2010-01-28 07:30:00	MSFT	Stock	29.9	29.94	29.89	29.93	5910.0
2010-01-28 08:00:00	MSFT	Stock	29.9	29.94	29.85	29.9	86886.0
2010-01-28 08:30:00	MSFT	Stock	29.88	29.91	29.87	29.88	27308.0
2010-01-28 09:00:00	MSFT	Stock	29.86	29.91	29.83	29.84	66243.0
2010-01-28 09:30:00	MSFT	Stock	29.85	29.87	29.54	29.56	9090513.0
2010-01-28 10:00:00	MSFT	Stock	29.565	29.57	29.05	29.144	11800358.0
2010-01-28 10:30:00	MSFT	Stock	29.14	29.26	29.11	29.23	6908942.0
2010-01-28 11:00:00	MSFT	Stock	29.24	29.26	29.15	29.16	7140463.0
2010-01-28 11:30:00	MSFT	Stock	29.15	29.17	29.0	29.02	7195073.0
2010-01-28 12:00:00	MSFT	Stock	29.01	29.11	28.9	28.98	5999192.0
2010-01-28 12:30:00	MSFT	Stock	28.98	29.07	28.89	29.06	3528057.0
2010-01-28 13:00:00	MSFT	Stock	29.06	29.2	28.96	29.18	4407016.0
2010-01-28 13:30:00	MSFT	Stock	29.19	29.39	29.14	29.29	8474846.0
2010-01-28 14:00:00	MSFT	Stock	29.3	29.34	29.14	29.29	6588968.0
2010-01-28 14:30:00	MSFT	Stock	29.29	29.5	29.24	29.41	4891795.0
2010-01-28 15:00:00	MSFT	Stock	29.41	29.54	29.32	29.452	7578055.0
2010-01-28 15:30:00	MSFT	Stock	29.45	29.5	29.16	29.16	16813923.0

> showing 50 of 73,833 rows — these rows as CSV

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