PREVIEW / stock_30min / 2014-07-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-03.parquet
  size:    1.1 MB
  rows:    51,323
  symbols: 3,537

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
2014-07-03 04:30:00	AAPL	Stock	23.4075	23.4075	23.4075	23.4075	400.0
2014-07-03 05:00:00	AAPL	Stock	23.4	23.4	23.3775	23.3775	4800.0
2014-07-03 05:30:00	AAPL	Stock	23.3925	23.4	23.3925	23.4	6800.0
2014-07-03 06:00:00	AAPL	Stock	23.4075	23.445	23.4075	23.42	12240.0
2014-07-03 06:30:00	AAPL	Stock	23.4325	23.4325	23.42	23.42	13592.0
2014-07-03 07:00:00	AAPL	Stock	23.42	23.45	23.38	23.38	95344.0
2014-07-03 07:30:00	AAPL	Stock	23.42	23.42	23.395	23.395	16100.0
2014-07-03 08:00:00	AAPL	Stock	23.415	23.4375	23.3725	23.375	268732.0
2014-07-03 08:30:00	AAPL	Stock	23.3925	23.4375	23.3625	23.4325	538464.0
2014-07-03 09:00:00	AAPL	Stock	23.435	23.435	23.405	23.42	216596.0
2014-07-03 09:30:00	AAPL	Stock	23.4125	23.425	23.305	23.3875	15812460.0
2014-07-03 10:00:00	AAPL	Stock	23.3898	23.395	23.3	23.35	8528332.0
2014-07-03 10:30:00	AAPL	Stock	23.3485	23.3975	23.345	23.3775	7166148.0
2014-07-03 11:00:00	AAPL	Stock	23.38	23.43	23.38	23.415	7137976.0
2014-07-03 11:30:00	AAPL	Stock	23.4175	23.4475	23.405	23.4168	7234320.0
2014-07-03 12:00:00	AAPL	Stock	23.42	23.4325	23.4062	23.409	6290104.0
2014-07-03 12:30:00	AAPL	Stock	23.4088	23.5225	23.4075	23.5225	21849544.0
2014-07-03 13:00:00	AAPL	Stock	23.5225	23.525	23.4148	23.505	8737212.0
2014-07-03 13:30:00	AAPL	Stock	23.5075	23.525	23.4348	23.5	540372.0
2014-07-03 14:00:00	AAPL	Stock	23.495	23.5075	23.495	23.505	77196.0
2014-07-03 14:30:00	AAPL	Stock	23.505	23.51	23.5025	23.5075	64256.0
2014-07-03 15:00:00	AAPL	Stock	23.5075	23.51	23.5025	23.5075	50564.0
2014-07-03 15:30:00	AAPL	Stock	23.5075	23.515	23.505	23.5075	83004.0
2014-07-03 16:00:00	AAPL	Stock	23.505	23.51	23.5025	23.51	17864.0
2014-07-03 16:30:00	AAPL	Stock	23.51	23.5125	23.505	23.5125	19828.0
2014-07-03 08:00:00	MSFT	Stock	41.8	41.8	41.8	41.8	125.0
2014-07-03 08:30:00	MSFT	Stock	41.93	41.93	41.93	41.93	400.0
2014-07-03 09:00:00	MSFT	Stock	41.95	42.0	41.93	41.95	8481.0
2014-07-03 09:30:00	MSFT	Stock	41.91	41.99	41.56	41.62	3280145.0
2014-07-03 10:00:00	MSFT	Stock	41.61	41.87	41.61	41.695	1789734.0
2014-07-03 10:30:00	MSFT	Stock	41.695	41.75	41.69	41.705	879478.0
2014-07-03 11:00:00	MSFT	Stock	41.705	41.76	41.66	41.74	1554034.0
2014-07-03 11:30:00	MSFT	Stock	41.74	41.79	41.73	41.78	647532.0
2014-07-03 12:00:00	MSFT	Stock	41.775	41.84	41.77	41.82	738830.0
2014-07-03 12:30:00	MSFT	Stock	41.82	41.83	41.69	41.8	3483693.0
2014-07-03 13:00:00	MSFT	Stock	41.79	41.8	41.758	41.8	2404107.0
2014-07-03 13:30:00	MSFT	Stock	41.78	41.8	41.758	41.8	67208.0
2014-07-03 14:30:00	MSFT	Stock	41.65	41.65	41.65	41.65	168.0
2014-07-03 15:00:00	MSFT	Stock	41.78	41.8	41.78	41.8	8164.0
2014-07-03 15:30:00	MSFT	Stock	41.78	41.78	41.78	41.78	239.0
2014-07-03 17:00:00	MSFT	Stock	41.805	41.805	41.805	41.805	2634.0
2014-07-03 07:00:00	NVDA	Stock	0.4662	0.4662	0.4662	0.4662	8000.0
2014-07-03 08:00:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	4000.0
2014-07-03 08:30:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	36000.0
2014-07-03 09:30:00	NVDA	Stock	0.4628	0.4723	0.4628	0.4708	31737840.0
2014-07-03 10:00:00	NVDA	Stock	0.4708	0.4723	0.4705	0.4713	11918720.0
2014-07-03 10:30:00	NVDA	Stock	0.4713	0.4718	0.4702	0.471	9962760.0
2014-07-03 11:00:00	NVDA	Stock	0.471	0.4715	0.4702	0.4713	10813640.0
2014-07-03 11:30:00	NVDA	Stock	0.471	0.4713	0.4699	0.4709	11593920.0
2014-07-03 12:00:00	NVDA	Stock	0.4708	0.4725	0.4708	0.4715	9217360.0

> showing 50 of 51,323 rows — these rows as CSV

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