PREVIEW / stock_30min / 2013-01-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-03.parquet
  size:    1.5 MB
  rows:    77,500
  symbols: 3,476

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-01-03 04:00:00	AAPL	Stock	19.6086	19.6086	19.6032	19.6032	20944.0
2013-01-03 04:30:00	AAPL	Stock	19.5636	19.5643	19.5636	19.5643	9800.0
2013-01-03 05:30:00	AAPL	Stock	19.5218	19.5257	19.5218	19.5257	5600.0
2013-01-03 06:00:00	AAPL	Stock	19.5004	19.5254	19.5004	19.5254	20972.0
2013-01-03 06:30:00	AAPL	Stock	19.5386	19.5386	19.5386	19.5386	2800.0
2013-01-03 07:00:00	AAPL	Stock	19.5389	19.5389	19.5	19.5186	101920.0
2013-01-03 07:30:00	AAPL	Stock	19.5321	19.5321	19.4954	19.5	346108.0
2013-01-03 08:00:00	AAPL	Stock	19.5	19.6082	19.4821	19.5	968744.0
2013-01-03 08:30:00	AAPL	Stock	19.4921	19.5439	19.4911	19.5439	811132.0
2013-01-03 09:00:00	AAPL	Stock	19.5361	19.5739	19.4821	19.5625	1765988.0
2013-01-03 09:30:00	AAPL	Stock	19.5654	19.5936	19.4143	19.5804	60618852.0
2013-01-03 10:00:00	AAPL	Stock	19.5804	19.6311	19.5271	19.5561	35320824.0
2013-01-03 10:30:00	AAPL	Stock	19.5557	19.5889	19.5275	19.5471	20718824.0
2013-01-03 11:00:00	AAPL	Stock	19.5496	19.5821	19.52	19.5568	15463532.0
2013-01-03 11:30:00	AAPL	Stock	19.5618	19.6125	19.5382	19.5479	21706692.0
2013-01-03 12:00:00	AAPL	Stock	19.5446	19.6004	19.5443	19.5875	12123580.0
2013-01-03 12:30:00	AAPL	Stock	19.5875	19.6021	19.5504	19.5529	9783816.0
2013-01-03 13:00:00	AAPL	Stock	19.5518	19.5711	19.5	19.5322	14338380.0
2013-01-03 13:30:00	AAPL	Stock	19.5325	19.5782	19.5296	19.552	5404812.0
2013-01-03 14:00:00	AAPL	Stock	19.5489	19.5716	19.4839	19.4939	24115728.0
2013-01-03 14:30:00	AAPL	Stock	19.4982	19.505	19.4464	19.4818	20826456.0
2013-01-03 15:00:00	AAPL	Stock	19.4796	19.4943	19.3364	19.3725	35873908.0
2013-01-03 15:30:00	AAPL	Stock	19.3693	19.3971	19.3214	19.3707	53830924.0
2013-01-03 16:00:00	AAPL	Stock	19.3657	19.4914	19.3539	19.3607	6836900.0
2013-01-03 16:30:00	AAPL	Stock	19.3579	19.5665	19.35	19.35	826364.0
2013-01-03 17:00:00	AAPL	Stock	19.3468	19.35	19.3329	19.3393	139636.0
2013-01-03 17:30:00	AAPL	Stock	19.3393	19.3393	19.3268	19.3321	240716.0
2013-01-03 18:00:00	AAPL	Stock	19.3321	19.3393	19.3286	19.3321	122864.0
2013-01-03 18:30:00	AAPL	Stock	19.3321	19.3321	19.3246	19.3318	57820.0
2013-01-03 19:00:00	AAPL	Stock	19.3336	19.3357	19.3268	19.3268	58884.0
2013-01-03 19:30:00	AAPL	Stock	19.3321	19.3571	19.3321	19.3571	266728.0
2013-01-03 06:30:00	MSFT	Stock	27.69	27.69	27.68	27.69	3100.0
2013-01-03 07:00:00	MSFT	Stock	27.56	27.56	27.56	27.56	1900.0
2013-01-03 07:30:00	MSFT	Stock	27.55	27.55	27.53	27.55	7928.0
2013-01-03 08:00:00	MSFT	Stock	27.56	27.6	27.55	27.6	2030.0
2013-01-03 08:30:00	MSFT	Stock	27.6	27.67	27.6	27.62	9121.0
2013-01-03 09:00:00	MSFT	Stock	27.62	27.63	27.59	27.63	25711.0
2013-01-03 09:30:00	MSFT	Stock	27.63	27.65	27.39	27.47	4594758.0
2013-01-03 10:00:00	MSFT	Stock	27.47	27.54	27.42	27.42	3802006.0
2013-01-03 10:30:00	MSFT	Stock	27.42	27.475	27.37	27.38	2440352.0
2013-01-03 11:00:00	MSFT	Stock	27.38	27.48	27.38	27.44	2218591.0
2013-01-03 11:30:00	MSFT	Stock	27.445	27.51	27.41	27.425	3711114.0
2013-01-03 12:00:00	MSFT	Stock	27.427	27.44	27.39	27.405	2153015.0
2013-01-03 12:30:00	MSFT	Stock	27.41	27.42	27.33	27.355	2222906.0
2013-01-03 13:00:00	MSFT	Stock	27.35	27.4	27.31	27.38	1883835.0
2013-01-03 13:30:00	MSFT	Stock	27.372	27.38	27.34	27.35	759696.0
2013-01-03 14:00:00	MSFT	Stock	27.35	27.37	27.17	27.17	4029540.0
2013-01-03 14:30:00	MSFT	Stock	27.18	27.35	27.16	27.32	3871919.0
2013-01-03 15:00:00	MSFT	Stock	27.32	27.33	27.22	27.23	2743562.0
2013-01-03 15:30:00	MSFT	Stock	27.24	27.3	27.19	27.28	7963656.0

> showing 50 of 77,500 rows — these rows as CSV

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