PREVIEW / stock_30min / 2013-03-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-04.parquet
  size:    1.5 MB
  rows:    77,381
  symbols: 3,497

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-03-04 04:00:00	AAPL	Stock	15.3929	15.3929	15.2857	15.3214	76804.0
2013-03-04 04:30:00	AAPL	Stock	15.3232	15.3393	15.3214	15.3393	24836.0
2013-03-04 05:00:00	AAPL	Stock	15.35	15.3507	15.3357	15.3507	16800.0
2013-03-04 05:30:00	AAPL	Stock	15.3571	15.3571	15.3571	15.3571	2800.0
2013-03-04 06:00:00	AAPL	Stock	15.3518	15.3518	15.3357	15.3357	33796.0
2013-03-04 06:30:00	AAPL	Stock	15.3357	15.3357	15.3214	15.3214	26068.0
2013-03-04 07:00:00	AAPL	Stock	15.3118	15.3214	15.2857	15.3214	476476.0
2013-03-04 07:30:00	AAPL	Stock	15.3161	15.3357	15.3082	15.3286	291648.0
2013-03-04 08:00:00	AAPL	Stock	15.3393	15.3786	15.2857	15.365	957124.0
2013-03-04 08:30:00	AAPL	Stock	15.3675	15.3811	15.2857	15.2939	2009420.0
2013-03-04 09:00:00	AAPL	Stock	15.2971	15.3296	15.2786	15.2786	1888348.0
2013-03-04 09:30:00	AAPL	Stock	15.2786	15.2929	15.1893	15.2168	89982200.0
2013-03-04 10:00:00	AAPL	Stock	15.2161	15.2754	15.1625	15.1707	48515628.0
2013-03-04 10:30:00	AAPL	Stock	15.1701	15.1875	15.0939	15.126	59199756.0
2013-03-04 11:00:00	AAPL	Stock	15.1296	15.1546	15.0754	15.1396	35779380.0
2013-03-04 11:30:00	AAPL	Stock	15.1396	15.1871	15.0943	15.0996	30828084.0
2013-03-04 12:00:00	AAPL	Stock	15.1014	15.1161	15.0471	15.054	31245620.0
2013-03-04 12:30:00	AAPL	Stock	15.0539	15.1371	15.0525	15.1043	23359980.0
2013-03-04 13:00:00	AAPL	Stock	15.1036	15.1321	15.0825	15.118	26889044.0
2013-03-04 13:30:00	AAPL	Stock	15.1221	15.1746	15.0764	15.107	23743160.0
2013-03-04 14:00:00	AAPL	Stock	15.1054	15.1168	15.0411	15.0732	30082668.0
2013-03-04 14:30:00	AAPL	Stock	15.0718	15.1379	15.0536	15.1221	25909520.0
2013-03-04 15:00:00	AAPL	Stock	15.1182	15.1275	15.0279	15.0282	37751028.0
2013-03-04 15:30:00	AAPL	Stock	15.03	15.0429	14.9643	15.0004	82450088.0
2013-03-04 16:00:00	AAPL	Stock	14.9966	15.1308	14.9779	15.0018	9877672.0
2013-03-04 16:30:00	AAPL	Stock	14.9979	14.9982	14.9904	14.9971	250180.0
2013-03-04 17:00:00	AAPL	Stock	14.9964	14.9975	14.9789	14.9889	376096.0
2013-03-04 17:30:00	AAPL	Stock	14.9857	15.0018	14.9857	14.9918	741384.0
2013-03-04 18:00:00	AAPL	Stock	14.9921	14.9961	14.9896	14.9946	187180.0
2013-03-04 18:30:00	AAPL	Stock	14.9946	14.995	14.9914	14.995	69244.0
2013-03-04 19:00:00	AAPL	Stock	14.995	14.9957	14.9911	14.9921	65380.0
2013-03-04 19:30:00	AAPL	Stock	14.99	14.9929	14.94	14.9518	790328.0
2013-03-04 05:30:00	MSFT	Stock	27.8	27.8	27.8	27.8	300.0
2013-03-04 07:00:00	MSFT	Stock	27.82	27.82	27.82	27.82	100.0
2013-03-04 07:30:00	MSFT	Stock	27.87	27.87	27.87	27.87	1700.0
2013-03-04 08:00:00	MSFT	Stock	27.87	27.9	27.85	27.87	15230.0
2013-03-04 08:30:00	MSFT	Stock	27.87	27.92	27.82	27.82	4805.0
2013-03-04 09:00:00	MSFT	Stock	27.84	27.85	27.8	27.83	23524.0
2013-03-04 09:30:00	MSFT	Stock	27.83	27.91	27.72	27.72	3725881.0
2013-03-04 10:00:00	MSFT	Stock	27.72	27.8	27.7	27.78	2385971.0
2013-03-04 10:30:00	MSFT	Stock	27.77	27.829	27.71	27.8	1904704.0
2013-03-04 11:00:00	MSFT	Stock	27.8	27.88	27.77	27.86	2256011.0
2013-03-04 11:30:00	MSFT	Stock	27.87	27.89	27.85	27.87	1238765.0
2013-03-04 12:00:00	MSFT	Stock	27.87	27.89	27.8	27.8	1744425.0
2013-03-04 12:30:00	MSFT	Stock	27.8	27.825	27.755	27.785	1042747.0
2013-03-04 13:00:00	MSFT	Stock	27.78	27.875	27.76	27.855	1466247.0
2013-03-04 13:30:00	MSFT	Stock	27.87	27.88	27.82	27.85	1439628.0
2013-03-04 14:00:00	MSFT	Stock	27.84	28.01	27.83	27.96	4255446.0
2013-03-04 14:30:00	MSFT	Stock	27.965	28.03	27.94	28.03	1963792.0
2013-03-04 15:00:00	MSFT	Stock	28.028	28.095	28.01	28.09	4183554.0

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

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