PREVIEW / stock_30min / 2011-07-06

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-06.parquet
  size:    1.4 MB
  rows:    74,786
  symbols: 3,533

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-07-06 04:00:00	AAPL	Stock	12.4129	12.4129	12.4129	12.4129	2800.0
2011-07-06 05:00:00	AAPL	Stock	12.4325	12.4325	12.4089	12.4089	8400.0
2011-07-06 06:00:00	AAPL	Stock	12.4375	12.4375	12.4375	12.4375	2800.0
2011-07-06 06:30:00	AAPL	Stock	12.4218	12.4432	12.4214	12.4432	28700.0
2011-07-06 07:00:00	AAPL	Stock	12.4639	12.4925	12.4357	12.4607	117040.0
2011-07-06 07:30:00	AAPL	Stock	12.4536	12.4536	12.4321	12.4346	76860.0
2011-07-06 08:00:00	AAPL	Stock	12.4446	12.4536	12.4321	12.4368	389396.0
2011-07-06 08:30:00	AAPL	Stock	12.4354	12.4857	12.4339	12.4768	646968.0
2011-07-06 09:00:00	AAPL	Stock	12.4786	12.4864	12.4539	12.4643	477232.0
2011-07-06 09:30:00	AAPL	Stock	12.4625	12.4875	12.41	12.4318	48778156.0
2011-07-06 10:00:00	AAPL	Stock	12.4314	12.4421	12.3825	12.4267	35315896.0
2011-07-06 10:30:00	AAPL	Stock	12.4286	12.5282	12.4279	12.5203	42332864.0
2011-07-06 11:00:00	AAPL	Stock	12.5207	12.55	12.5089	12.5306	37032436.0
2011-07-06 11:30:00	AAPL	Stock	12.5304	12.6071	12.5221	12.5991	38446016.0
2011-07-06 12:00:00	AAPL	Stock	12.5981	12.605	12.5704	12.5946	20497148.0
2011-07-06 12:30:00	AAPL	Stock	12.5931	12.6421	12.5861	12.6371	25350500.0
2011-07-06 13:00:00	AAPL	Stock	12.6376	12.6464	12.5821	12.5877	22964648.0
2011-07-06 13:30:00	AAPL	Stock	12.5882	12.625	12.5861	12.6157	20190380.0
2011-07-06 14:00:00	AAPL	Stock	12.6171	12.62	12.5286	12.553	32588080.0
2011-07-06 14:30:00	AAPL	Stock	12.5536	12.5714	12.53	12.5311	26047840.0
2011-07-06 15:00:00	AAPL	Stock	12.5318	12.58	12.4911	12.5704	40097316.0
2011-07-06 15:30:00	AAPL	Stock	12.5704	12.5747	12.5386	12.5657	38126984.0
2011-07-06 16:00:00	AAPL	Stock	12.5629	12.5679	12.5318	12.5614	6128304.0
2011-07-06 16:30:00	AAPL	Stock	12.5643	12.57	12.5623	12.5664	495656.0
2011-07-06 17:00:00	AAPL	Stock	12.5564	12.5664	12.5564	12.5643	184744.0
2011-07-06 17:30:00	AAPL	Stock	12.5629	12.5671	12.5629	12.5654	86828.0
2011-07-06 18:00:00	AAPL	Stock	12.5671	12.5679	12.5629	12.5629	131796.0
2011-07-06 18:30:00	AAPL	Stock	12.5629	12.5629	12.5607	12.5607	114492.0
2011-07-06 19:00:00	AAPL	Stock	12.5646	12.5654	12.5571	12.5571	63560.0
2011-07-06 19:30:00	AAPL	Stock	12.5582	12.5721	12.5557	12.5714	230160.0
2011-07-06 05:00:00	MSFT	Stock	25.92	26.04	25.92	26.02	300.0
2011-07-06 06:30:00	MSFT	Stock	25.93	25.93	25.92	25.92	400.0
2011-07-06 07:00:00	MSFT	Stock	25.93	25.93	25.93	25.93	305.0
2011-07-06 07:30:00	MSFT	Stock	25.99	26.0	25.93	25.97	2114.0
2011-07-06 08:00:00	MSFT	Stock	25.98	25.98	25.91	25.97	10176.0
2011-07-06 08:30:00	MSFT	Stock	25.96	26.0	25.96	26.0	3222.0
2011-07-06 09:00:00	MSFT	Stock	25.99	25.99	25.96	25.98	259084.0
2011-07-06 09:30:00	MSFT	Stock	25.96	26.29	25.96	26.2	6622491.0
2011-07-06 10:00:00	MSFT	Stock	26.2	26.27	26.04	26.099	4696255.0
2011-07-06 10:30:00	MSFT	Stock	26.1	26.24	26.07	26.215	2870174.0
2011-07-06 11:00:00	MSFT	Stock	26.215	26.24	26.15	26.2	2115005.0
2011-07-06 11:30:00	MSFT	Stock	26.2	26.28	26.2	26.27	2111912.0
2011-07-06 12:00:00	MSFT	Stock	26.265	26.28	26.23	26.24	1379127.0
2011-07-06 12:30:00	MSFT	Stock	26.24	26.37	26.24	26.36	3113375.0
2011-07-06 13:00:00	MSFT	Stock	26.358	26.36	26.23	26.27	3543215.0
2011-07-06 13:30:00	MSFT	Stock	26.274	26.3	26.18	26.24	3412257.0
2011-07-06 14:00:00	MSFT	Stock	26.245	26.25	26.16	26.245	2337983.0
2011-07-06 14:30:00	MSFT	Stock	26.247	26.3	26.16	26.255	1927952.0
2011-07-06 15:00:00	MSFT	Stock	26.25	26.34	26.23	26.25	3362795.0
2011-07-06 15:30:00	MSFT	Stock	26.255	26.36	26.21	26.35	7145327.0

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

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