PREVIEW / stock_30min / 2012-10-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-18.parquet
  size:    1.4 MB
  rows:    74,347
  symbols: 3,452

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-10-18 05:00:00	AAPL	Stock	23.0	23.0	23.0	23.0	2800.0
2012-10-18 05:30:00	AAPL	Stock	23.0357	23.0357	23.0357	23.0357	2800.0
2012-10-18 06:00:00	AAPL	Stock	23.0479	23.0479	23.0479	23.0479	2800.0
2012-10-18 06:30:00	AAPL	Stock	23.0518	23.0518	23.0518	23.0518	5600.0
2012-10-18 07:00:00	AAPL	Stock	23.0357	23.0357	23.0004	23.0004	47460.0
2012-10-18 07:30:00	AAPL	Stock	22.9921	22.9939	22.9321	22.9357	309120.0
2012-10-18 08:00:00	AAPL	Stock	22.9514	22.9929	22.7368	22.8243	2323552.0
2012-10-18 08:30:00	AAPL	Stock	22.8118	22.8339	22.7375	22.8161	1784076.0
2012-10-18 09:00:00	AAPL	Stock	22.8161	22.9089	22.8125	22.8546	2193184.0
2012-10-18 09:30:00	AAPL	Stock	22.8425	22.9307	22.7632	22.85	59056060.0
2012-10-18 10:00:00	AAPL	Stock	22.8518	22.8804	22.7111	22.7522	43074332.0
2012-10-18 10:30:00	AAPL	Stock	22.7529	22.8296	22.7254	22.8168	22537396.0
2012-10-18 11:00:00	AAPL	Stock	22.8179	22.8304	22.7254	22.7886	19426848.0
2012-10-18 11:30:00	AAPL	Stock	22.7886	22.8482	22.7854	22.8418	20741140.0
2012-10-18 12:00:00	AAPL	Stock	22.8446	22.8668	22.7975	22.8064	11336584.0
2012-10-18 12:30:00	AAPL	Stock	22.8104	22.8204	22.5493	22.6054	60533256.0
2012-10-18 13:00:00	AAPL	Stock	22.6025	22.7107	22.5418	22.6861	48499696.0
2012-10-18 13:30:00	AAPL	Stock	22.6979	22.6979	22.5571	22.5807	21901992.0
2012-10-18 14:00:00	AAPL	Stock	22.5804	22.6629	22.5722	22.6046	22696072.0
2012-10-18 14:30:00	AAPL	Stock	22.6039	22.6246	22.5607	22.5943	21127652.0
2012-10-18 15:00:00	AAPL	Stock	22.5893	22.6157	22.5	22.5707	49285628.0
2012-10-18 15:30:00	AAPL	Stock	22.5675	22.65	22.5507	22.5929	44694356.0
2012-10-18 16:00:00	AAPL	Stock	22.595	22.6881	22.5446	22.5539	17586856.0
2012-10-18 16:30:00	AAPL	Stock	22.5639	22.5896	22.545	22.5536	489300.0
2012-10-18 17:00:00	AAPL	Stock	22.5554	22.5943	22.5486	22.5614	298704.0
2012-10-18 17:30:00	AAPL	Stock	22.5611	22.5714	22.5554	22.5711	165116.0
2012-10-18 18:00:00	AAPL	Stock	22.5696	22.58	22.5679	22.5789	56000.0
2012-10-18 18:30:00	AAPL	Stock	22.5686	22.5714	22.5618	22.5679	74536.0
2012-10-18 19:00:00	AAPL	Stock	22.5714	22.5821	22.5696	22.5786	78120.0
2012-10-18 19:30:00	AAPL	Stock	22.5718	22.5871	22.555	22.5607	145852.0
2012-10-18 07:30:00	MSFT	Stock	29.64	29.64	29.62	29.63	2544.0
2012-10-18 08:00:00	MSFT	Stock	29.6	29.7	29.6	29.67	7716.0
2012-10-18 08:30:00	MSFT	Stock	29.65	29.65	29.57	29.57	23314.0
2012-10-18 09:00:00	MSFT	Stock	29.58	29.68	29.58	29.66	35050.0
2012-10-18 09:30:00	MSFT	Stock	29.67	29.7	29.48	29.7	3693543.0
2012-10-18 10:00:00	MSFT	Stock	29.69	29.73	29.47	29.485	3419180.0
2012-10-18 10:30:00	MSFT	Stock	29.485	29.53	29.42	29.46	2502731.0
2012-10-18 11:00:00	MSFT	Stock	29.46	29.53	29.46	29.52	1631813.0
2012-10-18 11:30:00	MSFT	Stock	29.515	29.61	29.51	29.585	2432243.0
2012-10-18 12:00:00	MSFT	Stock	29.587	29.7	29.58	29.62	2378323.0
2012-10-18 12:30:00	MSFT	Stock	29.615	29.63	29.47	29.54	4032906.0
2012-10-18 13:00:00	MSFT	Stock	29.545	29.555	29.37	29.42	2878266.0
2012-10-18 13:30:00	MSFT	Stock	29.43	29.43	29.26	29.285	2822496.0
2012-10-18 14:00:00	MSFT	Stock	29.28	29.45	29.28	29.4	2877806.0
2012-10-18 14:30:00	MSFT	Stock	29.4	29.42	29.35	29.4	2764703.0
2012-10-18 15:00:00	MSFT	Stock	29.39	29.485	29.39	29.44	4068659.0
2012-10-18 15:30:00	MSFT	Stock	29.44	29.56	29.41	29.54	8726332.0
2012-10-18 16:00:00	MSFT	Stock	29.495	29.85	28.24	28.69	8512417.0
2012-10-18 16:30:00	MSFT	Stock	28.68	29.54	28.54	28.73	1016547.0
2012-10-18 17:00:00	MSFT	Stock	28.73	29.54	28.7	28.84	651396.0

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

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