PREVIEW / stock_30min / 2011-08-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-17.parquet
  size:    1.4 MB
  rows:    74,565
  symbols: 3,515

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-08-17 04:00:00	AAPL	Stock	13.58	13.58	13.58	13.58	2800.0
2011-08-17 04:30:00	AAPL	Stock	13.5532	13.5532	13.5532	13.5532	2800.0
2011-08-17 05:30:00	AAPL	Stock	13.6246	13.6246	13.6246	13.6246	8400.0
2011-08-17 06:00:00	AAPL	Stock	13.5696	13.5696	13.5689	13.5689	5600.0
2011-08-17 06:30:00	AAPL	Stock	13.6143	13.6475	13.6143	13.6475	19600.0
2011-08-17 07:00:00	AAPL	Stock	13.6075	13.6607	13.6071	13.6446	106988.0
2011-08-17 07:30:00	AAPL	Stock	13.6529	13.6732	13.625	13.6439	386400.0
2011-08-17 08:00:00	AAPL	Stock	13.6411	13.6643	13.5886	13.6643	1202068.0
2011-08-17 08:30:00	AAPL	Stock	13.6636	13.6636	13.6307	13.6482	1184344.0
2011-08-17 09:00:00	AAPL	Stock	13.6461	13.6704	13.6311	13.6554	2405928.0
2011-08-17 09:30:00	AAPL	Stock	13.6554	13.7329	13.6093	13.7104	55977544.0
2011-08-17 10:00:00	AAPL	Stock	13.7064	13.7214	13.675	13.72	34540352.0
2011-08-17 10:30:00	AAPL	Stock	13.7186	13.7197	13.6575	13.6582	25108888.0
2011-08-17 11:00:00	AAPL	Stock	13.6571	13.6782	13.6289	13.6411	30034956.0
2011-08-17 11:30:00	AAPL	Stock	13.6396	13.6561	13.5257	13.5456	47896968.0
2011-08-17 12:00:00	AAPL	Stock	13.5482	13.5711	13.5	13.5654	31748500.0
2011-08-17 12:30:00	AAPL	Stock	13.5661	13.6304	13.5514	13.5843	31257716.0
2011-08-17 13:00:00	AAPL	Stock	13.5846	13.5886	13.5382	13.5475	24372712.0
2011-08-17 13:30:00	AAPL	Stock	13.5482	13.5893	13.5064	13.5143	26890164.0
2011-08-17 14:00:00	AAPL	Stock	13.5139	13.5875	13.5125	13.5518	25405324.0
2011-08-17 14:30:00	AAPL	Stock	13.5509	13.5661	13.5225	13.561	16735096.0
2011-08-17 15:00:00	AAPL	Stock	13.5618	13.5871	13.5393	13.5675	20031620.0
2011-08-17 15:30:00	AAPL	Stock	13.5668	13.6389	13.5332	13.5789	32111072.0
2011-08-17 16:00:00	AAPL	Stock	13.5864	13.6249	13.5634	13.5786	29648220.0
2011-08-17 16:30:00	AAPL	Stock	13.5779	13.7128	13.5527	13.5539	272076.0
2011-08-17 17:00:00	AAPL	Stock	13.5871	13.5871	13.5539	13.5582	1289400.0
2011-08-17 17:30:00	AAPL	Stock	13.5582	13.5696	13.5554	13.5696	71484.0
2011-08-17 18:00:00	AAPL	Stock	13.5714	13.5871	13.5571	13.5571	56140.0
2011-08-17 18:30:00	AAPL	Stock	13.5604	13.5604	13.5482	13.5536	26040.0
2011-08-17 19:00:00	AAPL	Stock	13.5482	13.591	13.5293	13.5293	1403556.0
2011-08-17 19:30:00	AAPL	Stock	13.5357	13.545	13.5325	13.545	102200.0
2011-08-17 06:30:00	MSFT	Stock	25.34	25.35	25.3	25.34	3200.0
2011-08-17 07:30:00	MSFT	Stock	25.35	25.35	25.32	25.35	4301.0
2011-08-17 08:00:00	MSFT	Stock	25.39	25.45	25.35	25.38	52992.0
2011-08-17 08:30:00	MSFT	Stock	25.36	25.36	25.25	25.3	20845.0
2011-08-17 09:00:00	MSFT	Stock	25.35	25.35	25.24	25.26	24297.0
2011-08-17 09:30:00	MSFT	Stock	25.25	25.7	25.21	25.65	6905833.0
2011-08-17 10:00:00	MSFT	Stock	25.66	25.678	25.53	25.658	3056497.0
2011-08-17 10:30:00	MSFT	Stock	25.65	25.65	25.33	25.35	3621239.0
2011-08-17 11:00:00	MSFT	Stock	25.35	25.47	25.3	25.34	2940053.0
2011-08-17 11:30:00	MSFT	Stock	25.335	25.375	25.15	25.24	4135797.0
2011-08-17 12:00:00	MSFT	Stock	25.245	25.31	25.08	25.192	3021311.0
2011-08-17 12:30:00	MSFT	Stock	25.2	25.29	25.1	25.16	2642573.0
2011-08-17 13:00:00	MSFT	Stock	25.16	25.16	25.01	25.05	2126867.0
2011-08-17 13:30:00	MSFT	Stock	25.05	25.09	24.93	25.05	3311719.0
2011-08-17 14:00:00	MSFT	Stock	25.06	25.17	25.01	25.104	2201549.0
2011-08-17 14:30:00	MSFT	Stock	25.1	25.14	25.05	25.14	2224543.0
2011-08-17 15:00:00	MSFT	Stock	25.138	25.21	25.09	25.141	2571274.0
2011-08-17 15:30:00	MSFT	Stock	25.14	25.27	25.08	25.25	7817423.0
2011-08-17 16:00:00	MSFT	Stock	25.245	25.33	25.163	25.272	2903854.0

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

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