PREVIEW / stock_30min / 2010-01-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-13.parquet
  size:    1.4 MB
  rows:    72,619
  symbols: 3,445

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-13 04:00:00	AAPL	Stock	7.4261	7.4261	7.4261	7.4261	5600.0
2010-01-13 06:30:00	AAPL	Stock	7.4557	7.4557	7.4557	7.4557	2800.0
2010-01-13 07:00:00	AAPL	Stock	7.4518	7.4557	7.4214	7.4214	44744.0
2010-01-13 07:30:00	AAPL	Stock	7.4446	7.4457	7.4429	7.4429	159404.0
2010-01-13 08:00:00	AAPL	Stock	7.4346	7.4464	7.4125	7.4129	443296.0
2010-01-13 08:30:00	AAPL	Stock	7.4186	7.4286	7.4043	7.4073	656152.0
2010-01-13 09:00:00	AAPL	Stock	7.4071	7.4264	7.4054	7.425	591920.0
2010-01-13 09:30:00	AAPL	Stock	7.4239	7.4457	7.3775	7.3832	67029900.0
2010-01-13 10:00:00	AAPL	Stock	7.3832	7.3893	7.2893	7.3275	106906184.0
2010-01-13 10:30:00	AAPL	Stock	7.325	7.3629	7.3214	7.3504	47872720.0
2010-01-13 11:00:00	AAPL	Stock	7.35	7.3879	7.3221	7.3864	38216976.0
2010-01-13 11:30:00	AAPL	Stock	7.3861	7.3929	7.365	7.3704	24036292.0
2010-01-13 12:00:00	AAPL	Stock	7.37	7.4346	7.37	7.4268	31858316.0
2010-01-13 12:30:00	AAPL	Stock	7.4264	7.4614	7.4214	7.4479	41939184.0
2010-01-13 13:00:00	AAPL	Stock	7.4482	7.4621	7.4356	7.4621	19660396.0
2010-01-13 13:30:00	AAPL	Stock	7.4618	7.4982	7.4575	7.4893	40129740.0
2010-01-13 14:00:00	AAPL	Stock	7.4893	7.5089	7.4821	7.5043	33151972.0
2010-01-13 14:30:00	AAPL	Stock	7.505	7.5175	7.4946	7.5018	33293568.0
2010-01-13 15:00:00	AAPL	Stock	7.5025	7.5129	7.49	7.5071	30084852.0
2010-01-13 15:30:00	AAPL	Stock	7.5073	7.5332	7.5037	7.5143	66311868.0
2010-01-13 16:00:00	AAPL	Stock	7.5246	7.527	7.4205	7.5236	8755628.0
2010-01-13 16:30:00	AAPL	Stock	7.5066	7.5257	7.4277	7.5257	468664.0
2010-01-13 17:00:00	AAPL	Stock	7.5268	7.5282	7.5232	7.5282	49084.0
2010-01-13 17:30:00	AAPL	Stock	7.5289	7.5321	7.5275	7.5304	164192.0
2010-01-13 18:00:00	AAPL	Stock	7.5321	7.5429	7.5232	7.5407	925820.0
2010-01-13 18:30:00	AAPL	Stock	7.5411	7.5414	7.5364	7.5375	80724.0
2010-01-13 19:00:00	AAPL	Stock	7.5375	7.5414	7.5375	7.5411	128408.0
2010-01-13 19:30:00	AAPL	Stock	7.5411	7.5493	7.5393	7.5482	204988.0
2010-01-13 05:30:00	MSFT	Stock	30.1	30.1	30.1	30.1	185.0
2010-01-13 08:00:00	MSFT	Stock	30.18	30.21	30.18	30.18	4650.0
2010-01-13 08:30:00	MSFT	Stock	30.15	30.21	30.15	30.21	8132.0
2010-01-13 09:00:00	MSFT	Stock	30.19	30.26	30.18	30.26	23782.0
2010-01-13 09:30:00	MSFT	Stock	30.26	30.28	30.04	30.048	4612484.0
2010-01-13 10:00:00	MSFT	Stock	30.04	30.11	30.01	30.1	4142542.0
2010-01-13 10:30:00	MSFT	Stock	30.1	30.3	30.09	30.245	3304376.0
2010-01-13 11:00:00	MSFT	Stock	30.24	30.27	30.168	30.2	2999648.0
2010-01-13 11:30:00	MSFT	Stock	30.2	30.26	30.17	30.242	2134802.0
2010-01-13 12:00:00	MSFT	Stock	30.243	30.35	30.24	30.33	2713490.0
2010-01-13 12:30:00	MSFT	Stock	30.331	30.45	30.33	30.44	2794557.0
2010-01-13 13:00:00	MSFT	Stock	30.45	30.45	30.29	30.331	2143559.0
2010-01-13 13:30:00	MSFT	Stock	30.33	30.35	30.26	30.26	2343267.0
2010-01-13 14:00:00	MSFT	Stock	30.26	30.34	30.26	30.33	1774499.0
2010-01-13 14:30:00	MSFT	Stock	30.33	30.45	30.32	30.45	2051079.0
2010-01-13 15:00:00	MSFT	Stock	30.45	30.455	30.35	30.45	2533878.0
2010-01-13 15:30:00	MSFT	Stock	30.45	30.52	30.33	30.35	6724952.0
2010-01-13 16:00:00	MSFT	Stock	30.35	30.44	30.257	30.34	6565652.0
2010-01-13 16:30:00	MSFT	Stock	30.433	30.433	30.326	30.38	39300.0
2010-01-13 17:00:00	MSFT	Stock	30.36	30.36	30.32	30.32	12924.0
2010-01-13 17:30:00	MSFT	Stock	30.35	30.35	30.35	30.35	200000.0
2010-01-13 18:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	5093.0

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

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