PREVIEW / stock_30min / 2009-02-23

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-23.parquet
  size:    1.3 MB
  rows:    71,435
  symbols: 3,344

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
2009-02-23 07:00:00	AAPL	Stock	3.2804	3.3071	3.2804	3.3071	17108.0
2009-02-23 07:30:00	AAPL	Stock	3.2829	3.2907	3.2768	3.2768	62636.0
2009-02-23 08:00:00	AAPL	Stock	3.2679	3.2768	3.2593	3.2643	396480.0
2009-02-23 08:30:00	AAPL	Stock	3.2611	3.2854	3.2607	3.2854	779324.0
2009-02-23 09:00:00	AAPL	Stock	3.2854	3.2918	3.2693	3.2775	1202992.0
2009-02-23 09:30:00	AAPL	Stock	3.2732	3.2857	3.1696	3.1736	101409840.0
2009-02-23 10:00:00	AAPL	Stock	3.1745	3.1882	3.1582	3.1764	76092492.0
2009-02-23 10:30:00	AAPL	Stock	3.1771	3.1782	3.15	3.1554	52969868.0
2009-02-23 11:00:00	AAPL	Stock	3.1557	3.1732	3.1482	3.1675	46545492.0
2009-02-23 11:30:00	AAPL	Stock	3.1671	3.1679	3.1418	3.1446	41253912.0
2009-02-23 12:00:00	AAPL	Stock	3.1446	3.1529	3.125	3.1468	38334968.0
2009-02-23 12:30:00	AAPL	Stock	3.1464	3.15	3.1254	3.1264	29706124.0
2009-02-23 13:00:00	AAPL	Stock	3.1261	3.1607	3.1254	3.15	40288696.0
2009-02-23 13:30:00	AAPL	Stock	3.1504	3.1554	3.1336	3.1375	33267304.0
2009-02-23 14:00:00	AAPL	Stock	3.1368	3.1607	3.1232	3.1575	48384448.0
2009-02-23 14:30:00	AAPL	Stock	3.1575	3.1675	3.1107	3.1168	50502732.0
2009-02-23 15:00:00	AAPL	Stock	3.1168	3.1336	3.0989	3.1114	59117184.0
2009-02-23 15:30:00	AAPL	Stock	3.1114	3.1346	3.0896	3.1104	102322948.0
2009-02-23 16:00:00	AAPL	Stock	3.1104	3.1507	3.101	3.1104	18564588.0
2009-02-23 16:30:00	AAPL	Stock	3.1089	3.1143	3.1036	3.1054	3700844.0
2009-02-23 17:00:00	AAPL	Stock	3.1054	3.1177	3.105	3.1107	334908.0
2009-02-23 17:30:00	AAPL	Stock	3.1071	3.1139	3.1057	3.1139	326480.0
2009-02-23 18:00:00	AAPL	Stock	3.1118	3.1121	3.1054	3.1121	31310216.0
2009-02-23 18:30:00	AAPL	Stock	3.1121	3.1121	3.1054	3.1054	2869720.0
2009-02-23 19:00:00	AAPL	Stock	3.1054	3.1079	3.1054	3.1079	68768.0
2009-02-23 19:30:00	AAPL	Stock	3.1096	3.1107	3.1057	3.1071	145096.0
2009-02-23 04:00:00	MSFT	Stock	18.12	18.12	18.12	18.12	100.0
2009-02-23 05:30:00	MSFT	Stock	18.15	18.15	18.15	18.15	700.0
2009-02-23 06:30:00	MSFT	Stock	18.15	18.15	18.15	18.15	400.0
2009-02-23 07:00:00	MSFT	Stock	18.15	18.15	18.15	18.15	1500.0
2009-02-23 07:30:00	MSFT	Stock	18.07	18.07	18.04	18.05	5770.0
2009-02-23 08:00:00	MSFT	Stock	18.06	18.15	18.04	18.1	13847.0
2009-02-23 08:30:00	MSFT	Stock	18.1	18.14	18.1	18.1	29810.0
2009-02-23 09:00:00	MSFT	Stock	18.1	18.16	18.03	18.04	85121.0
2009-02-23 09:30:00	MSFT	Stock	18.04	18.15	17.69	17.712	7279323.0
2009-02-23 10:00:00	MSFT	Stock	17.71	17.72	17.51	17.6	4906174.0
2009-02-23 10:30:00	MSFT	Stock	17.6	17.61	17.47	17.48	3616225.0
2009-02-23 11:00:00	MSFT	Stock	17.48	17.62	17.4	17.59	4764164.0
2009-02-23 11:30:00	MSFT	Stock	17.59	17.59	17.49	17.52	4028371.0
2009-02-23 12:00:00	MSFT	Stock	17.52	17.63	17.49	17.6	2803358.0
2009-02-23 12:30:00	MSFT	Stock	17.6	17.64	17.505	17.53	3741417.0
2009-02-23 13:00:00	MSFT	Stock	17.53	17.65	17.51	17.54	2197797.0
2009-02-23 13:30:00	MSFT	Stock	17.55	17.56	17.48	17.5	3463967.0
2009-02-23 14:00:00	MSFT	Stock	17.51	17.6	17.4	17.59	3673883.0
2009-02-23 14:30:00	MSFT	Stock	17.595	17.61	17.29	17.3	3992321.0
2009-02-23 15:00:00	MSFT	Stock	17.3	17.39	17.22	17.3	5087714.0
2009-02-23 15:30:00	MSFT	Stock	17.3	17.4	17.16	17.23	10965592.0
2009-02-23 16:00:00	MSFT	Stock	17.23	17.509	17.15	17.25	7639579.0
2009-02-23 16:30:00	MSFT	Stock	17.22	17.25	17.2	17.21	892593.0
2009-02-23 17:00:00	MSFT	Stock	17.21	17.492	17.19	17.2	9600.0

> showing 50 of 71,435 rows — these rows as CSV

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