PREVIEW / stock_30min / 2010-08-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-23.parquet
  size:    1.4 MB
  rows:    74,820
  symbols: 3,463

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-08-23 06:30:00	AAPL	Stock	8.9446	8.9464	8.9446	8.9464	11200.0
2010-08-23 07:00:00	AAPL	Stock	8.9518	8.9732	8.9518	8.9589	67480.0
2010-08-23 07:30:00	AAPL	Stock	8.9589	8.9893	8.9571	8.9818	181720.0
2010-08-23 08:00:00	AAPL	Stock	8.9732	8.9836	8.9536	8.9732	1088388.0
2010-08-23 08:30:00	AAPL	Stock	8.975	8.9875	8.9714	8.9821	1246588.0
2010-08-23 09:00:00	AAPL	Stock	8.9821	8.9957	8.9711	8.9925	1745940.0
2010-08-23 09:30:00	AAPL	Stock	8.9925	9.0	8.9564	8.9586	43641248.0
2010-08-23 10:00:00	AAPL	Stock	8.9568	8.9586	8.8625	8.8775	53066412.0
2010-08-23 10:30:00	AAPL	Stock	8.8771	8.9107	8.8464	8.8596	40603360.0
2010-08-23 11:00:00	AAPL	Stock	8.8596	8.8607	8.8268	8.8343	30937620.0
2010-08-23 11:30:00	AAPL	Stock	8.8339	8.8621	8.8311	8.8414	19297908.0
2010-08-23 12:00:00	AAPL	Stock	8.8418	8.8654	8.8393	8.8554	14961576.0
2010-08-23 12:30:00	AAPL	Stock	8.8561	8.8607	8.8339	8.8357	11269188.0
2010-08-23 13:00:00	AAPL	Stock	8.8339	8.8439	8.8132	8.8342	21611016.0
2010-08-23 13:30:00	AAPL	Stock	8.8339	8.8375	8.8093	8.8232	17066000.0
2010-08-23 14:00:00	AAPL	Stock	8.8249	8.8375	8.8071	8.8089	23020732.0
2010-08-23 14:30:00	AAPL	Stock	8.8086	8.8311	8.8054	8.8076	18717160.0
2010-08-23 15:00:00	AAPL	Stock	8.8075	8.8196	8.7868	8.7904	34412784.0
2010-08-23 15:30:00	AAPL	Stock	8.7896	8.7929	8.7589	8.7786	59636164.0
2010-08-23 16:00:00	AAPL	Stock	8.7786	8.9982	8.7721	8.7818	14486808.0
2010-08-23 16:30:00	AAPL	Stock	8.7804	8.793	8.7793	8.7804	284956.0
2010-08-23 17:00:00	AAPL	Stock	8.7789	8.7804	8.7754	8.7754	1546804.0
2010-08-23 17:30:00	AAPL	Stock	8.7754	8.7754	8.7611	8.77	169540.0
2010-08-23 18:00:00	AAPL	Stock	8.77	8.7786	8.7664	8.7704	264544.0
2010-08-23 18:30:00	AAPL	Stock	8.7714	8.7725	8.7664	8.7668	107016.0
2010-08-23 19:00:00	AAPL	Stock	8.7671	8.7707	8.7654	8.7654	108948.0
2010-08-23 19:30:00	AAPL	Stock	8.7654	8.7696	8.7607	8.7639	244104.0
2010-08-23 08:00:00	MSFT	Stock	24.31	24.38	24.3	24.35	5525.0
2010-08-23 08:30:00	MSFT	Stock	24.35	24.35	24.31	24.35	8154.0
2010-08-23 09:00:00	MSFT	Stock	24.33	24.44	24.31	24.43	37761.0
2010-08-23 09:30:00	MSFT	Stock	24.44	24.64	24.35	24.62	5878519.0
2010-08-23 10:00:00	MSFT	Stock	24.615	24.62	24.38	24.4	5722911.0
2010-08-23 10:30:00	MSFT	Stock	24.41	24.41	24.27	24.31	5112727.0
2010-08-23 11:00:00	MSFT	Stock	24.315	24.36	24.27	24.295	3124274.0
2010-08-23 11:30:00	MSFT	Stock	24.29	24.33	24.28	24.32	2570206.0
2010-08-23 12:00:00	MSFT	Stock	24.31	24.37	24.305	24.34	1880037.0
2010-08-23 12:30:00	MSFT	Stock	24.35	24.38	24.28	24.285	1411652.0
2010-08-23 13:00:00	MSFT	Stock	24.28	24.35	24.24	24.35	2296195.0
2010-08-23 13:30:00	MSFT	Stock	24.355	24.42	24.35	24.4	3373073.0
2010-08-23 14:00:00	MSFT	Stock	24.4	24.54	24.395	24.47	3073604.0
2010-08-23 14:30:00	MSFT	Stock	24.475	24.54	24.47	24.48	1551903.0
2010-08-23 15:00:00	MSFT	Stock	24.48	24.5	24.35	24.36	3502276.0
2010-08-23 15:30:00	MSFT	Stock	24.36	24.5	24.26	24.28	8612874.0
2010-08-23 16:00:00	MSFT	Stock	24.28	24.398	24.21	24.22	2649839.0
2010-08-23 16:30:00	MSFT	Stock	24.351	24.351	24.23	24.24	35600.0
2010-08-23 17:00:00	MSFT	Stock	24.22	24.28	24.2	24.28	127981.0
2010-08-23 17:30:00	MSFT	Stock	24.25	24.25	24.24	24.24	3000.0
2010-08-23 18:00:00	MSFT	Stock	24.24	24.28	24.2	24.28	23668.0
2010-08-23 18:30:00	MSFT	Stock	24.24	24.24	24.24	24.24	500.0
2010-08-23 19:00:00	MSFT	Stock	24.18	24.25	24.18	24.25	1000.0

> showing 50 of 74,820 rows — these rows as CSV

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