PREVIEW / stock_30min / 2010-08-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-20.parquet
  size:    1.3 MB
  rows:    73,043
  symbols: 3,464

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-08-20 06:00:00	AAPL	Stock	8.8929	8.8929	8.8814	8.8814	8400.0
2010-08-20 06:30:00	AAPL	Stock	8.8571	8.8571	8.8571	8.8571	2800.0
2010-08-20 07:00:00	AAPL	Stock	8.8418	8.87	8.8418	8.87	14000.0
2010-08-20 07:30:00	AAPL	Stock	8.8604	8.8768	8.8604	8.8768	40740.0
2010-08-20 08:00:00	AAPL	Stock	8.8768	8.8893	8.875	8.8821	442708.0
2010-08-20 08:30:00	AAPL	Stock	8.8789	8.9014	8.8704	8.8839	478436.0
2010-08-20 09:00:00	AAPL	Stock	8.8914	8.9075	8.8836	8.9036	834932.0
2010-08-20 09:30:00	AAPL	Stock	8.9046	8.9607	8.8929	8.9404	61576844.0
2010-08-20 10:00:00	AAPL	Stock	8.94	8.9771	8.925	8.9279	50971760.0
2010-08-20 10:30:00	AAPL	Stock	8.9275	9.0686	8.9243	8.9332	22330140.0
2010-08-20 11:00:00	AAPL	Stock	8.9321	8.9404	8.9154	8.9246	18086768.0
2010-08-20 11:30:00	AAPL	Stock	8.9236	8.9236	8.9	8.9032	22995868.0
2010-08-20 12:00:00	AAPL	Stock	8.9036	8.9143	8.8982	8.9093	17496696.0
2010-08-20 12:30:00	AAPL	Stock	8.9093	8.925	8.9057	8.9211	13309884.0
2010-08-20 13:00:00	AAPL	Stock	8.9211	8.9279	8.9186	8.92	11871132.0
2010-08-20 13:30:00	AAPL	Stock	8.92	8.9296	8.915	8.9218	10134180.0
2010-08-20 14:00:00	AAPL	Stock	8.9218	8.9429	8.92	8.9307	21136360.0
2010-08-20 14:30:00	AAPL	Stock	8.9314	8.9475	8.9296	8.9296	21462056.0
2010-08-20 15:00:00	AAPL	Stock	8.9296	8.9346	8.9193	8.9279	22688008.0
2010-08-20 15:30:00	AAPL	Stock	8.9279	8.9336	8.9146	8.9164	41404664.0
2010-08-20 16:00:00	AAPL	Stock	8.9164	8.9296	8.8993	8.9268	9225916.0
2010-08-20 16:30:00	AAPL	Stock	8.9268	8.9286	8.9157	8.9221	1326220.0
2010-08-20 17:00:00	AAPL	Stock	8.9243	8.93	8.9243	8.9286	100716.0
2010-08-20 17:30:00	AAPL	Stock	8.9282	8.9314	8.9279	8.9314	56700.0
2010-08-20 18:00:00	AAPL	Stock	8.9286	8.9304	8.9157	8.9286	69776.0
2010-08-20 18:30:00	AAPL	Stock	8.9282	8.9286	8.9232	8.9232	37100.0
2010-08-20 19:00:00	AAPL	Stock	8.9286	8.9286	8.9279	8.9279	5600.0
2010-08-20 19:30:00	AAPL	Stock	8.9279	8.9304	8.9254	8.9279	68656.0
2010-08-20 20:00:00	AAPL	Stock	8.9386	8.9386	8.9386	8.9386	701400.0
2010-08-20 07:30:00	MSFT	Stock	24.3	24.3	24.25	24.25	500.0
2010-08-20 08:00:00	MSFT	Stock	24.34	24.34	24.32	24.32	1100.0
2010-08-20 08:30:00	MSFT	Stock	24.32	24.36	24.32	24.34	4850.0
2010-08-20 09:00:00	MSFT	Stock	24.34	24.39	24.25	24.32	42235.0
2010-08-20 09:30:00	MSFT	Stock	24.31	24.38	24.24	24.34	10665495.0
2010-08-20 10:00:00	MSFT	Stock	24.338	24.39	24.27	24.345	5758619.0
2010-08-20 10:30:00	MSFT	Stock	24.36	24.4	24.32	24.36	3341634.0
2010-08-20 11:00:00	MSFT	Stock	24.36	24.38	24.27	24.33	2171983.0
2010-08-20 11:30:00	MSFT	Stock	24.33	24.33	24.2	24.21	3522242.0
2010-08-20 12:00:00	MSFT	Stock	24.21	24.27	24.2	24.245	2109540.0
2010-08-20 12:30:00	MSFT	Stock	24.245	24.25	24.21	24.21	1966870.0
2010-08-20 13:00:00	MSFT	Stock	24.215	24.25	24.21	24.22	2192447.0
2010-08-20 13:30:00	MSFT	Stock	24.22	24.25	24.2	24.22	3002748.0
2010-08-20 14:00:00	MSFT	Stock	24.22	24.26	24.215	24.223	1545204.0
2010-08-20 14:30:00	MSFT	Stock	24.23	24.32	24.22	24.29	2197642.0
2010-08-20 15:00:00	MSFT	Stock	24.285	24.31	24.23	24.255	2375397.0
2010-08-20 15:30:00	MSFT	Stock	24.255	24.31	24.23	24.23	5845349.0
2010-08-20 16:00:00	MSFT	Stock	24.24	24.303	24.03	24.23	2321812.0
2010-08-20 16:30:00	MSFT	Stock	24.23	24.24	24.14	24.2	152305.0
2010-08-20 17:00:00	MSFT	Stock	24.2	24.277	24.2	24.23	2296.0
2010-08-20 17:30:00	MSFT	Stock	24.21	24.25	24.2	24.25	5793.0

> showing 50 of 73,043 rows — these rows as CSV

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