PREVIEW / stock_30min / 2012-11-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-14.parquet
  size:    1.5 MB
  rows:    77,919
  symbols: 3,478

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-11-14 04:00:00	AAPL	Stock	19.5	19.55	19.5	19.55	10360.0
2012-11-14 05:00:00	AAPL	Stock	19.5696	19.5696	19.5411	19.5411	15400.0
2012-11-14 05:30:00	AAPL	Stock	19.5268	19.5357	19.5	19.5	93520.0
2012-11-14 06:00:00	AAPL	Stock	19.5	19.5004	19.5	19.5004	5600.0
2012-11-14 07:00:00	AAPL	Stock	19.4946	19.4954	19.4554	19.4554	173600.0
2012-11-14 07:30:00	AAPL	Stock	19.4539	19.4643	19.4332	19.4379	215096.0
2012-11-14 08:00:00	AAPL	Stock	19.4514	19.4875	19.4357	19.465	608664.0
2012-11-14 08:30:00	AAPL	Stock	19.4689	19.49	19.4514	19.4857	850724.0
2012-11-14 09:00:00	AAPL	Stock	19.4871	19.4961	19.4643	19.4643	1120616.0
2012-11-14 09:30:00	AAPL	Stock	19.4796	19.5518	19.3757	19.4204	61593168.0
2012-11-14 10:00:00	AAPL	Stock	19.415	19.4729	19.345	19.3464	37260440.0
2012-11-14 10:30:00	AAPL	Stock	19.3482	19.4286	19.2643	19.3286	39840304.0
2012-11-14 11:00:00	AAPL	Stock	19.3221	19.4237	19.3171	19.4171	29400616.0
2012-11-14 11:30:00	AAPL	Stock	19.4182	19.4943	19.3643	19.4723	29603308.0
2012-11-14 12:00:00	AAPL	Stock	19.475	19.4836	19.3464	19.425	19452552.0
2012-11-14 12:30:00	AAPL	Stock	19.4246	19.4282	19.3407	19.3493	13784036.0
2012-11-14 13:00:00	AAPL	Stock	19.3532	19.4225	19.3396	19.3936	18658584.0
2012-11-14 13:30:00	AAPL	Stock	19.4036	19.4464	19.3714	19.4036	17559360.0
2012-11-14 14:00:00	AAPL	Stock	19.4052	19.4561	19.335	19.3704	30334668.0
2012-11-14 14:30:00	AAPL	Stock	19.3696	19.3865	19.2836	19.3036	26952856.0
2012-11-14 15:00:00	AAPL	Stock	19.3046	19.3179	19.1786	19.2314	47445104.0
2012-11-14 15:30:00	AAPL	Stock	19.2341	19.2389	19.1493	19.1836	64101660.0
2012-11-14 16:00:00	AAPL	Stock	19.1761	19.3501	19.1314	19.1429	18297076.0
2012-11-14 16:30:00	AAPL	Stock	19.1496	19.2333	19.1496	19.1821	735840.0
2012-11-14 17:00:00	AAPL	Stock	19.1839	19.1839	19.1529	19.1564	224280.0
2012-11-14 17:30:00	AAPL	Stock	19.1511	19.1511	19.1307	19.1396	414708.0
2012-11-14 18:00:00	AAPL	Stock	19.1432	19.1696	19.1414	19.1536	188580.0
2012-11-14 18:30:00	AAPL	Stock	19.1568	19.1704	19.1536	19.1586	114352.0
2012-11-14 19:00:00	AAPL	Stock	19.1571	19.1571	19.1429	19.1457	127428.0
2012-11-14 19:30:00	AAPL	Stock	19.1464	19.1518	19.1414	19.1429	218596.0
2012-11-14 04:30:00	MSFT	Stock	27.45	27.45	27.45	27.45	100.0
2012-11-14 06:30:00	MSFT	Stock	27.3	27.3	27.3	27.3	500.0
2012-11-14 07:00:00	MSFT	Stock	27.3	27.3	27.29	27.29	1100.0
2012-11-14 07:30:00	MSFT	Stock	27.27	27.27	27.18	27.2	14050.0
2012-11-14 08:00:00	MSFT	Stock	27.19	27.2	27.1	27.2	19283.0
2012-11-14 08:30:00	MSFT	Stock	27.15	27.2	27.12	27.16	37140.0
2012-11-14 09:00:00	MSFT	Stock	27.16	27.29	27.15	27.22	47779.0
2012-11-14 09:30:00	MSFT	Stock	27.22	27.29	27.1	27.18	6043989.0
2012-11-14 10:00:00	MSFT	Stock	27.18	27.27	27.12	27.12	3850895.0
2012-11-14 10:30:00	MSFT	Stock	27.13	27.16	27.06	27.084	6537101.0
2012-11-14 11:00:00	MSFT	Stock	27.08	27.15	27.06	27.13	4166264.0
2012-11-14 11:30:00	MSFT	Stock	27.14	27.14	27.085	27.12	3302385.0
2012-11-14 12:00:00	MSFT	Stock	27.112	27.12	27.04	27.072	3714487.0
2012-11-14 12:30:00	MSFT	Stock	27.08	27.08	27.0	27.025	4267689.0
2012-11-14 13:00:00	MSFT	Stock	27.02	27.07	27.01	27.02	2224153.0
2012-11-14 13:30:00	MSFT	Stock	27.02	27.055	26.985	27.02	6249373.0
2012-11-14 14:00:00	MSFT	Stock	27.02	27.06	26.97	27.01	4829842.0
2012-11-14 14:30:00	MSFT	Stock	27.01	27.03	26.98	27.002	5070607.0
2012-11-14 15:00:00	MSFT	Stock	27.0	27.01	26.95	26.987	6582778.0
2012-11-14 15:30:00	MSFT	Stock	26.98	27.0	26.8	26.83	11529165.0

> showing 50 of 77,919 rows — these rows as CSV

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