PREVIEW / stock_30min / 2008-11-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-20.parquet
  size:    1.3 MB
  rows:    72,130
  symbols: 3,397

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-11-20 04:00:00	AAPL	Stock	3.0739	3.0739	3.0686	3.0686	5600.0
2008-11-20 04:30:00	AAPL	Stock	3.0361	3.0361	3.0361	3.0361	5600.0
2008-11-20 06:30:00	AAPL	Stock	3.0161	3.0161	3.0161	3.0161	2800.0
2008-11-20 07:00:00	AAPL	Stock	3.0532	3.0921	3.0532	3.0893	101332.0
2008-11-20 07:30:00	AAPL	Stock	3.0929	3.1054	3.0893	3.1054	327600.0
2008-11-20 08:00:00	AAPL	Stock	3.0968	3.1064	3.0875	3.0893	540484.0
2008-11-20 08:30:00	AAPL	Stock	3.0893	3.0893	3.0214	3.0393	2007208.0
2008-11-20 09:00:00	AAPL	Stock	3.0411	3.0464	3.0214	3.0432	2859164.0
2008-11-20 09:30:00	AAPL	Stock	3.0436	3.0679	2.985	3.0	159791464.0
2008-11-20 10:00:00	AAPL	Stock	3.0	3.015	2.8571	2.9911	166804764.0
2008-11-20 10:30:00	AAPL	Stock	2.9904	3.065	2.985	3.0375	171223892.0
2008-11-20 11:00:00	AAPL	Stock	3.0361	3.0557	2.9932	3.0418	143633056.0
2008-11-20 11:30:00	AAPL	Stock	3.0404	3.0529	3.015	3.0196	84277844.0
2008-11-20 12:00:00	AAPL	Stock	3.0193	3.0704	2.9896	3.0621	103032160.0
2008-11-20 12:30:00	AAPL	Stock	3.0621	3.0875	3.0339	3.0407	106264312.0
2008-11-20 13:00:00	AAPL	Stock	3.0407	3.05	2.9829	2.9839	91118104.0
2008-11-20 13:30:00	AAPL	Stock	2.9839	3.0304	2.9618	3.0254	94928960.0
2008-11-20 14:00:00	AAPL	Stock	3.025	3.0346	2.9507	2.9554	88810540.0
2008-11-20 14:30:00	AAPL	Stock	2.9546	2.9807	2.9236	2.9361	111801872.0
2008-11-20 15:00:00	AAPL	Stock	2.9364	2.9564	2.8889	2.9075	135462068.0
2008-11-20 15:30:00	AAPL	Stock	2.9079	2.9454	2.8657	2.875	207648644.0
2008-11-20 16:00:00	AAPL	Stock	2.875	2.9874	2.8657	2.8821	27391784.0
2008-11-20 16:30:00	AAPL	Stock	2.8818	2.9857	2.8746	2.8882	1696184.0
2008-11-20 17:00:00	AAPL	Stock	2.8857	2.8911	2.8754	2.8796	337792.0
2008-11-20 17:30:00	AAPL	Stock	2.8786	2.8786	2.87	2.87	624148.0
2008-11-20 18:00:00	AAPL	Stock	2.87	2.8786	2.8679	2.8786	212212.0
2008-11-20 18:30:00	AAPL	Stock	2.8786	2.8846	2.8761	2.8768	228984.0
2008-11-20 19:00:00	AAPL	Stock	2.8764	2.8807	2.8754	2.8796	311248.0
2008-11-20 19:30:00	AAPL	Stock	2.8761	2.8854	2.8757	2.8854	212324.0
2008-11-20 07:30:00	MSFT	Stock	18.25	18.5	18.22	18.22	1874.0
2008-11-20 08:00:00	MSFT	Stock	18.3	18.4	18.25	18.32	24605.0
2008-11-20 08:30:00	MSFT	Stock	18.33	18.33	18.05	18.06	63820.0
2008-11-20 09:00:00	MSFT	Stock	18.11	18.19	18.08	18.13	129947.0
2008-11-20 09:30:00	MSFT	Stock	18.12	18.55	18.06	18.14	11843096.0
2008-11-20 10:00:00	MSFT	Stock	18.13	18.3	18.0	18.26	11213575.0
2008-11-20 10:30:00	MSFT	Stock	18.26	18.55	18.05	18.54	11060666.0
2008-11-20 11:00:00	MSFT	Stock	18.55	18.84	18.3	18.36	11584286.0
2008-11-20 11:30:00	MSFT	Stock	18.35	18.42	18.2	18.22	5706058.0
2008-11-20 12:00:00	MSFT	Stock	18.21	18.57	18.07	18.552	8150268.0
2008-11-20 12:30:00	MSFT	Stock	18.552	18.73	18.38	18.49	7641123.0
2008-11-20 13:00:00	MSFT	Stock	18.49	18.5	18.15	18.26	7441508.0
2008-11-20 13:30:00	MSFT	Stock	18.26	18.61	18.21	18.58	6903656.0
2008-11-20 14:00:00	MSFT	Stock	18.588	18.64	18.145	18.17	6804861.0
2008-11-20 14:30:00	MSFT	Stock	18.17	18.35	18.08	18.2	6735386.0
2008-11-20 15:00:00	MSFT	Stock	18.19	18.27	17.93	18.03	9749322.0
2008-11-20 15:30:00	MSFT	Stock	18.038	18.12	17.5	17.54	26958213.0
2008-11-20 16:00:00	MSFT	Stock	17.54	18.44	17.52	17.79	5680128.0
2008-11-20 16:30:00	MSFT	Stock	17.77	17.8	17.53	17.75	232893.0
2008-11-20 17:00:00	MSFT	Stock	17.71	18.191	17.516	17.8	22651.0
2008-11-20 17:30:00	MSFT	Stock	17.74	17.74	17.53	17.69	11230.0

> showing 50 of 72,130 rows — these rows as CSV

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