PREVIEW / stock_30min / 2014-01-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-15.parquet
  size:    1.6 MB
  rows:    82,370
  symbols: 3,518

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-01-15 04:00:00	AAPL	Stock	19.5507	19.8143	19.5507	19.7875	90048.0
2014-01-15 04:30:00	AAPL	Stock	19.8096	19.8114	19.7818	19.7854	62132.0
2014-01-15 05:00:00	AAPL	Stock	19.7836	19.7836	19.7732	19.7732	28672.0
2014-01-15 05:30:00	AAPL	Stock	19.7657	19.7657	19.7504	19.7654	42560.0
2014-01-15 06:00:00	AAPL	Stock	19.7836	19.7839	19.7143	19.7321	141456.0
2014-01-15 06:30:00	AAPL	Stock	19.7411	19.7429	19.7143	19.7375	99316.0
2014-01-15 07:00:00	AAPL	Stock	19.7411	19.8071	19.7314	19.8071	669704.0
2014-01-15 07:30:00	AAPL	Stock	19.7961	19.8839	19.7918	19.8218	1376928.0
2014-01-15 08:00:00	AAPL	Stock	19.8214	19.875	19.7393	19.8171	2371208.0
2014-01-15 08:30:00	AAPL	Stock	19.8071	19.8157	19.7682	19.7861	1309140.0
2014-01-15 09:00:00	AAPL	Stock	19.7861	19.8	19.7575	19.7664	2537556.0
2014-01-15 09:30:00	AAPL	Stock	19.7686	19.9286	19.7021	19.9279	79988720.0
2014-01-15 10:00:00	AAPL	Stock	19.9279	19.9996	19.875	19.9432	42723884.0
2014-01-15 10:30:00	AAPL	Stock	19.9429	19.9643	19.8846	19.9286	18119836.0
2014-01-15 11:00:00	AAPL	Stock	19.9257	19.9711	19.8964	19.9261	17508204.0
2014-01-15 11:30:00	AAPL	Stock	19.9257	19.9643	19.9229	19.9357	12143152.0
2014-01-15 12:00:00	AAPL	Stock	19.9389	20.0068	19.9146	19.9852	23071020.0
2014-01-15 12:30:00	AAPL	Stock	19.9854	19.9954	19.9571	19.9707	9342984.0
2014-01-15 13:00:00	AAPL	Stock	19.9718	20.0018	19.9375	19.9432	12678792.0
2014-01-15 13:30:00	AAPL	Stock	19.9429	19.9646	19.8814	19.9127	14423612.0
2014-01-15 14:00:00	AAPL	Stock	19.9107	19.9496	19.9064	19.9361	9678704.0
2014-01-15 14:30:00	AAPL	Stock	19.9361	19.9692	19.9064	19.9518	9931152.0
2014-01-15 15:00:00	AAPL	Stock	19.9496	19.9732	19.8904	19.92	12478144.0
2014-01-15 15:30:00	AAPL	Stock	19.9207	19.9264	19.8489	19.9057	32242728.0
2014-01-15 16:00:00	AAPL	Stock	19.9057	19.9636	19.7579	19.9004	16139172.0
2014-01-15 16:30:00	AAPL	Stock	19.9	19.9061	19.8929	19.9054	2914856.0
2014-01-15 17:00:00	AAPL	Stock	19.9057	19.9104	19.9004	19.9104	222768.0
2014-01-15 17:30:00	AAPL	Stock	19.9089	19.9643	19.9022	19.9643	394884.0
2014-01-15 18:00:00	AAPL	Stock	19.9643	19.9736	19.9286	19.9607	292068.0
2014-01-15 18:30:00	AAPL	Stock	19.9621	19.9643	19.9061	19.959	487172.0
2014-01-15 19:00:00	AAPL	Stock	19.9632	19.9679	19.9554	19.9679	419552.0
2014-01-15 19:30:00	AAPL	Stock	19.9732	19.9732	19.9643	19.9707	326956.0
2014-01-15 04:00:00	MSFT	Stock	35.75	35.75	35.75	35.75	100.0
2014-01-15 04:30:00	MSFT	Stock	35.86	35.86	35.86	35.86	500.0
2014-01-15 05:00:00	MSFT	Stock	35.9	35.9	35.9	35.9	300.0
2014-01-15 07:00:00	MSFT	Stock	35.89	35.89	35.88	35.89	2102.0
2014-01-15 07:30:00	MSFT	Stock	35.89	35.95	35.89	35.92	7866.0
2014-01-15 08:00:00	MSFT	Stock	35.92	35.97	35.89	35.95	15146.0
2014-01-15 08:30:00	MSFT	Stock	35.97	35.97	35.95	35.95	6973.0
2014-01-15 09:00:00	MSFT	Stock	35.93	35.97	35.89	35.92	16415.0
2014-01-15 09:30:00	MSFT	Stock	35.9	36.32	35.85	36.24	5185205.0
2014-01-15 10:00:00	MSFT	Stock	36.25	36.5	36.2	36.485	3654742.0
2014-01-15 10:30:00	MSFT	Stock	36.485	36.55	36.39	36.55	2563274.0
2014-01-15 11:00:00	MSFT	Stock	36.55	36.67	36.535	36.62	3441876.0
2014-01-15 11:30:00	MSFT	Stock	36.62	36.65	36.58	36.65	1875789.0
2014-01-15 12:00:00	MSFT	Stock	36.647	36.69	36.63	36.67	1520747.0
2014-01-15 12:30:00	MSFT	Stock	36.67	36.7	36.59	36.61	1465629.0
2014-01-15 13:00:00	MSFT	Stock	36.6	36.69	36.6	36.675	1103431.0
2014-01-15 13:30:00	MSFT	Stock	36.67	36.73	36.66	36.7	1791291.0
2014-01-15 14:00:00	MSFT	Stock	36.7	36.745	36.66	36.685	2588928.0

> showing 50 of 82,370 rows — these rows as CSV

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