PREVIEW / stock_30min / 2009-03-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-09.parquet
  size:    1.2 MB
  rows:    70,546
  symbols: 3,340

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-03-09 07:00:00	AAPL	Stock	2.995	3.0	2.995	3.0	56000.0
2009-03-09 07:30:00	AAPL	Stock	3.0146	3.0146	3.0	3.0	16800.0
2009-03-09 08:00:00	AAPL	Stock	3.0	3.015	3.0	3.0089	149604.0
2009-03-09 08:30:00	AAPL	Stock	3.0054	3.0143	3.0054	3.0118	114072.0
2009-03-09 09:00:00	AAPL	Stock	3.0129	3.0193	3.0036	3.0061	1383760.0
2009-03-09 09:30:00	AAPL	Stock	3.0064	3.1071	3.0	3.0793	86263156.0
2009-03-09 10:00:00	AAPL	Stock	3.079	3.1286	3.0779	3.0779	65474752.0
2009-03-09 10:30:00	AAPL	Stock	3.0782	3.0986	3.0121	3.0175	68595100.0
2009-03-09 11:00:00	AAPL	Stock	3.0179	3.0457	3.0089	3.0361	54987492.0
2009-03-09 11:30:00	AAPL	Stock	3.0361	3.0443	3.0086	3.0254	34845020.0
2009-03-09 12:00:00	AAPL	Stock	3.025	3.0489	3.0114	3.0304	32605580.0
2009-03-09 12:30:00	AAPL	Stock	3.0307	3.0321	2.9914	2.9925	35558796.0
2009-03-09 13:00:00	AAPL	Stock	2.9922	2.9922	2.9654	2.9804	38790640.0
2009-03-09 13:30:00	AAPL	Stock	2.9804	2.9968	2.9786	2.9843	25939088.0
2009-03-09 14:00:00	AAPL	Stock	2.9843	3.0079	2.9714	2.9793	35660968.0
2009-03-09 14:30:00	AAPL	Stock	2.9789	2.9921	2.9579	2.9668	53361784.0
2009-03-09 15:00:00	AAPL	Stock	2.9664	2.9821	2.9489	2.9632	53420640.0
2009-03-09 15:30:00	AAPL	Stock	2.9646	2.9779	2.9504	2.9696	74931416.0
2009-03-09 16:00:00	AAPL	Stock	2.9693	3.02	2.9607	2.9618	13549956.0
2009-03-09 16:30:00	AAPL	Stock	2.9618	3.0191	2.9582	2.9675	574896.0
2009-03-09 17:00:00	AAPL	Stock	2.9654	2.9696	2.9643	2.9696	344848.0
2009-03-09 17:30:00	AAPL	Stock	2.9679	2.9707	2.9661	2.9671	7045780.0
2009-03-09 18:00:00	AAPL	Stock	2.9693	2.9693	2.9661	2.9693	571592.0
2009-03-09 18:30:00	AAPL	Stock	2.9661	2.9693	2.9661	2.9661	41748.0
2009-03-09 19:00:00	AAPL	Stock	2.9643	2.9661	2.9643	2.9661	37408.0
2009-03-09 19:30:00	AAPL	Stock	2.9689	2.9693	2.9643	2.9686	95928.0
2009-03-09 07:30:00	MSFT	Stock	15.27	15.28	15.25	15.25	4600.0
2009-03-09 08:00:00	MSFT	Stock	15.3	15.3	15.15	15.17	11300.0
2009-03-09 08:30:00	MSFT	Stock	15.15	15.18	15.15	15.15	13900.0
2009-03-09 09:00:00	MSFT	Stock	15.15	15.3	15.15	15.15	42587.0
2009-03-09 09:30:00	MSFT	Stock	15.2	15.74	15.2	15.46	8852411.0
2009-03-09 10:00:00	MSFT	Stock	15.462	15.7	15.45	15.525	6591282.0
2009-03-09 10:30:00	MSFT	Stock	15.53	15.58	15.24	15.29	5319146.0
2009-03-09 11:00:00	MSFT	Stock	15.28	15.44	15.28	15.325	4891741.0
2009-03-09 11:30:00	MSFT	Stock	15.32	15.41	15.26	15.35	3033017.0
2009-03-09 12:00:00	MSFT	Stock	15.34	15.44	15.3	15.41	2656743.0
2009-03-09 12:30:00	MSFT	Stock	15.41	15.42	15.28	15.33	2261445.0
2009-03-09 13:00:00	MSFT	Stock	15.33	15.335	15.1	15.16	3798422.0
2009-03-09 13:30:00	MSFT	Stock	15.16	15.26	15.15	15.19	2642149.0
2009-03-09 14:00:00	MSFT	Stock	15.2	15.34	15.17	15.235	3458537.0
2009-03-09 14:30:00	MSFT	Stock	15.24	15.3	15.15	15.22	3430075.0
2009-03-09 15:00:00	MSFT	Stock	15.22	15.384	15.12	15.18	7094849.0
2009-03-09 15:30:00	MSFT	Stock	15.18	15.24	15.11	15.15	8014082.0
2009-03-09 16:00:00	MSFT	Stock	15.15	15.7	15.15	15.16	1949153.0
2009-03-09 16:30:00	MSFT	Stock	15.15	15.16	15.11	15.15	74675.0
2009-03-09 17:00:00	MSFT	Stock	15.15	15.15	15.14	15.14	86792.0
2009-03-09 17:30:00	MSFT	Stock	15.14	15.15	15.13	15.14	2896.0
2009-03-09 18:00:00	MSFT	Stock	15.13	15.15	15.13	15.13	28238.0
2009-03-09 18:30:00	MSFT	Stock	15.14	15.15	15.13	15.13	6133.0
2009-03-09 19:00:00	MSFT	Stock	15.13	15.13	15.1	15.11	11128.0

> showing 50 of 70,546 rows — these rows as CSV

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