PREVIEW / stock_30min / 2010-03-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-23.parquet
  size:    1.4 MB
  rows:    73,440
  symbols: 3,474

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-03-23 07:00:00	AAPL	Stock	8.0454	8.0454	8.0454	8.0454	12600.0
2010-03-23 07:30:00	AAPL	Stock	8.0368	8.0464	8.0321	8.0411	201600.0
2010-03-23 08:00:00	AAPL	Stock	8.0414	8.0621	8.0368	8.0546	986216.0
2010-03-23 08:30:00	AAPL	Stock	8.0536	8.055	8.0446	8.0504	536732.0
2010-03-23 09:00:00	AAPL	Stock	8.0504	8.0729	8.0504	8.0571	1556884.0
2010-03-23 09:30:00	AAPL	Stock	8.0546	8.075	8.03	8.0557	64604848.0
2010-03-23 10:00:00	AAPL	Stock	8.0557	8.0743	8.0368	8.0575	53708984.0
2010-03-23 10:30:00	AAPL	Stock	8.0589	8.0689	8.0232	8.0289	34628608.0
2010-03-23 11:00:00	AAPL	Stock	8.0289	8.0468	8.0036	8.0311	35608216.0
2010-03-23 11:30:00	AAPL	Stock	8.0318	8.0443	8.0289	8.0432	15449252.0
2010-03-23 12:00:00	AAPL	Stock	8.0432	8.0579	8.0407	8.0525	15659644.0
2010-03-23 12:30:00	AAPL	Stock	8.0532	8.0643	8.0464	8.0632	14766612.0
2010-03-23 13:00:00	AAPL	Stock	8.0629	8.0993	8.0589	8.0929	36996540.0
2010-03-23 13:30:00	AAPL	Stock	8.0925	8.0929	8.0721	8.0764	25285652.0
2010-03-23 14:00:00	AAPL	Stock	8.0768	8.1382	8.0757	8.1368	52027528.0
2010-03-23 14:30:00	AAPL	Stock	8.1376	8.1493	8.1218	8.145	57698704.0
2010-03-23 15:00:00	AAPL	Stock	8.1457	8.1707	8.1393	8.1582	64319528.0
2010-03-23 15:30:00	AAPL	Stock	8.1582	8.1661	8.1454	8.1568	58610580.0
2010-03-23 16:00:00	AAPL	Stock	8.1571	8.1607	8.092	8.1529	7924812.0
2010-03-23 16:30:00	AAPL	Stock	8.158	8.158	8.15	8.1514	410256.0
2010-03-23 17:00:00	AAPL	Stock	8.1514	8.1601	8.15	8.1536	206360.0
2010-03-23 17:30:00	AAPL	Stock	8.1518	8.1529	8.1486	8.1486	99680.0
2010-03-23 18:00:00	AAPL	Stock	8.1486	8.1593	8.1486	8.1521	278236.0
2010-03-23 18:30:00	AAPL	Stock	8.1543	8.1586	8.1543	8.1557	175168.0
2010-03-23 19:00:00	AAPL	Stock	8.1571	8.1582	8.1536	8.1536	125748.0
2010-03-23 19:30:00	AAPL	Stock	8.1536	8.1571	8.1486	8.1489	196756.0
2010-03-23 07:30:00	MSFT	Stock	29.61	29.61	29.61	29.61	114.0
2010-03-23 08:00:00	MSFT	Stock	29.6	29.6	29.57	29.57	1148.0
2010-03-23 08:30:00	MSFT	Stock	29.63	29.63	29.63	29.63	100.0
2010-03-23 09:00:00	MSFT	Stock	29.63	29.63	29.57	29.57	7955.0
2010-03-23 09:30:00	MSFT	Stock	29.59	29.67	29.41	29.56	4078332.0
2010-03-23 10:00:00	MSFT	Stock	29.56	29.7	29.46	29.69	3457531.0
2010-03-23 10:30:00	MSFT	Stock	29.69	29.74	29.57	29.608	3327820.0
2010-03-23 11:00:00	MSFT	Stock	29.6	29.67	29.53	29.67	2661400.0
2010-03-23 11:30:00	MSFT	Stock	29.662	29.76	29.66	29.72	2900375.0
2010-03-23 12:00:00	MSFT	Stock	29.72	29.78	29.7	29.76	1708966.0
2010-03-23 12:30:00	MSFT	Stock	29.755	29.775	29.7	29.77	1129355.0
2010-03-23 13:00:00	MSFT	Stock	29.77	29.81	29.75	29.81	1544949.0
2010-03-23 13:30:00	MSFT	Stock	29.81	29.81	29.71	29.715	1536797.0
2010-03-23 14:00:00	MSFT	Stock	29.71	29.78	29.7	29.74	2377819.0
2010-03-23 14:30:00	MSFT	Stock	29.736	29.74	29.68	29.73	1797907.0
2010-03-23 15:00:00	MSFT	Stock	29.727	29.88	29.7	29.87	3333450.0
2010-03-23 15:30:00	MSFT	Stock	29.868	29.9	29.81	29.85	6074667.0
2010-03-23 16:00:00	MSFT	Stock	29.87	29.91	29.59	29.89	3659610.0
2010-03-23 16:30:00	MSFT	Stock	29.853	29.92	29.853	29.9	40900.0
2010-03-23 17:00:00	MSFT	Stock	29.9	29.9	29.89	29.9	11100.0
2010-03-23 17:30:00	MSFT	Stock	29.9	29.95	29.9	29.9	5327.0
2010-03-23 18:00:00	MSFT	Stock	29.88	29.93	29.88	29.93	62550.0
2010-03-23 18:30:00	MSFT	Stock	29.94	29.97	29.94	29.96	8676.0
2010-03-23 19:00:00	MSFT	Stock	29.96	29.97	29.94	29.94	2300.0

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

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