PREVIEW / stock_30min / 2010-03-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-19.parquet
  size:    1.5 MB
  rows:    76,536
  symbols: 3,459

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-03-19 06:00:00	AAPL	Stock	7.9896	7.9896	7.9896	7.9896	2800.0
2010-03-19 06:30:00	AAPL	Stock	7.9846	7.9871	7.9846	7.9871	11200.0
2010-03-19 07:00:00	AAPL	Stock	7.9904	8.0	7.985	7.9861	42672.0
2010-03-19 07:30:00	AAPL	Stock	7.9861	7.9911	7.9861	7.9911	11200.0
2010-03-19 08:00:00	AAPL	Stock	7.9975	8.0121	7.9946	8.0082	648620.0
2010-03-19 08:30:00	AAPL	Stock	8.0039	8.0057	7.9957	7.9975	715848.0
2010-03-19 09:00:00	AAPL	Stock	7.9989	8.0339	7.9986	8.0339	3419612.0
2010-03-19 09:30:00	AAPL	Stock	8.0346	8.0443	7.9604	7.9746	70957152.0
2010-03-19 10:00:00	AAPL	Stock	7.9746	7.975	7.9307	7.9375	51166724.0
2010-03-19 10:30:00	AAPL	Stock	7.9375	7.9389	7.9179	7.9275	41715744.0
2010-03-19 11:00:00	AAPL	Stock	7.9284	7.9389	7.915	7.9256	36035944.0
2010-03-19 11:30:00	AAPL	Stock	7.9261	7.9482	7.9179	7.9436	23381680.0
2010-03-19 12:00:00	AAPL	Stock	7.9436	7.9518	7.9293	7.9354	20875540.0
2010-03-19 12:30:00	AAPL	Stock	7.9364	7.9396	7.9286	7.93	13012580.0
2010-03-19 13:00:00	AAPL	Stock	7.9311	7.9379	7.9214	7.9225	15217636.0
2010-03-19 13:30:00	AAPL	Stock	7.9232	7.9393	7.9175	7.9365	19779312.0
2010-03-19 14:00:00	AAPL	Stock	7.9371	7.9446	7.9271	7.9425	19268004.0
2010-03-19 14:30:00	AAPL	Stock	7.9429	7.9429	7.9314	7.9314	13169156.0
2010-03-19 15:00:00	AAPL	Stock	7.9325	7.9404	7.9293	7.9293	16257920.0
2010-03-19 15:30:00	AAPL	Stock	7.9296	7.9389	7.9011	7.9361	72784936.0
2010-03-19 16:00:00	AAPL	Stock	7.9375	7.9592	7.9252	7.9392	35841316.0
2010-03-19 16:30:00	AAPL	Stock	7.912	7.9411	7.912	7.9375	1953644.0
2010-03-19 17:00:00	AAPL	Stock	7.9346	7.9393	7.9343	7.9375	267568.0
2010-03-19 17:30:00	AAPL	Stock	7.9357	7.9357	7.9321	7.9321	71400.0
2010-03-19 18:00:00	AAPL	Stock	7.9311	7.9375	7.925	7.925	126616.0
2010-03-19 18:30:00	AAPL	Stock	7.9243	7.9293	7.9243	7.9257	106820.0
2010-03-19 19:00:00	AAPL	Stock	7.9257	7.9279	7.92	7.9214	214984.0
2010-03-19 19:30:00	AAPL	Stock	7.9221	7.9221	7.9179	7.9214	223300.0
2010-03-19 07:00:00	MSFT	Stock	29.45	29.45	29.41	29.41	2200.0
2010-03-19 07:30:00	MSFT	Stock	29.47	29.51	29.43	29.51	800.0
2010-03-19 08:00:00	MSFT	Stock	29.53	29.59	29.53	29.56	7618.0
2010-03-19 08:30:00	MSFT	Stock	29.55	29.67	29.55	29.65	17721.0
2010-03-19 09:00:00	MSFT	Stock	29.65	29.79	29.62	29.76	461917.0
2010-03-19 09:30:00	MSFT	Stock	29.76	29.9	29.51	29.77	26699285.0
2010-03-19 10:00:00	MSFT	Stock	29.77	29.78	29.538	29.6	4118490.0
2010-03-19 10:30:00	MSFT	Stock	29.59	29.64	29.51	29.61	2803246.0
2010-03-19 11:00:00	MSFT	Stock	29.6	29.62	29.41	29.432	2946142.0
2010-03-19 11:30:00	MSFT	Stock	29.44	29.5	29.39	29.45	2700207.0
2010-03-19 12:00:00	MSFT	Stock	29.44	29.53	29.42	29.44	2297852.0
2010-03-19 12:30:00	MSFT	Stock	29.44	29.47	29.35	29.37	2212058.0
2010-03-19 13:00:00	MSFT	Stock	29.38	29.5	29.36	29.49	2478853.0
2010-03-19 13:30:00	MSFT	Stock	29.48	29.51	29.391	29.495	1888959.0
2010-03-19 14:00:00	MSFT	Stock	29.5	29.59	29.435	29.54	2839126.0
2010-03-19 14:30:00	MSFT	Stock	29.55	29.55	29.456	29.48	1640909.0
2010-03-19 15:00:00	MSFT	Stock	29.488	29.55	29.46	29.46	1953158.0
2010-03-19 15:30:00	MSFT	Stock	29.47	29.6	29.38	29.6	7158460.0
2010-03-19 16:00:00	MSFT	Stock	29.6	29.65	29.415	29.609	13638681.0
2010-03-19 16:30:00	MSFT	Stock	29.423	29.62	29.423	29.61	1260056.0
2010-03-19 17:00:00	MSFT	Stock	29.58	29.61	29.55	29.59	3198.0
2010-03-19 17:30:00	MSFT	Stock	29.6	29.6	29.6	29.6	1618.0

> showing 50 of 76,536 rows — these rows as CSV

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