PREVIEW / stock_30min / 2009-07-10

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-10.parquet
  size:    1.2 MB
  rows:    66,888
  symbols: 3,297

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-07-10 07:30:00	AAPL	Stock	4.8696	4.8696	4.8696	4.8696	11200.0
2009-07-10 08:00:00	AAPL	Stock	4.8579	4.8686	4.85	4.8571	533092.0
2009-07-10 08:30:00	AAPL	Stock	4.8607	4.8786	4.8568	4.8664	706468.0
2009-07-10 09:00:00	AAPL	Stock	4.8668	4.8768	4.8661	4.8714	644700.0
2009-07-10 09:30:00	AAPL	Stock	4.8693	4.9589	4.8675	4.9514	103455100.0
2009-07-10 10:00:00	AAPL	Stock	4.95	4.9571	4.9293	4.945	47683272.0
2009-07-10 10:30:00	AAPL	Stock	4.9446	4.9521	4.9225	4.9434	28167300.0
2009-07-10 11:00:00	AAPL	Stock	4.9429	4.9493	4.9075	4.9143	36358560.0
2009-07-10 11:30:00	AAPL	Stock	4.9143	4.9346	4.9007	4.9218	22737652.0
2009-07-10 12:00:00	AAPL	Stock	4.9218	4.9357	4.9186	4.93	14103488.0
2009-07-10 12:30:00	AAPL	Stock	4.93	4.9436	4.9221	4.9393	16264976.0
2009-07-10 13:00:00	AAPL	Stock	4.9393	4.9496	4.9371	4.9389	15197728.0
2009-07-10 13:30:00	AAPL	Stock	4.9389	4.9614	4.9382	4.9593	18271204.0
2009-07-10 14:00:00	AAPL	Stock	4.9585	4.9607	4.9321	4.9425	19681116.0
2009-07-10 14:30:00	AAPL	Stock	4.9425	4.9489	4.9346	4.9379	22268932.0
2009-07-10 15:00:00	AAPL	Stock	4.9379	4.9554	4.9357	4.9414	26775056.0
2009-07-10 15:30:00	AAPL	Stock	4.9418	4.9632	4.9375	4.9461	50770524.0
2009-07-10 16:00:00	AAPL	Stock	4.9461	4.9571	4.9221	4.9521	9308180.0
2009-07-10 16:30:00	AAPL	Stock	4.9525	4.9525	4.9471	4.9471	357168.0
2009-07-10 17:00:00	AAPL	Stock	4.9507	4.9518	4.9429	4.9464	367164.0
2009-07-10 17:30:00	AAPL	Stock	4.9457	4.9464	4.9429	4.9464	177296.0
2009-07-10 18:00:00	AAPL	Stock	4.9411	4.9482	4.9393	4.9393	749784.0
2009-07-10 18:30:00	AAPL	Stock	4.94	4.9454	4.9393	4.9393	39200.0
2009-07-10 19:00:00	AAPL	Stock	4.9393	4.9429	4.9393	4.9429	170100.0
2009-07-10 19:30:00	AAPL	Stock	4.9393	4.9429	4.9393	4.9404	51688.0
2009-07-10 07:00:00	MSFT	Stock	22.2	22.2	22.2	22.2	400.0
2009-07-10 08:00:00	MSFT	Stock	22.29	22.29	22.2	22.25	6944.0
2009-07-10 08:30:00	MSFT	Stock	22.25	22.3	22.25	22.25	3300.0
2009-07-10 09:00:00	MSFT	Stock	22.3	22.3	22.15	22.22	69615.0
2009-07-10 09:30:00	MSFT	Stock	22.2	22.45	22.15	22.41	8302179.0
2009-07-10 10:00:00	MSFT	Stock	22.41	22.54	22.32	22.53	3948789.0
2009-07-10 10:30:00	MSFT	Stock	22.54	22.54	22.36	22.37	2278184.0
2009-07-10 11:00:00	MSFT	Stock	22.36	22.37	22.19	22.202	3276702.0
2009-07-10 11:30:00	MSFT	Stock	22.21	22.3	22.16	22.258	3405766.0
2009-07-10 12:00:00	MSFT	Stock	22.25	22.35	22.23	22.318	1865029.0
2009-07-10 12:30:00	MSFT	Stock	22.32	22.36	22.28	22.33	1729830.0
2009-07-10 13:00:00	MSFT	Stock	22.33	22.345	22.27	22.3	2103670.0
2009-07-10 13:30:00	MSFT	Stock	22.31	22.41	22.31	22.39	1514992.0
2009-07-10 14:00:00	MSFT	Stock	22.38	22.39	22.29	22.34	1695056.0
2009-07-10 14:30:00	MSFT	Stock	22.33	22.38	22.285	22.33	2140955.0
2009-07-10 15:00:00	MSFT	Stock	22.32	22.4	22.31	22.38	2281049.0
2009-07-10 15:30:00	MSFT	Stock	22.39	22.47	22.35	22.39	5008587.0
2009-07-10 16:00:00	MSFT	Stock	22.39	22.43	22.21	22.43	1859484.0
2009-07-10 16:30:00	MSFT	Stock	22.36	22.39	22.36	22.39	104977.0
2009-07-10 17:00:00	MSFT	Stock	22.42	22.42	22.42	22.42	400.0
2009-07-10 17:30:00	MSFT	Stock	22.39	22.41	22.34	22.34	4700.0
2009-07-10 18:00:00	MSFT	Stock	22.39	22.39	22.39	22.39	737.0
2009-07-10 18:30:00	MSFT	Stock	22.37	22.37	22.32	22.32	400.0
2009-07-10 19:00:00	MSFT	Stock	22.32	22.32	22.32	22.32	1900.0
2009-07-10 19:30:00	MSFT	Stock	22.36	22.38	22.32	22.38	1829.0

> showing 50 of 66,888 rows — these rows as CSV

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