PREVIEW / stock_30min / 2014-06-18

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-18.parquet
  size:    1.6 MB
  rows:    81,765
  symbols: 3,563

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-06-18 04:00:00	AAPL	Stock	23.065	23.065	23.025	23.025	5600.0
2014-06-18 04:30:00	AAPL	Stock	23.045	23.05	23.045	23.05	2800.0
2014-06-18 05:30:00	AAPL	Stock	23.055	23.065	23.055	23.065	5200.0
2014-06-18 06:00:00	AAPL	Stock	23.06	23.065	23.06	23.065	4724.0
2014-06-18 06:30:00	AAPL	Stock	23.06	23.07	23.0475	23.0575	9752.0
2014-06-18 07:00:00	AAPL	Stock	23.0575	23.1825	23.0425	23.175	212816.0
2014-06-18 07:30:00	AAPL	Stock	23.1825	23.25	23.1375	23.16	204040.0
2014-06-18 08:00:00	AAPL	Stock	23.145	23.1975	23.055	23.1075	256836.0
2014-06-18 08:30:00	AAPL	Stock	23.1175	23.1375	23.1075	23.12	175784.0
2014-06-18 09:00:00	AAPL	Stock	23.125	23.13	23.05	23.0675	531080.0
2014-06-18 09:30:00	AAPL	Stock	23.0675	23.0725	22.925	22.94	19728520.0
2014-06-18 10:00:00	AAPL	Stock	22.94	22.9725	22.8625	22.95	13528428.0
2014-06-18 10:30:00	AAPL	Stock	22.9475	22.985	22.9	22.9025	7624056.0
2014-06-18 11:00:00	AAPL	Stock	22.9038	22.9275	22.8725	22.8725	6140436.0
2014-06-18 11:30:00	AAPL	Stock	22.8738	22.91	22.85	22.9075	6095240.0
2014-06-18 12:00:00	AAPL	Stock	22.905	22.93	22.8875	22.91	3912336.0
2014-06-18 12:30:00	AAPL	Stock	22.9105	22.935	22.9	22.9188	3693756.0
2014-06-18 13:00:00	AAPL	Stock	22.9175	22.925	22.885	22.885	2712480.0
2014-06-18 13:30:00	AAPL	Stock	22.8858	22.8975	22.84	22.8625	6151544.0
2014-06-18 14:00:00	AAPL	Stock	22.8625	23.02	22.8375	22.9912	14045248.0
2014-06-18 14:30:00	AAPL	Stock	22.9918	23.0075	22.9425	22.985	9256624.0
2014-06-18 15:00:00	AAPL	Stock	22.9847	23.0025	22.9725	23.0025	7701468.0
2014-06-18 15:30:00	AAPL	Stock	23.0	23.065	22.9975	23.04	16202424.0
2014-06-18 16:00:00	AAPL	Stock	23.045	23.0775	22.9245	23.045	5984964.0
2014-06-18 16:30:00	AAPL	Stock	23.0675	23.07	22.93	23.045	82048.0
2014-06-18 17:00:00	AAPL	Stock	23.045	23.055	23.045	23.055	33216.0
2014-06-18 17:30:00	AAPL	Stock	23.0475	23.055	23.045	23.0475	663132.0
2014-06-18 18:00:00	AAPL	Stock	23.0475	23.055	23.04	23.04	42536.0
2014-06-18 18:30:00	AAPL	Stock	23.04	23.0525	23.04	23.0525	4972.0
2014-06-18 19:00:00	AAPL	Stock	23.045	23.055	23.045	23.0525	22320.0
2014-06-18 19:30:00	AAPL	Stock	23.045	23.055	23.04	23.05	48616.0
2014-06-18 05:30:00	MSFT	Stock	41.71	41.71	41.71	41.71	200.0
2014-06-18 06:00:00	MSFT	Stock	41.94	41.94	41.93	41.93	450.0
2014-06-18 08:00:00	MSFT	Stock	41.79	41.79	41.71	41.71	1259.0
2014-06-18 08:30:00	MSFT	Stock	41.74	41.74	41.59	41.63	1848.0
2014-06-18 09:00:00	MSFT	Stock	41.63	41.71	41.53	41.59	16683.0
2014-06-18 09:30:00	MSFT	Stock	41.605	41.7	41.28	41.31	2574827.0
2014-06-18 10:00:00	MSFT	Stock	41.3	41.38	41.23	41.325	1940007.0
2014-06-18 10:30:00	MSFT	Stock	41.326	41.35	41.215	41.215	1013528.0
2014-06-18 11:00:00	MSFT	Stock	41.21	41.31	41.2	41.27	1168877.0
2014-06-18 11:30:00	MSFT	Stock	41.26	41.31	41.26	41.268	870850.0
2014-06-18 12:00:00	MSFT	Stock	41.27	41.28	41.18	41.2	3728832.0
2014-06-18 12:30:00	MSFT	Stock	41.191	41.35	41.19	41.34	2558164.0
2014-06-18 13:00:00	MSFT	Stock	41.33	41.41	41.32	41.36	680029.0
2014-06-18 13:30:00	MSFT	Stock	41.36	41.365	41.21	41.245	863077.0
2014-06-18 14:00:00	MSFT	Stock	41.24	41.45	41.18	41.415	1794843.0
2014-06-18 14:30:00	MSFT	Stock	41.43	41.51	41.39	41.495	1471893.0
2014-06-18 15:00:00	MSFT	Stock	41.5	41.67	41.49	41.64	1597442.0
2014-06-18 15:30:00	MSFT	Stock	41.65	41.74	41.62	41.65	3715443.0
2014-06-18 16:00:00	MSFT	Stock	41.65	41.66	41.204	41.65	2094202.0

> showing 50 of 81,765 rows — these rows as CSV

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