PREVIEW / stock_30min / 2012-10-11

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-11.parquet
  size:    1.4 MB
  rows:    74,225
  symbols: 3,465

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-10-11 04:00:00	AAPL	Stock	22.9339	23.0	22.9286	23.0	51492.0
2012-10-11 04:30:00	AAPL	Stock	23.0	23.0	22.9957	22.9957	5600.0
2012-10-11 05:00:00	AAPL	Stock	23.0139	23.0139	23.0139	23.0139	2856.0
2012-10-11 05:30:00	AAPL	Stock	23.0179	23.0179	23.0036	23.0179	45808.0
2012-10-11 06:30:00	AAPL	Stock	23.0357	23.0357	23.0354	23.0357	15400.0
2012-10-11 07:00:00	AAPL	Stock	23.0179	23.0571	22.9896	23.0246	379344.0
2012-10-11 07:30:00	AAPL	Stock	23.0179	23.0325	22.9979	23.0257	417900.0
2012-10-11 08:00:00	AAPL	Stock	23.0161	23.0246	22.9821	23.0079	916300.0
2012-10-11 08:30:00	AAPL	Stock	23.0268	23.0714	23.0189	23.0593	1790964.0
2012-10-11 09:00:00	AAPL	Stock	23.0575	23.1036	23.0529	23.0961	2270156.0
2012-10-11 09:30:00	AAPL	Stock	23.095	23.1143	22.9289	22.9664	61222560.0
2012-10-11 10:00:00	AAPL	Stock	22.9654	23.0104	22.8968	22.9121	34350540.0
2012-10-11 10:30:00	AAPL	Stock	22.9121	22.98	22.8632	22.8789	35139720.0
2012-10-11 11:00:00	AAPL	Stock	22.8804	22.8811	22.6586	22.7436	62251392.0
2012-10-11 11:30:00	AAPL	Stock	22.7446	22.7446	22.5586	22.6812	48778492.0
2012-10-11 12:00:00	AAPL	Stock	22.6789	22.7214	22.6186	22.6606	22284472.0
2012-10-11 12:30:00	AAPL	Stock	22.6604	22.6857	22.5736	22.6084	24977652.0
2012-10-11 13:00:00	AAPL	Stock	22.608	22.6739	22.5786	22.5861	19736584.0
2012-10-11 13:30:00	AAPL	Stock	22.5879	22.5889	22.4932	22.5125	45356276.0
2012-10-11 14:00:00	AAPL	Stock	22.5132	22.6361	22.5099	22.5725	28256032.0
2012-10-11 14:30:00	AAPL	Stock	22.5768	22.6168	22.5179	22.5414	22023176.0
2012-10-11 15:00:00	AAPL	Stock	22.5425	22.6132	22.4714	22.6057	40293484.0
2012-10-11 15:30:00	AAPL	Stock	22.6057	22.6057	22.4321	22.4321	60615380.0
2012-10-11 16:00:00	AAPL	Stock	22.4321	22.706	22.4	22.4214	12141024.0
2012-10-11 16:30:00	AAPL	Stock	22.4236	22.6052	22.4236	22.4536	502824.0
2012-10-11 17:00:00	AAPL	Stock	22.4486	22.4568	22.4464	22.4489	101836.0
2012-10-11 17:30:00	AAPL	Stock	22.4411	22.4696	22.4411	22.4643	291928.0
2012-10-11 18:00:00	AAPL	Stock	22.4575	22.4643	22.4529	22.4625	86072.0
2012-10-11 18:30:00	AAPL	Stock	22.4568	22.4568	22.4518	22.4536	28476.0
2012-10-11 19:00:00	AAPL	Stock	22.4571	22.4607	22.4468	22.4579	122388.0
2012-10-11 19:30:00	AAPL	Stock	22.4557	22.4732	22.445	22.4732	186900.0
2012-10-11 06:30:00	MSFT	Stock	29.1	29.1	29.1	29.1	1000.0
2012-10-11 07:00:00	MSFT	Stock	29.15	29.15	29.09	29.09	9338.0
2012-10-11 07:30:00	MSFT	Stock	29.09	29.09	29.0	29.08	8600.0
2012-10-11 08:00:00	MSFT	Stock	29.08	29.08	29.04	29.05	51482.0
2012-10-11 08:30:00	MSFT	Stock	29.08	29.12	29.08	29.11	19187.0
2012-10-11 09:00:00	MSFT	Stock	29.11	29.28	29.11	29.26	183674.0
2012-10-11 09:30:00	MSFT	Stock	29.21	29.25	29.0	29.065	6612250.0
2012-10-11 10:00:00	MSFT	Stock	29.06	29.14	29.02	29.12	3975631.0
2012-10-11 10:30:00	MSFT	Stock	29.124	29.16	29.08	29.115	2876156.0
2012-10-11 11:00:00	MSFT	Stock	29.115	29.13	29.06	29.08	2802042.0
2012-10-11 11:30:00	MSFT	Stock	29.085	29.09	28.98	29.01	2419758.0
2012-10-11 12:00:00	MSFT	Stock	29.015	29.055	28.98	29.005	1385636.0
2012-10-11 12:30:00	MSFT	Stock	29.005	29.06	29.0	29.03	1296633.0
2012-10-11 13:00:00	MSFT	Stock	29.026	29.06	28.975	28.975	1699943.0
2012-10-11 13:30:00	MSFT	Stock	28.97	28.99	28.9	28.93	2317085.0
2012-10-11 14:00:00	MSFT	Stock	28.925	28.97	28.87	28.88	2759705.0
2012-10-11 14:30:00	MSFT	Stock	28.88	28.92	28.87	28.902	2190713.0
2012-10-11 15:00:00	MSFT	Stock	28.9	29.05	28.9	29.035	2833773.0
2012-10-11 15:30:00	MSFT	Stock	29.03	29.038	28.94	28.955	5119507.0

> showing 50 of 74,225 rows — these rows as CSV

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