PREVIEW / stock_30min / 2014-05-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-16.parquet
  size:    1.6 MB
  rows:    81,260
  symbols: 3,534

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-05-16 05:00:00	AAPL	Stock	21.0375	21.0375	21.0375	21.0375	2800.0
2014-05-16 05:30:00	AAPL	Stock	21.0386	21.04	21.0314	21.0318	14000.0
2014-05-16 06:00:00	AAPL	Stock	21.0264	21.0264	21.0264	21.0264	2800.0
2014-05-16 07:00:00	AAPL	Stock	21.0225	21.0225	21.0225	21.0225	2800.0
2014-05-16 07:30:00	AAPL	Stock	21.0018	21.0229	21.0	21.0114	50680.0
2014-05-16 08:00:00	AAPL	Stock	21.0161	21.0243	20.9839	20.9957	114604.0
2014-05-16 08:30:00	AAPL	Stock	20.9957	21.0607	20.9957	21.0564	271180.0
2014-05-16 09:00:00	AAPL	Stock	21.0536	21.0886	21.0246	21.0268	540344.0
2014-05-16 09:30:00	AAPL	Stock	21.0264	21.075	20.9364	20.9721	41077792.0
2014-05-16 10:00:00	AAPL	Stock	20.9768	20.9839	20.9071	20.925	18011784.0
2014-05-16 10:30:00	AAPL	Stock	20.9286	20.9721	20.9146	20.9532	8996148.0
2014-05-16 11:00:00	AAPL	Stock	20.955	20.9918	20.9396	20.97	6619676.0
2014-05-16 11:30:00	AAPL	Stock	20.9714	20.9868	20.9557	20.9801	7543200.0
2014-05-16 12:00:00	AAPL	Stock	20.9818	21.0725	20.9814	21.0585	12041736.0
2014-05-16 12:30:00	AAPL	Stock	21.0621	21.0689	21.0275	21.0461	6269172.0
2014-05-16 13:00:00	AAPL	Stock	21.0475	21.0893	21.0182	21.0825	7655620.0
2014-05-16 13:30:00	AAPL	Stock	21.0821	21.1179	21.0809	21.1036	9661932.0
2014-05-16 14:00:00	AAPL	Stock	21.1054	21.1354	21.0832	21.1282	8038912.0
2014-05-16 14:30:00	AAPL	Stock	21.1282	21.2329	21.1232	21.2314	18000416.0
2014-05-16 15:00:00	AAPL	Stock	21.2296	21.3043	21.2296	21.2632	27331584.0
2014-05-16 15:30:00	AAPL	Stock	21.2635	21.3404	21.2554	21.338	35652652.0
2014-05-16 16:00:00	AAPL	Stock	21.3396	21.3571	20.9555	21.3386	10695132.0
2014-05-16 16:30:00	AAPL	Stock	21.3389	21.3418	21.3379	21.3414	950124.0
2014-05-16 17:00:00	AAPL	Stock	21.3411	21.3432	21.3389	21.3407	427784.0
2014-05-16 17:30:00	AAPL	Stock	21.3396	21.3429	21.3375	21.34	36792.0
2014-05-16 18:00:00	AAPL	Stock	21.3396	21.3446	21.3396	21.3446	238280.0
2014-05-16 18:30:00	AAPL	Stock	21.3489	21.3493	21.3489	21.3493	9800.0
2014-05-16 19:00:00	AAPL	Stock	21.3496	21.3529	21.3496	21.35	11564.0
2014-05-16 19:30:00	AAPL	Stock	21.3454	21.3521	21.3432	21.3457	48748.0
2014-05-16 08:00:00	MSFT	Stock	39.78	39.78	39.7	39.7	2100.0
2014-05-16 08:30:00	MSFT	Stock	39.63	39.65	39.63	39.65	5125.0
2014-05-16 09:00:00	MSFT	Stock	39.65	39.72	39.65	39.71	8805.0
2014-05-16 09:30:00	MSFT	Stock	39.67	39.74	39.44	39.64	6989928.0
2014-05-16 10:00:00	MSFT	Stock	39.63	39.69	39.33	39.355	2784210.0
2014-05-16 10:30:00	MSFT	Stock	39.355	39.54	39.33	39.512	2190239.0
2014-05-16 11:00:00	MSFT	Stock	39.51	39.58	39.5	39.534	978334.0
2014-05-16 11:30:00	MSFT	Stock	39.54	39.59	39.42	39.45	881658.0
2014-05-16 12:00:00	MSFT	Stock	39.45	39.555	39.43	39.49	1023755.0
2014-05-16 12:30:00	MSFT	Stock	39.5	39.5	39.38	39.385	952511.0
2014-05-16 13:00:00	MSFT	Stock	39.385	39.47	39.27	39.395	1188291.0
2014-05-16 13:30:00	MSFT	Stock	39.39	39.48	39.38	39.4	714563.0
2014-05-16 14:00:00	MSFT	Stock	39.4	39.48	39.355	39.45	1084354.0
2014-05-16 14:30:00	MSFT	Stock	39.45	39.627	39.44	39.62	1463761.0
2014-05-16 15:00:00	MSFT	Stock	39.61	39.79	39.585	39.735	2156704.0
2014-05-16 15:30:00	MSFT	Stock	39.734	39.84	39.73	39.82	3036856.0
2014-05-16 16:00:00	MSFT	Stock	39.83	39.84	39.569	39.77	2956032.0
2014-05-16 16:30:00	MSFT	Stock	39.81	39.83	39.606	39.83	99373.0
2014-05-16 17:00:00	MSFT	Stock	39.85	39.85	39.81	39.81	1100.0
2014-05-16 18:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	100.0
2014-05-16 19:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	118.0

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

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