PREVIEW / stock_30min / 2010-01-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-27.parquet
  size:    1.3 MB
  rows:    72,666
  symbols: 3,435

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-01-27 04:00:00	AAPL	Stock	7.3961	7.4054	7.3954	7.4054	39200.0
2010-01-27 05:00:00	AAPL	Stock	7.4132	7.4132	7.4132	7.4132	6160.0
2010-01-27 05:30:00	AAPL	Stock	7.4246	7.4264	7.4157	7.4264	57792.0
2010-01-27 06:00:00	AAPL	Stock	7.4246	7.4375	7.4189	7.4375	41608.0
2010-01-27 06:30:00	AAPL	Stock	7.4289	7.4464	7.4286	7.4321	102536.0
2010-01-27 07:00:00	AAPL	Stock	7.42	7.4386	7.4107	7.4107	759724.0
2010-01-27 07:30:00	AAPL	Stock	7.4089	7.4243	7.3786	7.4036	1381296.0
2010-01-27 08:00:00	AAPL	Stock	7.4021	7.4089	7.355	7.3832	4770416.0
2010-01-27 08:30:00	AAPL	Stock	7.3857	7.3879	7.3679	7.3768	2796752.0
2010-01-27 09:00:00	AAPL	Stock	7.3764	7.3896	7.3279	7.3886	6597248.0
2010-01-27 09:30:00	AAPL	Stock	7.3868	7.4011	7.2768	7.3496	139452488.0
2010-01-27 10:00:00	AAPL	Stock	7.3496	7.3632	7.2589	7.2982	96364996.0
2010-01-27 10:30:00	AAPL	Stock	7.2985	7.2986	7.2071	7.2832	90405532.0
2010-01-27 11:00:00	AAPL	Stock	7.2843	7.2911	7.2393	7.2714	43771728.0
2010-01-27 11:30:00	AAPL	Stock	7.2718	7.2743	7.2246	7.2604	38529568.0
2010-01-27 12:00:00	AAPL	Stock	7.2604	7.3218	7.2357	7.3073	57069292.0
2010-01-27 12:30:00	AAPL	Stock	7.3071	7.3321	7.2725	7.3079	60268964.0
2010-01-27 13:00:00	AAPL	Stock	7.3095	7.3286	7.1261	7.1757	234046288.0
2010-01-27 13:30:00	AAPL	Stock	7.175	7.2792	7.1693	7.2393	130988256.0
2010-01-27 14:00:00	AAPL	Stock	7.2382	7.4911	7.235	7.3904	263899104.0
2010-01-27 14:30:00	AAPL	Stock	7.3885	7.5207	7.3861	7.4882	227146276.0
2010-01-27 15:00:00	AAPL	Stock	7.4882	7.4907	7.3365	7.4057	148593816.0
2010-01-27 15:30:00	AAPL	Stock	7.4054	7.4711	7.3857	7.4275	139868400.0
2010-01-27 16:00:00	AAPL	Stock	7.4236	7.4418	7.2536	7.4143	20758276.0
2010-01-27 16:30:00	AAPL	Stock	7.406	7.4279	7.406	7.4171	1805748.0
2010-01-27 17:00:00	AAPL	Stock	7.4143	7.4211	7.4064	7.4125	758268.0
2010-01-27 17:30:00	AAPL	Stock	7.4107	7.4139	7.4089	7.4107	321160.0
2010-01-27 18:00:00	AAPL	Stock	7.4136	7.4279	7.4093	7.4107	146300.0
2010-01-27 18:30:00	AAPL	Stock	7.4096	7.4196	7.4093	7.4125	335748.0
2010-01-27 19:00:00	AAPL	Stock	7.4111	7.4157	7.4071	7.4157	402220.0
2010-01-27 19:30:00	AAPL	Stock	7.4154	7.4193	7.3929	7.3964	374892.0
2010-01-27 07:00:00	MSFT	Stock	29.49	29.49	29.49	29.49	1000.0
2010-01-27 08:00:00	MSFT	Stock	29.54	29.57	29.53	29.53	11949.0
2010-01-27 08:30:00	MSFT	Stock	29.54	29.54	29.49	29.49	11508.0
2010-01-27 09:00:00	MSFT	Stock	29.53	29.53	29.36	29.36	34774.0
2010-01-27 09:30:00	MSFT	Stock	29.36	29.72	29.28	29.57	6367162.0
2010-01-27 10:00:00	MSFT	Stock	29.56	29.59	29.29	29.4	5995254.0
2010-01-27 10:30:00	MSFT	Stock	29.4	29.45	29.02	29.395	4287429.0
2010-01-27 11:00:00	MSFT	Stock	29.39	29.47	29.35	29.432	2856019.0
2010-01-27 11:30:00	MSFT	Stock	29.44	29.52	29.43	29.455	2329503.0
2010-01-27 12:00:00	MSFT	Stock	29.45	29.53	29.43	29.46	2260578.0
2010-01-27 12:30:00	MSFT	Stock	29.469	29.49	29.43	29.438	2859134.0
2010-01-27 13:00:00	MSFT	Stock	29.44	29.49	29.4	29.4	2901864.0
2010-01-27 13:30:00	MSFT	Stock	29.41	29.47	29.4	29.45	1959205.0
2010-01-27 14:00:00	MSFT	Stock	29.45	29.62	29.29	29.4	5098442.0
2010-01-27 14:30:00	MSFT	Stock	29.4	29.73	29.37	29.6	5181490.0
2010-01-27 15:00:00	MSFT	Stock	29.6	29.68	29.38	29.672	5788613.0
2010-01-27 15:30:00	MSFT	Stock	29.65	29.82	29.64	29.67	6705836.0
2010-01-27 16:00:00	MSFT	Stock	29.68	29.71	29.496	29.67	6754794.0
2010-01-27 16:30:00	MSFT	Stock	29.69	29.69	29.64	29.65	291169.0

> showing 50 of 72,666 rows — these rows as CSV

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