PREVIEW / stock_30min / 2011-03-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-16.parquet
  size:    1.4 MB
  rows:    76,451
  symbols: 3,513

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
2011-03-16 04:00:00	AAPL	Stock	12.2643	12.2786	12.2007	12.2007	215180.0
2011-03-16 04:30:00	AAPL	Stock	12.2214	12.25	12.2143	12.25	19600.0
2011-03-16 05:00:00	AAPL	Stock	12.2521	12.2679	12.2393	12.2464	50400.0
2011-03-16 05:30:00	AAPL	Stock	12.2254	12.2254	12.2254	12.2254	33600.0
2011-03-16 06:00:00	AAPL	Stock	12.2321	12.2321	12.2036	12.2079	396900.0
2011-03-16 06:30:00	AAPL	Stock	12.2125	12.2411	12.2039	12.2107	214900.0
2011-03-16 07:00:00	AAPL	Stock	12.2107	12.25	12.2107	12.2429	556360.0
2011-03-16 07:30:00	AAPL	Stock	12.2496	12.2668	12.2436	12.2629	439348.0
2011-03-16 08:00:00	AAPL	Stock	12.2625	12.3196	12.2571	12.2857	3189536.0
2011-03-16 08:30:00	AAPL	Stock	12.2864	12.3368	12.2321	12.2564	3934504.0
2011-03-16 09:00:00	AAPL	Stock	12.2514	12.2679	12.2011	12.2057	3685444.0
2011-03-16 09:30:00	AAPL	Stock	12.2029	12.25	12.0839	12.09	145916792.0
2011-03-16 10:00:00	AAPL	Stock	12.0934	12.1514	12.09	12.1448	79918468.0
2011-03-16 10:30:00	AAPL	Stock	12.145	12.1768	12.0993	12.0997	47217128.0
2011-03-16 11:00:00	AAPL	Stock	12.1029	12.1104	11.8754	12.0004	136611020.0
2011-03-16 11:30:00	AAPL	Stock	12.0	12.0225	11.9246	11.931	56487284.0
2011-03-16 12:00:00	AAPL	Stock	11.9304	11.9421	11.8761	11.9263	76812988.0
2011-03-16 12:30:00	AAPL	Stock	11.9271	11.9908	11.8988	11.9681	47195484.0
2011-03-16 13:00:00	AAPL	Stock	11.9657	11.9861	11.8929	11.9132	35490448.0
2011-03-16 13:30:00	AAPL	Stock	11.9131	11.9168	11.845	11.8718	54900888.0
2011-03-16 14:00:00	AAPL	Stock	11.8718	11.88	11.6521	11.7664	145922868.0
2011-03-16 14:30:00	AAPL	Stock	11.7646	11.9332	11.7568	11.9071	105374276.0
2011-03-16 15:00:00	AAPL	Stock	11.9066	11.9482	11.8482	11.8589	77875196.0
2011-03-16 15:30:00	AAPL	Stock	11.8596	11.8693	11.7711	11.7868	102749164.0
2011-03-16 16:00:00	AAPL	Stock	11.7871	12.1026	11.7771	11.8375	14972692.0
2011-03-16 16:30:00	AAPL	Stock	11.8386	12.0588	11.7075	11.8254	1620472.0
2011-03-16 17:00:00	AAPL	Stock	11.8286	11.8286	11.7521	11.7664	4759916.0
2011-03-16 17:30:00	AAPL	Stock	11.7668	11.7811	11.7321	11.7489	1090712.0
2011-03-16 18:00:00	AAPL	Stock	11.7446	11.75	11.7143	11.7414	1069376.0
2011-03-16 18:30:00	AAPL	Stock	11.7439	11.7536	11.6786	11.7036	748524.0
2011-03-16 19:00:00	AAPL	Stock	11.7036	11.7143	11.6682	11.6714	934864.0
2011-03-16 19:30:00	AAPL	Stock	11.6686	11.725	11.6682	11.675	2090648.0
2011-03-16 07:30:00	MSFT	Stock	25.35	25.37	25.35	25.37	2300.0
2011-03-16 08:00:00	MSFT	Stock	25.37	25.39	25.34	25.39	7950.0
2011-03-16 08:30:00	MSFT	Stock	25.39	25.48	25.34	25.42	29558.0
2011-03-16 09:00:00	MSFT	Stock	25.43	25.43	25.2	25.2	167392.0
2011-03-16 09:30:00	MSFT	Stock	25.23	25.23	24.95	25.02	12242526.0
2011-03-16 10:00:00	MSFT	Stock	25.029	25.28	25.02	25.21	6537651.0
2011-03-16 10:30:00	MSFT	Stock	25.22	25.223	25.01	25.01	4320922.0
2011-03-16 11:00:00	MSFT	Stock	25.01	25.03	24.83	24.85	10606047.0
2011-03-16 11:30:00	MSFT	Stock	24.85	24.86	24.75	24.8	9838504.0
2011-03-16 12:00:00	MSFT	Stock	24.799	24.94	24.75	24.895	5617518.0
2011-03-16 12:30:00	MSFT	Stock	24.9	24.93	24.81	24.91	4655324.0
2011-03-16 13:00:00	MSFT	Stock	24.91	24.97	24.88	24.935	3908520.0
2011-03-16 13:30:00	MSFT	Stock	24.94	25.04	24.8	24.86	10284102.0
2011-03-16 14:00:00	MSFT	Stock	24.85	24.87	24.68	24.81	6038266.0
2011-03-16 14:30:00	MSFT	Stock	24.805	24.97	24.77	24.91	5237057.0
2011-03-16 15:00:00	MSFT	Stock	24.918	24.99	24.84	24.89	4958826.0
2011-03-16 15:30:00	MSFT	Stock	24.89	24.91	24.78	24.79	9807021.0
2011-03-16 16:00:00	MSFT	Stock	24.79	25.168	24.78	24.81	3143787.0

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

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