PREVIEW / stock_30min / 2008-03-31

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-31.parquet
  size:    1.2 MB
  rows:    69,093
  symbols: 3,283

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
2008-03-31 05:00:00	AAPL	Stock	5.0993	5.0993	5.0864	5.0864	5600.0
2008-03-31 06:30:00	AAPL	Stock	5.0929	5.1046	5.0929	5.1046	5600.0
2008-03-31 07:00:00	AAPL	Stock	5.1125	5.1357	5.1125	5.125	123984.0
2008-03-31 07:30:00	AAPL	Stock	5.1232	5.1375	5.1221	5.1375	117796.0
2008-03-31 08:00:00	AAPL	Stock	5.1361	5.1429	5.1343	5.1368	1281000.0
2008-03-31 08:30:00	AAPL	Stock	5.1371	5.1375	5.105	5.1214	1282148.0
2008-03-31 09:00:00	AAPL	Stock	5.1143	5.125	5.1125	5.1143	930496.0
2008-03-31 09:30:00	AAPL	Stock	5.1168	5.2039	5.1136	5.1761	114691304.0
2008-03-31 10:00:00	AAPL	Stock	5.1761	5.1786	5.1443	5.1479	75064528.0
2008-03-31 10:30:00	AAPL	Stock	5.1486	5.1689	5.1346	5.1629	61528376.0
2008-03-31 11:00:00	AAPL	Stock	5.1632	5.1664	5.1407	5.1511	42620900.0
2008-03-31 11:30:00	AAPL	Stock	5.1511	5.1568	5.1336	5.1336	37464868.0
2008-03-31 12:00:00	AAPL	Stock	5.1336	5.1354	5.09	5.1096	55111784.0
2008-03-31 12:30:00	AAPL	Stock	5.1086	5.139	5.1018	5.1329	40425532.0
2008-03-31 13:00:00	AAPL	Stock	5.1329	5.1679	5.1311	5.1654	54054308.0
2008-03-31 13:30:00	AAPL	Stock	5.1654	5.1725	5.1325	5.1364	41486564.0
2008-03-31 14:00:00	AAPL	Stock	5.1371	5.1393	5.1146	5.1354	42425656.0
2008-03-31 14:30:00	AAPL	Stock	5.1346	5.1496	5.1107	5.1271	46590348.0
2008-03-31 15:00:00	AAPL	Stock	5.1268	5.1461	5.1129	5.1221	41220088.0
2008-03-31 15:30:00	AAPL	Stock	5.1218	5.1461	5.1125	5.125	76230336.0
2008-03-31 16:00:00	AAPL	Stock	5.125	5.1442	5.12	5.1321	19444040.0
2008-03-31 16:30:00	AAPL	Stock	5.1267	5.1336	5.125	5.1321	792568.0
2008-03-31 17:00:00	AAPL	Stock	5.1318	5.1424	5.1304	5.1314	110880.0
2008-03-31 17:30:00	AAPL	Stock	5.125	5.1537	5.125	5.1361	721168.0
2008-03-31 18:00:00	AAPL	Stock	5.1361	5.1375	5.1339	5.1368	121128.0
2008-03-31 18:30:00	AAPL	Stock	5.1364	5.1375	5.1357	5.1357	30800.0
2008-03-31 19:00:00	AAPL	Stock	5.1332	5.1357	5.1325	5.1357	23800.0
2008-03-31 19:30:00	AAPL	Stock	5.1339	5.1389	5.1339	5.1389	168308.0
2008-03-31 08:00:00	MSFT	Stock	28.0	28.08	27.99	28.08	2800.0
2008-03-31 08:30:00	MSFT	Stock	28.02	28.02	27.94	27.94	5475.0
2008-03-31 09:00:00	MSFT	Stock	28.28	28.28	27.79	27.89	123650.0
2008-03-31 09:30:00	MSFT	Stock	27.89	28.36	27.84	28.29	5621743.0
2008-03-31 10:00:00	MSFT	Stock	28.285	28.285	28.125	28.17	2634096.0
2008-03-31 10:30:00	MSFT	Stock	28.16	28.25	28.07	28.24	2070180.0
2008-03-31 11:00:00	MSFT	Stock	28.24	28.26	28.14	28.23	2215133.0
2008-03-31 11:30:00	MSFT	Stock	28.22	28.38	28.22	28.365	2371734.0
2008-03-31 12:00:00	MSFT	Stock	28.37	28.4	28.35	28.39	1193396.0
2008-03-31 12:30:00	MSFT	Stock	28.38	28.47	28.36	28.42	1767274.0
2008-03-31 13:00:00	MSFT	Stock	28.41	28.5	28.4	28.5	2190190.0
2008-03-31 13:30:00	MSFT	Stock	28.5	28.56	28.49	28.5	2469538.0
2008-03-31 14:00:00	MSFT	Stock	28.5	28.59	28.49	28.56	2067089.0
2008-03-31 14:30:00	MSFT	Stock	28.56	28.57	28.36	28.44	2410197.0
2008-03-31 15:00:00	MSFT	Stock	28.43	28.45	28.25	28.31	3595277.0
2008-03-31 15:30:00	MSFT	Stock	28.32	28.44	28.28	28.38	7930760.0
2008-03-31 16:00:00	MSFT	Stock	28.33	28.384	28.16	28.24	4563196.0
2008-03-31 16:30:00	MSFT	Stock	28.23	28.428	28.22	28.22	153070.0
2008-03-31 17:00:00	MSFT	Stock	28.23	28.443	28.22	28.23	135307.0
2008-03-31 17:30:00	MSFT	Stock	28.38	28.381	28.23	28.24	75331.0
2008-03-31 18:00:00	MSFT	Stock	28.24	28.24	28.23	28.24	1400.0
2008-03-31 18:30:00	MSFT	Stock	28.24	28.25	28.24	28.24	11180.0

> showing 50 of 69,093 rows — these rows as CSV

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