PREVIEW / stock_30min / 2010-05-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-24.parquet
  size:    1.4 MB
  rows:    74,024
  symbols: 3,444

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-24 04:00:00	AAPL	Stock	8.6889	8.6896	8.6889	8.6896	30800.0
2010-05-24 05:00:00	AAPL	Stock	8.6786	8.6786	8.6429	8.6429	44800.0
2010-05-24 05:30:00	AAPL	Stock	8.6429	8.6429	8.6429	8.6429	3612.0
2010-05-24 06:00:00	AAPL	Stock	8.6429	8.6429	8.6164	8.6164	39200.0
2010-05-24 06:30:00	AAPL	Stock	8.6104	8.6304	8.5986	8.5986	126336.0
2010-05-24 07:00:00	AAPL	Stock	8.5807	8.6429	8.5807	8.64	633696.0
2010-05-24 07:30:00	AAPL	Stock	8.64	8.7043	8.64	8.6914	980980.0
2010-05-24 08:00:00	AAPL	Stock	8.6843	8.7239	8.6632	8.6925	2984380.0
2010-05-24 08:30:00	AAPL	Stock	8.69	8.8264	8.6868	8.8071	5595660.0
2010-05-24 09:00:00	AAPL	Stock	8.8093	8.8654	8.8036	8.8304	6231260.0
2010-05-24 09:30:00	AAPL	Stock	8.8275	8.9107	8.795	8.865	137370464.0
2010-05-24 10:00:00	AAPL	Stock	8.8671	8.9211	8.8393	8.9189	90441736.0
2010-05-24 10:30:00	AAPL	Stock	8.9161	8.9443	8.8439	8.9132	73472868.0
2010-05-24 11:00:00	AAPL	Stock	8.9136	8.9339	8.8707	8.8979	48422192.0
2010-05-24 11:30:00	AAPL	Stock	8.8984	8.9246	8.885	8.9129	30735264.0
2010-05-24 12:00:00	AAPL	Stock	8.9118	8.9375	8.9032	8.9274	31553228.0
2010-05-24 12:30:00	AAPL	Stock	8.9296	8.9552	8.9171	8.9529	33783652.0
2010-05-24 13:00:00	AAPL	Stock	8.9529	8.9607	8.9296	8.9486	31140984.0
2010-05-24 13:30:00	AAPL	Stock	8.9468	8.9561	8.9164	8.9286	33248796.0
2010-05-24 14:00:00	AAPL	Stock	8.9296	8.95	8.9164	8.9414	33537504.0
2010-05-24 14:30:00	AAPL	Stock	8.9425	8.9518	8.9196	8.9375	33717208.0
2010-05-24 15:00:00	AAPL	Stock	8.9375	8.9446	8.8754	8.9018	52753064.0
2010-05-24 15:30:00	AAPL	Stock	8.9007	8.9243	8.8114	8.8125	87157924.0
2010-05-24 16:00:00	AAPL	Stock	8.8171	8.9404	8.8046	8.8107	9384816.0
2010-05-24 16:30:00	AAPL	Stock	8.8071	8.9026	8.7925	8.8032	774032.0
2010-05-24 17:00:00	AAPL	Stock	8.8068	8.8086	8.7393	8.7432	1049048.0
2010-05-24 17:30:00	AAPL	Stock	8.7429	8.7779	8.7393	8.7589	686140.0
2010-05-24 18:00:00	AAPL	Stock	8.7589	8.8129	8.7536	8.7536	201600.0
2010-05-24 18:30:00	AAPL	Stock	8.7589	8.7607	8.7521	8.7536	194292.0
2010-05-24 19:00:00	AAPL	Stock	8.7557	8.7611	8.7518	8.7571	191996.0
2010-05-24 19:30:00	AAPL	Stock	8.7554	8.7607	8.75	8.7504	285768.0
2010-05-24 20:00:00	AAPL	Stock	8.9261	8.9261	8.9261	8.9261	2800.0
2010-05-24 07:30:00	MSFT	Stock	26.78	26.79	26.78	26.79	1500.0
2010-05-24 08:00:00	MSFT	Stock	26.75	26.907	26.7	26.71	12918.0
2010-05-24 08:30:00	MSFT	Stock	26.75	26.83	26.7	26.78	15087.0
2010-05-24 09:00:00	MSFT	Stock	26.78	26.97	26.78	26.85	45916.0
2010-05-24 09:30:00	MSFT	Stock	26.85	26.87	26.59	26.705	5831096.0
2010-05-24 10:00:00	MSFT	Stock	26.72	26.82	26.59	26.8	4352693.0
2010-05-24 10:30:00	MSFT	Stock	26.8	26.8	26.57	26.595	5201491.0
2010-05-24 11:00:00	MSFT	Stock	26.595	26.8	26.356	26.565	5046837.0
2010-05-24 11:30:00	MSFT	Stock	26.57	26.62	26.54	26.58	4361761.0
2010-05-24 12:00:00	MSFT	Stock	26.58	26.66	26.54	26.605	4387263.0
2010-05-24 12:30:00	MSFT	Stock	26.601	26.65	26.57	26.6	4259451.0
2010-05-24 13:00:00	MSFT	Stock	26.595	26.62	26.54	26.59	3248061.0
2010-05-24 13:30:00	MSFT	Stock	26.592	26.62	26.54	26.571	2546956.0
2010-05-24 14:00:00	MSFT	Stock	26.579	26.61	26.54	26.58	2953093.0
2010-05-24 14:30:00	MSFT	Stock	26.58	26.6	26.52	26.58	3050368.0
2010-05-24 15:00:00	MSFT	Stock	26.58	26.59	26.39	26.395	6687648.0
2010-05-24 15:30:00	MSFT	Stock	26.395	26.48	26.26	26.33	16963681.0
2010-05-24 16:00:00	MSFT	Stock	26.33	26.629	26.25	26.3	3043952.0

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

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