PREVIEW / stock_30min / 2013-12-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-12-03.parquet
  size:    1.6 MB
  rows:    81,894
  symbols: 3,544

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-12-03 04:00:00	AAPL	Stock	19.8211	20.0036	19.8211	19.9407	66752.0
2013-12-03 04:30:00	AAPL	Stock	19.9621	19.9696	19.9286	19.9332	48860.0
2013-12-03 05:00:00	AAPL	Stock	19.9375	19.9375	19.8489	19.9125	70448.0
2013-12-03 05:30:00	AAPL	Stock	19.9075	19.9129	19.8707	19.8929	208152.0
2013-12-03 06:00:00	AAPL	Stock	19.9107	19.9254	19.9107	19.925	75600.0
2013-12-03 06:30:00	AAPL	Stock	19.9196	19.9286	19.8761	19.925	184072.0
2013-12-03 07:00:00	AAPL	Stock	19.9129	19.9246	19.8532	19.8743	689080.0
2013-12-03 07:30:00	AAPL	Stock	19.8743	19.9143	19.8714	19.8929	922656.0
2013-12-03 08:00:00	AAPL	Stock	19.8918	19.925	19.6964	19.8964	2252208.0
2013-12-03 08:30:00	AAPL	Stock	19.8943	19.9014	19.8421	19.8821	1264340.0
2013-12-03 09:00:00	AAPL	Stock	19.8829	19.9625	19.875	19.9164	5390252.0
2013-12-03 09:30:00	AAPL	Stock	19.9393	20.1229	19.9171	20.0068	95309592.0
2013-12-03 10:00:00	AAPL	Stock	20.0057	20.0657	19.9786	19.9971	38309460.0
2013-12-03 10:30:00	AAPL	Stock	19.9986	20.0507	19.9889	20.0439	22579536.0
2013-12-03 11:00:00	AAPL	Stock	20.0441	20.118	20.0357	20.0515	34103720.0
2013-12-03 11:30:00	AAPL	Stock	20.0557	20.0557	19.9493	19.9964	25499908.0
2013-12-03 12:00:00	AAPL	Stock	19.9957	20.05	19.9875	20.0186	18242140.0
2013-12-03 12:30:00	AAPL	Stock	20.0182	20.0721	19.9932	20.065	12372556.0
2013-12-03 13:00:00	AAPL	Stock	20.0643	20.0686	20.0189	20.025	9866556.0
2013-12-03 13:30:00	AAPL	Stock	20.0236	20.05	19.9857	20.0225	19766096.0
2013-12-03 14:00:00	AAPL	Stock	20.025	20.055	20.0179	20.0392	10433920.0
2013-12-03 14:30:00	AAPL	Stock	20.0382	20.1354	20.0361	20.1221	26639956.0
2013-12-03 15:00:00	AAPL	Stock	20.1221	20.1464	20.0979	20.1143	26792752.0
2013-12-03 15:30:00	AAPL	Stock	20.1143	20.2279	20.1115	20.2279	59307080.0
2013-12-03 16:00:00	AAPL	Stock	20.2271	20.2321	20.052	20.2268	22396808.0
2013-12-03 16:30:00	AAPL	Stock	20.2286	20.2496	20.0255	20.2421	311668.0
2013-12-03 17:00:00	AAPL	Stock	20.2464	20.2768	20.2271	20.2743	1363180.0
2013-12-03 17:30:00	AAPL	Stock	20.27	20.2729	20.2589	20.2675	269556.0
2013-12-03 18:00:00	AAPL	Stock	20.2607	20.2807	20.2518	20.2782	249760.0
2013-12-03 18:30:00	AAPL	Stock	20.2782	20.2936	20.2761	20.2893	315980.0
2013-12-03 19:00:00	AAPL	Stock	20.2893	20.31	20.2271	20.2979	443996.0
2013-12-03 19:30:00	AAPL	Stock	20.2964	20.3036	20.2779	20.2857	315056.0
2013-12-03 04:00:00	MSFT	Stock	38.51	38.51	38.51	38.51	200.0
2013-12-03 05:30:00	MSFT	Stock	38.39	38.39	38.39	38.39	420.0
2013-12-03 06:00:00	MSFT	Stock	38.37	38.41	38.3	38.3	2495.0
2013-12-03 07:30:00	MSFT	Stock	38.3	38.3	38.21	38.21	7574.0
2013-12-03 08:00:00	MSFT	Stock	38.25	38.25	38.13	38.13	183099.0
2013-12-03 08:30:00	MSFT	Stock	38.13	38.22	38.13	38.22	9950.0
2013-12-03 09:00:00	MSFT	Stock	38.19	38.45	38.11	38.11	146228.0
2013-12-03 09:30:00	MSFT	Stock	38.12	38.49	38.08	38.365	8410995.0
2013-12-03 10:00:00	MSFT	Stock	38.37	38.47	38.34	38.385	4872082.0
2013-12-03 10:30:00	MSFT	Stock	38.385	38.4	38.245	38.31	4645485.0
2013-12-03 11:00:00	MSFT	Stock	38.31	38.36	38.26	38.32	3152543.0
2013-12-03 11:30:00	MSFT	Stock	38.321	38.36	38.25	38.29	2879239.0
2013-12-03 12:00:00	MSFT	Stock	38.29	38.33	38.23	38.234	1724912.0
2013-12-03 12:30:00	MSFT	Stock	38.233	38.31	38.23	38.25	1236023.0
2013-12-03 13:00:00	MSFT	Stock	38.25	38.3	38.23	38.25	1996916.0
2013-12-03 13:30:00	MSFT	Stock	38.25	38.3	38.23	38.25	3522217.0
2013-12-03 14:00:00	MSFT	Stock	38.25	38.3	38.24	38.27	2182297.0
2013-12-03 14:30:00	MSFT	Stock	38.27	38.3	38.25	38.26	1902819.0

> showing 50 of 81,894 rows — these rows as CSV

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