PREVIEW / stock_30min / 2012-06-13

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-13.parquet
  size:    1.4 MB
  rows:    75,388
  symbols: 3,491

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-06-13 05:00:00	AAPL	Stock	20.5775	20.5775	20.5775	20.5775	5600.0
2012-06-13 05:30:00	AAPL	Stock	20.5454	20.5454	20.5454	20.5454	11200.0
2012-06-13 07:00:00	AAPL	Stock	20.5893	20.5893	20.5393	20.54	35000.0
2012-06-13 07:30:00	AAPL	Stock	20.5357	20.5821	20.5357	20.5714	56000.0
2012-06-13 08:00:00	AAPL	Stock	20.5714	20.5746	20.4821	20.5161	912772.0
2012-06-13 08:30:00	AAPL	Stock	20.5004	20.5296	20.4821	20.5079	757624.0
2012-06-13 09:00:00	AAPL	Stock	20.5146	20.5282	20.4896	20.5282	670768.0
2012-06-13 09:30:00	AAPL	Stock	20.5271	20.6543	20.4736	20.5364	52468976.0
2012-06-13 10:00:00	AAPL	Stock	20.5364	20.6161	20.5314	20.5657	25272688.0
2012-06-13 10:30:00	AAPL	Stock	20.5657	20.66	20.56	20.65	25567388.0
2012-06-13 11:00:00	AAPL	Stock	20.6489	20.6525	20.5875	20.6318	14336392.0
2012-06-13 11:30:00	AAPL	Stock	20.6284	20.6529	20.5775	20.5932	13097616.0
2012-06-13 12:00:00	AAPL	Stock	20.5893	20.5957	20.5357	20.5486	14355208.0
2012-06-13 12:30:00	AAPL	Stock	20.5486	20.6246	20.5486	20.5911	12208448.0
2012-06-13 13:00:00	AAPL	Stock	20.5902	20.6125	20.5721	20.6029	6839504.0
2012-06-13 13:30:00	AAPL	Stock	20.6004	20.6125	20.5132	20.5357	12516756.0
2012-06-13 14:00:00	AAPL	Stock	20.5296	20.5554	20.5179	20.535	10102512.0
2012-06-13 14:30:00	AAPL	Stock	20.5361	20.5393	20.415	20.4429	22724744.0
2012-06-13 15:00:00	AAPL	Stock	20.4432	20.4582	20.3707	20.3879	25206524.0
2012-06-13 15:30:00	AAPL	Stock	20.3896	20.4443	20.3718	20.4339	34426728.0
2012-06-13 16:00:00	AAPL	Stock	20.4339	20.5369	20.4032	20.4357	17639132.0
2012-06-13 16:30:00	AAPL	Stock	20.4343	20.4386	20.4004	20.4143	1984444.0
2012-06-13 17:00:00	AAPL	Stock	20.4143	20.4286	20.4143	20.4157	61404.0
2012-06-13 17:30:00	AAPL	Stock	20.4171	20.4286	20.4171	20.425	18088.0
2012-06-13 18:00:00	AAPL	Stock	20.4232	20.4371	20.4214	20.4346	75264.0
2012-06-13 18:30:00	AAPL	Stock	20.4364	20.4464	20.4264	20.4264	71960.0
2012-06-13 19:00:00	AAPL	Stock	20.4239	20.4361	20.4236	20.4357	53088.0
2012-06-13 19:30:00	AAPL	Stock	20.4286	20.4286	20.4268	20.4271	34580.0
2012-06-13 08:00:00	MSFT	Stock	29.34	29.34	29.26	29.26	7300.0
2012-06-13 08:30:00	MSFT	Stock	29.25	29.3	29.16	29.21	5723.0
2012-06-13 09:00:00	MSFT	Stock	29.24	29.24	29.18	29.2	3648.0
2012-06-13 09:30:00	MSFT	Stock	29.24	29.32	29.15	29.19	3000903.0
2012-06-13 10:00:00	MSFT	Stock	29.18	29.35	29.18	29.35	2184997.0
2012-06-13 10:30:00	MSFT	Stock	29.35	29.44	29.33	29.428	3019190.0
2012-06-13 11:00:00	MSFT	Stock	29.42	29.425	29.3	29.3	2684437.0
2012-06-13 11:30:00	MSFT	Stock	29.31	29.36	29.29	29.33	2871230.0
2012-06-13 12:00:00	MSFT	Stock	29.34	29.35	29.24	29.31	1480983.0
2012-06-13 12:30:00	MSFT	Stock	29.3	29.44	29.29	29.379	1560081.0
2012-06-13 13:00:00	MSFT	Stock	29.38	29.41	29.34	29.41	1046658.0
2012-06-13 13:30:00	MSFT	Stock	29.4	29.42	29.34	29.36	1493045.0
2012-06-13 14:00:00	MSFT	Stock	29.36	29.375	29.27	29.295	1156230.0
2012-06-13 14:30:00	MSFT	Stock	29.298	29.31	29.22	29.225	2595877.0
2012-06-13 15:00:00	MSFT	Stock	29.23	29.24	29.08	29.08	2456833.0
2012-06-13 15:30:00	MSFT	Stock	29.085	29.17	29.05	29.12	5372218.0
2012-06-13 16:00:00	MSFT	Stock	29.13	29.272	29.06	29.13	1333259.0
2012-06-13 16:30:00	MSFT	Stock	29.13	29.14	29.076	29.076	404280.0
2012-06-13 17:00:00	MSFT	Stock	29.13	29.13	29.13	29.13	1000.0
2012-06-13 18:00:00	MSFT	Stock	29.13	29.18	29.13	29.18	1530.0
2012-06-13 08:30:00	NVDA	Stock	0.3118	0.312	0.3118	0.3118	187720.0
2012-06-13 09:00:00	NVDA	Stock	0.312	0.3128	0.312	0.312	323800.0

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

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