PREVIEW / stock_30min / 2012-03-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-13.parquet
  size:    1.4 MB
  rows:    76,558
  symbols: 3,532

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
2012-03-13 04:00:00	AAPL	Stock	19.7357	19.8339	19.7357	19.8339	52920.0
2012-03-13 04:30:00	AAPL	Stock	19.8321	19.8393	19.8321	19.8393	50400.0
2012-03-13 05:00:00	AAPL	Stock	19.85	19.85	19.8393	19.8393	11200.0
2012-03-13 05:30:00	AAPL	Stock	19.85	19.85	19.85	19.85	11452.0
2012-03-13 06:00:00	AAPL	Stock	19.8571	19.8679	19.8571	19.8571	58800.0
2012-03-13 06:30:00	AAPL	Stock	19.8679	19.8682	19.8571	19.8571	50680.0
2012-03-13 07:00:00	AAPL	Stock	19.8436	19.8754	19.8393	19.8732	443100.0
2012-03-13 07:30:00	AAPL	Stock	19.8739	19.9036	19.8739	19.8893	791476.0
2012-03-13 08:00:00	AAPL	Stock	19.8868	19.9196	19.8743	19.8929	2271920.0
2012-03-13 08:30:00	AAPL	Stock	19.8961	19.9021	19.8757	19.8829	1420496.0
2012-03-13 09:00:00	AAPL	Stock	19.88	19.9243	19.875	19.9114	2997064.0
2012-03-13 09:30:00	AAPL	Stock	19.9193	19.9414	19.8571	19.8765	69598480.0
2012-03-13 10:00:00	AAPL	Stock	19.8811	19.9161	19.8482	19.9118	46919460.0
2012-03-13 10:30:00	AAPL	Stock	19.9121	19.9946	19.9071	19.9872	61373816.0
2012-03-13 11:00:00	AAPL	Stock	19.9871	20.005	19.9507	19.9968	40183052.0
2012-03-13 11:30:00	AAPL	Stock	19.9959	20.0671	19.9839	20.0304	52612028.0
2012-03-13 12:00:00	AAPL	Stock	20.0307	20.1207	20.0157	20.1207	49760284.0
2012-03-13 12:30:00	AAPL	Stock	20.12	20.1468	20.1109	20.1273	41636308.0
2012-03-13 13:00:00	AAPL	Stock	20.1293	20.1314	20.0607	20.1039	37465820.0
2012-03-13 13:30:00	AAPL	Stock	20.1018	20.1071	20.0861	20.1032	17341856.0
2012-03-13 14:00:00	AAPL	Stock	20.1025	20.1589	20.0893	20.1086	37282000.0
2012-03-13 14:30:00	AAPL	Stock	20.1082	20.1532	20.0793	20.1396	51700180.0
2012-03-13 15:00:00	AAPL	Stock	20.1404	20.2632	20.1364	20.2379	66117324.0
2012-03-13 15:30:00	AAPL	Stock	20.2414	20.2921	20.1964	20.2886	82725888.0
2012-03-13 16:00:00	AAPL	Stock	20.2893	20.2993	20.0087	20.2843	17433304.0
2012-03-13 16:30:00	AAPL	Stock	20.2843	20.2964	20.2378	20.2961	1343384.0
2012-03-13 17:00:00	AAPL	Stock	20.2921	20.2946	20.2539	20.2593	1626268.0
2012-03-13 17:30:00	AAPL	Stock	20.2607	20.2607	20.2468	20.2511	329980.0
2012-03-13 18:00:00	AAPL	Stock	20.25	20.2679	20.25	20.2589	216300.0
2012-03-13 18:30:00	AAPL	Stock	20.2589	20.2804	20.2589	20.2761	377720.0
2012-03-13 19:00:00	AAPL	Stock	20.2775	20.2918	20.2721	20.2864	488740.0
2012-03-13 19:30:00	AAPL	Stock	20.2893	20.3107	20.2839	20.3018	547708.0
2012-03-13 06:00:00	MSFT	Stock	32.25	32.25	32.25	32.25	100.0
2012-03-13 07:00:00	MSFT	Stock	32.25	32.25	32.2	32.2	2800.0
2012-03-13 07:30:00	MSFT	Stock	32.2	32.21	32.2	32.2	6109.0
2012-03-13 08:00:00	MSFT	Stock	32.2	32.2	32.17	32.19	1700.0
2012-03-13 08:30:00	MSFT	Stock	32.2	32.21	32.04	32.2	9584.0
2012-03-13 09:00:00	MSFT	Stock	32.19	32.27	32.19	32.25	13528.0
2012-03-13 09:30:00	MSFT	Stock	32.26	32.28	32.15	32.22	4102772.0
2012-03-13 10:00:00	MSFT	Stock	32.21	32.28	32.17	32.265	3212583.0
2012-03-13 10:30:00	MSFT	Stock	32.263	32.36	32.26	32.31	2891461.0
2012-03-13 11:00:00	MSFT	Stock	32.31	32.49	32.28	32.475	8055781.0
2012-03-13 11:30:00	MSFT	Stock	32.475	32.49	32.42	32.47	2326791.0
2012-03-13 12:00:00	MSFT	Stock	32.465	32.47	32.44	32.45	1499848.0
2012-03-13 12:30:00	MSFT	Stock	32.46	32.48	32.42	32.472	1635119.0
2012-03-13 13:00:00	MSFT	Stock	32.47	32.49	32.47	32.48	1329148.0
2012-03-13 13:30:00	MSFT	Stock	32.48	32.48	32.42	32.445	1626819.0
2012-03-13 14:00:00	MSFT	Stock	32.45	32.5	32.42	32.445	1891250.0
2012-03-13 14:30:00	MSFT	Stock	32.449	32.48	32.41	32.45	1962305.0
2012-03-13 15:00:00	MSFT	Stock	32.445	32.55	32.44	32.49	4430979.0

> showing 50 of 76,558 rows — these rows as CSV

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