PREVIEW / stock_30min / 2014-04-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-15.parquet
  size:    1.6 MB
  rows:    82,019
  symbols: 3,545

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
2014-04-15 07:00:00	AAPL	Stock	18.6661	18.6786	18.6661	18.6786	33432.0
2014-04-15 07:30:00	AAPL	Stock	18.6571	18.6607	18.65	18.6607	11200.0
2014-04-15 08:00:00	AAPL	Stock	18.6518	18.6693	18.6446	18.6536	130592.0
2014-04-15 08:30:00	AAPL	Stock	18.6464	18.6464	18.5932	18.5968	255276.0
2014-04-15 09:00:00	AAPL	Stock	18.5964	18.5982	18.5561	18.5679	399672.0
2014-04-15 09:30:00	AAPL	Stock	18.5811	18.63	18.5215	18.5846	21589680.0
2014-04-15 10:00:00	AAPL	Stock	18.5839	18.6139	18.4721	18.4986	20184388.0
2014-04-15 10:30:00	AAPL	Stock	18.4961	18.5161	18.3704	18.3811	24684968.0
2014-04-15 11:00:00	AAPL	Stock	18.3771	18.4375	18.3571	18.4096	14069384.0
2014-04-15 11:30:00	AAPL	Stock	18.4135	18.45	18.3575	18.3575	12643232.0
2014-04-15 12:00:00	AAPL	Stock	18.3632	18.3757	18.304	18.3093	16200044.0
2014-04-15 12:30:00	AAPL	Stock	18.3111	18.3568	18.2975	18.2986	10127656.0
2014-04-15 13:00:00	AAPL	Stock	18.2971	18.3661	18.2618	18.3632	14443380.0
2014-04-15 13:30:00	AAPL	Stock	18.3618	18.4232	18.3529	18.4179	11420164.0
2014-04-15 14:00:00	AAPL	Stock	18.4189	18.4607	18.3975	18.4207	10226944.0
2014-04-15 14:30:00	AAPL	Stock	18.4204	18.5193	18.4143	18.4925	12035968.0
2014-04-15 15:00:00	AAPL	Stock	18.4907	18.5254	18.4471	18.5175	10076276.0
2014-04-15 15:30:00	AAPL	Stock	18.5175	18.5189	18.4668	18.4964	17130708.0
2014-04-15 16:00:00	AAPL	Stock	18.4982	18.55	18.4454	18.5286	6746404.0
2014-04-15 16:30:00	AAPL	Stock	18.5043	18.5321	18.4909	18.5	788256.0
2014-04-15 17:00:00	AAPL	Stock	18.5089	18.5196	18.5018	18.5071	131880.0
2014-04-15 17:30:00	AAPL	Stock	18.5	18.5	18.4996	18.5	24724.0
2014-04-15 18:00:00	AAPL	Stock	18.4929	18.5071	18.4911	18.5071	137676.0
2014-04-15 18:30:00	AAPL	Stock	18.4982	18.5071	18.4982	18.4996	268408.0
2014-04-15 19:00:00	AAPL	Stock	18.4936	18.5	18.4936	18.5	31500.0
2014-04-15 19:30:00	AAPL	Stock	18.4982	18.5	18.4914	18.4996	78008.0
2014-04-15 08:00:00	MSFT	Stock	39.2	39.2	39.2	39.2	400.0
2014-04-15 08:30:00	MSFT	Stock	39.25	39.25	39.23	39.23	1600.0
2014-04-15 09:00:00	MSFT	Stock	39.25	39.39	39.21	39.33	10750.0
2014-04-15 09:30:00	MSFT	Stock	39.34	39.81	39.19	39.73	4335622.0
2014-04-15 10:00:00	MSFT	Stock	39.72	39.79	39.35	39.36	2734318.0
2014-04-15 10:30:00	MSFT	Stock	39.36	39.59	39.27	39.33	2161580.0
2014-04-15 11:00:00	MSFT	Stock	39.33	39.49	39.19	39.31	1663756.0
2014-04-15 11:30:00	MSFT	Stock	39.32	39.42	39.213	39.265	1736228.0
2014-04-15 12:00:00	MSFT	Stock	39.265	39.287	39.13	39.25	1206282.0
2014-04-15 12:30:00	MSFT	Stock	39.246	39.246	39.075	39.109	1066616.0
2014-04-15 13:00:00	MSFT	Stock	39.1	39.31	39.05	39.3	1248085.0
2014-04-15 13:30:00	MSFT	Stock	39.299	39.44	39.24	39.41	1588391.0
2014-04-15 14:00:00	MSFT	Stock	39.405	39.65	39.405	39.63	1886128.0
2014-04-15 14:30:00	MSFT	Stock	39.625	39.895	39.6	39.75	2012787.0
2014-04-15 15:00:00	MSFT	Stock	39.75	39.95	39.67	39.95	2358814.0
2014-04-15 15:30:00	MSFT	Stock	39.95	39.96	39.68	39.74	5802862.0
2014-04-15 16:00:00	MSFT	Stock	39.75	39.91	39.556	39.75	2727178.0
2014-04-15 16:30:00	MSFT	Stock	39.88	39.95	39.533	39.95	103141.0
2014-04-15 17:00:00	MSFT	Stock	40.08	40.08	39.95	39.95	720.0
2014-04-15 17:30:00	MSFT	Stock	40.05	40.05	39.95	39.95	1800.0
2014-04-15 18:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	400.0
2014-04-15 19:00:00	MSFT	Stock	39.97	39.97	39.97	39.97	9800.0
2014-04-15 09:30:00	NVDA	Stock	0.4585	0.4635	0.458	0.4585	16908960.0
2014-04-15 10:00:00	NVDA	Stock	0.4585	0.4605	0.4552	0.4565	21197880.0

> showing 50 of 82,019 rows — these rows as CSV

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