PREVIEW / stock_30min / 2013-11-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-07.parquet
  size:    1.6 MB
  rows:    81,036
  symbols: 3,525

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
2013-11-07 05:30:00	AAPL	Stock	18.5386	18.5386	18.5386	18.5386	2800.0
2013-11-07 06:00:00	AAPL	Stock	18.5368	18.5368	18.5368	18.5368	2800.0
2013-11-07 06:30:00	AAPL	Stock	18.5271	18.5271	18.5271	18.5271	2800.0
2013-11-07 07:00:00	AAPL	Stock	18.5571	18.6061	18.5536	18.5536	113932.0
2013-11-07 07:30:00	AAPL	Stock	18.5854	18.6393	18.5579	18.6304	261016.0
2013-11-07 08:00:00	AAPL	Stock	18.62	18.6429	18.5536	18.6211	692272.0
2013-11-07 08:30:00	AAPL	Stock	18.6211	18.6518	18.5911	18.6032	1109108.0
2013-11-07 09:00:00	AAPL	Stock	18.5932	18.6139	18.5436	18.5636	695828.0
2013-11-07 09:30:00	AAPL	Stock	18.5564	18.6854	18.5396	18.6261	40949720.0
2013-11-07 10:00:00	AAPL	Stock	18.6314	18.6329	18.4932	18.5293	32798976.0
2013-11-07 10:30:00	AAPL	Stock	18.5296	18.5864	18.4768	18.5221	23083900.0
2013-11-07 11:00:00	AAPL	Stock	18.5218	18.5464	18.4671	18.5086	19681480.0
2013-11-07 11:30:00	AAPL	Stock	18.5079	18.5504	18.4876	18.5211	10174696.0
2013-11-07 12:00:00	AAPL	Stock	18.5211	18.5418	18.4761	18.5146	11152512.0
2013-11-07 12:30:00	AAPL	Stock	18.5093	18.5389	18.5008	18.5032	5427548.0
2013-11-07 13:00:00	AAPL	Stock	18.5032	18.5141	18.4443	18.4643	13183856.0
2013-11-07 13:30:00	AAPL	Stock	18.4632	18.4746	18.4321	18.4511	10471776.0
2013-11-07 14:00:00	AAPL	Stock	18.4507	18.4593	18.4068	18.4329	13846952.0
2013-11-07 14:30:00	AAPL	Stock	18.4314	18.4589	18.4102	18.44	11291308.0
2013-11-07 15:00:00	AAPL	Stock	18.44	18.4429	18.3525	18.3525	17473484.0
2013-11-07 15:30:00	AAPL	Stock	18.3539	18.3693	18.2993	18.3036	34944224.0
2013-11-07 16:00:00	AAPL	Stock	18.3039	18.4902	18.3021	18.3146	8375416.0
2013-11-07 16:30:00	AAPL	Stock	18.3039	18.4287	18.3003	18.3107	913808.0
2013-11-07 17:00:00	AAPL	Stock	18.3107	18.3193	18.3071	18.3071	52892.0
2013-11-07 17:30:00	AAPL	Stock	18.3089	18.3143	18.3039	18.3143	51884.0
2013-11-07 18:00:00	AAPL	Stock	18.3143	18.3257	18.3043	18.3061	119644.0
2013-11-07 18:30:00	AAPL	Stock	18.3089	18.3196	18.3068	18.3071	56280.0
2013-11-07 19:00:00	AAPL	Stock	18.3039	18.3193	18.3039	18.3168	62944.0
2013-11-07 19:30:00	AAPL	Stock	18.3125	18.3179	18.3064	18.3071	155064.0
2013-11-07 05:00:00	MSFT	Stock	38.09	38.11	38.09	38.11	820.0
2013-11-07 05:30:00	MSFT	Stock	38.17	38.21	38.17	38.21	320.0
2013-11-07 06:00:00	MSFT	Stock	38.23	38.24	38.14	38.14	3100.0
2013-11-07 06:30:00	MSFT	Stock	38.1	38.1	38.0	38.0	1200.0
2013-11-07 07:00:00	MSFT	Stock	38.09	38.1	38.0	38.1	3685.0
2013-11-07 07:30:00	MSFT	Stock	38.07	38.2	38.0	38.2	7670.0
2013-11-07 08:00:00	MSFT	Stock	38.2	38.2	38.0	38.04	36363.0
2013-11-07 08:30:00	MSFT	Stock	38.04	38.08	38.0	38.02	27471.0
2013-11-07 09:00:00	MSFT	Stock	38.04	38.18	37.91	37.96	121617.0
2013-11-07 09:30:00	MSFT	Stock	37.96	38.01	37.69	37.78	8106021.0
2013-11-07 10:00:00	MSFT	Stock	37.77	37.92	37.7	37.74	5301526.0
2013-11-07 10:30:00	MSFT	Stock	37.745	37.935	37.7	37.85	4102209.0
2013-11-07 11:00:00	MSFT	Stock	37.855	37.895	37.615	37.71	4152469.0
2013-11-07 11:30:00	MSFT	Stock	37.71	37.77	37.65	37.73	2683207.0
2013-11-07 12:00:00	MSFT	Stock	37.73	37.77	37.63	37.675	3246621.0
2013-11-07 12:30:00	MSFT	Stock	37.66	37.71	37.64	37.7	2380659.0
2013-11-07 13:00:00	MSFT	Stock	37.69	37.78	37.66	37.663	3413476.0
2013-11-07 13:30:00	MSFT	Stock	37.66	37.7	37.63	37.635	2530020.0
2013-11-07 14:00:00	MSFT	Stock	37.63	37.66	37.51	37.542	4250491.0
2013-11-07 14:30:00	MSFT	Stock	37.54	37.61	37.43	37.607	4714424.0
2013-11-07 15:00:00	MSFT	Stock	37.605	37.63	37.49	37.505	3239129.0

> showing 50 of 81,036 rows — these rows as CSV

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