PREVIEW / stock_30min / 2013-03-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-22.parquet
  size:    1.4 MB
  rows:    75,666
  symbols: 3,461

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-22 04:00:00	AAPL	Stock	16.1804	16.1804	16.1804	16.1804	2800.0
2013-03-22 05:30:00	AAPL	Stock	16.2143	16.2143	16.2143	16.2143	2800.0
2013-03-22 07:00:00	AAPL	Stock	16.2207	16.2321	16.2054	16.2321	33992.0
2013-03-22 07:30:00	AAPL	Stock	16.25	16.2679	16.2218	16.2304	182392.0
2013-03-22 08:00:00	AAPL	Stock	16.2296	16.25	16.2139	16.2321	400652.0
2013-03-22 08:30:00	AAPL	Stock	16.2318	16.2357	16.215	16.2214	313124.0
2013-03-22 09:00:00	AAPL	Stock	16.2246	16.2393	16.2118	16.2357	512904.0
2013-03-22 09:30:00	AAPL	Stock	16.2282	16.2961	16.1825	16.2764	49303912.0
2013-03-22 10:00:00	AAPL	Stock	16.2754	16.3268	16.2646	16.2726	34304284.0
2013-03-22 10:30:00	AAPL	Stock	16.2714	16.3179	16.1786	16.2854	19114564.0
2013-03-22 11:00:00	AAPL	Stock	16.2839	16.3132	16.2797	16.3021	13520752.0
2013-03-22 11:30:00	AAPL	Stock	16.3021	16.325	16.2896	16.3236	13210428.0
2013-03-22 12:00:00	AAPL	Stock	16.325	16.3814	16.325	16.3679	34426588.0
2013-03-22 12:30:00	AAPL	Stock	16.3679	16.4239	16.3654	16.4068	32941468.0
2013-03-22 13:00:00	AAPL	Stock	16.4068	16.4546	16.3725	16.454	26018048.0
2013-03-22 13:30:00	AAPL	Stock	16.4527	16.4929	16.4421	16.4753	34844908.0
2013-03-22 14:00:00	AAPL	Stock	16.4748	16.5	16.4618	16.4784	19736500.0
2013-03-22 14:30:00	AAPL	Stock	16.4804	16.4804	16.4321	16.4461	19608176.0
2013-03-22 15:00:00	AAPL	Stock	16.4425	16.4589	16.4336	16.4379	14772268.0
2013-03-22 15:30:00	AAPL	Stock	16.4368	16.5036	16.4364	16.4982	57279180.0
2013-03-22 16:00:00	AAPL	Stock	16.4982	16.5464	16.3832	16.5071	13362524.0
2013-03-22 16:30:00	AAPL	Stock	16.5071	16.5171	16.5014	16.5107	547568.0
2013-03-22 17:00:00	AAPL	Stock	16.5125	16.5161	16.4968	16.5107	403452.0
2013-03-22 17:30:00	AAPL	Stock	16.5129	16.5696	16.5129	16.5589	1145060.0
2013-03-22 18:00:00	AAPL	Stock	16.5468	16.5536	16.5382	16.5475	192976.0
2013-03-22 18:30:00	AAPL	Stock	16.54	16.5407	16.5296	16.5314	342496.0
2013-03-22 19:00:00	AAPL	Stock	16.5325	16.5325	16.5257	16.5257	47852.0
2013-03-22 19:30:00	AAPL	Stock	16.5318	16.5429	16.5307	16.5325	118748.0
2013-03-22 08:30:00	MSFT	Stock	28.15	28.2	28.15	28.2	400.0
2013-03-22 09:00:00	MSFT	Stock	28.14	28.17	28.14	28.17	11600.0
2013-03-22 09:30:00	MSFT	Stock	28.19	28.22	28.13	28.18	2754647.0
2013-03-22 10:00:00	MSFT	Stock	28.175	28.21	28.115	28.145	1984793.0
2013-03-22 10:30:00	MSFT	Stock	28.14	28.19	28.12	28.16	2072508.0
2013-03-22 11:00:00	MSFT	Stock	28.15	28.175	28.1	28.162	2307620.0
2013-03-22 11:30:00	MSFT	Stock	28.16	28.17	28.1	28.11	1268685.0
2013-03-22 12:00:00	MSFT	Stock	28.105	28.16	28.1	28.155	2929279.0
2013-03-22 12:30:00	MSFT	Stock	28.15	28.27	28.15	28.25	1534422.0
2013-03-22 13:00:00	MSFT	Stock	28.25	28.32	28.24	28.31	2093619.0
2013-03-22 13:30:00	MSFT	Stock	28.31	28.338	28.26	28.265	849113.0
2013-03-22 14:00:00	MSFT	Stock	28.265	28.27	28.23	28.24	1183794.0
2013-03-22 14:30:00	MSFT	Stock	28.245	28.28	28.22	28.23	1882754.0
2013-03-22 15:00:00	MSFT	Stock	28.23	28.25	28.18	28.22	2257723.0
2013-03-22 15:30:00	MSFT	Stock	28.22	28.26	28.17	28.245	3120783.0
2013-03-22 16:00:00	MSFT	Stock	28.26	28.28	28.068	28.25	2254957.0
2013-03-22 16:30:00	MSFT	Stock	28.22	28.22	28.22	28.22	300.0
2013-03-22 17:00:00	MSFT	Stock	28.25	28.259	28.25	28.25	4770.0
2013-03-22 17:30:00	MSFT	Stock	28.29	28.29	28.23	28.23	700.0
2013-03-22 18:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	100.0
2013-03-22 19:00:00	MSFT	Stock	28.29	28.29	28.29	28.29	300.0
2013-03-22 09:00:00	NVDA	Stock	0.312	0.3123	0.312	0.3123	48000.0

> showing 50 of 75,666 rows — these rows as CSV

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