PREVIEW / stock_30min / 2010-05-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-04.parquet
  size:    1.5 MB
  rows:    78,142
  symbols: 3,488

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-05-04 04:30:00	AAPL	Stock	9.5018	9.5018	9.4911	9.4911	19600.0
2010-05-04 05:30:00	AAPL	Stock	9.4771	9.4793	9.4643	9.4643	33600.0
2010-05-04 06:00:00	AAPL	Stock	9.4679	9.4768	9.4657	9.4768	30800.0
2010-05-04 06:30:00	AAPL	Stock	9.4661	9.4696	9.4539	9.4539	36400.0
2010-05-04 07:00:00	AAPL	Stock	9.4643	9.4732	9.4361	9.4532	103600.0
2010-05-04 07:30:00	AAPL	Stock	9.4386	9.45	9.4068	9.4114	382508.0
2010-05-04 08:00:00	AAPL	Stock	9.4139	9.4193	9.3839	9.4089	2069760.0
2010-05-04 08:30:00	AAPL	Stock	9.4107	9.425	9.4089	9.4143	1365616.0
2010-05-04 09:00:00	AAPL	Stock	9.4168	9.4168	9.3796	9.3929	2179968.0
2010-05-04 09:30:00	AAPL	Stock	9.3932	9.4032	9.2954	9.3264	88709096.0
2010-05-04 10:00:00	AAPL	Stock	9.3293	9.3332	9.2146	9.2179	98233800.0
2010-05-04 10:30:00	AAPL	Stock	9.2179	9.2561	9.1793	9.225	72007992.0
2010-05-04 11:00:00	AAPL	Stock	9.2247	9.2325	9.1696	9.2096	46242448.0
2010-05-04 11:30:00	AAPL	Stock	9.21	9.2675	9.2071	9.2657	38067008.0
2010-05-04 12:00:00	AAPL	Stock	9.2654	9.2675	9.1875	9.1982	62582660.0
2010-05-04 12:30:00	AAPL	Stock	9.1968	9.2467	9.1857	9.2321	33956188.0
2010-05-04 13:00:00	AAPL	Stock	9.2304	9.2718	9.2244	9.2296	33012448.0
2010-05-04 13:30:00	AAPL	Stock	9.2304	9.2821	9.2271	9.2643	31503024.0
2010-05-04 14:00:00	AAPL	Stock	9.2657	9.2664	9.2171	9.2173	26793228.0
2010-05-04 14:30:00	AAPL	Stock	9.2193	9.2471	9.1914	9.2143	33311376.0
2010-05-04 15:00:00	AAPL	Stock	9.2123	9.25	9.1893	9.2318	44347856.0
2010-05-04 15:30:00	AAPL	Stock	9.2318	9.2404	9.1736	9.2379	85102416.0
2010-05-04 16:00:00	AAPL	Stock	9.2296	9.25	9.2148	9.2386	12729108.0
2010-05-04 16:30:00	AAPL	Stock	9.2429	9.5125	9.2108	9.2379	731360.0
2010-05-04 17:00:00	AAPL	Stock	9.2396	9.2439	9.2264	9.2264	240296.0
2010-05-04 17:30:00	AAPL	Stock	9.2257	9.2321	9.2189	9.2214	352576.0
2010-05-04 18:00:00	AAPL	Stock	9.2207	9.2243	9.2179	9.2232	103796.0
2010-05-04 18:30:00	AAPL	Stock	9.2214	9.2214	9.2143	9.2143	114996.0
2010-05-04 19:00:00	AAPL	Stock	9.2175	9.2175	9.2071	9.2071	267848.0
2010-05-04 19:30:00	AAPL	Stock	9.2073	9.22	9.2073	9.2171	420728.0
2010-05-04 04:30:00	MSFT	Stock	30.72	30.72	30.72	30.72	200.0
2010-05-04 05:30:00	MSFT	Stock	30.68	30.68	30.68	30.68	100.0
2010-05-04 07:30:00	MSFT	Stock	30.7	30.7	30.62	30.7	2800.0
2010-05-04 08:00:00	MSFT	Stock	30.74	30.74	30.68	30.68	7327.0
2010-05-04 08:30:00	MSFT	Stock	30.69	30.7	30.68	30.68	12279.0
2010-05-04 09:00:00	MSFT	Stock	30.65	30.69	30.52	30.52	44307.0
2010-05-04 09:30:00	MSFT	Stock	30.52	30.55	30.2	30.41	6835909.0
2010-05-04 10:00:00	MSFT	Stock	30.42	30.45	30.25	30.29	5981241.0
2010-05-04 10:30:00	MSFT	Stock	30.29	30.32	30.1	30.12	8375914.0
2010-05-04 11:00:00	MSFT	Stock	30.11	30.15	29.76	29.84	10355785.0
2010-05-04 11:30:00	MSFT	Stock	29.84	29.97	29.82	29.945	3819920.0
2010-05-04 12:00:00	MSFT	Stock	29.946	29.95	29.75	29.77	5357042.0
2010-05-04 12:30:00	MSFT	Stock	29.78	29.94	29.75	29.908	4104895.0
2010-05-04 13:00:00	MSFT	Stock	29.91	29.96	29.875	29.96	3580143.0
2010-05-04 13:30:00	MSFT	Stock	29.96	30.12	29.95	30.095	3308346.0
2010-05-04 14:00:00	MSFT	Stock	30.093	30.14	30.0	30.008	3745257.0
2010-05-04 14:30:00	MSFT	Stock	30.0	30.03	29.935	29.97	3984502.0
2010-05-04 15:00:00	MSFT	Stock	29.965	30.07	29.93	30.04	6830156.0
2010-05-04 15:30:00	MSFT	Stock	30.035	30.15	29.94	30.11	10132253.0
2010-05-04 16:00:00	MSFT	Stock	30.11	30.22	29.991	30.13	4165858.0

> showing 50 of 78,142 rows — these rows as CSV

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