PREVIEW / stock_30min / 2010-10-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-29.parquet
  size:    1.4 MB
  rows:    72,972
  symbols: 3,492

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-10-29 05:00:00	AAPL	Stock	10.8414	10.8661	10.8368	10.8368	9800.0
2010-10-29 05:30:00	AAPL	Stock	10.8586	10.8586	10.8489	10.8489	5600.0
2010-10-29 06:00:00	AAPL	Stock	10.8371	10.8371	10.8371	10.8371	2800.0
2010-10-29 06:30:00	AAPL	Stock	10.8468	10.8571	10.8468	10.8571	11200.0
2010-10-29 07:00:00	AAPL	Stock	10.8464	10.8496	10.8396	10.8396	14000.0
2010-10-29 07:30:00	AAPL	Stock	10.8393	10.86	10.8393	10.86	49980.0
2010-10-29 08:00:00	AAPL	Stock	10.8629	10.8918	10.85	10.8779	1117032.0
2010-10-29 08:30:00	AAPL	Stock	10.8779	10.9071	10.8646	10.9018	1467200.0
2010-10-29 09:00:00	AAPL	Stock	10.9018	10.9079	10.865	10.8654	985292.0
2010-10-29 09:30:00	AAPL	Stock	10.8654	10.9243	10.8571	10.872	44577176.0
2010-10-29 10:00:00	AAPL	Stock	10.8718	10.9036	10.8668	10.8814	26384876.0
2010-10-29 10:30:00	AAPL	Stock	10.8829	10.8832	10.8086	10.8393	32985680.0
2010-10-29 11:00:00	AAPL	Stock	10.8368	10.8439	10.8054	10.8055	21471688.0
2010-10-29 11:30:00	AAPL	Stock	10.8054	10.8121	10.7857	10.8057	28963480.0
2010-10-29 12:00:00	AAPL	Stock	10.8057	10.8525	10.8057	10.8457	21054460.0
2010-10-29 12:30:00	AAPL	Stock	10.8436	10.8804	10.8429	10.8441	23302328.0
2010-10-29 13:00:00	AAPL	Stock	10.845	10.845	10.7986	10.825	25230940.0
2010-10-29 13:30:00	AAPL	Stock	10.8257	10.8311	10.795	10.8207	23545144.0
2010-10-29 14:00:00	AAPL	Stock	10.8203	10.8268	10.8079	10.8107	14212324.0
2010-10-29 14:30:00	AAPL	Stock	10.8111	10.8114	10.7864	10.7904	20541584.0
2010-10-29 15:00:00	AAPL	Stock	10.7897	10.8032	10.7679	10.7981	30517144.0
2010-10-29 15:30:00	AAPL	Stock	10.7989	10.8125	10.7457	10.7457	74590152.0
2010-10-29 16:00:00	AAPL	Stock	10.7457	10.9014	10.7196	10.735	25951268.0
2010-10-29 16:30:00	AAPL	Stock	10.7339	10.7999	10.7236	10.7268	1307376.0
2010-10-29 17:00:00	AAPL	Stock	10.7282	10.73	10.7218	10.73	371056.0
2010-10-29 17:30:00	AAPL	Stock	10.73	10.7321	10.7168	10.7168	532700.0
2010-10-29 18:00:00	AAPL	Stock	10.7189	10.7639	10.7171	10.7589	2593108.0
2010-10-29 18:30:00	AAPL	Stock	10.7607	10.7607	10.7321	10.7339	669200.0
2010-10-29 19:00:00	AAPL	Stock	10.7321	10.7361	10.7236	10.7236	310968.0
2010-10-29 19:30:00	AAPL	Stock	10.7257	10.75	10.7239	10.7443	492156.0
2010-10-29 04:00:00	MSFT	Stock	27.01	27.01	26.95	26.97	2400.0
2010-10-29 05:00:00	MSFT	Stock	27.05	27.05	27.04	27.04	1800.0
2010-10-29 05:30:00	MSFT	Stock	27.04	27.06	26.99	27.0	4500.0
2010-10-29 06:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	200.0
2010-10-29 06:30:00	MSFT	Stock	27.05	27.23	27.05	27.23	8100.0
2010-10-29 07:00:00	MSFT	Stock	27.15	27.23	27.01	27.01	80060.0
2010-10-29 07:30:00	MSFT	Stock	27.02	27.13	26.75	27.09	324378.0
2010-10-29 08:00:00	MSFT	Stock	27.1	27.13	26.97	27.05	947077.0
2010-10-29 08:30:00	MSFT	Stock	27.05	27.22	27.04	27.21	690884.0
2010-10-29 09:00:00	MSFT	Stock	27.21	27.3	27.07	27.15	2508423.0
2010-10-29 09:30:00	MSFT	Stock	27.15	27.2	26.64	26.729	29066998.0
2010-10-29 10:00:00	MSFT	Stock	26.725	26.81	26.63	26.639	9378739.0
2010-10-29 10:30:00	MSFT	Stock	26.63	26.635	26.48	26.59	10086967.0
2010-10-29 11:00:00	MSFT	Stock	26.582	26.75	26.55	26.73	5062654.0
2010-10-29 11:30:00	MSFT	Stock	26.73	26.75	26.61	26.721	4666912.0
2010-10-29 12:00:00	MSFT	Stock	26.728	26.84	26.71	26.74	4313547.0
2010-10-29 12:30:00	MSFT	Stock	26.74	26.88	26.71	26.86	3908814.0
2010-10-29 13:00:00	MSFT	Stock	26.86	26.86	26.71	26.78	4128501.0
2010-10-29 13:30:00	MSFT	Stock	26.78	26.96	26.71	26.96	5062865.0
2010-10-29 14:00:00	MSFT	Stock	26.96	26.96	26.84	26.87	4344525.0

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

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