PREVIEW / stock_30min / 2012-11-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-23.parquet
  size:    900 KB
  rows:    44,768
  symbols: 3,325

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-23 04:00:00	AAPL	Stock	20.125	20.125	20.125	20.125	16800.0
2012-11-23 04:30:00	AAPL	Stock	20.1429	20.1429	20.1429	20.1429	5600.0
2012-11-23 06:00:00	AAPL	Stock	20.1625	20.1786	20.1429	20.1786	70000.0
2012-11-23 06:30:00	AAPL	Stock	20.1793	20.2479	20.1793	20.2479	33180.0
2012-11-23 07:00:00	AAPL	Stock	20.1875	20.1929	20.1239	20.1607	203420.0
2012-11-23 07:30:00	AAPL	Stock	20.1607	20.1707	20.1446	20.1489	84476.0
2012-11-23 08:00:00	AAPL	Stock	20.16	20.1839	20.1493	20.1779	835940.0
2012-11-23 08:30:00	AAPL	Stock	20.1786	20.21	20.1782	20.1893	816956.0
2012-11-23 09:00:00	AAPL	Stock	20.1807	20.2743	20.1489	20.2593	2582384.0
2012-11-23 09:30:00	AAPL	Stock	20.2561	20.2696	20.1043	20.1089	53605888.0
2012-11-23 10:00:00	AAPL	Stock	20.1086	20.1754	20.0929	20.1504	29118516.0
2012-11-23 10:30:00	AAPL	Stock	20.1507	20.219	20.1386	20.2161	23155748.0
2012-11-23 11:00:00	AAPL	Stock	20.2129	20.275	20.2046	20.2582	28687428.0
2012-11-23 11:30:00	AAPL	Stock	20.2607	20.3125	20.2571	20.2879	28750652.0
2012-11-23 12:00:00	AAPL	Stock	20.2879	20.2929	20.1938	20.2554	26743248.0
2012-11-23 12:30:00	AAPL	Stock	20.255	20.4286	20.245	20.4093	58545340.0
2012-11-23 13:00:00	AAPL	Stock	20.4196	20.4286	20.2446	20.4271	13396096.0
2012-11-23 13:30:00	AAPL	Stock	20.4218	20.4286	20.2011	20.4093	1934604.0
2012-11-23 14:00:00	AAPL	Stock	20.3993	20.4232	20.3993	20.4196	251832.0
2012-11-23 14:30:00	AAPL	Stock	20.4196	20.4225	20.415	20.4196	98000.0
2012-11-23 15:00:00	AAPL	Stock	20.4211	20.4211	20.4161	20.4161	49084.0
2012-11-23 15:30:00	AAPL	Stock	20.4179	20.4268	20.4161	20.4268	179760.0
2012-11-23 16:00:00	AAPL	Stock	20.4218	20.4286	20.4214	20.4268	113288.0
2012-11-23 16:30:00	AAPL	Stock	20.4257	20.4286	20.4254	20.4279	75208.0
2012-11-23 04:30:00	MSFT	Stock	27.1	27.1	27.1	27.1	1150.0
2012-11-23 06:30:00	MSFT	Stock	27.15	27.15	27.15	27.15	200.0
2012-11-23 07:00:00	MSFT	Stock	27.12	27.12	27.1	27.1	3924.0
2012-11-23 07:30:00	MSFT	Stock	27.07	27.13	27.07	27.1	6401.0
2012-11-23 08:00:00	MSFT	Stock	27.09	27.1	26.95	26.98	27076.0
2012-11-23 08:30:00	MSFT	Stock	27.08	27.11	27.0	27.06	14960.0
2012-11-23 09:00:00	MSFT	Stock	27.06	27.27	26.95	27.25	150200.0
2012-11-23 09:30:00	MSFT	Stock	27.22	27.43	27.2	27.39	6302785.0
2012-11-23 10:00:00	MSFT	Stock	27.4	27.67	27.39	27.618	6353597.0
2012-11-23 10:30:00	MSFT	Stock	27.61	27.66	27.56	27.585	4202036.0
2012-11-23 11:00:00	MSFT	Stock	27.585	27.62	27.56	27.6	2306733.0
2012-11-23 11:30:00	MSFT	Stock	27.6	27.66	27.595	27.63	1786213.0
2012-11-23 12:00:00	MSFT	Stock	27.63	27.64	27.52	27.555	2282123.0
2012-11-23 12:30:00	MSFT	Stock	27.56	27.77	27.55	27.7	5728553.0
2012-11-23 13:00:00	MSFT	Stock	27.7	27.706	27.54	27.7	1805750.0
2012-11-23 13:30:00	MSFT	Stock	27.593	27.7	26.95	27.64	1431769.0
2012-11-23 14:00:00	MSFT	Stock	27.64	27.65	27.58	27.62	6835.0
2012-11-23 14:30:00	MSFT	Stock	27.63	27.65	27.61	27.61	2600.0
2012-11-23 15:00:00	MSFT	Stock	27.64	27.65	27.62	27.62	1533.0
2012-11-23 15:30:00	MSFT	Stock	27.63	27.63	27.63	27.63	3323.0
2012-11-23 16:00:00	MSFT	Stock	27.65	27.65	27.65	27.65	150.0
2012-11-23 16:30:00	MSFT	Stock	27.62	27.62	27.62	27.62	700.0
2012-11-23 09:00:00	NVDA	Stock	0.2965	0.2965	0.2965	0.2965	40000.0
2012-11-23 09:30:00	NVDA	Stock	0.2968	0.299	0.2962	0.297	52055600.0
2012-11-23 10:00:00	NVDA	Stock	0.297	0.298	0.2951	0.298	38473280.0
2012-11-23 10:30:00	NVDA	Stock	0.2978	0.3	0.2978	0.2994	34466160.0

> showing 50 of 44,768 rows — these rows as CSV

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